Inventory & Services
How Do I...
The Sage 50 Inventory & Services Navigation Center
displays information and access points related to your company's inventory
items. It includes a summary of item information, access to recently used
inventory reports, and a graphic analysis of how the cost of sales is
trending. In addition, the Navigation Center shows the flow of inventory-related
tasks and takes you where you need to go to perform those tasks.
Some of the data that appears in the Sage 50 Navigation Centers can
be drilled
down on.
These spots are marked by blue text. Just click it to go to a related
window displaying detail information.
The Inventory & Services
section provides a graphic representation of the flow of inventory-related
tasks, as well as access to those tasks. It also provides access to windows
where you enter/maintain inventory items and company services.
Items & Services—Maintenance
Options
At the top of the section are three buttons that take you
to maintenance options:
Inventory Items:
Click this to select from a menu of inventory-maintenance options:
- New
Item: This takes you to the Maintain
Inventory Items window, where you can enter a new item record.
- View
and Edit Inventory Items: This takes you to the Inventory List,
where you can see a variety of inventory-related information.
- Set
Up Inventory Defaults: This takes you to the Inventory
Item Defaults window, where you can set up a number of inventory-wide
defaults, such price levels.
Company Services:
if your company is a service business, click this to select from a menu
of appropriate maintenance options:
- New
Company Service: This takes you to the Maintain
Inventory Items window, where you can enter a new service record.
- View
and Edit Company Services: This takes you to the Inventory List,
where you can see a variety of service-related information.
- Set
Up Company Service Defaults: This takes you to the Inventory
Item Defaults window, where you can set up a number of service-wide
defaults, such price levels.
Assemblies: Click
the to select from a menu of assembly-related options:
- Set
Up Items for Assembly: This takes you to the Maintain
Inventory Items window, where you can enter the items needed for an
assembly.
- Build
New Assembly: This takes you to the Build/Unbuild
Assemblies window, where you can build or unbuild quantities of assembly
items in inventory.
Prices (Sage 50 Premium Accounting and higher): This takes you to Maintain
Item Prices, where you can change sales and billing prices for items.
- Set
Up Items for Assembly: This takes you to the Maintain
Inventory Items window, where you can enter the items needed for an
assembly.
- Build
New Assembly: This takes you to the Build/Unbuild
Assemblies window, where you can build or unbuild quantities of assembly
items in inventory.
Items & Services—Task
Flow
The task flow takes you from a purchase order to the receipt
of an inventory item. Separate tasks include
Inventory Count and Inventory Adjustments.
Click the appropriate button; a pop-up menu appears. For
example, if you click the Purchase Orders
button, a menu with the following options appears:
The Inventory section
lists all items entered through Maintain
Inventory Items. There are four columns of information for each item:
- Item ID
- Item Name
- Units Sold
- QTY on Hand
- Days
Held (in inventory)
- Turnover
You can sort the information in any of the columns.
View Detailed List:
Click this button (at the top of the section) to see the Inventory
List, which includes detailed information for all items.
Right-click menu:
Right-click the Inventory section
to see a pop-up menu with the following options:
- Add
Inventory Item: Click to go to Maintain Inventory Items and add
a new item.
- View
Customer Detail: Click to go to Maintain Inventory Items and see
the complete information entered for this item.
The Recently Used Inventory
Reports section lists the five most recently opened reports relating
to items. If this is a new company and you are accessing the Inventory
& Services Navigation Center before opening any inventory reports,
the following default reports will be listed:
To see a report on the computer screen, click the View link opposite that
report. To print the report, click the Print
link opposite the report.
At the bottom of the section, there is View
All Inventory & Services Reports link; click this to go to
the Sage 50 Select
a Report window with the list of inventory
reports preselected.
The Cost of Sales Trend
section shows the relationship among your company's revenue, cost of sales,
and gross profit figures. The three measures appear in a line graph, each represented by
a different color.
The link at the bottom of the section lets you view the
Inventory Profitability
Report.
Links in this section provide information about the following:
Inventory/Service Management Tab (Sage 50 Premium Accounting and higher)
General Information
How can I search for information if I don't know the Item ID?You can search for items using any of the following information:
- item ID
- item description
- item type
- description for sales
- description for purchases
- preferred vendor ID
- buyer ID
- item note
- custom field information
To do so:
- Enter the information you do know, such as item description or item type, in the Find item with field.
- Select the type of information from the in field.
- Click Find. Sage 50 will find the item. If there are multiple items that fit your search criteria, Sage 50 will let you choose the correct one.
Note: The search is not case-sensitive. "LAND" is the same as "land". You can also enter just a part of the information, like the last 4 digits of a phone number and search on that. Sage 50 will find partial matches.
What can I do with the sections of item information?You can:
- Change the date range for the information you want to appear. Simply select a different option in the Date Range field.
- Change the sort of the list by clicking a column header. Clicking once will make the list sort by that column in ascending order (A-Z). Clicking again will make it sort by that column in descending order (Z-A).
- Change the width of columns. Simply click and hold the cursor and drag the column line to widen or narrow the column.
- Search for a particular item of information. To do so,
- Click Advanced search. This will open the filter controls.
- Enter the text in the Search for field.
- Select the field in which the information should appear.
- Click Search. To clear the search information, click Clear Search.
Note: These settings will be saved and appear the next time you view this screen. You can close the filter controls by clicking Advanced search.
Modifying this tab
How do I change the columns that appear in a list?
To do this:
- Click the Customize link at the top right corner of the list, then click Settings.
- Use the Settings window to select which fields appear and the order in which they will appear. Tell me more about this window.
- Click OK. The data will automatically change.
Note: These changes will be saved and will appear the next time you view this screen. They are also saved on a per user basis. That is, each user of Sage 50 will have individual settings.
How can I change the number of rows that appear in a section?- Click the Customize link at the top right corner of the section.
- Select the number of rows you want to display for that section. You can choose to display 5 rows, 10 rows, the maximum number of rows, or to have the number of rows determined automatically.
What do you want to do next?