Spreadsheet: 690191d1596922148-if-currency-is-x-and-due-day-is-1-return-day-as-2-apt-sample
Sheet: Data

Text | CoCd | Doc. Date | Amount in local cur. | LCurr | Amount in doc. curr. | Curr. | Net due dt | Discount base amount | Discount amount | Cash disc. amt LC | Pmnt date | Disc.1 | Day1 | Disc.2 | Day2 | Net | [NAME]000 | Month | Exchange rate | GBP | Payment Date | Payment Date Fiter | To be paid on | Is GBP | Net due weekday | Paid on weekday
Vendor 184 | 0100 | 2020-08-04 00:00:00 | -7.2 | GBP | -7.2 | GBP | 2020-08-11 00:00:00 | -7.2 | 0 | 0 | 2020-08-11 00:00:00 | 0 | 7 | 0 | 0 | 0
Vendor 189 | 0706 | 2020-08-04 00:00:00 | -290 | EUR | -290 | EUR | 2020-08-18 00:00:00 | -290 | 0 | 0 | 2020-08-11 00:00:00 | 3 | 7 | 0 | 14 | 0
Vendor 147 | 1102 | 2020-07-27 00:00:00 | -75 | USD | -75 | USD | 2020-08-10 00:00:00 | -75 | 0 | 0 | 2020-08-10 00:00:00 | 0 | 14 | 0 | 0 | 0
Vendor 151 | 1102 | 2020-07-28 00:00:00 | -35 | USD | -35 | USD | 2020-08-11 00:00:00 | -35 | 0 | 0 | 2020-08-11 00:00:00 | 0 | 14 | 0 | 0 | 0
Vendor 177 | 1102 | 2020-08-03 00:00:00 | -150 | USD | -150 | USD | 2020-08-17 00:00:00 | -150 | 0 | 0 | 2020-08-17 00:00:00 | 0 | 14 | 0 | 0 | 0
Vendor 191 | 0498 | 2020-08-05 00:00:00 | -157.5 | AED | -157.5 | AED | 2020-08-19 00:00:00 | -150 | 0 | 0 | 2020-08-19 00:00:00 | 0 | 14 | 0 | 0 | 0
Vendor 100 | 0600 | 2020-07-13 00:00:00 | -62.07 | EUR | -62.07 | EUR | 2020-08-10 00:00:00 | -62.07 | 0 | 0 | 2020-08-10 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 185 | 0100 | 2020-08-04 00:00:00 | -35 | GBP | -35 | GBP | 2020-09-01 00:00:00 | -35 | 0 | 0 | 2020-09-01 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 186 | 0600 | 2020-08-04 00:00:00 | -63.52 | EUR | -63.52 | EUR | 2020-09-01 00:00:00 | -63.52 | 0 | 0 | 2020-09-01 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 187 | 0706 | 2020-08-04 00:00:00 | -116 | EUR | -116 | EUR | 2020-09-01 00:00:00 | -116 | 0 | 0 | 2020-09-01 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 188 | 0706 | 2020-08-04 00:00:00 | -119 | EUR | -119 | EUR | 2020-09-01 00:00:00 | -119 | 0 | 0 | 2020-09-01 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 190 | 0706 | 2020-08-05 00:00:00 | -147.67 | EUR | -147.67 | EUR | 2020-09-02 00:00:00 | -147.67 | 0 | 0 | 2020-09-02 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 192 | 0600 | 2020-08-05 00:00:00 | -182.07 | EUR | -182.07 | EUR | 2020-09-02 00:00:00 | -182.07 | 0 | 0 | 2020-09-02 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 193 | 0630 | 2020-08-05 00:00:00 | -196.62 | EUR | -196.62 | EUR | 2020-09-02 00:00:00 | -196.62 | 0 | 0 | 2020-09-02 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 194 | 0600 | 2020-08-05 00:00:00 | -275 | EUR | -275 | EUR | 2020-09-02 00:00:00 | -275 | 0 | 0 | 2020-09-02 00:00:00 | 0 | 28 | 0 | 0 | 0
Vendor 136 | 0802 | 2020-07-23 00:00:00 | -270 | EUR | -270 | EUR | 2020-08-22 00:00:00 | -270 | 0 | 0 | 2020-08-22 00:00:00 | 0 | 30 | 0 | 0 | 0
Vendor 157 | 0802 | 2020-07-28 00:00:00 | -247.02 | EUR | -247.02 | EUR | 2020-08-27 00:00:00 | -247.02 | 0 | 0 | 2020-08-27 00:00:00 | 0 | 30 | 0 | 0 | 0
Vendor 167 | 0802 | 2020-07-31 00:00:00 | -252 | EUR | -252 | EUR | 2020-08-30 00:00:00 | -252 | 0 | 0 | 2020-08-30 00:00:00 | 0 | 30 | 0 | 0 | 0
Vendor 176 | 0802 | 2020-08-03 00:00:00 | -95.36 | EUR | -95.36 | EUR | 2020-09-02 00:00:00 | -95.36 | 0 | 0 | 2020-09-02 00:00:00 | 0 | 30 | 0 | 0 | 0