Purchase Orders > Setup > Supplier Stock Code Cross Reference

Supplier Stock Code Cross Reference

You use this program to maintain a cross-reference between a SYSPRO stock code and a supplier catalogue number (supplier stock code).

When you purchase a non-stocked item from a supplier, the system automatically creates an entry for the non-stocked item in the supplier/stock code interchange file if the Supplier/stock code interchange system option is enabled (Inventory Setup). This enables you to print and reprint details of these purchases on purchase order documents.

Toolbar and menu

Field Description
New Select this icon to add a new supplier/stock code cross reference.
Delete Select this icon to delete the supplier/stock code cross reference currently displayed.
Save Select this to save the details you entered or changed.
Supplier

Indicate the supplier for whom you want to create a cross-reference to a SYSPRO stock item.

If the entered supplier is not the primary supplier defined against the stock item (Stock Codes) then you can add the supplier as an alternate supplier.

Stock code

Specify a valid SYSPRO stock code that you want to link to the supplier's stock code.

A non-stocked cross reference can be maintained here only if the item was receipted in on a purchase order. In addition, for non-stocked cross references, you will be unable to access the U/m fields, and the Purchase order qty u/m field is not applicable.

This stock code cannot be defined as a Notional part (Stock Codes).

Cross-reference Select this to use the Browse on Supplier Stock Code Cross Ref program to view supplier/stock code cross-references.

This option is not enabled when you access the Supplier Stock Code Cross Reference program from the Browse on Supplier Stock Code Cross Ref program.

Supplier/Stock Code Xref Maintenance

Field Description
Supplier This indicates the supplier code for which you are adding or changing the cross-reference details.
Supplier name This indicates the name for the supplier code displayed in the previous field.
Stock code This indicates the SYSPRO stock code for which you are maintaining the cross-reference.
Stock description This indicates the description for the SYSPRO stock code.
Long description This indicates the long description for the SYSPRO stock code.
Currency This displays the currency defined against the supplier.
Catalogue Indicate the supplier's stock code for the SYSPRO stock item entered.

The supplier's code must be entered in this field if you want to be able to use the supplier's code instead of the SYSPRO stock code when processing purchase orders.

Demonstrated lead time

Indicate the average number of days it takes to receive the stock item from the supplier.

This field is used for documentary purposes only and is not updated by the actual lead time.

You can use the AP Contract Price List program to compare the supplier's demonstrated lead time with the quoted lead time.

Last price paid

Indicate the last price that was paid to the supplier for the stock item.

The value entered here must be in the currency of the supplier.

This field is updated automatically when purchase order receipts are entered for goods received from the supplier and the option: Receipts by supplier/stock code is enabled (Purchase Orders Setup).

[Note]

For a foreign currency supplier, this will always be the original foreign price as raised when the order line was created.

Last price u/m This indicates the unit of measure for the last price paid.
Date of last receipt

Indicate the date when you last purchased the item from the supplier.

You can only access this field if you are adding a cross-reference for the first time.

This field is updated automatically when purchase order receipts are entered for goods received from the supplier and the option: Receipts by supplier/stock code is enabled (Purchase Orders Setup).

Qty last received

Indicate the quantity of the item last purchased from the supplier.

You can only access this field if you are adding a cross-reference for the first time.

This field is updated automatically when purchase order receipts are entered for goods received from the supplier and the option: Receipts by supplier/stock code is enabled (Purchase Orders Setup).

Purchase order qty uom

Indicate the unit of measure in which the stock item is purchased from the supplier.

This field is updated automatically when purchase order receipts are entered for goods received from the supplier and you selected the option: Receipts by supplier/stock code is enabled (Purchase Orders Setup).

LCT merchandise price The price entered here is used to calculate the expected merchandise cost in the Landed Cost Tracking module. This price must be in the currency of the primary supplier of the stock code.
LCT merchandise uom This indicates the unit of measure for the LCT merchandise price.
Default price for purchase order review Indicate the default price to be used for the stock item in the Purchase Order Review program.
Default price uom

Indicate the unit of measure applicable to your entry at the Default price for purchase order review field.

The unit of measure entered here must be in the stocking/alternate unit of measure, or must exist in the Purchasing Price Unit of measure or Order Unit of measure table (see Price Unit of Measure).

The Default price u/m defaults to the unit of measure against the Last price u/m field.

This field is enabled only if the Requirements Planning module is installed.

Supplier's stock description Enter the supplier's stock description (i.e. the catalogue description).
Supplier's long description Enter a long description for the item to be purchased.
Alternate supplier price

This indicates the alternate price you want to print on purchase order documents for your local currency suppliers.

If no alternate price is defined here then the purchase price held against the purchase order line is printed.

[Note]

This field is enabled only if you enabled the option: Use alternate document price (Purchase Orders Setup).

In addition, to actually print the alternate price on purchase order documents you must enable the preference: Use alternate supplier price (Purchase Order Format - Preferences).

The price entered here is used only for printing on purchase order documents and does not affect the cost at which the purchase order is receipted.

Alternate supplier prices can only be printed on purchase order documents if the purchase order is for a local currency supplier.

Supplier's P/ord notes  
Notes Select this to use the Admin Notepad Editor (Monospaced Text) program to add free format text to assign to any purchase of the stock item from the supplier.

Notes and warnings

Prerequisites

  • You must enable the Supplier/stock code interchange system option (Inventory Setup) before you define your supplier stock codes in this program.

    Any supplier/stock code details defined before you select the Supplier/stock code interchange system required option are not saved.

Coding considerations

  • You must create a link between the supplier and a valid SYSPRO stock code before you can import the supplier's stock code using the Import Supplier Contract Prices program.

Automation considerations

  • The complete supplier key length (even if the presentation length is less than the full 15 characters) must be supplied when running this program using Automation or using the Ctrl+R (Run a Program) function.

    For example, when using the Run a Program function, and you want to maintain the cross references for Supplier 0000001 and Stock code A101, you would enter:

    PORPS2 000000000000001A101 in the Program to run field.

    Failing to do this results in a message stating that the supplier is not on file being displayed.

eSignature considerations

Electronic Signatures provide security access, transaction logging and event triggering. This enables you to increase control over your system changes.

Access to the following eSignature transactions within this program can be restricted at Operator, Group, Role or Company level. You configure this using the eSignature Setup program.

eSignature Transaction Description
PO Add supplier/stock code cross information

Controls access to the Add and New Cross-Reference functions in the Browse on Supplier Stock Code Cross Ref and Supplier Stock Code Cross Reference programs.

PO Change supplier/stock code cross information

Controls access to the maintenance of cross-references in the Browse on Supplier Stock Code Cross Ref and Supplier Stock Code Cross Reference programs.

PO Delete supplier/stock code cross information

Controls access to the Delete function in the Browse on Supplier Stock Code Cross Ref and Supplier Stock Code Cross Reference programs.

Inserting Application Help

You would typically follow this procedure to display help for the current program in a customized pane that can be pinned to the program window.

Information includes step-by-step instructions for the various functions available within the program, including a brief overview of what the program does, what setup options are required and how to personalize the program.

  1. Open the program for which you want to insert application help into a customized pane.

    This functionality is only available for a program that has panes.

  2. Right-click any form field.

    You can also click the triangle menu icon that appears in the title area of a pane.

  3. Select Insert Application Help from the context-sensitive menu.

    The application help appears in a pane within your program. You can reposition the pane using the docking stickers or pin it to the program window.

Removing the Application Help pane

If you no longer want to display application help in a pane for your current program, you can simply remove it.

  1. Select the Close icon in the right-hand corner of the application help pane.

  2. Confirm that you want to delete the pane.