Skip to main content
Question

Data Capture from third party software during production run

  • September 25, 2023
  • 2 replies
  • 62 views

Jennifer Douglas
Varsity I
Forum|alt.badge.img+1

Hey all!

Hope someone has implemented a similar solution to a problem I am struggling with. 

We are still in the implementation phase of Acumatica at this facility, and at this time my ‘decision makers’ are insisting we use kits rather than a production run due to the way our BOMS are set up.  

Parallel to this upgrade, we are implementing a new scale system in one phase of our manufacturing facility. We need to capture 4 fields, the tare weight, the net weight, the gross weight, and the sequential “box number” of that run.  This is a proof of concept for creating end to end transparency and visibility for QC in our tobacco products as they are assembled between 3 companies on 2 tenants.

We’ve discussed adding attributes to the kit assembly and using lot/serial numbers but realized that in both the production and kit assembly these are not created until either the assembly of the kit, or the completion of the production run.  Nor are these attributes presented within the webservice endpoints after we created them for either production or kit assembly.  

What is the best practice to create a one-to-one record of the fields being recorded from a third-party software during production? 

The software that the scale system will be using is Ignition with a SQL Server and will be the using Business Connector module from Sepasoft to pass the data through the API.  

 

2 replies

angierowley75
Acumatica Moderator
Forum|alt.badge.img+3
  • Acumatica Moderator
  • 817 replies
  • September 25, 2023

Production Orders support the ability to create a Lot / Serial for the finished good prior to releasing the production order… not sure if that information helps - but thought I would mention it.

“We’ve discussed adding attributes to the kit assembly and using lot/serial numbers but realized that in both the production and kit assembly these are not created until either the assembly of the kit, or the completion of the production run. “


cmoreland
Semi-Pro III
Forum|alt.badge.img
  • Semi-Pro III
  • 106 replies
  • October 10, 2023

As @angierowley75  stated you can assign a lot/serial in the 23R1 and later versions of Acumatica.

If you are posting back to the Acumatica API you could add a simple custom field on the order (I would put it under the references tab myself) and extend that field in the API. I do something similar with our “Work To List” and Sales/Production Orders. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings