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
35%
Installation Wizard into new VRC
42%
Manual into existing VRC
3%
Manual into new VRC
19%
Total votes: 31

Baanboard at LinkedIn


Reference Content

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10th January 2017, 17:05
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 567
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Wink Relation between tfacp200 & tdpur046
Baan: Baan IVc4
C/S: Both

Hello everyone,

This is related to Baan IV.

we have a report requirement with following details:

Supplier Tran.type Doc.No Invoice amt Order Order amt
abc FIP 20090001 1000 100001 500
abc FIP 20090001 1000 100002 500

here, invoice FIP 2009000 is paid against two purchase orders (records from tdpur046). Is there any way to join these two tables (obviously based on ttyp and ninv) in such a way that if a matching record is not found in tdpur046, the fields from tdpur046 will be blank but the values from tfacp200 will be printed. I could not find any way to use "refers to" as there is no native relationship between these two tables. One way is I can use is as below:
tfacp200.ttyp = tdpur046.ttyp and tfacp200.ninv = tdpur046.invn

ON THE FORM FOLLOWING FIELDS WILL BE USED AS SELECTION CRITERIA:

SUPPLIER FROM - TO
PURCHASE ORDER FROM - TO
TFACP200.TTYP FROM - TO
TFACP200.NINV FROM- TO

Is there any way out to overcome this problem ?

Vishal
Reply With Quote
 


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
JV Transaction in tfacp200 johnmark Tools Development 4 20th March 2013 06:06
Pick up of default Bank relation while processing payments fionad Finance, Invoicing and Integration 2 29th August 2012 17:15
Pegging Relation quelle Manufacturing & Supply Chain 5 23rd December 2009 04:06
Restoring tdpur046 records manish_patel Finance, Invoicing and Integration 9 25th April 2007 03:50
Finace - Logistic co. relation concept in LN satinderg Finance, Invoicing and Integration 2 2nd January 2006 09:57


All times are GMT +2. The time now is 06:35.


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