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. To add a standard template please contact your Account Manager stating which templates you would like added
The available standard templates are listed below along with a brief description of what is included/excluded and the columns on the report.
Invoice Items Pending Receiving
The Invoice Items Pending Receiving report lists all orders where the line items are Pending Receiving.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this report are: Order Number, Created Date, Retrofit Order, Invoice Number, Invoice Date, Calculation of Days Since Invoice Date, Invoice Subtotal, Buyer Name, and Supplier.
You can find an example report on the link below.
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.
The 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.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
Unimarket Blanket Order Report Example
Unimarket Expenses
The Unimarket Expenses report lists all expense claims loaded in Unimarket within the specified dates.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
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.
The columns included on this report are: Requisition Number, Line, Requester, Buyer, OBO, Outcome, Approver ,Task Created ,Task Completed, Total Time (Hours), Approver Decision, Approve / Decline Reason.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
Unimarket Invoices-Matched Example
Unimarket Order Report
The Unimarket Order Report lists orders within the specified date range excluding cancelled orders.
The columns on this 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.
You can find an example report on the link below.
Unimarket Order Report Example
Unimarket Receiving Report
The Unimarket Receiving Report lists all receiving done within the specified date range.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this 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.
You can find an example report on the link below.
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.
The columns on this report are: Requisition Number, Description, Begin Approval Date, Type, Supplier, Buyer, On Behalf Of, Current Approver, Lines, Organization Unit, Currency, Subtotal, Shipping, Tax, Total.
You can find an example report on the link below.
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.
The columns included on this 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.
You can find an example report on the link below.
Unimarket Requisitions Report Example
Custom Reports
If you want to define custom report templates please contact your Account Manager.