Hi! For items with fifo costing, is there a way to see what the actual margin would be on a sales order? The margins on sales orders screen use average costing so it's not helpful for my client. Also, I'm looking at Inventory Summary report and same thing it provides the average. Does anyone know where to find the current fifo cost before the items have been issued/shipped?
Answer
How to determine the fifo cost of an item before it has been issued?
+4Best answer by vshashkova
Hi @estebanperalta54, by default, the system uses average cost in standard reports and sales order margin calculations, as you’ve noted. If you need to estimate margin based on the FIFO cost layers prior to shipment, you may consider building a custom GI or report that looks into the current cost layers available in the system.
+1Hi @estebanperalta54, by default, the system uses average cost in standard reports and sales order margin calculations, as you’ve noted. If you need to estimate margin based on the FIFO cost layers prior to shipment, you may consider building a custom GI or report that looks into the current cost layers available in the system.
Valentina, Technical Product Manager - Distribution
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.