You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Hans Bakker <ma...@antwebsystems.com> on 2009/01/09 15:21:18 UTC
adding payrol
I am looking to add payroll functions.
anybody any ideas/concerns?
actions:
1. add entity "PayCheckItem" with key paymentId and paymentItemSeqId and with "PayCheckItemType" and other fields
2. add services, screens ad forms in accounting
3. add automatic calculation using data from HR
input appreciated!
--
Antwebsystems.com: Quality OFBiz services for competitive prices
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
Re: adding payrol
Posted by Eva Bowman <eb...@globalera.com>.
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>.
how we make sure that that only payrolInvoice itemtypes can be selected
on input? The InvoiceItemTypeMap entity needs a special invoiceType
i also want to add automatically the basic payrolInvoice item types
where the user just have to fill in the values...
and probably there are more special operations for the new invoiceType
called "salary"
regards,
Hans
On Fri, 2009-01-09 at 20:17 -0800, David E Jones wrote:
> New InvoiceItemType records may be needed for retirement savings
> deductions, health insurance deductions, and income tax deductions,
> but I don't think a new InvoiceType would be needed.
>
> Remember this is just an invoice from the employee to the company...
> just like any other payable invoice the company might be liable for.
>
> -David
>
>
> On Jan 9, 2009, at 7:35 PM, Hans Bakker wrote:
>
> > Hi David,
> >
> > sound like a good idea, my suggestion was just to follow the database
> > design book. This is less work so sure we can do that.....
> >
> > we do need however special invoiceItemtypes and therefore a new
> > invoiceType,
> >
> > Please let me know because as usual...my customers want this quick and
> > it would be nice if we could now agree on this implementation?
> >
> > So an invoiceType called "Salary" and types like (US) withholding tax,
> > 401-deduction etc...and the mapping against a glAccount for which we
> > can use the existing invoiceItemTypeGlAccount mapping....
> >
> > when this new Invoice type is created, we can create the items at the
> > same time and have the user (in the first phase) fill in the values
> > calculated by hand. (gross salary can be taken from the HR component
> > if
> > available)
> > In the second phase we will calculate the values by the system, but
> > that
> > can be discussed later...
> >
> > an acceptable approach?
> >
> > Regards,
> > Hans
> >
> >
> >
> > On Fri, 2009-01-09 at 16:14 -0800, David E Jones wrote:
> >> Why not just use Invoice* and Payment? These are used elsewhere for
> >> outgoing payments and such, and Invoice has the itemized detail
> >> structure that you're looking for.
> >>
> >> -David
> >>
> >>
> >> On Jan 9, 2009, at 6:21 AM, Hans Bakker wrote:
> >>
> >>> I am looking to add payroll functions.
> >>>
> >>> anybody any ideas/concerns?
> >>>
> >>> actions:
> >>> 1. add entity "PayCheckItem" with key paymentId and paymentItemSeqId
> >>> and with "PayCheckItemType" and other fields
> >>> 2. add services, screens ad forms in accounting
> >>> 3. add automatic calculation using data from HR
> >>>
> >>> input appreciated!
> >>>
> >>> --
> >>> Antwebsystems.com: Quality OFBiz services for competitive prices
> >>>
> >>
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive prices
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive prices
Re: adding payrol
Posted by David E Jones <da...@hotwaxmedia.com>.
New InvoiceItemType records may be needed for retirement savings
deductions, health insurance deductions, and income tax deductions,
but I don't think a new InvoiceType would be needed.
Remember this is just an invoice from the employee to the company...
just like any other payable invoice the company might be liable for.
-David
On Jan 9, 2009, at 7:35 PM, Hans Bakker wrote:
> Hi David,
>
> sound like a good idea, my suggestion was just to follow the database
> design book. This is less work so sure we can do that.....
>
> we do need however special invoiceItemtypes and therefore a new
> invoiceType,
>
> Please let me know because as usual...my customers want this quick and
> it would be nice if we could now agree on this implementation?
>
> So an invoiceType called "Salary" and types like (US) withholding tax,
> 401-deduction etc...and the mapping against a glAccount for which we
> can use the existing invoiceItemTypeGlAccount mapping....
>
> when this new Invoice type is created, we can create the items at the
> same time and have the user (in the first phase) fill in the values
> calculated by hand. (gross salary can be taken from the HR component
> if
> available)
> In the second phase we will calculate the values by the system, but
> that
> can be discussed later...
>
> an acceptable approach?
>
> Regards,
> Hans
>
>
>
> On Fri, 2009-01-09 at 16:14 -0800, David E Jones wrote:
>> Why not just use Invoice* and Payment? These are used elsewhere for
>> outgoing payments and such, and Invoice has the itemized detail
>> structure that you're looking for.
>>
>> -David
>>
>>
>> On Jan 9, 2009, at 6:21 AM, Hans Bakker wrote:
>>
>>> I am looking to add payroll functions.
>>>
>>> anybody any ideas/concerns?
>>>
>>> actions:
>>> 1. add entity "PayCheckItem" with key paymentId and paymentItemSeqId
>>> and with "PayCheckItemType" and other fields
>>> 2. add services, screens ad forms in accounting
>>> 3. add automatic calculation using data from HR
>>>
>>> input appreciated!
>>>
>>> --
>>> Antwebsystems.com: Quality OFBiz services for competitive prices
>>>
>>
> --
> Antwebsystems.com: Quality OFBiz services for competitive prices
>
Re: adding payrol
Posted by Hans Bakker <ma...@antwebsystems.com>.
Hi David,
sound like a good idea, my suggestion was just to follow the database
design book. This is less work so sure we can do that.....
we do need however special invoiceItemtypes and therefore a new
invoiceType,
Please let me know because as usual...my customers want this quick and
it would be nice if we could now agree on this implementation?
So an invoiceType called "Salary" and types like (US) withholding tax,
401-deduction etc...and the mapping against a glAccount for which we
can use the existing invoiceItemTypeGlAccount mapping....
when this new Invoice type is created, we can create the items at the
same time and have the user (in the first phase) fill in the values
calculated by hand. (gross salary can be taken from the HR component if
available)
In the second phase we will calculate the values by the system, but that
can be discussed later...
an acceptable approach?
Regards,
Hans
On Fri, 2009-01-09 at 16:14 -0800, David E Jones wrote:
> Why not just use Invoice* and Payment? These are used elsewhere for
> outgoing payments and such, and Invoice has the itemized detail
> structure that you're looking for.
>
> -David
>
>
> On Jan 9, 2009, at 6:21 AM, Hans Bakker wrote:
>
> > I am looking to add payroll functions.
> >
> > anybody any ideas/concerns?
> >
> > actions:
> > 1. add entity "PayCheckItem" with key paymentId and paymentItemSeqId
> > and with "PayCheckItemType" and other fields
> > 2. add services, screens ad forms in accounting
> > 3. add automatic calculation using data from HR
> >
> > input appreciated!
> >
> > --
> > Antwebsystems.com: Quality OFBiz services for competitive prices
> >
>
--
Antwebsystems.com: Quality OFBiz services for competitive prices
Re: adding payrol
Posted by David E Jones <da...@hotwaxmedia.com>.
Why not just use Invoice* and Payment? These are used elsewhere for
outgoing payments and such, and Invoice has the itemized detail
structure that you're looking for.
-David
On Jan 9, 2009, at 6:21 AM, Hans Bakker wrote:
> I am looking to add payroll functions.
>
> anybody any ideas/concerns?
>
> actions:
> 1. add entity "PayCheckItem" with key paymentId and paymentItemSeqId
> and with "PayCheckItemType" and other fields
> 2. add services, screens ad forms in accounting
> 3. add automatic calculation using data from HR
>
> input appreciated!
>
> --
> Antwebsystems.com: Quality OFBiz services for competitive prices
>
Re: adding payrol
Posted by David E Jones <da...@hotwaxmedia.com>.
On Jan 9, 2009, at 8:31 PM, Adrian Crum wrote:
> --- On Fri, 1/9/09, David E Jones <da...@hotwaxmedia.com> wrote:
>> For some dose of reality, how I see it anyway, is that
>> Payroll companies don't usually do much pay calculation.
>> In many cases they just get the pre-calculated numbers and
>> generate checks, and maybe help with some simple calculation
>> of taxes and other deductions. If they do anything very
>> complex it is custom code... not something OOTB in any
>> system (or rather, combined with OOTB parameterized things
>> that are somewhat complex, but you can only do so much when
>> guessing in advance). If it's going to be custom it
>> requires analysis and design just like anything else, and
>> might as well be implemented in OFBiz as in a separate
>> system that doesn't have access to the company's
>> data that would be used in the calculations.
>
> I have been writing and supporting payroll software for over 20
> years, and I can assure you, that is NOT how payroll processing
> companies work. You supply them with employee info (marital status,
> withholding allowances, payrate, benefits, etc) and they calculate
> what the employee should be paid, print the check, PLUS provide all
> of the necessary tax forms for local, state and federal taxes, as
> well as group insurance payments, etc.
>
> The payroll service you described would not be worth the fee - it
> would be cheaper to buy a printer.
It sounds like you're describing the filling out of basic forms for
payroll processing. That's what I was referring to as the simple case
where they help you figure out the numbers for different people, ie
"help with some simple calculation of taxes and other deductions".
Those are things that most systems can handle OOTB and that change
according to tax code changes and such, but generally really aren't
that complex and usually the tax code and such is boiled down to a few
simple forms and formulas based on them. That's easy stuff, just
implement to the forms and the calculations they describe. There are
corner cases and funny laws that cause problems, and payroll companies
frequently mess these up too until they get a complaint and make a
manual fix of some sort.
What I am talking about for complex payroll stuff is when
organizations build up hundreds or thousands of different policies for
overtime, vacations, non-tax deductions, bonuses, commissions, and the
list goes on and on. Granted these are more typical for larger
organizations, but hopefully this helps clarify what I meant by simple
versus complex cases and customization that payroll outsourcing
companies don't automagically help with (like they do for the simpler
cases).
-David
Re: adding payrol moved to OFBIZ-2117
Posted by Hans Bakker <ma...@antwebsystems.com>.
i moved the discussion to to OFBIZ issue:
OFBIZ-2117
shall we continue there?
Regards,
Hans
On Fri, 2009-01-09 at 20:31 -0800, Adrian Crum wrote:
> --- On Fri, 1/9/09, David E Jones <da...@hotwaxmedia.com> wrote:
> > For some dose of reality, how I see it anyway, is that
> > Payroll companies don't usually do much pay calculation.
> > In many cases they just get the pre-calculated numbers and
> > generate checks, and maybe help with some simple calculation
> > of taxes and other deductions. If they do anything very
> > complex it is custom code... not something OOTB in any
> > system (or rather, combined with OOTB parameterized things
> > that are somewhat complex, but you can only do so much when
> > guessing in advance). If it's going to be custom it
> > requires analysis and design just like anything else, and
> > might as well be implemented in OFBiz as in a separate
> > system that doesn't have access to the company's
> > data that would be used in the calculations.
>
> I have been writing and supporting payroll software for over 20 years, and I can assure you, that is NOT how payroll processing companies work. You supply them with employee info (marital status, withholding allowances, payrate, benefits, etc) and they calculate what the employee should be paid, print the check, PLUS provide all of the necessary tax forms for local, state and federal taxes, as well as group insurance payments, etc.
>
> The payroll service you described would not be worth the fee - it would be cheaper to buy a printer.
>
> -Adrian
>
>
>
>
--
Antwebsystems.com: Quality OFBiz services for competitive prices
Re: adding payrol
Posted by Adrian Crum <ad...@yahoo.com>.
--- On Fri, 1/9/09, David E Jones <da...@hotwaxmedia.com> wrote:
> For some dose of reality, how I see it anyway, is that
> Payroll companies don't usually do much pay calculation.
> In many cases they just get the pre-calculated numbers and
> generate checks, and maybe help with some simple calculation
> of taxes and other deductions. If they do anything very
> complex it is custom code... not something OOTB in any
> system (or rather, combined with OOTB parameterized things
> that are somewhat complex, but you can only do so much when
> guessing in advance). If it's going to be custom it
> requires analysis and design just like anything else, and
> might as well be implemented in OFBiz as in a separate
> system that doesn't have access to the company's
> data that would be used in the calculations.
I have been writing and supporting payroll software for over 20 years, and I can assure you, that is NOT how payroll processing companies work. You supply them with employee info (marital status, withholding allowances, payrate, benefits, etc) and they calculate what the employee should be paid, print the check, PLUS provide all of the necessary tax forms for local, state and federal taxes, as well as group insurance payments, etc.
The payroll service you described would not be worth the fee - it would be cheaper to buy a printer.
-Adrian
Re: adding payrol
Posted by David E Jones <da...@hotwaxmedia.com>.
There are lots of complicated things that we handle in different ways
in OFBiz. In most cases we have light or medium complexity
implementations and touch points where people can customize to their
whim... with whatever insane complexity they want to attempt.
In this case if we have an invoice from the employee to the company
that models what the company owes the employee and we support
generating checks or other payments. We can implement some basic ways
of populating these based on certain simple inputs, and maybe even
have a variety of options available for populating the data. On top of
these end-user organizations can implement their own services for
their own craziness. However it is calculated, the results go into the
same data structure and beyond that point this data is all that we
need to do payments and such.
For some dose of reality, how I see it anyway, is that Payroll
companies don't usually do much pay calculation. In many cases they
just get the pre-calculated numbers and generate checks, and maybe
help with some simple calculation of taxes and other deductions. If
they do anything very complex it is custom code... not something OOTB
in any system (or rather, combined with OOTB parameterized things that
are somewhat complex, but you can only do so much when guessing in
advance). If it's going to be custom it requires analysis and design
just like anything else, and might as well be implemented in OFBiz as
in a separate system that doesn't have access to the company's data
that would be used in the calculations.
-David
On Jan 9, 2009, at 7:40 PM, Adrian Crum wrote:
> The best strategy (in my opinion) is to have OFBiz output payroll
> information in a format that can be accepted by third-party payroll
> processors (ADP, etc).
>
> Trying to write payroll software for OFBiz will be a nightmare, due
> to constantly changing labor, wage, and tax laws.
>
> -Adrian
>
>
> --- On Fri, 1/9/09, Hans Bakker <ma...@antwebsystems.com> wrote:
>
>> From: Hans Bakker <ma...@antwebsystems.com>
>> Subject: adding payrol
>> To: "user" <us...@ofbiz.apache.org>
>> Date: Friday, January 9, 2009, 6:21 AM
>> I am looking to add payroll functions.
>>
>> anybody any ideas/concerns?
>>
>> actions:
>> 1. add entity "PayCheckItem" with key paymentId
>> and paymentItemSeqId and with "PayCheckItemType"
>> and other fields
>> 2. add services, screens ad forms in accounting
>> 3. add automatic calculation using data from HR
>>
>> input appreciated!
>>
>> --
>> Antwebsystems.com: Quality OFBiz services for competitive
>> prices
>
>
>
Re: adding payrol
Posted by Adrian Crum <ad...@yahoo.com>.
The best strategy (in my opinion) is to have OFBiz output payroll information in a format that can be accepted by third-party payroll processors (ADP, etc).
Trying to write payroll software for OFBiz will be a nightmare, due to constantly changing labor, wage, and tax laws.
-Adrian
--- On Fri, 1/9/09, Hans Bakker <ma...@antwebsystems.com> wrote:
> From: Hans Bakker <ma...@antwebsystems.com>
> Subject: adding payrol
> To: "user" <us...@ofbiz.apache.org>
> Date: Friday, January 9, 2009, 6:21 AM
> I am looking to add payroll functions.
>
> anybody any ideas/concerns?
>
> actions:
> 1. add entity "PayCheckItem" with key paymentId
> and paymentItemSeqId and with "PayCheckItemType"
> and other fields
> 2. add services, screens ad forms in accounting
> 3. add automatic calculation using data from HR
>
> input appreciated!
>
> --
> Antwebsystems.com: Quality OFBiz services for competitive
> prices