pavanranjan
Board Regular
- Joined
- Sep 20, 2008
- Messages
- 50
Dear ,I need a formula for doing Reco of un-adjusted entries on daily basis for large amount of entries.
Please help me to do it with the help of excel formula .
Sample as given below :-
"Issue CN" Should be formula output :-
<tbody>
</tbody>
Please help me to do it with the help of excel formula .
Sample as given below :-
"Issue CN" Should be formula output :-
| Document of type ZCR6 | Formula Required | Amount | Sold to | Remarks |
| #N/A | -247.20 | CSR0614 | ||
| 5641801305 | 247.20 | CSR0614 | ||
| #N/A | -456.00 | CSR0614 | ||
| 5641801181 | 456.00 | CSR0614 | ||
| #N/A | -13,650.00 | CSR0614 | ||
| 5641801180 | 13,650.00 | CSR0614 | ||
| #N/A | Issue CN | -15,288 | CSR0614 | un-adjusted |
| #N/A | -18,819.36 | CSR0614 | ||
| 5641801211 | 18,819.36 | CSR0614 | ||
| #N/A | -23,705.64 | CSR0614 | ||
| 5641801009 | 23,705.64 | CSR0614 | ||
| #N/A | -25,000.00 | CSR0614 | ||
| 5641801132 | 25,000.00 | CSR0614 | ||
| #N/A | -38,000.00 | CSR0614 | ||
| 5641801132 | 38,000.00 | CSR0614 | ||
| #N/A | Issue CN | -72,696.00 | CSR0614 | if amount are same(+ve or -ve) and unadjusted |
| #N/A | Issue CN | -72,696.00 | CSR0614 | if amount are same(+ve or -ve) and unadjusted |
<tbody>
</tbody>
Last edited:
