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: 54

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
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
Old 21st December 2010, 11:51
Leerkes Leerkes is offline
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".
Reply With Quote
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.
Deepak Rawat
Reply With Quote
Sponsored Links

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 16:39.

©2001-2018 - -