So our parent company wants us to start sending automated data flows to them. Previously they've been doing the mapping between our accounts, but now they want to push that down to us. Trouble is, they have a unique account string for each (or at least some) account and location combinations (e.g. our account 11101 + location 1 = their account 989999, our account 11101 + location 2 = their account 990000, our account 11102 + location1 = their account 990001). Wondering if anyone has had to build this kind of a mapping and/or has some tips on the best way to go about it?

look into Accounting Context

doesn't that just do a 1:1 mapping with the account though? not a mapping of account + classifications?

yes, you are right, I misunderstood 😞

No worries. I initially got this problem, and was like "oh that shouldn't be hard", but digging into it I'm really struggling for a good solution. Especially because you also can't link custom records to account or classifications as parent records, apparently. Good times! netsuite

yes, you have to modify whatever comes from the non-NS side into NS format, that means combining three accounts into one 😞