Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-1434

General Ledger

    XMLWordPrintableJSON

Details

    • Task
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Trunk
    • None
    • accounting
    • 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

      Attachments

        Issue Links

          relates to

          Sub-task - The sub-task of the issue OFBIZ-616 Re-Factor Accounting permissions to follow new patterns

          • Major - Major loss of function.
          • Closed

          Sub-task - The sub-task of the issue OFBIZ-1546 Reports: Cash Flow Statement

          • Major - Major loss of function.
          • Closed

          Wish - General wishlist item. OFBIZ-1343 Experience for OFBiz to propertly support multicurrency accounting and autoposting

          • Major - Major loss of function.
          • Closed
          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 Pierre Smits

          0%
          Original Estimate - 2m
          Remaining Estimate - 2m

          Activity

            People

              Unassigned Unassigned
              jacopoc 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