Skip to main content

Before you begin

Before you begin: Confirm the plugin is available in the intended account book and review the user’s stock locations and access rights. Batch Options and UOM Option require the corresponding Item Batch or Multi-UOM modules; Show cost requires the standard View Cost permission.

01. Configure Stock Availability Report Access Rights

Open General Maintenance > Access Right Maintenance. Select the user/group, then expand SL Plug-In > Stock Availability Report. Assign Show Stock Availability Report, Show User Default Setting, User follow User Default Setting, Can Edit Multi Dimensional Sales Analysis Data Area Options, and Show License Status only as appropriate. The standard View Cost right controls Show cost. Standard Customize Grid Layout and Grid Column Chooser rights control lookup layout actions.

  1. Open General Maintenance > Access Right Maintenance.
  2. Expand SL Plug-In > Stock Availability Report for the relevant user or group.
  3. Assign Show Stock Availability Report and, where needed, Show User Default Setting and User follow User Default Setting.
  4. Restrict Can Edit Multi Dimensional Sales Analysis Data Area Options and Show License Status appropriately.
  5. Review standard View Cost, Customize Grid Layout and Grid Column Chooser rights. Save changes.

Check: Confirm the results and relevant permissions before continuing.

02. Run the Stock Availability Report

Select a report date, item and permitted stock locations before generating results.

  1. Open Stock Availability Report > Stock Availability Report.
  2. Select Date, Stock Item and one or more Stock Location rows. Use All to tick or untick displayed locations.
  3. Click More Option if additional filters are required.
  4. Click Inquiry; then use Preview, Print or Hide Options as needed.

Check: Confirm the results and relevant permissions before continuing.

03. Choose Advanced Filters and Report Options

More Option contains Filter 1, Filter 2, Report Options and Other Options.

  1. Under Filter 1, review Date, Stock Item, Stock Group, Stock Item Type, Batch Options and active/inactive items.
  2. Under Filter 2, filter by Stock Brand, Stock Category or Stock Class.
  3. Under Report Options, choose Group By and Show Criteria In Report.
  4. Under Other Options, review zero balances, Include No Transaction Item(s), Use Desc For Header, Show cost, Include Outstanding SO & PO, Include Consignment and UOM Option.
  5. Click Inquiry to refresh the results.
Module requirements: Batch Options require Item Batch, UOM Option requires Multi-UOM, and Show cost requires View Cost.

Check: Confirm the results and relevant permissions before continuing.

04. Maintain User Default Stock Locations

User Default Setting allows authorized maintenance of stock locations for each active user.

  1. Open Stock Availability Report > User Default Setting.
  2. Select an active user; choose Edit to maintain locations or View for read-only inspection.
  3. Tick allowed locations; use Check All or Uncheck All as required.
  4. Click Save. When User follow User Default Setting applies, the report follows saved allowed locations. The documented fallback is HQ when no location is saved and HQ exists.

Check: Confirm the results and relevant permissions before continuing.

05. Check Stock Balances in Item Code Lookup

The enhanced lookup makes stock balances visible during supported document entry.

  1. Open a supported Quotation, Sales Order, Delivery Order, Invoice, Stock Transfer, Purchase Return or Consignment document.
  2. Open Item Code lookup and review Item Code and Description.
  3. When enabled, check Balance Qty and current-location Bal. Qty. Consignment-enabled installations also provide CSGN Qty and On Hand Qty.
  4. If the document location changes, verify the refreshed balance before selecting the item.

Check: Confirm the results and relevant permissions before continuing.

06. Save and Manage Lookup Layouts

Saved lookup layouts are user-specific preferences and should be preserved unless intentionally changed.

  1. Right-click the Item Code lookup grid.
  2. Choose Save Layout, name it and optionally tick Save As Default.
  3. Use Load Layout to apply a stored layout.
  4. Use Reset Layout only when the current user’s saved assignment should be cleared.
  5. In Layout Manager, maintain defaults and assignments; click Save Assignments after changing them.
Important: Do not reset a user’s saved layout without permission.

Check: Confirm the results and relevant permissions before continuing.

07. Review Multi-Dimensional Sales Analysis Options

The plugin can restrict selected standard sales-analysis data-area options.

  1. Open standard Multi-Dimensional Sales Analysis.
  2. Users with Can Edit Multi Dimensional Sales Analysis Data Area Options may use the related controls.
  3. Without this right, Show Local SubTotal, Show Local Total Cost, Show Local Profit, Show Profit Margin, Show Unit Price and Show Unit Cost are unchecked and disabled.
  4. Run the analysis using the options available to the user.

Check: Confirm the results and relevant permissions before continuing.

Troubleshooting

Report menu missing
Check the plugin and Show Stock Availability Report access right.
Expected stock location missing
Check User Default Setting and User follow User Default Setting permissions.
Show cost unavailable
Review the standard View Cost right.
Item lookup balance unexpected
Review document location, enabled quantity display and the available modules.
Lookup layout unavailable
Check standard Customize Grid Layout and Grid Column Chooser rights.

Frequently Asked Questions

Can I view multiple locations?

Yes. Select the applicable stock locations before Inquiry.

Can I filter by date?

Yes. Date is a documented report criterion.

Can I use stock group, brand, category and class filters?

Yes. These are available through More Option.

Can the Item Code lookup display quantities?

Yes, when enabled, it provides Balance Qty and current-location Bal. Qty.

Can users have different default locations?

Yes. User Default Setting maintains locations per active user.

Can I view costs without permission?

The standard View Cost right controls the Show cost option and cost fields.

Can lookup layouts be saved?

Authorized users can Save, Load, Reset and manage layouts.

Resources and Technical Support

Browse the AutoCount Knowledge Base and Advanced Plugin Guides.

Need help with Stock Availability Report?

Contact SL Software Solutions for help with report criteria, locations, stock lookups or access rights. Share your AutoCount version and relevant screen details.

Contact Support