Weighbridge (Trek Scale)

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

Menu 

• Open Transaction - Opens the linked Transaction when applicable.

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.