Calculate price 3

[Rodrigue]

Hello,

I work on an application (Delphi or .NET) that will run outside off Accpac. I want to know how to calculate item prices. Do I need to find information in the table or is there a view available??? Any help will be appreciated!

If you have something like "Developping for Accpac for dummies" let me know. I'm TOTALLY lost!!

Thanks!

 

[Jay Converse]

Look in the ICPRIC and ICPRICP view/tables, they're the same thing.

 

[Rodrigue]

Thanks.

I already had those, but....Is there anything that calculate the price based on customer, item, quantity, etc. that I will give as parameters.

Using ICPRICP or ICPRIC I need to calculate the price with my application. Everything is Ok when PRICETYPE = DISCOUNT, but when PRICETYPE = everything else :'(

If that kind of view doesn't exist can you tell me where I can find "Markedup Cost", "Average cost" and "Landed

 

[Jay Converse]

ICILOC has average and last costs.
ICCUPR has customer/contract prices.
I don't know where landed costs are stored.

 

[ettienne]

Landed is one of the user defined cost fields in ICILOC.

 

[ettienne]

There is an item pricing view OE0630. Good luck on figuring out how it works.

 

[ettienne]

There is also IC0385.

 

[DjangMan]

I've already written that in Delphi.

http://www.silentdsoftware.com/html/customer_price_list.html

 

[Rodrigue]

Ok DjamMan, but can you give me some hints???

I there views or I need to figure out how the price is calculated?

I want to do something like that but I need the quantity price to be included.

 

[DjangMan]

I didn't use views - I went after the tables directly.

Here are the things you need to know:
Customer Number
Customer Type (Base, a..e)
Item Number
Item Category
Price List Code

You have to get the base price for the item.
Then determine how the item's price is calculated.
Get the discount percentages for the item from the price list.
Check for rounding instructions.
Look for an item contract.
Look for a category contract.

Now depending on the version of Accpac you are supporting you'll need to supply a quantity to purchase and you'll need to know the item's weight.

You'll also want to check for sale prices.

If you have Accpac you can use the RVSpy utility to watch Accpac read the information from each table to determine the price. You don't get to see the calculations but that part isn't the hard part.

 

[ettienne]

That all seems to be handled in the OE0630 view, I just have not put a lot of effort in figuring it out.

 

[Rodrigue]

Thanks for the instruction DjangMan it will help me not to forget anything.

Ettienne: I've tried to figure out how OE0630 and IC0385 and nothing comes up, so if you figure out, post plz

Thanks guys I appreciate

 

[DjangMan]

Ettienne - I coded it for a client who needed to be able to lookup customer pricing very quickly for ranges of items. Their Unix system allowed that so I had to reproduce it for Accpac - along with a quarter million contract prices.