AX 2012 R3 | Statement Posting| Part II: Retail Parameters and Batch Configuration
Hi Guys, Hope you are keeping up with RetailDAXing. I have started a blog series where we will go through different setup and ultimately the operation about Statement posting which is a key operation in Retail module. This is the 2nd part of my Statement posting blog series. In this blog we will see, few more setups required in Retail parameters and batch configuration.
The posting section in Retail parameters form is used to specify parameters that are used to post discounts, inventory updates, settlements, and other retail operations.
Discount specific posting
Select the Post periodic discount check box to enable periodic offers to be posted to individual ledger accounts defined on discounts. Periodic discounts include mix and match discounts, multi-buy discounts, and discount offers.
Select the ledger account type used to post periodic discounts. The options available are:
- Standard – If the account type is standard (i.e. the post periodic discount is unchecked) then the ledger accounts are disabled. Microsoft Dynamics AX for Retail uses the ledger account that is defined for inventory posting in Microsoft Dynamics AX.
- Periodic – If the account type is periodic then follow below steps to specify the ledger accounts.
a. Select the Discount general ledger account that is used to post discounts, configured in Retail > Common > Pricing and discounts > Discounts.
b. Select the Quantity discount general ledger account that is used to post quantity discounts, configured in Retail > Common > Pricing and discounts > Quantity discounts.
c. Select the Mix and match number general ledger account that is used to post mix and match discounts, configured in Retail > Common > Pricing and discounts > Mix and match discounts.
d. Select the Threshold discount number general ledger account that is used to post mix and match discounts, configured in Retail > Common > Pricing and discounts > Threshold discounts.
The gift card product from the product list which represents the Gift Card item that will be used as default at the stores. This is the product that represents the physical or electronic gift cards. The settings on the gift card product are used when statements that include gift card transactions are processed.
The gift card company which hold the outstanding liabilities of the issued gift cards.
The default journal name is set to post the inter-company transaction to transfer the gift card liabilities from the transaction Company to the gift card company defined above.
The default void journal name is set to post the journal in case the gift card is voided.
Select the Automatic settlement check box to automatically settle open invoices when a payment or credit note is updated. If the check box is cleared, you must settle accounts manually, either when you enter payments or later, by using open transaction editing.
The Aggregation section is used to select if aggregation should be applied to safe drops, bank drops and voucher transactions at POS.
- Select the Safe drop check box to aggregate safe drops at posting.
- Select the Bank drop check box to aggregate bank drops at posting.
- Select the Voucher transactions to aggregate voucher transactions at posting.
Note : If the Voucher transaction is checked then at the time of posting, the transactions being posted will be aggregated. These include sales revenue, taxes, customers, inventory transactions and more. This option speeds up the posting process and lowers the volumes of transactions created.
The Batch processing defines the batch process of statement posting from POS to Retail HQ can be optimized in performance with the following setup :
- The posting of the statements will happen in parallel if the Process request in parallel is ticked.
- The Maximum sales order per task can be set to limit the performance load during the parallel processing.
Manual or periodical (batch jobs) posting
To run the statement calculation processes for your stores automatically, based on a schedule, configure the batch process for each stage of the statement process as follows:
- Configure the calculate statement process to calculate the transaction sets for one store or all stores.
- Configure the post statement process to post the calculated statements.
- Configure the post inventory process to update the inventory for the stores when the statements are posted.
Calculate the statement. This step gathers the transactions lines by using criteria that you define for each store in the Retail parameters and Store forms. You must define the criteria that the system uses. You must also specify how the transactions are calculated. The calculate statement process uses the global number sequence. You can use the Transactions form to view a list of the transactions that were included in the statement before the calculate statement process is run.
A statement calculation uses tender declarations from the registers as the counted amount. Alternatively, you can enter the counted amount manually. The statement displays the difference between the sales amount for the transactions and the actual counted amount in all tender types. The statement is posted only if this difference is less than the maximum selected posting difference that is defined for the store.
When you calculate a statement, the calculation performs the following tasks:
- Any transactions that were not included in a previous statement calculation for the selected date range are marked.
- The total amounts that were tendered in the selected transactions are calculated. The results displayed on the statement lines is as per the Statement method defined on Store master.
To configure running the Calculate statement in batch, follow these steps:
- Click Retail > Periodic > POS posting > Calculate statement.
- In the Calculate statement form, select the store or a range of stores to configure the calculate statement batch process for and click Add.
- Click the Batch tab to configure the batch process. Click Recurrence to set up the frequency of the batch.
Post the statement. Sales orders and invoices are created for the retail sales in the statement. Cash and carry sales are aggregated onto one sales order and invoice for the default customer who is assigned to the store. Any retail sales that had a customer added to the transaction in Microsoft Dynamics AX for Retail POS generate separate sales orders and invoices, one for each unique customer. Payment journals are automatically created for the payments in the statement, and the inventory is updated for the POS store. If you selected the Automatic settlement option on the Posting tab in the Retail parameters form, payments are automatically settled against invoices.
To configure running the Post statement in batch, follow these steps:
- Click Retail > Periodic > POS posting > Post statement.
- In the form, select the store number to configure the post statement batch process for a single store or select multiple stores and click Add.
- Click the Batch tab to configure batch process. Click on Recurrence to set up the frequency of the batch.
Inventory update (batch only)
Inventory update is a process to update the inventory without posting the statement. This basically means that the physical inventory is reserved. Then at a later time when the end of day statement is posted, the financial side is posted (revenue, issue, consumption, tax and so on). Select the Detail level for inventory updates from the drop down list. The options available are:
- Summary: Inventory update will be generated by summarizing the inventory transactions until the point when the update is initiated by the user or a scheduled batch job. The transactions are summarized by store, warehouse and product.
- Details: Inventory update will be generated for every inventory transaction until the point when the update is initiated by the user or a scheduled batch job.
To configure running the Post statement in batch, follow these steps:
- Click Retail > Periodic > POS posting > Post inventory.
- Select the store number to configure the post inventory batch process for a single store or select multiple stores and click Add.
Note : To keep your on-hand inventory accurate, you should run this batch job frequently. For example, you can set the frequency to match the frequency with which you run the distribution schedule for job P-0001 for each store.
This is it for this blog, we will continue with the Statement posting in next blog.
Feel free to reach out for any clarifications. If you like my blog posts then comment and subscribe to the blogs.