[jira] Created: (OFBIZ-1494) Implement new screen and Java event to create an account reconciliation

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
12 messages Options
Reply | Threaded
Open this post in threaded view
|

[jira] Created: (OFBIZ-1494) Implement new screen and Java event to create an account reconciliation

Nicolas Malin (Jira)
Implement new screen and Java event to create an account reconciliation
-----------------------------------------------------------------------

                 Key: OFBIZ-1494
                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
             Project: OFBiz
          Issue Type: Sub-task
          Components: accounting
    Affects Versions: SVN trunk
            Reporter: Jacopo Cappellato


Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation

Task details:
1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
2) implement a new screen composed by a search form at the top and a multi form at the bottom
2.1) the (single) search form is composed by:
2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
2.1.2) a search button
2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
3.5) put in the context/parameters the glReconciliationId
4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId

6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
7) implement a new screen composed by a search form at the top and a multi form at the bottom
7.1) the (single) search form is composed by:
7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
7.1.2) from/thru dates
7.1.3) a search button
7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato updated OFBIZ-1494:
-------------------------------------

    Summary: Implement new screens and Java event to manage account reconciliations  (was: Implement new screen and Java event to create an account reconciliation)

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

JyotsnaRathore updated OFBIZ-1494:
----------------------------------

    Attachment: glreconcilation.patch

This patch is from me and Santosh Malviya.
Thanks to Vikas, Mridul, Sumit and all for their help on this issue......
 

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>         Attachments: glreconcilation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Santosh updated OFBIZ-1494:
---------------------------

    Attachment: Glreconciliation.patch

This is the latest patch for this issue which is working fine now.

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>         Attachments: glreconcilation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

JyotsnaRathore updated OFBIZ-1494:
----------------------------------

    Attachment: glreconcilation.patch

I think  submit button "Create Account Reconciliation" should be disabled if none of the AcctgTransEntry records associated to the selected account is selected(checked) .

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>         Attachments: glreconcilation.patch, glreconcilation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Assigned: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashish Vijaywargiya reassigned OFBIZ-1494:
------------------------------------------

    Assignee: Ashish Vijaywargiya

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Santosh updated OFBIZ-1494:
---------------------------

    Attachment: GlReconcilation.patch

Updated patch with suggested modifications.

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: GlReconcilation.patch, glreconcilation.patch, glreconcilation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Santosh updated OFBIZ-1494:
---------------------------

    Attachment:     (was: GlReconcilation.patch)

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Santosh updated OFBIZ-1494:
---------------------------

    Attachment: GlReconciliation.patch

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, GlReconciliation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Updated: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pranay Pandey updated OFBIZ-1494:
---------------------------------

    Attachment: glreconcilation.patch

The attached patch is complete with respect to the funcationality.
After reviewing the attached patch I did small updations in it which are :

1. Added titleProperty to the screen created for pt. 2 : FindGlAccountReconciliation.
2. Added titleProperty to the screen created for pt. 5 : EditGlReconciliation.
3. UiLable created for the titleProperty of screen EditGlReconciliation.
4. Updated the controller entry as per the instructions given in pt. 4 for error.
5. Added titleProperty to the screen created for pt. 7 : FindGlAccountReconciliations
6. Added license to the java event for pt. 3.

--
Pranay

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, glreconcilation.patch, GlReconciliation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Closed: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

     [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ashish Vijaywargiya closed OFBIZ-1494.
--------------------------------------

    Resolution: Fixed

Thanks to Santosh Malivya and Jyotsna Rathore for your valuable patch.
Special thanks to Pranay Pandey for the improvement in the work done by Santosh and Jyotsna.

PS : - Jacopo I did extensive testing of this work and it looked good to me.
Can you please see if its accurate as per as requirement ?
I am thinking to create new file FinAccountEvents.java and moving the code from ReconcileEvents.java into it.
Please let me know what do you think about it.

Changes are in rev # 606978.

--
Ashish Vijaywargiya

> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, glreconcilation.patch, GlReconciliation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply | Threaded
Open this post in threaded view
|

[jira] Commented: (OFBIZ-1494) Implement new screens and Java event to manage account reconciliations

Nicolas Malin (Jira)
In reply to this post by Nicolas Malin (Jira)

    [ https://issues.apache.org/jira/browse/OFBIZ-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12554531 ]

Jacopo Cappellato commented on OFBIZ-1494:
------------------------------------------

Ashish,

if I am not wrong, FinAccountEvents is the class for events related to FinAccounts (I don't know much about FinAccounts but they are similar to BillingAccounts) so I don't think that the new code should go there.
Of course, feel free to reorganize/move the code or rename the ReconcileEvents class using a more general name, such as GlEvents.java...


> Implement new screens and Java event to manage account reconciliations
> ----------------------------------------------------------------------
>
>                 Key: OFBIZ-1494
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1494
>             Project: OFBiz
>          Issue Type: Sub-task
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Jacopo Cappellato
>            Assignee: Ashish Vijaywargiya
>         Attachments: glreconcilation.patch, glreconcilation.patch, glreconcilation.patch, GlReconciliation.patch, Glreconciliation.patch
>
>
> Implement new screen and Java event to create an account reconciliation (for example a bank reconciliation).
> For a general description about the process: http://en.wikipedia.org/wiki/Bank_reconciliation
> Task details:
> 1) add a new menu item "Account Reconciliation" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #2
> 2) implement a new screen composed by a search form at the top and a multi form at the bottom
> 2.1) the (single) search form is composed by:
> 2.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 2.1.2) a search button
> 2.2) the multi form will only be visible when the first form has been submitted; the list will show all the AcctgTransEntry records associated to the selected account  (sorted by ascending  date) with reconcileStatusId field set to "not reconciled"; each row will have a checkbox; at the end of the list a submit button "Create Account Reconciliation"
> 2.3) (OPTIONAL) it would be cool to add some Javascript (or Ajax?) magic to display, at the bottom of the page the total of all the selected records (use the amount field where D counts as + and C as -)
> 3) create a Java event (not necessarily a service, a controller event is probably easier) and that will receive data from the multi form at point 2.2 and:
> 3.1) for each row selected it will retrieve the corresponding AcctgTransEntry and add it to a List (NOTE/HINTS: there are some utils methods to easily retrieve/parse fields submitted by a multi form... let me know if you don't find them)
> 3.2) compute the total of all the AcctgTransEntry.amount of the entries in the list (where D counts as + and C as -)
> 3.3) call the service "createGlReconciliation" with the following input fields: glReconciliationName="the 'now' timestamp", glAccountId, organizationPartyId, reconciledDate=now, reconciledBalance=the number computed in #3.2; save the output parameter glReconciliationId
> 3.4) iterate the list of entries created in #3.1 and for each one call the service "createGlReconciliationEntry" with the following input fields: glReconciliationId= the value returned at #3.3, acctgTransId, acctgTransEntrySeqId, reconciledAmount=AcctgTransEntry.amount
> 3.5) put in the context/parameters the glReconciliationId
> 4) set the controller entries so that, after the event described at #3 is successfully executed, redirect to a new screen "Edit GL Reconciliation" (described in #5); on error return at the screen described in #2
> 5) implement a new screen "Edit GL Reconciliation" that takes as input a glReconciliationId and is composed by:
> 5.1) an editable form that display the content of the GlReconciliation entry; the only editable fields will be: glReconciliationName, description, reconciledDate; all the other fields will be visible only; once submitted, the three fields will be updated ("updateGlReconciliation")
> 5.2) a list (non editable) of all the GlReconciliationEntry records associated with the glReconciliationId
> 6) add a new menu item "Account Reconciliations" to the Accounting>General Ledger>Accounting menu; the menu item will open the screen described at point #7
> 7) implement a new screen composed by a search form at the top and a multi form at the bottom
> 7.1) the (single) search form is composed by:
> 7.1.1) a drop down (allow-empty= false) with all the GL accounts associated to the organization
> 7.1.2) from/thru dates
> 7.1.3) a search button
> 7.2) a list form (visible when the first form has been submitted) that lists all the GlReconciliation records that match the search parameters; the glReconciliationId field will be an hyperlink to open the "Edit Gl Reconciliation" screen (implemented in #5; the highlighted menu should not change)

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.