Skip to main content

ExFlow Vendor statement

Purpose

The purpose of the product is to automate the process of checking a statement from a vendor for a period against transactions in D365FO and to make sure that the vendor and customer agree on which trade has occurred during the period.

Prerequisites for Vendor statement

  • Requires ExFlow version 2.15.2 or later.
  • A subscription to a Marketplace offer must be set up to be able to use the Vendor statement.
  • Activation and onboarding.
  • Import method for vendor statements from ExFlow data capture.
  • Data Capture team from Signup Software setup profile for import of Vendor statements.
  • Vendor statement parameter configuration.

Subscription from Marketplace

A subscription to a Marketplace offer must be set up to be able to use the Vendor statement.
The Vendor statement functionality is included in the ExFlow module. You subscribe to the solution via Microsoft Marketplace and can choose the plan that best suits your needs.

medium

Steps for the activation and Initiate onboarding

ExFlow AP | Setup | General parameters | Tab; Vendor statement

  1. Navigate to Exflow AP - Setup - General parameters - tab Vendor statement.
  2. Select Initiate, done when you get info message that parameters are initialized.

medium

medium

  1. New menu exit “ExFlow core”
    The ExFlow Core menu is used to handle the subscription. (This is where you sign up and pay for the new functionality via Microsoft Marketplace).
  • Navigate to ExFlow core - Common – Subscriptions.
  • Mark Vendor statements and in the General Menu in the action pane, select "Onboarding", then another popup displays on the right side.
  • Select Azure Marketplace and make sure that you follow all the steps, and that the subscription is set to onboarded = Yes. See image 4 below.

medium

medium

Graphical user interface, text, application, email Description automatically generated

Graphical user interface, text, application, email Description automatically generated

  1. Enable Vendor statements
    ExFlow | Setup | General parameters | Tab; Feature management
  • Navigate to General parameters - tab feature management.
  • Set Vendor statement = Yes.
  • Enable Vendor statement, after activation a new menu exit for “ExFlow common” will be visible.

small

  1. The ExFlow Common menu is used to the Vendor statement functionality.

small

Setup import method for Vendor statement

To use ExFlow Data Capture for scanning and verifying the incoming statements, you need to;

  1. Inform Signup Data Capture team to add a separate profile for Vendor statements.
  2. Setup the Import method in ExFlow for Vendor statement by choosing the Import document type “Vendor statement”, with a specific XSLT provided from Signup.

See more information in the document platform of how-to setup different methods.
URL: https://docs.exflow.cloud/finance-operations/docs/user-manual/import-methods/import-methods-overview

ExFlow | Setup | Import methods

Graphical user interface, text, application, email Description automatically generated

  1. Setup batch jobs for the created import method.
    ExFlow Common | Periodic tasks | Vendor statement
  • Import vendor statement XML files (Multiple methods).
  • Import vendor statement from history.

small

Set old transactions as “Fully reconciled”

ExFlow Common | Inquiries and reports | Vendor document status

The “Vendor document status” form shows transactions from the data source for vendor and payments. The users can manually set the older transactions as “set as fully reconciled” or “set as not reconciled”.

Graphical user interface, text, application, email Description automatically generated

ButtonDescription
Set as fully reconciliedSet the selected vendor transactions and payments for the specific period as fully reconciled, transactions will then not come up in the reconciliation form as open transactions to match against.
Set as not fully reconciliedSet the selected vendor transactions and payments for the specific period as NOT fully reconciled, transactions will come up in the reconciliation form as open transactions to match against.

Short demo of the product