Jiwa

From the object JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderLine I want to get the returned price mode, so whether it's Percentage, Actual or None (assuming the price has come from Debtor Specific price, Debtor Classification Price, Debtor Group price, etc).

I've looked in

Code: Select all

soLine.PriceSelected

and

Code: Select all

soLine.PriceSelected.SourcePrice

but neither gives me the mode of the returned price.

Do I just need to whip up an SQL select statement to find the mode?

DannyC wrote:From the object JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrderLine I want to get the returned price mode, so whether it's Percentage, Actual or None (assuming the price has come from Debtor Specific price, Debtor Classification Price, Debtor Group price, etc).

I've looked in

Code: Select all

soLine.PriceSelected

and

Code: Select all

soLine.PriceSelected.SourcePrice

but neither gives me the mode of the returned price.

We don't have properties of prices which aren't universally generic available from there - just what we knew would be fairly generic and useful (like the price in dollars and cents, does the price have a date range, quantity break and so on).

DannyC wrote:Do I just need to whip up an SQL select statement to find the mode?

That's a good way to do it - in the case of a debtor specific price, the soLine.PriceSelected.SourceID is the RecID from the IN_DebtorSpecificPrice table, so using that you can find the other values you're interested in. Just be aware that a debtor specific price might not be the source of the price, so SourceID will need to link to something else - you can work out which table columns SourceID links to by looking at the stored proc backing the price - whatever goes into the RecID column being returned by the stored procs is what ends up in the SourceID property of the soLine.PriceSelected.SourceID.

I was thinking about the sourceID, but then I thought it would be more readable if I used the description so I knocked up a routine which basically fires off the relevant SQL statement to find the OPMode. Pretty much like this:

Code: Select all

switch (soLine.PriceSelected.SourcePrice.Description)
{
   case "Debtor Specific Price":
      //do stuff to get the mode.
   break;
   
   case "Debtor Parent Price":
      //do stuff to get the mode.            
   break;
      
   case "Debtor Classification Price":
      //do stuff to get the mode.
   break;
      
   case "Debtor Group Price":
      //do stuff to get the mode.
   break;
      
   case "Debtor Parent Classification Price":
      //do stuff to get the mode.
   break;
}