Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Query Using Posted Pur...
Small and medium business | Business Central, N...
Unanswered

Query Using Posted Purchase Invoice & Posted Purchase Credit Memo Tables

(0) ShareShare
ReportReport
Posted on by CU11011222-0
Hi,
 
I want to create a query object in which data must be from Post.Pur.Inv Table & from Post.Pur.Crm Table,
 
Is it possible , if not then if i create two separate queries can i combine them in temp table ? 

please help me understand this concept
Categories:
Dynamics 365 Business Central
  • Suggested answer
    Alexander Drogin Profile Picture
    Alexander Drogin 83 on at
    Query Using Posted Purchase Invoice & Posted Purchase Credit Memo Tables
    This would a UNION statement in SQL, and unions are not supported in BC queries. So yes, you need to create two separate queries and process results separately or insert into a temporary table.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,338 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans