Weighbridge Reference

BOS Enterprise can connect directly to the Trekscale database to extract weighbridge data at scheduled intervals (see Trekscale Contact Details below).

  • BOS Server manages the integration using the Data Exchange Service. The Trekscale application runs on an MSSQL 2014 database, and the data is imported to the BOS Firebird database (see BOS Server Setup below).
  • The dedicated Weighbridge module can be used to view and manage all the Inbound and Outbound weights that are recorded. It can be added to the menu by selecting the fixed Weighbridge module.
  • Each weighbridge record should update a single transaction, based on the settings below.

Settings

Note

The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.

General Settings

Navigation Example

Main Menu > Settings > General (tab)

Setting Description Default
Weighbridge > Item Category for Containers (e.g. = 2, in (1,2,3))
  • Used to restrict the Container lookup to valid items only.
  • Container Items require a weight in kg. You can assign the Item Weight in the Estimating tab on the Item's edit view.
Blank
Weighbridge > Item Category for Products (e.g. = 2, in (1,2,3))Used to restrict the Product lookup to valid items only.Blank

User Settings

Navigation Example

Main Menu > Settings > Users (tab)

Setting Description Default
General > Weighbridge - Access AllowedThe options are: None, View Only, Full Access.None

Transaction Settings

Navigation Example

Main Menu > Settings > Transactions (tab)

Note

Create only one of each of these Transaction settings.

Setting Description Default
Weighbridge > Create Transaction from Purchase Order for Weighbridge (In)Add this setting to the Goods Received Transaction Type that is created from the Purchase Order specified in the weighbridge record. The first item linked to Input that equals Compounds is copied. The Purchase Orders must only contain one Compound Item.Unchecked
Weighbridge > Purchase Order Transaction for Weighbridge (In)Add this setting to the Transaction Type used to make Purchase Orders for compounds.Unchecked
Weighbridge > Update Transaction from Weighbridge by Del No. (Out)Add this setting to a Delivery Note. The transaction (Delivery Note) is linked by number to the Del No. in the weighbridge record. The first item linked to Input = Compounds is copied. Delivery Notes must only contain one Compound Item.Unchecked

Status Settings

Navigation Example

Main Menu > Setup > Transactions > Status (tab)

For the Goods Received and Delivery Note transactions set up above, set Default to Weighbridge next to one of their statuses. When these transactions are created from a weighbridge record, their statuses change to the default Weighbridge status.

Statuses Explained

Info

When a new record is added, the Status is set to Pending and you can 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 change the status manually.

Status Description
PendingNew records start as Pending. All the fields can be edited, and Update Transaction updates the linked transaction.
CompleteSet when the weighbridge updates the linked transaction. Only the Status can be changed, and the record cannot be deleted.
WasteUsed, for example, when the goods are spoilt. Only the Status can be changed, and the record does not update a transaction.
CancelledOnly the Status can be changed. The record does not update a transaction.

List View

Navigation Example

Main Menu > Weighbridge

Buttons Explained

Button Description
ViewLists the records that match the filters.
EditLets you change Pending records (see Fields Explained below).
SaveSaves the changes.
ActionsOpens a menu with these options:
  • Update Transaction: Updates the transactions of the selected weighbridge records. The procedure checks that the transaction is in an editable status, then updates all the items linked to Compound Categories: the Qty is set to the Net Mass, and the weighbridge data is added as a note to the item.
  • Status: Sets the selected records to Pending, Complete or Cancelled. Waste is set in the Status column (see Fields Explained below).
  • Delete: Deletes the selected records. Complete records cannot be deleted.
MenuOpens a menu with these options:
  • Reset Data Filter: Resets the filters.
  • View Changelog: Shows the changes to the selected record (see Changelog below).
  • Export Grid and Email Excel: Export the weighbridge data in Excel format.
  • Layout & Grids: Save, Save (All Users), Restore Grid and Restore Default (All Users).

Filters Explained

Info

By default, the list shows all the Pending records (No Date and Pending Status).

Filter Description
DateThe date range of the records.
StatusThe status of the records.

Fields Explained

Info
  • Fields marked in blue (✎) can be edited when the Status is Pending.
  • BOS Enterprise V26 added the pallet, FlowBin and container columns. Columns removed in V26 were not removed from the database.
Field Description
IDThe system-generated number for the record.
Reg No.The registration number of the vehicle.
CompanyThe customer.
HaulierThe haulier (a supplier).
ProductThe product (see Item Category for Products above).
DestinationThe destination.
Order No.The order number.
Date In, Time InThe date and time of the first weighing.
1st MassThe first weight.
Operator InThe operator of the first weighing.
StatusThe Trekscale status of the first weighing.
Date Out, Time OutThe date and time of the second weighing.
2nd MassThe second weight.
Operator OutThe operator of the second weighing.
Status 2The Trekscale status of the second weighing.
Net MassThe net weight, which Update Transaction uses as the Qty.
DirectionIn or Out.
Del No.The Delivery Note number the record is linked to.
StatusThe record's status in BOS Enterprise (see Statuses Explained above). In Edit mode, it can be changed on any record, and it is the only place to set Waste.
TransItem IDThe transaction item the record updated.
Trekscale IDThe record's number in Trekscale.
NoteA note.
UpdatedThe user who last updated the record, and when.
GR No.The Goods Received number.
Pallet WeightThe pallet weight.
Pallet QtyThe number of pallets.
FlowBin QtyThe number of FlowBins, without decimals.
FlowBin WeightThe FlowBin weight, with two decimals.
Container (CTR)Select from Items (see Item Category for Containers above).
CTR InEnter the number of containers coming in.
CTR OutEnter the number of containers going out.
MenuClick the button or right-click a weighbridge record for these options:
  • View Changelog: Shows the changes to the record.
  • Open Transaction: Opens the linked transaction when applicable.

Changelog

These fields are included in the Changelog:

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

BOS Server Setup

  • 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 imports the weighbridge data. The Source SQL and Target SQL needed to set up BOS Server are at the top of the procedure.
  • Default credentials for the source MSSQL 2014 database:
    • Data Source: The site-specific computer name.
    • Username: SQLTesting or sa.
    • Password: TrekScale2094.
  • See the BOS Server documentation.

Trekscale Contact Details

  • Company: TREK SCALE COMPANY (PTY) LTD.
  • Address: 12 Bessemer Road, Heriotdale, Johannesburg, 2094
  • Postal address: P.O. Box 40565, Cleveland 2022
  • Tel: 011 626 3490/8
  • Fax: 011 626 2029
  • Website: www.trekscale.com
  • Email: software@trekscale.com

Report an issue with this page

For more useful feedback, select the text on the page you're reporting about, then click Feedback again — or continue without selecting anything.