I have observed that when creating a new standard Inventory Adjustment that the system does not allow you to specify the unit cost when performing a negative quantity adjustment. In addition to this, the system rounds the unit cost to the nearest hundredth of the location's average cost rather than using the cost with 4 or 5 decimal places as it is shown on the item record. (We are using average costing method).
This in itself is not a huge deal, but it is feasible that if I were to adjust out all remaining quantity in a location to 0 then the total value of the item would not equal $0.00
For example:
1) The system shows 10pcs of Widget A on hand @ $1.5323 avg cost for a total value of $15.32
2) I create and save an inventory adjustment for -10 pieces of this item, and the system pulls in the unit cost as $1.53. This sets the total adjustment amount at $15.30 (which is a $0.02 discrepancy)
3) The inventory location now has 0 pieces on hand, but shows an inventory value of $0.02.
I'm not very concerned about 2 cents as in this example, BUT this is just a simple example and these numbers could be greatly skewed as time goes on and more or larger adjustments are made.
When performing a positive adjustment the system will let you manually override the unit cost as desired, but defaults to rounding the unit cost again when sourcing the item.
I noticed this behavior while scripting some Inventory Adjustments for the purpose of transferring inventory between locations (1 adjustment out of source location, and 1 adjustment into destination location). The totals on the 2 adjustments did not balance because the 'out' adjustment unit costs were rounded, and the 'in' adjustment unit cost was not rounded. Basic Inventory Transfers are not currently supported via scripting.
My concerns are:
1) Was it intended that the system only allow unit cost manual override on positive adjustments or a bug?
2) Why does the system round the unit cost on inventory adjustments? Can this be changed to use precise decimals?
3) Is there a way to override the unit cost that I am not aware of? (via UI, settings, or scripting)
4) Does anyone have another recommendation on how 'transfer' inventory via scripting? (transfer orders and not feasible for our model)
Thanks in advance for any insight you can provide!