Transfer sheet 1 to sheet2
sheet1
Account | Amount in local currency |
24508272 | -29.55 |
69011530 | 29.55 |
24508272 | -6.68 |
68121000 | 6.68 |
if Amount in local currency>0,Debit/Credit Indicator*="s"
if Amount in local currency<0,Debit/Credit Indicator*="H"
sheet2
General Ledger Account | Debit/Credit Indicator* | Amount in Document Currency* |
24508272 | H | 29.55 |
69011530 | S | 29.55 |
24508272 | H | 6.68 |
68121000 | S | 6.68 |
Solved! Go to Solution.