Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

(0) ShareShare
ReportReport
Posted on by 20

Hi All,

In My scenario user created a warehouse and deleted again to create newly. But the deleted warehouse address is printing in invoice copy of transfer order

In the attachment To Warehouse address Name is showing correctly as mysore but the address is showing the deleted warehouse address(Hyderabad,Gachibowli)'

it Is happening for all the invoices.

when i have gone through the code the address is coming from logisticspostaladdress table with relation to the inventtransferjour table topostaladdress column

Please help me to fix this issue.

i want the Mysore address to be displayed in the invoice copy.

Warehouseaddress.PNG

  • Suggested answer
    nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    Looking at the code, InventTransferJour.ToPostalAddress is initialized frmo InventTransferTable.ToPostalAddress (this is done in method "initFromInventTransferTable" of InventTransferJour table.

    Was the transfer order (InventTransferTable) created before 10th of October?

    If not, and you get the wrong address even in InventTransferTable, you need to look how that field is initialized.

    InventTransferTable.ToPostalAddress is initialized in method "initToAddress" of InventTransferTable.

    There you can also see that it takes the Delivery address for the selected "To" warehouse. Perhaps you can still double check the warehouse address setup. Is the new address marked as Delivery address? Can you still see the old address in the warehouse address list?

    Debug the initToAddress method if needed to understand what happens when the value is initialized.

  • Shiva Mantri Profile Picture
    20 on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    transfer Orders were created after 10th October.

    I want to know how can I get the correct address for the invoices(even if it is for the invoices that I am going to create from now) instead of picking the old address.

  • nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    And when were the transfer orders created? Most likely the invoice initializes this information from there.

  • Shiva Mantri Profile Picture
    20 on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    No.

    Lets say old warehouse("ABC") was deletaded on 10th october and new warehouse("ABC") with different was created on same day 10th october. So for me wrong address(old address) is getting captured for all the invoices whatever generated after 10th october.

  • nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    You said "newly created invoice copies". If you print a copy of an old invoice, you will see the original address.

  • Shiva Mantri Profile Picture
    20 on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    Hi Nikolaos

    Even For new invoices also the deleted address is showing.

    My user deleted a warehouse "ABC" with Address "Hyderabad,Gachibowli". After that he created a new warehouse with the SAME OLD NAME ("ABC") and with new address "Mysore".

    But in all the newly created invoice copies also the old address ("Hyderabad,Gachibowli") is coming.

    Thanks for your reply.

  • Suggested answer
    nmaenpaa Profile Picture
    101,158 Moderator on at
    RE: How the data comes to inventtransferjour.ToPostalAddress column in AX 2012 R3

    If you delete an address, usually it's not really deleted, it's marked as inactive. So the address data still stays there.

    It's important because actually all old orders, invoices etc which were using that address must still show the old address.

    This means that it's expected that your old orders will still show the old address. Only orders that are created after the new address was created will use the new address.

    In your screenshot you show an invoice. I assume that this invoice was created before the address was changed. Is this correct? 

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,217 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,978 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans