How To: Filter Invoices by Pick Location
Table Of Contents
Overview
The Sales Invoice Manager (SIM) includes a Location Range filter that allows you to view orders containing stock from a specific range of warehouse locations.The filter works with the standard filter saving functionality, making it easy to create and save location-based filter sets for future use.This is particularly useful when:- Picking orders from a specific warehouse area.
- Managing workload by location range.
- Creating saved filter sets for frequently used warehouse zones.
Important: Location codes used with this feature must contain alphanumeric characters only. Special characters can cause unexpected sorting behaviour.
The Sales Invoice Manager (SIM) includes a Location Range filter that allows you to view orders containing stock from a specific range of warehouse locations.
The filter works with the standard filter saving functionality, making it easy to create and save location-based filter sets for future use.
This is particularly useful when:
- Picking orders from a specific warehouse area.
- Managing workload by location range.
- Creating saved filter sets for frequently used warehouse zones.
Important: Location codes used with this feature must contain alphanumeric characters only. Special characters can cause unexpected sorting behaviour.
Valid Examples
AAA1A to AAB2B3A
Invalid Examples
AAA11 to AAB2B/DNR
The second example contains a forward slash (/) and cannot be used.
The second example contains a forward slash (
/) and cannot be used.Prerequisites
- Warehouse functionality must be enabled within your Khaos Control system.
- Location codes must contain only letters and numbers.
- Warehouse functionality must be enabled within your Khaos Control system.
- Location codes must contain only letters and numbers.
Filter Orders by Location Range
- Open the Sales Invoice Manager screen. If required, see (show me how).
- Open the filter window by:
- Clicking Filter, or
- Pressing F4.
- In the bottom-right corner of the Staged Processing Filter screen, locate:
- Location Range Start
- Location Range End
- Enter the required location range.
- Click OK.
The results will display orders containing items within the specified location range.
- Open the Sales Invoice Manager screen. If required, see (show me how).
- Open the filter window by:
- Clicking Filter, or
- Pressing F4.
- In the bottom-right corner of the Staged Processing Filter screen, locate:
- Location Range Start
- Location Range End
- Enter the required location range.
- Click OK.
The results will display orders containing items within the specified location range.
Saving a Location Range Filter
The Location Range filter can be saved as part of a standard filter set.This allows you to:- Quickly reload commonly used warehouse location ranges.
- Create dedicated picking filters for specific warehouse zones.
- Reduce the time spent configuring filters manually.
The Location Range filter can be saved as part of a standard filter set.
This allows you to:
- Quickly reload commonly used warehouse location ranges.
- Create dedicated picking filters for specific warehouse zones.
- Reduce the time spent configuring filters manually.
How Location Range Filtering Works
Use Location Range Start Only
Entering a value in Location Range Start returns locations after the specified value.Example:
Start: A100End: Blank
Returns all locations from A100 onwards.
Entering a value in Location Range Start returns locations after the specified value.
Example:
Start: A100
Start: A100
End: Blank
Returns all locations from A100 onwards.
Use Location Range End Only
Entering a value in Location Range End returns locations before the specified value.Example:
Start: BlankEnd: C999
Returns all locations up to C999.
Entering a value in Location Range End returns locations before the specified value.
Example:
Start: Blank
Start: Blank
End: C999
Returns all locations up to C999.
Use Both Fields
Entering both values returns locations between the two entries, including the start and end locations.Example:
Start: A100End: A500
Returns all matching locations between A100 and A500, inclusive.
Entering both values returns locations between the two entries, including the start and end locations.
Example:
Start: A100
Start: A100
End: A500
Returns all matching locations between A100 and A500, inclusive.
Use Neither Field
Leaving both fields blank returns all locations.
Leaving both fields blank returns all locations.
Location Code Rules
Alphanumeric Characters Only
Location values must contain only:- Letters (A-Z)
- Numbers (0-9)
Special characters are not supported.If a non-alphanumeric character is entered, Khaos Control displays an error message when you click OK.
Location values must contain only:
- Letters (A-Z)
- Numbers (0-9)
Special characters are not supported.
If a non-alphanumeric character is entered, Khaos Control displays an error message when you click OK.
Numeric Sorting
Numbers are treated as coming before letters.For example:
1 to C
includes:- Locations beginning with numbers
- Locations beginning with A
- Locations beginning with B
- Locations beginning with C
but does not include locations beginning with:- D through Z
Numbers are treated as coming before letters.
For example:
1 to C
includes:
- Locations beginning with numbers
- Locations beginning with A
- Locations beginning with B
- Locations beginning with C
but does not include locations beginning with:
- D through Z
Different Length Location Codes
The start and end locations do not need to contain the same number of characters.For example:
Location Range Start: A
Location Range End: Bb
Khaos Control interprets the value A as A0, ensuring all valid locations beginning with A are included.
The start and end locations do not need to contain the same number of characters.
For example:
Location Range Start: A
Location Range End: Bb
Khaos Control interprets the value A as A0, ensuring all valid locations beginning with A are included.
Location Range Based on Pick
The filter screen also includes the Location Range Based on Pick option.
The filter screen also includes the Location Range Based on Pick option.
When Ticked
The location range is applied using the actual pick locations for the invoice.
The location range is applied using the actual pick locations for the invoice.
When Unticked
The location range is applied using all potential pick locations available for the invoice.
The location range is applied using all potential pick locations available for the invoice.
Additional Information
- This feature is available only on warehouse-enabled systems.
- Location ranges can be included in saved filter sets.
- Start and end locations are inclusive.
- Special characters are not supported within location ranges.
- The filter can be used with either field individually or with both fields together.
- The Location Range Based on Pick option changes whether the filter uses actual pick locations or potential pick locations.
- This feature is available only on warehouse-enabled systems.
- Location ranges can be included in saved filter sets.
- Start and end locations are inclusive.
- Special characters are not supported within location ranges.
- The filter can be used with either field individually or with both fields together.
- The Location Range Based on Pick option changes whether the filter uses actual pick locations or potential pick locations.