Sage X3 Integration with Weighing Scales

By | July 20, 2022

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]
[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]
[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]
[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]
[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]
[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]
[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]
[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 Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience, 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 caters to a wide range of Sage X3, a Sage Business Cloud Solution, offerings. Our unique GUMU™ integrations include Sage X3 for Sage CRMSalesforce.com, Dynamics 365 CRM and Magento eCommerce along with Implementation and Technical Support worldwide for Sage X3. Currently we are Sage X3 Implementation Partner in East Africa, Middle East, Australia, Asia, US, UK. We also offer best-in-class Sage X3 customization and development services, integrated applications such as POS | WMS | Payment Gateway | Shipping System | Business Intelligence | eCommerce and have developed add-ons such as Catch – Weight  and Letter of Credit and India Legislation for Sage X3 to Sage business partners, end users and Sage PSG worldwide. Greytrix Sales Commission App for Sage X3 simplifies commission calculations and postings on sales transactions.

The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for processing and execution of application programs at the click of a button.

Greytrix is a recognized Sage champion ISV Partner for GUMU™ Sage X3 – Sage CRM integration also listed on Sage Marketplace; GUMU™ integration for Sage X3 – Salesforce is a 5-star rated app listed on Salesforce AppExchange and GUMU™ integration for Dynamics 365 CRM – Sage ERP listed on Microsoft AppSource.

For more information on Sage X3 Integration and Services, please contact us at x3@greytrix.com, We would like to hear from you.