[jira] Created: (OFBIZ-2611) Add "Posted and UnPosted" section to the "Transaction Totals" report.

[Nicolas Malin (Jira)]

Add "Posted and UnPosted" section to the "Transaction Totals" report.
---------------------------------------------------------------------

                 Key: OFBIZ-2611
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
             Project: OFBiz
          Issue Type: New Feature
          Components: accounting
    Affects Versions: SVN trunk
            Reporter: Sumit Pandit
             Fix For: SVN trunk


The report is this:

https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company

In it there are currently two sections:

    * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
    * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N

We have to implement a new section:

    * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag


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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12719998#action_12719998 ]

Sumit Pandit commented on OFBIZ-2611:
-------------------------------------

Thanks Jacopo for your guidance in this issue.  

--
Regards
Sumit Pandit

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Sumit Pandit updated OFBIZ-2611:
--------------------------------

    Attachment: OFBiz_2611.patch

Here is a patch uploaded for desired functionality.

Thanks And Regards
Sumit Pandit

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12720594#action_12720594 ]

Sumit Pandit commented on OFBIZ-2611:
-------------------------------------

Testing Steps -
1)Create some unposted transactions using following steps -
  a) go and create a new transaction - https://localhost:8443/accounting/control/newAcctgTrans?organizationPartyId=Company
  b) Enter some debit and credit Transaction entries.
  b) Debit credit total should same.
2) And to create more transactions(Posted Transactions) - Create and Ship an Order from Order Manager application (Receive inventory if require). It will create some posted transactions and that will help us to test the functionality.

3) Now go on page - https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
4) Enter FromDate and ThruDate; (Keep in mind that the date when you created your transactions should come in between ThruDate and FromDate.)
5) Click on submit button.
6) You will see 3 blocks (Posted, UnPosted and PostedAndUnPosted) containing data.

How to verify -
1) If thruDate and fromDate is empty then no record should display.
2) If FromDate is empty and ThruDate is set then no records should display.
3) If FromDate is set and ThruDate is empty then, default current date will set and get records from FromDate to CurrentDate.
4) In search result - three blocks should display.
5) In each block no record should repeat.
6) For each GlAccountId in each block - sum of Dr/Cr column should display on third block.
7) Each row should contain summation of all Debit and Credit entry during the time period.

-
Thanks And Regards
Sumit Pandit

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Jacopo Cappellato closed OFBIZ-2611.
------------------------------------

    Resolution: Fixed

Thank you Sumit,

your patch is in rev. 785537

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Sumit Pandit updated OFBIZ-2611:
--------------------------------

    Attachment: OFBiz2611_DemoData.patch

Hi, Here is the demo data for the applied functionality. We can test it for time period :- 2009-06-1 00:00:00.0 to 2009-06-30 00:00:00.0

Thanks And Regards
Sumit Pandit

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz2611_DemoData.patch, OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Sumit Pandit updated OFBIZ-2611:
--------------------------------

    Attachment:     (was: OFBiz2611_DemoData.patch)

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Sumit Pandit updated OFBIZ-2611:
--------------------------------

    Attachment: OFBiz2611_DemoData.patch

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>             Fix For: SVN trunk
>
>         Attachments: OFBiz2611_DemoData.patch, OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Ashish Vijaywargiya closed OFBIZ-2611.
--------------------------------------

    Resolution: Fixed

Thanks Sumit!
Data committed at r788928.

--
Ashish

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Assignee: Ashish Vijaywargiya
>             Fix For: SVN trunk
>
>         Attachments: OFBiz2611_DemoData.patch, OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

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

Ashish Vijaywargiya reopened OFBIZ-2611:
----------------------------------------

      Assignee: Ashish Vijaywargiya

Added new data file so opening this jira issue.

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Assignee: Ashish Vijaywargiya
>             Fix For: SVN trunk
>
>         Attachments: OFBiz2611_DemoData.patch, OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12724816#action_12724816 ]

Sumit Pandit commented on OFBIZ-2611:
-------------------------------------

Thank you Ashish And Jacopo for your commit.

> Add "Posted and UnPosted" section to the "Transaction Totals" report.
> ---------------------------------------------------------------------
>
>                 Key: OFBIZ-2611
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2611
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: accounting
>    Affects Versions: SVN trunk
>            Reporter: Sumit Pandit
>            Assignee: Ashish Vijaywargiya
>             Fix For: SVN trunk
>
>         Attachments: OFBiz2611_DemoData.patch, OFBiz_2611.patch
>
>
> The report is this:
> https://localhost:8443/accounting/control/TransactionTotals?organizationPartyId=Company
> In it there are currently two sections:
>     * Posted Totals: shows all transactions (in a given date range) with isPosted flag set to Y
>     * UnPosted Totals: shows all transactions (in a given date range) with isPosted flag set to N
> We have to implement a new section:
>     * "Posted and UnPosted Totals" containing all the transactions (in a given date range), i.e. not constrained by the isPosted flag

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