Sage 50 UKI Ideas Portal

Match product line cost price in the product activity to the related invoice when raising a credit

Currently, the profit analysis in the invoice record is not accurate. The invoice record uses the cost price included in "Last Cost Price (Standard)" field in the product record. This means that if the product price has changed since the invoice was raised, or the goods held in stock were bought at a lower or higher value than "Last Cost Price (Standard)", the profit analysis is not accurate. Whereas, it should be using the cost price relating to the goods dispatched (FIFO). This led us to run reports out of the invoicing section and product section separately, to combine the 2 to ensure the correct cost price is used, as the activity uses FIFO. However, when a credit note is raised against an invoice, the product record updates the cost price as the "Last Cost Price (Standard)" again, instead of the cost price that was associated with the original invoice record. As again, the cost price may have changed since the invoice was raised.

  • Guest
  • Nov 4 2024