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.

About Us

Greytrix – a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.

Greytrix has some unique integration solutions developed for Sage CRM with Sage ERPs namely Sage X3, Sage Intacct, Sage 100, Sage 500, and Sage 300. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 – Sage CRM integration listed on Sage Marketplace and Sage CRM – Sage Intacct integration listed on Sage Intacct Marketplace. The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.

For more information on our integration solutions, please contact us at sage@greytrix.com. We will be glad to assist you.