Journal Entry Posting Error

Epicor ERP 9
1

Dear experts,

We are unable to post the Journal entry for your reference screenshot is attached

JV
JV1280×720 155 KB

Error:

Exception caught in: Epicor.Mfg.BO.GLJrnGrp

Error Detail

Message: Fiscal Year/Period can not be determined based on Apply Date [Line 1] BookID KSABOOK. FiscalCalendarID CALKSA. FiscalYear 2020. FiscalPeriod 5. ApplyDate 04/30/20
Fiscal Year/Period can not be determined based on Apply Date [Line 2] BookID KSABOOK. FiscalCalendarID CALKSA. FiscalYear 2020. FiscalPeriod 5. ApplyDate 04/30/20

Type: Error
Program: bo/GLJrnGrp/GLJrnGrp.p
Method: PostGroupJournals
Table: PostingProcess
Row:
Field:

Stack Trace

at Epicor.Mfg.Proxy.GLJrnGrpImpl.PostGroupJournals(String postGroupID, String& notAllPostedMessage)
at Epicor.Mfg.UI.Adapters.GLJrnGrpAdapter.PostGroupJournals(String postGroupID, String& notAllPostedMessage)

Inner Exception

ERROR condition: The Server application has returned an error. (7243) (7211)

Inner Stack Trace

at Progress.Open4GL.DynamicAPI.Session.runProcedure(String requestID, String procedureName, ParameterSet parms, Boolean persistent, Boolean internal_Renamed, Int64 procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.Session.runStatelessProcedure(String requestID, String fullProcedureName, ParameterSet inparams, Object procId, MetaSchema localSchema, Int32 stateModel)
at Progress.Open4GL.DynamicAPI.PersistentProc.runTheProcedure(String requestID, String procedureName, ParameterSet parms, MetaSchema schema)
at Progress.Open4GL.DynamicAPI.PersistentProc.runProcedure(String procedureName, ParameterSet parms, MetaSchema schema)
at Epicor.Mfg.Core.CallContext.CallContextPersistentProc.runProcedure(String procedureName, ParameterSet parameters, MetaSchema metaSchema)
at Epicor.Mfg.Core.CallContext.ProxyHelper.CallMethod(String methodName, ParameterSet parameters, MetaSchema metaSchema, BLConnectionPool connPool, Session connection, PersistentProc persistProc, CallContextDataSet callContextDataSet)
at Epicor.Mfg.Core.CallContext.ProxyHelper.CallMethod(String methodName, ParameterSet parameters, BLConnectionPool connPool, Session connection, PersistentProc persistProc, CallContextDataSet callContextDataSet)
at Epicor.Mfg.Proxy.GLJrnGrpImpl.PostGroupJournals(String postGroupID, String& notAllPostedMessage)

2

Check the fiscal calendar mapped to the GL book.“KSABOOK”
This error seems like the respective fiscal year and period is not available in the fiscal calendar CALKSA.

image

3

Fiscal Calendar is attached in Book maintenance for your reference screenshot is attached

Book
Book911×403 17.5 KB

4

Could you please check in the Fiscal Calendar Maintenance, may the respective fiscal year and period might not be there.

1 Like
5

Dear @prash172, I have checked that everything is there for your reference screenshot is attached

Fiscal Calendar
Fiscal Calendar797×302 14.6 KB

Fiscal Year
Fiscal Year1119×540 22.2 KB

Fiscal Period
Fiscal Period1530×478 34.1 KB

6

Has the period been marked as closed. Close Fiscal Period/Year. Also check your posting validation rules. Book Maintenance > Posting > Validation > Fiscal Period is Closed > “What is here” as a validation. Error or autocorrect.

7

We have set the Fiscal Period is Closed = Autocorrect with Warning for reference screenshot is attached below

Book
Book1008×410 21.4 KB

8

Can you give us another screen show showing the Apply Date in the Journal Entry Screen?

9

Journal Entry
Journal Entry873×681 364 KB

10

That pop up has the apply date, fiscal year, and fiscal period covered up. Can you move the dialog box over and send a screen shot, or send just a screen shot of the journal screen without the error?

11

Journal Entry
Journal Entry1280×720 103 KB

12

Sorry I know I continue to ask, but this picture looks OK for sure. Can you copy all of the details in the error and post it here? Also can you verify the General Ledger account details and setup for the one used in the journal?

13

The Reverse date is 5/1 and the apply date is 4/30. Are both periods open?

Does the Journal Edit say anything?

Charlie Smith

CRS Consulting Svcs

(860) 919-1708

CTCharlie@outlook.com

14

Dear @CTCharlie

The Reverse date is 5/1 and the apply date is 4/30. Are both periods open?

Yes, Both the periods are open.

Does the Journal Edit say anything?

No

15

Kindly give screen shot of the Journal Entry Group.

Based on the error some where it has stored fiscal period “5” where as the apply date is 30/4/2020.

16

Group
Group1067×575 26.2 KB

17

Are there any other transaction posted in the fiscal period “04” and “05”. Fiscal year 2020. ?

18

Finally we have Voided the legal number and deleted the group. After that we created the new Group and successfully posted.