1. Buying Start Date = Begin DT 2. if above 1 fails, then check "Buying Start Date” of Trade report = Any date between "Begin DT" and "Due DT" of Invoice Excel

[Koteswara_Rao]

HI Everyone,

Please find the below use case and provide the best understandable solution for this:

Case1:

1. Buying Start Date = Begin DT
2. if above 1 fails, then check "Buying Start Date” of Trade report = Any date between “Begin DT” and “Due DT” of Invoice Excel.
3. if above 2 fails , throw a error

Case2:

1. Buying End Date = End DT
2. 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.
3. if above 2 fails, throw a error

[Nithinkrishna]

Hey @Koteswara_Rao

You can do this by using the below steps,

1. Use a for-each to iterate the Data Table

2. 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

[Koteswara_Rao]

InvoiceReport.xlsx (9.3 KB)
TradeReport.xlsx (9.2 KB)

these are the demo excel files ?

[Nithinkrishna]

Hey @Koteswara_Rao

Please find the sample sequence below,

nmnithinkrishna_ReconcileTradeRepWitInvoice.zip (16.2 KB)

Hope this helps

Thanks
#nK