Solved

Sage 50 accounting crystal reports addition

Posted on 2013-11-20
5
649 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

792 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