Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / sales invoice report i...
Finance | Project Operations, Human Resources, ...
Suggested answer

sales invoice report in both english and Japanese language

(0) ShareShare
ReportReport
Posted on by @rp@n 5,901

Hi all,

i am working on Sales Invoice report for Japan legal entity. So, that what i did...

1. i have duplicate all classes ( DP, Contract and Controller ) for Sales Invoice report.

2. I have create a new report for sales Invoice for Japan with new Format ( SalesInvoice_JA.Report) .

Now my questions is

1. i need to set my report format in Print management for LEGAL ENTITY JAPAN ?

LIKE SalesInvoice_JA.Report

is it rite?

prntmgmt.jpg

2. Customer give us Japan report format for Sales Invoice.

Customer wants the report in BOTH languages ( EN-US or JA) for ONE customer , then what kind of customization is required?

In Japanese i need to print

Customer name

Address

Delivery address etc...

for example  -- i need to create 1 more column in table for customer name for Japanese ? 

Please give me more shed on this.

Thanks!

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: sales invoice report in both english and Japanese language

    Hi @rp@n,

    From a legal perspective it is not allowed to make changes (manipulations) to an already generated invoice.

    However, you can always reprint copies of 'old' / existing invoices.

    What I referred to as invoice designs is illustrated in the screenprint below. 

    That is, you can have a default report layout that follows your US regulations and a second layout that follow Japanese regulations and is always printed in Japanese language. 

    If you setup your print management in a similar way and provided that your report design follows the different rules in US/Japan, you should always get a US and Japanese invoice once you create a new invoice document. 

    Note: The screenprint illustrates one possibility only how two invoice designs can be used in parallel. Depending on what you want exactly, there might be alternative ways to get this setup. 

    Best regards, 

    Ludwig

    lan2.png

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: sales invoice report in both english and Japanese language

    As Ludwig said

    'your report design there must be a reference to the language field that is setup for your customer in the customer master table.

    Based on this selection the report will print either in English or Japanese."

    Please let me know how I will set reference in report design? as Ludwig said

    Please give me more shed on this 

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: sales invoice report in both english and Japanese language

    Hi @rp@n,

    If you have access to D365 instance you can compare SalesInvoiceController class (method runPrintMgmt). In D365 it's possible to change the language of invoice layout, but it's done by changing the value for the language field in invoice record.

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: sales invoice report in both english and Japanese language

    Hi @rp@n,

    Standard printout is quite tight to the languageId field from custInvoiceJour (use find option by text for classes SalesInvoiceDP and SalesInvoiceController by lanuageId value). Out of the box, you can print only in one language specified in the field on the journal level. With development and print management set up you can print in both languages.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: sales invoice report in both english and Japanese language

    that Nikoloas also said, if i am not wrong

    means always SO which is already ( invoiced ) can print in one language only either english or Japaneae not both. rite?

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: sales invoice report in both english and Japanese language

    Hi @rp@n,

    Language for invoice copied from customer record through sales order to invoice and fixed there. If you change the language for customer it will be applied only for new orders (invoices), but not for old ones.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: sales invoice report in both english and Japanese language

    hi Sergei,

    i have checked with Invoiced SO, which has before language en-us. it's printed in English. that it  is fine  then i changed to language JA in customer master then again print that SO but still it's printed in English not JA why?

  • Sergei Minozhenko Profile Picture
    Sergei Minozhenko 23,089 on at
    RE: sales invoice report in both english and Japanese language

    Hi @rp@n,

    You still can do modification to change the language on the invoice and print it again. Or you can add parameter to the print dialog to choose which language to use instead of language from invoice.

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: sales invoice report in both english and Japanese language

    hi Ludwig,

    sorry , i forgot the below discussion

    community.dynamics.com/.../invoice-delivery-note-and-receipt-new-report-format-for-japan-legal-entity

    as Nikoloas said ..

    "language of existing invoices can't be changed. And the invoice printout is using the language of the invoice.

    So, if you change the customer language and want to try the invoice printout with this new language, you need to create a new sales order and invoice. (You can change language of existing sales order and invoice it, too. But you can't change the language of existing invoices)."

    So, i can tell customer if the SO is invoiced with language "En-Us" that always printed in English only even if i changed the language in Customer but still it will print in English only because it's already invoiced.

    we need to create  a new SO& invoice and set langauge to customer JA then invoiced.

    then it will print in Japaneses language

    means always one SO ( invoiced ) can print in one language only  either english or Japaneae not both

    Kindly verify Nikoloas

  • @rp@n Profile Picture
    @rp@n 5,901 on at
    RE: sales invoice report in both english and Japanese language

    Thanks Ludwig,

    can you please let me know how i will make validation in report design tp print Japanese or English language based on customer master language setup?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans