Finance | Project Operations, Human Resources, ...

LogisticsPostalAddress table is not returning any data even it exists in DB

(4) Share

Report

Posted on by SA-20091232-0

Hi,

I'm facing an issue in Dynamics 365 FO, I have a query that returns data from LogisticsPostalAddress in SQL as well as on table browser I can see the record, but when I apply the X++ query I do not get any record. Following is the detail of the work I'm doing.

On Table browsing I can see the record by applying filter on recID

But when I apply Same query in X++ in runnable class I'm not getting the record.

Categories:

Microsoft Dynamics AX

All responses (9)

Answers (0)

Sort by

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved from MS Dynamics AX Form
Layan Jwei 8,421 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Use int642Str instead of int2Str

Also when u debug after selecting the buffer, can u see a value?

Thanks,
Layan Jweihan
Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi,

this is normal, since the “LogisticsPostalAddress” table contains validform and validto fields that prevent the selection of records
so you need to add validtimestate to the query.

Validfrom fromDate = 05\19\2023; ValidTo toDate = 09\09\2024; Select validtimestate(fromDate,toDate) * from LogisticsPostalAddress where LogisticsPostalAddress.RecId == 5642043649;

Best regards,

Mohamed Amine MAHMOUDI
SA-20091232-0 89 on at

Like (0)

Report
Copy link

Link copied!

Hi Mohamed Amine Mahmoudi,

I tried and I'm getting error in your suggested way of fetching data,

error is as follows:

1.

2.
Suggested answer

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi,

Try this :

LogisticsPostalAddress logisticsPostalAddress; TransDate fromDate, toDate; fromDate = str2Date("05/19/2023", 123); toDate = str2Date("09/09/2024", 123); Select validtimestate(fromDate,toDate) * from logisticsPostalAddress where logisticsPostalAddress.RecId == 5642043649;

Best regards,

Mohamed Amine MAHMOUDI
Suggested answer

Bharani Preetham Pe... 3,634 Moderator on at

Like (0)

Report
Copy link

Link copied!

When you say you are working with a runnable class, are you sure company parameter is added at the project level? Or do you have any parameter which mentions the current company?

And from your screenshot of table browser, I can see that the address got expired on 9th of september. In that case, this is obvious that FO doesn't show the record. You need to use valid time state key to get the right buffer.
Waed Ayyad 9,222 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad
Raj Borad 1,590 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Are you running the class in the same company which you set in the property of the project?
Waed Ayyad 9,222 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks
Waed Ayyad