Language field on the invoice/Sales order

SUGGESTED

Hi,

We are trying to tag invoices with options so we can use them to pull data on a specific report. On the sales order your have a option called "Language". We are looking to use this field, however how can we add more options to the language drop down so we can use it. Please advise.

Thanks,

FAHAD

  • 0

    It will not be a direct answer on your question. From my experience, it is not a very good way to use system standard fields for other purpose. Sooner or later it will cause some misfunctionality.

    How about invoice type or project? Did you looked in that direction? They are very flexible to create and customize.

  • 0 in reply to Girts Mazais

    Hi Girts,

    How would I go about doing that?

  • 0 in reply to Ancient Nutrition
    SUGGESTED

    No sure what the output is needed. As I understand there can be 2 purpose:

    - to collect data in Sage for later use in inquiries and reports. 
    - to get specific crystal report , based on values, which are chosen when order/invoice is being printed(managed at crystal report).

    In first case - it is possible to create more invoice/order types - depend on your need (it can become more complex if there is big variation of them).

    In second - create in misc tables new menu (for tests I used 15000). It will allows enter your criteria (dropdown choice entries) in misc table entries. After add custom field to your report definition (Development>Scrip Dictionary>Reports>[your report code]) like "ordering" and assign created misc table code - variable type ADI, menu = 15000 (or yours), value type = Single, Ent="Yes" on your choice default value can be assigned. In such way, it will be possible to get user specified value(possible to chose from values of misc table entry 15000). Rest - will be needed to make modifications in Crystal report. 

  • 0 in reply to Girts Mazais

    This is for th first option you mentioned. It will be used to just tag Sales orders. Do you know a method I can create the field and use that to tag the information?