Hi,

When we do enter a supplier invoice (thru session Maintain Transactions) and "match & approve" with Purchase receipt, does the system store the linking (invoice document no. with purchase receipt no.) in any of the tables? If yes, what is/are the table(s)? Is there any display/print session which can give me the receipt nos. which an invoice document has linked? We have checked in tdpur045, tfacp200, tfgld106, tfgld102. Could not find in any of them.
We are on Baan IV c4, IN5.
Please help.

Warm Regards
Manu

I have not available my system right now, but if I remeber well it was this table. What I think is that it is in tdpur04? table. (Not sure about 6)

.

yes, tdpur046 has the invoice number line to a purchase order line. You will have to take this info to look at tdpur045 if you want the actual reciept number

The receipt link to invoice is stored in tdpur046, tdpur045 also has the receipt links and the flag which shows if the receipt line has been matched with the invoice.

I hope this helps !

Manu,

You can also try the Baan GRINYA solution. This is an additional solution that may or may not be loaded on your system (depending on how up to date you are with patches, etc.). The nice thing about this solution is that it allows you to see the transactional flow of a purchase receipt from logistics to finance. It also allows you to see where you have differences in orders, creating an imbalance between finance and logistics.

Baan really listened to their customers on this solution. Moreover, they keep improving with the suggestions they get from the customers using the GRINYA solution.

Ken

RE: Showing the links

Also can see the links in standard (non-GRINYA) Baan under AP reports.

I'm not in front of a menu browser but I believe it's Accounts Payable / Transaction Processing / Reports / Print Purchase Invoices (tfacp2421m000).

The report has an option to include paid invoices (Yes/No). Like lots of older Baan it's not exactly what it promises. "Yes" just adds the approval invoice number(s) below each purchase receipt line. The standard report has PO# and Line # but does not have the PUR receipt number. Since the report already draws data from pur045 and pur046, however, I remember that Receipt # was quite easy to add.

Scott

RE: Showing the Links

Oops! My error. I think the report name is Print Purchase Receipts. It is an acp report and I think the menu path I gave is correct but I don't think it's acp2421m000. (I'm still not on line so I won't try to requote the correct session #.)

Scott

Yes it is "Print Purchase Receipts" (tfacp1430m000) and you can get the related invoice nos by specifying "Print Matched Invoices" as "Yes" on the form.
BTW, thanks a lot for all your help. I just needed the info about table tdpur046.

Warm Regards
Manu