This article walks through the manual steps for creating, calculating, and posting a Retail Store Statement. Also there are batch jobs that can be configured for the same tasks. To complete this procedure, you must have transactions that were completed in POS and then pulled into Microsoft Dynamics AX Retail.
In Microsoft Dynamics 365 Retail, the statement posting process is used to account for the transactions that occur in the Cloud point of sale (POS) or Modern POS (MPOS). The statement posting process utilizes the distribution schedule to pull a set of POS transactions into the headquarters (HQ) client. The parameters that are defined on the Retail parameters and the Stores pages are used to select the transactions that are pulled into individual Retail Store Statement.
- Go to All work-spaces > Retail store financials.
- Click New Retail Store Statement.
- In the Store number field, select the drop-down button to open the lookup.
- In the list, select the link in the selected row.
- Click OK.
- Setup group has the settings that control which transactions are included in the statement and how they are grouped into statement lines. You can also open the Setup group and change these settings, or you can use the defaults.
- The Statement method field defines how the statement lines will be grouped.
- Select a staff member or a register if calculating a statement only for the specific staff member or register.
- In the Closing method field, select an option.
- Click Calculate statement.
- Click Yes.
- After calculating the statement, there should be the lines created with total amounts for each payment method and statement method that was used.
- Enter a counted amount in each line if needed to be entered or updated. The counted field is populated with the amounts from tender declarations done in POS.
- Click Post Retail Store Statement.
- Click Close.
- Select Retail and commerce > Channels > Retail store financials.
- Click the Posted statements tab.
These steps demonstrates the configurations for Retail parameters that affect how Retail statements get created and posted. This procedure uses the USRT demo company.
- Select Retail and commerce > Headquarters setup > Parameters > Retail parameters.
- Click the Posting tab.
- Click “Yes” if you want to post periodic discount amounts specifically.
- Select the “Standard” to use the default accounts, or select the “Periodic” if you want to define which account to use for each periodic discount.
- Click “Summary” if the inventory lines should get aggregated whenever possible.
- Select “Yes” if the Invoices and the Payments should get automatically settled as part of the Statement posting process.
- Click “Yes” if the Safe drop transactions should get aggregated.
- Select “Yes” if the Bank drop transactions should get aggregated.
- Click “Yes” to turn the aggregation on for the Statement posting.
- Select “Yes” to create and process the orders in parallel when statements are posted.
- Enter maximum orders to be processed in each batch job task.
- Click Save.
These steps demonstrates the configurations for Retail store payment methods, which affects how the Retail Store Statement gets created and posted. This recording uses the USRT demo company.
- Select Retail and commerce > Channels > Retail stores > All retail stores.
- Inside the list, search and select the desired record.
- Inside the list, click the link in the selected row.
- On the Action Pane, click Set up.
- Click Payment methods.
- Expand or collapse the Posting section.
- Click Edit.
- Select whether the amounts received for this payment method should be posted to a ledger account or the bank account.
- Select the account to which the amounts received for this payment method should be posted to.
- Click an account to post the possible differences between the total transaction amount received and the amount counted for this payment method.
- In this field you can enter the amount to control when the difference amount should be posted to another difference account. You can use this to track big differences.
- Select an account to post possible differences between the total transaction amount received and the amount counted, when it exceeds the value that is defined in the “Maximum difference amount” field.
- Select “Yes” to post bank drop amounts to a separate account.
- In this field you can select whether the bank drop amounts should be posted to a ledger account or a bank account.
- Select the account to post bank drop amounts into.
- Select the bank transaction type to use when the posting bank, drop amounts to the bank account.
- Click “Yes” to post safe drop amounts to a separate account.
- Select whether the safe drop amounts should be posted to the ledger account or the bank account.
- Click the account to post safe drop amounts into.
- Click Save.
Locus IT has worked with RMS industries to develop, implement, and improve on their ERP solution. We also provide Dynamics RMS training, Dynamics RMS implementation and Retail Store support. For more details please contact us and we’ll be happy to consult with you and refine your current system or create a customized solution.