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

Help Studio
, , ,
1

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

usecase example
usecase example1642×696 67.3 KB

1 Like
2

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

4

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

these are the demo excel files ?

1 Like
5

Hey @Koteswara_Rao

Please find the sample sequence below,

nmnithinkrishna_ReconcileTradeRepWitInvoice.zip (16.2 KB)

Hope this helps

Thanks
#nK

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.