Sales Detail Report, By Ship To, in MM buckets

[Frosty the Coder]

The site currently has a WorldWriter over the Sales Summary table.
This table summarizes at the SOLD TO level into monthly buckets.

I've been asked for a similar report at the shipto level.
I've looked for, but haven't found, a vanilla report doing this.
Does one exist?

Please AND Thanks
Gene

 

[John Dickey]

Maybe one of these years your company will wise up and invest in a data war ehouse solution.=C2=A0 I could have something like this done and ready in a bout 15 minutes time.
John Dickey

 

[Frosty the Coder]

I'm just a hired-gun at a client site.

They don't believe in investing in ANYTHING.
All inventory movements are PEN AND PAPER,
there's no fax servers, no wireless, all PCs are several years old.....

 

[mgerritt]

Unfortunately John is correct. Without a datawarehouse your only option is to build the report yourself against the F4211(9). It's pretty simple using SQL (except of course you then need RPG to format the report and print it). Too bad JDE provides very limited SQL function in WW. You are not the only one lacking a warehouse though, John's fortunate to have the financial and staff to have built one.