Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

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 29th October 2009, 15:18
peturba peturba is offline
Senior Member
 
Join Date: Sep 2007
Location: Germany
Posts: 169
peturba is on a distinguished road
Baan: 6.1 ERP LN - DB: Informix - OS: Solaris
Question Crystal Report and status of sales order line
Baan: ERP LN 6.1
C/S: Both

Hi,

I'm creating a report using Crystal Reports where the output depends on the status of each sales order line. Every time the status of an order line changes ERP LN generates a record in table tdsls413. Does there any other method exist to discover the status of an sales order line? In Crystal Reports it is quite difficult (if not even impossible) to get the correct output.

Thanks in advance

pet
Reply With Quote
Sponsored Links
  #2  
Old 4th November 2009, 14:20
peturba peturba is offline
Senior Member
 
Join Date: Sep 2007
Location: Germany
Posts: 169
peturba is on a distinguished road
Baan: 6.1 ERP LN - DB: Informix - OS: Solaris
Exclamation Solution

Found a solution by myself: the table tdsls406 will do the job. If a sales order line position cannot be found in the table or if it is present in the table with any status except "processed" then the order line has not been delivered yet.

pet
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
RPL order status report pkamal Distribution, Transportation & Warehousing 1 4th August 2008 14:24
Is possible to change Production order status Senthil Manufacturing & Supply Chain 1 27th September 2004 12:41
resetting production order status from completed to active jroberts Manufacturing & Supply Chain 7 15th August 2003 17:25
Picking Lists melmer Distribution, Transportation & Warehousing 1 27th January 2003 01:24
More quantity when report production order completed hpcarol Manufacturing & Supply Chain 6 18th September 2002 10:05


All times are GMT +2. The time now is 08:49.


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