Spreadsheet: 692042d1598024854-change-payment-date-if-month-end-payment-dating-dummy
Sheet: SAP Forecast

A | B | Doc | Type | SG | DD | Clrng doc. | 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 | Sthree Bank A/c Ccy | Sthree Bank A/c Amt | Ctry | Month | Old Payment Date | Payment Date Fiter | To be paid on | Is GBP | Net due weekday | Paid on weekday | CONCAT | Day
A2 | B2 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -36 | EUR | -36 | EUR | 2020-08-24 00:00:00 | -36 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A3 | B3 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -37.03 | EUR | -37.03 | EUR | 2020-08-24 00:00:00 | -37.03 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A4 | B4 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -37.03 | EUR | -37.03 | EUR | 2020-08-24 00:00:00 | -37.03 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A5 | B5 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -62.07 | EUR | -62.07 | EUR | 2020-08-24 00:00:00 | -62.07 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A6 | B6 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -89.25 | EUR | -89.25 | EUR | 2020-08-24 00:00:00 | -89.25 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A7 | B7 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -131.65 | EUR | -131.65 | EUR | 2020-08-24 00:00:00 | -131.65 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A8 | B8 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -227.37 | EUR | -227.37 | EUR | 2020-08-24 00:00:00 | -227.37 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A9 | B9 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -338.8 | EUR | -338.8 | EUR | 2020-08-24 00:00:00 | -338.8 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A10 | B10 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -473.55 | EUR | -473.55 | EUR | 2020-08-24 00:00:00 | -473.55 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A11 | B11 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -605 | EUR | -605 | EUR | 2020-08-24 00:00:00 | -605 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A12 | B12 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -629.2 | EUR | -629.2 | EUR | 2020-09-07 00:00:00 | -629.2 | 0 | 0 | 2020-08-24 00:00:00 | 1.5 | 14 | 0 | 28 | 0
A13 | B13 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -638.01 | EUR | -638.01 | EUR | 2020-08-24 00:00:00 | -638.01 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A14 | B14 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -642.6 | EUR | -642.6 | EUR | 2020-09-14 00:00:00 | -642.6 | 0 | 0 | 2020-08-24 00:00:00 | 3 | 7 | 1.5 | 14 | 28
A15 | B15 | AA | RE |  |  |  |  | 0905 | 2020-07-27 00:00:00 | -704.32 | EUR | -704.32 | EUR | 2020-08-24 00:00:00 | -582.08 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A16 | B16 | AA | RE |  |  |  |  | 0500 | 2020-08-10 00:00:00 | -738 | EUR | -738 | EUR | 2020-08-24 00:00:00 | -738 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A17 | B17 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -845 | EUR | -845 | EUR | 2020-08-24 00:00:00 | -845 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A18 | B18 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -915.63 | EUR | -915.63 | EUR | 2020-08-24 00:00:00 | -915.63 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A19 | B19 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -929.25 | EUR | -929.25 | EUR | 2020-08-24 00:00:00 | -929.25 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A20 | [NAME] | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -992 | USD | -992 | USD | 2020-08-24 00:00:00 | -992 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A21 | B21 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1016.4 | EUR | -1016.4 | EUR | 2020-08-24 00:00:00 | -1016.4 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A22 | B22 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1127.12 | EUR | -1127.12 | EUR | 2020-08-24 00:00:00 | -1127.12 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A23 | B23 | AA | RE |  |  |  |  | 0500 | 2020-08-10 00:00:00 | -1505.52 | EUR | -1505.52 | EUR | 2020-08-24 00:00:00 | -1505.52 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A24 | B24 | AA | RE |  |  |  |  | 0500 | 2020-07-27 00:00:00 | -1537.5 | EUR | -1537.5 | EUR | 2020-08-24 00:00:00 | -1537.5 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A25 | B25 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1548.4 | USD | -1548.4 | USD | 2020-08-24 00:00:00 | -1548.4 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A26 | B26 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1560 | USD | -1560 | USD | 2020-08-24 00:00:00 | -1560 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A27 | B27 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -1584 | EUR | -1584 | EUR | 2020-08-24 00:00:00 | -1584 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A28 | B28 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -1644.3 | EUR | -1644.3 | EUR | 2020-09-14 00:00:00 | -1644.3 | 0 | 0 | 2020-08-24 00:00:00 | 3 | 7 | 1.5 | 14 | 28
A29 | B29 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -1740 | EUR | -1740 | EUR | 2020-08-24 00:00:00 | -1740 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A30 | B30 | AA | RE |  |  |  |  | 0496 | 2020-08-10 00:00:00 | -6420.58 | AED | -1748.25 | USD | 2020-08-24 00:00:00 | -1665 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A31 | B31 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -1800 | USD | -1800 | USD | 2020-08-24 00:00:00 | -1800 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A32 | B32 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -1815 | EUR | -1815 | EUR | 2020-08-24 00:00:00 | -1815 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A33 | B33 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -2880 | EUR | -2880 | EUR | 2020-08-24 00:00:00 | -2880 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A34 | B34 | AA | RE |  |  |  |  | 1102 | 2020-08-10 00:00:00 | -2900 | USD | -2900 | USD | 2020-08-24 00:00:00 | -2900 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
[NAME] | B35 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | -2904 | EUR | 2020-08-24 00:00:00 | -2904 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A36 | B36 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | -2904 | EUR | 2020-08-24 00:00:00 | -2904 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A37 | B37 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2904 | EUR | -2904 | EUR | 2020-08-24 00:00:00 | -2904 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A38 | B38 | AA | RE |  |  |  |  | 0600 | 2020-07-27 00:00:00 | -2910 | EUR | -2910 | EUR | 2020-08-24 00:00:00 | -2910 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A39 | [NAME] | AA | RE |  |  |  |  | 4000 | 2020-08-10 00:00:00 | -2992 | AUD | -2992 | AUD | 2020-08-24 00:00:00 | -2720 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A40 | B40 | AA | RE |  |  |  |  | 0630 | 2020-07-27 00:00:00 | -3000.8 | EUR | -3000.8 | EUR | 2020-08-24 00:00:00 | -3000.8 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A41 | [NAME] | AA | RE |  |  |  |  | 0600 | 2020-08-17 00:00:00 | -3012.9 | EUR | -3012.9 | EUR | 2020-09-14 00:00:00 | -3012.9 | 0 | 0 | 2020-08-24 00:00:00 | 3 | 7 | 1.5 | 14 | 28
A42 | B42 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -4872 | EUR | -4872 | EUR | 2020-08-24 00:00:00 | -4872 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A43 | B43 | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -4896.87 | EUR | -4896.87 | EUR | 2020-08-24 00:00:00 | -4896.87 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
[NAME] | B44 | AA | RE |  |  |  |  | 4000 | 2020-07-27 00:00:00 | -4950 | AUD | -4950 | AUD | 2020-08-24 00:00:00 | -4500 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A45 | B45 | AA | RE |  |  |  |  | 0560 | 2020-07-27 00:00:00 | -5009.4 | EUR | -5009.4 | EUR | 2020-08-24 00:00:00 | -5009.4 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A46 | B46 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -10904.04 | EUR | -10904.04 | EUR | 2020-08-24 00:00:00 | -10904.04 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A47 | B47 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -11006.48 | EUR | -11006.48 | EUR | 2020-08-24 00:00:00 | -11006.48 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A48 | B48 | AA | RE |  |  |  |  | 0706 | 2020-07-10 00:00:00 | -11130.22 | EUR | -11130.22 | EUR | 2020-08-24 00:00:00 | -11130.22 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 45 | 0 | 0 | 0
A49 | [NAME] | AA | RE |  |  |  |  | 0600 | 2020-08-10 00:00:00 | -11325.6 | EUR | -11325.6 | EUR | 2020-09-07 00:00:00 | -11325.6 | 0 | 0 | 2020-08-24 00:00:00 | 1.5 | 14 | 0 | 28 | 0
[NAME] | B50 | AA | RE |  |  |  |  | 0600 | 2020-08-03 00:00:00 | -11392.15 | EUR | -11392.15 | EUR | 2020-08-24 00:00:00 | -11392.15 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 21 | 0 | 0 | 0
A51 | B51 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -11640 | EUR | -11640 | EUR | 2020-08-24 00:00:00 | -11640 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A52 | B52 | AA | RE |  |  |  |  | 0902 | 2020-08-10 00:00:00 | -11899.54 | EUR | -11899.54 | EUR | 2020-09-07 00:00:00 | -9860 | 0 | 0 | 2020-08-24 00:00:00 | 1.5 | 14 | 0 | 28 | 0
A53 | B53 | AA | RE |  |  |  |  | 3400 | 2020-08-10 00:00:00 | -19314.4 | MYR | -19314.4 | MYR | 2020-08-24 00:00:00 | -19314.4 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
[NAME] | B54 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -19395.2 | EUR | -19395.2 | EUR | 2020-09-14 00:00:00 | -19395.2 | 0 | 0 | 2020-08-24 00:00:00 | 3 | 7 | 1.5 | 14 | 28
A55 | B55 | AA | RE |  |  |  |  | 0706 | 2020-08-03 00:00:00 | -19488 | EUR | -19488 | EUR | 2020-08-24 00:00:00 | -19488 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 21 | 0 | 0 | 0
[NAME] | B56 | AA | RE |  |  |  |  | 0706 | 2020-08-17 00:00:00 | -19778 | EUR | -19778 | EUR | 2020-08-24 00:00:00 | -19778 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 7 | 0 | 0 | 0
A57 | B57 | AA | RE |  |  |  |  | 0802 | 2020-07-27 00:00:00 | -21000 | EUR | -21000 | EUR | 2020-08-24 00:00:00 | -21000 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A58 | B58 | AA | RE |  |  |  |  | 0706 | 2020-08-10 00:00:00 | -21692 | EUR | -21692 | EUR | 2020-08-24 00:00:00 | -21692 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 14 | 0 | 0 | 0
A59 | B59 | AA | RE |  |  |  |  | 0706 | 2020-07-27 00:00:00 | -22258.08 | EUR | -22258.08 | EUR | 2020-08-24 00:00:00 | -22258.08 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 28 | 0 | 0 | 0
A60 | B60 | AA | RE |  |  |  |  | 3300 | 2020-08-14 00:00:00 | -440000 | [NAME] | -440000 | [NAME] | 2020-08-24 00:00:00 | -400000 | 0 | 0 | 2020-08-24 00:00:00 | 0 | 10 | 0 | 0 | 0
A61 | B61 | AA | RE |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -7.56 | GBP | -7.56 | GBP | 2020-08-25 00:00:00 | -7.56 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 7 | 0 | 0 | 0
A62 | B62 | AA | RE |  |  |  |  | 1102 | 2020-08-11 00:00:00 | -18 | USD | -18 | USD | 2020-08-25 00:00:00 | -18 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A63 | B63 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -24.76 | GBP | -32.4 | USD | 2020-08-25 00:00:00 | -32.4 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A64 | B64 | AA | RE |  |  |  |  | 0100 | 2020-08-13 00:00:00 | -30.6 | GBP | -34 | EUR | 2020-08-25 00:00:00 | -34 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A65 | B65 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -43.73 | GBP | -57.22 | USD | 2020-08-25 00:00:00 | -57.22 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A66 | B66 | AA | RE |  |  |  |  | 0100 | 2020-07-28 00:00:00 | -81 | GBP | -81 | GBP | 2020-08-25 00:00:00 | -81 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 28 | 0 | 0 | 0
A67 | B67 | AA | RE |  |  |  |  | 0706 | 2020-08-11 00:00:00 | -91.53 | EUR | -91.53 | EUR | 2020-08-25 00:00:00 | -91.53 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A68 | B68 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -71.45 | GBP | -93.5 | USD | 2020-08-25 00:00:00 | -93.5 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A69 | B69 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -102.52 | GBP | -102.52 | GBP | 2020-08-25 00:00:00 | -102.52 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A70 | B70 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -128.47 | GBP | -128.47 | GBP | 2020-08-25 00:00:00 | -128.47 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
[NAME] | B71 | AA | KR |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -155.95 | GBP | -155.95 | GBP | 2020-08-25 00:00:00 | -155.95 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 7 | 0 | 0 | 0
A72 | B72 | AA | RE |  |  |  |  | 0100 | 2020-07-28 00:00:00 | -166.32 | GBP | -166.32 | GBP | 2020-08-25 00:00:00 | -166.32 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 28 | 0 | 0 | 0
A73 | B73 | AA | RE |  |  |  |  | 0802 | 2020-07-28 00:00:00 | -179.87 | EUR | -179.87 | EUR | 2020-08-25 00:00:00 | -179.87 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 28 | 0 | 0 | 0
A74 | B74 | AA | RE |  |  |  |  | 0500 | 2020-07-28 00:00:00 | -180.99 | EUR | -180.99 | EUR | 2020-08-25 00:00:00 | -180.99 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 28 | 0 | 0 | 0
A75 | B75 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -143.1 | GBP | -187.2 | USD | 2020-08-25 00:00:00 | -187.2 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A76 | B76 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -198.72 | GBP | -198.72 | GBP | 2020-08-25 00:00:00 | -198.72 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A77 | B77 | AA | RE |  |  |  |  | 0706 | 2020-07-28 00:00:00 | -220.4 | EUR | -220.4 | EUR | 2020-08-25 00:00:00 | -220.4 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 28 | 0 | 0 | 0
A78 | B78 | AA | RE |  |  |  |  | 0100 | 2020-08-11 00:00:00 | -230 | GBP | -230 | GBP | 2020-08-25 00:00:00 | -230 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 14 | 0 | 0 | 0
A79 | B79 | AA | RE |  |  |  |  | 0100 | 2020-08-18 00:00:00 | -276.04 | GBP | -276.04 | GBP | 2020-08-25 00:00:00 | -276.04 | 0 | 0 | 2020-08-25 00:00:00 | 0 | 7 | 0 | 0 | 0