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

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

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 can rename this as "Net Sales Retail Cost":
   
   
4. *Formula Type is Multiply x*y
   *x = Sales
   *y = Ending Average Cost
   
   
5. User has option to tick Apply Formula to Grand Total checkbox.
   
   
6. Hit Preview or Save.