baan999
19th October 2011, 15:42
i am trying to pick from tfacp200.balh as an balance to vendor and generating report with some other additional fields .

i am comparing with the selective vendor with tfacp2421m000(ageing analysis) there is mismatch in balance amount. between standard and customised session

what is the logic derived tfacp2421m000 ?

cyprus
1st November 2011, 08:54
HI There,

I think you should run the session tfacp2245m000 (Recalculate Invoice from BP) session in simulate mode once, and then see if there is any discrepancy in the balances for the open invoices.

Regards,
Saroj K Thakur

sultania.vivek
2nd November 2011, 07:37
Hi,

I agree with Saroj Comments and want to add following points:
1. What other fields you are considering. If you are using balh then you should not use any other field like discounts, payment difference, currency difference etc.
2. For report you should use advance and unallocated type of payment also if in ageing you are considering advance/unallocated payment too.
3. If anticipated mechanism is being used then the logic should be modified accordingly.

I hope this will be useful.
With regards,
Vivek S