Solved

Sales order with allocation creates new Lot/serial number entry

  • 18 March 2024
  • 2 replies
  • 36 views

Userlevel 1

Good day.

 

We have an enquiry regarding the creation of a sales orders with allocations.

 

We query the inventory summary results - expanded  by lot/serial number to retrieve a list of serials for an inventory product. We then display these options to the user to choose from when ordering a product ex: a gun.

 

It seems that when we create an order with an allocation it creates/duplicates the lotSerialNbr entry within the inventory summary.

 

Please see attached:

- Example of create order call from documentation

- Screenshot of our request logs

- Screenshot of additional lotSerial entries created

 

Our understanding of allocation on an order is that an existing lot serial number will be assigned to a Details/Product entry.

 

Would appreciate any clarification and guidance on why our request is in fact creating a new lot/serial entry for an inventory item.

 

Kind regards, 

Alecia

icon

Best answer by Alecia 20 March 2024, 10:14

View original

2 replies

Userlevel 1

We have found the reason why the lotSerialNbr entries were duplicating. 

 

For reference for anyone who might experience the same problem: 

 

If we specify the the 'LocationID': {"value": “MAIN”} within the allocation object an existing stock entry is assigned rather than creating a new UNASSIGNED lotSerialNbr entry. 

 

Kind regards.

 

Userlevel 7
Badge

Thank you for sharing your solution with the community @Alecia!

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved