Guys

I am new to Baan. We currently have a client using Baan and is requesting a report to see all Invoice details entered with payment detail. I have no idea where to start. TTFACP200 seems like a good place to start. I can see the "Purchase Invoice" and "Normal Payment". What joins/links these 2 lines? ( I cant see anything that will work) I am using SQL and received the data of the different tables in txt format.

Will ttfacp200 give me the Payment Batch as per the "Payment Advice"

Your help will REALLY HELP!!!!!

Christo

I will leave this here to see if it gets any responses, but it sounds more like a finance question. That is who I would direct this to at the company I work for - get them to explain to me how to trace through the records. I do know the primary index fields of ttyp and ninv, play a role in this - but that is all I recall. Lets see what other responses you get from the tools forum.

Hello,

table tfacp200 contains all transactions for suppliers.
Your supplier invoices are registered therein with a transaction type and a document number. The amount is positive for an invoice.
The table index1 contains 6 fields.
The invoice is registered with all subsequent index fields = blank or zero.
If a payment is linked with the invoice then a second record with the same transaction type and document number is created but the second transaction type (field4) and document number (field 5) are filled: this is the payment transaction. the amount is then negative.

the payment transaction can be retrieved. with the transaction type (4) and document (5).
If more than 1 payment is done then additional lines are added.

Regards
Philippe

So if I understand you correct. If I want to display the payment next to the Invoice transaction my join/link would be on ttyp and ninv?

Is it possible that more than 1 invoice can have the same ttyp and ninv?

Hello,

All lines with same ttyp and ninv are related, if the fields tdoc and docn are filled this is or a correction or a payment.
With tdoc you can read table tfgld011 and find if it is a category cash : this is then a payment.
I think that different invoices can have the same payment document.

Regards
Philippe

I Agree invoices can have the same payment document but surely the date of the payment document should be the same in ttfacp200?

This is what I am seeing

Hello,

I find one thing strange : the 4 first lines have the same index. This should not be possible.
Field tpay for payment contains 10 (unallocated payment) or 14 (assignment) or 8 anticipated payment.

Regards
Philippe