4Site
Support Request System
View Patch #50.035.018
Description
Patch ID:
Date Implemented:
Patch Title:
Patch Type:
Request IDs:
Bug
Enhancement
Other
02834 -
Add requisition information to Delivery Ticket
Symptoms:
If extra fields for RFQ# and PR# can be indicated on the header of the delivery ticket, the following results can be achieved; a. MAXIMUM WAREHOUSE SPACE UTILIZATION FOR MORE INVENTORIES i. We can push out all those “direct charge” items sitting on the warehouse floor to RFQ End user immediately. ii. We can notify those RFQ initiators via email or phone to pick up the DC items right away as we complete receiving. iii. More space is available for extra shelves or inventories b. IMPROVEMENT IN EFFICIENCY i. Instead of losing tracks of who picked up and what, we can be in a control seat and managing both DC and stock items. ii. This will allow us to focus on other tasks with much improved efficiencies. iii. People will not come into warehouse office and ask us if the product arrived or not, which obviously interrupts the flow of work
Solution:
1. Create temporary table (prdata_tmp) to store the fields required by the request (poid, prid, personid, proriginator). 2. In VB code create a query to select required data and insert it into the prdata_tmp table. 3. Modify the Crystal report file (DelTick.rpt) -Add the new prdata_tmp table joined on prdata_tmp.poid = rct.poid -Add 2 text fields and corresponding data fields to page header (PR/RFQ#: and PROriginator:)
Browse Patches
Find a Patch
Return to Request System Menu
