You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Eva Bowman <eb...@globalera.com> on 2009/07/18 01:00:26 UTC
Re: adding payrol
Hello Hans,
I'm trying to use the new Payroll function within PurchaseInvoice. I
believe you may have implemented this nice piece of functionality. I've ran
into an accounting issue:
1) Created the new invoice type = payroll. Selected Organization Party ID
and From Party ID.
2) Entered quantity and amounts in the invoice item screen and selected ADD.
3) Updated each line with the Override GL Account ID (expense GL Accounts
for each payroll invoice item)
4) Set the invoice status to approved and then ready.
5) Navigated to the auto-generated payment and SENT the payment.
6) The GL entries associated with the Payroll invoice did not post - they
went to the error journal.
7) When I use the Verify Transaction process for those transactions that are
in suspense they do not display the Override GL Accounts I selected in step
3. Because they do not have a GL Account ID, those entries are not posted.
Would you know what might be happening?
Thanks,
Eva
--
View this message in context: http://www.nabble.com/adding-payrol-tp21382829p24542893.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: adding payrol
Posted by Hans Bakker <ma...@antwebsystems.com>.
Yes you are right,
i am looking into it, in my spare free time,
Regards,
Hans
On Mon, 2009-07-20 at 17:14 -0700, Eva Bowman wrote:
> Hello Hans,
>
> I've added the Payroll GLAccount assignments found in the
> DemoGLSetupData.xml. I did not see any 'Company' payroll invoice line type
> items in this xml file. I was not able to add them via the User Interface
> either.
>
> I tried to generate another Payroll type invoice and the only GL journal
> created is the one with AccountingTransType = Payment Applied (it did not
> post and it went to the ERROR_JOURNAL). I believe this GL journal is related
> to the payment that was applied "behind the scenes". So, in reality, I did
> not get any postings for the Purchase Invoice.
>
> Please see the email from Sharan Foga below. He has experienced the same
> issues I'm experiencing.
> Thank you,
> Eva
>
> ______________________________________
> Hi Eva
>
> I had a quick test of your scenario using the latest trunk online demo and I
> agree with you - it's not using the override accounts and I would have
> expected it to as long as it is an account specified as part of the chart of
> account for 'Company' (or whatever department you are using).
>
> The accounting transaction isnt posting because it only has one side of the
> journal and it needs the balancing entry to be able to post.
>
> I'm not an expert in HR but I have been looking into the OFBiz accounting
> setup and configuration. My initial thought was that there was some
> configuration missing. The reasons are as follows:
>
> If you look at 'Organisation GL Settings' for Company and then ' GL Account
> Defaults / Purchase Invoice' then you see all the default purchase invoice
> line type mappings for the 'Company' – I noticed that the payroll invoice
> line type items arent there and they dont appear in the drop down list for
> the valid Purchase Invoice Item types. (Maybe this is to be implemented as
> part of the HR module rather than in accounting but this is where I would
> have expected the configuration to show up).
>
> If you look in 'Global GL Settings' and then 'Invoice Item Type' then you'll
> see the complete list and the payroll ones do appear there and you can
> specify a global default account.
>
> I did a second test based on yours – this time I put in a default account
> mapping at the global level for a payroll invoice item type to a valid
> account that was linked to the chart of account for Company then re-ran your
> test without putting an override account in - but it still didnt work.
>
> So now it looks to me as as if there is some logic rather than configuration
> that is stopping it from posting.
>
> Hopefully someone else will be able to respond to you that has a better
> understanding of things are currently setup.
>
> Thanks
> Sharan
>
> hansbak wrote:
> >
> > Hi Eva,
> >
> > I tried to reproduce what you describe below...but the override are
> > copied to the first transactions, the second transactions are not filled
> > because the wages(salary) GLAccounts and glaccount assignments for
> > invoice types are not setup for "Company" yet.
> >
> > If you add these to this Company and then add these to the invoice types
> > then the posting will work.
> >
> > I have made start with this in the latest version (795479) in the demo
> > data....let me know if you think it needs some adjustments....
> >
> > Regards,
> > Hans
> >
> > On Fri, 2009-07-17 at 16:00 -0700, Eva Bowman wrote:
> >>
> >> Hello Hans,
> >>
> >> I'm trying to use the new Payroll function within PurchaseInvoice. I
> >> believe you may have implemented this nice piece of functionality. I've
> >> ran
> >> into an accounting issue:
> >>
> >> 1) Created the new invoice type = payroll. Selected Organization Party ID
> >> and From Party ID.
> >> 2) Entered quantity and amounts in the invoice item screen and selected
> >> ADD.
> >> 3) Updated each line with the Override GL Account ID (expense GL Accounts
> >> for each payroll invoice item)
> >> 4) Set the invoice status to approved and then ready.
> >> 5) Navigated to the auto-generated payment and SENT the payment.
> >> 6) The GL entries associated with the Payroll invoice did not post - they
> >> went to the error journal.
> >> 7) When I use the Verify Transaction process for those transactions that
> >> are
> >> in suspense they do not display the Override GL Accounts I selected in
> >> step
> >> 3. Because they do not have a GL Account ID, those entries are not
> >> posted.
> >>
> >> Would you know what might be happening?
> >>
> >> Thanks,
> >> Eva
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
> >
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates
Re: adding payrol
Posted by Eva Bowman <eb...@globalera.com>.
Hi Hans,
It worked! Thank you.... Eva
hansbak wrote:
>
> OK Eva, i have made some more changes in r796243, please try again.
>
> Regards Hans
>
> On Mon, 2009-07-20 at 17:14 -0700, Eva Bowman wrote:
>> Hello Hans,
>>
>> I've added the Payroll GLAccount assignments found in the
>> DemoGLSetupData.xml. I did not see any 'Company' payroll invoice line
>> type
>> items in this xml file. I was not able to add them via the User Interface
>> either.
>>
>> I tried to generate another Payroll type invoice and the only GL journal
>> created is the one with AccountingTransType = Payment Applied (it did not
>> post and it went to the ERROR_JOURNAL). I believe this GL journal is
>> related
>> to the payment that was applied "behind the scenes". So, in reality, I
>> did
>> not get any postings for the Purchase Invoice.
>>
>> Please see the email from Sharan Foga below. He has experienced the same
>> issues I'm experiencing.
>> Thank you,
>> Eva
>>
>> ______________________________________
>> Hi Eva
>>
>> I had a quick test of your scenario using the latest trunk online demo
>> and I
>> agree with you - it's not using the override accounts and I would have
>> expected it to as long as it is an account specified as part of the chart
>> of
>> account for 'Company' (or whatever department you are using).
>>
>> The accounting transaction isnt posting because it only has one side of
>> the
>> journal and it needs the balancing entry to be able to post.
>>
>> I'm not an expert in HR but I have been looking into the OFBiz accounting
>> setup and configuration. My initial thought was that there was some
>> configuration missing. The reasons are as follows:
>>
>> If you look at 'Organisation GL Settings' for Company and then ' GL
>> Account
>> Defaults / Purchase Invoice' then you see all the default purchase
>> invoice
>> line type mappings for the 'Company' – I noticed that the payroll invoice
>> line type items arent there and they dont appear in the drop down list
>> for
>> the valid Purchase Invoice Item types. (Maybe this is to be implemented
>> as
>> part of the HR module rather than in accounting but this is where I would
>> have expected the configuration to show up).
>>
>> If you look in 'Global GL Settings' and then 'Invoice Item Type' then
>> you'll
>> see the complete list and the payroll ones do appear there and you can
>> specify a global default account.
>>
>> I did a second test based on yours – this time I put in a default account
>> mapping at the global level for a payroll invoice item type to a valid
>> account that was linked to the chart of account for Company then re-ran
>> your
>> test without putting an override account in - but it still didnt work.
>>
>> So now it looks to me as as if there is some logic rather than
>> configuration
>> that is stopping it from posting.
>>
>> Hopefully someone else will be able to respond to you that has a better
>> understanding of things are currently setup.
>>
>> Thanks
>> Sharan
>>
>> hansbak wrote:
>> >
>> > Hi Eva,
>> >
>> > I tried to reproduce what you describe below...but the override are
>> > copied to the first transactions, the second transactions are not
>> filled
>> > because the wages(salary) GLAccounts and glaccount assignments for
>> > invoice types are not setup for "Company" yet.
>> >
>> > If you add these to this Company and then add these to the invoice
>> types
>> > then the posting will work.
>> >
>> > I have made start with this in the latest version (795479) in the demo
>> > data....let me know if you think it needs some adjustments....
>> >
>> > Regards,
>> > Hans
>> >
>> > On Fri, 2009-07-17 at 16:00 -0700, Eva Bowman wrote:
>> >>
>> >> Hello Hans,
>> >>
>> >> I'm trying to use the new Payroll function within PurchaseInvoice. I
>> >> believe you may have implemented this nice piece of functionality.
>> I've
>> >> ran
>> >> into an accounting issue:
>> >>
>> >> 1) Created the new invoice type = payroll. Selected Organization Party
>> ID
>> >> and From Party ID.
>> >> 2) Entered quantity and amounts in the invoice item screen and
>> selected
>> >> ADD.
>> >> 3) Updated each line with the Override GL Account ID (expense GL
>> Accounts
>> >> for each payroll invoice item)
>> >> 4) Set the invoice status to approved and then ready.
>> >> 5) Navigated to the auto-generated payment and SENT the payment.
>> >> 6) The GL entries associated with the Payroll invoice did not post -
>> they
>> >> went to the error journal.
>> >> 7) When I use the Verify Transaction process for those transactions
>> that
>> >> are
>> >> in suspense they do not display the Override GL Accounts I selected in
>> >> step
>> >> 3. Because they do not have a GL Account ID, those entries are not
>> >> posted.
>> >>
>> >> Would you know what might be happening?
>> >>
>> >> Thanks,
>> >> Eva
>> > --
>> > Antwebsystems.com: Quality OFBiz services for competitive rates
>> >
>> >
>> >
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>
>
--
View this message in context: http://www.nabble.com/adding-payrol-tp21382829p24592937.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: adding payrol
Posted by Hans Bakker <ma...@antwebsystems.com>.
OK Eva, i have made some more changes in r796243, please try again.
Regards Hans
On Mon, 2009-07-20 at 17:14 -0700, Eva Bowman wrote:
> Hello Hans,
>
> I've added the Payroll GLAccount assignments found in the
> DemoGLSetupData.xml. I did not see any 'Company' payroll invoice line type
> items in this xml file. I was not able to add them via the User Interface
> either.
>
> I tried to generate another Payroll type invoice and the only GL journal
> created is the one with AccountingTransType = Payment Applied (it did not
> post and it went to the ERROR_JOURNAL). I believe this GL journal is related
> to the payment that was applied "behind the scenes". So, in reality, I did
> not get any postings for the Purchase Invoice.
>
> Please see the email from Sharan Foga below. He has experienced the same
> issues I'm experiencing.
> Thank you,
> Eva
>
> ______________________________________
> Hi Eva
>
> I had a quick test of your scenario using the latest trunk online demo and I
> agree with you - it's not using the override accounts and I would have
> expected it to as long as it is an account specified as part of the chart of
> account for 'Company' (or whatever department you are using).
>
> The accounting transaction isnt posting because it only has one side of the
> journal and it needs the balancing entry to be able to post.
>
> I'm not an expert in HR but I have been looking into the OFBiz accounting
> setup and configuration. My initial thought was that there was some
> configuration missing. The reasons are as follows:
>
> If you look at 'Organisation GL Settings' for Company and then ' GL Account
> Defaults / Purchase Invoice' then you see all the default purchase invoice
> line type mappings for the 'Company' – I noticed that the payroll invoice
> line type items arent there and they dont appear in the drop down list for
> the valid Purchase Invoice Item types. (Maybe this is to be implemented as
> part of the HR module rather than in accounting but this is where I would
> have expected the configuration to show up).
>
> If you look in 'Global GL Settings' and then 'Invoice Item Type' then you'll
> see the complete list and the payroll ones do appear there and you can
> specify a global default account.
>
> I did a second test based on yours – this time I put in a default account
> mapping at the global level for a payroll invoice item type to a valid
> account that was linked to the chart of account for Company then re-ran your
> test without putting an override account in - but it still didnt work.
>
> So now it looks to me as as if there is some logic rather than configuration
> that is stopping it from posting.
>
> Hopefully someone else will be able to respond to you that has a better
> understanding of things are currently setup.
>
> Thanks
> Sharan
>
> hansbak wrote:
> >
> > Hi Eva,
> >
> > I tried to reproduce what you describe below...but the override are
> > copied to the first transactions, the second transactions are not filled
> > because the wages(salary) GLAccounts and glaccount assignments for
> > invoice types are not setup for "Company" yet.
> >
> > If you add these to this Company and then add these to the invoice types
> > then the posting will work.
> >
> > I have made start with this in the latest version (795479) in the demo
> > data....let me know if you think it needs some adjustments....
> >
> > Regards,
> > Hans
> >
> > On Fri, 2009-07-17 at 16:00 -0700, Eva Bowman wrote:
> >>
> >> Hello Hans,
> >>
> >> I'm trying to use the new Payroll function within PurchaseInvoice. I
> >> believe you may have implemented this nice piece of functionality. I've
> >> ran
> >> into an accounting issue:
> >>
> >> 1) Created the new invoice type = payroll. Selected Organization Party ID
> >> and From Party ID.
> >> 2) Entered quantity and amounts in the invoice item screen and selected
> >> ADD.
> >> 3) Updated each line with the Override GL Account ID (expense GL Accounts
> >> for each payroll invoice item)
> >> 4) Set the invoice status to approved and then ready.
> >> 5) Navigated to the auto-generated payment and SENT the payment.
> >> 6) The GL entries associated with the Payroll invoice did not post - they
> >> went to the error journal.
> >> 7) When I use the Verify Transaction process for those transactions that
> >> are
> >> in suspense they do not display the Override GL Accounts I selected in
> >> step
> >> 3. Because they do not have a GL Account ID, those entries are not
> >> posted.
> >>
> >> Would you know what might be happening?
> >>
> >> Thanks,
> >> Eva
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive rates
> >
> >
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive rates
Re: adding payrol
Posted by Eva Bowman <eb...@globalera.com>.
Hello Hans,
I've added the Payroll GLAccount assignments found in the
DemoGLSetupData.xml. I did not see any 'Company' payroll invoice line type
items in this xml file. I was not able to add them via the User Interface
either.
I tried to generate another Payroll type invoice and the only GL journal
created is the one with AccountingTransType = Payment Applied (it did not
post and it went to the ERROR_JOURNAL). I believe this GL journal is related
to the payment that was applied "behind the scenes". So, in reality, I did
not get any postings for the Purchase Invoice.
Please see the email from Sharan Foga below. He has experienced the same
issues I'm experiencing.
Thank you,
Eva
______________________________________
Hi Eva
I had a quick test of your scenario using the latest trunk online demo and I
agree with you - it's not using the override accounts and I would have
expected it to as long as it is an account specified as part of the chart of
account for 'Company' (or whatever department you are using).
The accounting transaction isnt posting because it only has one side of the
journal and it needs the balancing entry to be able to post.
I'm not an expert in HR but I have been looking into the OFBiz accounting
setup and configuration. My initial thought was that there was some
configuration missing. The reasons are as follows:
If you look at 'Organisation GL Settings' for Company and then ' GL Account
Defaults / Purchase Invoice' then you see all the default purchase invoice
line type mappings for the 'Company' – I noticed that the payroll invoice
line type items arent there and they dont appear in the drop down list for
the valid Purchase Invoice Item types. (Maybe this is to be implemented as
part of the HR module rather than in accounting but this is where I would
have expected the configuration to show up).
If you look in 'Global GL Settings' and then 'Invoice Item Type' then you'll
see the complete list and the payroll ones do appear there and you can
specify a global default account.
I did a second test based on yours – this time I put in a default account
mapping at the global level for a payroll invoice item type to a valid
account that was linked to the chart of account for Company then re-ran your
test without putting an override account in - but it still didnt work.
So now it looks to me as as if there is some logic rather than configuration
that is stopping it from posting.
Hopefully someone else will be able to respond to you that has a better
understanding of things are currently setup.
Thanks
Sharan
hansbak wrote:
>
> Hi Eva,
>
> I tried to reproduce what you describe below...but the override are
> copied to the first transactions, the second transactions are not filled
> because the wages(salary) GLAccounts and glaccount assignments for
> invoice types are not setup for "Company" yet.
>
> If you add these to this Company and then add these to the invoice types
> then the posting will work.
>
> I have made start with this in the latest version (795479) in the demo
> data....let me know if you think it needs some adjustments....
>
> Regards,
> Hans
>
> On Fri, 2009-07-17 at 16:00 -0700, Eva Bowman wrote:
>>
>> Hello Hans,
>>
>> I'm trying to use the new Payroll function within PurchaseInvoice. I
>> believe you may have implemented this nice piece of functionality. I've
>> ran
>> into an accounting issue:
>>
>> 1) Created the new invoice type = payroll. Selected Organization Party ID
>> and From Party ID.
>> 2) Entered quantity and amounts in the invoice item screen and selected
>> ADD.
>> 3) Updated each line with the Override GL Account ID (expense GL Accounts
>> for each payroll invoice item)
>> 4) Set the invoice status to approved and then ready.
>> 5) Navigated to the auto-generated payment and SENT the payment.
>> 6) The GL entries associated with the Payroll invoice did not post - they
>> went to the error journal.
>> 7) When I use the Verify Transaction process for those transactions that
>> are
>> in suspense they do not display the Override GL Accounts I selected in
>> step
>> 3. Because they do not have a GL Account ID, those entries are not
>> posted.
>>
>> Would you know what might be happening?
>>
>> Thanks,
>> Eva
> --
> Antwebsystems.com: Quality OFBiz services for competitive rates
>
>
>
--
View this message in context: http://www.nabble.com/adding-payrol-tp21382829p24579721.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: adding payrol
Posted by Hans Bakker <ma...@antwebsystems.com>.
Hi Eva,
I tried to reproduce what you describe below...but the override are
copied to the first transactions, the second transactions are not filled
because the wages(salary) GLAccounts and glaccount assignments for
invoice types are not setup for "Company" yet.
If you add these to this Company and then add these to the invoice types
then the posting will work.
I have made start with this in the latest version (795479) in the demo
data....let me know if you think it needs some adjustments....
Regards,
Hans
On Fri, 2009-07-17 at 16:00 -0700, Eva Bowman wrote:
>
> Hello Hans,
>
> I'm trying to use the new Payroll function within PurchaseInvoice. I
> believe you may have implemented this nice piece of functionality. I've ran
> into an accounting issue:
>
> 1) Created the new invoice type = payroll. Selected Organization Party ID
> and From Party ID.
> 2) Entered quantity and amounts in the invoice item screen and selected ADD.
> 3) Updated each line with the Override GL Account ID (expense GL Accounts
> for each payroll invoice item)
> 4) Set the invoice status to approved and then ready.
> 5) Navigated to the auto-generated payment and SENT the payment.
> 6) The GL entries associated with the Payroll invoice did not post - they
> went to the error journal.
> 7) When I use the Verify Transaction process for those transactions that are
> in suspense they do not display the Override GL Accounts I selected in step
> 3. Because they do not have a GL Account ID, those entries are not posted.
>
> Would you know what might be happening?
>
> Thanks,
> Eva
--
Antwebsystems.com: Quality OFBiz services for competitive rates