Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
36%
Installation Wizard into new VRC
36%
Manual into existing VRC
7%
Manual into new VRC
22%
Total votes: 45

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st December 2010, 01:54
KBacca's Avatar
KBacca KBacca is offline
Junior Member
 
Join Date: Feb 2002
Location: West-Central, Ohio
Posts: 20
KBacca is on a distinguished road
Baan: ERP LN - DB: Oracle 8 - OS: Linux
Purchase Invoice - Approver captured?
Baan: ERP LN 6.1 FP3

Greetings - I'm trying to find a field in the LN tables and so far I'm not finding it.
Can anyone offer any suggestions?

When using the session:Match/Approve Purchase Invoices (tfacp2107s000)
to Approve approve and Invoice that my have some Additional Costs included.

I'm trying to find if the User who actually performs the "Approve Invoice" is recorded along with the transaction.

I've been asked to add a column to an existing report (tfacp1431m000:Print Matched and Approved Purchase Invoices with Receipts) which will show the User Id that approved the Invoice...but so far all I find in the User who Authorized or last modified the invoice....

Is this recorded in the LN Tables somewhere?
Reply With Quote
  #2  
Old 21st December 2010, 10:51
Leerkes Leerkes is offline
Member
 
Join Date: Mar 2007
Posts: 61
Leerkes is on a distinguished road
Baan: BaanV, LN - DB: Oracle - OS: Unix
You will need to go to the approval document, so use tfacp200.tapr and tfacp200.dapr and find in tfgld018 the document number, the field tfgld018.user will be the user who created the approval document and is therefore also the "approver".
Regards,
Michiel
Reply With Quote
Sponsored Links
  #3  
Old 6th January 2011, 09:34
finamp's Avatar
finamp finamp is offline
Senior Member
 
Join Date: Sep 2008
Location: India
Posts: 120
finamp is on a distinguished road
Baan: Baan IV, V, LN SP0, FP2, FP3, FP5, FP6, FP7, 10.3, 10.4 - DB: SQL - OS: Server2003
This information you can get from approval document no.
you have to develop this in Infor.
__________________
Regards
Deepak Rawat
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
approved purchase invoice error Dinushi Senanay Finance, Invoicing and Integration 4 9th September 2008 07:29
open purchase order with wrong price nopadon Distribution, Transportation & Warehousing 2 4th March 2006 15:11
invoice for a matched purchase order PHPTeufel Finance, Invoicing and Integration 2 7th April 2004 16:29


All times are GMT +2. The time now is 19:39.


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