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
thank. ..
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 ..
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,522 Super User 2024 Season 2
Martin Dráb 228,441 Most Valuable Professional
nmaenpaa 101,148