Mass External Transfers based on one distribution..
I am working on a a project to reconcile two systems and part of this entails creating transfer transactions in the fa_mass_external_transfers table. While I have most of what I need, I have come accross a scenario that I didn't anticipate initially but I will ultimatly have to deal with it.
Okay, let's say I have an asset at location 'A' with 10 units. I have to move 5 of these units to location 'B' and the other 5 to location 'C'. Since both of these transactions are made up of the same distribution, the first one will post but the second one will error stating the from distribution_id is invalid (as a result of the first transfer).