Solved

Sales order Import scenario Update Existing data

pandachan48
Rank
Userlevel 2
Badge

Hello,
Not sure if there is any suggestions on the case below? 
I would like to update the sub account code in those open SO in system.
 
I tried to create a new data provider & import scenario, I noticed that the information update is weird, some order with one line can be updated, some cannot, some order with multiple lines, then maybe one of them will be update or totally no update. 

 

This is the import scenario mapping that I created.

 

This is the import scenario mapping that I created.

 

When I did the import scenario data update, it processed successfully.

 

However, in the SO, it does not reflect.

 

icon

Best answer by manikantad18 31 March 2023, 10:05

View original

13 replies

manikantad18
Rank
Userlevel 7
Badge +12

Hi @pandachan48 

Please find the import scenario to update the subaccount.

Please verify for one order with Multiple lines and executed for all. ( Run in the sandbox instance ).

1 Attachment
Acumatica Functional Consultant
pandachan48
Rank
Userlevel 2
Badge

Hi @manikantad18, 

 

Sorry that, i am not familiar in this. 

May i know where should I execute this, and how to do it?

Any step or flow to guide?

manikantad18
Rank
Userlevel 7
Badge +12

Hi @pandachan48 

Could you please check this if you have test environment, if there is no test environment then please check one record and executed for all other records

Acumatica Functional Consultant
V
Rank
Userlevel 7
Badge +11

Hi @pandachan48 

On your import source data, please use the LineOrder column to identify the detail line on SO instead of the LineNbr. 

 

Make changes on your scenario, and let us know if it works.

Regards,

VijayKumarU
pandachan48
Rank
Userlevel 2
Badge

Hi @manikantad18,

 

Yes, i am in the test environment, so i need go to the import scenario and upload it?

 

 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @manikantad18,

 

Yes, i am in the test environment, so i need go to the import scenario and upload it?

 

 

Hi @pandachan48 

Please import the file shared by me and mapped the data provider.

check with one record 

Acumatica Functional Consultant
pandachan48
Rank
Userlevel 2
Badge

Hi @pandachan48 

On your import source data, please use the LineOrder column to identify the detail line on SO instead of the LineNbr. 

 

Make changes on your scenario, and let us know if it works.

Regards,

Hi, 

I tried to use the line order, but the results still same, where if there is multiple line in the same sales order, it will not happen. this is the import scenario mapping. 

 

This is after import, no changes on it. 

 

pandachan48
Rank
Userlevel 2
Badge

Hi @manikantad18,

 

Yes, i am in the test environment, so i need go to the import scenario and upload it?

 

 

Hi @pandachan48 

Please import the file shared by me and mapped the data provider.

check with one record 

Hi,

 

I tried to import your XML file in the data provider.

This is the one i import...

 

After imported, i cant fill the schema field.
in the import scenario, i choose the provider with your xml file, then cant bring the field info. 

 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @pandachan48 

Can you map the Import scenario to your existing import scenario and make the necessary changes.

Thanks

Acumatica Functional Consultant
pandachan48
Rank
Userlevel 2
Badge

Hi @pandachan48 

Can you map the Import scenario to your existing import scenario and make the necessary changes.

Thanks

Hi @manikantad18,

 

I map your mapping with mine existing.

 

this is after changed.

 

this is yours map.
this is the error.

 

I even tried and change to Line order (sort order) also can’t…

 

no change….

 

manikantad18
Rank
Userlevel 7
Badge +12

hI @pandachan48 

Please find the Import scenario mapping once again

 

IN YOUR Screenshot I see customer ID which is not required to update the existing sales order lines

 

Acumatica Functional Consultant
pandachan48
Rank
Userlevel 2
Badge

hI @pandachan48 

Please find the Import scenario mapping once again

 

IN YOUR Screenshot I see customer ID which is not required to update the existing sales order lines

 

Hi @manikantad18, 

After changed, it successfully import some lines, but not all the lines…

 

this is the mapping...

 

 

 

manikantad18
Rank
Userlevel 7
Badge +12

Hi @pandachan48 

Please try to debug the difference, import scenario worked for me, May be any data issues.

Thanks

Acumatica Functional Consultant

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved