web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) I need one smartlist r...

Microsoft Dynamics GP (Archived)

I need one smartlist report please guide me

(0) Share

Report

Report

Posted on by Community Member

Monthly Reports

Number of POs created
Total number of line items on POs created for the month
Value of POs created
Number of orders received
Total number of line items received for the month
Number of orders received in warehouse vs. direct orders
Receiving Lag for orders received in the warehouse (This is the time it takes Purchasing to receive an order from the time it is received in the warehouse)
Cycle Time (Measure the time from placing an order to invoicing the order)
Core group of P/N we manage – In other words, can we get a report on which parts are ordered with more frequency
Vendors that get top 20% spend
The above requirement which table have that fields any body can guide me how to design the reports

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Redbeard 12,931 on at

Like (0)

Report
Copy link

Link copied!

Number of PO's Created would best be built starting with the Purchasing > Purchase Orders Folder. You can add columns using the Column button. The columns are named in full text, and can be searched. Once you've added the columns save the SmartList to a Favorite using the Favorites button, so the columns remain available when prior to building you search. Now use the search button to restrict the output to the criteria you desire.

Similarly orders received can be analyzed in the Sales Transaction.

The Lines for orders and purchase orders can be found in the Sales Line Items and Purchase Line Items respectively.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans