After recently finding out that the Shipping Field does absolutely nothing in a purchase order reguarding Costs of Goods, or anything for that matter, I decided that "oh, I can just use a Formula to change the costs in my purchase order to reflect my shipping costs!" So, after going through and adding up all the quantities of items recieved, and dividing it by my shipping cost, I got a cost of $1.40/item. No problem right? Wrong. The Formula will in no way reflect a NEWLY updated cost. And I cannot use Formulas after the purchase order is committed!!!!! >:O
FOR EXAMPLE: I have item 123. Item 123 used to cost me $3, it now costs me $5. So, in a purchase order, I enter item 123, and put in a new cost of $5. NOW, when I go to use the FORMULA to add in shipping, it only has options that reguard to the OLD costs and other things that dont do crap for me. So if I say, "Add 1$ for each item cost, my ending cost becomes $4 because the purchase order Formula does not take the NEW cost of $5. The only way the Formula will use the UPDATED $5 cost is to COMMIT the purchase order which then renders the Formula field useless because you then cannot click on it to edit the costs.
I must say, shipping is a huge part of our end-of-the-day cost, and there is absolutely no way to make this work easily for us. Problems like this keep popping up in RMS and my Boss' are getting very frustrated with this system.