Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Answered

dynamics sl ar posting to incorrect period

Posted on by 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.

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at
    Re: dynamics sl ar posting to incorrect period

    Yes. Thank you.

  • Jeffrey Ricafort Profile Picture
    Jeffrey Ricafort 135 on at
    Re: dynamics sl ar posting to incorrect period

    Does it resolve your concern already?

  • Deb Davis Profile Picture
    Deb Davis 1,515 on at
    Re: dynamics sl ar posting to incorrect period

    Thank you for you quick response.

  • Verified answer
    Jeffrey Ricafort Profile Picture
    Jeffrey Ricafort 135 on at
    Re: dynamics sl ar posting to incorrect period

    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
    Re: dynamics sl ar posting to incorrect period

    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
    Re: dynamics sl ar posting to incorrect period

    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.

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans