We have an issue where our company uses subcontractors for projects and we have an inventory item called Subcontractor. It is non-inventory type Misc Charges and the cost is not reflected properly on the invoice to the customer. This skews cost and commissions.The cost, by design, that gets pulled when receiving updates the Current Cost which fluctuates wildly with many projects going on. For example the Subcontractor cost on the PO may be $5,000 and the cost on the SO pulls $10,000 because the last receipt came in on a larger project PO with a larger cost (Current Cost).
Other than serializing the item I am looking for a solution as that is not viable since we used Subcontractor frequently over many branches.Any ideas would be appreciated.
Displays the unit cost of an item if you chose to display unit costs in the Sales Order Processing Setup window. If you haven't marked the Display Item Unit Cost option, the unit cost will be zero. If you're entering a non-inventoried item, enter the cost of the item.
If the invoice quantity is a negative, you can change the unit cost. If the invoice quantity is a negative, you can change the unit cost even if the Display Item Unit Cost option is marked.
The unit cost will be calculated according to the valuation method assigned to the selected item. The current cost will be displayed for items using FIFO, LIFO, and average perpetual valuation methods, and the standard cost will be displayed for items using FIFO periodic and LIFO periodic valuation methods.
If you're entering a return and you marked the Override Item Cost for Returns option in the Sales Return Setup window, you can change the unit cost (or current cost) of the item. This allows you to define the cost when returning the item to inventory. If the Override Item Cost for Returns option hasn't been selected, the current cost of the line item will be displayed and can't be changed.
Senior ERP Administrator
Amano McGann Inc.
2699 Patton Road
Roseville, MN 55113
Tel | 651.308.3240
If you've found this thread useful, dive deeper into User Group community content by role