Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL (Archived)

Period Closed in AP Document Maintenance

Posted on by Microsoft Employee

User just notified that a voucher was entered and processed and in the Document Maintenance form, the Period Closed is 08-2019 instead of 08-2015.  Getting ready for an audit and wanted to find out the best/fastest way to correct this?  Can this be done through the back end without effecting anything else?  Not familiar with what this period does.

Thanks in advance for all help and suggestions.

*This post is locked for comments

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Period Closed in AP Document Maintenance

    I would highly recommend consulting your SL consulting partner, as there are numerous tables & fields that need to be considered to truly correct this issue. And don't forget the cause of the 201908 Period-to-Post - the AP check batch that paid the voucher.

    AP_Balances contains the 1099 balances for the vendor. You would also want to review & adjust the APHist table, which contains Summary Vendor History by Fiscal Period & Fiscal Year.

    If your partner is unable to assist, I'd be happy to - contact me offline.

    John

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Period Closed in AP Document Maintenance

    Ok, looking through the tables, APDoc does have the PerClosed of 201908.  APTran PerPost of 201508 (this is correct),  APAdjust AdjgPerPost of 201908 and PerAppl or 201908.  These are the dates that need to be corrected right?  What about AP_Balances, what is the best way to correct this table?

  • John_Joyce Profile Picture
    John_Joyce 1,040 on at
    RE: Period Closed in AP Document Maintenance

    This very likely means that the check batch that this voucher was paid-in was posted to Period 08-2019 (the release of the check would "close" the voucher). Look for that AP Check Batch to see how many other checks & related vouchers might be affected.

    You likely have an Unposted batch for that 2019 period, so your GL balances in Cash/AP as of Period 08-2015 would be incorrect. This can be corrected via a GL entry.

    If the check has been cashed, then AP can be corrected via the back-end by updating APDoc, APTran, APAdjust and AP_Balances.

    In the unlikely event the check is still O/S, it could be corrected in the AP module by voiding it (to period 08-2019) and re-issuing it (to period 08-2015). But you'd want to get the original check back from the vendor.

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