I am new to Acumatica, so, please be patient with me. I need to export production order records from Acumatica. I am successfully doing that but I have been requested to update information back into Acumatica so I thought that if I had the unique record id then finding the right record to update would be easier. My issue is, I don’t see an option to include the unique value (primary index?) when doing the initial export of data. Is there a way to include the unique record id in a generic inquiry? Thanks in advance!
Answer
Include Unique Record ID in generic inquiry
Best answer by MichaelShirk
I would recommend going through these course to learn how to work with Acumatica data via API from an external system.
Web Services
+5The (composite) key fields for a production order record in Acumatica are AMProdItem.OrderType, and AMProdItem.ProdOrdID.
AMProdItem.NoteID is a GUID and will also be unique.
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Michael,
Thank you for your answer. So to be clear, there is no unique record id guid field for the work order header but it uses that combination of ordertype and prodordid. Is that the same for production order operations?
Thanks!
Alan
+5Well, the NoteID is a unique record id, but that’s typically not used when referencing records for updating inside of Acumatica. I do think you can update records via API using the NoteID.
The production order operations also have a noteID field “AMProdOper.NoteID” that is a unique ID.
What process are you wanting to use to update the records?
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
New to Acumatica so learning as I go, but I assume I will be using the REST API to update the records.
+5I would recommend going through these course to learn how to work with Acumatica data via API from an external system.
Web Services
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.