PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Collapse]Financials
    [Expand]Posting
    [Expand]Accounting Dashboard
    [Expand]Accruals and Deferrals
    [Expand]Credits and leases
    [Expand]Payment Transactions
    [Collapse]Subject Accounts
     [Expand]Close Manually
     [Expand]Close by Reposting
     [Expand]Close Prepayments
     [Expand]Rounding Differences and Cash Discounts
     [Collapse]Outstanding Items
      [Expand]Comparing Outstanding Items Report and Payment Analysis
      [Expand]Reports
       SQLI and Outstanding Items Reports
     [Expand]Balance Report and Debt Structure
      Pregled plačil računov
      Debt Collection
      Debt Structure
      Reminders
     [Expand]Interest Calculation
    [Expand]Finances
    [Expand]Fixed Assets
    [Expand]Fiscal Year
    [Expand]Set-off
   [Expand]Analytics
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 421.876 ms
"
   2734 | 3133 | 342164 | Updated
Label

SQLI and Outstanding Items Reports

SQLI and Outstanding Items Reports

SQLI and Outstanding Items Reports

 005557.gif. 005558.gif.

010381.gif 010411.gif 010382.gif 010383.gif

Whenever predefined report types do not meet individual requirements, you can use SQLI tool.

Example: Let us say we added a new procedure:

005324.gif

Use variables that are available from the outstanding items report panel. To do this, check Show Object Names in template settings menu 006379.gif of taskbar. View them in the outstanding items panel after clicking Criteria tab.

Field name corresponds to the one in the selected table. In our case this is table of journal entries.

005326.gif

Enter SQL command to collect data.

005327.gif

Trigger procedure in the general panel of outstanding items report. Having already entered required data in the Criteria panel and selected Task Autorun in the General panel, double-clicking the name of SQLI procedure lists posting lines matching the set criteria:

005328.gif

005329.gif


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!