How to update UoM Price for item where pricing unit isn't the same as UoM Group default unit?

[Julian_Biggin]

I've written a process to update the pricing for an item and uses a loop to go through any existing UoM's establishing if there is an entry present in ITM3/9 for the unit, where this is not the case the UoM entry is added along with the price.

Looping around the lines in "oItems.PriceList.UoMPrices" and on finding the required UoM updating the price or if not found adding a new line.

If there are no additional UoM's present for the item as the unit is the same as the default UoM for the items UoM Group this again works fine too, as "oItems.PriceList.Price" works fine to update the price.

The issue comes where the default pricing unit differs from the pricing unit, but there are no other UoM's with prices. The UI allows the entry of a price for that UoM however, I can't seem to get this to process via the DI as I'm getting the error.......

" 1470000147 - Invalid UoM; specify a purchase or sales UoM from ITM3 [ITM9.UomEntry][line: 1]"

Looking at the "oItems.PriceList" property, there's no object there to indicate the UoM, and looking at the table in SQL there is an entry in ITM9 but seemingly updating via the DI inside the record loop is failing when it comes to the "oItems.Update" process.

Does anyone have any ideas, or have hit this themselves?

[ANKIT_CHAUHAN]

Hi Julian_Biggin,

Does any of the following queries return any result?

• Select * from ITM9 T0 Where T0."UomEntry" not in (Select distinct "UomEntry" from ITM12 U0 where U0."ItemCode" = T0."ItemCode");
• Select * from ITM9 Where "PriceList" = '-1' and "UomEntry" in ('-1');

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[Abdul]

Please have a looka t below video, maybe it will help you. 

https://www.youtube.com/watch?v=O6IN3LIYVrk&t=8s

[Julian_Biggin]

Not really, as this is referring to how you acheive importing the data via DTW whereas I'm pushing in the updates via the DI using a C# program written to achieve this. :o(