Month end

Hi Guys,
Just wondering what other businesses do around month end for cut off’s in processing transactions.

We run almost 24/7 and we need to stock-take at month end. The issue that keeps occurring is we have transactions that occur on the cut off date (after we have closed the period) and we don’t want these transactions appearing in last months period data.

Does anyone else have this issue? I know for example when we used to use Oracle it would just say last month is closed therefore this transaction is going into the next month automatically where as epicor blocks the update and you need to change the date of the transaction.

I think what you are looking for is to set the earliest apply date (in General ledger --> General Operations). It will prevent anyone from back dating any transaction based on this date/period. You can apply this to all transactions or setup for certain modules etc.

Hey Paul,
Yeah we use earliest apply date but this blocks the transactions which means we can’t put them in for a different period on the same date.
We essentially stop processing at 6am for an hour or two to do stocktake and then start back up at 10am on the same day.

But isn’t that you don’t want people to be able to back date transactions in the prior period once you have closed off… if this is the case then this option will stop that.

Yes it will and it does. The issue is it doesn’t allow transactions to happen in the next month.

I suppose to put it more simply. Is there a way to do transactions from two different periods in one day? Each going into two different months.

Agree with others, that you must have a point where employee’s are aware of month-end trans being for a new month in a 24-7 shop.

PROBLEM: Cutting off MFG trans (labor) and running CAPTURE routine, but enabling supervisors to correct labor-tran mistakes?
During the month, run capture on WEDNESDAY for prior week Sun-Sat. Therefore, time-entry clean-up must be done by Tuesday. As mth-end approaches, requirement to clean-up trans becomes more pressing, mandatory. If Friday is last day of mth, labor for mon-thurs MUST be clean by noon?
Issue: Managing CAPTURE, labor-clean-up, and Earliest apply date (EAD)!
If you are 5-5-4… the benefit is mth-end can be a Sat of Sun.
If not, then it gets a bit ugly. In any case, pick a lunch time or break (hopefully within 3rd shift)… advise employee’s to complete all transactions up-to that point.
Coordinated, execute capture, run Stk-status and change EAD (for the modules that need to be locked-down)!
You can actually manage the earliest apply date per specific modules/business areas or transaction type!!! ~hint!~
IF any prior period trans are required, you can OPEN that module via changing Earliest apply date, process the transaction (may need to run capture again) then change E-A-D!

Depends what transactions you are meaning - Apply Date is what’s controlling period based posting in Epicor. In the screens where Apply Date is shown, you can change this independently from TranDate to control periods.

Also, check Book settings. There is an option that says whether to block a transaction, warn and allow, or auto move to next period.

1 Like

Are you trying to post in the future period on the last day of the month? I agree with others here as well, but I think we are missing some level of detail from you.

1 Like

Perfect mark! Book settings - autocorrect was exactly what i was looking for.
It will now push the transactions into the open period!
Thank you!