I have historical transactions showing up in my ap aging from 2001 that are changing the balance of my total ap aging so it does not agree to my gl. All transactions are type PP. These transactions did not show up in prior months and they do not show when I look at AP/Vendor Maintenance/Documents. Is there a way to correct this so the transactions don't show up in my aging without impacting the gl balance?
*This post is locked for comments
Hi Tim,
I would suppose that someone removed the Pre-pay Nbr field from your Voucher and Adjustment Entry screen.
Several changes were made to the reports in how they handle the display of pre-payments. Most likely some database fields for these pre-pays and the items (checks & vouchers) linked to the pre-pays are not set correctly.
The statement below should return two rows from APdoc table. Pick the refnbr of a PP document that is currently showing in your aged report. In all statements, substitute the X's with your refnbr of the PP.
Select * from apdoc where prepay_refnbr = 'xxxxxx'
The two rows returned would be one for the pre-payment and the other row should be the voucher that the PP was applied to.
Select * from apadjust where adjdrefnbr = 'xxxxxx'
In the above statement, the ADJAMT field should contain 0 (zero) if the PP is fully applied to a voucher.
To see if it is fully applied, note the check number (adjgrefnbr) that paid the PP from the above statement and try this statement. Substitute the y's for the check number.
Select * from apadjust where adjgrefnbr = 'yyyyyy'
Let's start there and see what you find.
You could also create a support case as this is a bit difficult to support in this forum.
Yes, there is an asterisk in the title on the Voucher and Adjustment screen.
There are 9 PP transactions. 8 show the full balance on the aging and 1 is a partial.
I can get to SQL with my IT guy.
Hi Tim,
It sounds like your Voucher and Adjustment Entry screen might be customized. Is there an asterisk (*) in the title of the screen?
Do the Pre-payments display on the aging with their full balance or with a partial balance?
Do you have access to SQL Server Management Studio to look at the records in the database?
Version is 8.10.30917.00. Yes, we did an upgrade. All the pre-payments have been paid and applied to vouchers. I cannot see a Pre-Pay Nbr field when I go into Voucher and Adjustment Entry, so I cannot confirm if the Pre-Pays are on the list. I can find all of the prepayments in the Document Maintenance screen.
Hi Tim,
Did you just upgrade and the pre-payment documents suddenly started showing on the AP Aging?
What version of SL are you using? Let me know the version number from the Help/About Microsoft Dynamics SL screen.
Have all these pre-payments been paid with a check and have they been applied to vouchers? As a test, go into Voucher and Adjustment Entry. Select one of the vendors that has a pre-payment showing on the aging. Go to the Pre-pay Nbr field and press F3. Do the pre-pays show in the list?
Can you find these pre-payments in the Document Maintenance screen?
Let me know what you find.
#1
André Arnaud de Cal...
293,041
Super User 2025 Season 1
#2
Martin Dráb
231,860
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
