Open Forum

Expand all | Collapse all

Custom Report Layout. Sales Invoice. Missing Currency or I cannot find it? Code

  • 1.  Custom Report Layout. Sales Invoice. Missing Currency or I cannot find it? Code

    Posted 20 days ago
      |   view attached
    The posted sales invoice header table has the currency code field.
    i am editing in WORD the custom report layout sales invoice Report ID 1306.
    When I activate the XML Mapping in word when using report ID 1306 the currency code field does not appear when examing the list of fields and labels available under the ??


    The urn for standard sales invoice is where I do not see the currency code field...is this a bug or is the currency code field misnamed??


    ------------------------------
    David Cameron
    Microsoft Financial Consultant
    Templer Group
    ANCASTER ON
    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Custom Report Layout. Sales Invoice. Missing Currency or I cannot find it? Code

    GOLD CONTRIBUTOR
    Posted 20 days ago
    David,
    Maybe I am not remembering this correctly but Isn't that set on the Customer Card? Would that then make it a flow field? If you go to the table and look at the Sales Line you are right the field is there, but drilling in opens the Currency Code table. So this then makes me question why it is blank. I am second guessing myself now. I want to say that in one of my past employers it was left as blank and defaulted to USD but then again it could have been a mod.


    ------------------------------
    Troy Harkness
    Miller Baking Company
    Milwaukee, WI
    ------------------------------

    Academy - Online Interactive Learning from Experts


  • 3.  RE: Custom Report Layout. Sales Invoice. Missing Currency or I cannot find it? Code

    Posted 20 days ago
    Hi Troy,  I forgot to mention I am using B.C. in the cloud.   In the word editor for the report ID the currency code field does not show up in the ur for the sales invoice header or line tables.   I could make an extension or a workaround is that  I know that the currency is exposed via the TotalText, but it is not the "currency code" but the "currency symbol" that is actual used. So the text shows as "Total $". Not very useful is you are doing business in Canada, US, Australia,... I could change the symbol to the currency code, but that is rather dirty.

    The extension and workaround are listed below:
    https://community.dynamics.com/business/f/dynamics-365-business-central-forum/279456/adding-currency-on-word-custom-report-layout-invoice


    ------------------------------
    David Cameron
    Microsoft Financial Consultant
    Templer Group
    ANCASTER ON
    ------------------------------

    Academy - Online Interactive Learning from Experts


If you've found this thread useful, dive deeper into User Group community content by role