Microsoft Dynamics SL: Missing AR Documents in the AR Payment Application Window
Posted by Michael Broadmeadow, Senior Support Analyst on September 13, 2016
Recently, our Support Team at Crestwood received a call from a client that they were missing AR documents in the Detail area of the AR Payment Application screen in Dynamics SL. However, the missing documents showed up on the Aging Report and also showed as “open” in the Customer Maintenance Activity.
Where are the Missing Documents?
If you’re also missing documents in the Detail area of your AR Payment Application screen in Dynamics SL, it’s most likely in another Payment Application batch that is either on hold or possibly suspended. In order to fix this, you will need to find that batch and then release or delete it.
3 Ways to Find the Missing Document:
- Open the Payment Application screen and press F3 in the batch number field. In the filter area, change the field to Status and search for batches that have a status of B or H or S. If you find a batch, bring it up and review it to see if the Customer and Documents are in the batch. If so, either release the batch or delete it.
- Run an AR Batch register to find batches that have not been released. On the Report tab, make sure you enter a begin period of when the document was entered and an end period of the current period. Enter the following info from this screen shot on the Select tab.
- Review the batches found from the report in the Payment Application screen. You will then have to either release or delete the batch containing the Customer and Documents.
If you have access to SQL, run the following statement
Select * from artran where siteid = ‘XXX’
Replace the XXX with the document number that is missing. If data is returned look at the artran.batnbr field and bring this batch up in Payment Application. Note: This process will only work if the missing document has an 'Amt To Apply' in the Payment Application batch.
Again, you must either release or delete the batch containing the Customer and Documents.
If you have questions or need further assistance, give our team of experts a shout.
Contact them at Support@Crestwood.com