Jiwa Pricing

[SBarnes]

I am working on integration of Jiwa to a sales platform, the orignal idea had been to lift and shift the Jiwa pricing tables to this platform and then simply implement Jiwa's pricing functionality in this platform given this platform works on SQL server, it should have been a simple exercise.

This has now eveolved to having to translate the data for this platform, don't get me started on that point, any way my question is as simple as this the tables that need to be worried about are IN_DebtorPricingGroupSpecificPrice, IN_DebtorSpecificPrice and IN_DebtorClassificationSpecificPrice.

I understand what a blank classification id means in IN_DebtorClassificationSpecificPrice i.e. its a global quanity break for all classications but what if you find blanks in the Debtor Id in IN_DebtorSpecificPrice and what if the group is blank in IN_DebtorPricingGroupSpecificPrice, my question is because this is indeed the case in the client data, so are these treated similar to classifcation or should they be ignored?

[Mike.Sheen]

but what if you find blanks in the Debtor Id in IN_DebtorSpecificPrice

This is pretty easy to discover / test the behaviour.

Create a new Debtor Specific price for a product and don't specify a debtor. Use some parameters to make your testing narrow enough to separate it from other prices - for example, add a quantity break of 10 and a sell price of -99% off sell price.

The add the item to a sales order and (assuming the price scheme uses debtor specific prices) and see the result then the quantity is changed to 10:

Try again for any debtor and you'll find that having no debtor specified for a debtor specific price of a product means all debtors - but only where the price scheme applies - if a debtor is attached to price scheme that does not consider debtor specific prices, when a sales order is created for that debtor the price scheme defaults to that price scheme and if unchanged won't include the debtor specific prices with no debtor.

and what if the group is blank in IN_DebtorPricingGroupSpecificPrice

It's the same story as with debtor specific prices which have no debtor. Again - it should be easy to test.