News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Need help with Crystal...

Microsoft Dynamics GP (Archived)

Need help with Crystal reports and GP

(0) Share

Report

Report

Posted on by Bill Stoltz

95

I am attemmting to create a fairly simple report. One that can show total inventory sales for a specified period of time, selected by pricelevel, grouped by short name and sorted by volume. I have not been able to find a date stamp that allows my to specify a date range in the inventory tables. Is there a date I can use in the inventory tables to limit the sales quantities to a specfic time period or do I have to link this with a table somewhere else in GP?

I have though about using sales tables, but then I will loose the ability to select by pricelevel. Or is that the way I ought to go?

Thanks

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

Victoria Yudin 22,766 on at

Like (0)

Report

Re: Need help with Crystal reports and GP

Bill,

Can you please clarify what you mean by pricelevel? Is it the pricelevel that the item was sold for? Or something else that you track by item? That was the only thing I was not 100% clear on, but in either case, you are probably better off going to the sale tables. If you're using SOP, it should be SOP30300.

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans