Order Entry - Abandon Immediate Issue if Insufficient Stock


Datafile Software

Order Entry - Abandon Immediate Issue if Insufficient Stock

Introduced in Release 6.5 the ‘Immediate Issue’ option allows for component entries of a works order to be optionally issued from stock during works order entry or to issue components separately from the build during document processing. If selected to issue during order entry, and insufficient stock was available, the system offered options to nominate an alternate stock item, to omit the component completely or to issue the component and allow stock to go ‘negative’.

This new feature, if enabled, replaces the Negative option with a Abandon option which allows the works order to be created but disables the immediate issue flag so that stock is not issued for the components.


Note - as the stock is issued as each works order line is created then if the ‘Abandon’ option is selected on a shortfall the system, behind-the-scenes, continues to add the remaining lines without issuing stock before creating negative issues for the stock lines processed before the abandon option was selected.

Document Processing

To enable a similar facility within the document – whether issuing components only or building the assembly – existing parameters allow setting of an equivalent option to abandon the issue if insufficient stock is available.

On parameter screen 16 of the document parameters are options to ‘Only Allow Qty if Physically Available’ and ‘If Physical Check – Prompt Abandon Build’ – setting both these options enables the facility to abandon the issue process.

Installation

Database Changes

One new item is required on the Works Order detail file for this new feature. To add this new item select Installation from the main menu followed by Application Manager and then Restructure A Database. Select the Bill of Materials application. Elect to update the Live Files and then select the Works Order Detail File. The existing data items are then displayed on screen, scroll-down to the next available blank entries and create the following items:

Item Type Description

IMMED-ISSUE ? Flag item to identify whether the works order detail has been immediately issued.

To insert a new item press <Enter> against a blank entry, enter the title as required and press <Enter>, select the item type (using the drop-down list if required), and depending on item type select the size required.

Once the additional items have been recorded press the <ESC> key and select the UPDATE button to save the database changes. When prompted respond ‘Y’ to the prompts to ‘Extract Existing Data to New Database Structure’ and, if appropriate, ‘Copy Table Entries from Old Database to New Database. Final prompts ask to ‘Remove (.OLD) Database’ and to ‘Carry Out the Same Restructure on the BASE File as well’ – respond as required. If you select to update the base file you need to manually insert the new items at the same data item positions as on the live file.

Database Profiles

The new data item needs to be referenced within the Database Profiles. To update these settings select Installation from the main menu followed by Application Manager and Set Database Profiles. Choose the Bill of Materials application as required before selecting the Detail Optional 1 parameter screen.


On the left of the screen is the prompt Immediate Issue – against this item reference the data item number of the equivalent item created above, <F4-Select> is available if required.


Custom Fields

Article ID: 1919
Created On: Fri, Oct 26, 2012 at 11:47 AM
Last Updated On: Wed, Jun 14, 2023 at 4:25 PM

Online URL: https://kb.datafile.co.uk/article/order-entry-abandon-immediate-issue-if-insufficient-stock-1919.html