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 13th November 2002, 19:02
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Question Item Issues by Period - by date

I need to show item issues by date (1999 issues, 2000, issues, etc.) and don't know how to code it. The problem is that when it searches for the 1999 issues, if it does not find the item code it tosses out that record and does not look in 2000, 2001, etc.

If I use an 'or' statement, it will only give me the issues for the 1st year it finds, and not for all of the years.

I am a beginning programmer and would appreciate any help.

Here is what I have tried:

where ttayear.item = tdinv001.item
and ttbyear.item = tdinv001.item
and ttcyear.item = tdinv001.item
and ttdyear.item = dtinv001.item
and ttayear.year = 2002
and ttbyear.year = 2001
and ttcyear.year = 2000
and ttdyear.year = 1999
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
Sponsored Links
  #2  
Old 13th November 2002, 19:25
tjbyfield's Avatar
tjbyfield tjbyfield is offline
Guru
 
Join Date: Jun 2002
Location: Sydney Australia
Posts: 356
tjbyfield is on a distinguished road
Baan: baan4c4 - DB: oracle 805 - OS: AIX 4.3.3
Staugner

I am not sure what tables the ttayear, ttbyear etc are. Are they aliases for the same table? If so you could try without the multiple tables something like the following...

where ttayear.item = tdinv001.item
and (ttayear.year = 2002 or ttayear.year = 2001 or
ttayear.year = 2000 or ttayear.year = 1999)
[could also use ttayear.year in (2002, 2001, 200, 1999) ]

If the are different tables you may be better off with separate selets for each one

Hope this helps
Terry
Reply With Quote
  #3  
Old 13th November 2002, 19:28
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Thanks - the aliases are all for the same table (tdinv750). I will try your solution.
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
  #4  
Old 14th November 2002, 08:38
rupertb's Avatar
rupertb rupertb is offline
Senior Member
 
Join Date: Jun 2002
Location: NY, USA
Posts: 192
rupertb is on a distinguished road
Baan: T2.2, BIVb2, BIVc4, Vc - DB: Oracle, INFORMIX, DB2, SQL - OS: AIX, WIN
Question

Are you trying to display the item issue per period as in to the screen? Why not set up a display session of type 1? Single Occurence with main-table. Or is the data intended for print output? Why alias the table four times? Are you trying to display four years on one form?
By the way hardcoding variables is not good practice ...
Reply With Quote
  #5  
Old 14th November 2002, 15:04
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Yes, I'm trying to display issues by item for four different years on the same form, thus the four aliases. Is this possible? It is to be a printed report...
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
  #6  
Old 14th November 2002, 15:59
rupertb's Avatar
rupertb rupertb is offline
Senior Member
 
Join Date: Jun 2002
Location: NY, USA
Posts: 192
rupertb is on a distinguished road
Baan: T2.2, BIVb2, BIVc4, Vc - DB: Oracle, INFORMIX, DB2, SQL - OS: AIX, WIN
Can I create the report and send you the dumps, that'll start you off and then you can finish it?
Reply With Quote
  #7  
Old 14th November 2002, 16:02
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
That could be a tremendous help!
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
  #8  
Old 14th November 2002, 16:04
rupertb's Avatar
rupertb rupertb is offline
Senior Member
 
Join Date: Jun 2002
Location: NY, USA
Posts: 192
rupertb is on a distinguished road
Baan: T2.2, BIVb2, BIVc4, Vc - DB: Oracle, INFORMIX, DB2, SQL - OS: AIX, WIN
OK, I'll have it ready in half an hour!
Reply With Quote
  #9  
Old 14th November 2002, 16:54
rupertb's Avatar
rupertb rupertb is offline
Senior Member
 
Join Date: Jun 2002
Location: NY, USA
Posts: 192
rupertb is on a distinguished road
Baan: T2.2, BIVb2, BIVc4, Vc - DB: Oracle, INFORMIX, DB2, SQL - OS: AIX, WIN
Attached please find the dump archive I have created, use winzip (or similar) to extract ftp or file copy to your baan system. In baan go to tools/software distribution/internal import/export/import data dictionary supply the path to the dumps files, overwrite yes/no depending on the session (I've called it tdinvc470m000 - does it exist already? I hope not). At the option "write software to other package VRC" choose your customization VRC.

Click continue - once it's imported you may need to go to "maintain sessions" and change the session status from developing to finished, press save and then change it back to developing again and press save again. (sometimes this is necessary to register the object and session)


Good Luck,
Rupert
Attached Files
File Type: zip item_issue.zip (30.2 KB, 32 views)
Reply With Quote
  #10  
Old 18th November 2002, 11:29
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Dear Sharon,

Just a thought. If you'd like to show such report on your sales goods (ie you'd like summary of sales qty for year 1999, 2000, 2001, and 2002) it can be done easily with Sales Statistics (SST) module. It can produce this timewise column arrangement with no problem.

Rgds,
Paul
Reply With Quote
  #11  
Old 18th November 2002, 15:43
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Thanks Paul, but we haven't activated the Sales Statistics module at this time...
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
  #12  
Old 19th November 2002, 02:55
Paul P's Avatar
Paul P Paul P is offline
Guru
 
Join Date: Jul 2002
Location: Jakarta, Indonesia
Posts: 797
Paul P is on a distinguished road
Baan: BaanIV, BaanERP - DB: SQL Server, Informix, Oracle - OS: Windows, HP-UX
Sure thing, Sharon . It's just a thought . By the way, should you decide to implement it in the future, pls be informed that this SST module is a reporting module only. It doesn't have any impact on any other business process. Should the time come and you need assistance, I and many other BB members will surely be happy to help . Have a nice day!

Rgds,
Paul
Reply With Quote
  #13  
Old 19th November 2002, 22:16
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Thank you Paul, I appreciate it. There are many parts of Baan that I'd like to see implemented!
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
Reply With Quote
  #14  
Old 20th November 2002, 19:57
staugner's Avatar
staugner staugner is offline
Member
 
Join Date: Sep 2002
Location: Marine on St Croix, MN
Posts: 31
staugner is on a distinguished road
Baan: IV c4 - DB: Oracle - OS: NT
Rupert, you are amazing! I just got your dump files into my system and it's as pretty a solution as I've ever seen. Many thanks,

Sharon
__________________
Sharon Taugner
sharon.taugner@ufeinc.com
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
use of itm001.item type? gavin_wusj Manufacturing & Supply Chain 2 25th November 2003 09:15


All times are GMT +2. The time now is 02:25.


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