Home » Categories » Multiple Categories

Create New Back Order Lines

Datafile Software

Create New Back Order Lines

When processing Delivery Notes (or Goods Received Notes in POP) there are times when the full outstanding delivery cannot be processed – you have insufficient stock available for delivery, or you have not yet received the full shipment – and you can decide (subject to document configuration) whether to write off the remainder or leave on back order.

This new option allows, if the outstanding delivery quantity is left on back order, the system to create a new order line for the back-ordered quantity and reduce the order quantity on the original line to that delivered. This allows for greater clarity on invoice documents when produce one invoice covering multiple deliveries and improves traceability on later enquiries.

The back-order detail line is created at the end of the existing order and is identical to the original order line except for the quantity items (were the order qty is updated to the back-order qty, and the delivered/invoiced quantities are all zero). The original order line is updated with a reduced order quantity equal to that actually delivered (see note below)

During Delivery Note production the operator will notice no differences from standard write-off/back-order processing.On update of the order files new order lines will be created for any lines actually processed (non-zero action quantity) but with a quantity left on back-order. If you amend the order afterwards then the system will warn if amend the detail for which the back order was created and not allow changes although an <F7-Option> override is available.


 Note

 If the order has already been invoiced then the new back-order line is created for the difference between the order quantity and the higher of the delivered or invoiced quantities. For example, if order 10 of an item, invoice 7 and then deliver 5 the current line is updated with an order quantity of 7 and the new detail is created for 3 items.

 Multiple Order Documents

 This feature is not applicable if using multiple order delivery notes.

 Installation

For this new feature changes are required to the order detail database, database profiles, application user facilities and, possibly if not already using write-off facilities, the delivery document design.

Restructure a Database

A new data item is required on the sales / purchase order detail database to hold the ‘pre back-order order qty’. This data is not mandatory but this is the item checked when ‘protecting’ an order line from being amended once a delivery has been made and a back-order line created.

File Item Name Type Description

SOD/POD QTY-PRE-B/O K, L, M Holds the original order quantity value prior to the new back-order line creation (and the subsequent reduction in the order qty).

Set Database Profiles

The new data item needs to be referenced within the Datafile Database Profiles for S.O.P. and P.O.P as required. The parameter screen ‘Detail Optional 5’ allows reference of an ‘original order quantity’ which is updated on back-order line creation.


Application User Facilities

The parameter to allow the creation of back order details is set within the Optional Features parameter screen(s). Screen 3 asks for the new parameter.


Create Back-Order Details – set to allow creation of back order details when delivery note action quantity is less than the outstanding delivery quantity and you choose to leave the balance on back order.

Document Parameters

This change, only applying to back orders on delivery note documents, relies on the write-off parameters being enabled within the document design. Parameter Screen 1 contains the write-off parameters.

Allow Adjustments to ‘Inv’ Qty and Write Off – set to allow write-off and back order facilities.

If Write-Off then ask at each detail line - set to allow prompting on each detail whether to leave on back order.

Default back order – set whether default is to write-off (leave blank) or to remain on back-order.

Custom Fields
  • Release ID: 6.1
Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Part Processing Deposit Lines (SOP only)
Viewed 1839 times since Wed, Jun 13, 2012
Select via Stock Code and Negative Quantities
Viewed 1335 times since Tue, Jun 12, 2012
Additional Options for Quick Form Processing
Viewed 1605 times since Fri, Jun 8, 2012
Select Assembly for BOM Works Order Generation (SOP Only)
Viewed 1442 times since Mon, Jun 11, 2012
Default Stock Location
Viewed 1330 times since Fri, Oct 26, 2012
Order Entry - Column 1/2 Inputs as View-Only
Viewed 2173 times since Fri, Oct 26, 2012
Prevent Changes to Order Header if Complete
Viewed 1273 times since Fri, Oct 26, 2012
Document Parameters
Viewed 1833 times since Wed, Jul 4, 2012
Order Entry / Document Accumulation Items
Viewed 1285 times since Wed, Jun 13, 2012
Flag User-ID, Date and Time to Order Detail on Document Production
Viewed 1927 times since Wed, Jun 13, 2012