Import Scenario - Delete Multiple Transaction by excel

Hello,

Is it possible to import excel file (Sales orders/ Shipment/ AR Invoice) by the Import Scenario function?

Yes, it is possible to import directly from Excel files to Acumatica. We can also import directly from a wide variety of sources:

Or there are any way to delete multiple?

Yes, we can import deletion of records.  The way we delete records is by replacing <SAVE> at the end of the import scenario with <DELETE> action.

Thanks @Naveen Boga and @laura01 for your kind reply!

I create a Delete AR Invoice Template as the attached image and got the error: “customer id can not be empty” though I understand that we don't need a customer field when we delete?

Another question, On the import by screen, there is another mapping screen, so which mapping screen that this system is using when I import? 

Thank you,

Yên Chi

Thanks @Naveen Boga and @laura01 for your kind reply!

I create a Delete AR Invoice Template as the attached image and got the error: “customer id can not be empty” though I understand that we don't need a customer field when we delete?

 

Another question, On the import by screen, there is another mapping screen, so which mapping screen that this system is using when I import? 

 

Thank you,

Yên Chi

I have fixed this one. Thanks all!