PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Collapse]Settings
    [Expand]Subjects
    [Expand]Items
    [Expand]POS
    [Expand]Manufacturing
    [Expand]Personnel
     Calendar
    [Expand]Financials
    [Expand]Customs
    [Collapse]Program
     [Collapse]Document Types
       Header
       Notes
      [Expand]Permissions
       Signatories
      [Expand]Taskbar
      [Expand]Orders
      [Expand]Work Orders
      [Expand]Plan
      [Expand]Goods
      [Expand]Customs
      [Expand]Excise duty
      [Collapse]Financials
       [Expand]Cash
        Fixed Assets
        Accruals and Deferrals
       [Expand]Credits and Leases
        Fiscal Year
        Financials Archive
       [Collapse]Reports - Financials
         Corporate Tax
         Consolidated Financial Statements
        [Expand]Cash Flow Planning
        [Expand]Receivables / Payables
       [Expand]Set-Offs
       [Expand]Reminders
       [Expand]Predefined Document Types
      [Expand]Payment Orders
      [Expand]Interest
      [Expand]Trips
      [Expand]Payroll
       Planning
       Spremenjen šifrant vrst dokumentov
       Authorizations for Document Type Groups
       Archive
       Treatment
     [Expand]Reports in PANTHEON
      Document Texts
      Delivery Methods
     [Expand]Loyalty Cards
     [Expand]Administration Panel
     [Expand]Dashboard Components
      Dashboard Reports
      Ad-hoc analysis
     [Expand]ARES
      SQL urejevalnik
    [Expand]Documentation
    [Expand]Change User
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [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
 [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
[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]User Site

Load Time: 734.4 ms
"
   1001681 | 208556 | 343418 | Updated
Label

Cash flow planning

Cash Flow Planing

010381.gif010411.gif010382.gif010383.gif

The cash flow planning document type can be accessed through the menu Settings | Program | Document types | Financials | Reports Financials:

 

Planning By

We can choose between options:

  • Weeks,
  • Months and
  • Quarters.
Include Journal Entries

It is possible to choose between:

All journals,

Just Record-Only and

No Record-Only Positions.

Colors

We can choose any color to show the data. Colors can also be set for comparative data.

Mark User can choose weather to color text or background.
Formula 1

We use the formulas in the same way as in the financial reports, but without subtotals.

HINT

It is possible to use SQL statements in formulas.

 

WARNING

It is not possible to use formulas to reference another cell, as is possible in balance sheets.
Use SQL statements in formulas

SQL statements write in formula so that is limited by the sign ~S~ at the beginning and end of the sentence (for example, use this SQL statement in case you need paid costs of interest posted on account 7400% : ~S~select SUM(ATI.anDebit) from tHE_AcctTransItem ATI JOIN tHE_AcctTrans AT on AT.acKey = ATI.acKey where ATI.acAcct like '7400%' and AT.adDate>=#DateFrom# and AT.adDate<=#DateTo# and acContraAcct like '22%'~S~).

 Variables that can be used in  SQL statements and replace the value at print of the entered criteria are:

Variable Value
#DateFrom# Period From
#DateTo#

Period To

 

Use Date

 We can choose between the document date, due date and target date (from journal entry header).
Formula 2 We can use Formula 2 in the column PlanNing. But to use that, we need to mark the Formula 2 for planNing option on the planing document. For eg. to show overdue receivables or payables or any other analyze report.

Use Date 2

 We can choose between the document date, due date and target date (from journal entry header) for formula 2.
Condition

Realized data can be colored depending on the result of the set criteria (> for bigger that, < smaller from, = is equal).

 

 

RELATED TOPICS:

  Reports Financials

 Cash flow planning
 

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