Building a GI that will display Inventory items along with the data from the InUnit table (conversions).
Ex.
My GI keeps giving me duplicate records such as below:
I’m not sure where the conversion factor of 1 is coming from in this case. Here are the joins:
Best answer by lauraj46
Hi
I believe that Acumatica creates a default record for every stock item using the base UOM.
You could add a join condition: InventoryItem.BaseUnit Not Equal InUnit.FromUnit
Hope this helps!
Laura
+8Hi
I believe that Acumatica creates a default record for every stock item using the base UOM.
You could add a join condition: InventoryItem.BaseUnit Not Equal InUnit.FromUnit
Hope this helps!
Laura
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
