[
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.
