RE: Accounts Receivable Outstanding Payment Application
Lisa,
The first thing I would do is run a query against the invoice and look at the field ApplBatNbr. This field will contain the batch number of the application batch that is set to pay some or all of the document. When a payment application batch is created and items applied to documents, this field is set in the documents and is not cleared until the application batch is fully released. While this field is set you will get the message you indicated. If the value in that field represents a batch that does not exist then you can clear this field and the ApplAmt field and the document should then be available. However, you should run a separate query against the batch table to make sure the indicated batch does not really exist. Remember, that batch could have been created by a screen other than the payment application screen. Looking at the Crtd_Prog field in the batch table will tell you what screen created that batch.
Having said the above, your post is not clear as to whether you are talking about an invoice/debit memo that should have a 0.00 balance or a payment that should have a 0.00 balance due to an NSF action against that payment. If the later, then the above does not apply. In that case, you need to find where the payment is showing as part of an application batch. In that case there will be one or more ARTran records where the refnbr field is equal to the payment reference number and the siteID field will not be blank. The batnbr field of that ARTran record will indicate the batch number using that payment.
Let me know if none of the above resolves your issue or you need more assistance. My clients use the NSF action with some frequency and have not had your situation so, as far as I know, there is not an issue with doing an NSF action. As you probably know, the Application/Inquiry screen does not allow you to set the posting period of the corresponding transactions (if defaults to the current AR period) so, when you say the trial balance, if you mean the period sensitive trial balance then make sure you run that report for the correct posting period. Or, use the regular trial balance report to examine the document in question.
Share
Report
All responses (
Answers (
1,270
