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
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)…
I'm not sure about appending "-CM", but I'll bet someone else here will know. From a technical standpoint I suppose you could use a Calculated field and put in +"-CM", but I am not sure if that will actually…
