Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Match Shipments to Invoice Inquiry Zoom - Does equivalent report exist?

Posted on by 1,325

I have a received a request to provide a report that essentially includes the same information that is on the Match Shipments to Invoice Inquiry Zoom window. Our plan is to implement matching of purchase receipts to invoices for landed costs and one of our users wants a report that would list the individual landed costs for each item. I do not find such a report in Smartlist or GP canned reports. I am new to GP and tried to create such a report using Report Writer. As best as I can tell Report Writer does not provide a means or interface (like what is used for Smartlist reports or GP canned reports) for users to enter data selection criteria outside of entering constants in the report restriction definition. My understanding is the the tables listed below are used in the Match Shipments to Invoice Inquiry Zoom application. I could an SQL report, but that would require someone from IT to execute it when the user needs it. They need a report that they can execute on their own.

GL00100 –  Distribution Account Master

IV00103 – Item Vendor Master

POP10500 – Purchasing Receipt Line Quantities

POP10310 –  Purchasing Receipt Line

POP30310 – Purchasing Receipt Line History

POP10600 – Purchasing Shipment Invoice Apply

 

So I have two questions. Does a GP canned report exist that provides the same type of information that exists in Match Shipments to Invoice Inquiry Zoom? Is there a way for users to enter record selection criteria other than entering constants in the report restriction definitions for a custom report that is built with Report Writer?

 

Thank you.

*This post is locked for comments

  • Larry Turner Profile Picture
    Larry Turner 1,325 on at
    Re: Match Shipments to Invoice Inquiry Zoom - Does equivalent report exist?

    Richard and Frank, Thank you for your suggestions. We do have SSRS up and running and we will pursue that tool as a solution.

    Thank you,

    Larry

  • Verified answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 4,029 Super User 2024 Season 2 on at
    Re: Match Shipments to Invoice Inquiry Zoom - Does equivalent report exist?

    In addition to Richard's excellent suggestion, another option would be Crystal reports.  

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Match Shipments to Invoice Inquiry Zoom - Does equivalent report exist?

    Do you have SSRS up and running? You could deploy the report there and then users would just run it on their own. I am currently working on a similar script and that is how I will be deploying it.

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans