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 / Finance | Project Operations, Human Resources, ... / system accpet to post ...
Finance | Project Operations, Human Resources, ...
Suggested answer

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

(0) ShareShare
ReportReport
Posted on by aMr Hash 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

Categories:
Microsoft Dynamics GP
  • 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

Ramesh Kumar – Community Spotlight

We are honored to recognize Ramesh Kumar as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 565

#2
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 402 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans