Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Regular stock takes ensure the inventory levels in your account are accurate.

You canOptions:

  1. require that all items get counted - so the only items in a location after the stocktake will be the ones counted
  2. enable updates only on items you do count

...

A Stocktake will be compared to current stock levels when completed and will write appropriate journals to write off or create stock

You will need the Secure Features ''Is Stock Manager''

Set stock locations that store stock to "Lot"

Note

When setting up a new company that has existing stock - you can count the stock and not write journals - instead using a single journal line for the stock value.

This feature can also be used to count stock that you do not need to do journals for adjustments - for example stock held on consignment

...

Note

Until you get experienced - count a single warehouse bay at a time.

  • Have the Secure Features ''Is Stock Manager''
  • Set stock locations that store stock to "Lot"

Select the area that will be counted in one count

...

Second Counters find stocktake that needs a second count

Note

If the stocktake does not need a second count - copy the first count to a second count

Image Added

 

Count the stock in the same way as the first count.

Comparing 1st and 2nd Counts

T

 

  1. To update counts
    1. Double click on the location to populate it into the form
    2. Search, use Barcode or Enter the Article that was found
    3. Enter the Quantity and the Use By for the item
    4. '''Save''' each combination of item count and expiry for the location
    5. Once location has all counted items added - select '''Counted''' (may say Finalised) next to the Save button and save the location update
    6. ''Note can hide Counted (Finalised) locations so you can see only the ones that remain to be counted in the list''
    7. ''Note that multiple persons can be entering counts at the same time for Count 1''
  2. At any time can run a report showing counts vs original stock level differences using the Action Button
  3. When finished use Action Button to''' Complete first count'''
  4. Stock Take Status will move to '''Second Count'''
    1. Enter counts as for first count - multiple persons can be entering counts at a time.
  5. Once completed use Action Button to '''Close Second Count and Report Differences''' and a list of discrepancies will popup.
  6. Stock Take Status will move to '''Finalising''' Action Button has options:
    1. Report Differences between Counts
      1. Can update 2nd count if differences found - second count will be used for new stock levels
    2. Report Differences between This stocktake and system stock levels
      1. Can update Count 2 until ready to journal changes as completed
      2. You must run this on your machine for the next steps to be made available
  7. Can update any of the values in the finalising stage to the final values wanted
    1. Journal stock differences (as reported) and close will create journals and write off stock to the account nominated in Symbols Config "Stock TakeAdjustmentGLCode"
    2. '''Use this data as initial stock ''' will not create any journals - all stock will be reset to the values counted and will also delete all history for the stock
  8. Stock Take Status will move to closed and you have completed the stocktake.

General Tab

Locations

  • '''Date''' is the date that the journals will take effect
  • '''Root Location''' is the highest level of the Stock Location that is to be counted. All lower levels in the hierarchy will be included
  • '''Action button''' has next available Stock Take Status and ability to print reports
  • '''Status''' for the stock take shows adjacent to the action button
  • '''Notes''' allows free form descriptive notes to be held against the stocktake
  • '''Mode''' has two options
    • Full - all items in locations chosen must be counted
    • Counted Items Only - only items that you count will be updated - all others will be assumed to be correct - note that this is not the case if you chose
  • Once a stocktake has been saved (and hence created) the list of locations will be shown
    • Doubleclick or right click to select a location from the list will populate the location to the line in the bottom of the section.
  • '''Hide Counted Locations''' will ensure the list shows only those still to be finalised

Items in a Location.

  • Can enter a barcode to enter your item if you have a tablet and a barcode scanner attached.
  • Item if no barcode can Search for an Article. Note once this field has been populated can navigate to the properties of the Article
  • Counted is counted quantity
  • Use by is use by date for counted quantity
  • Comments can be added
  • Save to add the count to the list of items counted in this location

Summary by Item Tab

Shows a list of the items affected by the stocktake, the bay affected the quantity, the useby, the average buy price and the stock cost total. A total valuation impact is also calculated across the stock take.

Master List Tab (Locator Tab)

A list of all the stock takes that have been done and their status. Doubleclick or rightclick Select to populate the stock take record into the rest of the form.

Setup

  Note: ''To use stocktake you must

...

  • Create a new config key called StockTakeAdjustmentGLCode (The Value must be the GL account code).

...

Close Second Count and Report Differences

Image Added

Any differences will show in a report - allowing a recount of any discrepancies

Image Added

Simply update the counts until you are convinced the second count is correct.

Report differences again

Note

After any changes to counts you will need to report differences again to proceed

Comparing Second Count to System Stock Levels

Image Added

Again a list will show - recheck and update any counts you want

Journal Stock Differences

Will create the required journals

Note

Stock take adjustment GL account is configured in Symbols Config as "Stock TakeAdjustmentGLCode"

Status will become closed.