View Single Post
  #2  
Old 22nd March 2017, 09:09
sasikanth's Avatar
sasikanth sasikanth is offline
Senior Member
 
Join Date: Jul 2009
Location: Hyderabad, Andhra Pradesh, India
Posts: 149
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" (tcgen.oltp.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