Difference between revisions of "Conc Sales Vs Inventory"

From Rts
Jump to: navigation, search
(Conc Sales Vs Inventory breakdown)
 
m
Line 7: Line 7:
 
2)  Select date range applicable
 
2)  Select date range applicable
 
Note: Current day will only appear in report after a deposit close.
 
Note: Current day will only appear in report after a deposit close.
 +
----
  
 
Breaking down the report:
 
Breaking down the report:
  
'''Concession''' – Individual item, grouped by Subtotal
+
'''Concession''' – Individual item, grouped by Subtotal<br>
'''Begin''' – Count of each item at the beginning of the designated date range
+
'''Begin''' – Count of each item at the beginning of the designated date range<br>
'''Received''' – Total amount of item received or returned during the date range
+
'''Received''' – Total amount of item received or returned during the date range<br>
'''Transf''' - Amount of items Transfered
+
'''Transf''' - Amount of items Transfered<br>
'''Spoil''' – Total amount of item that went to waste during the date range
+
'''Spoil''' – Total amount of item that went to waste during the date range<br>
'''Adjust''' – Amount the count of an item was adjusted via “Correct Inventory”
+
'''Adjust''' – Amount the count of an item was adjusted via “Correct Inventory”<br>
'''Ending''' – Count of each item at the end of the desired date range.
+
'''Ending''' – Count of each item at the end of the desired date range.<br>
'''Term''' – Quantity sold at a station
+
'''Term''' – Quantity sold at a station<br>
'''Phy''' – Quantity physically removed from inventory, calculated by Term - Adjust
+
'''Phy''' – Quantity physically removed from inventory, calculated by Term - Adjust<br>
'''Term Sold''' - “Term” multiplied by the item price
+
'''Term Sold''' - “Term” multiplied by the item price<br>
'''Inv Sold''' - “Phy” multiplied by the item price
+
'''Inv Sold''' - “Phy” multiplied by the item price<br>
  
 
----
 
----
Line 26: Line 27:
 
'''Common Questions:'''
 
'''Common Questions:'''
  
''Why is my inv sold number negative?''
+
''Why is my inv sold number negative?''<br>
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.
+
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.<br><br>
  
''How do I correct my inventory count without throwing off my Inv Sold?''
+
''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 Actions → Stock / Inventory → Receive or Return.  
+
Items received or returned will not count as inventory sold.  They can be entered via Actions → Stock / Inventory → Receive or Return.<br><br>
  
''How do I hide Combo items which aren’t actually in inventory?''
+
''How do I hide Combo items which aren’t actually in inventory?''<br>
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.
+
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.<br><br>

Revision as of 16:43, 26 September 2018

Conc Sales Vs Inventory

To view Sales vs Inventory report:

1) Go to: Reports → Inventory → Conc Sales Vs. Inventory

2) Select date range applicable Note: Current day will only appear in report after a deposit close.


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
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.

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.