AGED BALANCE REPORT TEST (in trunk) I could test the aged balance report today and I must say that the report is not working properly...
1 - I personally think it is a shame that calendar days are not taken into consideration. I explain myself : - an invoice due on the 31/01/2010 and not paid on the 30/04/2010 is 89 days overdue and appear in column "60-90" - an invoice due on the 30/06/2010 and not paid on the 30/09/2010 is 92 days overdue and appear in column "90-120" Both invoices are 3 months overdue and will not be shown as urgent to get paid. 2 - much more important - invoices, credit notes and payment are shown in this report separately. The report does not take into account partial reconcile. In the attached document you see on the 2nd line the partner called "cust2usd" and invoice in column "+120" for 3058.90F and the partial payment in column "0-30" for -436.20F. What is expected : col- "+120" amount : 2622.70F. 3 - A very usefull (and expected) option in wizard is missing (for main for year end legal audit) : possibility to exclude invoices after a date. i.e: we are in apr-2010 and we need to know all invoices, at the date of the 31/12/09, which are still unpaid today . We need an aged balance report dated to the 31/12/09 excluding all invoices after that date but taking all payment and credit notes between the 31/12/09 and today. Thank you for making correction ASAP - at least the point 2 for backport to V5. We know that you are focus on the V6 and we understand but we remind you that we agreed to backport all financial reports into extra-addons V5 BEFORE THE 30-NOV-2010 so we need feedback from you on this comment and my previous one under this same bug report. ** Attachment added: "Aged balance.png" https://bugs.launchpad.net/openobject-addons/+bug/583666/+attachment/1734024/+files/Aged%20balance.png -- Financial Report Minimal Requierement for 5.0 https://bugs.launchpad.net/bugs/583666 You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. Status in OpenObject Addons Modules: Confirmed Bug description: Hi, This is a Bug report on Financial reporting of OpenERP that has to be fixed for 5.0 in order to be "usable" in a real accounting context. All the following comments has been discussed with Fabien Pinckaers, Luc Maurer, Quentin De Paoli, and me. We decided to fix those minimal requirements (fixes or improvements) in the stable and all "nice-to-have" for the 6.0. This bug report :https://bugs.launchpad.net/openobject-addons/+bug/551630 will be for 6.0. 1. All financial reports --------------------------- Wizard changes for balance sheet & general ledger & journal printing & partner ledger (qdp) ---------------------------------------------------------------------------------------------------------------------------------------- Filter : Filters have to be refactorized and period filters isn't working. We need those filter : - 'start date end date' and 'start period and end period'. - Period really based on period and not on dates => actually the filter by period does not consider period, but date of periods…. Select must be done on periode_id IN (ids). IMPROVE SPEED (al) ----------------------- 100'000 Account move line should be printed out in less than the OpenERP-Client timeout ! Especially in : - the General Ledger - the Aged Partner Balance --> AL is working on this. For 6.0 version (qdp's team) ------------------------- Wizard: - add an option to have a new column “currency balance amount” => amount and currency code => check box - add comparison with other fiscal year Presentation: - Add “currency balance amount” and “currency code” columns if related check box is active 3.General ledger --------------------- --------------------- Mandatory/bugs => 5.0.11 ---------------------------------- Presentation: - Replace “balance amount” by “cumulative balance amount” and make a cumulative total for each line For 6.0 version ------------------- - add “with opening balance" => to have a new line with the sum of all entries that are before the begin date/periode used for the filter - Use the “Display history” check box => add a new select field (see quentin notes) 4.Partner balance --------------------------- --------------------------- Mandatory/bugs => 5.0.11 ---------------------------------- Wizard: - Set the default value for “fiscal year” = actual fiscal year (year that contain the actual date). - add "balance date" => by default = actual date - add new option for the moves selection : “partner with movement / balance <> 0 / all” => by default = “balance <>0” - add a new check box “with starting balance” => by default “true” that report the starting balance - Make it also available on the partner (automatic selection of the partner) => important to have good informations (take care if multi-selection to select all) Presentation : - same layout than general ledger and account balance Calculation: - selection of client vs supplier accounts based on the internal account type - add a new computed field “rec_max_date” on account_move_line which is False if not fully reconciled => if fully reconciles = the max date of all the entries with same reconcile number of this entry line => to know when it has been paid because you have to know what was exactly the situation at a given time (!!! Do not use the reconciliation date !!!) The value are the SUM of move_line that - account internal type = client and/or supplier (depending the choice made by the user) - and journal/period <> “End of year entry journal” (see fiscal year) - and move_line.date = into the selected fiscal year - and move_line.date >= begin date/period and move_line.date <= end date/period - if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”) - sum of debit, credit, debit-credit => total by account and by partners 5.Partner ledger --------------------- --------------------- Mandatory/bugs => 5.0.11 --------------------------- Wizard: - By default the value for “fiscal year” = actual fiscal year (year that contain the actual date). - add "balance date" (situation at date…)=> by default = actual date - add new option for the moves selection “partner with movement / balance <> 0 / all => by default = “balance <>0” - add a new check box “with starting balance” => by default “true” Make it also available on the partner (automatic selection of the partner) => important to have good informations (take care if multi-selection to select all) Presentation : - same layout than general ledger and account balance Calculation : The value are the LIST of move_line that - account internal type = client and/or supplier (depending the choice made by the user) - and journal/period <> “End of year entry journal” (see fiscal year) - and move_line.date = into the selected fiscal year - and move_line.date >= begin date/period and move_line.date <= end date/period - if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”) - if “Include reconcile entries” = false => and (rec_max_date = false or rec_max_date > “balance date”) - group by partners For 6.0 version -------------------- - Add sort option (date, entry number, amount, due date) - Add choice “open amount only / paid amount only / all entries” to replace the “Include reconcile entries” 6.Aged partner ledger --------------------------- --------------------------- Mandatory/bugs => 5.0.11 ----------------------------------- Wizard: - By default the value for “fiscal year” = actual fiscal year (year that contain the actual date). - Add filter option like all other financial reports - Add a new check box “with starting balance” => by default “true” - Rename “Sart of period" with "balance date" to be consistent with other reports. Calculation: It should be based on “Maturity date” (not “effective date”). If the maturity date is empty => use the effective date. The value are SUM of move_line that: - account internal type = client and/or supplier (depending the choice made by the user) - and journal/period <> “End of year entry journal” (see fiscal year) - and move_line.date = into the selected fiscal year - and move_line.date >= begin date/period and move_line.date <= end date/period - if “with starting balance” = true => or move_line.date < begin date/period and (rec_max_date = false or rec_max_date > “balance date”) - group by partners and by group of Maturity date Presentation: The last column of the report must show the sum from last period to infinite, do not limit it with another period min or max. Example: - Today: 30-60, 60-90, 90-120, 120-150 - Correct is : 30-60, 60-90, 90-120, 120+ _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
