其實我做緊嘅係adjustment
係每個ISIN要有3樣野要做
Situation 1:
如果 Grand total + amount in func > 0 (row 8 ?)
-
Account column: A1311, Debit column: Grand Total+amount in func
-
加多行row:
- account:1020,
- debit column: Grand Total+amount in func
-
加多行row:
- account:NA8600,
- debit: grand total + amount in func
-
再加多行row:
- account NA8601,
- credit: grand total + amount in func
Situation 2:
如果Grand total + amount in func < 0 (row 8 ?)
-
Account column: A1311, Credit column: Grand Total+amount in func
-
加多行row: account:1020, credit column: Grand Total+amount in func
-
加多行row: account:NA8700, credit: grand total + amount in func
-
再加多行row: account NA8701, debit: grand total + amount in func
Situation 3:
如果Grand total + amount in func = 0
- 咩都唔洗做
Special case (如果PCCO Code係P1375000):
Situation 1:
如果Grand total + amount in func > 0 (missing example)
-
Account column: P1375, Debit column: Grand Total+amount in func
-
加多行row: account:2020, debit column: Grand Total+amount in func
-
加多行row: account:NA8600, debit: grand total + amount in func
-
再加多行row: account NA8601, credit: grand total + amount in func
Situation 2:
如果Grand total + amount in func < 0 (row 21)
-
Account column: P1375, Credit column: Grand Total+amount in func
-
加多行row: account:2020, credit column: Grand Total+amount in func
-
加多行row: account:8700, credit: grand total + amount in func
-
再加多行row: account 8701, debit: grand total + amount in func
Situation 3:
如果Grand total + amount in func = 0
- 咩都唔洗做