web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How the data comes to ...
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 Shiva Mantri 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

I have the same question (0)
  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,162 Moderator on at

    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? 

  • Shiva Mantri Profile Picture
    Shiva Mantri 20 on at

    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.

  • nmaenpaa Profile Picture
    nmaenpaa 101,162 Moderator on at

    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
    Shiva Mantri 20 on at

    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
    nmaenpaa 101,162 Moderator on at

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

  • Shiva Mantri Profile Picture
    Shiva Mantri 20 on at

    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.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,162 Moderator on at

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans