Stock Allocations

QUOTATION - LOG: #10650, #10788

When generating and listing the store requirements, the requirement for an item is the total required to bring it up to it’s maximum. This figure is used to generate transfers from a central warehouse if central warehouse delivery and distribution is used. When (re)calculating this requirement, it must therefore ignore what is already on purchase order (otherwise the quantity to be distributed from the central warehouse would be wrong). However to ensure the correct quantity is ordered from a supplier, the quantity already on PO is subtracted from the total requirement.

The current “List Requirements” report shows the Qty on PO and the Total Requirement. for each stock item/location.

We will modify this report to provide an extra column titled “Qty to Order” which will be Total Requirement – Qty on PO. Note that this change will not apply to items that have “size runs” (We do not believe Allphones currently have any items with size runs). Design, Development, testing and installation $250+GST

We will also modify the “List Requirements” report to allow users to filter by an allocation batch number and by an employee code. Design, Development, testing and installation $250+GST

We will provide an option to "ignore current purchase orders" when Generating Purchase Orders Design, Development, testing and installation $400+GST


Aegis # 10826

Stock allocations will be modified so that if you manually do Add/Alter Allocations, you will be prompted to put in a batch code.

This code, as well as the employee that is current logged in, will be recorded with the allocation. The batch code and employee will be the one from the last modification to that particular stock item.

Eg Employee A modifies item Z with a batch code of 1. Later, Employee B modifies items Z and uses a batch code of 2. Now, item Z is recorded as having a batch code of 2, and an employee code of B.

We will provide the options to filter by employee code and batch number when generating the purchase orders.

We will also provide a menu option that will allow you to specify if you want suggested purchase orders or regular purchase orders generated. Once the purchase order is generated, the allocation, batch number and employee code will all be reset.

Also, we will provide an option that will allow you to clear allocations by batch number and employee, without having to generate a purchase order. All matching items will have their allocations reset to 0.

Task

Time Required (hrs)

Adding/Maintaining Allocation Batch No & Employee code on stock record

5

Adding option to allow deletion of allocation by Batch No/Employee

3

Adding menu option to allow generation of regular or suggested PO's

1

Quote/Documentation

1

Total

10


Allocations (last edited 2013-09-18 06:09:33 by localhost)