Sage X3 Integration with Weighing Scales

Is it possible to integrate weighing scales to ERP? Yes. In Sage X3, we have established integration with weighing scales to fulfil the client’s requirement in which we have fetched/read a weight programmatically from weighing scale machine which is connected to the user’s machine and loaded the received data in Sage X3. To achieve this requirement, we have created a new custom screen. This screen is working according to that specific setup of the machine. So user won’t have to change his/her system to adjust with the customization.

Weighing scale integration with Sage X3 can provide a wide range of benefits for your business. These include reducing mistakes that can happen by a manual operator who needs to write down measurements, automatically picking an accurate weight from the scale. It has the ability to increase efficiency, saving time and money, and more.

One of our client wanted to add a customization in such a way that, whenever user measures the weight of the goods using weighing scale machine then that weight must appear automatically in the Gross Weight field of Production Tracking screen.

Now, we will see how the functionality is working in Sage X3:

Step 1: User will create Sales Order first. And after MRP Processing, Work Order will be generated against that Sales Order. Furthermore, Production Tracking will be generated against the work order. In Tracking, we have already added Gross Weight, Tare Weight, Net Weight and Remark columns in Stock Transaction Modification Screen.

Path: Manufacturing -> Production Tracking -> Manufacturing Tab -> Click on Action Button -> Stock Txn Modification (Refer below screenshot)

New Stuff: Weigh Bridge Integration in Sage X3

[Production Tracking Screen]

After clicking on Stock Txn Modification, pop-up window will be opened in which ‘0’ value will be displayed for Gross Weight, Tare Weight and Net Weight columns initially. Remark column will remain blank.

[Stock Txn Modification before loading weight]

Step 2: After that, user will open a custom screen i.e. Weighing Scale screen at his end where weighing machine is connected. To update the weight for that particular Product, user will select Production Tracking number from the finder and all the details related to tracking, product will be flown in the Weighing Scale screen, as shown in the below screenshot.

[Weighing Scale screen before Loading]

Tare weight will be calculated with the values of the Product Master screen. In Sales Order screen, Core, Box and Pallet products will be selected and sum of the STK Weight of those 3 products will be considered as Tare Weight.

Tare Weight = STK Weight of Core + STK Weight of Box + STK Weight of Pallet

Step 3: User will click on “Load Weight” button in Weighing Scale screen.

After clicking on Load Weight button, Gross Weight will be auto updated in the screen against the LOT and serial no. And user will enter data manually in Remark field.

Net Weight will be calculated as [Gross Weight – Tare Weight].

[Weighing Scale screen after Loading]

Step 4: After filling data, user will click on “Save in Sage X3” button, and one pop-up will be displayed to acknowledge a successful insert.

[Process Status]

After clicking on “Save in Sage X3” button, the data will be updated in the production tracking screen, as shown in the below screenshot.

[Stock Txn Modification after loading weight]

Step 5: LOT wise report will be generated against the production tracking, which contains total gross weight, total tare weight, total net weight. Barcode will be generated in this report.

[Barcode Print Format]

In this way, Weigh Scale Integration functionality is working in Sage X3 with the help of new custom screen and data is getting flown in the Production Tracking transaction.