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 16th August 2006, 08:23
brad997 brad997 is offline
Member
 
Join Date: May 2005
Posts: 64
brad997 is on a distinguished road
Baan: LN6 - DB: Informix - OS: IBM AIX5.2
Resolve approved document but not yet approved
Baan: Other/Unknown

Hi gurus,
I need your help urgently. Please help.

Somehow my users incidently produced one document displayed in tfacp2525s000 (Display Purchase Invoice Data) with invoice status=Approved but the Document Approval is blank in tfacp2525s000.
But this document is printed out in the "Finalized Transaction by Doc. Date" under a ledger account (say 2121933).

Upon checking report tfacp1433m000 (Print Invoices Receipts Specifications) , the document is not printout , means it is actually not yet Approved. Only status in tfacp200 is changed as Approved and there is no Approval document details present.

I am advised by someone of 2 options:-

Option A. To change the invoice status to "Registered" from tfacp200 table and Write off the Invoice
OR
Option B. Issue a Purchase Credit note for the same amount and link it to this invoice and to Delete the Invoice postings from tfacp200 table and from tfgld102/tfgld106 table.

MY QUESTIONS:-
1. Based on option A, how to Write off the invoice (I'm non finance)?

2. Based on option A, since this transaction is reflected in the Finalized Transactions report and under the ledger Account 2121933, will there be any impact on GL, opening & closing of the ledger account, Trial Balance, Ledger History table, and other tables?

3. Based on option B, how to do the Issue Purchase Credit Note for the same amount and link it to this invoice? Also do we need to skip the matching and proceed with the approval to ensure only one sided transaction is taken up?

4. Beside Delete the Invoice postings from tfacp200 table and from tfgld102/tfgld106 table, are there any other table such as those impact on GL, opening & closing of the ledger account, Trial Balance, Ledger History table ?


Thanks
Brad
Reply With Quote
  #2  
Old 16th August 2006, 10:44
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
Tip

In case there is no approval document in tfgld102/106 for the invoice just change the status to registered and approve from session " Match Approve Invoice".

No need to attach credit note as there is no problem in the invoice and once approved it can be paid.

Regards

H
Reply With Quote
  #3  
Old 16th August 2006, 11:37
brad997 brad997 is offline
Member
 
Join Date: May 2005
Posts: 64
brad997 is on a distinguished road
Baan: LN6 - DB: Informix - OS: IBM AIX5.2
but the document was finalized and in tfgld106

Hi H,
Baan used is BaanIV.

Thanks for reply.
However the document was finalized and found in tfgld106.
The document somehow is approved invoice status displayed in tfacp2525s000 but with no document approval. It is actually not yet approved as checked against tfacp1433m000 report.

What does the write off invoice means as suggested by someone?

rgds,
Brad
Reply With Quote
Sponsored Links
  #4  
Old 16th August 2006, 12:28
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
Hi

This means the approval field in tfacp200 is wrongly updated. Make it registered and then approve the invoice.

By Write off one could mean attach a credit note and make balance 0... then make a new invoice...

Regards
Reply With Quote
  #5  
Old 16th August 2006, 12:33
h_baan_ln6 h_baan_ln6 is offline
Member
 
Join Date: Jun 2006
Posts: 48
h_baan_ln6 is on a distinguished road
Baan: LN6 - DB: oracle - OS: NT
Hi Again

Hi Brad,

It sems I am not getting your Question correctly.. You have a fair Idea of BaaN Finance and should not be stuck in such a small issue..

Process:

Make Invoice : Table tfgld102--> tfgld106, tfacp200 with status as registered.

Approve Invoice : Tfacp200 status changed to Approved and approval document no updated in the table. Approval document also created in tfgld102 ---> tfgld106.

Now what is the status in youjr case..

Regards

H
Reply With Quote
  #6  
Old 21st August 2006, 11:00
sandeep sandeep is offline
Junior Member
 
Join Date: Feb 2003
Posts: 6
sandeep is on a distinguished road
Baan: BaaN IV C4 - DB: Oracle - OS: Unix
HI,


Please run correction programme otfcor0229 it will change status from approved to matched then run session tfacp1130m00 and matched and approved correctly.



with thanks,
sundeep
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
matched invoice doc+ approval document aliceK Finance, Invoicing and Integration 2 30th December 2005 15:05
BB supporting OO v2 document types patvdv About Baanboard.com 0 22nd October 2005 00:22
Missing document no in tfgld418 ritchly Finance, Invoicing and Integration 0 24th November 2004 12:53
Immediate print of PDF document richard Tools Development 2 10th October 2002 13:19
AFS - Automating Print Order Document and Release Problem!!! gous99 AFS/DDC/OLE: Function servers 6 6th September 2002 20:50


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


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