Sage 100

I am attempting to import via VI into AR_InvoiceHistoryHeader table on 4.40.0.6 to correct incorrect cogs postings. I receive an error on the job log referencing that the Corporate Tax Overrd and the Deposit Corporate Tax Overrd fields are required. It imports 117 records out of 2499? Why does it allow these 117? They are not any different than the other 2382. However as soon as I add these to the job I can't even run it. I receive an error 65 AR_CreditCardCommonEntry.pvc line 01790 and it aborts the job. I have not found anything on the KB about it.

Those are Y/N fields. Are you assigning themin your job as N?

Yes I assigned an N

Buffy may I ask why you are even bothering with this if the real issue is COGS. Wouldn't you just make a GL entry.

Sure...this file is used when running multple sales history reports.

I have found that you can sometimes get around this type of problem when fixing existing records by setting the import of those fields to File Assign and have them look up the existing value in the file.

The correct answer is to make the Assign to a Y not an N.