Skip to main content

Notifications

Microsoft Dynamics GP forum
Suggested answer

system accpet to post sub ledger date although that year not setup in fiscal periods

Posted on by 65

Hello..

during posting one of our receivables cash receipt in

Sales to be settled as client cash deposit

there is mistake done when  posting that receipt we found

that post date for cash receipt  as " sub ledger " date

Was 22-03-5020 (Entered the data by mistake) and GL posting date was in 22-03-2020

we wonder how system accepted that date on sub ledger although  that year not setup in fiscal periods

may be system accepted that date due to  there's something marked in posting setup settings ?? I don’t know..!!!!

& when trying to void that cash receipt... System can't do and this message appeared “a fiscal period for this date has not been set up."

so how to solve this problem ,, how Prevent a recurrence of this error in future ..

& how to setup date in system to display Year as YYYY no YY

kindly find attached screen shot for further clarification

  1. Posting Setup Settings during that post
  2. Cash Receipt voided window

 thank. .. Posting--Setup-_2E00__2E00_.pngRWD-error-Accounts-Receivables--630-EGP-_2D00_-Payment-_2300_-PYMNT2020_2D00_H014156.PNG

  • Suggested answer
    aMr Hash Profile Picture
    aMr Hash 65 on at
    RE: system accpet to post sub ledger date although that year not setup in fiscal periods

    Hi.. Janelle

    fist thanks so much for your prompt reply ....

    tell me .. you mention that i can correct the incorrect voided date through SQL depending upon where data is stored.........so that cash receipt is still OPEN so could you write down SQL Code and detailed steps to try to process via SQL

    you mention also Professional Services Tools Library where to get that tool, & is it free ??? is it applicable for MS Dynamcis GP 2010 ???

    once againe thank you so much ..

  • Suggested answer
    JanelleM Profile Picture
    JanelleM on at
    RE: system accpet to post sub ledger date although that year not setup in fiscal periods

    Hi,

    Thank you for using Microsoft Communities.

    If there is a date which does not have a fiscal period setup, you should be getting a message indicating the fiscal year has not been setup.  I tested this with an RM payment void date in the latest version as well as GP2016 and everything was working correctly.  If this is something you can replicate with the void date field, I would recommend creating a support case.

    To correct the incorrect voided date, you can look to update the voided date field(s) as needed through SQL depending upon where the data is stored (OPEN or HIST), but you would want to test this first to ensure everything is correct before making any updates in live.

    In the Professional Services Tools Library, there is a tool called Doc Date Verify you can look into activating as a second data validation check on certain windows you might want to look into.

    There are a couple of DEX.INI switches (beginning with StdInternationalInfo.....) that you can try regarding changing your date format.  I have pasted a link regarding the DEX.INI switches from the Microsoft Communities site below for your convenience.

    community.dynamics.com/.../dex-ini-switches-my-complete-list

    I hope this information helps.

    Thank you,

    Janelle

    Microsoft Support

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans