TASBooks - Stock adjustments

To help you increase or decrease the goods you hold in stock, you use the Stock Adjustments window. It's generally used to write-off damaged stock, or to adjust quantities after a stock take. You can also use the Stock Adjustment window to enter opening balances.

When you produce a credit note, this can put goods back into stock. This also applies to assembly-type products. However, in many cases you may not want to put all or some of the goods back into stock.

Note: This option is only available if your TASBooks licence includes the Stock Control module.

The following steps contain everything you need to help you record stock adjustments in TASBooks.

To enter stock opening balances

  1. Stock > Stock Movement > Stock Adjustments (option 521)
  2. Select the Opening Balance check box.
  3. Date > enter the date of the opening balance.
  4. GMV > enter a GMV number or reference number > press the Tab button on your keyboard.
  5. Stock Details > for each product you want to enter an opening balance for, complete the following information:
    6. Product Code Enter the product's code. Alternatively, press F2 > select the relevant product.
    Description Enter a description for the adjustment. For example, opening balance.
    Date Enter the date for this opening balance, for example, the date of the last stock take.
    Qty Enter the current quantity in stock.
    Cost Price Enter the cost price of the product.
    NL Acct Enter the nominal code for your stock account.

    Tip: This will default to the nominal code you entered for stock adjustments in Central > General Company information > TASBooks Configuration (option 012)
  6. Press the Tab button on your keyboard.
  7. Repeat steps 5 and 6 for each product you want to enter opening balances for > Save > Yes.
  8. To close the Stock Adjustments window > Cancel.

To enter stock adjustments

  1. Stock > Stock Movement > Stock Adjustments (option 521)
  2. If you want this entry to be counted during a stock take > select the Stock Taken check box.
  3. GMV > enter a GMV number or reference number > press the Tab button on your keyboard.
  4. Stock Details > for each product you want to enter an adjustment for, complete the following information:
    5. Product Code Enter the product's code, or press F2 > select the relevant product.
    Description Enter a description for the adjustment.
    Date Enter the date for the adjustment.
    Qty Enter the quantity you want to adjust the stock by.

    Tip: This can be a positive or negative value.
    Cost Price Enter the cost price of the product.

    Tip: This will default to the standard cost price of the product you entered in Stock > Products and Services > Maintain Products / Services (option 511), but you can overwrite it here.
    NL Acct Enter the nominal code for your stock account.

    Tip: This will default to the nominal code you entered for stock adjustments in Central > General Company information > TASBooks Configuration (option 012)
  5. Press the Tab button on your keyboard.
  6. Repeat step 4 and 5 for each product you want to enter an adjustment for > Save > Yes.

    7. Tip: You can cancel a stock adjustment by simply entering an opposite entry. So if you just increased stock and you made a mistake, you simply repeat the adjustment but this time you decrease stock.

  7. To close the Stock Adjustments window > Cancel.

Note: If you make stock adjustments that include movements of goods to and from the EC, you must also manually update the Intrastat SD file from either Sales Orders > Intrastat > Enter / Change Intrastat Dispatches (option 671) or Purchase Orders > Intrastat > Enter / Change Intrastat Arrivals (option 771).

The following steps contain everything you need to help you record stock adjustments in TASBooks.

To enter stock opening balances

  1. Stock > Stock Movement > Stock Adjustments (option 521)
  2. Select the Opening Balance check box.
  3. Date > enter the date of the opening balance.
  4. GMV > enter a GMV number or reference number > press the Tab button on your keyboard.
  5. Stock Details > for each product you want to enter an opening balance for, complete the following information:
    6. Product Code Enter the product's code. Alternatively, press F2 > select the relevant product.
    Description Enter a description for the adjustment. For example, opening balance.
    Date Enter the date for this opening balance, for example, the date of the last stock take.
    Qty Enter the current quantity in stock.
    Cost Price Enter the cost price of the product.
    NL Acct Enter the nominal code for your stock account.

    Tip: This will default to the nominal code you entered for stock adjustments in Central > General Company information > TASBooks Configuration (option 012)
  6. Press the Tab button on your keyboard.
  7. Repeat steps 5 and 6 for each product you want to enter opening balances for > Save > Yes.
  8. To close the Stock Adjustments window > Cancel.

To enter stock adjustments

  1. Stock > Stock Movement > Stock Adjustments (option 521)
  2. If you want this entry to be counted during a stock take > select the Stock Taken check box.
  3. GMV > enter a GMV number or reference number > press the Tab button on your keyboard.
  4. Stock Details > for each product you want to enter an adjustment for, complete the following information:
    5. Product Code Enter the product's code, or press F2 > select the relevant product.
    Description Enter a description for the adjustment.
    Date Enter the date for the adjustment.
    Qty Enter the quantity you want to adjust the stock by.

    Tip: This can be a positive or negative value.
    Cost Price Enter the cost price of the product.

    Tip: This will default to the standard cost price of the product you entered in Stock > Products and Services > Maintain Products / Services (option 511), but you can overwrite it here.
    NL Acct Enter the nominal code for your stock account.

    Tip: This will default to the nominal code you entered for stock adjustments in Central > General Company information > TASBooks Configuration (option 012)
  5. Press the Tab button on your keyboard.
  6. Repeat step 4 and 5 for each product you want to enter an adjustment for > Save > Yes.

    7. Tip: You can cancel a stock adjustment by simply entering an opposite entry. So if you just increased stock and you made a mistake, you simply repeat the adjustment but this time you decrease stock.

  7. To close the Stock Adjustments window > Cancel.

Note: If you make stock adjustments that include movements of goods to and from the EC, you must also manually update the Intrastat SD file from either Sales Orders > Intrastat > Enter / Change Intrastat Dispatches (option 671) or Purchase Orders > Intrastat > Enter / Change Intrastat Arrivals (option 771).

© Sage (UK) Ltd 2016. All rights reserved

Sage