veyant
18th June 2003, 09:00
Hi guys,
I am facing some problem in ITBR account. I am having +ve amount in ITBR however, it should be negitive. I be lieve somewhere some mismatch is in ITBR dr and ITBR cr. A/c.
Can somebofy help me in listing down the tables involved in ITBR and Registered Invoices.
thanks
veyant
baanmanindia69
19th June 2003, 21:33
ITBR (Invoices to be received) reconciliation has become the biggest headache for us also. The GRINYA solutions of BaaN do not really seem to be helping.
I would appreciate if anybody can throw light on this. We are not able to get a supplierwise breakup of ITBR, duly tallied with the General Ledger account in Finance
Best regards.
Baanmanindia
Sai_krishna
27th June 2003, 16:20
Hi,
Run the session select values for Receivable Invoices Specifications (tfacp1235m000) and then print the receivable invoices specifications (finance) report. This should be giving U a breakup of the difference as to manual transactions, Unmatched purchase invoices and mismatched ledger entries.
These details will be available at the bottom end of the report for balance per orderline
U can get the manual transactions details from table tfacp135 by using appropriate query.
However this report does not help 100% since i am unable to get the breakup for mismatched ledger entries.
Hope this helps
Sai Krishna