Details

    • Type: Task Task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: SVN trunk
    • Fix Version/s: None
    • Component/s: accounting
    • Labels:
      None

      Description

      Finish implementation of the OFBiz accounting component, both the auto-posting to GL services and a nice complete set of reports (the 4 standard accounting 101 type reports plus a complete set of financial metrics). Complete the user interfaces to manage AR/AP tasks etc...

      http://docs.ofbiz.org/x/sgw

        Issue Links

        1.
        New screen to manage the ProductGlAccount information of an Organization Sub-task Closed Anil K Patel  
         
        2.
        New entity, CRUD services and screen to map, for an organization, a productCategoryId/glAccountTypeId pair to a glAccountId Sub-task Closed Anil K Patel  
         
        3.
        Modify the getProductOrgGlAccount service to also consider the new ProductCategoryGlAccount entity Sub-task Closed Jacopo Cappellato  
         
        4.
        New screen to manually create an AcctgTrans. Sub-task Closed Anil K Patel  
         
        5.
        Review/cleanup the Accounting>General Ledger>Setup>Gl Account defaults>Sales Invoice screen Sub-task Closed Unassigned  
         
        6.
        Review/cleanup the Accounting>General Ledger>Setup>Gl Account defaults>Purchase Invoice screen Sub-task Closed Unassigned  
         
        7.
        Prepare a demo data file with some basic GL setup to facilitate the tests of the gl transaction postings Sub-task Closed Jacopo Cappellato  
         
        8.
        New CRUD services and screen for the FinAccountTypeGlAccount entity Sub-task Closed Anil K Patel  
         
        9.
        Add lookup buttons to the "search" forms for accounting transactions and accounting transactions entries Sub-task Closed Anil K Patel  
         
        10.
        Add links to the relevant fields of the list forms for accounting transactions and accounting transactions entries Sub-task Closed Anil K Patel  
         
        11.
        UI: Review/Improve/Cleanup the /accounting/control/EditAcctgTrans screen Sub-task Closed Vikas Mayur  
         
        12.
        New setup screen and CRUD services for managing organization's VarianceReasonGlAccount entries Sub-task Closed Anil K Patel  
         
        13.
        Implement an automatic GL posting service triggered when InventoryItem.unitCost is changed Sub-task Closed Anil K Patel  
         
        14.
        Implement an automatic GL posting service triggered when a physical inventory variance is performed Sub-task Closed Anil K Patel  
         
        15.
        Implement an automatic GL posting service triggered when the ownerPartyId of an inventory item is changed Sub-task Closed Anil K Patel  
         
        16.
        Implement CRUD services and screens for CreditCardTypeGlAccount entity Sub-task Closed Anil K Patel  
         
        17.
        Implement an automatic GL posting service triggered when inventory is issued for fixed asset maintenance Sub-task Closed Anil K Patel  
         
        18.
        Implement an automatic GL posting service triggered when inventory is issued to a work effort Sub-task Closed Anil K Patel  
         
        19.
        Enhance the service described in OFBIZ-1473 to handle in a special way the workEffort that are part of a production run. Sub-task Closed Anil K Patel  
         
        20.
        Implement CRUD services to manage the WorkEffortInventoryProduced entity Sub-task Closed Anil K Patel  
         
        21.
        Replace all the calls to delegator.makeValue("WorkEffortInventoryProduced" in the manufacturing component to service calls Sub-task Closed Anil K Patel  
         
        22.
        Implement an automatic GL posting service triggered when inventory is produced by a work effort Sub-task Closed Anil K Patel  
         
        23.
        Implement an automatic GL posting service triggered when an actual cost record is created for a work effort Sub-task Closed Anil K Patel  
         
        24.
        UI: Add a column with the default account id to the list form in the setup screen for payment method types mappings. Sub-task Closed Ashish Vijaywargiya  
         
        25.
        UI: Create a new top level menu item in the accounting component: "Global GL Settings" Sub-task Closed Ashish Vijaywargiya  
         
        26.
        Auto posting: Implement an automatic GL posting service for sales invoices Sub-task Closed Ashish Vijaywargiya  
         
        27.
        Implement an automatic GL posting service for purchase invoices Sub-task Closed Anil K Patel  
         
        28.
        Implement an automatic GL posting service for incoming payments Sub-task Closed Ashish Vijaywargiya  
         
        29.
        Auto posting: Implement an automatic GL posting service for outgoing payments Sub-task Closed Ashish Vijaywargiya  
         
        30.
        Auto posting: Implement an automatic GL posting service for payment applications Sub-task Closed Ashish Vijaywargiya  
         
        31.
        Create a service to clone an existing accounting transaction and its entries (AcctgTrans and AcctgTransEntry), with an optional parameter to revert the original transaction Sub-task Closed Ashish Vijaywargiya  
         
        32.
        Implement new screens and Java event to manage account reconciliations Sub-task Closed Ashish Vijaywargiya  
         
        33.
        Reports: Implement a report to show the debit/credi totals of all the transactions in a date range by gl account Sub-task Closed Vikas Mayur  
         
        34.
        Reports: Income Statement Sub-task Closed Jacopo Cappellato  
         
        35.
        Reports: Balance Sheet Sub-task Closed Jacopo Cappellato  
         
        36.
        New screen for the CostComponentCalc entity Sub-task Closed Ashish Vijaywargiya  
         
        37.
        New screen to manage the default glAccountId for the InvoiceItemType entity. Sub-task Closed Unassigned  
         
        38.
        New screen to manage the default glAccountId for the PaymentMethodType entity. Sub-task Closed Ashish Vijaywargiya  
         
        39.
        Setup Screens: implement new screen to manage the organization's TaxAuthorityGlAccount entries Sub-task Closed Vikas Mayur  
         
        40.
        Implement service to return an aggregated PartyAcctgPreference map containing information for all the preferences in a internal organization tree Sub-task Closed Jacopo Cappellato  
         
        41.
        Replace all the code that directly retrieves from the db a PartyAcctgPreference for an organizationPartyId with a call to the service implemented in OFBIZ-1630 Sub-task Closed Jacopo Cappellato  
         
        42.
        Refactor the getGlAccountFromAccountType minilang method so that all the entity-one calls are replaced by calls to minilang (inline) methods. Sub-task Closed Jacopo Cappellato  
         
        43.
        The list of accounts in the two drop downs in the edit Invoice Items screen should only show the accounts associated to the organization associated to the invoice. Sub-task Closed Jacopo Cappellato  
         
        44.
        Reports: Comparative Balance Sheet and Income Statement with Statement of Owner's Equity Sub-task Closed Anil K Patel  
         
        45.
        Reports: Cash Flow Statement Sub-task Closed Anil K Patel  
         
        46.
        Review and improve the demo GL settings in accounting/data/DemoGlSetup.xml file Sub-task Closed Unassigned  
         
        47.
        Implement service to close a financial time period Sub-task Closed Jacopo Cappellato  
         
        48.
        AR: implement a service to compute outstanding amounts of past due date invoices Sub-task Closed Jacopo Cappellato  
         
        49.
        Implement ability to map parties to GlAccounts Sub-task Closed Vikas Mayur  
         
        50.
        Auto posting: implement services for serialized inventory Sub-task Closed Ashish Vijaywargiya  
         
        51.
        Bug: with the current ui, it is not possible to associate the same error journal to more than one organizations. Sub-task Closed Unassigned  
         
        52.
        Implement fixed asset depreciation (methods) Sub-task Closed Vikas Mayur  
         
        53.
        In createAcctgTransAndEntries, aggregate entries with same exact fields and sum their amounts Sub-task Closed Unassigned  
         
        54.
        Implement service to help user to verify/complete the GL setup of an organization Sub-task Closed Ashish Vijaywargiya  
         
        55.
        Create a Wiki page to document/review the types and gl account types used by the GL posting services Sub-task Closed Unassigned  
         
        56.
        Issues with tax adjustment precision (3 decimals) and AcctgTransEntry.amount field (2 decimal) Sub-task Closed Jacques Le Roux  
         
        57.
        Chart of accounts isn't sorted properly Sub-task Closed Jacques Le Roux

        0%

        Original Estimate - 2m
        Remaining Estimate - 2m
         

          Activity

          Hide
          Anil K Patel added a comment -

          I think we should add AR and AP as two independent components under special purpose folder. Such components should have Task oriented tools for target Professional roles. This will allow us to easily implement and maintain SECURITY AND EASE OF USE.

          Show
          Anil K Patel added a comment - I think we should add AR and AP as two independent components under special purpose folder. Such components should have Task oriented tools for target Professional roles. This will allow us to easily implement and maintain SECURITY AND EASE OF USE.
          Hide
          Jacopo Cappellato added a comment -

          Anil,
          I like the idea of having different applications for the AP and AR screens, but maybe they can reside as independent applications under the "accounting" component (applications/accounting/webapp/ap and applications/accounting/webapp/ar). Does it make sense?

          Show
          Jacopo Cappellato added a comment - Anil, I like the idea of having different applications for the AP and AR screens, but maybe they can reside as independent applications under the "accounting" component (applications/accounting/webapp/ap and applications/accounting/webapp/ar). Does it make sense?
          Hide
          David E. Jones added a comment -

          The normal pattern for applications versus specialpurpose is that the components in applications would contain fully functional but very generic (data oriented) user interfaces where you can do anything. The components in specialpurpose would be more role/process oriented and would be slimmed down and streamlined for the relevant purpose.

          Show
          David E. Jones added a comment - The normal pattern for applications versus specialpurpose is that the components in applications would contain fully functional but very generic (data oriented) user interfaces where you can do anything. The components in specialpurpose would be more role/process oriented and would be slimmed down and streamlined for the relevant purpose.
          Hide
          Anil K Patel added a comment -

          Jacopo,
          Yes, I understand what you. It will be lot cleaner to do it that way. What I suggested was My interpretation of David's comments in other situations.

          This issue and Sub tasks are great effort. Tasking up at this granular level makes it really easy to contribute.

          Thanks for your effort.

          Show
          Anil K Patel added a comment - Jacopo, Yes, I understand what you. It will be lot cleaner to do it that way. What I suggested was My interpretation of David's comments in other situations. This issue and Sub tasks are great effort. Tasking up at this granular level makes it really easy to contribute. Thanks for your effort.
          Hide
          Jacques Le Roux added a comment -

          Hi Jacopo,

          Are the remaining subtasks still likely to be done?

          Show
          Jacques Le Roux added a comment - Hi Jacopo, Are the remaining subtasks still likely to be done?

            People

            • Assignee:
              Unassigned
              Reporter:
              Jacopo Cappellato
            • Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 2m
                2m
                Remaining:
                Remaining Estimate - 2m
                2m
                Logged:
                Time Spent - Not Specified
                Not Specified

                  Development