ProPartners Integration

An integration with ProPartners is a custom feature Agvance customers can use to connect to a third-party financing network to manage customer A/R balances. The retailer will facilitate the loan with the grower. The financial network originates the loans with growers. The Agvance user then pulls these loans into Agvance via the Loan API. Agvance users can access grower’s loan amounts to pay outstanding A/R balances. When an outstanding A/R balance is applied to these loans, Agvance sends a Draw to ProPartners via the API. The originating bank then remits the money to the retailer for payment of the customer’s balance and increases the loan balance on the customer. This financial network is managed by an originating bank, ProPartners Financial. 

Setup

  1. Set up API integration with ProPartners.
    1. Go to Hub / Utilities / Custom Features / Financing / Setup.
    2. Check the box to Use Financing API.
    3. Enter the Company ID provided by ProPartners.
    4. Optionally select to Require booking start and expiration dates.
    5. Select the Default Price Level.
    6. Choose Save.
  2. Create a new Cross Reference to identify customers participating in the ProPartners Integration.
    1. Go to Hub / Setup / Company Preferences and select the Customer tab. Cross Reference
    2. In the Cross Reference section, enter a name for the Cross Reference to designate customers using the ProPartners Integration.
    3. Select Save.
  3. Optionally create a new Cross Reference to identify products used for specific loan purposes.
    Note: This is for informational purposes only to pull product reports based on loan purpose. Agvance does not enforce loan purposes.
    1. Go to Hub / Setup / Company Preferences and select the Product tab. Product Cross Reference
    2. In the Product Cross References section, enter a name for the Product Cross Reference used to designated products for a specific loan purpose.
    3. Select Save.
  4. Establish a Customer ID Cross Reference to identify customers with their ProPartners Party ID.
    1. Go to Hub / File / Open / Customers.
    2. Edit the customer and enter the ProPartners Party ID in the appropriate Customer ID Cross Reference field.
    3. Select Save.
  5. Optionally add Product Cross References on products being used for specific loan purposes.
    1. Go to Hub / File / Open / Products.
    2. Edit the Product and enter the Product Cross Reference ID Code.
    3. Select Save.
  6. Establish a Pay Method.
    1. Go to Accounting / Setup / A/R / Pay Methods.
    2. Choose Add Row.
    3. Enter a Pay Method to identify payments that will be made via the ProPartners Integration. Select the appropriate G/L for each Location for posting purposes.
    4. Select OK.

Import Loans

  1. Get new loan balances and import daily loan balances via the GET Loans API endpoint.
    1. Go to Hub / Utilities / Custom Features / Financing / Import Loans.
    2. Select Import.
    3. Choose the appropriate Customer Xref from the drop-down.
    4. To utilize the automatic loan assignment, select Assign Loans on the Loans screen. This process will automatically assign new loans to customers in Agvance that have an established Cross Reference matching a Party ID.
      • Print or save the report for reference of loans that were auto assigned. Select OK.
  2. To manually assign loans, select the loan information from the Loans grid.
  3. Double-click the <Customer ID> in the Customers grid to search for the appropriate customer.
  4. Optionally sort the Loans grid by selecting column headings. Filter by Agvance Status and Crop Year.

Take Payments

  1. Use financed funds to pay Invoices and Bookings via the POST Draw API endpoint.
    1. Go to Hub / Utilities / Custom Features / Financing / Take Payments.
    2. Select the loan information from the Create Finance Payments window.
    3. To complete the draw process to pay open Invoices, select the POA option and choose Post.
  2. To complete the draw process to create generic prepaid Bookings, add the Booking Amount
    1. Select the Booking checkbox and the appropriate Booking Classification.
    2. Select Post.
      Note: Optionally take a payment on the save of an Invoice in A/R via the Receive Payment on Account window. Agvance follows and enforces the payment guidelines established by ProPartners. More details are available through ProPartners.

Edit Loans

To access the Loans screen or complete additional loan assignments without importing new loans, go to Hub / Utilities / Custom Features / Financing / Edit Loans.

Reports

Go to Hub / Utilities / Custom Features / Financing / Reports.

  • Unpaid Draw Report – This report provides information regarding the draws made for a specific date.
  • Transaction Detail Report – This report provides grower information regarding purchases paid for by the loan and can be run across fiscal years.
  • Automatic Loan Assignment Report – This report provides a list of loans that were linked.
    Note: This report is only available on the Import Loans screen immediately following the selection of Assign Loans.

Grower360 Functionality

  1. Growers who have a loan financed through ProPartners can see basic Loan Balance information on the Overview screen in Grower360.
  2. On the Loan Balance card(s), select View to be redirected to the ProPartners website to see additional details regarding the loan(s) and make payments.