DoliCloud / SellYourSaas

Sell-Your-Saas is an Open Source solution to automate and sell any Web application as a SaaS service
https://www.sellyoursaas.org
GNU General Public License v3.0
220 stars 76 forks source link

Detail invoice or update product desc (not only quantity) #299

Open rycks opened 1 year ago

rycks commented 1 year ago

There are some situations where we need to put more details on invoices.

On product details we can put a formula to get quantity to update it before invoicing, that's great but not enought.

For example i would like to update product details like that.

Before:

image

My wish:

image

Yes i can do it by myself just before sending invoices to customer but that's not the magic of full automatic sellyoursaas system ;)

rycks commented 1 year ago

Hello, there is "$newcommentonqty" in sellyoursaas code, is that solution for this feature request ?

eldy commented 1 year ago

Hello, there is "$newcommentonqty" in sellyoursaas code, is that solution for this feature request ?

I think so. In the method sellyoursaasRemoteAction(), it updates the qty but also a comment into an extrafields on each lines of the recurring invoice. For the moment, ability to return a couple nb+comment instead of just a number, is supported only for the formulae SQL:... The select must be "SELECT ... as nb, ... as comment FROM ..."

The comment will be saved into an extrafield of the contract (only 1 comment for all services lines is possible). It is also copied into an extrafield of the template invoice and will be shown on the generated invoice.