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
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th September 2007, 12:04
j3ruk07's Avatar
j3ruk07 j3ruk07 is offline
Junior Member
 
Join Date: Aug 2007
Posts: 14
j3ruk07 is on a distinguished road
Baan: Baan IVc4 - DB: SQL - OS: Windows XP
Question Print Sales Invoice History
Baan: Baan IVc4

Dear all,

Is there a way for us to know, who (which user id) print the sales invoice for a specific sales order number?

At my company, the process for Print Sales Invoice is done by logistic people. Now, our finance people need to know who print the sales invoice because sometime, the SO status is deleting line, the invoice transaction is integrated to finance, but the hard copy for the invoice is not delivered to finance dept.

In User History, we can only know, who log in to Print Sales Invoice session but we can't find out which order that he/she printed at that time.

The user id that Baan captured in document history, integration history & sales order history for Print Sales Invoice transaction comes from the one who did the Process Delivered Sales Order session.

The problem is, in Process Delivered Sales Order session, we can't specify which sales order that we want to process in that session.

So, if you have any suggestions on how to track who print the invoice for each sales order, please share them. I really appriciate your kindness for that.

Thank you

regards,
J
Reply With Quote
  #2  
Old 25th September 2007, 12:59
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
Auditing..

Perhaps you could turn on auditing for the sls tables, particularly the sls045 or sls051 table.

sk
Reply With Quote
  #3  
Old 25th September 2007, 17:13
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
May be a small customization would help. You can store this info in new table when invocie is printed. ANd you don't need source code also.
Reply With Quote
  #4  
Old 27th September 2007, 06:38
j3ruk07's Avatar
j3ruk07 j3ruk07 is offline
Junior Member
 
Join Date: Aug 2007
Posts: 14
j3ruk07 is on a distinguished road
Baan: Baan IVc4 - DB: SQL - OS: Windows XP
Dear SK,

Quote:
turn on auditing for the sls tables, particularly the sls045 or sls051 table
How to do this? Is it through Audit Management in Baan IV Tools? Do you have document on how to use this functionality? Thanks

Dear AV,

Quote:
May be a small customization would help. You can store this info in new table when invocie is printed. ANd you don't need source code also.
What kind of customization. Would you please elaborate? Thanks a lot.

Btw, infor gave me solution #164842. Does anyone here ever try this solution before? The document said that it will allow us to choose SO range in Process Delivered Sales Order session.

One more thing, in tdsls051, there is a field called Record type (1-3) (tdsls051.ckor). What is the meaning of record type 1/2/3?

Thanks a lot
__________________
J
Reply With Quote
  #5  
Old 27th September 2007, 08:07
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
Hi,
Yes its done through Audit Management but i am afraid i dont have the document for this. You could search it on infor. Or best, if you have a support contract with them then you can download the ISO image of Baan4c4 documentation CD that includes all documentation made for version 4.
As far as the solution is concerned, this function was added on to Sales Order Processing session in one of the Service Packs. Dont know how this would solve your problem, unless ofcourse the users are told to only process sales orders pertaining to a particular series. That might help.

sk
Reply With Quote
Sponsored Links
  #6  
Old 27th September 2007, 18:15
jftello jftello is offline
Junior Member
 
Join Date: Apr 2002
Location: Columbus, OH
Posts: 26
jftello is on a distinguished road
Baan: Triton 3.1, Baan IVc and Baan A&D, ERP LN - DB: Oracle, Miracle, Informix - OS: Solaris 8.0, IBM AIX5.3
Try tdsls051. Record type 1 means added, updated sales orders. Record type 2 means deleted. Record 3 means printed. You can see the username on the logname field.
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
Problem in AFS for Print Sales Invoice justknowledge AFS/DDC/OLE: Function servers 4 18th July 2007 07:19
Unable to print a specific sales invoice through api calls Punitha AFS/DDC/OLE: Function servers 12 16th July 2007 08:07
Process Delivered immediately after Print Sales Invoice vishbaan Distribution, Transportation & Warehousing 1 23rd November 2004 18:24
Problem in Session Print Sales Invoice manusatsangi Finance, Invoicing and Integration 1 5th July 2004 09:56
cant print sales invoice anthony_wang Finance, Invoicing and Integration 5 31st December 2002 04:58


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


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