D365 Finance & Operations and Dynamics AX Forum

 View Only
  • 1.  In which table is the Invoice email address stored?

    TOP CONTRIBUTOR
    Posted 28 days ago
    We need to manually update a customer's invoice email address because it ends in ".construction" (which is valid), and the UI is throwing an error when the user tries to enter it because the RegEx only allows for 9 characters at the end of the email address.  We can change the RegEx so it will allow the entire word "construction", but due to a big project we won't have a code release for at least 2 months.  In the meantime we need to manually update the customer's invoice email address via SQL.  Any idea which table stores that info?

         

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------


  • 2.  RE: In which table is the Invoice email address stored?

    MICROSOFT MVP
    Posted 27 days ago
    Rudy,

    I'm not sure how to navigate to that page within AX but can you right click on the email field and go to Personalize? This will show you the information where this data is being pulled from.


    My guess would be in either the DirPartyTable or the LogisticsElectronicAddress tables as this is where email information is normally stored.

    ------------------------------
    Alex Meyer
    Director of Microsoft Software Development
    Fastpath
    Des Moines, IA
    ------------------------------



  • 3.  RE: In which table is the Invoice email address stored?

    TOP CONTRIBUTOR
    Posted 23 days ago
    @Alex Meyer  Before I tried tracing the origin of the email address thru code, I looked for the current "To" email address in the LogisticsElectronicAddress table but couldn't find it.  And unfortunately there aren't any email addresses stored in the DirPartyTable.  Personalizing the SRSPrintDestinationSettingsForm shows that "MailTo" is the form control name for the "To" email addr.



    Unfortunately I'm having trouble tracing it back thru the code to determine the table that contains the value that populates that field.

    I think we may have had a similar situation many years ago where we needed to manually update an invoice email addr via SQL, and at that time I thought that we were able to trace it back to a table used for Print Management destination settings that stored the email addresses.  I can't remember for sure, but I believe we discovered that the Print Management destination settings email addresses are stored in encrypted format, so even if I'm able to trace it back to that table and find the record with the current "To" email addr, I may not be able to update it to the new email addr via SQL.

    @Mara Taylor  Thanks for your input.  The real issue is that the AX 2012 R2 UI for print destination settings is throwing the "Email address not valid error" because the RegEx used to validate the format of the email address is not allowing email addresses that end in ".construction" because that's greater than the 9 characters that the RegEx currently allows.  The user gets the error when trying to enter the new email addr ending in ".construction".  So we were hoping to manually update the email addr via SQL, but are having trouble determining the table where the current email addr is stored.​​

    ------------------------------
    Rudy Salcedo
    Senior Programmer/Analyst
    LaForce, Inc
    Green Bay WI
    ------------------------------



  • 4.  RE: In which table is the Invoice email address stored?

    Posted 21 days ago
    Edited by Kern Herron 21 days ago

    Hi Rudy, at least for our D365 environment (so probably this messages is unhelpful) but I tracked down the print managment "DESTINATIONEMAILTO" based on @Mara Taylor 's screenshot, maybe a similar query can help you hone in on the tables you need in your 2012 R2 environment.

    Looked for tables with printmanagement in name from INFORMATION_SCHEMA.COLUMNS

    SELECT TABLE_NAME, COLUMN_NAME,DATA_TYPE,CHARACTER_MAXIMUM_LENGTH FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME like '%PrintManagement%'

    The options  I had in D365 were PrintManagementDestinationEmailV2Staging and PrintManagementDestinationEmailStaging (empty)


    Then to find the record of the print managment setting based on customer account rec ID:

    select * from PrintManagementDestinationEmailV2Staging where referencedrecid in  (*RECID of account*)

    row TABLE_NAME COLUMN_NAME DATA_TYPE CHARACTER_MAXIMUM_LENGTH
    1 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DEFINITIONGROUP nvarchar 60
    2 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING EXECUTIONID nvarchar 90
    3 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING ISSELECTED int 0
    4 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING TRANSFERSTATUS int 0
    5 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DATAAREA nvarchar 4
    6 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING NODETYPE int 0
    7 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DOCUMENTTYPE int 0
    8 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DOCUMENTNAME nvarchar 40
    9 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DOCUMENTPRIORITYID numeric 0
    10 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DESTINATIONEMAILTO nvarchar -1
    11 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING DESTINATIONEMAILCC nvarchar -1
    12 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING REFERENCEDRECID bigint 0
    13 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING REFERENCEDTABLEID int 0
    14 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING PRINTSETTINGDESCRIPTION nvarchar 60
    15 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING PRINTSETTINGPRIORITYID numeric 0
    16 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING PARTITION bigint 0
    17 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING RECID bigint 0
    18 PRINTMANAGEMENTDESTINATIONEMAILV2STAGING RECVERSION int 0

    ​​​​

    ------------------------------
    Kern Herron
    Kent Water Sports Holdings, LLC
    New London OH
    ------------------------------



  • 5.  RE: In which table is the Invoice email address stored?

    SILVER CONTRIBUTOR
    Posted 24 days ago
    The email address can be found in All Customer/General /Print management, that is where you go to manually add or delete email - and then click the Invoice and go to the default setting and open that up you can just click in the main screen, see second screenshot


    ------------------------------
    Mara Taylor
    Credit Manager
    Kent Water Sports Holdings, LLC
    Snoqualmie WA
    ------------------------------



  • 6.  RE: In which table is the Invoice email address stored?

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Below is a screen shot of what table it is in...




    ------------------------------
    Mara Taylor
    Credit Manager
    Kent Water Sports Holdings, LLC
    Snoqualmie WA
    ------------------------------



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