search

YetiForceCompany / YetiForceCRM

Our team created for you one of the most innovative CRM systems that supports mainly business processes and allows for customization according to your needs. Be ahead of your competition and implement YetiForce!
https://yetiforce.com
Other
1.74k stars 749 forks source link

[Question] Customizing quotes and invoice #12056

Closed gkArvindr closed 5 years ago

gkArvindr commented 5 years ago

I tried searching the git closed and googled for how to create custom invoice and quotes but was not successful. can someone direct to the link how to do use variable and with the using concept behind it.

davide-alghi commented 5 years ago

Hi, here to customize invoice https://gitstable.yetiforce.com/index.php?module=LayoutEditor&parent=Settings&view=Index&sourceModule=FInvoice

here for quote https://gitstable.yetiforce.com/index.php?module=LayoutEditor&parent=Settings&view=Index&sourceModule=SQuotes

gkArvindr commented 5 years ago

@Davide Algh, thanks for the reply, I know how to customize fields, I want the syntax concepts of calling the fields to create customize template for pdf, which is in html format .

example "accountid" is a field and this is how it is represented $(relatedRecord : accountid|addresslevel8a|Accounts)$ in the example template.

While creating custom template I getting stuck with limited information, one is call custom, other translate : Other.PD.

I want to know

  1. list of fields like relatedRecord, record etc
  2. the concept behind the syntax followed to call the fields in the template to create pdf.
gkArvindr commented 5 years ago

Untitled

How do I bring this fields in to pdf template

rskrzypczak commented 5 years ago

you can use the variable in your pdf template image

or use this image

then you'll see image

mariuszkrzaczkowski commented 5 years ago

or

$(inventory : type=table columns=name,qty,price href=yes)$
$(inventory : type=table columns=seq,name,qty,unit,price,total,net href=no)$
gkArvindr commented 5 years ago

I still find it difficult is there a workflow diagram somewere, i will write the help doc for this once I am successful and share the same

gkArvindr commented 5 years ago

1574234708.pdf

I got the data, but header labels are showing variables instead of actual names

gkArvindr commented 5 years ago

Screenshot from 2019-11-20 13-19-32

vovpff commented 5 years ago

@gkArvindr looks like your template language has no translation for columns labels.

gkArvindr commented 5 years ago

Screenshot from 2019-11-20 16-32-20 I am not getting the dynamic template, where could be I going wrong

gkArvindr commented 5 years ago

@vovpff where should i check for it. please update

gkArvindr commented 5 years ago

@rskrzypczak can you help me, i dont see the dynamic template,

vovpff commented 5 years ago

@gkArvindr for dynamic template image For language try to change template language at first step of pdf template params.Try different languages

gkArvindr commented 5 years ago

@vovpff I tried with other lang, the status is the same, it shows only variable not the translated language

vovpff commented 5 years ago

Try other variables for products table. maybe this variable broken...

gkArvindr commented 5 years ago

Screenshot from 2019-11-20 18-08-53 I tried with sale invoice, the same issue.

gkArvindr commented 5 years ago

@vovpff I also updated the language files just to ensure

mariuszkrzaczkowski commented 5 years ago

did you set the language in the PDF template?

gkArvindr commented 5 years ago

yes I did to en_US and again tried fr_FR, and it is plain installation via Softaculous, so installation should be pretty standard

gkArvindr commented 5 years ago

Screenshot from 2019-11-20 18-24-09

Screen shot for your reference

gkArvindr commented 5 years ago

@mariuszkrzaczkowski In Parallel I install a new by downloading the latest version all the titles displayed perfectly , as soon as i create a custom pdf template, the language translate stopped working, I deleted the created custom pdf template, still the language translate stopped working. does it give you any clue

gkArvindr commented 5 years ago

I was able to produce the same issue again and again

gkArvindr commented 5 years ago

@mariuszkrzaczkowski @vovpff I experimented with many options, I reinstalled the whole application 3 times, now I feel the when creating custom pdf the language factor is not passing to while processing pdf file, it there anyway I can check to find out why it happens to custom pdf , something very specific to "translate" command

$(translate : Other.PDF|LBL_DEALER)$
gkArvindr commented 5 years ago

@mariuszkrzaczkowski @vovpff

I had a doubt that it was not saving language , i checked the table Table: a_yf_pdf and it was well saved , Screenshot from 2019-11-21 08-33-33

Hence it seem's only when the custom pdf is being generated the language parameter is not passed to pdf processing module

rskrzypczak commented 5 years ago

so check your language settings (try to modify) and global language settings. image image

gkArvindr commented 5 years ago

Screenshot from 2019-11-21 11-04-01 Screenshot from 2019-11-21 11-04-28

I think that's not a issue

gkArvindr commented 5 years ago

Screenshot from 2019-11-21 11-09-22 Pdf after ensuring all languages are set, I think it is when modified somewhere the language parameter is getting passed to pdf processed lies the issues bug.

mariuszkrzaczkowski commented 5 years ago

Attach a screenshot of the server configuration

mariuszkrzaczkowski commented 5 years ago

you have wrong language code image

hobejeans commented 4 years ago

I had the same issue for months. I changed the Language to en-US in the language field all my PDF templates and now they are working perfectly. I opened MySql/a_yf_pdf/ edit template then scroll down to the language field and change to en-US. Thank you