Hello,
The allocation schedules I have set up in NetSuite are not calculating as expected. I am allocating expense entries to various departments using the period balance in a statistical account. The allocation entries that are generated do not sum to the total of the source/original expense entries. NetSuite does not offer any guidance that I can find that would explain how it calculates dynamic allocations. The only piece of information that I can find relating to allocation weight is on page 33 of the Statistical Account Guide - https://docs.oracle.com/cloud/latest/netsuitecs_gs/NSSAC/NSSAC.pdf where it says: "To calculate statistical weight, NetSuite uses the flat amount for each destination line in the allocation schedule, rather than dividing by the total amount entered in all of the destination lines."
What does NetSuite mean by "flat amount?" I do not understand how NetSuite is producing the weighting for each destination line. The statistical account total for the period is not being used in the calculation as one would expect. If the statistical account units in the journal entry are ignored, how does NetSuite calculate the weight? For example, if I allocated 100 total units to 50 different departments, and Department A received 10 of the total units, I expect the allocation weight to equal 0.10 (10/100). However, this is not the case in NetSuite, so I just need to know if there is a resource that explains how the weight is calculated.
Thank you!
Mikail