Go Back > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor


How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 43

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 28th February 2005, 08:01
mila04792's Avatar
mila04792 mila04792 is offline
Join Date: Nov 2004
Location: Malaysia
Posts: 69
mila04792 is on a distinguished road
Baan: IV - DB: - - OS: unix
Finalized Transactions By Ledger Account

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!!!!!!!!!!!!!!!
Reply With Quote
Sponsored Links
Old 30th March 2005, 14:09
Penfold's Avatar
Penfold Penfold is offline
Join Date: Oct 2002
Location: England
Posts: 92
Penfold is on a distinguished road
Baan: IVc4 (SP26) - DB: SQL - OS: NT
Smile Finding original document.

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,

Last edited by Penfold : 30th March 2005 at 16:11. Reason: syntax & amendments
Reply With Quote
Old 1st April 2005, 12:15
mila04792's Avatar
mila04792 mila04792 is offline
Join Date: Nov 2004
Location: Malaysia
Posts: 69
mila04792 is on a distinguished road
Baan: IV - DB: - - OS: unix
Smile Thanks.

Dear Penfold,

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

Bye. Have a nice day.
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to correct Ledger Account in Integration Batch? YOGESH GUPTA Finance, Invoicing and Integration 6 19th January 2005 15:14
Relate ledger account to a BP Mohamed_alsadr Finance, Invoicing and Integration 1 9th January 2004 14:03
ledger account not defined veyant Distribution, Transportation & Warehousing 2 6th August 2003 15:24
Audit trail from Finance to distribution Nazeem Finance, Invoicing and Integration 14 11th October 2002 05:18
Changing a Ledger account LittleJohn Finance, Invoicing and Integration 5 8th May 2002 23:52

All times are GMT +2. The time now is 03:02.

©2001-2018 - -