A) Is there an easier way to do import costing and receive POs?
My current process is : Create purchase order for overseas supplier in HQ with (free on board) purchase price . Do not approve the Po to the store/warehouse. When shipment arrives use an excel spreadsheet to manually work out the actual cost price. (Unit Cost price =Number of Units * Purchase price + import duty+ Sea Freight + Local Handling charges+ Cartage/ Number of Units) Go back to PO key in correct actual prices. Approve PO for store/warehouse to receive.
It get harder when POs have many lines.
B)I also want to run a shipment cost report showing the breakdown of each cost variable also included on the report should be the current cost price and cost price to be if the PO is received at the warehouse.
Thanks