MediaWiki API result

{
    "batchcomplete": "",
    "continue": {
        "gapcontinue": "Referenced_Inventory",
        "continue": "gapcontinue||"
    },
    "query": {
        "pages": {
            "2055": {
                "pageid": 2055,
                "ns": 0,
                "title": "Read-Only Pool",
                "revisions": [
                    {
                        "contentformat": "text/x-wiki",
                        "contentmodel": "wikitext",
                        "*": "=Introduction=\n{{AvailableFrom|3.0PR17Q2}}\n\nThe '''read-only pool''' feature allows to retrieve connections from a secondary (backup) database which allows just read-only operations. Typically, this will be a stand-by database that must have its data updated as much as possible.  \n\nIt provides two main advantages:\n* This helps to relieve the load in the main database.\n* The reporting queries will not be executed against the main database: the standard ERP reports will be generated by taking the data from the secondary database.\n\n=Configuration=\nTo configure the read-only pool the following property must be included in [[Openbravo.properties|Openbravo.properties]]:\n\n*'''bbdd.readonly.url''': this property provides the read-only database url.\n\nNote that it is also mandatory to define the [http://wiki.openbravo.com/wiki/Openbravo.properties#Apache_JDBC_Connection_Pool Apache JDBC Connection Pool] in order to make use of the read-only pool.\n\nBesides, for each '''bbdd.*''' and '''db.pool.*''' it is possible to add new '''bbdd.readonly.*''' and '''db.readonly.pool.*''' properties to configure the read-only database connection and specific pool properties for it. For example:\n\n bbdd.readonly.user=ro\n bbdd.readonly.password=ro\n db.readonly.maxActive=10000\n ...\n\nIn case the read-only properties are not defined, the read-only pool will take the properties defined for the standard pool.\n\n=Supported Reports=\nOnce the read-only pool is enabled, it will be used to generate all the '''standard reports''' of the application. Please note that for custom manual reports which are not making use of the standard reporting engine, they should be adapted in case it is desired to make use of the read-only pool to generate them.\n\n{{(!)| See [[Data_Access_Layer#OBDal|OBDal]] for more details about how to adapt a report to use the read-only pool.}}\n\nStarting from '''3.0PR17Q4''' release, there are some manual reports in core that have been made compatible with the read-only pool. The full list of adapted reports is listed [http://wiki.openbravo.com/wiki/Projects:Read_Only_Pool_Manual_Reports here].\n\nAnd starting from '''3.0PR18Q2''' release, the documents printed with the standard [http://wiki.openbravo.com/wiki/User_Interface_Introduction#Toolbar print toolbar button], are never using the read-only pool (even if configured) but the standard pool. See [https://issues.openbravo.com/view.php?id=37933 here] for additional information.\n\n==Customization==\n{{AvailableFrom|3.0PR18Q3}}\nOnce the read-only pool is configured, it is used by all supported reports (see section above) by default. However, this behavior can be overriden by a Preference value and with a manual selection if a fine-grain configuration is required.\n\n{{(!)| For performance reasons this configuration is cached. When configuration changes, either in the Preference or the Data Pool Selection window, it is recommended to restart Tomcat to apply the changes.  \n}}\n\n===Preference===\n[[File:Default-pool-preference.png|480px|center]]\n\nThe preference '''Default DB Pool used by reports''' defines the database pool used by all reports that support using the read-only pool. Value should be '''DEFAULT''' or '''RO'''. If this preference is not defined or contains an invalid value, reports will use the read-only pool if configured.\n\n===Manual Selection===\n[[File:Data-pool-selection.png|480px|center]]\n\nIf a finer grain configuration is required, in window '''General Setup|Application|Data Pool Selection''' is possible to configure for each report which database pool to use, overriding the preference defined in '''Default DB pool used by reports'''.\n\n[[File:Report_selector.png|480px|center]]\n\nThe Report dropdown will show all applicable reports. That is, reports defined either in Process and Report or in Process Definition that is not used in toolbar's print button.\n\nReport's association with database pool can be temporary disabled using the '''Is active''' flag. Once deactivated, the pool defined in '''Default DB pool used by reports''' will be used.\n\n[[File:No-ro-pool-configured-message.png|480px|center]]\n\nAdministrators can add entries to this Window even if RO pool is not configured yet. In that case, a message should appear to indicate that RO pool is not configured yet and that the referred report is already using the main pool."
                    }
                ]
            },
            "851": {
                "pageid": 851,
                "ns": 0,
                "title": "Receivables Aging Schedule",
                "revisions": [
                    {
                        "contentformat": "text/x-wiki",
                        "contentmodel": "wikitext",
                        "*": "== Availability ==\n\n{{AvailableFrom|3.0PR17Q2}}\nTo get this feature in previous Openbravo 3 versions you must install the external module '''Aging Balance Report''' from the [[Module Management]] window.\n\n== Overview ==\n\nThe report shows the past due receivables as of the date the user selects.\n\n== Source of Information ==\n\nThe source of the information for this report is invoices as the origin of the receivables and the payables.\n\n* '''Invoices'''\n** The due date of an invoice depends on the payment terms and is calculated based on the invoice date.\n** If invoice has multiple payment plan lines, each line has it's own due date.\n** If there exists payments against the invoice, only those ones which are in a not confirmed status as of the date of the date filter are considered for this report.\n\n== Multi-currency ==\n\nThis report supports multicurrency.\n\n* '''Invoices''': If the exchange rate exists at document level then the amount is calculated based on this value, if it doesn't exist then the rate is taken at client level (Conversion Rates window)\n\n== Filters ==\n\n* '''Organization''' (Mandatory). \n* '''General Ledger''' (Mandatory). The user can filter the results by organization's general ledger. All the amounts will be converted to the currency of the general ledger.\n* '''As of Date''' (Mandatory). This is the date as of wich the report will be processed. Past due dates and payment dates will be calculated based on this date.\n* '''Business Partners''' (Optional). The user can select multiple Business Partners to filter the results.\n* '''Number of Days Overdue: Group One/Two/Three/Four''' (Mandatory). The results shown are grouped according to the day ranges the user must enter. The user can enter the ending day for each range, and then, the application will automatically modify the beginning day for the next ranges. For example: in the group One the user enters 30 so the range is now 0 - 30, in the group Two the user enters 60 so the second range is 31 - 60, and so on and so forth.\n* '''Show Details''' (Optional). This checkbox offers the user the option to either show the detailed version of the report or the summarized one. It is also used when printing and exporting to an xls file.\n* '''Show Doubtful Debt''' (Optional). This checkbox offers the user the option to show information about [http://wiki.openbravo.com/wiki/Doubtful_Debt Doubtful Debts] in the report.\n* '''Voided invoices needs to be included''' (Only available if [http://wiki.openbravo.com/wiki/Preference Preference] \"Enable void documents filter in Aging Reports\" is set to Y). This checkbox offers the user the option to include/exclude voided documents from the report\n* '''Reversed payments needs to be included''' (Only available if [http://wiki.openbravo.com/wiki/Preference Preference] \"Enable reversed payment documents filter in Aging Reports\" is set to Y). This checkbox offers the user the option to include/exclude reversed payment documents from the report\n[[Image:FiltersAging_Receivables_Core2.png]]\n\n== HTML/PDF/Excel output ==\n\nThe report can be generated in HTML, PDF and Spreadsheet format.\n\n=== Receivables Aging Schedule ===\n\nIt should Display a table showing the following data:\n\n* '''Business partner'''. A business partner with pending receivables. This is also a link to the detailed version of the report for this Business Partner.\n* '''Current'''. A sum of all the current debts the business partner has with the organization that are not due as of the date selected.\n* '''First day range'''. The amount the business partner owes the organization that is due, and it's due date is between the range.\n* '''Second day range'''. Same as above.\n* '''Third day range'''. Same as above.\n* '''Fourth day range'''. Same as above.\n* '''Fifth day range'''. Same as above.\n* '''Total'''. Current + All the amounts of the day ranges\n* '''Credits'''. Amount of money that the business partner has left as credit, to be used later. The amount is between brackets because it must be subtracted when calculating the totals.\n* '''Net'''. Total - - Credit of the Business Partner.\n\nIf the credits are posted in the same account as the Receivables, then the Net would match the balance of the Business Partner. If the credits are posted in a different account, such as prepayments, then the balance of the Business Partner would match with the Total.\n\nIf the '''Show Doubtful Debt''' check is selected, two more fields are shown.\n* '''Doubtful Debt'''. The amount classified as Doubtful Debt for that particular Business Partner.\n* '''Percentage'''. The percentage that represents the Doubtful Debt over the Net Debt of that particular Business Partner.\nAlso, when Show Doubtful Debt is selected, the Total amount is the sum of all the debts that are not doubtful. Therefore, the Net is Total + Doubtful - Credits\n\n[[Image:OutputAging.png]]\n\n=== Receivables Aging Schedule Details ===\n\nIt should Display a table showing the following data:\nBy clicking on the PDF or the XLS link, either a PDF or a spreadsheet file are generated.\n\nThe information is grouped by Business Partner, in case there report is run for more than one.\nFor each Business Partner the information shown is:\n* '''Document No.'''. The number of the document and also a link to it.\n* '''Document Date'''. The accounting date of the document.\n* '''Past due date buckets'''. The pending amount of the Invoice. It is shown in one column or another depending on the due date and the as of date filter.\n* '''Net Due'''. The outstanding amount of the Invoice as of date. It is the sum of the amounts in the past due date buckets.\n* '''Credits'''. Each line represents a Payment that has generated credit, and the amount is the credit left to be used as of date. The amount is between brackets because it must be subtracted when calculating the totals.\n* '''A summatory line for the Past due date buckets and Credits'''.\n\nIf the credits are posted in the same account as the Receivables, then the  total Net Due would match the balance of the Business Partner. If the credits are posted in a different account, such as prepayments, then the balance of the Business Partner would match with the total Net Due plus the Credits (undoing the subtraction of the credits to the total).\n\nPlus, there is a summatory line for all the Business Partners.\n\nIf the '''Show Doubtful Debt''' check is selected, two more fields are shown.\n* '''Doubtful Debt'''. The amount classified as Doubtful Debt for that particular Invoice.\n* '''Percentage'''. The percentage that represents the Doubtful Debt over the Net Due of that particular Invoice.\nAlso, when Show Doubtful Debt is selected, the Total amount is the sum of all the debts that are not doubtful. Therefore, the Net Due is Total + Doubtful - Credits\n\n[[Image:OutputAgingTrhee.png]]\n\n\n{{BackTo|Financial Management}}"
                    }
                ]
            }
        }
    }
}