Macola ES Booking Report 1

[dustcollector]

Hello - We have upgraded to Macola ES from Progression (with Esynergy) in Feb. and have just upgraded again to ES Batch 360.

Has anyone had trouble with the integrated Crystal booking report not working and/or showing incorrect totals.

Also has anyone ever wrote a successful SQL query to show booked orders but would also include orders that were booked and invoiced on the same day? I have been experimenting but I think I have a join problem with the query. Appreciate any help.

 

[kscheeler]

A true bookings report would show you orders taken and also changed/deleted in the month that it happened. This would require you to read the audit trail report. However, because Macola's report shows you the before and after on two seperate rows, it's difficult to match them up to see the net change.

What you need to do is your own trigger that tracks any insert, change and delete that affects the value of the order. That means you need to track changes to the quantity ordered and unit price fields. You may also include the discount field if that's important to you. You would be creating your own audit table and only writing to it if the value of the order changes. Since it's your own table, you can include any field that you want and therefore create crystal reports off it that meet your needs.

I posted a trigger that tracks changes in the unit price field on a previous thread which should get you started.

Kevin Scheeler

 

[crystalreporting]

This earlier post contains a SQL statement to give you open and posted (invoiced) orders:

http://www.tek-tips.com/viewthread.cfm?qid=1021309

Peter Shirley

http://www.linkcorp.com

 

[dustcollector]

Thanks for the help - I can run this in both SQL and Crystal correct?

I am getting the following error in my SQL query:

Server: Msg 8157, Level 16, State 1, Procedure orders, Line 3
All the queries in a query expression containing a UNION operator must have the same number of expressions in their select lists.

Any Ideas?

 

[crystalreporting]

The example creates a view. Open Query Analyzer and connect to the database where you want the view created. You'll need to use 'Edit/Replace' to replace [data_42] with your database name. When you execute the query, it will create the view.

The view should then be available to you in Crystal.

Peter Shirley

http://www.srhconsulting.com

 

[pronet74]

We have ES 360 and having major problems with crystal reports. At first they were trying to blame us. Bullshit! Just because they couldn't 'duplicate' the problem. It wasn't until I went under the customer portal and did some research. Found out 3 other companies are having similar problems. Once I brought that to their attention then they admitted that there were problems.

I am SO pissed at them. I am having major problems with order acknowledgements.

 

[dustcollector]

Pronet74 - I am in complete agreement with you! Everytime they can't duplicate the problem they blame the customer.

What are the problems you are having with order acknowledgements?

 

[stravis]

This problem with the order acknowledgements is resolved in the current release of batch 360. This was resolved a few weeks ago in an interim release prior this latest release that is supposed to fix even more report issues in 360.

Scott Travis

http://www.infoSpring,

LLC.

 

[abaldwin]

Scott, I am going to quote you but am not intending to bust your chops.

The core problem with ES can be seen, when a very knowledgable guy can make the following statment.

"This problem with the order acknowledgements is resolved in the current release of batch 360. This was resolved a few weeks ago in an interim release prior this latest release that is supposed to fix even more report issues in 360."

The lastes release of an intermim release of a permanent release of the most current release of an already fixed release that was broken by an unknown release". Jeez when will they simply start testing in a real world environment before releasing a release or an intermim release and mistaking it for a permanent release or removing the release from the permanent release so it does not appear to be an interim release.



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[pronet74]

Wrong. The latest patch that I put on (this past Monday) has NOT fixed the issues. At least not at our company. Half the time we get the ExactApp error message when trying to print an order acknowledgement, the other half of the time it'll show on the screen but have to print in A4 paper. We tried all the work arounds and it only works when it wants too. Reports are still extremely slow as well.

When we went from Progression to 340 we couldn't use scanning for a week! They had to rush code into 360 and we had to upgrade then. We are a distribution company so you could only imagine the nightmare I had. They should have told me this way before! I can't believe they would have the conscious to allow companies to use a piece of software where the WMS package does not work.