Performing Stock Take

The Stock Take function in MYOB EXO Business uses a comparative stock take method and reports discrepancies between counted and computer stock levels. Adjustment transactions are applied via a stock take upload sub-function giving the user complete control over the timing.

Stock takes are separated by stock location. Multiple locations may have stock takes concurrently active. Within a location, partial or rolling stock takes are also accommodated using selection criteria applied to the stock take initialisation process (e.g. supplier, stock group, bin number range etc). Additional filters may be specified by custom SQL if required and these may be set differently for each location Full stock take is also supported.

Stock take data may be imported from CSV file (Comma Separated Value) rather than keyed. This provides for use of hand held scanning devices or for importing data during implementation of a new database (or new location for existing database). The CSV import file may optionally also specify the average cost of the stock being imported.

Full support for stock batch codes and limited support for serial numbers is also available.

The stock take window allows you to stock take all or individual locations. MYOB EXO Business uses an adjustment method rather than an overwrite method. Thus the result of a stock take is a positive or negative adjustment transaction to bring the levels back into line with a physical count.

Workflow Summary

Performing a stock take involves the following steps:

1. Select a location in the locations grid.

2. Click the Initialise button and set selection criteria if required. This initialises the stock location, creating a snapshot of the present stock levels and sets the corresponding counted quantities to zero ready for keying. See

3. Print count sheets for each location and perform physical count.

4. Key in the counted quantities or import a CSV format file containing the count.

5. Print variance reports. Check any “suspicious” count figures and amend keyed quantities if required. If amending counted figures be sure to reprint the variance report.

6. When happy with the counted figures, run the stock take upload function. This creates stock transactions for any items that have a variance. This is the first point in the workflow that any amendment to the “true” stock ledger occurs. Up to this point the stock take may be discarded and recounted by rerunning the initialisation at step 2.