News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... How to fetch warehouse...

Finance | Project Operations, Human Resources, ...

Suggested answer

How to fetch warehouse address

(0) Share

Report

Report

Posted on by ax.tech

86

Hi Experts,

I want to display dynamic warehouse address (As there are multiple warehouses) attached to the warehouse present in the line of a movement journal in a ssrs report. right now we are fetch current company address as mentioned in below code. Can you please suggest what to do ?

select * from companyInfo
where companyInfo.RecId == CompanyInfo::current();

Thanks in advance waiting for your response

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

GirishS 27,832 Super User 2024 Season 1 on at

Like (1)

Report

How to fetch warehouse address

Hi,

Check whether the below blog helps you.

https://khadarmsdax.wordpress.com/2018/03/08/warehouse-address-x/

Thanks,

Girish S.
Suggested answer

Martin Dráb 230,235 Most Valuable Professional on at

Like (1)

Report

How to fetch warehouse address

A movement journal (table: InventJournalTable) has lines (table: InventJournalTrans). Each line has a reference to a set of inventory dimensions (table: InventDim), where you can find the warehouse (field: InventLocationId). Details of a warehouse can be found in InventLocation table and you can call its address() method to get the address (or look at its code to see tables and relations involved).

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans