AP_TransactionPaymentHistory     would be a good place to start      

Thank you, yes I do see payments in AP_TransactionPaymentHistory with TransactionType = P

Odd that ApplytoInvoice is null yet I see the payment applied.

It must be applied based on merely the fact that the Invoice numbers between Type=I and Type=P are the same.

Working on my Sage Visual Integrator job to mark these invoices as paid.

I guess I will start trying to import payments into AP_TransactionPaymentHistory.

I wish I new what the AP_TransactionPaymentHistory CheckType letters meant.   

Is there any schema or table structure documentation for VI import jobs that you know of, or trial and error?

If you are trying to record in Sage 100, payments processed outside of Sage100, you probably want to do your import to AP_ManualCheckHeader.  Then post normally.

Table information is available to you in the Information Center > Resources > File Layouts and Program Information.  Choose File Layouts under Contents.  Choose the table name and the table information will display.  You posted "I wish I new what the AP_TransactionPaymentHistory CheckType letters meant", that is answered in the file layout.

Under NO circumstances should you attempt to import into that file to mark invoices as paid. You would be in for a world of hurt.  You should use some type of transaction entry such as manual check entry and then post. This insures that ALL tables that are effected when an invoice is paid are written out to correctly.

Under NO circumstances should you attempt to import into that file to mark invoices as paid. You would be in for a world of hurt.  You should use some type of transaction entry such as manual check entry and then post. This insures that ALL tables that are effected when an invoice is paid are written out to correctly.

So if I import payments into AP_ManualCheckHeader, I should then be able to use  Manual Check Entry to post the payments?

Or are you saying I should NOT import payments at all?

(Thank you guys for you help BTW).

Yes, you do post that way.  Imports should replace manual data entry, not bypass programmed business object processes. 

Importing to the data entry tables is normal activity.  If you don't know what data entry table is appropriate, just ask, explaining the business problem you want to solve. 

Start with a technical question, and you may be lead further in the wrong direction.