Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


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
37%
Manual into existing VRC
5%
Manual into new VRC
21%
Total votes: 43

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th March 2018, 15:41
OshawaPlague OshawaPlague is offline
Junior Member
 
Join Date: Mar 2018
Posts: 3
OshawaPlague is on a distinguished road
Baan: LN - DB: SQL Server - OS: Windows
Red face Production Order Report customization
Baan: ERP LN 6.1 FP8 (Infor ERP 10.2)
C/S: Client

Masters! I beg your help!

I'm currently developing some customizations for a subreport in Production Order report (Material List, Report code: tisfc040804000). My goal is to have the report retrieves serial numbers from table timfc010 (Table name: As-Built Header for Serial End Items).

The problem I have is the report seems not able to retrieve data from timfc010 as it always returned with an empty result, even with hardcoded where clause. The report script was compiled successfully and I'm 100% sure there is data in that table, in fact, I can retrieve them through SQL script, but not in LN. Any thoughts or ideas?

Your help is greatly Appreciated!!!!!!!!!

Here's my code:
-------------------------------------------------------------------------------------------------------
SELECT timfc010.mser
FROM timfc010
WHERE timfc010.pdno = {:tisfc001.pdno}

SELECTDO
y = y + 1
ehc.serial(1, y) = timfc010.mser
SELECTEMPTY
y = y + 1
ehc.serial(1, y) = "Failed"
ENDSELECT
-------------------------------------------------------------------------------------------------------

Last edited by OshawaPlague : 31st March 2018 at 16:37. Reason: Typo
Reply With Quote
  #2  
Old 30th March 2018, 10:34
JaapJD's Avatar
JaapJD JaapJD is offline
Guru
 
Join Date: Sep 2002
Location: Netherlands
Posts: 755
JaapJD will become famous soon enoughJaapJD will become famous soon enough
Baan: BaanIV, BaanERP, ERP LN 6.1 - DB: Oracle, SQL Server - OS: Unix, Windows
Aren't mixing up timfc010 and timfc011?
Reply With Quote
  #3  
Old 31st March 2018, 16:39
OshawaPlague OshawaPlague is offline
Junior Member
 
Join Date: Mar 2018
Posts: 3
OshawaPlague is on a distinguished road
Baan: LN - DB: SQL Server - OS: Windows
Quote:
Originally Posted by JaapJD View Post
Aren't mixing up timfc010 and timfc011?
Oops, thanks Jaap, I also tried fetch it from timfc011.
Reply With Quote
  #4  
Old 20th April 2018, 22:58
lotius81 lotius81 is offline
Junior Member
 
Join Date: Nov 2016
Posts: 29
lotius81 is on a distinguished road
Baan: Infor LN 10.4 - DB: SQL Server - OS: Windows Server 2008
Even though it's compiling successfully are you getting any warnings about layouts not being used?
Reply With Quote
  #5  
Old 24th April 2018, 14:33
OshawaPlague OshawaPlague is offline
Junior Member
 
Join Date: Mar 2018
Posts: 3
OshawaPlague is on a distinguished road
Baan: LN - DB: SQL Server - OS: Windows
Quote:
Originally Posted by lotius81 View Post
Even though it's compiling successfully are you getting any warnings about layouts not being used?
Thank you for your reply lotius.

Nope, there was only one warning about comparing two double types may yield unpredictable result.
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
Effect of adding item in BOM after releasing it's production order VishalMistry Manufacturing & Supply Chain 3 8th October 2011 21:08
Clubbed Production Order amitsdotcom Manufacturing & Supply Chain 1 19th January 2011 06:22
production order VS sales order blanchap Manufacturing & Supply Chain 4 2nd September 2008 16:16
Production Order Deletion DineshSharma Manufacturing & Supply Chain 2 17th April 2007 12:25


All times are GMT +2. The time now is 05:11.


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