Automatic Creation of Commission Invoice

[cguZZman]

Hello everybody,

I'm a new user of Ofbiz. I have my ofbiz instance implemented and almost
in production mode.
Now I need to know how to make ofbiz automaticly creates a commission
invoce for each sales order or invoice.
I read the user documentation and looks like a aggrements must be
created for do that. so I create a aggreement but nothings happen.

I searched for two days everywhere without luck
Can somebody help me please? some steps to follow would be great.
I saw that the method createCommissionInvoices must be executed but I
can't make ofbiz to do that.

thanks for your time!!

[hans_bakker]

In accounting -> invoices, did you see the the 'commission run' button?

Regards,
Hans


--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.



On Thu, 2011-08-25 at 22:40 -0500, Carlos Guzman wrote:

> Hello everybody,
>
> I'm a new user of Ofbiz. I have my ofbiz instance implemented and almost
> in production mode.
> Now I need to know how to make ofbiz automaticly creates a commission
> invoce for each sales order or invoice.
> I read the user documentation and looks like a aggrements must be
> created for do that. so I create a aggreement but nothings happen.
>
> I searched for two days everywhere without luck
> Can somebody help me please? some steps to follow would be great.
> I saw that the method createCommissionInvoices must be executed but I
> can't make ofbiz to do that.
>
> thanks for your time!!

[cguZZman]

Hello Hans,

Yes, I saw the button and see the person there whom I must pay. but only the "Find" button is available and nothing happens.
When I create a order, I include this party too... but same result.
any suggestion?
thanks for your fast response!

hans_bakker wrote

In accounting -> invoices, did you see the the 'commission run' button?

Regards,
Hans


--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

[hans_bakker]

I did not use it yet, but what i would do is check the screen what the
selection criteria are....
(InvoiceScreens.xml#CommissionRun from the page source)
That would tell you what is required and then work from there?

Regards,
Hans

On Thu, 2011-08-25 at 21:08 -0700, cguZZman wrote:

> Hello Hans,
>
> Yes, I saw the button and see the person there whom I must pay. but only the
> "Find" button is available and nothing happens.
> When I create a order, I include this party too... but same result.
> any suggestion?
> thanks for your fast response!
>
>
>
> hans_bakker wrote:
> >
> > In accounting -> invoices, did you see the the 'commission run' button?
> >
> > Regards,
> > Hans
> >
> >
> > --
> > Ofbiz on twitter: http://twitter.com/apache_ofbiz
> > Myself on twitter: http://twitter.com/hansbak
> > Antwebsystems.com: Quality services for competitive rates.
> >
>
>
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3769969.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.

--
Ofbiz on twitter: http://twitter.com/apache_ofbiz
Myself on twitter: http://twitter.com/hansbak
Antwebsystems.com: Quality services for competitive rates.

[Surya Kusumakar-2]

Hello Carlos,

If you want to create automatic Commission invoice, you need to take care of
these points :

1. Sales Order should have been placed by selecting additional party(Person)
from the Additional Party page.
2. Sales Order should be completed and invoice should be in Paid status.
3. Role for additional party should be Sales Representative.
4. Commission Agreement should exist for the product(s) added in order w.r.t
the additional party.

Once you run all these point you will be able to search Commission Invoice
in Commission Run screen.

You can refer these links as example :

1. Sales Order using DemoRepAll as Sales Representative :
https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011.

2. Commission Agreement :
https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000

3. Commission Invoice (Commission Run screen) :
https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun

HTH

--
Regards
Surya Kusumakar

[cguZZman]

Hans, Surya thanks for you response.

Surya, I follow your points and I can see the invoces now.
but when I select an invoice and select the action Commision Run and clic the Run button, I get this error:
org.ofbiz.webapp.control.RequestHandlerException: Unknown request [processCommissionRun]; this request does not exist or cannot be called directly.

I saw the code of the controller of accounting and really it does not exist. I'm using ofbiz 10.4.
then I saw the trunk version of the controller and yes, there does exist.

looks like I need to move to the trunk version.

Surya Kusumakar-2 wrote

Hello Carlos,

If you want to create automatic Commission invoice, you need to take care of
these points :

1. Sales Order should have been placed by selecting additional party(Person)
from the Additional Party page.
2. Sales Order should be completed and invoice should be in Paid status.
3. Role for additional party should be Sales Representative.
4. Commission Agreement should exist for the product(s) added in order w.r.t
the additional party.

Once you run all these point you will be able to search Commission Invoice
in Commission Run screen.

You can refer these links as example :

1. Sales Order using DemoRepAll as Sales Representative :
https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011.

2. Commission Agreement :
https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000

3. Commission Invoice (Commission Run screen) :
https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun

HTH

--
Regards
Surya Kusumakar

[Surya Kusumakar-2]

Hi Carlos,

There is one more issue on Commission Run screen, the Commission invoice
which is shown on Commission Run screen is actually Sales Invoice (Sales
Order one) with Paid status, but it should be Commission Invoice with In
Process status. There is some bug in code, Commission Invoice is actually
not getting created.

--
Thanks & Regards
Surya Kusumakar

On Sat, Aug 27, 2011 at 8:29 PM, cguZZman <[hidden email]> wrote:

> Hans, Surya thanks for you response.
>
> Surya, I follow your points and I can see the invoces now.
> but when I select an invoice and select the action Commision Run and clic
> the Run button, I get this error:
> org.ofbiz.webapp.control.RequestHandlerException: Unknown request
> [processCommissionRun]; this request does not exist or cannot be called
> directly.
>
> I saw the code of the controller of accounting and really it does not
> exist.
> I'm using ofbiz 10.4.
> then I saw the trunk version of the controller and yes, there does exist.
>
> looks like I need to move to the trunk version.
>
>
> Surya Kusumakar-2 wrote:
> >
> > Hello Carlos,
> >
> > If you want to create automatic Commission invoice, you need to take care
> > of
> > these points :
> >
> > 1. Sales Order should have been placed by selecting additional
> > party(Person)
> > from the Additional Party page.
> > 2. Sales Order should be completed and invoice should be in Paid status.
> > 3. Role for additional party should be Sales Representative.
> > 4. Commission Agreement should exist for the product(s) added in order
> > w.r.t
> > the additional party.
> >
> > Once you run all these point you will be able to search Commission
> Invoice
> > in Commission Run screen.
> >
> > You can refer these links as example :
> >
> > 1. Sales Order using DemoRepAll as Sales Representative :
> >
> https://demo-trunk.ofbiz.apache.org:8443/ordermgr/control/orderview?orderId=WSCO10011
> .
> >
> > 2. Commission Agreement :
> >
> https://demo-trunk.ofbiz.apache.org:8443/ap/control/EditAgreement?agreementId=9000
> >
> > 3. Commission Invoice (Commission Run screen) :
> > https://demo-trunk.ofbiz.apache.org:8443/ap/control/CommissionRun
> >
> > HTH
> >
> > --
> > Regards
> > Surya Kusumakar
> >
>
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773092.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[cguZZman]

Hi Surya,

I saw that, and I thought the commission invoice would create when the button "Run" is pressed.
so, what does the button "Run"?
I can't get this button do something because of the error above.

[Surya Kusumakar-2]

Hi Carlos,

Sorry for the confusion, yes Run button actually creates Commission Invoice
against the Sales Invoice, but it is not working on Trunk as well. The
purpose Run button is to create Commission Invoice in In Process status
against the Paid Sales Invoice.

--
Thanks & Regards
Surya Kusumakar

On Sat, Aug 27, 2011 at 9:05 PM, cguZZman <[hidden email]> wrote:

> Hi Surya,
>
> I saw that, and I thought the commission invoice would create when the
> button "Run" is pressed.
> so, what does the button "Run"?
> I can't get this button do something because of the error above.
>
> --
> View this message in context:
> http://ofbiz.135035.n4.nabble.com/Automatic-Creation-of-Commission-Invoice-tp3769941p3773157.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

[cguZZman]

Hi Surya,
Thanks for the info. I will install Trunk version anyway and see what is
going on and try to fix it. This feature is almost critical to use ofbiz
in my bussiness.
thank you and I will give news later.


El 27/08/2011 11:53 a.m., Surya Kusumakar escribió:
> Hi Carlos,
>
> Sorry for the confusion, yes Run button actually creates Commission Invoice
> against the Sales Invoice, but it is not working on Trunk as well. The
> purpose Run button is to create Commission Invoice in In Process status
> against the Paid Sales Invoice.
>

[BJ Freeman]

you will find he answer in
\applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml
and
InvoicesServices.createCommissionInvoices

I run it as a scheduled service.

Carlos Guzman sent the following on 8/27/2011 10:21 AM:

> Hi Surya,
> Thanks for the info. I will install Trunk version anyway and see what is
> going on and try to fix it. This feature is almost critical to use ofbiz
> in my bussiness.
> thank you and I will give news later.
>
>
> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió:
>> Hi Carlos,
>>
>> Sorry for the confusion, yes Run button actually creates Commission
>> Invoice
>> against the Sales Invoice, but it is not working on Trunk as well. The
>> purpose Run button is to create Commission Invoice in In Process status
>> against the Paid Sales Invoice.
>>
>

[cguZZman]

Hello BJ, thanks for you response.
Please, tell us how you get it working?
what should we do?



El 27/08/2011 01:05 p.m., BJ Freeman escribió:

> you will find he answer in
> \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml
> and
> InvoicesServices.createCommissionInvoices
>
> I run it as a scheduled service.
>
> Carlos Guzman sent the following on 8/27/2011 10:21 AM:
>> Hi Surya,
>> Thanks for the info. I will install Trunk version anyway and see what is
>> going on and try to fix it. This feature is almost critical to use ofbiz
>> in my bussiness.
>> thank you and I will give news later.
>>
>>
>> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió:
>>> Hi Carlos,
>>>
>>> Sorry for the confusion, yes Run button actually creates Commission
>>> Invoice
>>> against the Sales Invoice, but it is not working on Trunk as well. The
>>> purpose Run button is to create Commission Invoice in In Process status
>>> against the Paid Sales Invoice.
>>>

[BJ Freeman]

you will have to modify the sample code for affiliates commissions if
you want to use that.
I suggest you read the InvoicesServices.createCommissionInvoices to
understand what has to be completed to run the service.

you can go to webtools and find the service then setup the scheduled run
from there. you can look at the code that run the service in the
webtools to complete the code for the page.

if you want it automatic schedules service then use one of the current
code as a template.


Carlos Guzman sent the following on 8/27/2011 11:18 AM:

> Hello BJ, thanks for you response.
> Please, tell us how you get it working?
> what should we do?
>
>
>
> El 27/08/2011 01:05 p.m., BJ Freeman escribió:
>> you will find he answer in
>> \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml
>>
>> and
>> InvoicesServices.createCommissionInvoices
>>
>> I run it as a scheduled service.
>>
>> Carlos Guzman sent the following on 8/27/2011 10:21 AM:
>>> Hi Surya,
>>> Thanks for the info. I will install Trunk version anyway and see what is
>>> going on and try to fix it. This feature is almost critical to use ofbiz
>>> in my bussiness.
>>> thank you and I will give news later.
>>>
>>>
>>> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió:
>>>> Hi Carlos,
>>>>
>>>> Sorry for the confusion, yes Run button actually creates Commission
>>>> Invoice
>>>> against the Sales Invoice, but it is not working on Trunk as well. The
>>>> purpose Run button is to create Commission Invoice in In Process status
>>>> against the Paid Sales Invoice.
>>>>
>

[BJ Freeman]

here is a jira that may be of interest
https://issues.apache.org/jira/browse/OFBIZ-2713

Carlos Guzman sent the following on 8/27/2011 11:18 AM:

> Hello BJ, thanks for you response.
> Please, tell us how you get it working?
> what should we do?
>
>
>
> El 27/08/2011 01:05 p.m., BJ Freeman escribió:
>> you will find he answer in
>> \applications\accounting\script\org\ofbiz\accounting\invoice\SampleCommissionServices.xml
>>
>> and
>> InvoicesServices.createCommissionInvoices
>>
>> I run it as a scheduled service.
>>
>> Carlos Guzman sent the following on 8/27/2011 10:21 AM:
>>> Hi Surya,
>>> Thanks for the info. I will install Trunk version anyway and see what is
>>> going on and try to fix it. This feature is almost critical to use ofbiz
>>> in my bussiness.
>>> thank you and I will give news later.
>>>
>>>
>>> El 27/08/2011 11:53 a.m., Surya Kusumakar escribió:
>>>> Hi Carlos,
>>>>
>>>> Sorry for the confusion, yes Run button actually creates Commission
>>>> Invoice
>>>> against the Sales Invoice, but it is not working on Trunk as well. The
>>>> purpose Run button is to create Commission Invoice in In Process status
>>>> against the Paid Sales Invoice.
>>>>
>