Solved

Sage 50 accounting crystal reports addition

Posted on 2013-11-20
5
667 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 23

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 23

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 101

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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…
Hi, I've just fixed a problem with Sage 50 Accounts 2010 crashing when creating a new Company.  I've spent nearly 4 hours on it including three calls to the Sage helpdesk (they didn't work it out in the end - I did!) ... so I thought I'd share th…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

717 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