Auto PO FT
Auto FT is use to raise Store Indents for the Flow through items, and also generate the Auto PO
Configuration Process:
Step 1:
Need to follow the below steps:
First, we should need to create the MBQ from the Master Excel,
MBQ will be defined location wise for the Sku’s which are FT
User Can define MBQ for multi locations at one go with max no of rows 4000
Step 2:
Flow Through:
Next Flow through should be enabled for the particular Sku code which will be done only in Warehouse location, either while creating the sku code or through excel upload option provided in Master Excel module
Flow Through Excel Format as below
Note: Max of 4000 rows will be accepted in excel upload
Step 3:
Case Quantity:
Now we need to link the case qty and percentage for the SKU code which Sku will be purchased based on Case quantity
Case quantity will be defined either while creating New sku code or through Excel upload Module which is available in master excel Module
Below is the format for Case Quantity
| Location Name (*50) | Sku Code (*15) | Case Qty (*99999.99) | Case Percentage (*99999.99) |
|---|---|---|---|
| HYDERABAD | 10001 | 36 | 50 |
| HYDERABAD | 10002 | 60 | 70 |
| HYDERABAD | 10003 | 24 | 60 |
| HYDERABAD | 10004 | 12 | 80 |
Step 4:
Vendor Order Schedule:
User Need to configure the Vendor Order Schedule in the Provided Module of VENDOR ORDER SCHEDULE
Vendor Order Schedule Module is available in the under Transactional Excel Module
Click on Vendor Order Schedule and it will guide you to the below screen
Click on Generate XL option which will generate the format of Vendor order schedule Excel and will be downloaded in the Download folder of the local system
Below is the format of Vendor Order Schedule
On defining all the four steps Process now Auto PO FT can be generated
Auto PO FT
User will allow to select single, Multiple or all locations in Select Stores Option.
Once the stores selected the user will click on Load Indent Data Based on the Vendor Schedule Data will be loaded in the grid.
Based on the MBQ at store level and available QOH indent will be generated location wise in the above shown grid.
Once the Indent is generated on selection of View WH Data the indent quantity will be consolidated and loaded in the Grid as shown below
And here the logic of PO on Order quantity, WH QOH, Case quantity with Fulfillment will be considered
On selectin of Generate WH PO, PO will be generated and mail will be dropped to Vendor based on the defined mail id in Vendor master
Export CSV: Export to CSV option is provided to user to download the loaded data in the grid for both loaded indent and PO
