Hi, we’re onboarding Acumatica now and would like to confirm this is possible. That is, can we use a Business Event or other functionality in Acumatica to automatically create a 6-digit Alternate ID upon creation of a Stock Item that would serve as a barcode? We would need to it to auto-increment so that it’s unique.
Create Auto-Incremented 6-digit Code for each Stock Item Upon Creation - Business Event?
Hi
What are you trying to Update the barcode, Are you looking to Pass same Inventory ID as alternative ID?
Thanks
Can you give me one example
How Inventory ID created and how would like to update the barcode ?
- Create a generic inquiry that shows all stock items. Use InventoryItem table, filter on IsStk, left join INItemXRef, filter on the type “B”. In the generic inquiry, show InventoryID, InventoryCD, and INItemXRef.AlternateID.
- Set up your Business Even to run every minute, using the data from that generic inquiry, but only picking up lines where AlternateID is empty.
- Set up your Import Scenario (from the Business Event) to use the InventoryID value (it’s always an integer), pad it with zeros on the left, and write it to the AlternateID field.
I’m pretty sure this will work. As for the auto-increment, you can definitely do that, but it would require custom code. Hope this helps.
- Create a generic inquiry that shows all stock items. Use InventoryItem table, filter on IsStk, left join INItemXRef, filter on the type “B”. In the generic inquiry, show InventoryID, InventoryCD, and INItemXRef.AlternateID.
- Set up your Business Even to run every minute, using the data from that generic inquiry, but only picking up lines where AlternateID is empty.
- Set up your Import Scenario (from the Business Event) to use the InventoryID value (it’s always an integer), pad it with zeros on the left, and write it to the AlternateID field.
I’m pretty sure this will work. As for the auto-increment, you can definitely do that, but it would require custom code. Hope this helps.
Adding sample Business event to kick start on this
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.