News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How to create a po fro...

Microsoft Dynamics RMS (Archived)

How to create a po from one supplier and many departments

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I cannot find a way to create a PO based on 1 supplier and multiple departments. I tried the following but they don't work.

Department Name = Dept1

OR Department Name = Dept2

OR Department Name = Dept3

AND Supplier Name = Supplier1

and

(Department Name = Dept1

OR Department Name = Dept2

OR Department Name = Dept3)

AND Supplier Name = Supplier1

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to create a po from one supplier and many departments

The OR is what will separate the logic. DEPT1 AND SUP1 OR DEPT2 AND SUP1 OR DEPT3 AND SUP1

Give that a shot on the filter.
Suggested answer

eliud mugo 1,440 on at

Like (0)

Report

RE: How to create a po from one supplier and many departments

Try:

generate purchase order based on items sold between the following dates

filter as follows

supplier name=x

and department name=a

or department name=b

or department name=c

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,214 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans