Available Views By ERP

This article contains a list of template views that have been created to direct users on setting up their configuration.

SQL View Templates

Solver has created template views to help assist customers getting up and running with Solver. These are template views designed to handle many “standard” features of the source listed below but may not be handling every configuration. As such, it may be required that you have to make customization to these views in order to get it to work with your ERP system.

Download the latest views from the Gateway application.

Dynamics Product Line

• GP
  • General Ledger
  • GL Budget Transactions
  • GL Detail Work
  • Accounts Payable
  • Accounts Receivable
  • Sales Order Processing
  • Account dimension
  • Sub-account dimensions
• SL
  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Sales Order Processing
  • GL Account dimension
  • GL Sub-account dimension
  • Account Segment dimensions
  • Project Account
  • Project Dimension
  • Project GL Transactions
• AX (2012r2)
  • General Ledger Journal Transactions
  • Budget Transactions
  • AP Vendor Invoice Transactions
  • AR Customer Invoice Transactions
  • Sales Orders
  • Sales Order Lines
  • Account Structure
  • Default Dimensions
  • GL Main Account Dimension
• NAV (2013)
  • G/L Entry
  • General Journal Line
  • GL Budget Entry
  • GL Budget Name
  • Customer Ledger Entry
  • Detailed Customer Ledger Entry
  • Vendor Ledger Entry
  • Detailed Vendor Ledger Entry
  • Sales Invoice Header
  • Sales Invoice Line
  • Sales Header
  • Sales Line
  • Purchase Invoice Header
  • Purchase Invoice Line
  • Global Dimensions
  • Shortcut Dimensions
  • GL Account

SAP Product Line

• SAP B1 SQL
  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Budget Transactions
  • Sales Order
  • Purchase Order
  • GL Account
  • Account Segments
  • Natural Account
  • Dimensions
  • BP Customer
  • BP Vendor

Sage Product Line

• Sage 100
  • General Ledger (Summary&Detail)
  • GL Budget
  • All Account and Sub-Account Dimensions
  • Accounts Payable
  • Accounts Receivable
  • Sales Order Processing (Current&Historical)
• Sage 300
  • General Ledger
  • Account Balance
  • GL Budget
  • All Account and Sub-Account Dimensions
  • Accounts Payable
  • Accounts Receivable
  • Purchase Orders
  • Inventory
  • Project Management
• Sage 500
  • General Ledger (Summary&Detail)
  • GL Budget
  • Account and All Sub-Account dimensions
  • Accounts Payable
  • Accounts Receivable
  • Sales Order Lines
  • Purchase Order Lines
  • Vendor Transaction History
  • Customer Transaction History
• Sage x3