Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Period Sensitive AP
Microsoft Dynamics SL (Archived)

Period Sensitive AP

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

 

I have two vendors on my Period Sensitive Aged AP that have negative amounts with a Doc type of CK.  This has been a reconciling item for months now and I need to get it removed.  The vendor balance is $0.  What can I do to clear this up?

 

 

 

Vendor                  Name              Master    Doc   Vendor/       Disc             Due         Pay                                                                              Days Past Due

Ref Nbr      Inv Nbr        DocType/RefNbr    Type  Doc Stat      Date             Date        Date                          Current           1 To 30                         31 To 60             61 To 90                Over 90    Balance

 

EENO1010           Lxxxxxxxx                                    A

 

005007                                                     CK       C                                                                                     0.00               0.00                                   0.00                                                          0.00 ‑221.41                                                                           ‑221.41

 

                                                                Vendor Total                                                            0.00               0.00                                   0.00                                                                              0.00                                                                    ‑221.41          ‑221.41

 

EGIA1030            Mxxxxxxx                                      A

 

005009                                                     CK       C                                                                                     0.00               0.00                                   0.00                                                          0.00 ‑189.54                                                                           ‑189.54

 

                                                                Vendor Total                                                            0.00               0.00                                   0.00                                                                              0.00                                                                    ‑189.54          ‑189.54

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Sensitive AP

    Elaine, interesting suggestion but I would think that the posting period should not affect the document balance in this manner.  If you run a period sensitive aging and the check document is a future period document it should not even show on the report (unless the report has a logic error that I am not aware of).  It is correct that the period sensitive aging computes the document balance based on the posting period specified so I suppose there could be a logic error in that process.  I suggest that the user runs the standard AP aging and see if this check has a negative balance or not.  They could also run the vendor trial balance and see if that check shows with a negative balance.

    Thinking along your line, it might be interesting to construct a test where a current period check is paying future documents.  If the real check document balance is 0.00 then the issue has to be in the apadjust records for that check whereas the period sensitive aging is getting confused when trying the computer the check document balance.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Sensitive AP

    When I indicated 'xxxxxx' I was meaning that you substitute in the actual check number in place of the 'xxxxxx'.

    When I say to run queries I am talking about a query under SQL Management Studio as opposed to a Quick Query though that might work provided that it will show the fields I am talking about.  Of course, you can only run a SQL query if you have access to that tool and you know how to run such queries.  You should not "experiment" in SQL Management Studio as it will leave no audit trail and can do harm to the data if you are not sure what you are doing.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Sensitive AP

    I would look at the perpost of the voucher and the check.  I am thinking that the voucher will have a future period to post.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Sensitive AP

    The Reference Number is 005007 for vendor EENO1010 and 005009 for vendor EGIA1030.  the xxxxxx is my attempt to block out the vendors name for confidentiality purposes. when you say to run a query do you mean a quick query or something else?

    Thank you

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Sensitive AP

    This is an unusual situation.   As you can guess, a check document should never have a negative balance.  Even voiding a check creates a new void check document so it cannot be the result of a duplicate void.

    The simple fix is to run an update query setting docbal and currydocbal to 0.00 but the actual cause could have left duplicate AP transactions or duplicate GL transactions.  I would want to check out several other things before taking this approach.  At the very minimum, run the following query:

    select * from aptran where refnbr = 'xxxxxx' and trantype = 'CK'

    'xxxxxx' would be your check number.

    A check should only have 2 APTran records.  One credits cash and the other debits AP Trade.  If you have more than these 2 then we need to determine why before taking any action.

    You could also run the following:

    select * from apdoc where refnbr = 'xxxxxx' and doctype = 'CK'

    You should only find one such record.  If you run

    select * from apdoc where refnbr = 'xxxxxx' and doctype in ('CK','HC','VC')

    that will tell you if there was some sort of void involved.

    the other question is whether you also run Cash Manager or Bank Recon.  If you do, I would look at your reconciliation activity regarding these 2 checks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans