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
The defaults are the values for new databases, new users and new Transaction Types. Your database may have different values.
General Settings
| Setting | Description | Default |
|---|---|---|
| Weighbridge > Item Category for Containers (e.g. = 2, in (1,2,3)) |
| 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
| Setting | Description | Default |
|---|---|---|
| General > Weighbridge - Access Allowed | The options are: None, View Only, Full Access. | None |
Transaction Settings
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
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
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 |
|---|---|
| Pending | New records start as Pending. All the fields can be edited, and Update Transaction updates the linked transaction. |
| Complete | Set when the weighbridge updates the linked transaction. Only the Status can be changed, and the record cannot be deleted. |
| Waste | Used, for example, when the goods are spoilt. Only the Status can be changed, and the record does not update a transaction. |
| Cancelled | Only the Status can be changed. The record does not update a transaction. |
List View
Buttons Explained
| Button | Description |
|---|---|
| View | Lists the records that match the filters. |
| Edit | Lets you change Pending records (see Fields Explained below). |
| Save | Saves the changes. |
| Actions | Opens a menu with these options:
|
| Menu | Opens a menu with these options:
|
Filters Explained
By default, the list shows all the Pending records (No Date and Pending Status).
| Filter | Description |
|---|---|
| Date | The date range of the records. |
| Status | The status of the records. |
Fields Explained
- 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 |
|---|---|
| ID | The system-generated number for the record. |
| Reg No. | The registration number of the vehicle. |
| Company | The customer. |
| Haulier | The haulier (a supplier). |
| Product | The product (see Item Category for Products above). |
| Destination | The destination. |
| Order No. | The order number. |
| Date In, Time In | The date and time of the first weighing. |
| 1st Mass | The first weight. |
| Operator In | The operator of the first weighing. |
| Status | The Trekscale status of the first weighing. |
| Date Out, Time Out | The date and time of the second weighing. |
| 2nd Mass | The second weight. |
| Operator Out | The operator of the second weighing. |
| Status 2 | The Trekscale status of the second weighing. |
| Net Mass | The net weight, which Update Transaction uses as the Qty. |
| Direction | In or Out. |
| Del No. | The Delivery Note number the record is linked to. |
| Status | The 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 ID | The transaction item the record updated. |
| Trekscale ID | The record's number in Trekscale. |
| Note | A note. |
| Updated | The user who last updated the record, and when. |
| GR No. | The Goods Received number. |
| Pallet Weight | The pallet weight. |
| Pallet Qty | The number of pallets. |
| FlowBin Qty | The number of FlowBins, without decimals. |
| FlowBin Weight | The FlowBin weight, with two decimals. |
| Container (CTR) | Select from Items (see Item Category for Containers above). |
| CTR In | Enter the number of containers coming in. |
| CTR Out | Enter the number of containers going out. |
| Menu | Click the button or right-click a weighbridge record for these options:
|
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