report

[lunchbox88]

I'm looking for a report that will show all of the following: within a date range, grouped by product; total $ for orders placed (invoiced or not)and total $ for invoiced orders.

Do any of the standard reports cover this, or is it a custom report?

Thanks!

 

[jazgeek]

custom crystal report with a view to combine both open and historical orders. I've done one here by currency in a table format by month. Works well and is much faster than printing out the 2-3 reports required with standard gp reports.

-----------
and they wonder why they call it Great Pains!

jaz

 

[lunchbox88]

So I'd need to bring in SOP10100, SOP10200, SOP30200, SOP30300, IV00101, RM00101, and RM20101, right?

Union on SOP10100 and SOP30200. What else am I missing?

 

[jazgeek]

just SOP10100 10200 30200 30300 IV is not needed and neither are the RM tables.

here's what I use

CREATE VIEW dbo.DASHBOARD
AS
SELECT SOPTYPE, SOPNUMBE, DOCDATE, SALSTERR, SLPRSNID, COMMAMNT, OCOMMAMT, (DOCAMNT + TRDISAMT + FRTAMNT) AS AMT,
(ORDOCAMT + ORTDISAM + ORFRTAMT) AS OAMT, CURNCYID
FROM SOP30200
WHERE VOIDSTTS = 0
UNION
SELECT SOPTYPE, SOPNUMBE, DOCDATE, SALSTERR, SLPRSNID, COMMAMNT, OCOMMAMT, (DOCAMNT + TRDISAMT + FRTAMNT) AS AMT,
(ORDOCAMT + ORTDISAM + ORFRTAMT) AS OAMT, CURNCYID
FROM SOP10100
WHERE VOIDSTTS = 0





-----------
and they wonder why they call it Great Pains!

jaz

 

[jazgeek]

just re-read. you'll have to adjust the view to get details for your product grouping. As I mentioned above, I only break out by currency.



-----------
and they wonder why they call it Great Pains!

jaz