Arabic and English words in one field in Sales invoice Report

(0) Share

Report

Posted on by Shabir Ahmad

3,110

Dear Experts,

We have 70 types of items in our inventory, I Customzied Sales invoice report , but one field in which i want to show these item names in English as well as in Arabic in one field. (For example if report shows item number (A(English anme /Arabic name) Help!

Thanks and Regards,

Shabir Ahmad

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report

Hi Shabir Ahmad!

You can try to use strfmt() function.

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Rustem Galiamov,

Thanks for reply, we have 70 items with English name already in name field but we also want to have that English names in name field with Arabic name(in one field = English Name item/ Arabic name Item). Hope, so you got my point.

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No
guk1964 10,888 on at

Like (2)

Report

Why does it need to be in one field?

Its much easier to search and sort if you keep these separate.

Ax supports multi language descriptions for items, and the language selected on standard reports will depend on the user. or trading partner default language.

However, I would add a new custom field for the translation. You can then call both to your report. Then its just matter of report layout. to put the two descriptions where you need.

You should be able to modify a report to concatentate two string fields into one at report level -I wouldn't but you could ( you don't want the printer to freak our trying to print L to R and R to L in the same field.)

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

magic 1949,

Thanks for your reply, i wrote a code , means a job please watch below:

static void arabicimport(Args _args)

{

int counter;

ArabicNameImport arabictable,arabictable1;

ItemId itemid;

prodid prodid,arabic;

ItemGroupId itemgroupid;

EcoResProduct itemidtable;

EcoResProductTranslation itemname;

container con = ["100", "أسيكال أقراص للمضغ",

"101", "أسيكال بلس أقراص للمضغ",

"102", "أملوكارد 5 ملجم أقراص",

"103", "أملوكارد 5 ملجم أقراص وزارة الصحة",

"104", "بيتازال مرهم 20 جم",

"105", "بيتازال مرهم 20 جم وزارة الصحة",

"106", "كلوتريزول أقراص مهبلية",

"107", "إكزاديرم كريم 30 جم",

"108", "إكزاديرم مرهم 30 جم",

"109", "إيفيت 400 كبسولات جيلاتينية رخوة",

"110", "إيفيت 400 كبسولات جيلاتينية رخوة وزارة الدفاع",

"111", "إيفيت 400 كبسولات جيلاتينية رخوة خليج",

"112", "إكزاديرم كريم 30 جم وزارة الصحة",

"115", "فيكسوتيل 120 ملجم أقراص",

"116", "فنجو كريم 20 جم",

"117", "فنجو كريم 20 جم وزارة الدفاع",

"118", " فوسيزون كريم 15 جم",

"119", "فيوسيزون كريم 15 جم وزارة الصحة",

"120", "فيوسيزون كريم 15 جم وزارة الداخلية",

"121", "جينكوجين 30 كبسولة",

"122", "ليدو مرهم 20 جم",

"123", "ليدو مرهم 20 جم وزارة الدفاع",

"124", "ليدو مرهم 20 جم خليج",

"125", "ليدو مرهم 20 جم وزارة الصحة",

"126", "ماكسيكال أقراص",

"127", "ماكسيكال أقراص وزارة الصحة (عمان)",

"128", "ميكولس كريم 20 جم",

"129", "بانتولوك 40 ملجم أقراص",

"130", "ريزينو شراب 100 مل",

"131", "رويال 1000 كبسولات جيلاتينية رخوة",

"132", "سيكنيد أقراص",

"133", "سوفوكيور أقراص",

"134", "ينيجنس كبسولات جيلاتينية رخوة",

"135", "ينيبروست أقراص 4 ملجم",

"136", "يونيتم جيل 20 جم",

"137", "يونيتم أخضر",

"138", "يونيزيم شراب 120 مل",

"139", "يونيزيم شراب 120 مل خليج"];

counter = 0;

while(Counter<=conLen(con))

{

counter++;

arabictable.itemid = conPeek(con,counter);

if(!arabictable.itemid )

break;

counter++;

arabictable.ArabicItemName = conPeek(con,counter);

select itemidtable where itemidtable.DisplayProductNumber == arabictable.itemid

join itemname where itemname.Product == itemidtable.RecId;

arabictable.ProdName = itemname.Name;

select arabictable1 where arabictable1.itemid ==arabictable.itemid;

if(!arabictable1)

arabictable.insert();

}

}

Was this reply helpful? Yes No
Shabir Ahmad 3,110 on at

Like (0)

Report

Dear Both,

I also create a table please check, is it possible, if the report take from both the sides means both the columns take data then show it in one field of name field on the report.

Thanks and Regards,

Shabir Ahmad

Was this reply helpful? Yes No
Suggested answer

Rustem Galiamov 8,072 on at

Like (1)

Report
Yes. As i suggested, you can try to use strfmt() function.

As example:

info(strfmt("%1/%2", ArabicNameImport.ProdName, ArabicNameImport.ArabicItemName));

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Shabir,

You can insert a new column in report design & write an expression to concatenate English name & Arabic name.

Hope it helps!!!

Was this reply helpful? Yes No