Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

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

Reply
 
Thread Tools Display Modes
  #1  
Old 13th December 2006, 06:19
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
matching the receipt with an invoice
Baan: iBaanERP 5.0c

Hi,

I have found that in tables tfacp250 baan is saving the information related to the invoices link with purchase orders and tfacp251 baan is saving the information related to the invoices link with receipts, but i saw that there are some receipts that are not linked to an invoice, but the purchase order is in the table tfacp250.

How can i know what receipts are linked to that invoice in tfacp250 if there is not receipts in tfacp251?. i thougt that maybe in tdpur401, but what happen with parcial receipts?.

Thank you in advance for your great help.

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
Reply With Quote
  #2  
Old 18th December 2006, 16:16
Michiel Leerkes Michiel Leerkes is offline
Junior Member
 
Join Date: Jan 2006
Posts: 8
Michiel Leerkes is on a distinguished road
Baan: ERP5.0c SSA ERP LN 6.1 - DB: oracle - OS: unix
Hi there,

You have two matching scenario's:
1) Match to Receipt; the link to each individual receipt is stored in table tfacp251 and at the same time in tfacp250 (link to order line/sequence).
2) Match to Order; the user is apparently not interested in the receipts. You just match to orderline/sequence. During approval the system just checks whether there is enough received approved quantity, but there is not link created between the invoice and the receipts.

So if you have tfacp250 records and no tfacp251 records, then it means that your invoice was used in the "Match to Order" procedure and you do not know the link with the receipts.

Regards,
Michiel
Reply With Quote
Sponsored Links
  #3  
Old 26th December 2006, 17:16
ckassab's Avatar
ckassab ckassab is offline
Member
 
Join Date: Dec 2004
Location: Guadalajara, Jalisco, México
Posts: 45
ckassab is on a distinguished road
Baan: VI,V - DB: Oracle,SQL Server - OS: SUN, Windows
Thank you

Quote:
Originally Posted by Michiel Leerkes View Post
Hi there,

You have two matching scenario's:
1) Match to Receipt; the link to each individual receipt is stored in table tfacp251 and at the same time in tfacp250 (link to order line/sequence).
2) Match to Order; the user is apparently not interested in the receipts. You just match to orderline/sequence. During approval the system just checks whether there is enough received approved quantity, but there is not link created between the invoice and the receipts.

So if you have tfacp250 records and no tfacp251 records, then it means that your invoice was used in the "Match to Order" procedure and you do not know the link with the receipts.

Regards,
Michiel
Michiel, Thank you very much for your help

Carlos Kassab
__________________
Consultant
ERP BaaN Tools
BaaN Exchange
BaaN OLE Automation
JasperSoft OLAP Business Intelligence.
BOBS Main Developer
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
open purchase order with wrong price nopadon Distribution, Transportation & Warehousing 2 4th March 2006 15:11
Discrepancy between receipt qty and invoice qty teddybear Finance, Invoicing and Integration 1 29th July 2005 09:56
Invoice consider the receipt schedule or not??? mostrightfuture Finance, Invoicing and Integration 0 1st July 2005 09:08
purchase invoice matching with stores receipts rdheeraj Finance, Invoicing and Integration 1 10th January 2002 11:38
Invoice Matching Problem rdheeraj Finance, Invoicing and Integration 3 7th January 2002 13:25


All times are GMT +2. The time now is 04:19.


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