Finance | Project Operations, Human Resources, ...

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

(0) Share

Report

Posted on by aMr Hash

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

Posting Setup Settings during that post
Cash Receipt voided window

thank. .. RWD-error-Accounts-Receivables--630-EGP-_2D00_-Payment-_2300_-PYMNT2020_2D00_H014156.PNG

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

Suggested answer

aMr Hash 65 on at

Like (0)

Report

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 on at

Like (0)

Report

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