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 / 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
I have the same question (0)
  • Suggested answer
    JanelleM Profile Picture
    JanelleM on at

    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

  • Suggested answer
    aMr Hash Profile Picture
    aMr Hash 65 on at

    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 ..

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 291 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans