OFBiz › OFBiz - User

Not getting transaction details

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

16 messages Options

manish

Not getting transaction details

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
?)
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 ?)

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 : [hidden email]*

Jacopo Cappellato-4

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 : [hidden email]*

manish

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

manish

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 : 3000000 . Even in "InvoiceAcctgTransEntries.pdf" it is showing same for all line Item.

Please help me out here

Thank You

Jacopo Cappellato-4

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 : 3000000
> . 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.

manish

Re: Not getting transaction details

I am using trunk.

Thank You

Jacopo Cappellato-4

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.

manish

Re: Not getting transaction details

Dear Jacopo ,

This is the link :

https://demo-trunk.ofbiz.apache.org:8443/accounting/control/invoiceOverview?invoiceId=CI1&externalLoginKey=EL952441317436

Here in transaction you can see that that for acctgTransId 10001 GlAccountId is 400000 . 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]> 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 here.
NAML

--

Thank You
Manish Kumar
M : +919343471846
E : [hidden email]

Jacopo Cappellato-4

Re: Not getting transaction details

Hi Manish,

you can change the account from 400000 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=CI1&externalLoginKey=EL952441317436
>
> Here in transaction you can see that that for acctgTransId 10001
> GlAccountId is 400000 . 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]> 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 here<
>> .
>> NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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]*
>
>
> --
> 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.

Tom

Re: Not getting transaction details

In reply to this post by Jacopo Cappellato-4

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 <[hidden email]>
To: [hidden email]
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:

GlForms.xml.patch (1K) Download Attachment

Erwan de FERRIERES

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

Tom

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 <[hidden email]>
To: [hidden email]
Sent: Saturday, March 17, 2012 8:57 AM
Subject: Re: Not getting transaction details

Le 17/03/2012 13:37, Tom Burns a écrit :

Tom

Re: Not getting transaction details

Looks like the invoice did not get attached to the previous message

From: Tom Burns <[hidden email]>
To: "[hidden email]" <[hidden email]>
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 <[hidden email]>
To: [hidden email]
Sent: Saturday, March 17, 2012 8:57 AM
Subject: Re: Not getting transaction details

Le 17/03/2012 13:37, Tom Burns a écrit :

manish

Re: Not getting transaction details

In reply to this post by Jacopo Cappellato-4

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] <[hidden email]> wrote:

Hi Manish,

you can change the account from 400000 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=CI1&externalLoginKey=EL952441317436
>
> Here in transaction you can see that that for acctgTransId 10001
> GlAccountId is 400000 . 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]> 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_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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]*
>
>
> --
> 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 here.
NAML

--

Thank You
Manish Kumar
M : +919343471846
E : [hidden email]

Jacques Le Roux

Re: Not getting transaction details

Administrator

In reply to this post by Tom

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: [hidden email]
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 <[hidden email]>
To: "[hidden email]" <[hidden email]>
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 <[hidden email]>
To: [hidden email]
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

Jacopo Cappellato-4

Re: Not getting transaction details

In reply to this post by manish

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] <
> [hidden email]> wrote:
>
>> Hi Manish,
>>
>> you can change the account from 400000 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=CI1&externalLoginKey=EL952441317436
>>>
>>> Here in transaction you can see that that for acctgTransId 10001
>>> GlAccountId is 400000 . 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=node&node=4480294&i=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_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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=node&node=4480294&i=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 here<
>> .
>> NAML<http://ofbiz.135035.n4.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=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]*
>
>
> --
> 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.