Reports and Transaction Runs

Users with the Community Administrator, View Transactions or Create Invoices role can run a one-time report of community data and review, in a CSV file format.

Reports older than 18 months will be removed from Unimarket.

To add a new standard template, please contact Unimarket Support (support@unimarket.com) to request desired template.

 

Create One-Time Reports

You can watch this short video or read instruction below on how to run a report:

 

To create one-time reports, go to the Insights module > click Reports > select Run Report > a pop-up box will appear.

The Email Address field will automatically default to users email address. This is where an email notification will be sent when the report is ready. If desired, the user can change the email address.

In the Report Type field, select the desired report. For report type and details, refer to the list below. 

Choose the desired date/time range in the From Date and To Date field (the default is set to one month) > click Create.

 

Once selected, the user will receive a successful alert at the top of the screen.

 

Access One-Time Reports

You can watch this short video or read instruction below about how to access a report:

 

To access new or past (no older than 18 months) reports, go to the Insights module > click Reports > located the desired listed report(s) > select Actions > once in Completed state, click Download, for the Excel CSV file.

 

View Existing One-Time Reports

To view existing new or past (no older than 18 months), go to the Insights module > select Reports > click the Reports tab.

View the report listing or utilize the State, Report Type and/or Period fields to customize search.

 

Report Types

Report Type templates define the format and content of the report. Templates can be added to the community from

• a list of standard Unimarket templates or
• there may be custom templates defined and added to the community, as part of the delivery process.

Current Report Type templates information. For additional details, refer to help article Report Types Overview.

Standard Templates	Description
Unimarket Commitments	Provides an overview of commitments.
Unimarket Goods Received Not Invoiced	Lists order items created in the specified date range that have been received but do not have a matched invoice.
Unimarket GRNI Accruals Reconciliation	Goods Received Not Invoiced optimized for accruals reconciliation. Selects orders that were received between From Date and To Date.
Unimarket Invoices - All	Lists all invoices created in the specified date range.
Unimarket Invoices - Matched	Lists matched invoices created in the specified date range.
Unimarket Order Report	Lists orders created in the specified date range. For additional information, refer to help article Understanding the Order Report.
Unimarket Receiving report	Lists all buyer receiving that occurred in the specified date range.
Unimarket Requisition Items in Progress	Lists requisition line items created in the specified date range that are still awaiting approval.
Unimarket Requisitions In Progress	Lists requisitions created in the specified date range that have at least one item still awaiting approval.
Unimarket Blanket Order Report	Lists blanket orders with valid from dates in the specified date range.
Unimarket Expenses	Lists expenses created in the specified date range.
Invoice Items Pending Receiving	Lists all invoice items within the specified date range that are still pending receiving along with the users responsible for receiving the linked order item.
Orders Created After Invoice	This report identifies orders raised after invoice date. It highlights spend for which pre-approval was not completed.
Time From Order to Fully Received	The purpose of this report is to allow analysis of receiving behavior against order lines. It measures the time from order line creation to receiving closed.
Unimarket Requisitions	A list of requisitions placed in the system. All states.
Unimarket Requisition Approval Statistics	Requisitions and their associated approval timelines.

 

Report Type templates defines the format and content of a report.

Templates can be added to the community from

• a list of standard Unimarket templates or
• there may be custom templates defined and added to the community, as part of the delivery process.

To add a new standard template please contact Unimarket Support (support@unimarket.com) to request desired template.

If your community desires a customer report templates, please contact your Unimarket Customer Success Manager.

The available standard templates and brief description are listed below. 

 

Invoice Items Pending Receiving

The Invoice Items Pending Receiving report lists all orders where the line items are Pending Receiving.

Columns on the report are: On Behalf Of, Order Number, Order Date, Order Type, Buyer Name, Supplier ID, Supplier Name, Invoice Number, Invoice Line Number, Amount, Currency, Invoice Created Date, Invoice Date, Creator, Supplier Created.

Sample report: Invoice Items Pending Receiving Example

 

Orders Created After Invoice

The Orders Created After Invoice report lists all Orders within the specified date where the Created date is greater than the Invoice date.

Columns on the report are: Order Number, Created Date, Retrofit Order, Invoice Number, Invoice Date, Calculation of Days Since Invoice Date, Invoice Subtotal, Buyer Name, and Supplier.

Sample report: Orders Created After Invoice Example

 

Unimarket Goods Received Not Invoiced (GRNI)

The Goods Received Not Invoiced report lists order line items created within the specified date range that have been received but do not have a matched invoice. It includes all order line items with the receiving has  been completed or closed. The report will exclude line items that have receiving open, were paid via Stripe or orders that are closed or cancelled. 

Columns on the report are: Supplier Vendor ID, Product Code, Product Name, Quantity, Received Quantity, Invoiced Quantity, Currency, Unit Price, Subtotal, Tax, Total, Account Code, Distribution Percentage, Distribution Amount, Receiving State.

Sample report: Unimarket Goods Received Not Invoiced Example

 

Time From Order to Fully Received

The Time From Order to Fully Received report lists all orders within the specified date range that have at least one line item fully received. This report excludes Line items that have partial or no receiving. 

Columns on the report are: Order Number, Order Created Date, Order Line Number, Order Line Quantity, Receiving State, Received Quantity, Receipting Date, Calculation of Receipting Days, Unit Price, Subtotal, Tax, Total, Buyer Name, Supplier.

Sample report: Time From Order to Fully Received Example

 

Unimarket Blanket Order Report

The Unimarket Blanket Order report lists blanket orders with valid from dates in the specified date range.

Columns on the report are: Blanket Order Number, Change of Order Number, Blanket Order Description, Details, Buyer, Supplier, Supplier ID, Org Unit, Valid From Date, Valid to Date, State, Value, Funds Available, Funds Allocated, Currency, Account Code, Financial Year, Blanket Requisition Number, Available To.

Sample report: Unimarket Blanket Order Report Example

 

Unimarket Expenses

The Unimarket Expenses report lists all expense claims loaded in Unimarket within the specified dates.

Columns on the report are: Expense Number, Buyer VendorId, Buyer Name, Buyer Username, OBO VendorId, OBO Name, OBO Username, Category, Claim Number, Claim Name, Created, Date, Description, Expense Type, Payment Type, Payment Type ExternalId, Reimbursement Type, Reimbursement Type ExternalId, State, Supplier, Supplier ExternalId, Amount, Account Code, Distribution Percentage, Distribution Amount. 

Sample report: Unimarket Expenses Example

 

Unimarket GRNI Accruals Reconciliation

The Unimarket GRNI Accruals Reconciliation report is a Goods Received Not Invoiced report optimized for accruals reconciliation. This report lists orders that were received within the specified date range, it includes all line items that have been received but do not have a matched invoice. 

Columns on the report are: Order Number, Order Date, Supplier Name, Supplier Vendor ID, Order Line Number, Order Line Description, Order Line Quantity, Received Not Invoiced Quantity, Received Not Invoiced Total.

Sample report: Unimarket GRNI Accruals Reconciliation Example

 

Unimarket Invoices - All

The Unimarket Invoice - All report lists all Invoices within the specified date range. The report is grouped by Invoice Line Item and Account Code. All invoices loaded into Unimarket are included on this report.

Columns on the report are: Invoice Number, Line Number, Order Number, Created, Invoice Date, Matched Date, Creator Username, Creator Name, Supplier Created, State, Order Type, Supplier, Supplier Vendor ID, Product Code, Description, Category Code, Category Name, Quantity, Currency, Unit Price, Subtotal, Tax, Total, Serial Numbers, Account Code, Distribution Percentage, Distribution Amount, Receiving State, Buyer Username, Buyer Name, On Behalf Of, Order Variance Approved, Order Variance Username, Order Variance Date, Receiving Variance Force Matched, Receiving Variance Username, Receiving Variance Date.

Sample report: Unimarket Invoices All Example

 

Unimarket Requisition Approval Statistics

The Unimarket Requisition Approval Statistics report lists all requisitions within the specified date range excluding requisitions that are Incomplete or Abandoned.

Columns on the report are: Requisition Number, Line, Requester, Buyer, OBO, Outcome, Approver ,Task Created ,Task Completed, Total Time (Hours), Approver Decision, Approve / Decline Reason.

Sample report: Unimarket Requisition Approval Statistics Example

 

Unimarket Invoices - Matched

The Unimarket Invoices - Matched report includes invoices where the State is Invoice Accepted or Downloaded within the specified date range. This report will exclude invoices in any other State. 

Columns on the report are: Product Code, Description, Category Code, Category Name, Quantity, Currency, Unit Price, Subtotal, Tax, Total, Serial Numbers, Account Code, Distribution Percentage, Distribution Amount, Receiving State, Buyer Username, Buyer Name, On Behalf Of, Order Variance Approved, Order Variance Username, Order Variance Date, Receiving Variance Force Matched, Receiving Variance Username, Receiving Variance Date. 

Sample report: Unimarket Invoices-Matched Example

 

Unimarket Order Report

The Unimarket Order Report lists orders within the specified date range excluding cancelled orders.

Columns on the report are: Order Number, Change of Order Number, Line Number, Requisition Number, Created, Order Date, Order Type, Payment Method, Is Retrofit, Blanket Order, Organization, Org Unit Code, Org Unit, Buyer Name, Buyer Username, On Behalf Of, Supplier, Supplier Vendor ID, Product Type, Product Code, Product Name, Category Code, Category Name, Quantity, Unit of Measure Name, Unit of Measure Code, Currency, Unit Price, Subtotal, Tax, Total, Distribution Percentage, Distribution Amount, Receiving State, Has Downloaded Invoice, AcctPart.

Sample report: Unimarket Order Report Example

For additional information about understanding the Unimarket Order Report, click here.

 

Unimarket Receiving Report

The Unimarket Receiving Report lists all receiving done within the specified date range. 

Columns on the report are: Receipt Date, Created Date, Receipt Number, Note, Action, Received Quantity, Received By Username, Received By Name, Receiving State, Total Received, Quantity, Total Invoiced Quantity, Outstanding Quantity, Order Number, Line Number, Order Type, Buyer Username, Buyer Name, Store Name, Store Vendor ID, Product Code, Product Name, Quantity, Currency Code, Unit Price ,Subtotal, Account Code Distribution Percentage, Distribution Amount.

Sample report: Unimarket Receiving Report Example

 

Unimarket Requisition Items in Progress

The Unimarket Requisition Items in Progress lists requisitions created in the specified date range with at least one line item awaiting approval.

Columns on the report are: Requisition Number, Description, Begin Approval Date, Type, Supplier, Buyer, On Behalf Of, Current Approver, Organization Unit, Account Code, Distribution Percentage, Distribution Amount, Currency, Unit Price, Quantity, Subtotal, Tax, Total.

Sample report: Unimarket Requisition Items In Progress Example

 

Unimarket Requisitions In Progress

The Unimarket Requisitions In Progress report lists all requisitions created within specified dates that are still in the approval process. This will exclude line items that have been approved.

Columns on the report are: Requisition Number, Description, Begin Approval Date, Type, Supplier, Buyer, On Behalf Of, Current Approver, Lines, Organization Unit, Currency, Subtotal, Shipping, Tax, Total.

Sample report: Unimarket Requisitions In Progress Example

  

Unimarket Requisitions Report

The Unimarket Requisitions Report lists all Requisitions created within the specified date range excluding requisitions that are Incomplete or Abandoned.

Columns on the report are: Requisition Number, Requisition Date, Supplier, Requisition Type, Requisition State, Requester, Buyer, OBO, Order Number, Order Submission, Org Unit, Created From Invoice, Order Receiving Contract Number, Blanket Amount Sent, Blanket Amount Hidden, Subtotal, Tax,Total, Justification Type, Justification, Approved Date, Cycle Time (Hours), No of Approvals.

Sample report: Unimarket Requisitions Report Example

 

Note: For information about running a report, refer to help article Reports.

The Unimarket Order Report is an insightful report to support organizations with spend analysis. The below summary is provided to assist understanding what the Order Types and Retrofit True (Y) or False (N) correlate to.

 

 

Blanket

This number reflects all newly created/approved blankets during the selected timeframe plus all approved blanket order changes--i.e. the changed blanket order’s created date is the date the change order was approved.

Retrofit Release

This number reflects all approved release orders that were initiated from an invoice that was entered against a blanket order and routed for acceptance by the Buyer.

Standard (Retrofit = N)

This number reflects all approved standard orders that were initiated from a Buyer.

Standard (Retrofit = Y)

This number reflects all orders created from the invoice initiating the process, or an approved standard order marked as retrofit (retrofit selection is possible against lite suppliers).

Standard Release (Retrofit = N)

This number reflects all approved release orders that were initiated from the Buyer or Available To User entering a standard requisition (not a retrofit), and charging it to the blanket order.

Standard Release (Retrofit = Y)

This number reflects all approved release orders that were initiated from the Buyer or Available To User entering a standard requisition and marking it as a retrofit, and charging it to the blanket order; or by an invoice posted against the blanket order.

 

Unimarket provides the ability to generate desired run reports, on a schedule. To extract data on a regular basis. 

Users with the Community Administrators or View Transactions role can create tailored report schedules.

Currently, the scheduled report feature is only available to run on a specific day at the moment. We have not (yet) provisioned the ability, to select a month-end or once a month type scheduling.

 

Watch this short video on how to create a scheduled report or continue reading below: 

 

Create a Scheduled Report

To create a scheduled report, go to the Insights module > select Schedules > click More Actions > select +Schedule Report.

 

The Schedule Report pop up will appear. For field details and descriptions, refer to the information below.

 

Schedule Name: The desired name for the scheduled report cycle.

Report Type: Choose the Report Type to run on a schedule.

Run Report Predefined Period - Select From Run Date if you want to customize how much data the report contains (e.g. 3 weeks back from the run date)

• Last Month - Uses predefined logic. On the first day of each month, it will generate for the previous month (e.g. September 1st will include all data from August 1st - August 31st)
• Last Quarter - Uses predefined logic. On the first day of each month, it will generate for the previous quarter (e.g. April 1st will include data from January 1st - March 31st). 
• Last 6 Months - Uses predefined logic. On the first day of each month, it will generate for the previous 6 months (e.g. August 1st will include all data from February 1st - July 31st). 

Run Report Duration - How much data to include in the report from the time it was run.

Run Report Period Type - Select Hour(s) 1 to 48, Day(s) 1 to 365, Week(s) 1 to 52, or Month(s) 1 to 12 as the period type.

Days - Select the day or days of the week to run report. This can be used in combination with Run Time to do something like "Every Monday & Wednesday at 8am"

Run Time - Select the time of day to run report. If you would like this report to run at multiple times during the day, you can press the + next to the drop down box to add additional times. 

Recipients - Once the report has run, an email notification will be send to the specified email address. To advise the report is now available. The report is not sent via email for size and security reasons.

Alternatively, an sFTP Endpoint can be chosen to securely submit the data to a folder location on the customer's side.

If you need to add or edit your Endpoint list, please contact Unimarket Support. 

Filename Template - The output file can have a specific naming convention to meet parameters, you may require. There is a default, using the naming convention and date of the report run.

You can update these parameters as below:

• ${scheduleName} - if you need to name the output file something different to your schedule name
• ${runDate(PATTERN)} - if you need an alternate date pattern, replace "PATTERN" with a date/time formatting.
  • MM-dd-yyyy_HH_mm_ss -> 06-01-2018_02_22_39
  • yyyy-MMM-dd-hhm -> 2018-Jun-01-0225

Example template:

ScheduledReport_${scheduleName}_Date-${runDate(YYYY-MM-dd_hh-mm-ss)} ->
ScheduledReport_ScheduleName_Date-18-06-16_02-46-19.csv

 

Once completed, select Add. To schedule another report, select Add More. 

 

View Existing Scheduled Report Details

To view existing scheduled report details, go to the Insights module > select Reports.

Click the Scheduled Reports tab. View the report listing or utilize the Schedules Report Name and/or Report Type fields, to customize search.

Select Actions > click View.

 

Once selected, the desired scheduled report details will provide specific details and the option to download the CSV file again. 

To download a previous specific scheduled report, select Actions > click Download.

 

Edit Existing Scheduled Report

To edit existing scheduled report, go to the Insights module > select Reports.

Click the Scheduled Reports tab. View the report listing or utilize the Schedules Report Name and/or Report Type fields, to customize search.

Select Actions > click Edit.

 

Once selected, a pop-up box will appear to make updates > select OK.

 

Delete Existing Scheduled Report

To delete an existing scheduled report, go to the Insights module > select Reports.

Click the Scheduled Reports tab. View the report listing or utilize the Schedules Report Name and/or Report Type fields, to customize search.

Select Actions > click Delete.

For simplified reporting, a user can use the Order Exports feature without requiring a specific role to access the Insights module.

Order Exports is a useful tool for cost center managers or buyers, to provide a view of applicable orders.

 

Watch this short video on how to Export Orders or read below for additional details: 

 

Order Export Run

To run an order export, go to the Marketplace > select Orders. 

If there is a specific set of data the user is seeking (e.g. date range, supplier), customize the report by selecting Filters.

Click Export > select Export Orders or Export Order Lines.

• Export Orders will provide the summary/header level detail of the orders 
• Export Order Lines will provide a line level breakdown of orders.

Note: Values used in exports, exclude GST & Shipping.

 

Once the desired option is selected, a pop-up box will appear > select the here hyperlink.

 

The Background Jobs screen will populate. Once the CSV file is in a Finished state, select Download. 

 

 

Type	Fields
Export Orders	Order Number, Change Of Order Number, Order Type, Payment Method, Payment Status, Retrofit Order, Created Date, Order Date, Order State, Receiving State, Has Accepted Invoice,  Requisition Number, Blanket Order, Blanket Balance, Organisation, Org Unit Code, Org Unit, Buyer ID, Buyer, Supplier ID, Supplier, Supplier Tags, Currency, Order Value, ShipTo, Bill To
Export Order Lines	OrderNumber, OrderType, PaymentMethod, PaymentStatus, RetrofitOrder, CreatedDate, OrderDate, OrderState, ReceivingState, HasAccepted Invoice, RequisitionNumber,   BlanketOrder,  BlanketBalance, Organisation, OrgUnitCode, OrgUnit, BuyerID, Buyer, SupplierID, Supplier,  SupplierTags, Currency, OrderValue, LineNumber, ProductSource,  CatalogueTags, ProductName, ProductCode, ProductTags, UnitPrice, Quantity, UnitOfMeasureName, UnitOfMeasureCode, ReceivedQuantity, InvoicedQuantity,  RceivedAmount, InvoicedAmount,  OrderLineAmount, SplitPercentage, AcctCodeFormat, AcctPart1, AcctPart2, AcctPart3, AcctPart4, AcctPart5

 

At times, communities may desire to view data regarding their current financial commitments.

A Financial Commitment export will provide a clear picture of the:

• Ordered
• Received 
• Invoiced (GRNI) quantities and
• Dollar amounts; of open (not fully received) order lines.

 

Run Financial Commitment Export

To run a financial commitment export, go to the Marketplace module > select Orders > in the Created Date field, select the "x" to clear field.

By doing so, this will ensure all open order lines are captured.

In the Buyer field, click the "x" to clear field > in the Views field, select Commitments > click Export > select Export Order Lines.

 

A pop-up box will appear > select the here hyperlink.

The Background Jobs screen will populate. Once the CSV file is in the Finished state, select Download.

 

Note: The Financial Commitments export can be scheduled in the Insights module.

A Transaction Run is used to allocate matched* invoices (or expenses) to a specific numbered Transaction Run.

When extracting invoice information to upload into an external system for payment. The transaction run ensures invoices:

• Cannot be picked up more than once (to prevent any being paid twice) and
• Will only pick up invoices that are not yet part of an existing transaction run.

Users with the Community Administrator or Create Invoices role have access:

• To create transaction runs and
• Review or download all transaction runs and their invoice information, at any time.

Matched - The state of an invoice that has matched the original order. For additional information refer to help article Viewing Invoices and/or Invoice Matching.

 

Create a Transaction Run

To create a transaction run, go to the Insights module > select Transaction Runs > click More Actions > select +Create Transaction Run.

 

A pop-up box will appear. For additional information about each field, refer to the information below.

 

Filename Template: Can be edited to suit the needs of the user. Allows a few variable terms to be used. This means the variable term entered is automatically replaced with the matching piece of data. Please see the examples below:

• ${runDate(PATTERN)} - Transaction Run generated date, replace "PATTERN" with a date/time formatting:
  • MM-dd-yyyy_HH_mm_ss - Will be replaced with 06-01-2018_02_22_39
  • yyyy-MMM-dd-hhm - Will be replaced with 2018-Jun-01-0225
• ${runNumber} - Will be replaced with the Transaction Run number
• ${randomNumber} - Will be replaced with a random number
• ${reportName} - Will be replaced with the Transaction Run Report name

Example:
Enter name as TransactionRun_${reportName}_Date-${runDate(YY-MM-dd_hh-m-s)}
Generated as TransactionRun_ReportName_Date-18-06-16_02-46-19.csv

For assistance setting up an sFTP endpoint for your transaction runs, contact your Customer Success Manager.

 

Date/Time Fields: Transaction runs can be created with or without a date range depending on your needs. Below are some helpful tips that will assist in determining desired customization: 

• By using a date range - if you specify a date range for the transaction run it will pick up invoices based on what option you select in the drop down list for 'Invoice Date Type' during the creation of the run.
• Created Date - if you select this option it will pick up invoices created (entered in Unimarket) within the date range you have chosen, i.e. if you create a transaction run for 1 June-30 June it will pick up all invoices created within that date range, as long as the invoices haven't already been allocated to a transaction run.
• Invoice Date - if you select this option it will pick up invoices with an invoice date within the date range you have chosen, i.e. if you create a transaction run for 1 June-30 June it will be pick up all invoices with an invoice date within that date range, as long as the invoices haven't already been allocated to a transaction run.
• Open (i.e. no date range) - if you choose not to select any date range and leave the date fields blank when creating the transaction run it will pick up all invoices based on what option you have selected in the drop down list (Created Date/Invoice Date).
• Hybrid - you can select either a start date or an end date depending on what information you are after:

Invoice related run options: For either of these, the system will then pick up any invoices not yet allocated to a transaction run.

• If you want all invoices from when you started using Unimarket until your 'year end date', leave the start date blank and enter the end date.
• If you want all invoices from a specific date and onwards until todays date, enter the start date and leave the end date empty.

Supplier Access: Select suppliers that are accessible by all customers in Unimarket (Public) or on internal use only suppliers (Internal). Leave blank to report on all.

Exclude or Include: (Exclude) The scheduled transaction run will contain records for all suppliers except for the one selected. This will be selected and blank by default. The Supplier field can be kept blank if you don't want to exclude any supplier. (Include) The scheduled transaction run will only contain records for the selected supplier. 

Supplier: Choose specific supplier or keep the field blank if you don't want to exclude any supplier. You may desire to utilize Exclude/Include options, if you have different file formats for one specific supplier.

Organizations: Select specific organizations to report on or leave blank to report on all.

Transaction Type: If your community uses more than one type of transaction you will need to select the type you wish to report on.

 

Once completed, select OK to create the transaction run > when the report is in a Processed state, select Actions > click Download.

Select View to review the transaction run details.

 

Scheduled Transaction Runs

Transaction runs may be scheduled on a calendar to run. Once configured, the scheduled transaction runs reports will reoccur automatically and save to a specific location.

To create a schedule a transaction run, go to the Insights module > select Transaction Runs > click More Actions > select +Schedule Transaction Run.

 

The Schedule Transaction Run pop-up box will appear. 

 

For additional information about each field, refer to the information below. Available fields shown are dependent upon of the Transaction Type selected.

 

Name: Insert the desired report name

Days: Select which days of the week you would like this to run on.

Run Time: Choose what time of day to run report. To add additional run times, select the plus icon. This allows it to be run more than once a day, without creating a separate scheduled run for each desired time.

Email Addresses: Where to send report notifications after generating the transaction run. The email will have a link directly to the current report.

Transaction Type: Choose

• Expense
• Invoice
• Order - Indicates Open, Closed, and Cancelled orders. That haven't yet been assigned to a transaction run. 
• Supplier - Indicates new suppliers, updated suppliers, and those that have disconnected from the community. That haven't yet been assigned to a transaction run. 

Note: Each order will only be sent once. So when the order is created, it will be included in a transaction run. If it is later cancelled, no update will be sent.

 

Exclude or Include: (Exclude) The scheduled transaction run will contain records for all suppliers except for the one selected. This will be selected and blank by default. The Supplier field can be kept blank if you don't want to exclude any supplier. (Include) The scheduled transaction run will only contain records for the selected supplier. 

Supplier: Choose specific supplier or keep the field blank if you don't want to exclude any supplier. You may desire to utilize Exclude/Include options, if you have different file formats for one specific supplier.

Organizations: Select specific organizations to report on or leave blank to report on all.

Filename Template: Can be edited to suit the needs of the user. Allows a few variable terms to be used. This means the variable term entered is automatically replaced with the matching piece of data. Please see the examples below:

• ${runDate(PATTERN)} - Transaction Run generated date, replace "PATTERN" with a date/time formatting:
  • MM-dd-yyyy_HH_mm_ss - Will be replaced with 06-01-2018_02_22_39
  • yyyy-MMM-dd-hhm - Will be replaced with 2018-Jun-01-0225
• ${runNumber} - Will be replaced with the Transaction Run number
• ${randomNumber} - Will be replaced with a random number
• ${reportName} - Will be replaced with the Transaction Run Report name

Example:
Enter name as TransactionRun_${reportName}_Date-${runDate(YY-MM-dd_hh-m-s)}
Generated as TransactionRun_ReportName_Date-18-06-16_02-46-19.csv

For assistance setting up an sFTP endpoint for your transaction runs, contact your Customer Success Manager.

Supplier Access: Select suppliers that are accessible by all customers in Unimarket (Public) or on internal use only suppliers (Internal). Leave blank to report on all.

Endpoint: Where to send the report after generating the transaction run. 

 

Dependent upon of the Transaction Type selected Add, Add More or +Edit Report Details.

If Add is selected, a confirmation alert box will appear at the top of the screen of the Schedules tab. 

If +Edit Report Details is selected > the Edit Report Details pop-up box will appear > select Add Report > click OK.

For additional information about the available fields, see list below.

 

Report: Choose from the available listed options

Filename Template: Refer to information above for defined field.

Endpoint: Where to send the report after generating the transaction run.

 

Once completed, select Add or Add More. A confirmation alert box will appear at the top of the screen of the Schedules tab. 

 

View Scheduled Transaction Runs

To view existing scheduled transaction runs, go to the Insights module > select Schedules > view the provided listing on the Schedules tab.

 

Copy, Edit or Delete Scheduled Transaction Runs

To copy, edit or delete scheduled transaction runs, go to the Insights module > select Transaction Runs.

Click Schedules tab > select Actions > click Copy, Edit or Delete.

 

Transaction Runs to an sFTP

When creating a Scheduled Transaction Run, these can be automatically sent to a dedicated sFTP.

The Transaction Run will be created and customized, as mentioned above and can be sent directly to the customer.

There is an option to Resend the transaction run for those set up to send via sFTP. 

To resend a sFTP transaction run, go to the Insights module > select Transaction Runs > click the Transaction Runs tab > locate the desired transaction run > select Actions > select Resend.

Note: If a manual Transaction Run is made between scheduled: The file will only pick up any new changes since the last run and Is only available for manual download (it is not separately sent via sFTP).

The Supplier Transaction Run provides community data for:

• New suppliers
• Updated suppliers and
• Those supplier who are disconnected.

Users with the Community Administrator or Create Invoices role have access:

• To create transaction runs and
• Review or download all transaction runs, at any time. 

The user can choose to run this report as:

• A one time query, as needed or
• Create a Supplier Transaction Run, to run data on a reoccurring basis. 

Each supplier transaction run report is stored when it was last run. A supplier record will also capture a date, when it was last updated. 

 

To Schedule a Supplier Transaction Run

To schedule a supplier transaction run, go to the Insights module > select Transactions Runs > click More Actions > select +Schedule Transaction Run.

 

A pop-up box will appear > in the Transaction Type, select Supplier.

For additional information about each field, refer to the information below.

 

Name: Insert the desired report name

Days: Select which days of the week you would like this to run on.

Run Time: Choose what time of day to run report. To add additional run times, select the plus icon. This allows it to be run more than once a day, without creating a separate scheduled run for each desired time.

Email Addresses: Where to send report notifications after generating the transaction run. The email will have a link directly to the current report.

Transaction Type:

• Supplier - Indicates new suppliers, updated suppliers, and those that have disconnected from the community. That haven't yet been assigned to a transaction run. 

Filename Template: Can be edited to suit the needs of the user. Allows a few variable terms to be used. This means the variable term entered is automatically replaced with the matching piece of data. Please see the examples below:

• ${runDate(PATTERN)} - Transaction Run generated date, replace "PATTERN" with a date/time formatting:
  • MM-dd-yyyy_HH_mm_ss - Will be replaced with 06-01-2018_02_22_39
  • yyyy-MMM-dd-hhm - Will be replaced with 2018-Jun-01-0225
• ${runNumber} - Will be replaced with the Transaction Run number
• ${randomNumber} - Will be replaced with a random number
• ${reportName} - Will be replaced with the Transaction Run Report name

Example:
Enter name as TransactionRun_${reportName}_Date-${runDate(YY-MM-dd_hh-m-s)}
Generated as TransactionRun_ReportName_Date-18-06-16_02-46-19.csv

For assistance setting up an sFTP endpoint for your transaction runs, contact your Customer Success Manager.

Endpoint: Where to send the report after generating the transaction run. 

 

Once completed, select Add. To schedule additional supplier transaction runs, click Add More. 

A confirmation alert box will appear at the top of the screen of the Schedules tab. 

 

View Existing Supplier Transaction Run Details

To view supplier transaction runs, go to the Insights module > select Transaction Runs.

Click Transaction Runs tab > in the Schedule field, select Supplier Transaction Run. To customize date range, choose available options in Created Date field or check Customize Dates box.

Select Search > click View.

 

Once selected, the desired scheduled report details will provide specific details.

 

Download Supplier Transaction Runs

To download supplier transaction runs to receive a CSV file, go to the Insights module > select Transaction Runs.

Click Transaction Runs tab > in the Schedule field, select Supplier Transaction Run. To customize date range, choose available options in Created Date field or check Customize Dates box.

Select Search > locate the desired supplier transaction run > click Actions > select Download.

 

Resend Supplier Transaction Runs

When creating a Scheduled Transaction Run, these can be automatically sent to a dedicated sFTP.

If sFTP was assigned at the time of creating the Supplier Transaction Run. The user can resend via sFTP by going to the Insights module > select Transaction Runs.

Click Transaction Runs tab > in the Schedule field, select Supplier Transaction Run. To customize date range, choose available options in Created Date field or check Customize Dates box.

Select Search > locate the desired supplier transaction run > click Actions > select Download.

 

 

What do the fields in this report mean?

Column	Column Heading	Description
A	Unimarket ID	The supplier UUID.
B	Supplier ID	Supplier ID.
C	Update Status	This can be Connected, Updated, or Disconnected.
D	Last Updated Date	The last time an update was made to the specific supplier.
E	Company or Trading Name	This will be optional if the supplier is an individual.
F	Supplier Type	This will be Lite, Registered, or Premium.
G	Profile Type	This will be either Company/Organization or Individual.
H	Supplier First Name	This will only populate if the supplier is registered as an individual.
I	Supplier Last Name	This will only populate if the supplier is registered as an individual.
J	Legal Business Name	This will be optional if the supplier is registered as an individual.
K	Business Number	This only populates for NZ customers. (Max character length is 255).
L	Tax Registered	This indicates if the supplier is Tax Registered with Yes/No.
M	Tax Identification Type	This only populates for US customers and is part of the W9 and will show as SSN or EIN.
N	Tax Number / ABN	This is optional if the supplier is not tax registered. (Max character length is 255).
O	Tax Rate	The Tax Rate itself, rather than the Tax Code (eg: NOTAX). If no Tax Rate has been defined at the Supplier level, we will retrieve the rate from Community level.
P	Currency	This shows the valid currency code. (Ex: USD for United States Dollars)
Q	Default Category	This shows the default UNSPSC code. (Max character length is 8).
R	Default Contract	This shows the Contract ID and helps support customers using contract information.
S	Supplier Tags	This shows a comma separated list of Tags.
T	Contact Person	This shows the suppliers default contact person - name.
U	Contact Phone	This shows the supplier's default person phone number.
V	Contact Email	This shows the suppliers default contact persons email.
W	Default Email	This shows the suppliers default contact email.
X	Invoicing Email	This shows the suppliers invoicing email.
Y	Order Email	This shows the suppliers order email.
Z	Remittance Email	This shows the suppliers remittance email.
AA	Remittance Name	This shows the name of the community default remittance address.
AB	Remittance Address Line 1	This shows the default remittance address.
AC	Remittance Address Line 2	This shows any address information that was entered on line 2.
AD	Remittance Address Line 3	This shows any address information that was entered on line 3.
AE	Remittance City	This shows the remittance city.
AF	Remittance State / Region	This shows the remittance state/region.
AG	Remittance Zip / Postcode	This shows the remittance zip/postcode. (Max character length is 20).
AH	Remittance Country	This shows the remittance country.
AI	Physical Address Line 1	This shows the physical address.
AJ	Physical Address Line 2	This shows any address information that was entered on line 2.
AK	Physical Address Line 3	This shows any address information that was entered on line 3.
AL	Physical City	This shows the city.
AM	Physical State / Region	This shows the state/region.
AN	Physical Zip / Postcode	This shows the zip/postcode. (Max character length is 20).
AO	Physical Country	This shows the country.
AP	Mailing Address Line 1	This shows the mailing address.
AQ	Mailing Address Line 2	This shows any address information that was entered on line 2.
AR	Mailing Address Line 3	This shows any address information that was entered on line 3.
AS	Mailing City	This shows the city.
AT	Mailing State / Region	This shows the state/region.
AU	Mailing Zip / Postcode	This shows the zip/postcode. (Max character length is 20).
AV	Mailing Country	This shows the country.
AW	Payment Term Code	The default payment term for the Supplier, or if none are set, the Community level default. A common example is “NET30”, where the Net amount is due within 30 days.
AX	Bank Account Country	This shows the Bank Account Country.
AY	Bank Name	This shows the Bank Name.
AZ	Branch Address	This shows the Bank Branch address.
BA	Bank Account Name	This shows the Bank Account Name.
BB	Bank Account Type	This shows the bank account type which can be Checking or Savings.
BC	Deposit Format	This shows the deposit format which can be CCD, CTX, or Unspecified.
BD	Bank Account Number	This shows the bank account number.
BE	Bank Account Currency	This shows the currency code. (Ex: USD - United States Dollars).
BF	Bank Account Verification	This indicates Yes or No for if bank account verification has been provided.
BG	Bank SWIFT Code	This is shown if the Country is different from your zone. (Max character length is 255).
BH	Bank IBAN Code	This is shown if the Country is different from your zone. (Max character length is 255).
BI	Credit Card Accepted	This indicates Yes or No if the supplier accepts credit cards.
BJ	Stripe Enabled	This indicates Yes or No if Stripe is enabled.
BK	Form Field Name	This field is populates based on form fields if any are being used.