BOI - How to insert an adjustment record in AP Invoice Data Entry

Question

Hi 
 I am using BOI to insert records in AP Invoice Data Entry. I am able to insert the header and lines record successfully. Can anybody please help me understand how can I insert an adjustment record? Because while inserting an adjustment record I have to use the same invoice number inserted before and when I try to insert the same invoice number, I get an exception which says "Invoice number is in use by another user". Is there any header field that I have to set while inserting an adjustment record? The header fields that I am inserting are APDivisionNo VendorNo BatchNo InvoiceNo InvoiceDate InvoiceDueDate HoldPayment Comment Adjustment RecurringInvoice SeparateCheck InvoiceAmt NetInvoiceAmt TermsCode 
 Thank you in advance.

Natasha Chang · Accepted Answer

The reason you do an adjustment is because the original invoice doesn't exist in data entry anymore. Someone has printed and updated the invoice register. And you need to change the amount. 
 If the invoice is still in data entry, you can just modify that invoice, instead of creating an adjustment invoice. 
 If SetKey returns 1 (invoice exists in data entry), you can use GetValue to get the current invoice amount, then do SetValue of the new amount (existing amount - 200). You can add a new line with distribution amount = -200. Then the header and detail totals should match.

Sage 100

BOI - How to insert an adjustment record in AP Invoice Data Entry

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING