Import Suppliers (30.1.2)
  • 12 Mar 2024
  • 13 Minutes to read
  • Dark
    Light
  • PDF

Import Suppliers (30.1.2)

  • Dark
    Light
  • PDF

Article summary

Business Process Overview

The supplier management process within Florida PALM involves multiple steps and interfaces to ensure accurate and compliant supplier records. MyFloridaMarketPlace (MFMP) and agency business systems provide supplier data files to Florida PALM, requiring review and approval by DFS AP Supplier Approvers for all sources except MFMP. The inbound Supplier Load file processes new suppliers and updates from external systems, with error handling for records that fail validation. Updates to supplier payment methods and banking information are managed in the "Manage Supplier Payment Method and Banks" subprocess. Employee records from the Human Capital Management (HCM) application are systematically converted to supplier records for non-payroll payments. Various interfaces handle W-9 updates, TIN matching, and payment validations before supplier records are fully approved. Approved supplier records are ready for use, with outbound files generated for enterprise and agency systems. Interfaces also manage retiree supplier records, ensuring data accuracy and validation through edit checks and error handling processes. The DFS AP Supplier Processor or AP Retiree Supplier Processor oversees the creation or update of supplier records, ensuring completeness and accuracy. The Supplier Detail report provides visibility into supplier records for review and management purposes throughout the process.

Business Process Diagram

Business Process Diagram for 30.1.2 Import Suppliers (part 1)

Business Process Diagram for 30.1.2 Import FRS Suppliers (part2)

Business Roles

The Business Process Flow Diagrams use horizontal swim lanes to depict where activities are performed by different parties or systems. Each swim lane is titled with a role, either agency-based or within DFS, and in some cases, are representative of an external entity or system. The swim lanes may change from page to page within a single business subprocess as more or fewer roles are required to execute sections of the business subprocess. 

  • DFS AP Supplier Approver: DFS role responsible for maintaining the supplier record in Florida PALM, to include reviewing and approving supplier registrations and change requests and monitoring and updating supplier records, as needed
  • AP Retiree Supplier ProccessorFRS role responsible for managing retiree supplier records

Business Process Flows Details

The tables below describe steps in each business subprocess as reflected on the Business Process Flow Diagrams. The tables also reflect information associated with each step describing the intent of the specific process. Florida PALM screenshots are included within the sections to allow connections to be made from specific business subprocess steps to screens within Florida PALM. This information should be read in conjunction with the Business Process Flow Diagrams. This information should be read in conjunction with the Business Process Flow Diagrams.

Process Step ID

Process Step Title

Description of Process

1

Inbound Supplier Load (API015)

MyFloridaMarketPlace (MFMP) and agency business systems provide a data file of supplier records to Florida PALM. The new suppliers and updates to existing suppliers are submitted to Florida PALM unapproved and require review by the DFS AP Supplier Approver for all sources other than MFMP. The source system must coordinate notification to the supplier to update the W-9 System.

 

The inbound Supplier Load file is interfaced into Florida PALM with data for new suppliers and supplier updates from various external systems.

 

Any supplier records that error during the load process are included on the interface error log and must be corrected in the source system and submitted to Florida PALM again within the next interface file submission for creation of, or update to, a supplier record within Florida PALM.

 

The process for making updates to the supplier Payment Method and banking information on the supplier record is found in the Manage Supplier Payment Method and Banks business subprocess.


2

Inbound Employee Load (API022)

Employee records setup in the Human Capital Management (HCM) application within Florida PALM that need to be set up as a supplier record for payment, are systematically sent over to the AP module and set up as supplier records using the Inbound Employee Load interface. The employee records are managed and maintained within HCM and are updated in the AP module via HCM integration and custom interface logic. Employee supplier records are created in the AP module with a Classification of ‘Employee’.

 

The employee supplier records are leveraged for non-payroll related payments to employees such as reimbursements for travel via the Statewide Travel Management System (STMS) or reimbursements other than travel. 


3

Inbound W-9 System Update (API016)

The Inbound W-9 System Update interface sends the TIN Match Status, TIN Match Date and Business Designation to Florida PALM to be captured within the supplier record.


4

Perform Interface Error Checking

Edit validations are performed on each interface before the data is allowed to load to the Accounts Payable staging tables. If file is rejected, all transactions in the file are rejected and the file must be resubmitted once issue is resolved.

 

If file is not rejected, edit validations are performed on each transaction before the data is allowed to load for processing in the Accounts Payable module. Additional edits will be performed during the transaction life cycle.


Rejected transactions are managed through the 120.1 Interface Error Handling Process.


Edit Validations include:


  • ChartField Validation
  • ChartField Combination Edits
  • Amount Validation
  • Open Period Validation
  • Supplier Validation
  • The edit check process includes the Budgetary Value combination edit check, which checks Fund, BE, & Cat combinations for a BU, the transaction will fail if this combination is inaccurate.


In addition, there are interface specific edits that pertain to AP data elements and fields.


5

Review Supplier Record

The new supplier records and updates to existing supplier records that are unapproved are reviewed by the DFS AP Supplier Approver to make sure all required fields are populated and all supplier requirements are met. If more information is needed, the DFS AP Supplier Approver works with the submitting agency or new/existing supplier to gather the necessary information.


6

Deny Supplier/Update

If the updated supplier information does not meet the requirements to be included within the supplier record, the DFS AP Supplier Approver denies the new supplier record or the existing supplier update.


7

Notify Agency/Supplier

The DFS AP Supplier Approver notifies the submitting agency or the new/existing supplier of the denial of the new supplier record or the existing supplier record update.


8

Approve Supplier/Update

Once all required information has been added to the supplier record, the final review and approval of the supplier record is completed by the DFS AP Supplier Approver.


9

Establish/Update Supplier Records

The successfully loaded supplier records either establish a supplier record in Florida PALM, or the supplier record is updated.

 

All suppliers must be TIN matched before they are ready for use within Florida PALM. All supplier records interfaced into Florida PALM are validated against the data submitted within the API016 Inbound W-9 Updates interface to obtain the TIN Match Status, TIN Match Date and Business Designation.

 

Suppliers that have not yet been prenoted are defaulted to be paid by System Check (warrant). If a supplier payment method is set to ACH/EFT, the Process Payments business process initiates the prenote validation. All suppliers will receive payment by System Check until prenote validation is complete.

 

Supplier records that are fully approved are identified as payees with a unique system-generated Supplier ID and are ready for use within Florida PALM. 

 

The Supplier Detail and AP Holds by Hold Type reports are available for review. 


10

Outbound Supplier Data (API020)

The Outbound Supplier Data interface file is generated by Florida PALM to send to enterprise systems and agency business systems containing a list of all added and updated supplier information.


11

Outbound Employee Extract (API059)

The Outbound Employee Extract file is generated by Florida PALM to send to enterprise systems and agency business systems containing a list of all added and updated employee information for use in the AP module.


12

Inbound DOR Supplier Levy Flag (API026)

The Inbound DOR Supplier Levy Flag interface contains a list of payees/suppliers that have a DOR levy.

 

The logic within the API026 Inbound DOR Supplier Levy Flag interface searches for matches of supplier records in Florida PALM against the DOR Levy database records submitted within the interface. Any supplier record matches either marks each supplier record with a DOR Levy flag and a global Payment Hold to prevent payments from being issued to the supplier or removes the DOR Levy flag and global Payment Hold per the instructions from DOR within the interface file. The supplier flags are reviewed and monitored by DFS.

 

Any Vouchers for suppliers that have a DOR Levy flag are routed through Voucher Workflow for auditor review.

13

Monitor Supplier Records

The DFS AP Supplier Approver monitors reports and the newly added and/or updated supplier records within Florida PALM to determine if any action is necessary. If the supplier record needs to be updated, the update is performed within the Add and Update Suppliers Online business subprocess.

 

The Supplier Detail, Minority Suppliers, 1099 Mismatch, Employee Suppliers, Duplicate Suppliers, AP Holds by Hold Type reports are available for review.


15

Inbound Retiree Supplier Load (API127)

Integrated Retirement Information System (IRIS) sends an Inbound Retiree Supplier File that contains retiree records and related financial institution information to Florida PALM to create supplier records within the FRS01 SetID.


16

Perform Interface Error Checking

Edit validations are performed on each interface before the data is allowed to load to the Accounts Payable staging tables. If file is rejected, all transactions in the file are rejected and the file must be resubmitted once issue is resolved.

 

If file is not rejected, edit validations are performed on each transaction before the data is allowed to load for processing in the Accounts Payable module. Additional edits will be performed during the transaction life cycle.


Rejected transactions are managed through the 120.1 Interface Error Handling Process.


Edit Validations include:


  • ChartField Validation
  • ChartField Combination Edits
  • Amount Validation
  • Open Period Validation
  • Supplier Validation
  • The edit check process includes the Budgetary Value combination edit check, which checks Fund, BE, & Cat combinations for a Business Unit, the transaction will fail if this combination is inaccurate.


In addition, there are interface specific edits that pertain to AP data elements and fields.


17

Check AP Employee Supplier Records

If there is not sufficient data within the API127 Inbound Retiree Supplier Load file to create a supplier record, the SSN of the retiree will be checked against the AP Employee Supplier records to determine if there is a match. If there is a match, a new supplier record is established using the AP Employee Supplier record information, if there is not a match, the record is sent to the error log. More information needs to be gathered by FRS and provided within the next run of the API127 Inbound Retiree Supplier Load interface to create a supplier record for the related SSN.


18

Establish/Update Retiree Supplier Record

The successfully loaded supplier records either establish a supplier record in Florida PALM, or the supplier record is updated.


Suppliers that have not yet been prenoted are defaulted to be paid by System Check (Warrant). If a supplier payment method is set to ACH/EFT, the Process Payments business process initiates the prenote validation. All suppliers will receive payment by System Check until prenote validation is complete.


Supplier records that are fully approved are identified as payees with a unique system-generated Supplier ID and are ready for use within Florida PALM.


If the Payment Method listed within the API127 Inbound Retiree Supplier Load interface is ACH/EFT, the banking information must get validated through the prenote process within the Process Pay Cycle business subprocess.


19

Update Retiree Supplier Record

Once the banking information has been validated or rejected within the Process Pay Cycle business subprocess, the supplier record is updated with the appropriate prenote status.


20

Outbound FRS Retiree Information (API038)

Florida PALM sends the Outbound FRS Retiree Information file, which includes all newly added and updated supplier information, such as Florida PALM Supplier ID, address, banking and prenote validation data for retiree supplier records, to IRIS..


21

Identify Need for Supplier Add/Update

The DFS AP Supplier Processor or AP Retiree Supplier Processor determines a need to establish a new supplier record or edit an existing supplier record in the FRS01 SetID.


22

Search Supplier Records

The DFS AP Supplier Approver or the AP Retiree Supplier Processor queries Florida PALM to confirm the supplier does not already exist, when entering a new supplier record, or finding the existing Supplier record if information needs to be updated. Florida PALM allows the ability to search by Supplier ID, Supplier Name, and Short Supplier Name. The Review Supplier screen is available for searching by Supplier TIN, or other available fields from the supplier profile.

 

The Supplier Detail report is available for review.


23

Enter/Update Retiree Supplier

The DFS AP Supplier Approver or AP Retiree Supplier Processor enters information to create or update the supplier record as appropriate.

Accounting Events

Accounting events originate during transaction processing in the applicable source module. The accounting events impact the source module, Commitment Control ledgers, and the General ledger (Actuals).

  • Source Module accounting entries require user input (I) of the primary line (i.e., expenditure, revenues) with an automated (A) system offsetting line (i.e., payable, receivable) during transaction entry. The source model transaction must pass Edit Check, Budget Check, and Cash Check (on applicable entries) prior to posting the transaction.
  • The Run Budget Check (Commitment Control) process automatically affects balances in the appropriate budget ledger (i.e., appropriation, spendable cash) if the transaction passes the budget check process.
  • After the transaction is posted in the source module, an automated system process summarizes and posts the entries in the General Ledger module to the Actuals Ledger.

The table below provides the most common accounting events applicable to this business process.

Acct Event ID 

Accounting Event

Commitment Control Ledger(s) Impact

Source Module Accounting Entry

General Ledger (Actuals) Entry

N/A





Reports

Key Reports are displayed as icons with the Report Number on this Business Process. The table below provides the reports identified to be produced at a particular process step or is used to support the completion of a process step.

Report Number

Report RICEFW ID

Report Description

Report Source

Report Frequency

Audience

R1

APR068

Supplier Detail Report – a report that lists suppliers by name, TIN, or other identifying information

Data Warehouse

Periodic

Agency, DFS

R2

APR069

Duplicate Suppliers Report – a report to identify potential duplicate supplier records, or related suppliers

Data Warehouse

Periodic

Agency, DFS

R3

APR113

Minority Suppliers Report – a report that lists minority suppliers

Data Warehouse

Periodic

Agency, DFS

R4

APR046

1099 Mismatch Report – 1099 Mismatch Report that lists suppliers without business designation and have vouchers with 1099 reportable object code

Data Warehouse

Periodic

Agency, DFS

R5

APR047

Employee Suppliers Report – lists employees doing business with the State as a supplier.

Data Warehouse

Periodic

Agency, DFS

R6

APR091

AP Holds by Hold Type – lists vouchers and payments marked for payment hold including the hold reason

PeopleSoft

Periodic

Agency, DFS

Note: A complete list of reports may be found in the Reports Catalog.

Interfaces

The table below provides the Interfaces identified on the Business Process.

Interface Number

Interface Description

Interface Frequency

Source

Target

API015

Inbound Supplier Load – Inbound interface containing new and modified suppliers from various external systems.

Daily

FRS, MFMP

Florida PALM

API016

Inbound W-9 System Updates – Inbound interface containing supplier W-9 status information.

Daily

W-9 System

Florida PALM

API020

Outbound Supplier Data  Outbound interface containing a list of all added and updated suppliers in Florida PALM.

Daily

Florida PALM

Enterprise Systems and Agency Business Systems

API026Inbound DOR Supplier Levy Flag - Inbound interface containing a list of suppliers who have a levy against them by DOR.DailyDOR
Florida PALM

API022

Inbound Employee Load – Inbound interface containing employee information to load employee data profiles in Florida PALM.

Daily

Human Capital Management (HCM), Florida PALM

Accounts Payable (AP), Florida PALM

API038

Outbound FRS Retiree Information – Outbound interface containing retiree information to include prenote status, to FRS.Daily, Weekly, MonthlyFlorida PALMIRIS

API059

Outbound Employee Extract – Outbound interface of employee information for use by enterprise systems and agency business systems.
Daily
Florida PALM
Enterprise Systems and Agency Business Systems

API127

Inbound Retiree Supplier Load - Inbound Interface containing retiree banking information for prenote and payment purposes.

Daily, Weekly, Monthly

IRIS

Florida PALM

Note: A complete list of interfaces may be found in the Interface Catalog.

Forms

The table below provides the forms identified on this Business Process.

Form Number

Form Description

Audience

N/A



Workflows

The table below provides the workflows identified on this Business Process.

Workflow Number

Workflow Description

Audience

N/A



Version History

Date

Revision Description

02/01/2024

Original Version

02/13/2024Clarified all integration points of supplier information and defined FRS process
Attachments

Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.