Let us help you tackle any Software issues and optimize your accounting workflow. 

Sage 50 crashes when saving transactions

How to Sort the Sales Order Picking List by Location in Sage 50 Accounting US

When warehouse employees need to collect products for customer orders, the order in which inventory appears on a picking list can make a significant difference. A list arranged by item number or sales order may be useful for reviewing transactions, but it may force employees to move repeatedly between shelves, aisles, and storage areas. Businesses looking to improve their warehouse picking process often want to sort a Sage 50 picking list by location so staff can collect products in a more organized sequence.

Sage 50 US editions provide a Picklist report that lists items on open sales orders and proposals, with a sorting option that includes location in supported editions. The report can help warehouse staff identify what needs to be picked and organize the information around where inventory is stored. However, the available options depend on the Sage 50 edition, report settings, and how inventory locations have been configured. The standard location field should also not automatically be confused with a detailed warehouse aisle, shelf, or bin-management system.

This guide explains how to sort a Sage 50 sales order picking list by location, configure the relevant report options, check inventory records, and address common problems when the results do not match the warehouse’s needs. It also covers practical alternatives for businesses that need more detailed bin-level picking, multiple warehouse workflows, or additional reporting customization. The aim is to help you use Sage 50’s existing features effectively without making unsupported changes to inventory records or sales transactions.

Why Can’t You Sort a Sage 50 Picking List by Location?

Several factors can prevent a picking list from appearing in the expected location order. The most common issue is that the user is printing a different report, such as the Sales Order report, instead of the Picklist report. Another possibility is that the report’s Sort by setting is still configured for sales order number, ship-by date, customer ID, or item ID rather than location.

Inventory setup can also affect the results. If location information is missing, inconsistent, or entered as a general description rather than a standardized warehouse code, the report may not provide the useful picking sequence employees expect. In addition, not every Sage 50 edition supports the same inventory-location features. The US Picklist report documentation identifies Sage 50 Premium Accounting and higher as the supported editions for this report.

Common Causes of Sage 50 Picking List Location-Sorting Problems

The following table summarizes the main reasons a Sage 50 sales order picking list may not be sorted as expected.

Possible causeWhat you may noticeRecommended action
Incorrect report selectedThe report does not offer a location sorting optionOpen the Picklist report under Accounts Receivable
Incorrect sorting settingItems appear by order number, customer, or item IDSelect Location in the report’s Sort by options
Location details are missingItems appear without useful storage informationReview the inventory item records and location setup
Multiple locations are not enabledYou cannot configure the expected location featuresCheck the edition and inventory settings
Inconsistent location namingSimilar products appear under different or confusing codesStandardize location codes and descriptions
Wrong report filtersExpected sales orders or items are missingReview the as-of date and other report filters
Report columns are unsuitableThe output does not show the information pickers needReview the report’s column and field options
Need for bin-level sortingThe list shows a general location but not the precise shelf or binConfirm the available fields or consider a specialized warehouse solution
Outdated assumptions about the softwareInstructions do not match the installed versionFollow the documentation for your Sage 50 edition and release

The most efficient approach is to check the report type and sorting option first. If those settings are correct, investigate the inventory data, location configuration, filters, and report layout in that order. Avoid modifying inventory quantities or posting adjustments merely to change how a report is displayed.

How to Sort a Sage 50 Picking List by Location?

The following steps apply to the US edition of Sage 50 where the Picklist report and location sorting are available. Menu labels can vary by release, so use the equivalent report options in your installed version if the interface differs.

Step 1: Open the Picklist Report

Start by opening the correct report rather than trying to change the order of a sales order transaction itself.

  1. Open Sage 50 and select the appropriate company.
  2. Go to Reports & Forms.
  3. Open Accounts Receivable.
  4. Double-click Picklist Report.
  5. Review the report’s available options before printing or exporting it.

The Picklist report lists items on open sales orders and proposals and is intended to help users gather products needed to fulfill sales. Sage’s documentation identifies this report as available in Sage 50 Premium Accounting and higher. If you cannot find the report, verify your product edition and version. You may be using a different regional edition of Sage 50, where report names and inventory features can differ. Do not assume that instructions for Sage 50 US, Sage 50 Canada, and Sage 50 UK describe the same feature set.

Why this step matters: The Picklist report is designed for fulfillment. A Sales Order report, inventory list, or transaction list may provide useful information, but it does not necessarily have the same sorting options.

Step 2: Open the Picklist Report Options

After opening the Picklist report, locate the Options button. This opens the settings used to define the report’s criteria and ordering. Depending on the version, you may see settings for:

  • As-of date
  • Sort by
  • Report summary
  • Filters
  • Description length

The Sort by setting is the key option for this task. Sage’s US documentation lists sales order or proposal number, ship-by date, customer ID, item ID, and location as available sorting choices for the Picklist report. If the report is already open in a preview window, return to its options rather than editing individual sales orders. Changing the sort order should affect how the report presents information; it should not change the order’s contents or alter inventory balances.

Step 3: Select Location as the Sort Order

In the Picklist report options, find the Sort by dropdown or equivalent control.

  1. Open the sorting options.
  2. Select Location.
  3. Review any other report criteria that are currently selected.
  4. Confirm the settings and run or preview the report.

This is the primary step for users who want to Sage 50 sort picking list by location. When the location option is available and the relevant inventory records contain usable location information, the report can organize its output around that field.

Do not select Item ID if your main goal is to group products by their storage locations. Item ID sorting organizes records around product identifiers, which may be useful for stock review but may not produce the desired location-based picking workflow. Likewise, sorting by sales order number prioritizes order identification rather than the warehouse’s physical layout. That may be appropriate for picking one customer order at a time, but less convenient when employees are collecting multiple orders in a single trip.

Step 4: Check the Report’s Filters and Date

Before printing, review the as-of date and any filters that determine which transactions appear. The Picklist report uses an as-of date to establish the date for which the report is current. Its filters can also affect which sales orders, proposals, or items are included.

For example, if an employee expects to pick five orders but the report includes only three, the problem may not be the location sort order. One or more of the missing orders may fall outside the selected criteria. Check the following:

  • Is the report’s as-of date appropriate for the fulfillment run?
  • Are the required open sales orders included?
  • Are any filters excluding relevant orders or items?
  • Are drop shipments included or excluded according to the warehouse process?
  • Does the report reflect the intended fulfillment period?

Drop shipments deserve particular attention. Products shipped directly from a vendor may not follow the same warehouse picking process as goods stored on your premises. Sage’s Picklist report supports options for including drop shipments or producing a report specifically for them, depending on the available settings.

Step 5: Review the Preview Before Printing

Run the report and inspect the preview before sending it to the warehouse. Check whether:

  • The expected sales orders appear.
  • Product IDs and descriptions are readable.
  • The location information is meaningful.
  • Quantities correspond to the outstanding fulfillment requirements.
  • The report’s order is practical for the people collecting inventory.

If the output is arranged by location but the locations are named inconsistently, the report may still be difficult to use. For example, codes such as A1, A-01, and AISLE-A-01 may represent similar areas but appear as separate values. Also distinguish between sorting by location and optimizing a walking route. A report sorted by a location field does not necessarily know the physical distance between shelves, one-way aisle rules, restricted areas, or the best path through a warehouse. It improves organization, but it should not be assumed to provide sophisticated route optimization.

Step 6: Print or Export the Picking Information

Once the preview looks correct, print the report or use the available output options in your version of Sage 50.

Before distributing it, confirm that the output includes the information the warehouse actually needs. A location-based picking list is most useful when staff can quickly identify the item, required quantity, and storage area without repeatedly checking another screen. A practical warehouse document may need:

  • Sales order or customer reference
  • Item ID and description
  • Quantity to pick
  • Location identifier
  • Any required handling notes, if supported by the report or a separate process

Do not assume every field above can be added directly to every standard Picklist report. The available columns depend on the report and product version. If a required field is missing, review the report’s supported customization options before looking for a workaround.

How to Improve Sage 50 Inventory Location Sorting

Selecting the location sort order is only part of the solution. For location-based order picking to work consistently, the underlying inventory records and warehouse procedures must also be organized.

Step 1: Review Inventory Item Location Information

Open the relevant inventory item records and inspect the location information available in your Sage 50 edition.

Look for missing values, inconsistent codes, outdated descriptions, and items assigned to locations that are no longer used. If the report relies on the location field associated with an inventory item, the output will only be as useful as the information maintained in that field. For example, a warehouse might use location codes such as:

  • A-01 for aisle A, shelf 01
  • A-02 for aisle A, shelf 02
  • B-01 for aisle B, shelf 01

This kind of naming system is only an example; it does not mean Sage 50 automatically interprets each part of the code as a separate aisle, shelf, or bin. The goal is to make each code consistent and understandable to employees.

Sage’s US knowledge base describes tracking inventory across multiple locations by using separate stock items or master stock items with substock items for different locations. It also advises including the store name or number in the item ID where that approach is used and entering the location in the inventory item record. Before adopting such a structure, consider the effect on item selection, purchasing, sales, reporting, and historical records. Creating duplicate items solely to change the order of a picking list may add unnecessary complexity.

Step 2: Verify Whether Multiple Inventory Locations Are Enabled

If your workflow requires inventory to be tracked at more than one location, check whether your edition supports that feature and whether it is configured.

In supported Sage 50 US editions, location-related features may be available through inventory settings. In Sage 50 Canada, Sage’s instructions describe a route through Setup → Settings → Inventory & Services → Locations, where users can enable the multiple-location option in supported editions. The precise path and feature names differ between regional products, so use the instructions for your own edition. Before changing these settings:

  1. Confirm your Sage 50 edition supports multiple locations.
  2. Review the official instructions for the installed version.
  3. Check the effect of the change on existing inventory records and transactions.
  4. Make a verified backup before making significant configuration changes.
  5. Follow any required single-user or administrator access instructions for your edition.

Do not disable or recreate existing locations simply to make a report look different. Sage’s Canadian documentation notes that locations used in transactions may not be removable or made inactive, and that location settings cannot necessarily be turned off after use.

Step 3: Standardize Location Codes

Create a documented naming convention for the locations used in your warehouse. A simple convention might combine an aisle and shelf identifier, such as A-01, A-02, or B-01. If the warehouse has multiple floors or zones, you may choose a format that includes those elements, provided it is supported by your inventory records and easy for employees to interpret. Consistency matters more than complexity. A useful location code should be:

  • Unique within the intended storage system
  • Short enough to read on a printed list
  • Consistent in capitalization and punctuation
  • Easy to find on warehouse labels
  • Documented so new employees understand it

If you use separate inventory items to represent stock held at different locations, establish clear item IDs and descriptions. Avoid mixing naming conventions across old and new records. One important limitation is that a standard location field may represent a broad storage area rather than a detailed bin hierarchy. If your warehouse needs separate values for building, zone, aisle, rack, shelf, and bin, check whether your version and report can represent those details. A single text field may not deliver the structured inventory picking system you need.

Step 4: Confirm Location Sorting with a Small Test

Before using a location-based list for a large fulfillment run, test it with a small group of open sales orders. Choose several inventory items that have known location values. Run the Picklist report with Sort by: Location, then compare the result against the inventory records. Ask these questions:

  • Are the selected items present?
  • Do their displayed locations match the records?
  • Are the records grouped in a useful order?
  • Are any locations blank or inconsistent?
  • Can the warehouse employee find the products using the printed information?

If the results do not match, check whether the report uses the location information you expect. Do not change inventory quantities, ship orders, or post transactions just to test a report’s sorting behavior. Once the test is successful, save or document the report settings if your version supports a reusable report template or saved configuration. This helps the team repeat the same process without relying on an employee’s memory.

Customize the Sage 50 Picking List for Warehouse Use

Sorting by location is useful, but a picking list also needs to communicate the right information clearly. Sage 50 provides report customization options, although the available fields and controls depend on the specific report and edition.

A. Use the Available Report Customization Options

The standard Picklist report documentation identifies Options for criteria and sorting. Older US help documentation also describes Columns settings for choosing report fields and controlling column breaks. Availability and exact controls may vary by release.

If your version provides column customization, review whether the report includes the information employees need. Avoid adding every available field simply because it exists. Too many columns can make a printed report difficult to scan, especially on narrow paper or a handheld printout.

For a typical warehouse workflow, prioritize item identification, quantity, location, and the order reference needed to reconcile the picked products. Keep customer-facing information to the level required by the fulfillment process. If you cannot customize the standard Picklist report sufficiently, consider whether a separate inventory report can provide supplementary location information. Inventory reports may have their own filters and customization settings, but they do not automatically replace a sales-order-based picking list.

B. Understand the Difference Between a Picklist and an Inventory Report

The Picklist report is designed around items on open sales orders and proposals. An inventory report, by contrast, can help review inventory details, quantities, and other stock information. The two serve different purposes.

Use the Picklist report when the main question is:

  • Which products are required to fulfill these open orders?
  • Use an inventory report when the main question is:
  • What inventory information do we need to review or verify?

For example, an inventory item list may help employees verify item IDs and quantities on hand, but it may not show which quantities are needed for a particular sales order. Combining a picking list with a separate inventory reference can be useful when the standard report does not include every detail required by the warehouse.

Be careful when reconciling two reports. They may use different dates, filters, or definitions of quantity. Confirm that the information is comparable before using it to make fulfillment decisions.

C. Save a Repeatable Report Workflow

If your Sage 50 release supports saving report templates or reusable report settings, use that capability to establish a consistent picking process. A standard procedure should document:

  1. Which Picklist report to open.
  2. Which as-of date to use.
  3. Which filters should be applied.
  4. Which sorting option to select.
  5. Which columns or output settings to use.
  6. Who reviews the report before it is released to the warehouse.

This reduces the risk of different employees producing lists with different criteria. It also makes it easier to investigate missing orders or unexpected location groupings. Do not assume that every version allows all report settings to be saved as a template. If your release does not provide that feature, maintain a short internal procedure instead.

What If Sage 50 Does Not Sort by Bin Location?

One of the most important distinctions in warehouse inventory management is the difference between a general inventory location and a detailed bin location. A general location might identify a warehouse, store, or storage area. A bin location typically identifies a more specific place inside that area, such as a particular aisle, rack, shelf, or compartment. Whether Sage 50 can record and report these levels separately depends on the product edition and configuration.

A. Check What the Location Field Actually Represents

Start by examining the location information available in the inventory record and the fields included in the report. Determine whether the field represents a warehouse, a storage area, or a more precise picking location.

For example, if the inventory record says Main Warehouse, sorting by that value may group items under the main warehouse, but it will not necessarily tell an employee whether the item is in aisle A, rack 3, or bin 12. You should not assume that a standard Sage 50 location field automatically supports a full warehouse management hierarchy. Sage’s documentation on tracking inventory at different locations describes approaches based on separate stock items or substock items, rather than establishing that every Sage 50 edition provides advanced bin-level warehouse management.

B. Decide Whether a Separate Location Reference Is Enough

If your warehouse is small, a simple naming convention may be sufficient. You might maintain consistent location descriptions and use a report or supplemental reference that employees can consult during picking.

However, consider the limitations before choosing this approach. A separate spreadsheet or manual reference must be kept synchronized with inventory changes. If items move frequently, employees may pick from outdated locations unless someone updates the reference promptly. For a small inventory, the extra administrative effort may be manageable. For a large or fast-moving warehouse, it can create discrepancies and slow fulfillment.

C. Consider a Dedicated Warehouse Management Add-on

If you need structured bin allocations, multi-warehouse stock control, directed picking routes, barcode scanning, or automated picking workflows, investigate whether a compatible warehouse management solution is appropriate.

Sage’s knowledge base notes that third-party add-on applications may offer additional multiple-location or warehouse tracking capabilities beyond the basic approach described for Sage 50 inventory items.

Before adopting an add-on, verify that it supports your exact Sage 50 edition and release. Ask the provider how it handles inventory synchronization, sales order fulfillment, partial picks, stock transfers, returns, and audit trails. Test it with representative transactions before deploying it to the entire warehouse.

An add-on should solve a clearly defined operational problem, not simply duplicate information already available in Sage 50.

Troubleshooting: Sage 50 Picking List Still Appears in the Wrong Order

If you have selected location sorting but the output still looks incorrect, use the following checks before changing your inventory setup.

1. The Report Is Still Sorted by Item ID or Sales Order

What happens: The report appears in a logical order, but it does not follow the warehouse locations.

What to do: Reopen the Picklist report’s Options and inspect the Sort by selection. Confirm that Location is selected rather than sales order number, ship-by date, customer ID, or item ID. These are separate sorting options in the documented US Picklist report. 

If the option is selected but the preview does not change, close the preview, reopen the report settings, and run the report again. Avoid assuming that changing the order of columns will also change the order of the records.

2. Some Inventory Items Have Blank or Unclear Locations

What happens: Some items appear grouped together or cannot be located easily on the warehouse floor.

What to do: Review the inventory records for the affected items. Confirm that their location information is present, consistent, and aligned with the labels used in the warehouse.

If the location field is intended to identify a broad warehouse rather than a bin, determine whether an additional reference is required. Do not enter invented bin values into a field that your organization uses for another purpose.

3. Expected Orders Are Missing from the List

What happens: The picking list contains fewer orders or items than the warehouse expected.

What to do: Check the report’s as-of date, filters, and the status of the sales orders. The Picklist report focuses on open sales orders and proposals, so a report’s selection criteria can affect which records appear.

Also verify whether the missing items are part of a drop shipment or another fulfillment process that is filtered out. If necessary, run a test report with carefully reviewed criteria to identify which setting is excluding the expected information.

4. The Report Does Not Offer a Location Option

What happens: The Sort by list does not include Location.

What to do: Confirm that you opened the correct report and are using the correct Sage 50 regional edition. The US Picklist report documentation identifies location sorting as an available option, while report features and inventory-location capabilities can vary by product and edition.

If you are using a different edition or a different report, consult the corresponding official help documentation. Do not assume that instructions for Sage 50 US apply unchanged to Sage 50 Canada or Sage 50 UK.

5. The Location Order Is Technically Correct but Operationally Poor

What happens: The report is sorted by location, but staff still travel back and forth across the warehouse.

What to do: Check whether the location codes correspond to the physical layout and whether the sequence is practical for picking. A basic sort groups information according to the field’s stored values; it does not necessarily calculate the shortest walking route.

Standardize location naming and consider whether a warehouse map or more advanced picking solution is needed. If the warehouse requires zone picking or optimized routes, confirm that the available Sage 50 features meet those needs before relying on a simple report sort.

6. The Report Is Missing a Required Column

What happens: The list is sorted correctly but does not include a useful detail, such as a specific storage reference or additional handling information.

What to do: Review the report’s available column and customization settings. The exact fields available vary by report and version. If the needed information is not supported, determine whether another inventory report or a compatible add-on can provide it.

Do not change sales order descriptions or item IDs just to force extra information into the output without considering the impact on searches, transactions, and reporting.

Best Practices for an Efficient Sage 50 Warehouse Picking Process

Once your picking list is sorted correctly, a few operational improvements can help make location-based picking more reliable.

A. Keep Inventory Records and Physical Labels Consistent

Use the same location codes in inventory records, warehouse labels, and internal procedures. If a product moves, update the appropriate records and references promptly. Otherwise, the picking list may direct an employee to a location where the product is no longer stored.

Where inventory is tracked across multiple locations, train staff to select the correct stock item when entering purchases and sales. Sage’s guidance on multiple-location inventory emphasizes selecting the item associated with the appropriate location.

B. Separate Picking from Packing and Shipping

A location-based picking list is primarily a tool for gathering products. Packing involves verifying the picked items, preparing the shipment, and checking that the correct quantities are being sent to the customer.

A practical workflow is to:

  1. Generate the Picklist report from the relevant open orders.
  2. Review the report and confirm the location sorting.
  3. Pick products using the location references provided.
  4. Verify the items and quantities against the order.
  5. Complete the applicable Sage 50 fulfillment and invoicing steps.

Sage 50 sales orders can be used to track items before they are invoiced and shipped, and sales orders can be printed as warehouse picking slips or packing slips in supported workflows.

The precise transaction steps depend on your edition and how your business handles partial shipments, backorders, and invoicing. Follow the established procedure for recording actual shipments rather than treating a printed picking list as proof that stock has been shipped.

C. Measure Picking Accuracy and Time

Review whether the new report format actually improves fulfillment. Useful measures include picking errors, missing items, time spent finding products, order completion time, and the number of trips required to collect an order.

Compare performance before and after changing the sorting process, using similar types of orders where possible. If errors remain high, investigate whether location records, warehouse labels, or staff procedures are the real source of the problem.

How to Prevent Future Picking List Problems

Use a repeatable maintenance routine to keep location-based picking reliable.

  • Review location data regularly. Check for blank, duplicated, or outdated location descriptions.
  • Use a consistent naming convention. Avoid creating several versions of the same location code.
  • Document report settings. Record the correct report, sort order, date criteria, and filters.
  • Test changes before large picking runs. Verify the output against a small selection of inventory items and sales orders.
  • Train warehouse staff. Explain how to read the list and what to do when an item cannot be found.
  • Back up company data before significant configuration changes. Follow the backup and change-management procedures for your version.
  • Review the need for additional tools. If the business needs bin-level allocations, barcode scanning, or route optimization, evaluate compatible warehouse management software instead of relying on a basic report sort.

These practices help maintain consistency between the accounting system, inventory records, and the warehouse’s actual storage arrangement.

Conclusion

To sort a Sage 50 picking list by location, open Reports & Forms → Accounts Receivable → Picklist Report, select Options, and choose Location under Sort by, where that option is supported. Then review the as-of date, filters, inventory location information, and report preview before printing the list.

If the output is still unsuitable, check for missing location data, inconsistent codes, incorrect report selection, or a need for more detailed bin-level information. Sage 50’s standard location sorting can improve the organization of a sales order picking list, but it should not be confused with advanced warehouse route optimization or a complete bin-management system. Using consistent inventory records and a documented picking workflow will help your team fulfill orders more accurately and efficiently.

FAQs of Sage 50 Sort Picking List by Location: 

Can you sort a Sage 50 picking list by location?

Yes. In the US edition, the Picklist report includes Location as a sorting option in supported editions. Open Reports & Forms → Accounts Receivable → Picklist Report, click Options, and select Location under Sort by.

Which Sage 50 report should I use for a sales order picking list?

Use the Picklist report to list items on open sales orders and proposals for fulfillment. Sage’s US documentation identifies this report as available in Sage 50 Premium Accounting and higher. Check your regional edition’s documentation if the report name or availability differs.

Why is the Location option missing from my Sage 50 report?

You may have opened a different report, be using a different regional edition, or have a version that does not support the expected feature. Confirm that you are using the Picklist report and check the official documentation for your exact Sage 50 edition.

Does sorting by location automatically optimize the warehouse picking route?

No. Sorting by location organizes the report according to the stored location field. It does not necessarily calculate the shortest walking path, optimize aisle sequences, or assign picking zones. Those requirements may need a more specialized warehouse management solution.

Can Sage 50 track inventory at multiple locations?

Multiple-location inventory features are available in supported editions, but setup and capabilities vary by regional product. Sage’s US knowledge base describes approaches using separate stock items or master items with substock items to distinguish locations. Check your edition’s documentation before changing your inventory structure.

Can I customize the columns on a Sage 50 Picklist report?

Customization options depend on the report and product version. Sage’s Picklist report documentation describes report options for criteria and sorting, while earlier US documentation also describes choosing report columns. Check your installed version for the available field and layout controls.

What should I do if Sage 50 does not show detailed bin locations?

First, check what the inventory location field represents and which location-related fields the Picklist report supports. If your workflow requires separate aisle, rack, shelf, and bin details that the standard report cannot provide, evaluate a compatible warehouse management add-on. Confirm its integration and inventory synchronization capabilities before implementation.

Related Articles