• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 705
  • Last Modified:

Sage 50 accounting crystal reports addition

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.
  • 2
2 Solutions
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
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).
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Forgot to mention: if your main report is restricted to another date range, then use the approach above inside a subreport linked on ItemID.
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now