OFBiz
  1. OFBiz
  2. OFBIZ-1434 General Ledger
  3. OFBIZ-1436

New entity, CRUD services and screen to map, for an organization, a productCategoryId/glAccountTypeId pair to a glAccountId

    Details

    • Type: Sub-task Sub-task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: product
    • Labels:
      None

      Description

      Define a new entity (ProductCategoryGlAccount) to map a productCategoryId and glAccountTypeId to a glAccountId.
      The entity will be similar to ProductGlAccount.
      Implement CRUD services.
      New screen to manage the ProductCategoryGlAccount information of an Organization: the screen will reside in the Accounting>General Ledger>Setup menu and will show a (searchable?) list of all the ProductCategoryGlAccount records related to the Organization in the context (organizationPartyId).
      At the bottom of the screen there will be an Add/Edit form.
      In the list there will be, next to each item, a "remove" link.

      1. RemoveWarningMessage.patch
        1 kB
        Ashish Vijaywargiya
      2. ProductCategoryGlAccount_CRUD_Services.patch
        17 kB
        Ashish Vijaywargiya

        Issue Links

          Activity

          Jacopo Cappellato created issue -
          Hide
          David E. Jones added a comment -

          So, the idea is that if there is no ProductGlAccount you would look for an applicable ProductCategoryGlAccount, or is this for something different?

          Show
          David E. Jones added a comment - So, the idea is that if there is no ProductGlAccount you would look for an applicable ProductCategoryGlAccount, or is this for something different?
          Jacopo Cappellato made changes -
          Field Original Value New Value
          Link This issue blocks OFBIZ-1437 [ OFBIZ-1437 ]
          Hide
          Jacopo Cappellato added a comment -

          David, yes this is the idea (see also OFBIZ-1437); do you think it is a good way to go?

          Show
          Jacopo Cappellato added a comment - David, yes this is the idea (see also OFBIZ-1437 ); do you think it is a good way to go?
          Hide
          David E. Jones added a comment -

          Sure, yes, it is definitely more convenient for companies with lots of products, and some certainly do have LOTS and LOTS.

          Show
          David E. Jones added a comment - Sure, yes, it is definitely more convenient for companies with lots of products, and some certainly do have LOTS and LOTS.
          Jacopo Cappellato made changes -
          Summary New entiy, CRUD services and screen to map, for an organization, a productCategoryId/glAccountTypeId pair to a glAccountId New entity, CRUD services and screen to map, for an organization, a productCategoryId/glAccountTypeId pair to a glAccountId
          Anil K Patel made changes -
          Assignee Anil K Patel [ anilpatel ]
          Hide
          Ashish Vijaywargiya added a comment -

          Jacopo & Anil,

          Here is the patch for this issue.


          Ashish Vijaywargiya

          Show
          Ashish Vijaywargiya added a comment - Jacopo & Anil, Here is the patch for this issue. – Ashish Vijaywargiya
          Ashish Vijaywargiya made changes -
          Hide
          Anil K Patel added a comment -

          Ashish, thanks for patch. Its in rev # 599219.

          Show
          Anil K Patel added a comment - Ashish, thanks for patch. Its in rev # 599219.
          Anil K Patel made changes -
          Resolution Fixed [ 1 ]
          Status Open [ 1 ] Closed [ 6 ]
          Hide
          Jacopo Cappellato added a comment -

          I've noticed the following warning messages at startup:

          2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:151:WARN ] ===== Found 4 warnings when checking the entity definitions:
          2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 characters in length for relation ProductCategory of entity ProductCategoryGlAccount.
          2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:20) was greater than 18 characters in length for relation Party of entity ProductCategoryGlAccount.
          2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 characters in length for relation GlAccountType of entity ProductCategoryGlAccount.
          2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:20) was greater than 18 characters in length for relation GlAccount of entity ProductCategoryGlAccount.

          Show
          Jacopo Cappellato added a comment - I've noticed the following warning messages at startup: 2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:151:WARN ] = = = = = Found 4 warnings when checking the entity definitions: 2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 characters in length for relation ProductCategory of entity ProductCategoryGlAccount. 2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:20) was greater than 18 characters in length for relation Party of entity ProductCategoryGlAccount. 2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:19) was greater than 18 characters in length for relation GlAccountType of entity ProductCategoryGlAccount. 2007-12-01 13:23:22,390 (main) [ GenericDelegator.java:153:WARN ] [RelFKNameGT18] The foregn key name (length:20) was greater than 18 characters in length for relation GlAccount of entity ProductCategoryGlAccount.
          Hide
          Ashish Vijaywargiya added a comment -

          Hi,

          Can anybody of you please open this issue ?
          I want to attach the patch for this warnings.


          Ashish

          Show
          Ashish Vijaywargiya added a comment - Hi, Can anybody of you please open this issue ? I want to attach the patch for this warnings. – Ashish
          Hide
          Anil K Patel added a comment -

          Need to fix error reported by Jacopo.

          Show
          Anil K Patel added a comment - Need to fix error reported by Jacopo.
          Anil K Patel made changes -
          Status Closed [ 6 ] Reopened [ 4 ]
          Resolution Fixed [ 1 ]
          Hide
          Ashish Vijaywargiya added a comment -

          Hi,

          This patch will remove the warning message that is coming up on the console.

          Ashish Vijaywargiya

          Show
          Ashish Vijaywargiya added a comment - Hi, This patch will remove the warning message that is coming up on the console. – Ashish Vijaywargiya
          Ashish Vijaywargiya made changes -
          Attachment RemoveWarningMessage.patch [ 12370913 ]
          Hide
          Anil K Patel added a comment -

          Ashish thanks for providing fix. Your patch is in rev#600909

          Show
          Anil K Patel added a comment - Ashish thanks for providing fix. Your patch is in rev#600909
          Anil K Patel made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12417951 ] OFbiz Workflow [ 12504223 ]
          Gavin made changes -
          Link This issue blocks OFBIZ-1437 [ OFBIZ-1437 ]
          Gavin made changes -
          Link This issue is depended upon by OFBIZ-1437 [ OFBIZ-1437 ]

            People

            • Assignee:
              Anil K Patel
              Reporter:
              Jacopo Cappellato
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development