1. Home
  2. /
  3. V7.9 Documentation
  4. /
  5. IP1 Product Documentation
  6. /
  7. User Guides
  8. /
  9. PSM/PSI
  10. /
  11. PSI

PSI

Features and functions

  • Concise information regarding titles recorded purchase, sales and inventory quantities, as well as cost details for particular sales periods.
  • Details are presented in a spreadsheet format, enabling you to view seven months at a time or 12 months depending on the format selected.
  • Sales price and budget information. Actual transactions can be compared to budget details.
  • A facility to set-up different PSI types.
  • Provision to link warehouses to PSI types and classifies warehouses as saleable and/or inventory only.
  • Facility to generate suggested orders interactively or in batch.
  • Facility to export PSI data to a PC.
  • Inquiry screen of PSI summary by title or category showing sales, GP, and performance against budget.
  • Ability to generate suggested orders for components of a system.
  • Ability to define sales allocation, including rebates and discounts, by customer classification. This allows the user to produce more accurate sales data from PSI.
  • Provision to set-up a separate exchange rate table for PSI independent of the company exchange rates for various ‘what if’ analysis.
  • The PSI system is able to identify Systems/Packs from normal titles. During generation of the purchase order, the Pack/System is broken down into its components.
  • Systems and Packs can have components with zero price percentages.
  • A facility is provided to record the preferred date on which stock is to be delivered into the warehouse. TMSDS/PSI-RDC control file defines the preferred stock receipt day within a monthly period. The purchase order generation program calculates the ETA date for the purchase orders based on this receipt day code and the supplier’s lead time. In the case of Packs/Systems where the components may have different lead times, the PSI system uses the greatest lead time to calculate the ETA date.
  • A stock ratio can be defined by individual title or title hierarchy and have it defaulted in PSI. The Stock Ratio Maintenance function, which resides on the PSI module, allows for the definition of the stock ratio by title hierarchy. This ratio is used as the default value in the PSI Maintenance program when generating the suggested order. Multiple stock ratios can be defined for each level, with the help of effective ‘from’ and ‘to’ expiry dates. Stock ratio records can be maintained and inquired into at all times.
  • Formulas are provided to calculate inventory ratio, these are average sales method and reducing method.
    1. Average sales.
    2. Reducing method.
    3. Safety stock holding policy.
  • Purchase orders can be automatically created from the generated suggested order PSI quantities either interactively or in batch.
  • No Purchase orders are raised on stopped/closed titles.
  • Purchase orders or suggested orders are not generated where the title has passed the ceased date.
  • Automatically creates PSI records from Outstanding Orders – this is based on projected, current and real demand rather than historical information by including items with back-orders, forward orders and reservation quantities.
  • Flexibility in retrieving the buying price of a title, ability to specify whether to pick up from the Title Masterfile or the Buying Price file.
  • Access to various inquiries and reports.

Process flow

To start the process of using PSI certain Control files need to be setup.

Various Database files need to be setup.

  • Buying Price file
  • Landing Charges
  • Shipping Parameters
  • Exchange rate definition
  • or Exchange rate definition within Distribution Database
  • Selling Prices
  • User Allocation
  • Sales Allocation
  • Stock levels
  • Stock Ratio
  • The Screen Writer
  • Budgets and Forecasts

With all the relevant Control files and reference data such as buying price, landing charges, sales allocation etc. set-up, the user will be able to start using the PSI by:

  1. Entering data directly in the PSI screen.
  2. Copying data from an external source such as a PC sales Spreadsheet into the ‘S’ of the PSI or
  3. Generating initial PSI data from previous sales or order demand data.

    • To generate initial PSI data from previous sales data the following will need to be done.

      1. Define forecast parameters using DSM295.
      2. Generate forecast data from Sales data using DSO140.
      3. Transfer forecast data to PSI using DSO356.

    • To generate initial PSI data from order demand data the following will need to be done.

      1. Update the order demand file by running SA010. Normally this program is already part of the EOD process.
      2. Transfer the order demand to a forecast ID using program DSO358.
      3. Transfer forecast data to PSI using DSO356.
  4. PSI production files from Suppliers. The data can be imported from different formats including CSV, comma delimitated, fix length etc.
  5. Generating records from the Outstanding Orders. This is based on projected, current and real demand rather than historical information by including items with back-orders, forward orders and reservation quantities.
  6. Budget data is displayed in the PSI Maintenance for reference. This data can be generated as described. 

Finally we arrive at the PSI maintenance, with all the previous steps set up, it should now be an excellent tool to work with.  All the information is at your finger tips.

  1. Flag the titles to be reviewed. Example: Ready to Order, Request Costing, Request and general meeting etc.
  2. Generate suggested orders and review them as many times as required before creating the final purchase order.
  3. Print the Order Indication Report, to review.
  4. Finally generate the purchase orders.

Work with PSI

PSI changes by product

PSI suggested order generation

Print Friendly, PDF & Email