Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


Google search

How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
200 - 500 GB
500 - 800 GB
800 - 1200 GB
1200 - 1500 GB
1500 - 2000 GB
> 2000 GB
Total votes: 4

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 7th March 2017, 03:50
DatinN DatinN is offline
Join Date: Aug 2014
Posts: 65
DatinN is on a distinguished road
Baan: FP7 - DB: SQL - OS: Windows
Query Purchase Order Line
Baan: ERP LN 6.1 FP6

Hello ,

Hi All ..
I need your expert view .
I'm creating query to ease my user checking incomplete delivery .
This because user need to close Purchase Order once over validity period.
The issue now I'm facing, when user has Cancelled Back Order, this query still displaying the said order line.
I have set condition where quantity receipt and quantity delivered below than quantity ordered and not final receipt.
also condition not to print cancelled order line.
I need to rectify this query yet I 'm getting road block.
how to set this query not to print cancelled back order ?

thank you in advance .

The query text as below :

tdpur400.orno, | Purchase Order
tccom100.nama, | Name
tccom001.nama, | Name
tdpur401.odat, | Order Date
tdpur401.item, | Item
tdpur401.cwar, | Warehouse
tdpur401.ddta | Planned Receipt Date
tccom001, | Employees - General
tccom100, | Business Partners
tdpur400, | Purchase Orders
tdpur401 | Purchase Order Lines
tdpur401.odat >= tdpur401.odat.f and
tdpur401.odat <= tdpur401.odat.t and
tdpur401.otbp >= tdpur401.otbp.f and
tdpur401.otbp <= tdpur401.otbp.t and
tdpur400.ccon >= tdpur400.ccon.f and
tdpur400.ccon <= tdpur400.ccon.t and
tdpur400.ccon = tccom001.emno and
tdpur400.hdst <> tdpur.hdst.closed and
tdpur400.hdst <> tdpur.hdst.cancelled and
tdpur400.orno = tdpur401.orno and
tdpur401.clyn = and = and
tdpur401.otbp = tccom100.bpid and
tdpur401.qoor > tdpur401.qidl and
tdpur401.qoor > tdpur401.qiap
order by
Reply With Quote
Sponsored Links
Old 22nd March 2017, 08:09
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 150
sasikanth is on a distinguished road
Baan: L.N 6.1 FP7, 10.3, 10.4 & 10.5 - DB: SQL Server - OS: Windows
Try considering the tdpur401.oltp field in your query.

You should ideally ignore the Line Type - "Total" (

Hope this should help you!
Sasi Kanth V
Infor ERP LN Solution Architect

Reach Me Out on LinkedIn | Never Miss an Update from LN Campus YouTube Channel
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
User Not Allow Insert Price In Purchase Order Line sobiratul Distribution, Transportation & Warehousing 2 8th July 2016 23:16
DAL 2 for purchase order line baanspider AFS/DDC/OLE: Function servers 1 26th February 2009 07:15
AFS on purchase order header and line creation baanguy2 AFS/DDC/OLE: Function servers 3 10th January 2008 20:30
Purchase Order Line Status = 0 ?? rodichen Distribution, Transportation & Warehousing 4 6th June 2006 12:52

All times are GMT +2. The time now is 10:27.

©2001-2018 - -