Skip to main content
Solved

Import Scenario that null a comma

  • Jan 13, 2025 4:49 PM UTC
  • 2 replies
  • 77 views
  • Translate All

Forum|alt.badge.img

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.
 

View original

2 replies

riglesias
Acumatica Employee
Forum|alt.badge.img+2
  • Acumatica Employee
  • Answer
  • Jan 13, 2025 5:21 PM UTC

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.
 

Translate

Forum|alt.badge.img+8
  • Captain II
  • Jan 13, 2025 6:43 PM UTC

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.

 

Translate