Hi Experts,
I need to add Product name in Sales invoice. In product tranlsation , I have added arabic name under language "Arabic(ar)".
Please help me.
Thanks,
Faiz
Hi Experts,
I need to add Product name in Sales invoice. In product tranlsation , I have added arabic name under language "Arabic(ar)".
Please help me.
Thanks,
Faiz
Hi faiz.
You're calling
EcoResProductTranslation::findByProductLanguage(this.itemId(_custInvoiceTrans),ar);
This method awaits 2 parameters :
- 1 product (refrecid)
- 1 languageid
And returns 1 object (EcoResProductTranslation)
So there are 3 problems in your code:
1) you give an itemid instead of a product
2) you give a variable name "ar" that has not been decleared instead of a languageid
3) You're not telling wich field of EcoResProductTranslation you want to put in your
salesInvoiceTmp.NameAR
So the proper way to call this method should be :
EcoResProductTranslation::findByProductLanguage(InventTable::find(this.itemId(_custInvoiceTrans)).product,"ar").Description));
Hi Experts,
Waiting for help.
Thanks,
Faiz
Hi Andre,
I tried using below code. Getting error "Variable has not been decleared".
salesInvoiceTmp.NameAR=EcoResProductTranslation::findByProductLanguage(this.itemId(_custInvoiceTrans),ar);
Please help me.
Thanks,
Faiz
Hi Andre,
How and which filter I have to apply for get "language=Arabic(ar)" with field "Product Name".
Because in Language there are Arabic and English.
Thank,
Faiz
HI Faiz,
If you want to concatenate values, you need to rerieve the Arabic name. You can find the record using the find() method on the EcoResProductTranslation table.
Hi Andre,
We are using customized report.
In data provider
salesInvoiceTmp.ItemDescription=_custInvoiceTrans.salesLine().itemName();
Through above code we are getting Product name. I want to include (concatenate) arabic name also. As in above screen shot, arabic name is fixed in "Product name" if language is selected "Arabic(ar)".
Both Sales order and Customer language is "en-us"
How to get Arabic text to Sales invoice report.
Hi Faiz,
Are you using the standard invoice report , data provider or do you have a custom report data provider?
What is the language selected on the customer and the sales order?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156