Automated statement Posting in D365 Retail (Commerce)
The Retail statement functionality in D365F&O is the process that puts everything together and makes sure transactions from POS flows into D365F&O HQ.
If you are using shift-based statements, a statement will be calculated when the shift is closed. Using shift-based closing can be tricky, but I highly recommend doing this! After the statement is calculated and there are no issues, the statement will be posted, and an invoiced sales order is created.
1. Manually create a new “blank” batch job
2. Click on “View Tasks”.
3. Add the following 4 classes:
| Class Name | Task Description |
| RetailCDXScheduleRunner | Upload channel transaction(P-job) |
| RetailTransactionSalesTransMark_Multi | Post inventory |
| RetailEodStatementCalculateBatchScheduler | Calculate statement |
| RetailEodStatementPostBatchScheduler | Post statement |
Here I choose to include upload of transactions, post inventory, calculate statement and post statement into a single batch-job.
Click on each task, Under the general tab. Set ignore task failure to YES.
Do this process for all task in the job.
And click on the “parameters” to set the parameters on each task, like what organization notes that should be included.
Add this parameter to Post inventory, Calculate Statement, Post statement.
On each batch task I also add conditions, so that the previous step needs to be completed before the batch-job starts on the next.
Provide condition to Post inventory, Calculate Statement, Post statement according to there sequence.
Click on recurrence and set the recurrence that when the statement done.
The benefit of this is that when you are opening the statements workspace you mostly see statements where there are cash differences, or where the issues on master data.
Now you will able to post statement automatically as per set time in recurrence.
Hope this helps!
