Interface to Lawson

 0 Replies
 0 Subscribed to this topic
 11 Subscribed to this forum
Sort:
Author
Messages
mil0n023
Veteran Member
Posts: 63
Veteran Member
    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.
    M. C. Miller
    Analyst
    Salem, Oregon