Baanboard.com

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

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 11th February 2017, 04:09
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
search sales invoices without sales orders
Baan: Other/Unknown

what is the best way to do this? i thought i would start from tfacr200, then compare the invoice number with tdsls041 or 051? I am not getting good results. any suggestion?
i am on IVc2. thanks.
Reply With Quote
Sponsored Links
  #2  
Old 11th February 2017, 04:41
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
follow up question. how about for purchase orders? i thought that would be from pur046 (purchase invoices)?
Reply With Quote
  #3  
Old 11th February 2017, 07:59
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi Benito,

Is there a concept of Manual Sales Invoices in your version? On LN, there is a table for manual sales invoices where the invoice is booked without the sales order.

Also, the purchase invoices should be present in tfacp200 if that table exists.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #4  
Old 11th February 2017, 16:31
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
Hi bushan, thank you. They do have a concept of manual invoicing and it's not as obvious as LN because you just insert a record in Finance (as with other transactions) (***baanIVc experts correct me if i'm wrong). so i guess i have to query acr200 - invoices in tdsls045. this could result in records in tfacr400?? or maybe i should assume that all records in tfacr400 have no sales orders?
Reply With Quote
  #5  
Old 27th February 2017, 18:02
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
Look for invoice number in tdsls045.You can use tfacr200 and if the invoice is not in tdsls045, then these are without sales order.
Reply With Quote
  #6  
Old 27th February 2017, 18:05
avpatil avpatil is offline
Guru
 
Join Date: Feb 2002
Posts: 710
avpatil is on a distinguished road
Baan: IVc3 - DB: SQL2000 - OS: Win 2003
For Purchase order also you can use tfacp200 and compare with tdpur046. But these shall only for invoices that are matched. Also in tfacp200 there is a flag matched with order also present.
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
purpose of qss.start VishalMistry Tools Development 3 25th January 2017 19:20
blocking orders at the sales order line stage panindub Distribution, Transportation & Warehousing 3 15th December 2008 15:14
Best way to remove sales orders? Archive or Copy Company? bmorris Archiving & Multisite 3 8th December 2008 16:04
Manipulating Sales Orders in LN6 ? Trisli AFS/DDC/OLE: Function servers 3 22nd October 2005 15:12
Block Sales orders if invoices are overdue amarpreet Distribution, Transportation & Warehousing 3 12th December 2002 12:57


All times are GMT +2. The time now is 21:52.


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