mm09,

Are you trying to create an invoice and its adjustment in the same data entry batch?  You cannot do that.  You can only create adjustment for an invoice that has been updated.  An adjustment invoice is like a normal invoice except that you set Adjustment$ to Y.  When you set the InvoiceNo$, you will get a warning (-1).  You can continue to SetKey and the rest of the fields.

Thank you Natasha. I appreciate your help.

So I will have to add one more header record with same invoice number but Adjustment$ set to Y and a line item with the adjustment amount. Should the amount on line match with the invoice amount on header?

For Example, I have added an invoice record where Adjustment$ is set to N with invoice amt 1200.

Now I want to add an adjustment record with adjustment amount -500. I create a header record with same invoice number where Adjustment$ is set to Y.

What should be the Invoice Amt on (adjustment)header and (adjustment)line in this case?

Thank you again for your help.

Both header and line amounts need to be -500.

Natasha,

When I try to add the header and line record with the same invoice number and Adjustment$ set to Y and with the same header and line amount, I get an error which says "The invoice is out of balance. Do you want to delete the Invoice?". Where am I going wrong?

Did you set InvoiceAmt in the header and DistributionAmt in the detail?  There are several amount fields.

Here is my really quick test in PVX syntax:

o = NEW("AP_Invoice_bus", %sys_ss)

r = o'SetKeyValue("APDivisionNo$", "01")

r = o'SetKeyValue("VendorNo$", "AIRWAY")

r = o'SetKeyValue("InvoiceNo$", "1053190")

r = o'SetKey()

r = o'SetValue("Adjustment$", "Y")

r = o'SetValue("InvoiceAmt", -10)

r = o'AddLine()

r = o'Lines'SetValue("AccountKey$", "100000000")

r = o'Lines'SetValue("DistributionAmt", -10)

r = o'Lines'Write()

r = o'Write()

Yes. I am setting the same amount in  InvoiceAmt field in Header and in DistributionAmt field in line.

See my example above.  Is your script similar to mine?

Natasha,

My script looks the same like yours except that I am also setting the other header fields in the adjustment invoice and I am setting the same value in InvoiceAmt and in DistributionAmt field.

r = o'SetKeyValue("APDivisionNo$", "00")

r = o'SetKeyValue("VendorNo$","HD")

r = o'SetKeyValue("InvoiceNo$","1000124")

r = o'SetKey()

r = o'SetValue("InvoiceDate$", "04/30/2014")

r = o'SetValue("InvoiceDueDate$", "04/30/2014")

r = o'SetValue("HoldPayment$", "N")

r = o'SetValue("Comment$", "IMPORTED")

r = o'SetValue("Adjustment$", "Y")

r = o'SetValue("RecurringInvoice$", "N")

r = o'SetValue("SeparateCheck$", "N")

r = o'SetValue("InvoiceAmt","-200.00")

r = o'SetValue("TermsCode$", "00")

r = o'Lines'AddLine()

r = o'Lines'SetValue("AccountKey$","220100000")

r = o'Lines'SetValue("DistributionAmt","-200.00")

r = o'Lines'Write()

r = o'Write()

Thanks you.

I forgot to mention something. Before setting APDivisionNo, I am selecting the batch number. It is the same batch number which has the invoice with same invoice number and where Adjustment$ is set to N.(It is the invoice without the adjustment amount)

r = o'Selectbatch("01113")

The InvoiceAmt and DistributionAmt fields are numeric fields.  Remove the quotes from around the values when doing the SetValue() of a numeric field.

The two lines from your example should be:

r = o'SetValue("InvoiceAmt",-200.00)

and

r = o'Lines'SetValue("DistributionAmt",-200.00)