Stock Ledger Report > On-Hand Retail Price and Net Sales Retail Cost

When customizing Stock Ledger Report to show the Ending Inventory Retail Price and Net Sales Retail Cost,

1. Navigate to Reports>  Inventory/Item > Stock Ledger Report > Customize.
   
2. Add a Formula field and rename this as “On Hand Retail Price”:
   *Formula Type is Multiply x*y
   *x = Ending Inventory On Hand Qty
   *y = Sales
   
3. Add a Formula field and rename this as “Net Sales Retail Cost”:
   
4. *Formula Type is Multiply x*y
   *x = Sales
   *y = Ending Average Cost
   
5. The user has the option to tick the Apply Formula to Grand Total checkbox.
   
6. Hit Preview or Save.