ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> General DBA Topics >> report that includes SO#, Inv#, Inv Class, & Item
http://www.istechforum.com/YaBB.pl?num=1317048466

Message started by Laura Oliver on 09/26/11 at 07:47:46

Title: report that includes SO#, Inv#, Inv Class, & Item
Post by Laura Oliver on 09/26/11 at 07:47:46

Is there a report that will give me (1) SO# (2) Inv# (3) Inventory class and (4) inventory item.

All-in-one Report .... that includes (1) SO# (2) Inv# (3) Inventory class and (4) inventory item

Can I go to System manager DE-A and choose GLX and get a report?
I can kinda get it in Sales Analaysis but i dont think those reports show Sales order#

Thanks,
Laura

Title: Re: report that includes SO#, Inv#, Inv Class, & I
Post by carie on 12/09/11 at 13:23:07

You should be able to use Sales Analaysis - just edit the RTM to have the SO number included.

Title: Re: report that includes SO#, Inv#, Inv Class, & I
Post by ddlong on 12/12/11 at 14:54:33

Which report do you suggest. I think a lot of the reports for that module are the "canned" reports that don't let you select an RTM. Please let me know if I am wrong about that, as we would also like to be able to add the Sales Order to those reports.

Darla Long

Title: Re: report that includes SO#, Inv#, Inv Class, & I
Post by Kelloggs on 12/12/11 at 15:39:20

Another option:

SELECT
BKARHINV.BKAR_INV_NUM,
BKARHINV.BKAR_INV_SONUM,
BKARHIVL.BKAR_INVL_PCODE,
BKICMSTR.BKIC_PROD_CLASS
FROM (BKARHINV INNER JOIN BKARHIVL ON BKARHINV.BKAR_INV_NUM = BKARHIVL.BKAR_INVL_INVNM)
INNER JOIN BKICMSTR ON BKARHIVL.BKAR_INVL_PCODE = BKICMSTR.BKIC_PROD_CODE

This query will pull the information of SO that have been shipped (Well, with DBA tables structure you never now)

Anyways, here ya go!!!

:P

Kelloggs

Title: Re: report that includes SO#, Inv#, Inv Class, & I
Post by TwinOaks on 03/07/12 at 14:23:18

I was reading about this report and wondering what or where is the Sales Analysis report?

Title: Re: report that includes SO#, Inv#, Inv Class, & I
Post by Lynn_Pantic on 03/08/12 at 08:19:52

SA-M if you want line item detail, SA-N if you just want invoice totals and SA-O (Evo-ERP only) if you want a comparison by customer of this year nad last year.