AR Invoice Import

SOLVED

I feel like I should know this, but for some reason I'm struggling with this VI job.  I am importing into AR Invoice Data Entry.  My file has over 400 lines in it.  What I want to happen is have the import assign the Next new invoice number, once.  However, what it does is assign an new invoice number EVERY time the dollar amount changes in the file.  The only way around it that I could find was to do a Runtime Assign.  I could do this but would prefer not to if at all possible. 

Am I missing something or is this just the way it works???

Thanks

Sue 

Parents
  • 0
    SUGGESTED

    Next triggers for a change in any header field value.  (Any field prefixed with an "H." in the field listing).  Make sure none of the header field values are changing in your source data and it should work.

  • 0 in reply to Kevin M

    Only fields prefixed with "H." using the "Replace" operation will trigger the Next number so if you use Calculated and reference the source column using IMP$[x] where x is the column number, it will not trigger the Next number if it varies from one record to the next.  It sounds like you are referencing the dollar amount in a header (table or temp) field with the Replace operation.  If you are trying to calculate a running total for the header, try instead using either a temp field or the table field with the Calculated operation and add it to the value being read, you could use something like the following if the header or temp field is numeric.

    Temp001=Temp001+NUM(IMP$[x])

Reply
  • 0 in reply to Kevin M

    Only fields prefixed with "H." using the "Replace" operation will trigger the Next number so if you use Calculated and reference the source column using IMP$[x] where x is the column number, it will not trigger the Next number if it varies from one record to the next.  It sounds like you are referencing the dollar amount in a header (table or temp) field with the Replace operation.  If you are trying to calculate a running total for the header, try instead using either a temp field or the table field with the Calculated operation and add it to the value being read, you could use something like the following if the header or temp field is numeric.

    Temp001=Temp001+NUM(IMP$[x])

Children
No Data