We are having a problem on purchase orders in Quickbooks 2004. At the time we place an order we do not know the shipping cost. This gets entered on the PO with $0 cost.
Our inventory manager receives against the PO at the time we receive the items, but again she has no invoice and she cannot record shipping costs.
Now later we receive an invoice from the vendor, and it has the shipping cost. My accounts payable person has been coming to me and asking me to make these corrections, and from what I have seen so far I am pretty horrified at how difficult it is to rectify the situation. The steps I have been doing to work around this situation:
1) I modify the purchase order that is already received in full, by entering in the shipping costs, and changing the quantity field of the shipping line item from 0 to 1. If the quantity remains unchanged, the PO will fail to appear in the next step!2) I modify the Item Receipt by doing a "Select PO" and reselecting the already received PO. Now the shipping costs appear. I have to manually retotal the items in the Item Receipt, because the total of the Item Receipt form does NOT adjust to the newly selected PO.
3) I save all this, and only now can the purchase order be paid.Is there a better way to do this? The above procedure requires too much attention to detail, and would in general be difficult for someone who was not extremely computer literate to deal with.
I count the following behaviors in the above sequence as bugs in Quickbooks:
1) From inside the Item Receipt, the "Select PO" feature fails to find any open PO if the dollar amount of the PO has changed. Only changing a quantity will allow the PO to show again. The PO should not be showing as received if any material detail of that PO has been modified, if for no other reason than good financial controls.2) From inside the Item Receipt, selecting a PO a second time fails to modify the total amount for the PO in the total line at the top of the Item Receipt.