Automated Posting of Statements in D365 for F&O

In the world of Microsoft Dynamics 365 Finance and Operations (D365F&O), the proper functioning of the Retail Statement feature is crucial. It is responsible for facilitating the seamless flow of transactions from the point of sale (POS) into D365F&O HQ.

In this blog, we will explore the steps to create a batch job that automates the process of calculating and posting statements, providing a streamlined and efficient approach to retail operations management.

When utilizing shift-based statements within D365F&O, the calculation of the statement occurs precisely at the time of shift closure. 

It is crucial to recognize that this method can be intricate, but I highly recommend embracing it.

After ensuring that the statement is error-free, it will be published and a sales order invoice will be created.

1. Create a new batch job from scratch manually

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

I have decided to merge the process of "upload of transactions, post inventory, calculate statement and post statement" into a single batch job, without taking any content from other sources.

Click on each task, Under the general tab. Set ignore task failure to YES.

Do this process for all task.

To set the parameters for each task, such as the organization notes that need to be included, click on the "parameters" option.

For Post inventory, Calculate Statement, and Post statement, add the necessary parameters according to their sequence.

To maintain the proper order of tasks, add conditions to each batch job, ensuring that the previous step is completed before the next one starts. 

This approach will optimize the workflow, minimize errors, and increase efficiency.

Set the recurrence option to determine the frequency of the batch job. 

For instance, the recurrence can be set to start when the statement is completed.

Set the recurrence option to determine the frequency of the batch job. 

For instance, the recurrence can be set to start when the statement is completed.

By automating the statement calculation and posting process, retailers can streamline their operations and identify any discrepancies or issues with the master data, which can be resolved promptly.

In summary, following these steps will enable you to create a batch job that automates the process of calculating and posting statements in D365F&O, leading to improved retail operations management and increased efficiency in your day-to-day business activities.

If you're interested in learning more about D365 finance and operations, be sure to check out my YouTube channel. I offer module-wise training series that covers everything from the basics to advanced techniques.