Transcript Uninvoiced Receipts Analysis Tool (GRNI)

Baan Business Intelligence
Analysis Tools
Uninvoiced Receipts
Strategic Systems Group, Inc.
[email protected]
http://www.ssgnet.com
Uninvoiced Receipts Overview
 What is Uninvoiced Receipts Analysis?
 Why was this analysis tool developed?
 What business problems does it solve?
 The Process
 The Results
Analysis Tools
Uninvoiced Receipts Analysis
A unique analysis tool to
 Identify A/P uninvoiced receipts by PO and
position
 Confirm that transactions flow correctly into
and out of the uninvoiced receipts ledger
account(s)
 Consolidate transaction details to reconcile
and research purchase receipt and payment
transactions
Uninvoiced Receipts (UIR)
History
 Developed in response to a need for
a way to analyze the uninvoiced
receipts (UIR) ledger account(s)
 Limited details are provided showing
purchase order transaction flow
through to General Ledger for the
uninvoiced receipts account(s)
UIR Reconciliation
 Purchase order and position can be identified
for uninvoiced receipt amounts
 Month-end balances can be recreated after
the month-end has past
 Posting and mapping errors can be identified
 Transaction data is consolidated into a single
data source to reduce reconciliation and
research time
UIR Reconciliation
 This analysis tool can identify uninvoiced
receipts for a prior period month-end. It
contains unique functionality to ‘go back in
time ’ to recreate ending balances for a prior
period.
 Using the MS Query functions, data is retrieved
from the Uninvoiced Receipts table and loaded
into Excel. Reconciliation and research tabs
provide queries for all the supporting details
UIR Record Selection
Transactions can be selected and analyzed by:
 Purchase order and position
 Project
 Invoice number
 Journal and batch
 Account number
 Supplier
 Period
Uninvoiced Receipts Analysis
Record selection is based on:
 Uninvoiced receipts ledger account(s)
 Beginning and ending periods for analysis
For uninvoiced receipts, this analysis identifies:
 Uninvoiced quantities and amounts by PO line and
related invoiced quantities and amounts for the PO
 PO currency and home currency
 Variances by PO line between operational transaction
flow and general ledger flow
 Transaction flow from PO to Receipts to Accounts
Payable to General Ledger
 Transaction flow for Project transactions
UIR Spreadsheet
Consolidates into one data source:
 Purchase receipt transactions
 Accounts Payable transactions
 Integration transactions
Identifies:
 Operational transaction flow by PO
 General ledger flow by PO
Uninvoiced Receipts Data Flow
UninvRcpts
Crystal
Reports
Baan System
POMatching
UIR Database
{or}
SSGBusIntell
RcptHist
UninvRcpts
Analysis
Spreadsheet
APDistrib
ProjFinTrans
IntegTrans
GenLedger
Start with an aged summary
Identify the PO and position
that make up this amount
Next, analyze the details 
Uninvoiced Receipts Spreadsheet
This summary page can be used as journal back-up.
Uninvoiced PO and Pos detail
Detailed analysis tabs
. . . and more
Operational Transaction Flow
Operational Transaction Flow
PO and Pos
Purchase Receipts In
A/P Vouchers Out
Calculated ending balance
Variance between
Calculated and
Baan balance
Baan ending balance
General Ledger Transaction Flow
General Ledger Transaction Flow
Transactions In
Variance between
Calculated and
Baan ending balance
Transactions Out
Calculated ending
balance
Baan ending balance
Updating the Analysis Components
 Refresh the UninvoicedReceipts




database from SSGBusIntell or Baan
Update the parameters in the
SystemValues table
Update the UninvoicedReceipts tables
Update the UninvRcptsAnalysis
spreadsheet with PO and position details
Run the UIR Aging report
The Results
 Easy identification of POs that have been
received and not invoiced
 Report POs with uninvoiced quantities &
amounts showing partial receipts/payments
 Link to database using analysis queries for
full analysis by PO, project, supplier, plus
other elements
 Trace transaction flow from receipt to G/L
posting
Benefits

Analysis tool that identifies PO transaction
detail to support uninvoiced receipts
reconciliation

All data for reconciliation contained in a
single source to reduce analysis, research &
reporting time

User-friendly, Accounting-friendly gateway to
the data

Minimal training required for end-user to
become productive with this analysis tool
Product Details and
Investment
Please contact one of the experts at
Strategic Systems Group, Inc. for more detailed product
information, a live demonstration or investment details.
Strategic Systems Group, Inc.
http://www.ssgnet.com
(310) 539-4645
[email protected]