Solved

Sage 50 accounting crystal reports addition

Posted on 2013-11-20
5
639 Views
Last Modified: 2014-01-10
I have a new client who uses Sage 50 accounting (peachtree) for their accounting and inventory control.  They have an existing custom crystal report (created by former IT provider that they no longer do business with) that they need to modify to add " quantity sold of items in past 12 months" to this existing report so they can utilize in their 2014 sales forecast reporting.

I do not have a lot of experience using crystal reports, so now sure how to go about getting this modification to their existing report completed.

Can anyone assist or provide any advise???

I provided a pdf example of the existing report that they want to add the " quantity sold of items in past 12 months" to.
Parameter-Screen-popup.jpg
Current-Order-Report-Example.pdf
0
Comment
Question by:resinate
  • 2
5 Comments
 
LVL 22

Expert Comment

by:Ido Millet
ID: 39665532
Add a formula such as:
IF {@Order_is_in_Last_12_Months} then {Qty} else 0
Then, SUM that formula by Item ID to provide the total sold in last 12 months.

For the {@Order_is_in_Last_12_Months} formula logic, depending on what is meant by that, you can use the DateDiff() or DateSerial() functions (see online help in Crystal).
0
 
LVL 22

Accepted Solution

by:
Ido Millet earned 250 total points
ID: 39665533
Forgot to mention: if your main report is restricted to another date range, then use the approach above inside a subreport linked on ItemID.
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 250 total points
ID: 39665757
AGree.  If you are looking at trying to use this year you can also use the YearToDate date range.

You can use a selection like
    {YourDateField} >= CurrentDate - 365

mlmcc
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now