Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st December 2010, 02: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, 11: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
  #3  
Old 6th January 2011, 10:34
finamp's Avatar
finamp finamp is offline
Senior Member
 
Join Date: Sep 2008
Location: India
Posts: 119
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
Sponsored Links
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 08:29
open purchase order with wrong price nopadon Distribution, Transportation & Warehousing 2 4th March 2006 16:11
invoice for a matched purchase order PHPTeufel Finance, Invoicing and Integration 2 7th April 2004 17:29


All times are GMT +2. The time now is 09:42.


©2001-2018 - Baanboard.com - Baanforums.com