BeyondERP.Newsletter
Menu

Job page · Retail and Commerce

Calculate financial statements in batch

A batch job that collects unposted financial (tender and cash management) transactions from closed shifts into new financial statements.

Business process
Post store end-of-day financial statements in Dynamics 365 Commerce
Menu item
RetailEodFinancialStatementCalculate_Batch
Show what matters for
PAGE GUIDEWhat the page does and how to use it7 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA batch job that collects unposted financial (tender and cash management) transactions from closed shifts into new financial statements.
What you do hereUse this page to schedule end-of-day calculation of financial statements, which reconcile counted tender amounts against transaction amounts.
Calculate financial statements in batch page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

Business processManage sales orders › Manage store operations › Post store end-of-day financial statements in Dynamics 365 Commerce
Menu pathRetail and Commerce › Retail and Commerce IT › POS posting › Calculate financial statements in batch
Used next byPost financial statements in batch Microsoft Learn
Related pagesStatements Microsoft Learn
End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

When to run it

When to run itAt the end of each business day, after the shifts of the stores are closed.
How oftenOnce per business day, as an end-of-day process.
Batch settingsA recurring daily batch job per store group, scheduled after store closing and before Post financial statements in batch.
What the output showsNew financial statements per closed shift with tender declaration, payment, banked tender and safe tender transactions, and the difference between counted and transaction amounts. A shift that's missing was usually not closed yet.

Source: Microsoft Learn

Steps from Microsoft

  1. Go to Retail and Commerce > Retail and Commerce IT > POS posting > Calculate financial statements in batch.
  2. On the General tab, choose the Organization hierarchy and add the stores whose end-of-day financial statements you want, moving them to Selected organization nodes.
  3. Set the start and end times around the expected end of the business day: financial statements only use the Shift closing method and pick up closed shifts only.
  4. Make sure the Retail statements - Trickle feed feature is enabled; this job belongs to trickle feed posting.
  5. After it runs, open the new financial statement in Store financials and review the tender details: counted amounts from tender declarations against transaction amounts.

Source: Microsoft Learn

Test checklist

  1. Each closed shift of the selected stores is on a financial statement.
  2. Counted amounts match the tender declarations from POS.

Source: Microsoft Learn

Solution architect

4Design impact

Can it be undoneYes, before posting: A calculated statement isn't posted yet. Use Clear statement in the Functions group to release its transactions before you post. Microsoft Learn
If you change it laterCreates financial statements and marks the unposted tender and cash management transactions of closed shifts with the statement. Microsoft Learn
Technical architect

5Technical

Menu itemRetailEodFinancialStatementCalculate_Batch Checked in Dynamics 365
FormRetailOperatingUnitPicker Checked in Dynamics 365
Roles to set it up and use itTo use itRetail service RetailServiceRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerGive people one of these roles. On this system, 3 roles can run this page.Checked in Dynamics 365
Developer

6Developer

Open it by URLhttps://<your-environment>/?mi=RetailEodFinancialStatementCalculate_Batch
Everyone

7Sources