Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 28th February 2005, 07:01
mila04792's Avatar
mila04792 mila04792 is offline
Member
 
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
  #2  
Old 30th March 2005, 13:09
Penfold's Avatar
Penfold Penfold is offline
Member
 
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,
P

Last edited by Penfold : 30th March 2005 at 15:11. Reason: syntax & amendments
Reply With Quote
  #3  
Old 1st April 2005, 11:15
mila04792's Avatar
mila04792 mila04792 is offline
Member
 
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
Reply


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 14:14
Relate ledger account to a BP Mohamed_alsadr Finance, Invoicing and Integration 1 9th January 2004 13:03
ledger account not defined veyant Distribution, Transportation & Warehousing 2 6th August 2003 14:24
Audit trail from Finance to distribution Nazeem Finance, Invoicing and Integration 14 11th October 2002 04:18
Changing a Ledger account LittleJohn Finance, Invoicing and Integration 5 8th May 2002 22:52


All times are GMT +2. The time now is 04:56.


©2001-2017 - Baanboard.com - Baanforums.com