Period close with LS Retail data: the pre-close checklist and the missed-day recovery

Period close · 6 min read

Business Central does not force you to close periods — period-end work there is a set of optional activities. Retail adds a layer those generic checklists never mention: every store, every day, has to arrive as a posted statement before any lock makes sense. Lock the dates first and the one store that forgot a Tuesday turns a routine close into an excavation.

The three locks are not interchangeable

Three different controls decide whether a late retail posting can still land in the period. They live in different places and block different things, so the order you apply them matters:

The decision rule that follows from this: never apply a wider lock while a narrower problem is still open. Allowed posting dates are the last lock, not the first, because they affect every user and every module — while an unposted statement is a one-store problem that should be finished, not locked out.

Pre-close checklist: prove every store and every day is in

Work the gates in order. Do not move to the next gate until the current one is clean. The daily routine itself is covered in the end-of-day reconciliation guide; this checklist is the period layer on top of it.

1. Confirm the daily closes happened. For each store and each day in the period, the end-of-day or tender declaration was finished. Statements are calculated and posted after those declarations, so a skipped declaration means a day with no statement.
2. Hunt for transactions that belong to no statement. A statement's transaction starting date includes all transactions in the store not already belonging to a statement. If a day was missed, its transactions are still sitting unclaimed — calculate a statement for the store and date range and see what it picks up.
3. Use the missing-transaction check where it is enabled. If the store's closing method is by POS Terminals and the Functionality Profile has Check for Missing Transactions selected, statement calculation compares the highest transaction number in the central database against each POS terminal's database and warns — with a comment on the statement — if transactions are missing. Solve those before calculating for real.
4. Calculate the remaining statements and balance them. Before posting, the Difference Amount should be 0.00 on every line and the Counted Amount should equal the Trans. Amount. A statement that does not balance does not get posted "to fix later."
5. Post every statement dated in the period, for every store. Stores marked One Statement per Day should show one posted statement per trading day. Count them.
6. Finish the Business Central period work. Post all sales invoices, credit memos and return orders for the period, post cash receipt journals, update and post recurring journals, and make the remaining G/L adjustments.
7. Reconcile receivables to the general ledger so the retail sales figures and the customer ledger tell the same story.
8. Prepare inventory to close. Run Adjust Cost – Item Entries. An inventory period can only close when there are no open outbound item ledger entries — negative inventory — in the period, and when the cost of all items has been adjusted. Outbound quantities from sales must be applied to inventory that actually exists.
9. Close the inventory period on the Inventory Periods page. Closing is recorded in an inventory period entry with the time, date, and the user who closed it.
10. Apply the date lock last. On the General Ledger Setup page, move Allow Posting From to the first day of the new period. Then run the period's financial reports.

Recovery: a store forgot to close a day

The locks are already on and a store finds an unclosed day in the closed period. Resist the urge to "fix it with a journal." The transactions exist; they were simply never statemented. Recover them through the normal path, with a controlled exception:

1. Scope the problem exactly. Which store, which date, which terminals? Confirm the day's transactions are present in the central database — the missed statement starting date will pick up every transaction for that store not already on a statement.
2. Open a user-level exception, not the company-wide lock. On the User Setup page, give the one user who will post the recovery an allowed posting range that covers the missed date. User Setup dates overrule General Ledger Setup for that user, so the rest of the company stays locked.
3. Reopen the inventory period if it is already closed. Inventory periods can be reopened when posting into a closed period is needed; reopening creates its own inventory period entry, so the exception is on the record.
4. Calculate and post the missing day's statement exactly as in the daily routine: counted amounts in, Difference Amount at 0.00, then Post Statement.
5. Re-run Adjust Cost – Item Entries. The late statement moved inventory, and the inventory period cannot be re-closed until item costs are adjusted again.
6. Re-close and re-lock. Close the inventory period again, remove the User Setup exception, and confirm the General Ledger Setup dates are back to the new period.
7. Leave a note. The close, reopen, and re-close are each recorded with time, date, and user in the inventory period entries — make sure someone reading them later also has the one-line reason on the statement or in the close file.

What success looks like

• Every store has a posted statement for every trading day in the period — counts match the calendar.
• No open statements and no unclaimed transactions dated in the period remain.
• The inventory period shows as closed, with its closing entry recorded.
• General Ledger Setup Allow Posting From is the first day of the new period, and no leftover User Setup exceptions cover the closed period.
• The period's financial reports run clean against the reconciled figures.

FAQ

Does Business Central force a period close? No. Business Central does not force you to close periods; the period-end activities are optional processes. The discipline has to come from your own checklist — which is exactly why the retail gates above need an owner.

Can a closed inventory period be reopened? Yes. Inventory periods can be reopened to post in a closed period, and both closing and reopening create an inventory period entry recording when it happened and who did it.

A store uses One Statement per Day — does that change the recovery? The program automatically fills the transaction ending date from the starting date for such stores, so the late day calculates as a single-day statement, the same shape as the days around it.