VI Import AP Credit Memos

Have the following source file (CSV)

2 questions:

1 - I want to import the Invoice No and append "-CM".  Is this possible?

2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative?

Thanks

Parents
  • 0

    AP Invoice Data Entry doesn't appear to have any fields that indicate the type of invoice, i.e. standard, credit memo, debit memo, etc.  So you are free to place what you want (up to 20 characters) in the InvoiceNo field.  In order for VI to handle multiple rows in your source file correctly, you should point a temp field using the Replace operation to your column containing the invoice number.  It should be set to assign on key assigns only and should be set to reset.  Then set your InvoiceNo field to use the Calculated operation and append "-CM" to the temp field.

    As for reversing the sign, rclowe's suggestion is what generally works.  Just make sure to set up the temp field pointing to the amount as a line level temp field that is numeric and have it reset.  Then use it in the calculation on the DistributionAmt field.

Reply
  • 0

    AP Invoice Data Entry doesn't appear to have any fields that indicate the type of invoice, i.e. standard, credit memo, debit memo, etc.  So you are free to place what you want (up to 20 characters) in the InvoiceNo field.  In order for VI to handle multiple rows in your source file correctly, you should point a temp field using the Replace operation to your column containing the invoice number.  It should be set to assign on key assigns only and should be set to reset.  Then set your InvoiceNo field to use the Calculated operation and append "-CM" to the temp field.

    As for reversing the sign, rclowe's suggestion is what generally works.  Just make sure to set up the temp field pointing to the amount as a line level temp field that is numeric and have it reset.  Then use it in the calculation on the DistributionAmt field.

Children
No Data