haider378
Board Regular
- Joined
- Nov 7, 2009
- Messages
- 97
Salam to all,
following is the link of Workbook
https://drive.google.com/file/d/0B_G_aG9jjcBZcWpfT1VaTzNYd28/edit?usp=sharing
I want to move credit amounts from ledger table to average collection period table.
These should move according to running total means received amount must adjust where running total become greater than received amount i.e.
in sheet 400,000 is adjusted when running total was 482,650 and 500,000 is adjusted when running total is 561,968
following is the link of Workbook
https://drive.google.com/file/d/0B_G_aG9jjcBZcWpfT1VaTzNYd28/edit?usp=sharing
I want to move credit amounts from ledger table to average collection period table.
These should move according to running total means received amount must adjust where running total become greater than received amount i.e.
in sheet 400,000 is adjusted when running total was 482,650 and 500,000 is adjusted when running total is 561,968
