Weighbridge (Trek Scale)

Overview

BOS Enterprise can connect directly to the Trekscale database to extract weighbridge data at scheduled intervals. (See Trek Scale contact details below)

BOS Server is used to manage the integration using the Data Exchange Service. The Trekscale application runs on a MSSQL 2014 database and data is imported to the BOS Firebird database.

TREK SCALE COMPANY (PTY) LTD.

12 Bessemer Road, Heriotdale, Johannesburg, 2094

P.O. Box 40565, Cleveland 2022

Tel: 011 626 3490/8

Fax: 011 626 2029

Website: www.trekscale.com

Email: software@trekscale.com

BOS Server - Setting up

BOS Server uses the Data Exchange service to select data from the Trekscale database and update it to the BOS Enterprise database.

DAT_WEIGHBRIDGE_INSERT - This stored procedure is used to Import the Weighbridge data. At the top of the procedure, you can find the Source SQL and Target SQL that is required to set up BOS Server.

Default credentials for Source MSSQL 2014 DB:

Data Source: Site-specific computer name
Password : TrekScale2094
Username: SQLTesting / sa

Link to BOS Server Documentation

BOS Enterprise - Weighbridge Module

The dedicated Weighbridge module can be used to view and manage all the Inbound and Outbound weights that are recorded.

This module can be added to the menu by selecting the fixed Weighbridge module.

Functionality is provided to export the weighbridge data in an Excel format.

Each Weighbridge record should update a single transaction, based on the settings below.

The following fields can be edited when the Status is Pending:

Order No.
Del No.
Reg. No.
Product
Haulier
Customer
Destination
Company
Note

Right-click a Weighbridge record to view the Changelog linked to a record.

Data filter

The default data filter is No Date & Pending Status

Date
Status

Status

When a new record is added, the Status is set to Pending and you're able to edit the Del No. and Order No. fields. When the weighbridge updates the linked Transaction (Delivery Note or Goods Received), the Status is set to Complete. Administrators can manually change the status.

Actions

Update Transaction - Updates transactions for multi-selected weighbridge records. The procedure checks if the Transaction is in an editable Status and then updates all the Items linked to Compound Categories. The Qty is updated to the Nett Weight and the weighbridge data is added as a Note to the Item. Note: The linked transaction needs to be in an editable status.
Set Status
- Pending
- Complete
- Cancelled

Changelog

The following fields are included in the Changelog;

Order No.
Del No.
Product
Haulier
Customer
Destination
Company
Note

Settings

General Settings > Weighbridge > Item Category filter for Products - used to restrict the Product lookup to valid items only.
Transaction > Status: Default = Weighbridge - When a DN or GR is updated/created from a Weighbridge record, the Status will be set to the Default = Weighbridge Status.
Role Settings > Module = Weighbridge > Weighbridge - Access Allowed - None, User, Administrator - The Administrator is allowed to update the Status on a weighbridge record.
Transaction Setting > Default: Purchase Order Transaction for Weighbridge (In) - The Transaction used to make Purchase Orders for compounds.
Transaction Setting > Default: Create Transaction from Purchase Order for Weighbridge (In) - The Transaction (Goods Received) that will be created from the Purchase Order specified in the Weighbridge record. The first item linked to Input = Compounds will be copied - ie. Purchase Orders must only contain one Compound Item.
Transaction Setting > Default: Update Transaction from Weighbridge by Del No. (Out) - The Transaction (Delivery Note) is linked by number to the Del No. in the weighbridge record. The first item linked to Input = Compounds will be copied - ie. Delivery Notes must only contain one Compound Item.

NB. Create only one each of the above Transaction settings.