Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Page Tree Search
rootPageF1 help

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 Receipt LCT screen receives imported stock into SYSPRO and DATASCOPE WMS by processing LCT receipts.

When the Receipt LCT module in DATASCOPE WMS processes and allocates LCT receipts, it is done in SYSPRO and WMS.

Therefore, an LCT must always be created in SYSPRO before the receipt.

Info

The creation and maintenance of the LCTs will continue as usual in SYSPRO.

  Once the final costing’s have

For more information, please refer to the SYSPRO user guides.

The Shipping Clerk will typically update the Actual Arrival Date field in SYSPRO for a particular shipment once the final costing has been received and completed in

SYSPRO, the shipping clerk would insert the “Actual Arrival Date” of a particular shipment into

SYSPRO.

  As soon as

Once this is

inserted

done, the shipment will be available

to

for receipt

through

by DATASCOPE WMS.

The

shipping clerk

Shipping Clerk would send the invoices to the

receiving clerk with the advice

Receiving Clerk, advising that the LCT is ready to

receipt.The receipting clerk would then receive the physical shipment into

be received at the receiving warehouse.

  Once the goods have been

The goods will be opened, manually checked, and sorted into batches of similar products,

the receipting clerk would

whereafter the Receiving Clerk will open the shipment in

WMS

this screen.

  • Enter the Shipment Reference number in the field or use the lookup icon to search for the number.

  • Select the Refresh button to load the data grid.

  • The entire shipment would display on the screen

,
  • as it is already in SYSPRO

, and the receipting clerk
  • .

  • The Receiving Clerk would start to build up pallets of different stock codes

.  The “Allocated Qty”
  • .

  • Pallets can be edited, changed, added to while the shipment is still unposted.If an existing pallet must be edited, it can be selected from the TrackID number browse button.

  • The Allocated Qty field shows what stock codes have been built onto pallets

and the “Unallocated Qty”
  • (TrackID).

  • The Unallocated Qty field shows what is still to be built on a pallet

.  Only
  • (TrackID).

Info

Only system-generated

pallet

TrackID numbers can be used for this process.

At
  • In 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,
    • right-hand corner you will find the following buttons:

      • Import LCT - if selected the entire LCT will be imported.

      • Print Variance Rep - if selected a Variance Report will print. The Variance Report can be printed at any time during the pallet build-up.

      • Allocate All - if selected, you will have the option to allocate all stock codes to a TrackID.

      • TrackID Allocation - if selected 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. This is to allocate the different quantities per stock code to different tracking IDs within the WMS. Here you tell the WMS how many quantities of that stock code are on each pallet. 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.
      • Update Receipt Totals - this button will refresh all the lines on the LCT by pulling the details from SYSPRO, and refresh the pallet build-ups already done.

    • 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 (TrackID) 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
    • Once completed, select Finalize.

    • The LCT shipment will be receipted into SYSPRO and DATASCOPE WMS and unique

    bar coded
    • barcoded labels will print out for

    every
    • each pallet that has been built up. (the DATASCOPE_TRACKID_MASTER_LETTER.rpt must be configured in the system settings)

    • The stock will be received

    into
    • in the default marshaling bin for the receiving warehouse.

      Pallets
    • Pallets (TrackIDs) will

    then
    • be

    bin transferred
    • transfers out of the

    receiving warehouse
    • 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.

    Page Tree Search
    rootPageF1 help

    SPECIAL FEATURES

    • This receipting program will allow for multiple stock items on a single pallet.

    • This module will not allow the user to input their own lot numbers and post to SYSPRO.

    • Variance controls can be configured.

    • There are four different options o process LCT receipts in DATASCOPE PREMIUM WMS. For a detail overview, refer to the Online User Guide.

    TECHNICAL

    • Relevant Settings

     Please review the settings help for a list of relevant settings
     
    SYSPRO Requirements

    • The Variance Report must print to a pre-defined A4/Letter printer.

    • Ensure the Variance Report .rpt template (DATASCOPE_LCT_VRIANCE_LETTER.rpt) has been configured for this screen. This is the standard Variance Report template. From the Ribbon Bar, browse to Settings / System Settings and locate the LCT System Name. Add the .rpt template to the Setting Name LCT_VARIANCE_REPORT.

    • The correct TrackID .rpt template (DATASCOPE_TRACKID_MASTER_LETTER.rpt) must be configured for this screen. From the Ribbon Bar, browse to Settings / System Settings and locate the LCT System Name. Add the .rpt template to the Setting Name BARRELLABEL.

    • The screen allows a user to do a ASN (Advanced Shipping Notice) import from the LCT Import button. Note that a plugin must first be configured prior to using the Import function. For more information, speak to a DATASCOPE Solution Provider (DSP)

    SYSPRO REQUIREMENTS & Business objects used

    •  Work with the Purchase Order

    LCT System
  • DATASCOPE Table updates

  • tblPallet

  • tblPalletItem

  • tblPalletAction

  • tblReceiving

  • tblPalletItemDetail
    • LTC system.

    REFERENCE

    REC020