Dynamics 365 CommunityForums Microsoft Dynamics SL (Archived) Sales Journal Print Re...

Sales Journal Print Records

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, we are using SL2011. We recently discovered that sometimes while we run a Sales Journal report, it never came out of the printer due to some PC/network/printer bug. To keep a track of what got printed we want to create a Crystal report showing Sales Journal Ids and Date of Print against each ID, and then group them by Date Range.

Can you identify for us the data sources ie. database fields to create such a report. Thanks.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Mark E 6,405 on at

Like (0)

Report

RE: Sales Journal Print Records

Try this:

SELECT DISTINCT(ShipRegisterID), MAX(LUpd_DateTime) AS LUpd_DateTime

FROM SOShipHeader WHERE

ShipRegisterID <> '' AND LUpd_Prog = '40690'

GROUP BY ShipRegisterID, LUpd_DateTime

ORDER BY ShipRegisterID