Does anybody know why when I map the Branch field in the order level the value doesnt change but in the detail level, it does?

@rodrigocid34 it makes sense. The order is not associated with a location directly. Instead, Shopify groups items into batches and assigns them to locations. Therefore, when you’re referencing Sales Order → Details, you have access to LocationID. But when you use Sales Order object, LocationID is not there, therefore your mapping doesn’t do what you need it to do.

Thank you Yuri, I understand. I tried using Shopify tags but it didn’t work neither. the problem could be  the object in Acumatica (Sales Order, Branch)?

@rodrigocid34 , did you try Sales Order → Financial Settings:

instead of Sales Order object? With tags, for example.

Now appears a new error( an odd one):

Cannot generate the next number for the SPORDER sequence.()1

but it doesn’t appear when I use the same formula mapping sales order → details. 

That’s because when you use details, you don’t change the branch of the order - you simply change the branch on each line.

But when it works (which it appears, now it does :)), this error is thrown. This error simply means that in your other branch, you don’t have auto numbering set for SPORDER numbering sequence. Go to Numbering Sequences screen, and add a line for your other branch for SPORDER sequence.

Hope this helps.