SLS - Stock Adjustments
School Shop Stock Adjustments Overview
This is a multi-purpose program that allows you to:
- Search for existing stock adjustment records using specific criteria.
- Produce a screen list of existing stock adjustment records that also provides the ability to drill-down and view more details on individual stock adjustment records.
- Print, export to Excel® or Word® the list of stock adjustments returned by your search.
- Add a new stock adjustment.
- Post stock adjustments (to update 'Quantity on Hand' on the stock record). This process also generates a General Ledger journal if cost-of-goods sold integration is switched on for this shop.
You would use this program to record losses to stock due to theft or damage. You can also use it to record increases in stock quantities.
Important!
This program will automatically check for any unposted stock receipts or adjustments when the 'New' button is clicked. If it detects any, it will redirect you to the 'Unposted Stock Receipts List' or the 'Unposted Stock Adjustment' screen as opposed to the stock receipts search screen. Use these screens to check and post the transactions.
Use the 'Print' button at the top of the screen to create a listing. After checking this, click on the 'Post' button. You will need to tick the checkbox to acknowledge 'Have you printed the Stock Receipt (or Adjustment) Listing and checked these Stock receipts (or Adjustments)?' then the 'GO' button to post these transactions.
Adding a Stock Adjustment
Click the 'New' icon to display a blank 'Stock Adjustment Details' screen.
The focus will be on the 'New' icon when this screen loads, so you can press the 'Enter' key instead of clicking the 'New' icon.
For more information on adding a stock adjustment, refer to section 'Stock Adjustments Details Screen' (below).
Viewing Existing Stock Adjustments
Stock Adjustments Search Screen
The search screen provides the facility to search for existing stock receipts using various search fields.
Click the 'GO' button (or press 'Enter') to execute the search and display the 'Stock adjustment List' screen with the matching records.
Stock List Screen
This list screen displays the stock items matching your search criteria initially sorted by adjustment date.
The records on this screen can be re-sorted by clicking on the heading links above the Stock Adjustment List.
Click on the 'View' Action link to access the stock adjustment record.
Select the 'Print' icon to generate a report of the stock adjustment records currently displayed.
Various sorting and formatting options are displayed, and you can select the type of file and layout you wish to use.
Stock Adjustments Details Screen
| Fields that require detailed information | |
|---|---|
Stock Code | This is the stock code that relates to this adjustment. Use the lookup if you do not know the code (when adding a new stock adjustment). Important! When adding a stock adjustment record if there are unposted stock adjustment records for this stock record then the following message will be displayed 'An unposted Stock Adjustment already exists for this stock code – click OK to display it.' When 'OK' is clicked, the existing unposted adjustment record will be loaded in edit mode. |
Adjustment Date | This will default to today's date. It can be overridden. Important! The date entered here will determine the General Ledger period in which this adjustment will be posted. |
ADJUSTMENT Qty | Enter a negative number to reduce the stock level for this item. Entering a positive number will increase the stock holding for this item. |
Adjustment Expense Account | This program will produce a General Ledger journal if cost-of-goods sold integration is switched on for this shop (Cost-of-goods sold integration is setup using program Finance > School Shop > Setup Information > School Shop Setup on the 'GL Integration' tab). The default account displayed in this field is the 'Cost of Sales Account' for the 'Stock Group' that this item belongs to. This is set up using program Finance > School Shop > Setup Information > School Shop Setup on the 'Stock Groups' tab. The journal that is produced for a negative adjustment is: Cost of Sales DR Stock CR The journal that is produced for a positive adjustment is: Stock DR Cost of Sales CR |
Adjustment Description | This description is posted through to the General Ledger if cost-of-goods sold integration is switched on for this shop. |
Date Received | This will default to the current system date. It can be overridden if you are postdating transactions. |