[jira] Created: (OFBIZ-2702) Rounding error(?) prohibits posting
Locked
[jira] Created: (OFBIZ-2702) Rounding error(?) prohibits posting
 
|
Rounding error(?) prohibits posting
----------------------------------- Key: OFBIZ-2702 URL: https://issues.apache.org/jira/browse/OFBIZ-2702 Project: OFBiz Issue Type: Bug Affects Versions: SVN trunk Reporter: Hans Bakker Fix For: SVN trunk how to re-create using normal ofbiz demo data Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. Use quick shipping and look at the invoice created. All transactions into suspense. to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729321#action_12729321 ] BJ Freeman commented on OFBIZ-2702: ----------------------------------- I see a lot of activity on Accounting. I would think this si a major show stopper. any one focused on this? > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Fix For: SVN trunk > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729503#action_12729503 ] Anil K Patel commented on OFBIZ-2702: ------------------------------------- BJ, Thanks for bringing this up. I'll look into this soon. Anil Patel > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Fix For: SVN trunk > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Issue Comment Edited: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729862#action_12729862 ] BJ Freeman edited comment on OFBIZ-2702 at 7/10/09 3:15 PM: ------------------------------------------------------------ some research to aid in a solution http://www.ibm.com/developerworks/java/library/j-jtp0114/ BCD math http://forums.sun.com/thread.jspa?forumID=31&threadID= the solution in my mind is to store all numbers as strings. the math package would first do the integers side then sift the decimal to integer perform the math the sift the result back to decimal side and add th e integer component. example 19595.3457 + 200.12 would first add 19595 and 200 then add 3457+1200 this keeps the numbers out of the floating point type of math the return result is the longest (in string) decimal. in this case .xxxx truncation and rounding would only be done at the last calculation point. in the case of the trial balance the result of the sumation of all the entries. was (Author: bjfreeman): some research to aid in a solution http://www.ibm.com/developerworks/java/library/j-jtp0114/ BCD math http://forums.sun.com/thread.jspa?forumID=31&threadID= the solution in my mind is to store all numbers as strings. the math package would first do the integers side then sift the decimal to integer perform the math the sift the result back to decimal side and add th e integer component. example 19595.3457 + 200.12 would first add 19595 and 200 then add 3457+12 this keeps the numbers out of the floating point type of math the return result is the longest (in string) decimal. in this case .xxxx truncation and rounding would only be done at the last calculation point. in the case of the trial balance the result of the sumation of all the entries. > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Fix For: SVN trunk > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12729862#action_12729862 ] BJ Freeman commented on OFBIZ-2702: ----------------------------------- some research to aid in a solution http://www.ibm.com/developerworks/java/library/j-jtp0114/ BCD math http://forums.sun.com/thread.jspa?forumID=31&threadID= the solution in my mind is to store all numbers as strings. the math package would first do the integers side then sift the decimal to integer perform the math the sift the result back to decimal side and add th e integer component. example 19595.3457 + 200.12 would first add 19595 and 200 then add 3457+12 this keeps the numbers out of the floating point type of math the return result is the longest (in string) decimal. in this case .xxxx truncation and rounding would only be done at the last calculation point. in the case of the trial balance the result of the sumation of all the entries. > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Fix For: SVN trunk > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Assigned: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel reassigned OFBIZ-2702: ----------------------------------- Assignee: Anil K Patel > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Assignee: Anil K Patel > Fix For: SVN trunk > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Updated: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anil K Patel updated OFBIZ-2702: -------------------------------- Attachment: acctgTransDetailReportPdf_2.pdf acctgTransDetailReportPdf.pdf invoice.pdf Artifacts from my attempt to reproduce error reported in this issue. > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Assignee: Anil K Patel > Fix For: SVN trunk > > Attachments: acctgTransDetailReportPdf.pdf, acctgTransDetailReportPdf_2.pdf, invoice.pdf > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12738030#action_12738030 ] Anil K Patel commented on OFBIZ-2702: ------------------------------------- I followed exact steps as mentioned by Hans. Only difference was I got different totals then mentioned above. For reference I am attaching pdf export of invoice, accounting transaction. Its possible that some other commit in past few days fixed this error as well. If anybody else has sometime please validate the error. Its critical issue. > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Assignee: Anil K Patel > Fix For: SVN trunk > > Attachments: acctgTransDetailReportPdf.pdf, acctgTransDetailReportPdf_2.pdf, invoice.pdf > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12738032#action_12738032 ] Jacopo Cappellato commented on OFBIZ-2702: ------------------------------------------ Thank you Anil. Hans, it would be really great if you could try this again and verify if it is now fixed. Thanks > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Assignee: Anil K Patel > Fix For: SVN trunk > > Attachments: acctgTransDetailReportPdf.pdf, acctgTransDetailReportPdf_2.pdf, invoice.pdf > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-2702) Rounding error(?) prohibits posting
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hans Bakker closed OFBIZ-2702. ------------------------------ Resolution: Fixed Hi Anil, Jacopo, Thank you for checking this out, i can verify that the problem has been solved. Regards, Hans > Rounding error(?) prohibits posting > ----------------------------------- > > Key: OFBIZ-2702 > URL: https://issues.apache.org/jira/browse/OFBIZ-2702 > Project: OFBiz > Issue Type: Bug > Affects Versions: SVN trunk > Reporter: Hans Bakker > Assignee: Anil K Patel > Fix For: SVN trunk > > Attachments: acctgTransDetailReportPdf.pdf, acctgTransDetailReportPdf_2.pdf, invoice.pdf > > > how to re-create using normal ofbiz demo data > Enter an order to DemoCustomer for product WG-9943-B3 quantity 11. > Use quick shipping and look at the invoice created. All transactions into suspense. > to see the reason goto GlSettings' -> accounting 'company' -> 'unposted transactions' -> verify transaction > then you het the message: Not posting GL Accounting Transaction with ID because the trial balance failed: Debit Total=522.51 Credit Total=522.49 Debit/Credit Difference=0.02 > ... looks like some rounding problem. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |