I don't understand why the freight that is entered onto a PO is not added to the item costs upon receiving inventory. This is part of my inventory value, so it hould be reflected in the cost of each item.
As a result, have a painful two step process because I must send the PO to the supplier using thier cost, but before I do my receiving, I have to manually apportion the freight to each item.
The whole story: Actually, my situation is more complicated because my suppliers are in a different country. Not only do I need to add freight, but duties, handling costs, ocean freight, etc. These all form part of my inventory value. Since I do not need to track these costs seperately (only need an accurate total landed item cost in the database) I could use the freight field if the software would apportion the freight among the PO items. The same thing applies to the Sales Tax % column. Sales Tax I pay to a supplier should be part of my inventory value, but the item cost uponreceiving does not take it into account. I could similarly use this field by establishing a factor that incorporates all costs, however, RMS does not apportion this cost to the items either.
This must be bothering the accountants out there. I just don't understand how the RMS inventory value is supposed to be correct when RMS does not take into account these costs. Am I missing something?
Thanks,
Jason
P.S. I do not want a Landed Cost add-on module. Again - I do not care about the individual components. I just want an accurate inventory costs without monkeying with the PO or manually updating costs.
P.S.S. Forget about the Formula button. This only works if you update your supplier costs religiously when there are changes. Often we just update the cost on the PO if there is a change, and forget or don't bother to updat the supplier cost. For some inexplicable reason, the Formula does not allow you to simply multiply the PO costs by a factor.