Getting the translated name for a document type

[josedvm]

Hi,

I have a requirement where I need to get a string representing the document type name (e.g. Sales Order, A/R Invoice, etc.) based on the document's or business partner's language. We want to use it in reports and add-ons.

In SAP BO's GUI, for instance, I can see Delivery (English) or Entrega (Spanish).

My question is, are these strings stored in SAP Database in a way I can get the correct one based on document's object type and a language code?

I read in another question these strings are stored in C:\Program Files (x86)\sap\SAP Business One\GUI, but these are binary files.

We would like to avoid, if possible, having a SQL table/function/procedure with the handwritten, translated names for different document types.

SAP BO version: SAP Business One 9.2 (9.20.160) PL: 06 (32-bit)

Regards.

[Johan_Hakkesteegt]

Hi José,

All descriptions in the GUI are stored in files. One file for each language. If you look around on the forum, there is information on how to implement your own language file, but I don't think that is what you are asking.

An add-on that runs in he B1 client, will automatically assume the client's language. In add-ons that you run outside the B1 client (for example console apps) you can set the language that you want the program to return (error) messages in, with the company object in the DI API. I am not sure if you can get the DI API to return a document object's description though.

"We would like to avoid, if possible, having a SQL table/function/procedure with the handwritten, translated names for different document types."

For reports / queries, a database table would actually be the easiest to incorporate into a query. Alternatively a user defined sql function (don't know if you can set these up in HANA) could perform the same task. Input the document code, and a language code, and have it return the given document description in the required language.

Regards,

Johan

[josedvm]

Hi Johan,

Thanks for your help, it is my first question here but your avatar is already familiar to me from reading other questions 😉

It seems that there was no luck, then. If we can't open the language files and there is no place in SAP database where these strings are stored to get them localized, I guess we shall create create a User Defined Function like you say.

This has some additional pros (additional logic, customizable strings) but is a shame we lose the built-in support for so many different languages.

We don't know any way to get these descriptions using the DI API, neither.

I will keep open this answer until someone can say a categorical Yes or No about getting these descriptions localized using the resources included in the SAP BO (and its SDK).