Negative line item unit price via API

[pauls22]

Hi,

I have some VBA code that inserts an invoice into ACCPAC. Everything has worked fine for several years. Now there is a requirement for adding a line item that is a rebate/credit (negative amount).

Is there a means of setting a negative amount as the unit price via the API? When I try to pass a negative number, an error occurs.

Ideally, the line item details show up as a negative "unit price" with a quantity of 1/one.

Thanks.

 

[Jay Converse]

Duh! That's not an invoice, that's a credit note.

You need to be working with the OECRD* views, not the OEINV* views.

 

[pauls22]

Hi Tuba2007,

Thanks for taking the time to reply. I might be wrong in the views that I am using but I need to issue an invoice as the "credit" can only be applied to new purchases. On the invoice they would like the existing credit displayed as a negative amount. This will allow the subtraction to be shown.

Is this possible in an invoice only? Or are you saying that I will need to create both an invoice and credit?

Thanks.

 

[Jay Converse]

So this is a PO invoice? In that case, I don't know the answer.

 

[ettienne]

Enter a negative qty with a positive price.

 

[DjangMan]

Record a macro of the process that you're trying to accomplish. Then review the code and go from there and 99% of the time you'll have the code you need.