Try rebuilding your optimized file by running:

Select * from VendorCredit verify

It is my understanding that if I have a $100 credit that has been applied to four invoices (at $25 each), their would be one entry in the VendorCredit table for $100 and four $25 related entries in the VendorCreditLinkedTxn table with the same TxnID.  In my case, I have 152 credits in VendorCredit and only 98 of them have matching transactions.  The remaining 55 do not have detail records in VendorCreditLinkedTxn.

Am I misunderstanding the relationship between these two tables or am I missing records for some reason?

Thanks Tom for trying to help,

Louis Block

The relationship would be from the VendorCreditExpenseLine and/or VendorCreditItemLine tables and the applied Bills directly. The BillLinkedTxn shows Bills Paid, Re-imbursed Expense Used/Not Used, Checks Used to Pay Bill that are directly tied to the Main Bill Table.

Ok, as far as, "If you have $100 credit that has been applied to four invoices (at $25 each), there would be one entry in the VendorCredit table for $100 and four $25 related entries in the VendorCreditLinkedTxn table with the same TxnID", is concerned, you are correct. I ran this query and got four rows returned, all with different Bills.

SELECT VendorCreditLinkedTxn.TxnID,VendorCreditLinkedTxn.LInkedTxnTxnID,
VendorCreditLinkedTxn.LinkedTxnAmount, Bill.AmountDue, Vendor.Contact
FROM VendorCreditLinkedTxn, Bill, Vendor
where VendorCreditLinkedTxn.LinkedTxnTxnID=Bill.TxnID
and VendorCreditLinkedTxn.VendorRefListID=Vendor.ListID
and VendorCreditLinkedTxn.VendorRefFullName ='ABC Company'