ISTech Support Forum - report that includes SO#, Inv#, Inv Class, & Item

Welcome, Guest. Please Login.

	05/13/24 at 04:50:19 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › General DBA Topics

‹ Previous topic | Next topic ›

Pages: 1

report that includes SO#, Inv#, Inv Class, & Item (Read 2127 times)

Laura Oliver

Active Member

Posts: 984
Gender: female

report that includes SO#, Inv#, Inv Class, & Item
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

Laura D. Oliver
classic DBA since 1997
EVO on Amazon server as of 5-2022
DIXIE PRECISION INC.
Birmingham, Alabama
(205)- 841-8400

www.dixieprecision.com

IP Logged

carie Full Member Posts: 209 Gender:	Re: report that includes SO#, Inv#, Inv Class, & I Reply #1 - 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.
Back to top	Evo-ERP Version 2015.2 with Build 7/02/2015 Pervasive 11.3 - 10 licenses / DBA since 2002 Carie Kirk McDantim Inc Helena, Montana IP Logged

ddlong Full Member Posts: 205 Gender:	Re: report that includes SO#, Inv#, Inv Class, & I Reply #2 - 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
Back to top	Darla Long Catalytic Industrial Group, Inc. Independence Ks dba 2004.1 client/server EVO Version 2020.0 08/07/20 Build Pervasive 11.3 IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: report that includes SO#, Inv#, Inv Class, & I
Reply #3 - 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!!!

Tongue

Kelloggs

Evo ERP - 35 Users
Dumped MS Access like a hot potato (VB.Net rules!!!)

IP Logged

TwinOaks Member I Love EvoERP! Posts: 83 Gender:	Re: report that includes SO#, Inv#, Inv Class, & I Reply #4 - 03/07/12 at 14:23:18 I was reading about this report and wondering what or where is the Sales Analysis report?
Back to top	Camille Twin Oaks Industries 4+Yr User of EVO 2013.4 Latest Update IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: report that includes SO#, Inv#, Inv Class, & I Reply #5 - 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.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › General DBA Topics

‹ Previous topic | Next topic ›