Forums
S3 Interfaces/Conversion
Interface to Lawson
Author
Messages
mil0n023
Veteran Member
Posts: 63
8/14/2006 6:38 PM
As I mentioned before, we are moving to a program called EPIC to do some of the financial work - Pateient Refunds - that send a csv to us to import to APCINVOICE.
I have a couple of questions about the refund file before I ship it off to Epic.
CVI-VENDOR - Spec states that this field is alpha. Can I put a numeric value here for the vendor ID? YES.
CVI-BATCH-NUMB - Is this the date of the file?
CVI-TAX-PNT-DATE - Is this the date of the file?
CVI-DUE-DATE - Is this the date of the file?
CVI-PO-NUM - Is this hardcoded to "KDBAYN"?
CVI-DIST-CODE - Is this hardcoded to "PTR"?
CVI-INVOICE-GROUP - Is this hardcoded to "PTR"?
CVI-ACCR-CODE - Is this hardcoded to "IVNA"?
CVI-PROC-LEVEL - Is this hardcoded to "1"?
CVI-BASE-INV-AMT - States field is required but it is blank. Is blank OK?
CVI-CHECK-DATE - States field is required but it is blank. Is blank OK?
CVI-TRAN-INV-AMT - Does this need to be left zero padded?
CVI-OLD-VENDOR - Spec says this field is not being used but there is a space in the file.
CVI-AUTO-MATCH - Spec says this field is not being used and there is no space in the file.