Automatic Write-Off of Variable Stock


Datafile Software

Automatic Write-Off of Variable Stock

Selected Stock Items by nature may not be shipped in exact quantities particularly when shipped in bulk. Alternatively you may have a standing order to refill vending machines but the actual items sold depend on what has been used in the previous period.

This type of adjustment in the delivered / invoiced quantity from the order quantity is handled by the write-off procedures within the order processing document but this by nature is either a manual process or, if performed automatically, global assumptions have to be made. This feature allows selected stock / order lines to be flagged as ‘variable’ stock lines.When processed on delivery / invoice the ‘unprocessed’ balance of the line is automatically written-off (or accepted if over-processed).

Installation

Database Changes

The primary control for a variable stock order line is a flag on the sales/purchase order detail record. However, where a stock item is generally shipped in a variable manner you can create this flag on the stock record and copy to the order detail.

To restructure a database select Installation from the main menu followed by Application Manager and then Restructure A Database. Select the required application, Stock Control or Sales/Purchase Order Processing, and choose to update the live files. If creating a default flag for the Stock record choose Stock File, if creating the control flag on the order detail select the Sales / Purchase Order Detail File. Once the current data items within the file are listed use the <Page-Down> and <Down-Arrow> keys until reach a blank field and then press <Enter> to add a new item.

Item Name Type Description

VARIABLE-STK ? Flag to allow automatic write-off of any balance on the order line.


Enter the item name within the first input and select the ‘?’ item type in the second. Once you have returned to the item list press <ESC> and select the UPDATE button to update the database changes.When prompted confirm that you wish to extract data to the new database structure and, if appropriate, that table descriptions are to be transferred.

Once updated you will be prompted to ‘Remove the Old Database’ – respond as required and also prompted if you wish to update the BASE file with the same change. Base Files are used when you create a new company – if you wish to update the base files respond affirmatively and make the same change as above taking care to keep the same data item name/number as on the live file.

Once the changes to one database are complete make the same change to any of the other databases as required.

Set Database Profiles

The new flag item needs to be referenced within the Database Profiles for the Order Processing application. In addition if setting the flag on the stock record you will need to define a copy item from the stock file to the order detail.

To update the Database Profiles select Installation from the main menu followed by Application Manager and then Set Database Profiles. Select the required Order Processing application and, if Sales Order Processing move down to the parameter screen Detail Optional 6 (if POP select Detail Optional 1).


Press <Enter> or use the mouse to select the input for ‘Variable Stock Item’ on the left of the screen and then press <F4-Select> to pick up the item number of new variable stock item you have just created.

If setting the flag on a stock item and copying to the order detail you need to also select one of the STK to DET parameter screens to configure the copy item. Here the values are entered on the left of the screen in matching pairs so you need to select the Variable-Stk flag on both the stock file and the order detail file - <F4-Select> is available if required.

Application Screen Layouts

Changes are required to the order detail entry procedures to allow display / update of the variable stock flag plus, if setting a default on the stock record, the stock maintenance screens.

To update the order entry screens select Installation from the main menu followed by Application Manager and then Application User Facilities. Select the required Order Processing application followed by Enter/Amend Orders and Maintain Order Details.


Position the cursor using the mouse where you require the text label for the variable stock input and then type the required text. If you make an error move back and (making sure the INSERT status is off) either overtype with text or space characters. If the existing characters shift to the right press the INSERT key to switch to OVERTYPE mode and continue.

To insert the data item position the cursor where required using the mouse and then press <F4-Select>. Move down to the new Variable Stock flag on the list of items and press <Enter> to select and update the item on to the screen. You are then prompted whether the item is view-only, set for upper case input (recommended) and whether input is mandatory – respond as required.

Once complete choose File from the toolbar and then Save and Exit. When prompted for the selective order detail screens press <ESC> to return to the menu.

You may be using an alternative order entry method to the full-screen design input by using either fast input / detail pick entry or using the ‘system-designed’ full screen order entry. To update these entry procedures select Advanced Input Facilities from the current menu and then select Additional Order Detail Items to be Input


The items on the left allow you to select up to twelve additional items for input on the ‘system designed’ order detail entry screen, the first eight of which can also be activated within the fast input / detail pick entry mode. Move down to a blank item and then press <F4-Select> and choose the new Variable Stock item to add to the list, if using fast input style entry make a note of the position in the ‘Extra Ask’ list and then press the SAVE button to complete this entry screen.

To update the fast input / detail pick entry process to include the variable stock item select Fast Input Features from the current menu.


To include the Variable Stock flag set the ‘tick box’ of the Extra Item that added previously.

Note when entering order details in this manner items are prompted across the screen and, depending on screen resolution, font settings and item sizes, items from the end of the list may be omitted. If the required variable stock item is not displayed you may have to omit other items earlier in the list or look to ‘truncate’ the display (but not the input) of the description input.

To update the Stock Maintenance screens, if required, <ESC> back to the Application Manager menu and then reselect Application User Facilities, the Stock application, Maintain Stock and then Add New Stock Record. The general stock maintenance screen is then displayed and be updated to include the variable stock flag as per the general screen design processes discussed earlier.

Document Design Manager

Document parameter settings are required both to allow write-off procedures on delivery / invoice documents and to process the variable flagged order lines automatically.

To update the document parameters select Installation from the main menu followed by Application Manager and then Document Design Manager. Select the required Order Processing application and then select the required document category. Once the available documents are listed enter the document number required and press <Enter> to display the document mask.

The Write Off parameters are set on screen 1 of the Document Parameters which can be accessed by selecting the Parameters option from the toolbar.


Allow Adjustments to ‘Inv’ Qty & Write Off – set to allow write-off / over-delivery functionality (required for variable stock handling).

W/Off Var-Stk – set to automatically write off under delivery / invoice of order lines flagged for variable stock (or auto-accept over delivery / invoice)

If Write-Off then Ask at Each Detail Line – set to prompt to write-off/over-delver against each detail line where appropriate (required for variable stock handling).

Default Back Order – set whether to default, on non-variable order lines, whether the default is to leave the balance of an order line on back order or to write-off the balance.

Default to back-order if delivery was back order – applicable for invoice documents layouts set, for non-variable order lines, the invoice to default to back-order or write-off based on the response selected on the delivery note.

Once complete press the OK button to return to the document mask and then select from the File menu the Save and Exit options to leave the current document design and then repeat for the other documents as required.


Custom Fields

Article ID: 151
Created On: Mon, Jun 11, 2012 at 3:08 PM
Last Updated On: Wed, Jun 14, 2023 at 5:35 PM

Online URL: https://kb.datafile.co.uk/article/automatic-write-off-of-variable-stock-151.html