Sage 300 Update Item Pricing Details (3 replies)
As a follow up image here's the mapping I refer to in question #2.
- If you are trying to set the details (for multiple units of measure) you set first the header, then the details. The details do not require the item, pricelist, currency as this is tied to the header.
- This is how Sage works. If you have multiple Units of Measure the values on the grid are empty.
Thank you. Once I added a hierarchy and adjusted the mappings I was able to get the price updates working. Thanks!
Hi there,
Looking for a little mapping advice. The goal is to set Base Price for all price lists in the result set to 0.00.
I'm querying table ICPRICP to get my target items in the Database Read. Right now I see 2 issues that I'm looking for input on.
1. I was expecting to see ITEMNO, PRICELIST and PRICETYPE fields when using Realisable's Sage 300 connector to update Item Pricing Details. None of those values were in the selection list. Maybe I've got an incorrect assumption? Or should these fields be there?
2. If I instead try to map to "Item Pricing" via the connector, I get unusual results. I'm expecting the grid to show 0.00 for Base Price but instead there is no value shown, and when I zoom to see the detail I do see 0.00. Still, something about this makes me think I'm doing this incorrectly.
Version details:
Assembly Versions:
Realisable.IManWebUI.DLL 4.2.0.0
Product Update: Product Update 1
Config Version: 4.24
DB Version: 4.20