Solved

Why the Date format is different when printing invoice and attaching invoice by "Notification template”?

  • 20 February 2021
  • 6 replies
  • 38 views
R
Rank
Userlevel 4
Badge

Hello，

     For the SO643000.rpx, we are using Acumatica original logic to display the Date and Due date as below:

         It shows properly when print the invoice on the screen directly.

          However, when we are using “Notification template” to attach this report and email it to customers.
      It shows 2 and 3 instead of Feb and Mar, 

     Which we does not understand.

    because the rpx is exactly the same one

      Can somebody help me?
     

 

icon

Best answer by Gabriel Michaud 23 February 2021, 19:09

你好 Ray,

It will probably best to file a support case with them to ensure it gets escalated to engineering.

Regards,

View original

6 replies

Gabriel Michaud
Rank
Userlevel 5
Badge +3

@ray20 that explains it -- MMM will be a 3 letter abbreviation of the month name (at least for languages using latin script). For Chinese this probably gets outputted as 2月 instead of Feb.

By using MM your are only going to get two digits, which works around the issue you have :)

谢谢

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
R
Rank
Userlevel 4
Badge

@Gabriel Michaud ,   Thank Gabriel, your Chinese is great.:grinning:
I did submit a case.
Somehow,    I  just changed the data format in the invoice rpx from "dd-MMM-yyyy" to "MM/dd/yyyy".
And in this way, we get rid of this issue.

Gabriel Michaud
Rank
Userlevel 5
Badge +3

你好 Ray,

It will probably best to file a support case with them to ensure it gets escalated to engineering.

Regards,

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica
R
Rank
Userlevel 4
Badge

Hello,
    I’ve researched on some materials.
It might be our Acumatica is installed on a Chinese version Windows and .net framework.

Acumatica can handle it when printing from Screen.
There might be something missing when print behind the screen (in attachment way).

     If it can be a quick fix, I hope Acumatica devlopment team can enhance it.

    Also, to save others time, I can change the format in SO643000
from dd-MMM-YYYY
to  MM/dd/yyyy
then I can get rid of characters.

R
Rank
Userlevel 4
Badge

Hello  @Gabriel Michaud 
  Thank you for giving me the right direction. It does have something to do with the “Locales”/”Multiple Languages”. But I was not able to solve the problem.

      I tried the combinations of Admin’s locale and report localizable setting.

      It makes no difference.

      Which shows “Feb” when printing directly

     shows “2” when attaching to template.

   

 

      By the way, the “2” is actually “2月” with the Chinese characters “月” missing when choosing “Arial” as the font，if chossing Microsoft Yahei as the Font, people would see the “月”, which means “Month” in English.

 

      So the question turns to

Why format “MMM” is tranlated to English Format when printing directly on page

while “MMM” is translated to Chinese Format when attaching.

Gabriel Michaud
Rank
Userlevel 5
Badge +3

Hi @ray20,

I noticed Chinese in your report designer screenshot -- have you configured additional system locales/languages in Acumatica on the login screen?

If you’re using a scheduled process to run notifications it will run under the locale format configured for the admin user in the User Profile screen (SM.20.30.10):

 

Please verify this, as it might explain the issue you’re seeing...

Gabriel Michaud Founder @ Velixo, Excel-based reporting for Acumatica

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved