Difference between revisions of "Conc Sales Vs Inventory"

From Rts
Jump to: navigation, search
Line 49: Line 49:
 
Adjustments are created via '''<code>Actions → Stock / Inventory → Correct Inventory</code>'''.<br><br>
 
Adjustments are created via '''<code>Actions → Stock / Inventory → Correct Inventory</code>'''.<br><br>
 
'''''How do I correct my inventory count without throwing off my Inv Sold?'''''<br>
 
'''''How do I correct my inventory count without throwing off my Inv Sold?'''''<br>
Items received or returned will not count as inventory sold.  They can be entered via '''<code>Actions → Stock / Inventory → Receive or Return</code>'''.<br><br>  
+
Items received or returned will not count as inventory sold.  They can be entered via '''<code>Actions → Stock / Inventory → Receive or Return</code>'''.
 +
 
 +
[[File:Actions_StockInv_RecRet.PNG|300px]]<br/><br/>  
 
'''''How do I hide Combo items which aren’t actually in inventory?'''''<br>
 
'''''How do I hide Combo items which aren’t actually in inventory?'''''<br>
 
Under '''<code>Setup → Concessions → Station items</code>''', verify that the item that should not show up on an inventory count is set up to “Stock From: Create” on the bottom.  This will prevent a negative count of an item that shouldn’t appear in inventory.<br><br>
 
Under '''<code>Setup → Concessions → Station items</code>''', verify that the item that should not show up on an inventory count is set up to “Stock From: Create” on the bottom.  This will prevent a negative count of an item that shouldn’t appear in inventory.<br><br>

Revision as of 13:46, 9 April 2019

To view Sales vs Inventory report:

  1. Navigate to: Reports → Inventory → Conc Sales Vs. Inventory.
  2. Select date range applicable
Note: Current day will only appear in report after a deposit close.

Reports Inventory ConcSalesVsInventory.PNG



Breaking down the report:

Concession Individual item, grouped by Subtotal

Begin Count of each item at the beginning of the designated date range

Received Total amount of item received or returned during the date range

Transf Amount of items transfered out of the building during Receive or Return

Spoil Total amount of item that went to waste during the date range

Adjust Amount the count of an item was adjusted via “Correct Inventory”

Ending Count of each item at the end of the desired date range.

Term Quantity sold at a station

Phy Quantity physically removed from inventory, calculated by Term - Adjust

Term Sold “Term” multiplied by the item price

Inv Sold “Phy” multiplied by the item price


Common Questions:

Why is my inv sold number negative?
Check if that item was adjusted. Positive adjustments assume the item was not sold and will reduce the inventory sold by it’s full retail price. Adjustments are created via Actions → Stock / Inventory → Correct Inventory.

How do I correct my inventory count without throwing off my Inv Sold?
Items received or returned will not count as inventory sold. They can be entered via Actions → Stock / Inventory → Receive or Return.

Actions StockInv RecRet.PNG

How do I hide Combo items which aren’t actually in inventory?
Under Setup → Concessions → Station items, verify that the item that should not show up on an inventory count is set up to “Stock From: Create” on the bottom. This will prevent a negative count of an item that shouldn’t appear in inventory.


Sample Report

Sample Conc Sales Vs Inventory Report

RD Crocker (talk) 18:07, 26 September 2018 (UTC)