Automated statement Posting in D365 Retail (Commerce) | CloudFronts

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.

Finance and Operations 
Save New Delete 
Configuration status Store Set up 
WM shift list 
Cha m el attributes 
attributæ 
method t. store 
account 
Bank drop 
Sum 
Copy 
Options 
ent met hods 
Cuh 
MOdes Of delivery 
Cha 
Stores 
HOUSTON 
: Houston 
Seardl for a page 
Fulfillment group essignment 
I Houston;USRTCentrl._, 
Statement/closing 
STATEMENT 
State mt m 
Sift 
day 
StMt —t 
Sum 
Miscellaneous 
ROUNDING 
Ming 
OPENING HOURS 
Rounding Difference 
MAXIMUM DIFFERENCE 
mnts shelf 
Tra 
CLOSING 
Date and time 
PO p.oduct filter 
BATCH OPTIONS 
End of day 
oomoo 
Post day 
Sp lit by Stat—t 
DEFAULT CHANNEL VERSIONS 
Retail pos

1. Manually create a new “blank” batch job

Finance and Operations 
Human resources 
Inventory management 
Master planning 
Organization administration 
Payroll 
Procurement and sourcing 
Product information 
management 
prodcxtion control 
project management and 
accounting 
Questionnaire 
Retail and Commerce 
Sales and marketing 
Service management 
System administration 
Time and attendance 
Transportation management 
Vendor collaboration 
les 
p Search for a page 
Change status Remove recurrervce 
Copy batch job 
Expand all Collapse all 
Workspaces 
Users 
Security 
Inquiries 
Deleted atta chrnents 
v Database 
Database information 
Database Log 
SQL index fragmentation details 
3 atch jobs 
Data cache 
User log 
> License 
Person search report 
> Security 
> License reports 
Setup 
periodic tasks 
Message processor 
start date'time 
28-02-2014 
09-01-2015 
02-02-2016 
13-10-2017 
30-03-2017 060818 
13-04-2017 23:51 
19-04-2017 
26-04-2017 
03-05-2017 0103:56 
10-05-2017 
01-06-2017 
„ 13-10-2017 
03-06-2017 
03-06-2017 
05-06-2017 
10-10-2019 
10-10-2019 
kti« 
Switch to legacy form 
by 
Admin 
sigitac 
del a-gani 
del agani 
del •gani 
del •gani 
delagani 
del a-gani 
hasingh 
hasingh 
hasingh 
Admin 
Admin 
Options 
by 
Admin 
Admin 
Comi»ny „ 
USMF 
USMF 
demf 
by 
Admin 
sigitac 
del agani 
del agani 
del agani 
del agani 
del agani 
del agani 
rubendel 
hasingh 
hasingh 
has in gh
Finance and Operations 
Save New Delete 
Batch jobs 
Switch to enhanced torm 
Job 
Statement postind 
Batch job 
p Filter 
Overview 
General 
Options 
S&duld st Mt 
05-03-2021 
09-01-2015 
28-02-2014 
02-02-2016 01:52:04 
13-10-2017 
30-03-2017 
13-04-2017 
19-04-2017 
26-04-2017 
03-05-2017 
13-10-2017 
01-06-2017 
03-06-2017 11:12:17 
03-06-2017 
05-06-2017 
10-05-2017 
10-10-2019 
10-10-2019 02:54.ß7 
10-10-2019 
p Search for a 
start 
date/t 
Withhold 
W ithm•ld 
W ithru'ld 
Withhold 
Withhold 
Withhold 
W ithf-u'ld 
Withhuzld 
Withhold 
Withhold 
Withhold 
W Ithhald 
Withhold 
Withhold 
Withhold 
With ha I d 
Automatic role assignment 
AF Processing 
Data cache refresh batch 
Create a scheduled task that will... 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Process worker data for wasrkform 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Process retail order email notific.„ 
Product availability 
p_cml 
Pmg 
O. 00 
coo 
O. 00 
00 
O. 00 
O. 00 
O. 00 
O. 00 
00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
by 
Admin 
SARA 
sigitac 
SilvS 
delagani 
delagani 
delagani 
delagani 
rubendel 
saraschi 
hasingh 
hasingh 
delagani 
Admin 
Admin 
Ad min 
by 
Admin 
Admin 
Admin

2. Click on “View Tasks”.

Finance and Operations 
New Delete 
t SSkS 
Batch job 
Switch to enhanced form 
C •unge Sutu S 
Job description 
Batch job 
batch job 
Log 
Germted files 
Status 
V'" thhold 
Withhold 
Withhold 
Withhold 
Withhold 
Withhold 
Withhold 
Withhold 
Wthhold 
Withhold 
Withhold 
Withhold 
Withhold 
Withhold 
Withhold 
options 
Scheduled date/time 
05-03-2021 09:41:22 
09-01-2015 
28-02-2014 061608 
02-02-2016 
13-10-2017 
30-03-2017 
13-04-2017 
19-04 
-2017 
26-04-2017 005406 
03-05-2017 
13-10-2017 
01-06-2017 
03-06-2017 
03-06-2017 
05-06-2017 
10-05-2017 
10-10-2019 03:3703 
10-10-2019 025447 
10-10-2019 025804 
Seardl for a page 
Actua I start date/time 
date/ti me 
Statement Posting 
Automatic role assignment 
Al F Processing 
Data cache refresh batch 
Create a scheduled task that will... 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Process worker data for workfor... 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Process retail order email notific„. 
Product availability 
Prog 
Off 
000 
0.00 
Off 
0.00 
0.00 
0.00 
0.00 
Off 
by 
demo 
Admin 
SARA 
silvs 
delagani 
delagani 
delagani 
delagani 
delagani 
rubendel 
saraschi 
hasingh 
hasingh 
hasingh 
delagani 
Admin 
Admin 
Admin 
Run by 
demo 
Admin 
Admin 
Admin

3. Add the following 4 classes:

Class NameTask Description
RetailCDXScheduleRunnerUpload channel transaction(P-job)
RetailTransactionSalesTransMark_Multi Post inventory
RetailEodStatementCalculateBatchSchedulerCalculate statement
RetailEodStatementPostBatchSchedulerPost statement

Here I choose to include upload of transactions, post inventory, calculate statement and post statement into a single batch-job.

Finance and Operations 
Save New Delete Parameters 
Search for a 
Log 
Refresh 
Options 
87 
STATEMENT POSTING WITHHOLD 
Batch tasks 
Overview 
V Status 
General 
Company 
USRT 
USRT 
USRT 
I_JSRT 
Class nam e 
RetailEodStatementPost8atchSc... 
RetailEodStatementCaIcuIateB.„ v 
RetailTransactionSaIesTransMark.„ 
Retail C DISC 
C Lass description 
Post inventory 
Has 
Run 
Server 
Server 
Batch group 
USRT 
progress Start dat 
Withhold 
Withhold 
Withhold 
Withhold 
HAS CONDITIONS 
+ New Delete 
Update 
Task description 
Post statement 
Calculate statement 
Post inventory 
upload Channel transaction (als... 
Go to previous

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

 Do this process for all task in the job.

Finance and Operations 
Save New @ Delete Parameters 
p Sear&' for a page 
Y 
STATEMENT POSTING: WITHHOLD 
Batch tasks 
Overview Gene 
IDENTIFICATION 
Withhold 
Task de-SC 
Update 
Log 
Condition 
Refresh 
Il y Start 
Options 
Actual statu s 
Runtime task 
Batch 
68720378525 
Task descrip tion 
task 
Ma 
Batch group 
AOS name 
Start date/tirne 
transaction (also p-jOb* 
BATCH 
USRT 
C) 
HAS CONDITIONS 
•E New Delete 
Q' dition type 
@ All Any 
Task 
Go to previous 
Expected status 
We didn* uw-thing to

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.

Finance and Operations 
Save 
Re fresh 
Options 
Y 
STATEMENT PO 
Batch tasks 
Overview 
Sta 
General 
WITHHOLD 
Update 
Task 
Post statement 
Calculate statement 
Post i rwentory 
Upload Channel transaction (als._. 
Go previous 
USRT 
usRT 
usRT 
Search for a 
RetailEodStatementPostaatchSc... 
Reta•IEodStatementCaIcu13teB3t... 
RetailTransactionSaIe5TransM.,. 
Task de«tiptiem 
Upload channel transaction (als... 
Choose organization nodes 
O' ga t ion hierarchy 
Retail Stores by Region 
AVAILABLE ORGANIZATION NODES: 
Bloom i 
Chicago 
Cincinnati 
Oak Brook 
San Antonio 
SELECTED ORGANIZATION NODES: 
Houston 
Has 
Withhold 
Withhold 
Withhold 
Withhold 
HAS CONDITIONS 
New Delete 
Condition 
@ All (D Any 
68720445916 
Post inventory 
Ended 
Withhold

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.

Finance and Operations 
Save New Delete Parameters 
Search for a page 
Log 
Refresh 
Options 
uSRT 
Cia " 
RetailEOdStätementPostBatchSc,.. 
RetailEcdStatementCaIcuIateæt.„ 
RetailTransactionSaIesTransM.„ v 
RetailCOXScheduIeRunner 
Tuk ti 
Upload channel transaction (als.„ 
Run 
Batch g 
USRT 
Stut da te/tim e 
p 
o 
Y 
STATEMENT POSTING WITHHOLD 
Batch tasks 
Overview 
Status 
General 
W,thhcld 
Withhold 
HAS CONDITIONS 
New @ Delete 
@ All Any 
68720445916 
Update 
Task 
Post statement 
Calculate statement 
Post inventory 
Upload channel transaction (a's... 
Go to previous 
Ex st 
Ended 
Post inve ntory

Click on recurrence and set the recurrence that when the statement done.

Finance and Operations 
Save New Delete 
Switch to enhanced form 
Batch job 
Options 
start 
05-03-2021 
09-01-2015 
28-02-2014 
02-02-2016 
13-10-2017 11:30:00 
30-03-2017 
13-04-2017 
19-04-2017 
26-04-2017 
03-05-2017 
13-10-2017 
01-06-2017 
03-06-2017 
03-06-2017 
05-06-2017 01:30:12 
10-05-2017 04:03:19 
10-10-2019 
10-10-2019 
10-10-2019 
p Search fcw a 
start 
USRT 
tasks 
Batch job h i story 
Log 
Withhold 
Withhold 
W ithf-dd 
Withhold 
Withhold 
Withhold 
W ithf-u'ld 
Withhold 
Withhold 
Withhold 
W ithf-dd 
Withhold 
Withhold 
Withhold 
Change status 
Job 
Copy batch 
Pefæh 
End date/t 
Statement Posting 
Automatic role assignment 
processing 
Data cache refresh batch 
Create a scheduled task that will... 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Process worker data for va•rkform 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
Data cache refresh batch 
process retail order email notific.„ 
Product availability 
9-0001 
0.00 
00 
0.00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
O. 00 
00 
O. 00 
by 
demo 
Admin 
SARA 
sigitac 
silvs 
delagani 
delagani 
delagani 
delagani 
delagani 
rubendel 
saraschi 
hasingh 
hasingh 
hasingh 
delagani 
Admin 
Admin 
Admin 
by 
Admin 
Admin 
Admin 
USM; 
USMF

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!


Share Story :