How to identify an applied document that has no Document Number in Microsoft Dynamics GP
Posted on 2011-09-21
We had a transaction lost (or partially) when the workstation went down and the transaction couldn't finish posting; it was a credit memo being applied to an invoice of a Vendor.
We ran Check Links and Reconcile 3 times, and still the same problem.
The problem is that when we look-up the applied credit in the vendor's window (Inquiry >> Purchases >> Transaction by Vendor) the credit memo is displayed in the Invoice applied documents, but no Document Number is found.
To be exact:
1. We go to Inquiry >> Purchases >> Transaction by Vendor
2. Select the Vendor
3. Select the invoice that was paid
4. Click on Document Number link above to display the Invoice
5. Then click on the Apply button and all applied docs is display
(the Invoice has various payments and one credit memo)
7. The Credit Memo appears only with the correct Amount
and 'Voucher/Payment Number', but no 'Document Number'
When we look-up the credit memo in GP and is not found.
We searched the PM tables and compared a good finished posted transaction and the interrupted transaction (credit memo) and found that on the finished posted transaction, the transaction are found on more tables than the interrupted one.
This leads us to believe that we must create manually the transaction in the tables that is not present.
Please advice on how to go about to identify the problem correctly and possible fixes.