web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / dynamics sl ar posting...
Microsoft Dynamics SL (Archived)

dynamics sl ar posting to incorrect period

(0) ShareShare
ReportReport
Posted on by Deb Davis 1,515

I have a client that posted a good number of invoices in AR module to an incorrect period. The transaction has not  been posted in GL. Are there queries that can be run to update the period rather than entering credits for the incorrect period and re-entering the invoices? There are just too many transactions to manually reverse.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Jeffrey Ricafort Profile Picture
    Jeffrey Ricafort 135 on at

    Update the period to post (perpost) of the following tables (ArTran, ArDoc, Batch).

    scripts:

    1. ArTran

    Update Artran set perpost = 'YYYYPP' where batnbr in ('BBBBBB')

    2. ArDoc

    Update ArDoc set perpost = 'YYYYPP' where batnbr in ('BBBBBB')

    3. Batch

    Update batch set perpost = 'YYYYPP' where batnbr in ('BBBBBB') and module = 'AR'

    Run the script in the appropriate application database.

    The script assumes that the periods where to post the transactions fall on the same year and they are not yet posted in the general ledger (status is 'U').

    Make sure to backup your database before running the scripts in SQL and if possible, deploy the resolution in a test environment before deploying it in the live database.

    After running the script, check the transactions in SL.

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at

    What else would need to be done if ther period is in the incorrect year. The customer posted transactions with a 2012-03 rather than a 2013-03 perpost.

  • Verified answer
    Jeffrey Ricafort Profile Picture
    Jeffrey Ricafort 135 on at

    include in the update script 'fiscyr' field of ArTran & GLTran tables.

    1. ArTran

    Update ArTran set perpost = '201303', fiscyr = '2013' where batnbr in ('BBBBBB')

    2. GLTran

    Update GLTran set perpost = '201303', fiscyr = '2013' where batnbr in ('BBBBBB') and module = 'AR'

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at

    Thank you for you quick response.

  • Jeffrey Ricafort Profile Picture
    Jeffrey Ricafort 135 on at

    Does it resolve your concern already?

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at

    Yes. Thank you.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans