1 / 19

Baan Business Intelligence Analysis Tools Uninvoiced Receipts

Baan Business Intelligence Analysis Tools Uninvoiced Receipts. Strategic Systems Group, Inc. info@ssgnet.com 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

ceri
Download Presentation

Baan Business Intelligence Analysis Tools Uninvoiced Receipts

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Baan Business Intelligence Analysis ToolsUninvoiced Receipts Strategic Systems Group, Inc. info@ssgnet.com http://www.ssgnet.com

  2. Uninvoiced Receipts Overview • What is Uninvoiced Receipts Analysis? • Why was this analysis tool developed? • What business problems does it solve? • The Process • The Results

  3. Analysis ToolsUninvoiced 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

  4. 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)

  5. 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

  6. 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

  7. UIR Record Selection Transactions can be selected and analyzed by: • Purchase order and position • Project • Invoice number • Journal and batch • Account number • Supplier • Period

  8. 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

  9. Consolidates into one data source: Purchase receipt transactions Accounts Payable transactions Integration transactions Identifies: Operational transaction flow by PO General ledger flow by PO UIR Spreadsheet

  10. Uninvoiced Receipts Data Flow UninvRcpts Crystal Reports Baan System RcptHist POMatching UIR Database UninvRcpts Analysis Spreadsheet APDistrib {or} SSGBusIntell ProjFinTrans IntegTrans GenLedger

  11. Start with an aged summary

  12. Identify the PO and position that make up this amount Next, analyze the details

  13. Uninvoiced Receipts Spreadsheet This summary page can be used as journal back-up. Uninvoiced PO and Pos detail Detailed analysis tabs . . . and more

  14. Operational Transaction Flow Operational Transaction Flow PO and Pos Variance between Calculated and Baan balance Purchase Receipts In Baan ending balance A/P Vouchers Out Calculated ending balance

  15. 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

  16. 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

  17. 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

  18. 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

  19. 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. (310) 539-4645 http://www.ssgnet.comdcervelli@ssgnet.com

More Related