Finalized Transactions By Ledger Account

[mila04792]

Hi everyone,

There is a session tfgld1406m000Print Finalized Transactions By Ledger Account) in General Ledger Menu ---> Month End Closing -->

And there is a ledger account xxxxx-00 (Unit Price Variance) in Finance.

In this Report when I selected this ledger account, I see the

Period / Document Invoice No / Document Date Dimension/Ref Supplier/Currency/Amount/Amount (Debit) and Amount(Credit)
------------------------------------------------------------------

The Document Invoice No are not unique(its the number from the batch).
Is there any way to identify the original document.
The purpose is to trace the actual amount for each document.
With this report, its hard to find the actual invoice (I guess!!!!!!)

---------------------------------------------------------------------
Can anyone give me idea how unit price variance account is created in the system ? (I guess by non-matching payment) and is there any way to trace back the actual document, actual amount, actual quantity by suppliers for each of the document?

Thanks in advance guys.

Actually the Finance Module in Baan IV (Account Payable, Account Receivable,General Ledger , Financial Statement, Financial Budget, Fixed Asset, Cash Management)
are confusing for me (I don't have strong Account Background).

It is a great help for me is anyone can give me some idea.

Thanks. Have a nice day!!!!!!!!!!!!!!!

[Penfold]

we also have this problem from time to time, particularly with our auditors at year end.

This is not easy in my experience and if any one knows a smarter way please let me know, but you also need to look at the integration displays/reports.

Neither display or report will give you exactly what you want but there is enough information, such as purchase order number, to track down the required original document. Reports can take a long time so choose display if you can and leave reports for long listings.
With the purchase order number you should be able to identify the difference and invoice from report tfacp1430m000 (accounts payable/transactions/reports)

As I say it's a bit messy and awkward but its the only way we have found so far.


With regard to how the transaction is created:
If there is a difference the transaction is created at the time of matching the invoice to the order. The settings should be within the integration parameters.

Hope this helps,
P

[mila04792]

Dear Penfold,

Thanks a lot. That gives me some idea how to solve my problem.

Bye. Have a nice day.