Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
18%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
12%
1500 - 2000 GB
18%
> 2000 GB
24%
Total votes: 17

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 29th July 2018, 03:22
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Exclamation Problem manual insertion or AFS in maintain inbound
Baan: Baan IVc4
C/S: None/Unknown

Hi friends,

When i do manual db.insert for the fginv line in table tdilc402 using receipt line it was giving error 606 reference does not exist due to warehouse(tdilc402.cwar = tdrpl100.dwar and location tdilc402.loca = "FGINV" field (order type is RPL).


If i try below code using AFS code for multiple lines maintain inbound it was getting inside 5th line error message, don't know what it preferring.

rc = stpapi.browse.set("tdilc4515s000","first.set", msg)
rc = stpapi.mark("tdilc4515s000",msg)
stpapi.continue.process("tdilc4515s000",msg)
if not isspace(msg) or rc<>1 then
stpapi.end.session("tdilc4515s000")
stpapi.end.session("tdilc4104s000")
stpapi.end.session("tdilc4103m000")
return
endif



Please help me in any one of the way to create multiple FGINV location line using location RECEIPT in tdilc402(maintain inbound) table.

Last edited by mathew : 29th July 2018 at 04:03.
Reply With Quote
  #2  
Old 29th July 2018, 03:29
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Hi friends it is creating problem doing manual insertion of fginv line using db.insert query with receipt line, due to warehouse and location field raising error 606 reference does not exist.

Also maintain inbound afs code not inserting multiple fginv lines using receipt location in tdilc402. Please help on this issues

Last edited by mathew : 29th July 2018 at 03:36.
Reply With Quote
  #3  
Old 29th July 2018, 18:23
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
You can check this http://www.baanboard.com/baanboard/s...=tdilc4515s000 thread to see if it helps any. I assume you made sure the location and warehouse are correct and the reference does exist. I have not done replenishment orders thru AFS - just inbound. The thread does mention some solutions to look at.
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #4  
Old 9th August 2018, 20:00
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Thanks for your reply Mark. I have fixed the issue.
Reply With Quote
  #5  
Old 12th August 2018, 16:45
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,122
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
How did you fix it?
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #6  
Old 4th October 2018, 07:49
mathew mathew is offline
Member
 
Join Date: Feb 2012
Posts: 36
mathew is on a distinguished road
Baan: Baan IV C4 - DB: Oracle 8 - OS: Windows Server 2003
Thumbs up

Sorry for late reply Mark, it is leading spaces issue, i have checked the space how they used and defined the values as " " & tdilc402.loca.So it is fixed .
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
Maintain receipt problem ryanwee510 Distribution, Transportation & Warehousing 2 29th April 2009 08:13
Problem inserting in "Maintain Lots" tdltc0101m000 (AFS) Jaroslaw AFS/DDC/OLE: Function servers 4 3rd April 2006 20:21
AFS: Maintain Production Order: Routing field problem khadarBaaNBoard AFS/DDC/OLE: Function servers 1 30th March 2006 17:09
Maintain Outbound in AFS fails for Order Type: "Collect Order" FoxZapper AFS/DDC/OLE: Function servers 7 3rd November 2005 14:45
AFS on Maintain Production Order jp.aalders AFS/DDC/OLE: Function servers 6 23rd December 2004 12:40


All times are GMT +2. The time now is 07:24.


©2001-2018 - Baanboard.com - Baanforums.com