How do I enter a stock take?

Summary

How to enter stock take information in Sage 50 Accounts.

Description

When you do a stock take, if the quantities you actually have in stock differ to those shown in your software, it's easy to correct this using the Stock take option.

You can either post the stock take manually, or if you prefer, you can import the stock take. Let's go through each option in turn.

Resolution

Post a stock take manually

With a manual stock take you can enter each stock level for the relevant products in just a few simple steps.

  1. Click Products and services and select the required product records then click Stock take.
  2. Complete the Stock take as follows:

    Product Code

    From the drop-down list, choose the required product code.

    Details

    Your product description appears automatically.

    Date

    Enter the date of the stock take.

    Ref

    STK TAKE automatically appears here, however you can change this if required.

    Actual

    Enter the actual number of this product that you have in stock.

     NOTE: Entering a value of zero indicates that you have nothing in stock and an adjustment is posted to adjust the stock to 0.00. Don't enter a zero value or leave this field blank unless you actually have zero in stock.

    Cost Price

    The cost price appears automatically.

    In Stock

    The current quantity in stock in the software.

    Adjustment

    The adjustment value. This is the difference between the In stock and Actual figures.

     

    If you currently have more items in stock than was previously recorded, this appears as a positive value. If you have fewer items, the adjustment figure appears as a negative value.

     TIP: If you often use the Stock take option and you want to memorise the information in this window to use at any time, you can use the memorise and recall options.  

  3. Click Post Stock take then click Close.

That's it, adjustments in or out are posted in your stock activity to correct the stock levels.

Import the stock take

To import a stock take, you need to first create a file to hold the stock take values in the correct format, then import this into your software. 

Create the import file

  1. In Sage 50 Accounts click Help, then click About.
  2. In the Program Details section, click the path to the right of Program Directory.
  3. Double-click the Import Templates folder.
  4. Open the file Stock Take FULL template.xls in Microsoft Excel or equivalent software.
  5. Enter the Stock Code, Date, Reference (optional) and Actual quantity for the products you want to count.
  6. Save the file in a new location, for example, your Windows desktop.

Import the stock take file

  1. Click Products and services and select the required product records then click Stock take.
  2. Click Import and select the file type you want to import.
  3. Click Browse and select the file you saved when you created the import file, then click Open.
  4. If your data does not have a row of headings, clear the First row contains headings check box then click Next.
  5. Use the Field Mappings window to link the imported data to the correct fields in Sage 50 Accounts.
  6. Complete the Imported Field column as required, choosing the relevant field from the drop-down lists.

    If you need to remove your selections and start again, click Clear Map.
    Use Save Map to record a map so you can use it again.
    Use Load map to load a map you have already saved.

  7. Once all of the required fields have been mapped, click Next then click Import and click Close.
  8. Click Post Stock take and click Close.

That's it, adjustments in or out are posted in your stock activity to correct the stock levels.

 

  More support and information is available 

Get the most out of your software, stay ahead with trending topics and get answers from thousands of articles using the Sage Knowledgebase. Visit the Help Centre >

 

Solution Properties

Solution ID
201105123005440
Last Modified Date
Wed Dec 27 10:00:47 UTC 2023
Views
0