Baanboard.com

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

Retirement Notice

Baanboard is shutting down on 31-dec-2023. See: http://www.baanboard.com/baanboard/showthread.php?t=76043


User login

Frontpage Sponsor

Main

Poll
What do you expect from your SI Implementation partner for the success of ERP implementation.
Bring best practices - Not to offer more CR's Leveraging standard functions
20%
Need more honesty to work with the Users until their processes are fully mapped & Users are trained
40%
Focus on process automation/ integrations/ Real time data/ BI analytics
13%
Stick to basics
27%
Total votes: 15

Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th June 2016, 12:39
naga ch naga ch is offline
Member
 
Join Date: Jan 2016
Posts: 59
naga ch is on a distinguished road
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 - DB: SQL SERVER - OS: WINDOWS
Error while opening opening purchase order
Baan: Other/Unknown
DB: Other/Unknown
OS: Other/Unknown
C/S: None/Unknown

Hi all,

I am getting table does not exist error (506) error while opening Purchase Order.but while checking in GTM the table is existed. please help me what could be the reason for this?

Regards,
Naga
Attached Thumbnails
Click image for larger version

Name:	unable to open purchase order.jpg
Views:	70
Size:	21.8 KB
ID:	6135  
Reply With Quote
  #2  
Old 10th June 2016, 12:53
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Posts: 1,982
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7/D.3 - DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c - OS: HP-UX, W2K3, SLES, RHLE
DLL read.department.....

Quote:
Originally Posted by naga ch View Post
Hi all,

I am getting table does not exist error (506) error while opening Purchase Order.but while checking in GTM the table is existed. please help me what could be the reason for this?

Regards,
Naga
Hello,

check if table Departments exist.

Check also all to tdsls401 related tables are existing.
Regards
__________________
//Bernd

Last edited by bdittmar : 10th June 2016 at 12:54. Reason: Related
Reply With Quote
  #3  
Old 10th June 2016, 21:07
naga ch naga ch is offline
Member
 
Join Date: Jan 2016
Posts: 59
naga ch is on a distinguished road
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 - DB: SQL SERVER - OS: WINDOWS
Hi ,
Thank you for the Reply.
i have checked Departments table and tdpur401 and tdsls401 table also,all are existed .but still i am getting the same error.

Regards,
Naga
Reply With Quote
  #4  
Old 10th June 2016, 22:49
GaryEd GaryEd is offline
Senior Member
 
Join Date: Sep 2001
Location: CT, USA
Posts: 164
GaryEd is on a distinguished road
Baan: 4c4 sp 30 - DB: SQL 2008 R2 - OS: Windows 2008 R2
Windows event viewer should tell you the table that is missing.
__________________
Gary
Reply With Quote
  #5  
Old 11th June 2016, 13:20
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Posts: 1,982
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox Tools 10.7/D.3 - DB: tbase, ms-sql7, oracle10gV1, 11g, 12c, 19c - OS: HP-UX, W2K3, SLES, RHLE
Check table exists and Logfiles

Hello,

as Gary suggested, check the logfiles for further information.
Also check to tdpur401 related tables :
Code:
tdpur400,tccom120,tccom121,tccom130,tccom140,tdipu001,
tcuef002,tcibd006,tdipu046,tcmcs060,tcmcs001,tcmcs005,tcmcs048,
tcmcs003,tcmcs004,tdpur054,tcmcs080,tdpur097,tdpur098,tcmcs010,
tctax016,tcmcs075,tccom705,tcmcs201,tcmcs206,tcmcs013,tcmcs041,
tcmcs042,tccom100,tclct020,tdpur414,tdipu045
Code:
Library tdpurdll0401

Integration to Common - Logistic Data
(49 Functions available)

Function Summary   
boolean  
tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
 
long  
tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
 
long  
tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
 
long  
tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
 
void  
tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
 
boolean  
tdpur.dll0401.employee.exists( domain tcemno i.employee )
 
domain tcncmp  
tdpur.dll0401.financial.company.project( domain tccprj i.project )
 
domain tcncmp  
tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
 
void  
tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
 
domain tcdsca  
tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
 
domain tcctit  
tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
 
domain tcdsca  
tdpur.dll0401.get.country.description( domain tcccty i.country )
 
domain tcemm.enty  
tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
 
domain tcemno  
tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
 
domain tcncmp  
tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
 
domain tcncmp  
tdpur.dll0401.get.operational.company( domain tccwoc i.department )
 
long  
tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
 
domain tcdsca  
tdpur.dll0401.get.title.description( domain tcctit i.title )
 
domain tccom.cadr  
tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
 
void  
tdpur.dll0401.read.address( domain tccom.cadr i.address )
 
void  
tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
 
void  
tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
 
void  
tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
 
void  
tdpur.dll0401.read.country( domain tcccty i.country )
 
void  
tdpur.dll0401.read.currency( domain tcccur i.currency )
 
void  
tdpur.dll0401.read.department( domain tccwoc i.department )
 
void  
tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
 
void  
tdpur.dll0401.read.employee( domain tcemno i.employee )
 
void  
tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
 
void  
tdpur.dll0401.read.item.group( domain tccitg i.item.group )
 
void  
tdpur.dll0401.read.language( domain tcclan i.language )
 
void  
tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
 
void  
tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
 
void  
tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
 
void  
tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
 
void  
tdpur.dll0401.read.price.group( domain tccprg i.price.group )
 
void  
tdpur.dll0401.read.project( domain tccprj i.project )
 
void  
tdpur.dll0401.read.purchase.order.number.group( )
 
void  
tdpur.dll0401.read.reason( domain tccdis i.reason )
 
boolean  
tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
 
void  
tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
 
void  
tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
 
void  
tdpur.dll0401.read.title( domain tcctit i.title )
 
void  
tdpur.dll0401.read.unit( domain tccprj i.unit )
 
void  
tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
 
void  
tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
 
domain tcamnt  
tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
 
domain tcamnt  
tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
 
boolean  
tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
 



  
Function Detail 
 
tdpur.dll0401.carrier.transport.category.is.none
 

boolean tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
 
 Expl:	If transport category of the carrier is not
	applicable then intrastat cannot handle the carrier.
	However: data is allowed so no dal check.
Input:	Carrier to be checked
Return:	True if transport category is none, false otherwise

tdpur.dll0401.check.carrier

long tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
 
 Expl.:	This function checks if the business partner of the
	carrier is valid on a given date.
Input:	i.carrier
	i.delivery.date
Return:	0 if carrier is valid,
	DALHOOKERROR if carrier cannot be used

tdpur.dll0401.check.not.financial.warehouse

long tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
 
 Expl.:	Checks if the warehouse is not a financial warehouse.
	Financial warehouses should not be used within TD,
	they do not represent actual warehouses but are used.
 
tdpur.dll0401.check.order.series
 

long tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
 
 Expl.:	This function checks if a series has been defined for the
	specified number group.
Pre:	NA
Post:	For return value 1-4, error message is set in buffer.
 	This message is filled to be displayed when the order series
 	is not defined or blocked.
Input:	i.number.group -> number group for which the series to
	             	    be checked.
	i.series -> serie that must be checked
Output:	o.error.message
Return:	0 if the order series is defined and not blocked,
	1 if the order series is not defined,
	2 if the order series is blocked,
	3 if the series length does not correspond to number group,
	4 if the series for a numbergroup is full.

tdpur.dll0401.check.order.series.filter
 

void tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
 
 Expl.:	Function returns a query in the form of a string,
	which can be used to set a filter to get the valid
	series for a given number group.
Pre:	NA
Post:	NA
Input:	i.number.group
Output: o.select.filter
	o.from.filter
	o.where.filter
Return:	NA
 
 
tdpur.dll0401.employee.exists
 

boolean tdpur.dll0401.employee.exists( domain tcemno i.employee )
 
 Expl.:	The purpose of this function is to see if the
	employee exists.
Input:	i.employee
Return:	true - employee is present
	false - employee is not present

 
tdpur.dll0401.financial.company.project
 

domain tcncmp tdpur.dll0401.financial.company.project( domain tccprj i.project )
 
 Expl.:	This function determines the financial company associated
	with the project.
Input:	i.project
Return:	Financial Company

tdpur.dll0401.financial.company.purchase.office
 

domain tcncmp tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
 
 Expl.:	This function determines the financial company
	associated to the purchase office. If
	i.purchase.office is empty, the current company is
	returned.
Input:	i.purchase.office
Return:	financial company

tdpur.dll0401.get.city.desc.of.company
 

void tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
 
 Expl.:	Use the function to read the city description of the current
	company
Input:	NA
Output: City Description

tdpur.dll0401.get.city.desc.of.department
 

domain tcdsca tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
 
 Expl.:	Use the function to read the city description of the
	department.
Input:	i.department
Return: City description

tdpur.dll0401.get.contact.title
 

domain tcctit tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
 
 Expl. :	Use the function to get the contact title.
Input :	i.contact
Return: contact title
  
 
tdpur.dll0401.get.country.description
 

domain tcdsca tdpur.dll0401.get.country.description( domain tcccty i.country )
 
 Expl.:	Use the function to read the country description.
Input:	i.country

 
tdpur.dll0401.get.department.entity.type
 

domain tcemm.enty tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
 
 Expl.	: This function determines the department type of the
	  i.department.
Pre	:
Post	:
Input	: i.department
Output	: NA
Return	: department type
  
 
tdpur.dll0401.get.employee.for.logon.code
 

domain tcemno tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
 
 Expl.:	Function can be used to retrieve the employee code
	for a given logon code.
Pre:	NA
Post:	NA
Input:	i.logon.code
Output:	NA
Return:	Employee code

 
tdpur.dll0401.get.financial.company.of.department
 

domain tcncmp tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
 
 Expl.:	Function retrieves the financial company of a
	department. First the department type is determent
	(which can be purchase office or accounting office).
	Next the operational company is determined. For
	purchase offices the operational company always
	equals the current logistic company (get.compnr()).
	For accounting offices the operational company number
	is retrieved via function
	tcint.dlltcemm.get.loco.grid.of.entity.
	Finaly the financial company is determined via the
	enterprise unit details.
Input:	i.department
Output: NA
Return: financial.company

  
 
tdpur.dll0401.get.operational.company
 

domain tcncmp tdpur.dll0401.get.operational.company( domain tccwoc i.department )
 
 Expl.:	This function determines the operation company of a
	department based on the department's entity type.
	For departments other then type 'accounting office' the
	current logistic company is the operational company.
	For an accounting office its financial company is its
	operational company.
Pre:	NA
Post:	NA
Input:	i.department
Output:	NA
Return:	the department's operational company.

 
tdpur.dll0401.get.project.status
 

long tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
 
 Expl.:	This function will get the status & description for a
	Project.
Input:	i.project
Output:	o.status - project status
Return:	0

 
tdpur.dll0401.get.title.description
 

domain tcdsca tdpur.dll0401.get.title.description( domain tcctit i.title )
 
 Expl. :	Use the function to get the title description.
Input :	i.title
Return: title description

  
 
tdpur.dll0401.get.warehouse.address
 

domain tccom.cadr tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
 
 Expl.	: This function returns the address code of the warehouse.

 
tdpur.dll0401.read.address
 

void tdpur.dll0401.read.address( domain tccom.cadr i.address )
 
 Expl.:	Use the function to read the address.
Input:	i.address

 
tdpur.dll0401.read.carrier
 

void tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
 
 Expl.:	Use the function to read the carrier data.
Input:	i.carrier

 
tdpur.dll0401.read.contact
 

void tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
 
 Expl.:	Use the function to read the contact data.
Input:	i.contact

 
tdpur.dll0401.read.cost.component
 

void tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
 
 Expl.:	Use the function to read the cost component data.
Input:	i.cost.component

  
 
tdpur.dll0401.read.country
 

void tdpur.dll0401.read.country( domain tcccty i.country )
 
 Expl.:	Use the function to read the country data.
Input:	i.country

 
tdpur.dll0401.read.currency
 

void tdpur.dll0401.read.currency( domain tcccur i.currency )
 
 Expl.:	Use the function to read the currency data.
Input:	i.currency

 
tdpur.dll0401.read.department
 

void tdpur.dll0401.read.department( domain tccwoc i.department )
 
 Expl.:	Use the function to read the department data.
Input:	i.department

 
tdpur.dll0401.read.discount.code
 

void tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
 
 Expl.:	Use the function to read the discount code data.
Input:	i.discount.code

 
tdpur.dll0401.read.employee
 

void tdpur.dll0401.read.employee( domain tcemno i.employee )
 
 Expl.:	Use the function to read the employee data.
Input:	i.employee
  
 
tdpur.dll0401.read.first.free.numbers
 

void tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
 
 Expl.:	Use the function to read the first free number data.
Input:	i.project

 
tdpur.dll0401.read.item.group
 

void tdpur.dll0401.read.item.group( domain tccitg i.item.group )
 
 Expl.:	Use the function to read the item group data.
Input:	i.item.group

  
 
tdpur.dll0401.read.language
 

void tdpur.dll0401.read.language( domain tcclan i.language )
 
 Expl.:	Use the function to read the language data.
Input:	i.language

 
tdpur.dll0401.read.late.payment.surcharge
 

void tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
 
 Expl.:	Use the function to read the late payment surcharges.
Input:	i.late.payment.surcharge

 
tdpur.dll0401.read.manufacturer
 

void tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
 
 Expl.:	Use the function to read the manufacturer data.
Input:	i.manufacturer

  
 
tdpur.dll0401.read.number.group
 

void tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
 
 Expl. : Use the function to read the number group.

  
 
tdpur.dll0401.read.point.of.title.passage
 

void tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
 
 Expl.:	Use the function to read the point of title passage
Input:	i.point.of.title.passage

 
tdpur.dll0401.read.price.group
 

void tdpur.dll0401.read.price.group( domain tccprg i.price.group )
 
 Expl.:	Use the function to read the price group data.
Input:	i.price.group

 
tdpur.dll0401.read.project
 

void tdpur.dll0401.read.project( domain tccprj i.project )
 
 Expl.:	Use the function to read the project data.
Input:	i.project

 
tdpur.dll0401.read.purchase.order.number.group
 

void tdpur.dll0401.read.purchase.order.number.group( )
 
 Expl.:	Use the function to read the number group for
	purchase orders.

  
 
tdpur.dll0401.read.reason
 

void tdpur.dll0401.read.reason( domain tccdis i.reason )
 
 Expl.:	Use the function to read the reason.
Input:	i.reason

 
tdpur.dll0401.read.rounding.factor
 

boolean tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
 
 Expl.:	Read the rounding factor of the currency belonging to
	a certain company.
	If company = 0 then the current company will be used.
 	Input:	i.company (optional)
	i.currency
Output:	o.rounding.factor
Return:	if found TRUE, otherwise FALSE

  
 
tdpur.dll0401.read.terms.of.delivery
 

void tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
 
 Expl.:	Use the function to read the terms of delivery.
Input:	i.terms.of.delivery

  
 
tdpur.dll0401.read.terms.of.payment
 

void tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
 
 Expl.:	Use the function to read the terms of payment
Input:	i.terms.of.payment

  
 
tdpur.dll0401.read.title
 

void tdpur.dll0401.read.title( domain tcctit i.title )
 
 Expl.:	Use the function to read the title data.
Input:	i.title

  
 
tdpur.dll0401.read.unit
 

void tdpur.dll0401.read.unit( domain tccprj i.unit )
 
 Expl.:	Use the function to read the unit data.
Input:	i.unit

  
 
tdpur.dll0401.read.units.by.language
 

void tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
 
 Expl.:	Use the function to read the units by language
Input:	i.unit
	i.language

  
 
tdpur.dll0401.read.warehouse
 

void tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
 
 Expl.:	Use the function to read the warehouse.
Input:	i.warehouse

  
 
tdpur.dll0401.round.amount
 

domain tcamnt tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
 
 Expl.:	The purpose of this function is to round, if applicable,
	the incoming amount based on the incoming currency.
Pre:	NA
Post:	NA
Input:	i.amount - amoumt that must be rounded
	i.currency - round amount based on this currency
Output:	NA
Return:	rounded amount is returned

 
tdpur.dll0401.round.price
 

domain tcamnt tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
 
 Expl.:	The purpose of this function is to round, if applicable,
	the incoming price based on the incoming currency.
Pre:	NA
Post:	NA
Input:	i.price	-> price that must be rounded
	i.currency	-> round price based on this currency
Output:	NA
Return:	rounded price is returned
 
tdpur.dll0401.rounding.factor.present
 

boolean tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
 
 Expl:	The purpose of this function is to check if a rounding
	factor is linked to the incoming currency.
Input:	i.currency
Return:	true	-> rounding factor found
	false	-> no rounding factor found
Is any customization there ?

Regards
__________________
//Bernd

Last edited by bdittmar : 11th June 2016 at 18:11. Reason: tdpurdll0401 added / Codetags
Reply With Quote
  #6  
Old 14th June 2016, 10:01
naga ch naga ch is offline
Member
 
Join Date: Jan 2016
Posts: 59
naga ch is on a distinguished road
Baan: BAAN IV,FP7,LN 10.2,LN 10.3,10.4 - DB: SQL SERVER - OS: WINDOWS
Quote:
Originally Posted by bdittmar View Post
Hello,

as Gary suggested, check the logfiles for further information.
Also check to tdpur401 related tables :
Code:
tdpur400,tccom120,tccom121,tccom130,tccom140,tdipu001,
tcuef002,tcibd006,tdipu046,tcmcs060,tcmcs001,tcmcs005,tcmcs048,
tcmcs003,tcmcs004,tdpur054,tcmcs080,tdpur097,tdpur098,tcmcs010,
tctax016,tcmcs075,tccom705,tcmcs201,tcmcs206,tcmcs013,tcmcs041,
tcmcs042,tccom100,tclct020,tdpur414,tdipu045
Code:
Library tdpurdll0401

Integration to Common - Logistic Data
(49 Functions available)

Function Summary   
boolean  
tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
 
long  
tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
 
long  
tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
 
long  
tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
 
void  
tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
 
boolean  
tdpur.dll0401.employee.exists( domain tcemno i.employee )
 
domain tcncmp  
tdpur.dll0401.financial.company.project( domain tccprj i.project )
 
domain tcncmp  
tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
 
void  
tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
 
domain tcdsca  
tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
 
domain tcctit  
tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
 
domain tcdsca  
tdpur.dll0401.get.country.description( domain tcccty i.country )
 
domain tcemm.enty  
tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
 
domain tcemno  
tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
 
domain tcncmp  
tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
 
domain tcncmp  
tdpur.dll0401.get.operational.company( domain tccwoc i.department )
 
long  
tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
 
domain tcdsca  
tdpur.dll0401.get.title.description( domain tcctit i.title )
 
domain tccom.cadr  
tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
 
void  
tdpur.dll0401.read.address( domain tccom.cadr i.address )
 
void  
tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
 
void  
tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
 
void  
tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
 
void  
tdpur.dll0401.read.country( domain tcccty i.country )
 
void  
tdpur.dll0401.read.currency( domain tcccur i.currency )
 
void  
tdpur.dll0401.read.department( domain tccwoc i.department )
 
void  
tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
 
void  
tdpur.dll0401.read.employee( domain tcemno i.employee )
 
void  
tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
 
void  
tdpur.dll0401.read.item.group( domain tccitg i.item.group )
 
void  
tdpur.dll0401.read.language( domain tcclan i.language )
 
void  
tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
 
void  
tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
 
void  
tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
 
void  
tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
 
void  
tdpur.dll0401.read.price.group( domain tccprg i.price.group )
 
void  
tdpur.dll0401.read.project( domain tccprj i.project )
 
void  
tdpur.dll0401.read.purchase.order.number.group( )
 
void  
tdpur.dll0401.read.reason( domain tccdis i.reason )
 
boolean  
tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
 
void  
tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
 
void  
tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
 
void  
tdpur.dll0401.read.title( domain tcctit i.title )
 
void  
tdpur.dll0401.read.unit( domain tccprj i.unit )
 
void  
tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
 
void  
tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
 
domain tcamnt  
tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
 
domain tcamnt  
tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
 
boolean  
tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
 



  
Function Detail 
 
tdpur.dll0401.carrier.transport.category.is.none
 

boolean tdpur.dll0401.carrier.transport.category.is.none( domain tccfrw i.carrier )
 
 Expl:	If transport category of the carrier is not
	applicable then intrastat cannot handle the carrier.
	However: data is allowed so no dal check.
Input:	Carrier to be checked
Return:	True if transport category is none, false otherwise

tdpur.dll0401.check.carrier

long tdpur.dll0401.check.carrier( domain tccfrw i.carrier, domain tcdate i.delivery.date )
 
 Expl.:	This function checks if the business partner of the
	carrier is valid on a given date.
Input:	i.carrier
	i.delivery.date
Return:	0 if carrier is valid,
	DALHOOKERROR if carrier cannot be used

tdpur.dll0401.check.not.financial.warehouse

long tdpur.dll0401.check.not.financial.warehouse( domain tccwar i.warehouse )
 
 Expl.:	Checks if the warehouse is not a financial warehouse.
	Financial warehouses should not be used within TD,
	they do not represent actual warehouses but are used.
 
tdpur.dll0401.check.order.series
 

long tdpur.dll0401.check.order.series( domain tcnrgr i.number.group, ref string i.series() )
 
 Expl.:	This function checks if a series has been defined for the
	specified number group.
Pre:	NA
Post:	For return value 1-4, error message is set in buffer.
 	This message is filled to be displayed when the order series
 	is not defined or blocked.
Input:	i.number.group -> number group for which the series to
	             	    be checked.
	i.series -> serie that must be checked
Output:	o.error.message
Return:	0 if the order series is defined and not blocked,
	1 if the order series is not defined,
	2 if the order series is blocked,
	3 if the series length does not correspond to number group,
	4 if the series for a numbergroup is full.

tdpur.dll0401.check.order.series.filter
 

void tdpur.dll0401.check.order.series.filter( domain tcnrgr i.number.group, ref string o.select.filter(), ref string o.from.filter(), ref string o.where.filter() )
 
 Expl.:	Function returns a query in the form of a string,
	which can be used to set a filter to get the valid
	series for a given number group.
Pre:	NA
Post:	NA
Input:	i.number.group
Output: o.select.filter
	o.from.filter
	o.where.filter
Return:	NA
 
 
tdpur.dll0401.employee.exists
 

boolean tdpur.dll0401.employee.exists( domain tcemno i.employee )
 
 Expl.:	The purpose of this function is to see if the
	employee exists.
Input:	i.employee
Return:	true - employee is present
	false - employee is not present

 
tdpur.dll0401.financial.company.project
 

domain tcncmp tdpur.dll0401.financial.company.project( domain tccprj i.project )
 
 Expl.:	This function determines the financial company associated
	with the project.
Input:	i.project
Return:	Financial Company

tdpur.dll0401.financial.company.purchase.office
 

domain tcncmp tdpur.dll0401.financial.company.purchase.office( domain tccwoc i.purchase.office )
 
 Expl.:	This function determines the financial company
	associated to the purchase office. If
	i.purchase.office is empty, the current company is
	returned.
Input:	i.purchase.office
Return:	financial company

tdpur.dll0401.get.city.desc.of.company
 

void tdpur.dll0401.get.city.desc.of.company( ref domain tcdsca o.description mb )
 
 Expl.:	Use the function to read the city description of the current
	company
Input:	NA
Output: City Description

tdpur.dll0401.get.city.desc.of.department
 

domain tcdsca tdpur.dll0401.get.city.desc.of.department( domain tccwoc i.department )
 
 Expl.:	Use the function to read the city description of the
	department.
Input:	i.department
Return: City description

tdpur.dll0401.get.contact.title
 

domain tcctit tdpur.dll0401.get.contact.title( domain tccom.ccnt i.contact )
 
 Expl. :	Use the function to get the contact title.
Input :	i.contact
Return: contact title
  
 
tdpur.dll0401.get.country.description
 

domain tcdsca tdpur.dll0401.get.country.description( domain tcccty i.country )
 
 Expl.:	Use the function to read the country description.
Input:	i.country

 
tdpur.dll0401.get.department.entity.type
 

domain tcemm.enty tdpur.dll0401.get.department.entity.type( domain tccwoc i.department )
 
 Expl.	: This function determines the department type of the
	  i.department.
Pre	:
Post	:
Input	: i.department
Output	: NA
Return	: department type
  
 
tdpur.dll0401.get.employee.for.logon.code
 

domain tcemno tdpur.dll0401.get.employee.for.logon.code( domain tclogn i.logon.code )
 
 Expl.:	Function can be used to retrieve the employee code
	for a given logon code.
Pre:	NA
Post:	NA
Input:	i.logon.code
Output:	NA
Return:	Employee code

 
tdpur.dll0401.get.financial.company.of.department
 

domain tcncmp tdpur.dll0401.get.financial.company.of.department( domain tccwoc i.department )
 
 Expl.:	Function retrieves the financial company of a
	department. First the department type is determent
	(which can be purchase office or accounting office).
	Next the operational company is determined. For
	purchase offices the operational company always
	equals the current logistic company (get.compnr()).
	For accounting offices the operational company number
	is retrieved via function
	tcint.dlltcemm.get.loco.grid.of.entity.
	Finaly the financial company is determined via the
	enterprise unit details.
Input:	i.department
Output: NA
Return: financial.company

  
 
tdpur.dll0401.get.operational.company
 

domain tcncmp tdpur.dll0401.get.operational.company( domain tccwoc i.department )
 
 Expl.:	This function determines the operation company of a
	department based on the department's entity type.
	For departments other then type 'accounting office' the
	current logistic company is the operational company.
	For an accounting office its financial company is its
	operational company.
Pre:	NA
Post:	NA
Input:	i.department
Output:	NA
Return:	the department's operational company.

 
tdpur.dll0401.get.project.status
 

long tdpur.dll0401.get.project.status( domain tccprj i.project, ref domain tcmcs.st30 o.status )
 
 Expl.:	This function will get the status & description for a
	Project.
Input:	i.project
Output:	o.status - project status
Return:	0

 
tdpur.dll0401.get.title.description
 

domain tcdsca tdpur.dll0401.get.title.description( domain tcctit i.title )
 
 Expl. :	Use the function to get the title description.
Input :	i.title
Return: title description

  
 
tdpur.dll0401.get.warehouse.address
 

domain tccom.cadr tdpur.dll0401.get.warehouse.address( domain tccwar i.warehouse )
 
 Expl.	: This function returns the address code of the warehouse.

 
tdpur.dll0401.read.address
 

void tdpur.dll0401.read.address( domain tccom.cadr i.address )
 
 Expl.:	Use the function to read the address.
Input:	i.address

 
tdpur.dll0401.read.carrier
 

void tdpur.dll0401.read.carrier( domain tccfrw i.carrier )
 
 Expl.:	Use the function to read the carrier data.
Input:	i.carrier

 
tdpur.dll0401.read.contact
 

void tdpur.dll0401.read.contact( domain tccom.ccnt i.contact )
 
 Expl.:	Use the function to read the contact data.
Input:	i.contact

 
tdpur.dll0401.read.cost.component
 

void tdpur.dll0401.read.cost.component( domain tccpcp i.cost.component )
 
 Expl.:	Use the function to read the cost component data.
Input:	i.cost.component

  
 
tdpur.dll0401.read.country
 

void tdpur.dll0401.read.country( domain tcccty i.country )
 
 Expl.:	Use the function to read the country data.
Input:	i.country

 
tdpur.dll0401.read.currency
 

void tdpur.dll0401.read.currency( domain tcccur i.currency )
 
 Expl.:	Use the function to read the currency data.
Input:	i.currency

 
tdpur.dll0401.read.department
 

void tdpur.dll0401.read.department( domain tccwoc i.department )
 
 Expl.:	Use the function to read the department data.
Input:	i.department

 
tdpur.dll0401.read.discount.code
 

void tdpur.dll0401.read.discount.code( domain tccdsc i.discount.code )
 
 Expl.:	Use the function to read the discount code data.
Input:	i.discount.code

 
tdpur.dll0401.read.employee
 

void tdpur.dll0401.read.employee( domain tcemno i.employee )
 
 Expl.:	Use the function to read the employee data.
Input:	i.employee
  
 
tdpur.dll0401.read.first.free.numbers
 

void tdpur.dll0401.read.first.free.numbers( domain tcnrgr i.number.group, domain tcseri i.series )
 
 Expl.:	Use the function to read the first free number data.
Input:	i.project

 
tdpur.dll0401.read.item.group
 

void tdpur.dll0401.read.item.group( domain tccitg i.item.group )
 
 Expl.:	Use the function to read the item group data.
Input:	i.item.group

  
 
tdpur.dll0401.read.language
 

void tdpur.dll0401.read.language( domain tcclan i.language )
 
 Expl.:	Use the function to read the language data.
Input:	i.language

 
tdpur.dll0401.read.late.payment.surcharge
 

void tdpur.dll0401.read.late.payment.surcharge( domain tcccrs i.late.payment.surcharge )
 
 Expl.:	Use the function to read the late payment surcharges.
Input:	i.late.payment.surcharge

 
tdpur.dll0401.read.manufacturer
 

void tdpur.dll0401.read.manufacturer( domain tcmcs.cmnf i.manufacturer )
 
 Expl.:	Use the function to read the manufacturer data.
Input:	i.manufacturer

  
 
tdpur.dll0401.read.number.group
 

void tdpur.dll0401.read.number.group( domain tcnrgr i.number.group )
 
 Expl. : Use the function to read the number group.

  
 
tdpur.dll0401.read.point.of.title.passage
 

void tdpur.dll0401.read.point.of.title.passage( domain tcptpa i.point.of.title.passage )
 
 Expl.:	Use the function to read the point of title passage
Input:	i.point.of.title.passage

 
tdpur.dll0401.read.price.group
 

void tdpur.dll0401.read.price.group( domain tccprg i.price.group )
 
 Expl.:	Use the function to read the price group data.
Input:	i.price.group

 
tdpur.dll0401.read.project
 

void tdpur.dll0401.read.project( domain tccprj i.project )
 
 Expl.:	Use the function to read the project data.
Input:	i.project

 
tdpur.dll0401.read.purchase.order.number.group
 

void tdpur.dll0401.read.purchase.order.number.group( )
 
 Expl.:	Use the function to read the number group for
	purchase orders.

  
 
tdpur.dll0401.read.reason
 

void tdpur.dll0401.read.reason( domain tccdis i.reason )
 
 Expl.:	Use the function to read the reason.
Input:	i.reason

 
tdpur.dll0401.read.rounding.factor
 

boolean tdpur.dll0401.read.rounding.factor( domain tcncmp i.company, domain tcccur i.currency, ref domain tccrnd o.rounding.factor )
 
 Expl.:	Read the rounding factor of the currency belonging to
	a certain company.
	If company = 0 then the current company will be used.
 	Input:	i.company (optional)
	i.currency
Output:	o.rounding.factor
Return:	if found TRUE, otherwise FALSE

  
 
tdpur.dll0401.read.terms.of.delivery
 

void tdpur.dll0401.read.terms.of.delivery( domain tccdec i.terms.of.delivery )
 
 Expl.:	Use the function to read the terms of delivery.
Input:	i.terms.of.delivery

  
 
tdpur.dll0401.read.terms.of.payment
 

void tdpur.dll0401.read.terms.of.payment( domain tccpay i.terms.of.payment )
 
 Expl.:	Use the function to read the terms of payment
Input:	i.terms.of.payment

  
 
tdpur.dll0401.read.title
 

void tdpur.dll0401.read.title( domain tcctit i.title )
 
 Expl.:	Use the function to read the title data.
Input:	i.title

  
 
tdpur.dll0401.read.unit
 

void tdpur.dll0401.read.unit( domain tccprj i.unit )
 
 Expl.:	Use the function to read the unit data.
Input:	i.unit

  
 
tdpur.dll0401.read.units.by.language
 

void tdpur.dll0401.read.units.by.language( domain tccuni i.unit, domain tcclan i.language )
 
 Expl.:	Use the function to read the units by language
Input:	i.unit
	i.language

  
 
tdpur.dll0401.read.warehouse
 

void tdpur.dll0401.read.warehouse( domain tccwar i.warehouse )
 
 Expl.:	Use the function to read the warehouse.
Input:	i.warehouse

  
 
tdpur.dll0401.round.amount
 

domain tcamnt tdpur.dll0401.round.amount( domain tcamnt i.amount, domain tcccur i.currency )
 
 Expl.:	The purpose of this function is to round, if applicable,
	the incoming amount based on the incoming currency.
Pre:	NA
Post:	NA
Input:	i.amount - amoumt that must be rounded
	i.currency - round amount based on this currency
Output:	NA
Return:	rounded amount is returned

 
tdpur.dll0401.round.price
 

domain tcamnt tdpur.dll0401.round.price( domain tcpric i.price, domain tcccur i.currency )
 
 Expl.:	The purpose of this function is to round, if applicable,
	the incoming price based on the incoming currency.
Pre:	NA
Post:	NA
Input:	i.price	-> price that must be rounded
	i.currency	-> round price based on this currency
Output:	NA
Return:	rounded price is returned
 
tdpur.dll0401.rounding.factor.present
 

boolean tdpur.dll0401.rounding.factor.present( domain tcccur i.currency )
 
 Expl:	The purpose of this function is to check if a rounding
	factor is linked to the incoming currency.
Input:	i.currency
Return:	true	-> rounding factor found
	false	-> no rounding factor found
Is any customization there ?

Regards

Hi,
No customization's done till now.But i am getting this type of error(table does not exist) for more sessions like
1.Item ordering(tcibd2500m000)
2.Item planning((cprpd1100m000)
3.Creation of production order(tisfc0101m100)

Please help me how to resolve all this??

Regards,
Naga.
Attached Thumbnails
Click image for larger version

Name:	pastedImage.png
Views:	51
Size:	229.7 KB
ID:	6139  
Reply With Quote
  #7  
Old 17th June 2016, 23:42
bmcfarla bmcfarla is offline
Junior Member
 
Join Date: Jun 2002
Location: San Jose
Posts: 6
bmcfarla is on a distinguished road
Baan: Baan IV, Baan ERP, LN 10.4 - DB: Oracle, SQL Server 2008, 2012, 2014 - OS: UNIX, Windows
These types of errors don't usually occur at random. Were any actions taken recently on the server?

Hard to tell which table is missing based on your screenshot. The LN server's Event Viewer would certainly help.

It could be the warehouse table or any other number of tables.

Is this your PROD environment? If not, worst case scenario, you could run the "Create table" Session full range. It will create any missing tables.

Also, if you are sharing tables, you might want to review those as well.
Reply With Quote
  #8  
Old 31st August 2022, 17:25
mroset mroset is offline
Junior Member
 
Join Date: Jun 2002
Location: NL
Posts: 11
mroset is on a distinguished road
Baan: Baan IVc, BaanERP, ERPLN 6.1, Basware IP and Alusta, Palette Arena (P2P), AX 3-4-2009-2012-AX7-AX365 - DB: Oracle,Informix,SQL7/2k/2k3/2k8/2k12 - OS: UNIX, NT, 2000, 2003,2008,2012, 2016
Late to the party, but nevermind...
Step 1 As other suggested already: this should be checking the Event Viewer on the LN-hostserver. That will tell you which table exactly is supposedly missing (and in which company)
Step 2 Is analyze the reason behind what you found at step 1

NOTE: Most common culprit (based on my experience) for this error popping up is the LN-logic refers to company 000 (Tools) for the table indicated. So in this case this becomes a matter of finding out why/where the 000 is coming from that's dynamically determined often (in multisite setups especially, although this may well occur for single-log/single-fin environments as well !). That on it's turn could well be a table field in some other table that's filled with company '000' . Reasons for that will differ from situation to situation. Sometimes a data migration from one feature pack to another and having forgotten to run all conversion scripts in order to fill all (new) table fields could well be the reason for this effect....

In any case, if you fill the related company field with an actual and proper value, you should be able to fix the 'collateral damage' error message 'table does not exist' as well.
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
Generate Purchase Order advice from sales order SoerenH Distribution, Transportation & Warehousing 2 5th March 2012 12:46
Dal king1980 Tools Development 6 19th March 2010 13:10
Payment term at Purchase Order teddybear Distribution, Transportation & Warehousing 0 20th September 2005 08:10
Subcontracting Purchase Order LittleJohn Manufacturing & Supply Chain 3 30th May 2005 06:01
purchase order activity skipped rcitra Distribution, Transportation & Warehousing 8 21st February 2005 03:30


All times are GMT +2. The time now is 01:15.


©2001-2023 - Baanboard.com - Baanforums.com