Finance | Project Operations, Human Resources, ...

How to fetch warehouse address

(0) Share

Report

Posted on by ax.tech

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

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Martin Dráb 237,976 Most Valuable Professional on at

Like (1)

Report

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).

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (1)

Report

Hi,

Check whether the below blog helps you.

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

Thanks,

Girish S.

Was this reply helpful? Yes No