Skip to main content
Answer

Import Scenario that null a comma

  • January 13, 2025
  • 2 replies
  • 33 views

Greetings, by any chance is there a formula that allows me to import invoices separated by a comma??

from here: Invoice Number

to import like:

 

Best answer by riglesias

Hello ​@alejandradiaz68 ,

 

In this case I would recommend you enter the invoice numbers in separate lines, the system process one line at a time and I don’t think there is a formula for this.
 

2 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • Answer
  • January 13, 2025

Hello ​@alejandradiaz68 ,

 

In this case I would recommend you enter the invoice numbers in separate lines, the system process one line at a time and I don’t think there is a formula for this.
 


Forum|alt.badge.img+7
  • Captain II
  • January 13, 2025

The only way I can think of making this work without changing the data would be to have two import scenarios. One would pull the invoice number from the string before the comma and the second would pull the invoice from after that comma.