Order Status Report

[vbajock]

I cannot get Open Order dollars from an Access report I wrote to agree with the Macola Open Order Status/All Report. I am simply summing OEORDLIN On Order Qty * Unit Price, Restricting it to ORDER_TYPE="O". I assumed this should agree with the bottom line total on the Macola report, but it never does.

If any one can tell me why, I would appreciate it.
Thanks
Kirk

 

[dgillz]

You need to account for discount percentages as follows:

QtyOnOrder*UnitPrice*(1-DiscPct) Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[vbajock]

Thank you O great Macola swami! That was it.

 

[dgillz]

You owe me Kirk!

How about a Macola consulting project somewhere?

:}

Don

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[vbajock]

Most of the work I am running into is add-ons to existing systems where the VARs have pretty much completed their work. Everyone in this area is waiting for the economy to turn around before investing in new systems, but I think that may finally be happening. I will be glad to keep you posted if anything comes my way.