IN_DebtorClassificationSpecificPrice NULL Debtor Class  Topic is solved

Discussions relating to plugin development, and the Jiwa API.

IN_DebtorClassificationSpecificPrice NULL Debtor Class

Postby pricerc » Tue Jun 13, 2023 1:58 pm

I'm just trying to figure out what the customer is doing with their pricing, and I notice a decent chunk of records in IN_DebtorClassificationSpecificPrice have no value (DB NULL) for DebtorClassificationID.

A quick scan through the decompiler shows me that Jiwa is happy to load these records, but I can't see where a "debtor classification price" with no debtor classification is referenced in the code, nor can I imagine a scenario where they would be useful.

What have I missed?
/Ryan

ERP Consultant,
Advanced ERP Limited, NZ
https://aerp.co.nz
User avatar
pricerc
Senpai
Senpai
 
Posts: 504
Joined: Mon Aug 10, 2009 12:22 pm
Location: Auckland, NZ
Topics Solved: 20

Re: IN_DebtorClassificationSpecificPrice NULL Debtor Class  Topic is solved

Postby Mike.Sheen » Tue Jun 13, 2023 2:13 pm

pricerc wrote:I'm just trying to figure out what the customer is doing with their pricing, and I notice a decent chunk of records in IN_DebtorClassificationSpecificPrice have no value (DB NULL) for DebtorClassificationID.

A quick scan through the decompiler shows me that Jiwa is happy to load these records, but I can't see where a "debtor classification price" with no debtor classification is referenced in the code, nor can I imagine a scenario where they would be useful.

What have I missed?


NULL just means all debtor classifications.

For example, you might want a promotional price of 10% off for the month of June for everyone who buys 5 or more 5L tubs of personal lubricant, and so you just add a debtor classification price to the product with 10% off, start and end date and no debtor classification.
Mike Sheen
Chief Software Engineer
Jiwa Financials

If I do answer your question to your satisfaction, please mark it as the post solving the topic so others with the same issue can readily identify the solution
User avatar
Mike.Sheen
Overflow Error
Overflow Error
 
Posts: 2444
Joined: Tue Feb 12, 2008 11:12 am
Location: Perth, Republic of Western Australia
Topics Solved: 756


Return to Technical and or Programming

Who is online

Users browsing this forum: No registered users and 39 guests