Thanks so much for replying! I will start looking into accomplishing this using crystal. We were hoping for an "out of the box" solution (since we always had that with Vantage 5.2), but if we have to create it, then I better get going :)Â
On Fri, Feb 27, 2015 at 10:59 AM, 'Vic Drecchio' vic.drecchio@... [vantage] <vantage@yahoogroups.com> wrote:Â<div> <p><div><p class="ygrps-yiv-1788951588MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt;">Sarah this is doable and I’ve done it many times. I use scheduled BAQ Exports and then use Crystal to hit the exported data files and use “bucket style†reporting within Crystal to analyze each record and drop the values in the appropriate Last Year or Cur Year columns.  If you are a SQL customer then it’s even easier to accomplish with SQL Views and then hit the SQL View with Crystal.<u></u><u></u></span></p><p class="ygrps-yiv-1788951588MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt;"><u></u> <u></u></span></p><div><div style="padding:3pt 0in 0in;border-top-color:rgb(225,225,225);border-top-width:1pt;border-top-style:solid;"><p class="ygrps-yiv-1788951588MsoNormal"><b><span style="font-size:11pt;">From:</span></b><span style="font-size:11pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [mailto:<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>] <br><b>Sent:</b> Friday, February 27, 2015 10:53 AM<br><b>To:</b> Vantage List<br><b>Subject:</b> Re: [Vantage] Epicor 9/05.702A financial report writer - consolidated company<u></u><u></u></span></p></div></div><div><div class="ygrps-yiv-1788951588h5"><p class="ygrps-yiv-1788951588MsoNormal"><u></u> <u></u></p><p class="ygrps-yiv-1788951588MsoNormal"> <u></u><u></u></p><div><div><div><div><p class="ygrps-yiv-1788951588MsoNormal">Hi everyone - I didn't get any responses to this so I am just wondering what everyone else with multiple companies on Epicor is using to get combined financial statements with prior years data? At this point we just need a solution... any feedback on what others are using would be greatly appreciated. Thanks!<u></u><u></u></p></div><div><p class="ygrps-yiv-1788951588MsoNormal"><u></u> <u></u></p><div><p class="ygrps-yiv-1788951588MsoNormal">On Thu, Jan 29, 2015 at 9:33 AM, Vareschi, Sarah <<a rel="nofollow" target="_blank" href="mailto:Sarah.Vareschi@...">Sarah.Vareschi@...</a>> wrote:<u></u><u></u></p><blockquote style="padding:0in;margin-top:5pt;margin-bottom:5pt;border-left-color:rgb(204,204,204);border-left-width:1pt;border-left-style:solid;"><div><div><p class="ygrps-yiv-1788951588MsoNormal">Sorry for beating a dead horse – but I need to ask again…  Is anyone out there using Epicor on multiple companies and using a separate consolidated company to report financial statements of the other companies combined? If so, are you able to report current and prior years numbers in same report?<u></u><u></u></p><p class="ygrps-yiv-1788951588MsoNormal"> <u></u><u></u></p><p class="ygrps-yiv-1788951588MsoNormal">We always had this ability in Vantage (prior to our upgrade) and now they are telling us it is not possible in Epicor 9 without the “advanced report writerâ€. Hoping someone else is successfully doing it in the std financial report writer in consolidated companies?<b><span style="color:rgb(23,54,93);"> </span></b><u></u><u></u></p><p class="ygrps-yiv-1788951588MsoNormal"><b><span style="color:rgb(23,54,93);"> </span></b><u></u><u></u></p><p class="ygrps-yiv-1788951588MsoNormal"><b><span style="color:rgb(23,54,93);">Any Advice or Help would be so greatly appreciated.</span></b><u></u><u></u></p><p class="ygrps-yiv-1788951588MsoNormal"> <u></u><u></u></p></div></div></blockquote></div><p class="ygrps-yiv-1788951588MsoNormal"><br><br clear="all"><br>-- <u></u><u></u></p><div><div><p style="margin:0in;"><a rel="nofollow" name="14bcbc4e8d95b20e_SafeHtmlFilter__MailAutoSig"><b><span style="color:rgb(23,54,93);">Sarah Vareschi </span></b></a><b><span style="color:rgb(23,54,93);font-size:9pt;">â–ª</span></b><b><span style="color:rgb(23,54,93);font-size:9pt;"> </span></b><b><span style="color:gray;">Systems Manager</span></b><b><span style="color:rgb(23,54,93);font-size:9pt;"> </span></b><u></u><u></u></p><p style="margin:0in;"><b><span style="color:rgb(23,54,93);font-size:8pt;"> </span></b><u></u><u></u></p><p style="margin:0in;"><b><span style="color:rgb(23,54,93);font-size:10pt;font-variant:small-caps;">NyproMold, Inc.</span></b><span style="color:rgb(23,54,93);font-size:8pt;"> </span><u></u><u></u></p><p style="margin:0in;"><span style="color:gray;font-size:9pt;">144 Pleasant St, Clinton, MA 01510</span><b><span style="color:rgb(23,54,93);font-size:9pt;"> </span></b><b><span style="color:rgb(23,54,93);font-size:9pt;">â–ª</span></b><b><span style="color:rgb(23,54,93);font-size:9pt;"> </span></b><a rel="nofollow" target="_blank" href="http://www.nypromold.com/"><span style="color:rgb(23,54,93);font-size:9pt;">www.nypromold.com</span></a><span style="color:rgb(31,73,125);font-size:9pt;">  </span><u></u><u></u></p><p style="margin:0in;"><span style="color:gray;font-size:9pt;">D <a rel="nofollow">978.368.4718</a></span><b><span style="color:rgb(23,54,93);font-size:9pt;"> </span></b><b><span style="color:rgb(23,54,93);font-size:9pt;">â–ª</span></b><span style="color:gray;font-size:9pt;"> F <a rel="nofollow">978.365.4548</a></span><u></u><u></u></p><p style="margin:0in;"><span style="color:gray;font-size:9pt;"> </span><u></u><u></u></p><p style="margin:0in;"><span style="color:gray;font-size:9pt;"> </span><u></u><u></u></p><p style="margin:0in;"><span style="color:gray;font-size:9pt;"> </span><u></u><u></u></p><p style="margin:0in;"><i><span style="color:black;font-size:8pt;">This e-mail may contain information which is confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, be aware that any disclosure, copying, distribution or use of the contents of this e-mail is prohibited. In the event of any error in transmission, unauthorized recipients are requested to contact the sender immediately and not to disclose or make use of this information. No employee or agent is authorized to conclude any binding agreement on behalf of NyproMold with another party by email without express written confirmation by NyproMold Offices.</span></i><u></u><u></u></p><p style="margin:0in;"><span style="color:rgb(79,98,40);font-family:Webdings;font-size:18pt;">P<i> </i></span><i><span style="color:rgb(79,98,40);font-size:8pt;">Please consider the environmental impact of printing this e-mail.</span></i><u></u><u></u></p></div></div></div></div><div><p class="ygrps-yiv-1788951588MsoNormal"><span style="color:white;"><u></u><u></u></span></p></div></div></div></div></div></div><p></p> </div> <div style="color:rgb(255,255,255);min-height:0px;"></div>
--Sarah Vareschi ▪ Systems ManagerÂ
Â
NyproMold, Inc.
144 Pleasant St, Clinton, MA 01510 ▪ www.nypromold.com Â
D 978.368.4718Â â–ª F 978.365.4548
Â
Â
Â
This e-mail may contain information which is
confidential or privileged. The information is intended to be for the use of
the individual or entity named above. If you are not the intended
recipient, be aware that any disclosure, copying, distribution or use of the
contents of this e-mail is prohibited. In the event of any error in
transmission, unauthorized recipients are requested to contact the sender
immediately and not to disclose or make use of this information. No
employee or agent is authorized to conclude any binding agreement on behalf of
NyproMold with another party by email without express written confirmation by
NyproMold Offices.P Please consider the environmental impact of
printing this e-mail.