Skip to main content
Solved

Warning of duplicate inventory ID when entering Sales Order/Invoice, or Purchase Order rows.


thomassherman51
Jr Varsity II
Forum|alt.badge.img

Is there some way in Acumatica to warn users, during entry, that the Inventory ID exist in another row?  

Scenario

A clerk inputs a Sales Order, Invoice, or PO with numerous items, 30+, including Item A. Later on they get a request to ‘add’ Items B to the order but they inadvertently select Item A

So the order is now has two rows with Inventory ID Item A.  

Required behavior:

  1. A popup prompt to notifying user that the Inventory ID already exist on the document
  2. Place a warning icon adjacent to the duplicate Inventory IDs 

     

 

 

 

 

Best answer by Laura02

Hello @thomassherman51 ,

With standard Acumatica features, there is no checkbox option we could choose that will automatically provide a warning or error to a user when a Sales Order contains the same item on multiple lines.

I do not see your idea in the Ideas section of Acumatica Community. Please add it so others may vote and add their comments.

It is possible to add warnings to Sales Order lines with customizations. Please review this previous post where a developer is adding custom code to the Sales Order Lines: 

 

Laura

View original
Did this topic help you find an answer to your question?

4 replies

Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • March 29, 2024

Hello @thomassherman51 ,

With standard Acumatica features, there is no checkbox option we could choose that will automatically provide a warning or error to a user when a Sales Order contains the same item on multiple lines.

I do not see your idea in the Ideas section of Acumatica Community. Please add it so others may vote and add their comments.

It is possible to add warnings to Sales Order lines with customizations. Please review this previous post where a developer is adding custom code to the Sales Order Lines: 

 

Laura


thomassherman51
Jr Varsity II
Forum|alt.badge.img

Hello Laura,

 

Thanks for your response and I will take your suggestion and post this as an idea.

Will look at the popup message customization you shared to see how this would be implemented in a duplicate Inventory ID scenario.  

.


craig2
Pro I
Forum|alt.badge.img+2
  • Pro I
  • 88 replies
  • April 2, 2024

Hey @thomassherman51 !

I hope you are well my friend!  For your scenario, the most elegant development solutions will be like what @Laura02 suggested. 

However, one option may be to create a GI with Sales Orders and their lines, then grouped by SOOrder.OrderNbr and SOLine.InventoryID.  In the Results, you can do a Count on SOLine.InventoryID, and then create a filter for instances where the Count > 1.

From there, you can create a Business Event or KPI or whatever else you like to help identify the scenario.  Now, any kind of alert like that is going to be after the fact, so I can understand why an instant pop-up is better.  But perhaps something based on a GI is “good enough.”

 

Best of luck!


thomassherman51
Jr Varsity II
Forum|alt.badge.img

Hello @craig2 , 

Thanks for your suggestion.

However, the user needs to be warned on selection of the duplicate item or on ‘saving’ the transaction.  


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