1,260
Hi,
I am using Dynamics AX 2012 R3, and there is a requirement to update the retailtransaction report in SSRS. I am asked to show the store address in the report whereas the report already has store number and store name which is retrieved from Retail transaction table.
How can I extract store address for the same as there is no direct link with retail transaction table?
*This post is locked for comments
Mauro,
I need to retrieve from the store address from business unit (Retail Channel). How am I suppose to do this?
The relation I have is
RetailTransactionTable.LogisticsPostalAddress == LogisticsPostalAddress.Recid.
How am I suppose to show the value of Address from the LogisticsPostalAddress?
Hi D,
It all depends on where did you save the store address. Usually, the store address sits on the Warehouse associated with the store, but I've heard of companies that save the store address on the Business unit (Retail channel) table.
So... given that you already have the Store number, get the Warehouse number or Business unit number and retrieve the address from there, depending on the case.
Regards, Mauro.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (