Skip to content · Zum Inhalt

Post a Day's POS Takings to the Financials

The sales of a register are transferred to Business Central as an import and posted through the journals set up for the register. This chapter covers the finance validations, checking the import of a day and posting it.

Before you start

  • The Base Setup Wizard (chapter 1) created the cash register HAUPT / TEST with its posting and job queue settings.
  • The tenders of register HAUPT / TEST have their G/L accounts: cash 1810 (cash-to-bank 1610), card 1830, voucher 1900, unknown voucher 1950, gift card 1990, difference 1820.
  • The finance validations POS-001 to POS-004 exist and are activated (see the next task).
  • The administrator is the Business Central user who posts general journals; the finance posting runs with this user's posting rights.

Set up the finance validations

  1. Search for Finance Validations and open it.
  2. Choose New to create a validation for the story: Code POS-005, Validation Type Compare Sale Line Turnover, Description Compare sale line turnover.
  3. To let the validation apply to specific G/L accounts, enter them in Account No.; enter Minimum Amount if the account should only trigger the check above an amount.
  4. To limit the validation to specific registers, add Location and Cash Register in the Cash Register part; without such an assignment the validation applies to all cash registers.
  5. Choose Activate so the validation actually runs.

The validation created for the story, with its status changed by Activate.

Note: A validation only runs while its status is Activated; Deactivate turns it off again, for example while you change it.

Note: A validation of the type Minimum Number of Lines or Balance is set up the same way: in its Assigned Account part enter Account No. and Minimum Number of Lines (the import must have at least that many lines on the account), or turn Balance Validation on so the account's balance must be zero after posting. A balance of zero means a carry-over account really was carried through.

Check the import of the day

  1. Search for BE-POS Import List and open it. It lists every POS document whose finance import has not been posted yet.
  2. Find the row of your register and day, for example HAUPT, TEST, the day; the Document No. is the POS document number and Booking Status shows where the import stands.
  3. If you are unsure an import can be posted, choose Check Status; it re-checks all open imports against the activated validations.

The Finance Import List with the import of HAUPT / TEST.

Note: Once a POS receipt is registered for the financial import, it appears in the import header: the import row of that document shows up in the BE-POS Import List.

Post the import

  1. Double-click the import row to open its card.
  2. Look at the journal lines on the card. The POS generates a multi-line booking for every transaction (at least a booking and a counter line, linked by Document No.); you may correct, delete or add lines here, and a line carries the POS receipt and register it came from.
  3. Choose Preview Posting to see the result without posting.
  4. Choose Test Report to run the journal with test reporting first.
  5. If the lines are shown compressed, Decompressed Lines shows the individual journal lines.
  6. Choose Post. The import's journal lines are posted and its status changes to Processed.

The journal lines of the POS import, carrying the POS receipt and register tags.

Note: Use Post for the normal daily close. Post and Print posts the same journal and also prints the posted lines like the test report, so choose it when you want a paper copy of the journal for the day's file. Post is hidden when the import is already Processed, so the same journal cannot be posted twice.

Note: The Post action runs the activated finance validations first; if one of them fails, posting is blocked and the error is shown in the Error Message field of the card.

Sales documents keep their POS tags

The sales documents of a POS sale are marked so you can recognise them later. Search for Sales Orders, open the order of a POS sale and see that it is marked as a POS document and carries the receipt, the register and the process it belongs to.

An open sales document marked as a POS document with its receipt, register and process.

What happens

  • The POS document's journal lines are posted to the financial ledger, moved into the archive and marked as processed.
  • The import row disappears from the BE-POS Import List; Processed Import List shows it.
  • Navigate on the import card opens the G/L entries that carry the POS document number.
  • Preview Posting shows the journal lines without posting them; Test Report runs the journal with test reporting.

If something goes wrong

  • "The import... could not be posted:..." - a finance validation or the posting itself failed. Open the import card and look at the Error Message; fix the cause (for example a wrong amount on a journal line), then Check Status and post again.
  • "No posting lines exist for the import..." - the import has no journal lines yet; wait until the sales data of the day has been imported, and check the register's posting settings in chapter 1.
  • "The import... has no general journal batch." - the import has no journal batch name; check the posting settings in chapter 1.
  • "The import... is already posted; posted lines are not generated again." - you used Reset on a posted import. Posted lines are final; correct a mistake with a new manual journal batch.
  • "No ledger entries exist for the import..." - Navigate was used before the import was posted.