5
Hi,
How do I generate a PO line items report that will also show me the vendor, item, quantities and cost in Dynamics 365 Business Central?
For both open and closed purchase orders.
Thank you!
Hi Lytt here I will suggest you three places that can solve your problem
But what I think you can do is which can help you
To generate a PO line items report that shows the vendor, item, quantities, and cost in Dynamics 365 Business Central for both open and closed purchase orders, you can follow these steps:
Go to the "Purchase Orders" page in Dynamics 365 Business Central.
Click on the "Navigate" button in the ribbon, then select "Reports" and "Purchase Orders - Line."
In the "Purchase Orders - Line" report, select the following filters:
"Document Status" = All
"Order Date" = All
"Posting Date" = All
"Document Type" = Order
Click on the "Preview" button to generate the report.
In the report preview, you will see a list of all the line items for all open and closed purchase orders, with the vendor, entity, quantities, and cost information.
You can refine the report by adding additional filters or grouping the data by vendor or item, for example, by using the "Modify Report" option.
Once you have customized the report to your liking, you can either print it or export it to a file format such as Excel or PDF for further analysis or sharing with others.
plus you can also visit https://globaldata365.com/jet-reports/ to solve your problem easily
Hi MahGah,
thanks for the pointers. I will take some time to go through designer tutorials and yzhums documentation. He is a valued member and great contributor in this community.
Cheers
Anthony
Hi anthonychew
In this case you need to use Designer. See below
Hi all,
We are using a dropshipment order as our main business model. I would like to check if it is possible to add the sales order number in the purchase order screen and also purchase order number in the sales order screen.
I can see the fields in the page inspection at the line items table but unable to find them using personalised function.
Thanks,
Hello,
One other idea to generate the data you are looking for is Jet Reports.
Here is a sample of a report:
Thanks,
Steve
Hi Iytt
I had no issue today. But I saw many articles with the same issue. Can you
1) Click on web service in BC and see if you can access it direct?
2) Try on another computer?
3) Delete the Web Service for 5168 in BC. Then republish it again
4) After publish and before connecting to Excel click on the link and open it in browser
#1
André Arnaud de Cal...
291,622
Super User 2024 Season 2
#2
Martin Dráb
230,354
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
