HI Everyone,
Please find the below use case and provide the best understandable solution for this:
Case1:
- Buying Start Date = Begin DT
- if above 1 fails, then check "Buying Start Date” of Trade report = Any date between “Begin DT” and “Due DT” of Invoice Excel.
- if above 2 fails , throw a error
Case2:
- Buying End Date = End DT
- if above 1 fails, then check "Buying End Date” of Trade report = equal to “Due DT” value or any date in range of +21 days to the “END DT” of Invoice.
- if above 2 fails, throw a error
1 Like
Hey @Koteswara_Rao
You can do this by using the below steps,
-
Use a for-each to iterate the Data Table
-
Inside the for-each just check the condition using IF with throw on the negative flow to raise exception
If you need a demo, please share the excel files.
Thanks
#nK
InvoiceReport.xlsx (9.3 KB)
TradeReport.xlsx (9.2 KB)
these are the demo excel files ?
1 Like
Hey @Koteswara_Rao
Please find the sample sequence below,
nmnithinkrishna_ReconcileTradeRepWitInvoice.zip (16.2 KB)
Hope this helps
Thanks
#nK
system
(system)
Closed
6
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.