You’re offline. This is a read only version of the page.
40
Hello,
How do you get rid of PP documents that continue to show on the Vendor Period Trial Balance? I've verified the APDoc table and found that the following fields have are all been properly updated but the document still shows.
OpenDoc=0, PerClosed=201505, DocBal=0, CuryDocBal=0, Selected=0
I also checked the APAdjust table AdjAmt field for the document and it shows 0.
This is happening in SL2011 FP2.
Thanks,
Dan.
*This post is locked for comments
Dan, I now follow what you were first saying. I had not related "PP" to mean pre-payment. I do not run across the use of pre-payment entries with my clients so I am not sure if I can answer your question. I do know that this report uses a complex view called vr_03651 that calculates the document balance based on several criteria. I would suggest that you use SQL Management to show the text of that view (sp_helptext vr_03651) and follow the logic of that view to get your reason that the document is still showing a balance. There are several other fields (beyond what you indicated in this post) that come into play with this view.
Thanks Rick for the suggestion. However, the AdjAmt in APAdjust can actually be zero especially for Prepayment doc types. When you apply a prepayment to a voucher, there'll be a record that links to the voucher no. (AdjdRefNbr) the check no. (AdjgRefNbr) that was used to pay the prepayment. This record has the AdjAmt greater than 0. There'll also be a record that links to the PP voucher no. (AdjdRefNbr) the check no. (AdjgRefNbr) that was used to pay the prepayment. This record has the AdjAmt equal 0. Both records will have the same manual check batch number.
That's what I was able to observe.
Dan,
Unless you had a typo in your post, the AdjAmt in the APAdjust table should be a value greater than zero. It is normally the amount that was applied to the voucher or credit adjustment. If the value is, indeed, 0 then there is the source of your problem in that the period trial balance report recalculates the voucher balance based on the records in APAdjust. The other fields in APAdjust that can play a part are the PerAppl and the AdjPerPost fields. If the AdjAmt is 0.00 then that suggests that either someone modified the APDoc fields or something went wrong when the check that paid the voucher was created.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,104
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (