Trouble with AccpacCalcCustPrice (1 reply)

Shraga Muller

6 years ago

Shraga Muller 6 years ago

I have a job to extract contract prices from sage but for some reason it is not working on some customers and items. Sage is picking it up properly in order entry but IMan is returning 0.

I am using the following formula.

AccpacCalcCustPrice("ACCPAC", %Customer, %ITEM, "1")

Support

6 years ago

Support 6 years ago

Shraga, there should be an issue.

My steps to debug would be as follows:

What happens when you enter a line on an order for the customer, item and quantity? Does Sage300 provide a price?
Try changing the "1" to just 1.
You may need to add additional parameters to calculate the price (such as Uom). For example:
```
AccpacCalcCustPrice("ACCPAC", %Customer, %ITEM, 1, "ORDERUNIT", "CASE")
```
See the examples on the reference section.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Request Demo

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Access Downloads

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Username
Password

	Remember Me Lost your password? Register