Hi Andre,
Sorry for my bad English. I will clarify my problem again.
I mean, instead of allocating the percentage among vendor account, I want to allocate it to vendor groups, which includes multiple vendor accounts.
For example, I devide the vendor for my raw materials into 2 groups: foreign vendors and local vendors. My company has a policy to buy 70% of RM from foreign vendors, and 30% from local vendors.
Currently:
- Foreign vendors: vendor 1, vendor 2, vendor 3
- Local vendors: vendor 4, vendor 5
I want to track the current allocation at the level "Group", not "Account". Therefore, when there is a new foreign vendor, the idea allocation doesn't change, I can place PO from vendor 1, 2, 3 or the new vendor as long as it make the deviation the least.
