Re: Not getting transaction details
One easy way to attach files is to use the Nabble forum. http://ofbiz.135035.n4.nabble.com/OFBiz-User-f135036.html It's the only case I recommend to use it instead of the user ML Jacques - Original Message - From: Tom Burns To: user@ofbiz.apache.org Sent: Saturday, March 17, 2012 3:52 PM Subject: Re: Not getting transaction details Looks like the invoice did not get attached to the previous message -- From: Tom Burns tramseybu...@yahoo.com To: user@ofbiz.apache.org user@ofbiz.apache.org Sent: Saturday, March 17, 2012 9:25 AM Subject: Re: Not getting transaction details Will do. Just like to confirm there is an issue before going to the trouble. One other thing - looks like the original problem Here POSTED BALANCE is coming $0.00 for all Transaction (Why ?) may have been because Round Gizmo's took advantage of a generous promo! Attached it the invoice for Round Gizmo - looks like the sample posted to demo trunk was for a different product. -- From: Erwan de FERRIERES erwan.de-ferrie...@nereide.fr To: user@ofbiz.apache.org Sent: Saturday, March 17, 2012 8:57 AM Subject: Re: Not getting transaction details Le 17/03/2012 13:37, Tom Burns a écrit : Jacopo, I am seeing an error in the demo-trunk in * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) *:ERROR MESSAGE:* org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount (Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount) Attached should fix it. Tom Hi Tom, you should create a Jira issue and attach your patch to it, in order to make it possible to commit (and accept the license!). https://issues.apache.org/jira/browse/OFBIZ/ Thanks, -- Erwan de FERRIERES www.nereide.biz
Re: Not getting transaction details
Then you should configure your mappings using the following screens: https://demo-trunk.ofbiz.apache.org:8443/accounting/control/GlAccountSalInvoice?organizationPartyId=Company https://demo-trunk.ofbiz.apache.org:8443/accounting/control/editProductGlAccounts?organizationPartyId=Company https://demo-trunk.ofbiz.apache.org:8443/accounting/control/editProductCategoryGlAccounts?organizationPartyId=Company Jacopo On Mar 17, 2012, at 5:04 PM, manish wrote: Dear Jacopo , I do not want to send all details in a default account . I have some categories Item and I want these item should go in corresponding categories not in default account. So , please suggest me how to do that. On Sat, Mar 17, 2012 at 2:43 PM, Jacopo Cappellato-4 [via OFBiz] ml-node+s135035n4480294...@n4.nabble.com wrote: Hi Manish, you can change the account from 40 to 4001000 from this screen: https://demo-trunk.ofbiz.apache.org:8443/accounting/control/GlAccountTypeDefaults?organizationPartyId=Company Jacopo On Mar 17, 2012, at 9:57 AM, manish wrote: Dear Jacopo , This is the link : https://demo-trunk.ofbiz.apache.org:8443/accounting/control/invoiceOverview?invoiceId=CI1externalLoginKey=EL952441317436 Here in transaction you can see that that for acctgTransId 10001 GlAccountId is 40 . But I want it should be 4001000(More Granular level ). Thank you On Fri, Mar 16, 2012 at 9:53 PM, Jacopo Cappellato-4 [via OFBiz] [hidden email] http://user/SendEmail.jtp?type=nodenode=4480294i=0 wrote: Could you please recreate the error in the demo site and send me the link? Jacopo PS: you should also subscribe to this list (your mails have been moderated and didn't go thru automatically) On Mar 16, 2012, at 5:06 PM, manish wrote: I am using trunk. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478572.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: . NAML http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- *Thank You Manish Kumar M : +919343471846 E : [hidden email]http://user/SendEmail.jtp?type=nodenode=4480294i=1* -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4480275.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4480294.html To unsubscribe from Not getting transaction details, click herehttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4477321code=bWFuaXNoa3VtYXIuZHNpQGdtYWlsLmNvbXw0NDc3MzIxfC03MTg5NTI2MjU= . NAMLhttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- *Thank You Manish Kumar M : +919343471846 E : manishkumar@gmail.com* -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4480784.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
Dear Jacopo , This is the link : https://demo-trunk.ofbiz.apache.org:8443/accounting/control/invoiceOverview?invoiceId=CI1externalLoginKey=EL952441317436 Here in transaction you can see that that for acctgTransId 10001 GlAccountId is 40 . But I want it should be 4001000(More Granular level ). Thank you On Fri, Mar 16, 2012 at 9:53 PM, Jacopo Cappellato-4 [via OFBiz] ml-node+s135035n4478620...@n4.nabble.com wrote: Could you please recreate the error in the demo site and send me the link? Jacopo PS: you should also subscribe to this list (your mails have been moderated and didn't go thru automatically) On Mar 16, 2012, at 5:06 PM, manish wrote: I am using trunk. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478572.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478620.html To unsubscribe from Not getting transaction details, click herehttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4477321code=bWFuaXNoa3VtYXIuZHNpQGdtYWlsLmNvbXw0NDc3MzIxfC03MTg5NTI2MjU= . NAMLhttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- *Thank You Manish Kumar M : +919343471846 E : manishkumar@gmail.com* -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4480275.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
Hi Manish, you can change the account from 40 to 4001000 from this screen: https://demo-trunk.ofbiz.apache.org:8443/accounting/control/GlAccountTypeDefaults?organizationPartyId=Company Jacopo On Mar 17, 2012, at 9:57 AM, manish wrote: Dear Jacopo , This is the link : https://demo-trunk.ofbiz.apache.org:8443/accounting/control/invoiceOverview?invoiceId=CI1externalLoginKey=EL952441317436 Here in transaction you can see that that for acctgTransId 10001 GlAccountId is 40 . But I want it should be 4001000(More Granular level ). Thank you On Fri, Mar 16, 2012 at 9:53 PM, Jacopo Cappellato-4 [via OFBiz] ml-node+s135035n4478620...@n4.nabble.com wrote: Could you please recreate the error in the demo site and send me the link? Jacopo PS: you should also subscribe to this list (your mails have been moderated and didn't go thru automatically) On Mar 16, 2012, at 5:06 PM, manish wrote: I am using trunk. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478572.html Sent from the OFBiz - User mailing list archive at Nabble.com. -- If you reply to this email, your message will be added to the discussion below: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478620.html To unsubscribe from Not getting transaction details, click herehttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_codenode=4477321code=bWFuaXNoa3VtYXIuZHNpQGdtYWlsLmNvbXw0NDc3MzIxfC03MTg5NTI2MjU= . NAMLhttp://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewerid=instant_html%21nabble%3Aemail.namlbase=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespacebreadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml -- *Thank You Manish Kumar M : +919343471846 E : manishkumar@gmail.com* -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4480275.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
Jacopo, I am seeing an error in the demo-trunk in * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) :ERROR MESSAGE: org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount (Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount) Attached should fix it. Tom From: Jacopo Cappellato jacopo.cappell...@hotwaxmedia.com To: user@ofbiz.apache.org Sent: Friday, March 16, 2012 1:51 AM Subject: Re: Not getting transaction details On Mar 16, 2012, at 3:53 AM, Manish Kumar wrote: Hi , I am new in Ofbiz . I am doing some transaction but I am not getting transaction details. These are the exact process I am doing , please tell me whether I am on track or not : 1. Login as an admin in ordermgr 2. Aplications order orderentry 3. Entered User Login Id : admin Customer : DemoCustomer1 4. Clicked on continue 5. Now entered ProductId : GZ-2644(Round Gizmo) , Quantity : 1 then clicked on Add To Order 6. Clicked on Finalize Order 7. Clicked on Continue after entering New Ship Address 8. Selected No Shipping , continue 9. continue 10. Selected offline payment radio button then continue 11. Selected offline I do not wish to add additional parties radio button then continue 12. Clicked on Create order 13. Now clicked on Approve Order 14. Now Status is Approved 15. After doing Quick Ship Entire Order Invoice is generated 16. Finally for this particular transaction I am able to see Invoice details but in Gl Journal Id column no data is present it is empty.(Why ?) Currently the journal id is set only for failed transactions as we have an error journal. There is a flag (is posted) that tells you if the transaction has been posted to the GL. 17. Now I want to see all transaction details So for this I am doing these steps : 18. Accounting Manager Global GL Setting Chart of accounts 19. Here POSTED BALANCE is coming $0.00 for all Transaction (Why ?) You should not look at that field (we should probably hide it from that screen to avoid confusion) but instead you should go here: Accounting Manager Organization GL Setting then click the Accounting button of the company you are using (this is probably the first record, the one with description Your Company Name Here) From there you will have several screens to review your transactions: * Accounting Transactions: shows you the GL transaction headers * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) * Reports: in the submenus you will find several financial reports, including the Trial Balance, Balance Sheet, Income Statement and Cash Flow Statement Kind regards Jacopo Please give me suggestion and reason why this is happening . Whether I am doing some wrong steps or this is a bug? Why this POSTED BALANCE is coming $0.00 ? In which table I can get all details of Transaction ? Please help me out . I will be very thankful for you. Thank you -- *Thank You Manish Kumar M : +919343471846 E : manishkumar@gmail.com*Index: applications/accounting/widget/GlForms.xml === --- applications/accounting/widget/GlForms.xml (revision 1301921) +++ applications/accounting/widget/GlForms.xml (working copy) @@ -277,11 +277,11 @@ row-actions set field=showPosition1 value=${bsh:String prev=(String)previousItem.get(quot;glAccountIdquot;);return new Boolean(!(prev!=nullamp;amp;prev.equals(glAccountId)));} type=Boolean/ /row-actions -field name=glAccountId position=1 use-when=showPosition1display//field -field name=glAccountDescription title=${uiLabelMap.CommonDescription} position=1 use-when=showPosition1 +field name=glAccountId position=1 use-when=${showPosition1}display//field +field name=glAccountDescription title=${uiLabelMap.CommonDescription} position=1 use-when=${showPosition1} display description=${accountCode} ${accountName}/ /field -field name=glAccountClassId position=1 use-when=showPosition1 +field name=glAccountClassId position=1 use-when=${showPosition1} display-entity entity-name=GlAccountClass/ /field
Re: Not getting transaction details
Le 17/03/2012 13:37, Tom Burns a écrit : Jacopo, I am seeing an error in the demo-trunk in * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) *:ERROR MESSAGE:* org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount (Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount) Attached should fix it. Tom Hi Tom, you should create a Jira issue and attach your patch to it, in order to make it possible to commit (and accept the license!). https://issues.apache.org/jira/browse/OFBIZ/ Thanks, -- Erwan de FERRIERES www.nereide.biz
Re: Not getting transaction details
Will do. Just like to confirm there is an issue before going to the trouble. One other thing - looks like the original problem Here POSTED BALANCE is coming $0.00 for all Transaction (Why ?) may have been because Round Gizmo's took advantage of a generous promo! Attached it the invoice for Round Gizmo - looks like the sample posted to demo trunk was for a different product. From: Erwan de FERRIERES erwan.de-ferrie...@nereide.fr To: user@ofbiz.apache.org Sent: Saturday, March 17, 2012 8:57 AM Subject: Re: Not getting transaction details Le 17/03/2012 13:37, Tom Burns a écrit : Jacopo, I am seeing an error in the demo-trunk in * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) *:ERROR MESSAGE:* org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount (Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount) Attached should fix it. Tom Hi Tom, you should create a Jira issue and attach your patch to it, in order to make it possible to commit (and accept the license!). https://issues.apache.org/jira/browse/OFBIZ/ Thanks, -- Erwan de FERRIERES www.nereide.biz
Re: Not getting transaction details
Looks like the invoice did not get attached to the previous message From: Tom Burns tramseybu...@yahoo.com To: user@ofbiz.apache.org user@ofbiz.apache.org Sent: Saturday, March 17, 2012 9:25 AM Subject: Re: Not getting transaction details Will do. Just like to confirm there is an issue before going to the trouble. One other thing - looks like the original problem Here POSTED BALANCE is coming $0.00 for all Transaction (Why ?) may have been because Round Gizmo's took advantage of a generous promo! Attached it the invoice for Round Gizmo - looks like the sample posted to demo trunk was for a different product. From: Erwan de FERRIERES erwan.de-ferrie...@nereide.fr To: user@ofbiz.apache.org Sent: Saturday, March 17, 2012 8:57 AM Subject: Re: Not getting transaction details Le 17/03/2012 13:37, Tom Burns a écrit : Jacopo, I am seeing an error in the demo-trunk in * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) *:ERROR MESSAGE:* org.ofbiz.widget.screen.ScreenRenderException: Error rendering screen [component://common/widget/CommonScreens.xml#GlobalDecorator]: java.lang.IllegalArgumentException: Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount (Return value from use-when condition eval was not a Boolean: null [null] on the field glAccountId of form ListFindAcctgTransEntriesByAccount) Attached should fix it. Tom Hi Tom, you should create a Jira issue and attach your patch to it, in order to make it possible to commit (and accept the license!). https://issues.apache.org/jira/browse/OFBIZ/ Thanks, -- Erwan de FERRIERES www.nereide.biz
Re: Not getting transaction details
Dear Jacopo , Thank You very much for your quick response.Now I am getting what I wanted . Thank You Manish Kumar -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4477411.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
Dear Jacopo , I got the details of transaction but details are not showing on item item level . Only getting on higher level . Like for one transaction all line items are showing with same account name : SALES and Account Code : 300 . Even in InvoiceAcctgTransEntries.pdf it is showing same for all line Item. Please help me out here Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478257.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
what release are you using? 10.04, 09.04, trunk? Jacopo On Mar 16, 2012, at 3:09 PM, manish wrote: Dear Jacopo , I got the details of transaction but details are not showing on item item level . Only getting on higher level . Like for one transaction all line items are showing with same account name : SALES and Account Code : 300 . Even in InvoiceAcctgTransEntries.pdf it is showing same for all line Item. Please help me out here Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478257.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
I am using trunk. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478572.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
Could you please recreate the error in the demo site and send me the link? Jacopo PS: you should also subscribe to this list (your mails have been moderated and didn't go thru automatically) On Mar 16, 2012, at 5:06 PM, manish wrote: I am using trunk. Thank You -- View this message in context: http://ofbiz.135035.n4.nabble.com/Not-getting-transaction-details-tp4477321p4478572.html Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Not getting transaction details
On Mar 16, 2012, at 3:53 AM, Manish Kumar wrote: Hi , I am new in Ofbiz . I am doing some transaction but I am not getting transaction details. These are the exact process I am doing , please tell me whether I am on track or not : 1. Login as an admin in ordermgr 2. Aplications order orderentry 3. Entered User Login Id : admin Customer : DemoCustomer1 4. Clicked on continue 5. Now entered ProductId : GZ-2644(Round Gizmo) , Quantity : 1 then clicked on Add To Order 6. Clicked on Finalize Order 7. Clicked on Continue after entering New Ship Address 8. Selected No Shipping , continue 9. continue 10. Selected offline payment radio button then continue 11. Selected offline I do not wish to add additional parties radio button then continue 12. Clicked on Create order 13. Now clicked on Approve Order 14. Now Status is Approved 15. After doing Quick Ship Entire Order Invoice is generated 16. Finally for this particular transaction I am able to see Invoice details but in Gl Journal Id column no data is present it is empty.(Why ?) Currently the journal id is set only for failed transactions as we have an error journal. There is a flag (is posted) that tells you if the transaction has been posted to the GL. 17. Now I want to see all transaction details So for this I am doing these steps : 18. Accounting Manager Global GL Setting Chart of accounts 19. Here POSTED BALANCE is coming $0.00 for all Transaction (Why ?) You should not look at that field (we should probably hide it from that screen to avoid confusion) but instead you should go here: Accounting Manager Organization GL Setting then click the Accounting button of the company you are using (this is probably the first record, the one with description Your Company Name Here) From there you will have several screens to review your transactions: * Accounting Transactions: shows you the GL transaction headers * Accounting Transaction Entries: shows you the GL transaction entries (Dr/Cr) * Reports: in the submenus you will find several financial reports, including the Trial Balance, Balance Sheet, Income Statement and Cash Flow Statement Kind regards Jacopo Please give me suggestion and reason why this is happening . Whether I am doing some wrong steps or this is a bug? Why this POSTED BALANCE is coming $0.00 ? In which table I can get all details of Transaction ? Please help me out . I will be very thankful for you. Thank you -- *Thank You Manish Kumar M : +919343471846 E : manishkumar@gmail.com*