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 new standard template, please contact Unimarket Support (support@unimarket.com). Stating the templates you would like loaded.
The available standard templates listed, provide a brief description of included columns.
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.
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.
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.
Sample report: Orders Created After Invoice Example
Unimarket Goods Received Not Invoiced (GRNI)
The Unimarket 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.
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.
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.
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.
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.
Sample report: 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 Vendor Id, Buyer Name, Buyer Username, OBO Vendor Id, OBO Name, OBO Username, Category, Claim Number, Claim Name, Created, Date, Description, Expense Type, Payment Type, Payment Type External Id, Reimbursement Type, Reimbursement Type External Id, State, Supplier, Supplier External Id, 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.
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.
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.
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.
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.
The columns on this 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.
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.
Sample report: 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.
Sample report: 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.
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.
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.
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.
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.
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.
The columns 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.
Sample report: Unimarket Requisitions Report Example
Note: Cycle Time (Hours) is the time from when a requisition is initially created to the time it is fully approved. |
Custom Reports
If you want to define custom report templates, please contact your Customer Success Manager.