Home » Categories » Multiple Categories

Order Entry - Additional Options for Hiding Stock Records from Selection

When adding a sales or purchase order line the system offers <F4-Select> on the stock code input to search for the stock record – listing all the stock codes that match your entered search filter. Existing options allow you to hide records from the search results – hiding from selection if an item is flagged as discontinued or if has no available stock for example.

This new feature allows you to hide records based on comparing a data item on the stock record against the order detail being added – for example in Purchase Order Processing to only allow the search results to list items for the same supplier as the order is being added for.


Installation

Application User Facilities

The option to hide records from stock searches within Order Processing is defined within the Optional Features.

Premier Installer users can right-click on the Order Entry option on the menu and choose Advanced Input Facilities and Optional Features.

Alternatively, select Installation from the main menu followed by Application Manager and then Application User Facilities. Choose the required Order Processing application and then Enter/Amend Orders followed by Advanced Input Facilities and Optional Features.

The ‘Ignore Stock’ options are configured on screen 4 of the Optional Features.


 

Ignore Records on F4 Stock Lookup – set to enable the option to hide stock records from the search results. When set a pop-up form is displayed to set the hide controls.

Stock Item to Test – select the data item on the stock file to be tested to determine if the stock record is to show.

Test Equal or Not Equal – set whether stock records are to be hidden if equal to the search value or if hidden when not equal to the search value.

Value to Test Against – here you reference the value to check against. Existing options meant that you could enter text such as ‘Y’ if you were, for example, checking a ‘Discontinued’ flag on the stock record, you could also enter !nnn where nnn is replaced by a stock data item so that you could hide where one stock value not equal to another.

This new feature allows you to reference a detail data item by entering !Dnnn where the !D indicates that matching an item on the detail database and nnn references the data item on the detail file – the example above !D005 is checking the supplier code against the account code item on the order detail file. When referencing an item on the detail file you should ensure the item is set prior to the input of the stock code – in practice this would mean an item entered on the order header and copied to the order lines.

 

Custom Fields
  • Release ID: 7.7
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Create New Delivery Address (SOP Only)
Viewed 2098 times since Fri, Jun 8, 2012
Acknowledgements, Goods Received and Supplier Invoices
Viewed 1472 times since Tue, Jul 3, 2012
Set Auto Expand Data Files
Viewed 1616 times since Wed, Jul 4, 2012
Instant Print Document Selection 5.6
Viewed 1594 times since Wed, Jun 13, 2012
Header Optional 4
Viewed 1809 times since Wed, Jul 4, 2012
Credit Note Documents / Deposit Refunds – User Authorisation Options (SOP Only)
Viewed 61 times since Thu, Jan 9, 2025
Order Processing and Other Files
Viewed 1435 times since Tue, Jul 3, 2012
Document Processing – Quantity Validation on Order Acknowledgements
Viewed 105 times since Tue, Oct 22, 2024
Change Active Orders Back to Quotes
Viewed 162 times since Thu, Oct 17, 2024
Ledger Enquiry Manager
Viewed 1888 times since Wed, Jul 4, 2012