VI Import to Invoice Credit Memo

Hello,

I have a Invoice type credit memo that I need to do and it's about 800 line items. What table, fields and their parameters I need to setup for an invoice credit memo import. I appreciate your help in advance.

I got some of it the fields done when trying to import, but I'm getting this error "L record AddLine() Failed. Missing or invalid header."

Thanks.

  • 0

    In either the live company or a test company manually enter an invoice type credit memo. Note the fields where you have to enter the data and the order of entering the data, both header and lines. Your source file should match the fields where you had to enter data and in that order.

    If possible post your VI job

  • 0 in reply to BigLouie

    Hi BigLouie,

    I got it to work, and have the following and it works

    ===========================

    H.InvoiceNo Type:S Oper:ASSN TEST

    H.InvoiceType Type:S Oper:ASSN IN

    H.ARDivisionNo Type:S OperASSN 00

    H.ARCustomerNo Type:S Oper:ASSN 1111111

    H.InvoiceDate Type:D Oper: CALC DTE(currentdate)

    H.Temp001 Type:S Oper:REPL 00001

    L.ItemCode Type:S Operr: REPL 0001

    L.TEmp004 Type: S Oper: File CI_Item.ProductType

    L.ItemType Type:S Oper:File CI_Item.ItemType

    L.QuantityOrdered Type:S Oper: REPL 00002

    L.QuantityShipped Type:S Oper: REPL 00002

    ========================================

    But on the job log, I get the

    ==============================

    00000001 HS Record passed - TEST

    00000002 L Record Passed - TEST

    00000003 HS Record passed - TEST

    00000004 L Record Passed - TEST

    ==============================

    How can I make it NOT show the HS Record Passed? I only want to see L Record logs

  • 0 in reply to tea

    You can't. The report is programmed and you cannot get to it.