SPECIAL FEATURES
TECHNICAL
SYSPRO REQUIREMENTS & Business objects used
REFERENCE
REC020
FUNCTIONALITY OVERVIEW
Imported stock will be receipted into both SYSPRO and WMS by using the PC-based Receipt Landed Cost Tracking in WMS.
STANDARD PROCESS
The creation and maintenance of the LCTs will continue as usual in SYSPRO.
Once the final costing’s have been received and completed in SYSPRO, the shipping clerk would insert the “Actual Arrival Date” of a particular shipment into SYSPRO. As soon as this is inserted, the shipment will be available to receipt through WMS.
The shipping clerk would send the invoices to the receiving clerk with the advice that the LCT is ready to receipt.
The receipting clerk would then receive the physical shipment into the receiving warehouse. Once the goods have been opened, manually checked and sorted into batches of similar products, the receipting clerk would open the shipment in WMS.
The entire shipment would display on the screen, as it is in SYSPRO, and the receipting clerk would start to build up pallets of different stock codes. The “Allocated Qty” field shows what stock codes have been built onto pallets and the “Unallocated Qty” field shows what is still to be built on a pallet. Only system-generated pallet numbers can be used for this process.
At the top of the LCT screen, the “Print Variance Report” button will print the Variance Report as detailed below.
The “Update Receipt Totals” button will refresh all the lines on the LCT by pulling the details from SYSPRO, and refresh the pallet build-ups already done.
Once the “Multi-stock Tracking ID” button is clicked, a “floating window” will appear on top of the existing screen. Within this screen, the purchase order and stock code need to be selected and the quantity entered. On clicking “Add”, the detail will populate in the bottom grid. When the first pallet is created, click the “Save” button.
Pallets will continue to be built. Pallets can be edited, changed, added to while the shipment is still un-posted. If an existing pallet needs to be edited, it can be selected from the Tracking ID Number browse button.
Once a stock code line has been completely satisfied, the line will show a green tick icon in the Status column. Once all lines have a green tick, the “Finalize” button at the bottom of the main screen will be activated. On clicking the “Finalize” button, the entire LCT shipment will be processed in SYSPRO and the system-generated pallet numbers will be generated.
The receipting clerk would work through the entire shipment, jumping between stock codes and lines as required. As the physical pallets are being packed in the receiving area, so those pallets will be built up within the LCT.
At any time in the pallet build-up process, a Variance Report can be printed to a pre-defined A4 printer.
The receipt can only be finalized once every stock code is allocated onto a pallet and there are no lines on the variance report.
On clicking Finalize, the LCT shipment will be receipted into SYSPRO and WMS and unique bar coded labels will print out for every pallet that has been built up. The stock will be received into the default marshaling bin for the receiving warehouse. Pallets will then be bin transferred out of the receiving warehouse and bin receipted into other warehouses by processing a Bin to Bin transfer on the scanners.
SPECIAL FEATURES
This receipting program will allow for multiple stock items on a single pallet.
This program will not allow the user to input their own lot numbers and post to SYSPRO.
Variance control
There are a number of variances that could arise during the LCT process, and can be dealt with as follows:
Scenario A:
Stock is physically over supplied against invoices provided by supplier. In this case, the stock items that are over supplied must be separated from the shipment and physically placed in a separate bin in the receiving warehouse. A handwritten notification will be sent to the shipping clerk advising of this oversupply. A subsequent LCT will be created and receipted for such items, as usual. Should the stock be supplied without an additional invoice, an inventory receipt transaction would need to be processed in WMS (which updated SYSPRO immediately).
SCENARIO B:
Stock is physically under supplied or over supplied against invoices provided by supplier. In this case, the receipting department processed the actual receipted quantities into WMS and then prints the standard LCT Variance Report. This report is used by the costing department to amend the SYSPRO LCT shipment to match the actual receipt. Once in balance the receipting department will post the receipt. Damaged stock is received. This stock will be treated the same as under supplied stock in the previous point above. The pallets containing the damaged stock can be transferred to the returns warehouse using Bin to Bin on the scanners.
TECHNICAL
Relevant Settings
Please review the settings help for a list of relevant settings
SYSPRO Requirements & Business objects used
Purchase Order LCT System
DATASCOPE Table updates
tblPallet
tblPalletItem
tblPalletAction
tblReceiving
tblPalletItemDetail