ISTech Support Forum - IN-A Shipments

cellis

Full Member

Posts: 190

IN-A Shipments - Calculate Totals
03/11/14 at 08:22:46

In DBA there is a function where you could select a date range in the Shipments screen of the IN-A and have it calculate a total.

We are currently using EVO and I don't see that as an option so I've been logging out of EVO and logging into DBA for this feature. Is there an alternative in EVO or is there any possibility of getting that feature added to the EVO??

Back to top

Carrie Ellis

EVO 2020.3
DBA since 1996

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: IN-A Shipments - Calculate Totals Reply #1 - 03/11/14 at 11:02:20 There is a little calculator button on the top of the IN-A shipments grid that will calculate for the fields defined in Queries - SU-A as total fields. You can also use the filter function (funnel button on the upper left) to define a date range.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

cellis

Full Member

Posts: 190

Re: IN-A Shipments - Calculate Totals
Reply #2 - 09/19/14 at 13:19:33

Are there any instructions how to enter a date range? The only thing that shows up when I click the "funnel" is the word "maintenance" If I click on that I get a box that I don't know what to do with and the calculator only totals the entire history. Do I have to write some sort of program to use date ranges? If so, is there any kind soul who will help a girl out?

Back to top

Carrie Ellis

EVO 2020.3
DBA since 1996

IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: IN-A Shipments - Calculate Totals Reply #3 - 09/19/14 at 14:02:54 What do you want to calculate? A date range total value shipped? Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

cellis Full Member Posts: 190	Re: IN-A Shipments - Calculate Totals Reply #4 - 09/22/14 at 05:12:01 Yes exactly. I want to be able to tell the computer to add up the total number of widgets shipped from date A to date B. As far as I can tell, the calculator only adds up 1 year back from the current date exactly.
Back to top	Carrie Ellis EVO 2020.3 DBA since 1996 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: IN-A Shipments - Calculate Totals Reply #5 - 09/22/14 at 07:06:46 I guess the IN-E report can be modify. The part and date range are there, and S - for Shipments Or you can go to DE-A and enter this: SELECT SUM(MTIT_QTY) AS TT FROM INVTXN WHERE MTIT_DATE >= '2012-01-01' and MTIT_DATE <= '2012-12-31' AND MTIT_CODE = 'MY PART ID' AND MTIT_TYPE = 'S'; Same result. Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

cellis

Full Member

Posts: 190

Re: IN-A Shipments - Calculate Totals
Reply #6 - 09/22/14 at 07:18:13

I mis-posted earlier. The calculator totals ALL shipped and the USAGE button reports 365 days backward from the current date. I guess I'll try using the report forms. I'm just not understanding the function of the "filter" button This is what I see when I choose "maintenance" from the drop down menu (it is the only option)

Ok, I would show you, but I can't figure out how to add a screenshot to this box.

Back to top

Carrie Ellis

EVO 2020.3
DBA since 1996

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5681	Re: IN-A Shipments - Calculate Totals Reply #7 - 09/22/14 at 07:29:37 After selecting Maintenance, choose Edit and in the case of shipments selecting a date range, you want AND BKAR.INVL.ASD > {date 1} AND BKAR.INVL.ASD < {date 2} and apply. You can save the filter and then bring it up in the future and Edit and enter a new date range.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: IN-A Shipments - Calculate Totals Reply #8 - 09/22/14 at 07:31:31 Lynn, Save your filter and share it with the forum. Anyone that wants to use it, can just save it on his/her C:\ISTS Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

cellis Full Member Posts: 190	Re: IN-A Shipments - Calculate Totals Reply #9 - 09/22/14 at 08:02:18 Sorry, Kellogg. I didn't mean to make you angry. I very much appreciate your help!
Back to top	Carrie Ellis EVO 2020.3 DBA since 1996 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: IN-A Shipments - Calculate Totals Reply #10 - 09/22/14 at 08:14:21 I am not angry. It is always a pleasure to help here. I am trying to create a filter but, it does not work, the date save as "01/01/1" Maybe Lynn or some else has better luck and can share it !!! Kelloggs
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

Kelloggs

Active Member

Do crazy people know
they are crazy?

Posts: 785
Gender: male

Re: IN-A Shipments - Calculate Totals
Reply #11 - 09/22/14 at 12:37:33

Actually this is a better sql query

SELECT
YEAR(MTIT_DATE) as SalesYear,
MONTH(MTIT_DATE) as SalesMonth,
SUM(MTIT_QTY) AS TotalSales
FROM INVTXN WHERE MTIT_DATE >= '2013-01-01' and MTIT_DATE <= '2013-12-31' AND MTIT_CODE = 'PART ID HERE' AND MTIT_TYPE = 'S'
GROUP BY YEAR(MTIT_DATE), MONTH(MTIT_DATE)
ORDER BY YEAR(MTIT_DATE), MONTH(MTIT_DATE);

Grin

Kelloggs

Back to top

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

IP Logged

cellis Full Member Posts: 190	Re: IN-A Shipments - Calculate Totals Reply #12 - 09/22/14 at 13:17:21 Awesome! Now what do I do with that? Save as a text file or do I type that into the box that pops up?
Back to top	Carrie Ellis EVO 2020.3 DBA since 1996 IP Logged

Kelloggs Active Member Do crazy people know they are crazy? Posts: 785 Gender:	Re: IN-A Shipments - Calculate Totals Reply #13 - 09/22/14 at 13:33:45 Go to System Mgr Open DE-A Paste the query, change the part id, and dates and click on "Execute" if you don't have that menu go to System Mrg Open UT-A and enter: SQLEXPORT.RWN Kelloggs PD: This is not a filter. I gave up on them long time ago. This is sql query. They work better, faster....
Back to top	Evo ERP - 35 Users Dumped MS Access like a hot potato (VB.Net rules!!!) IP Logged

cellis Full Member Posts: 190	Re: IN-A Shipments - Calculate Totals Reply #14 - 09/23/14 at 05:04:37 Perfect!! Thank you so much!!
Back to top	Carrie Ellis EVO 2020.3 DBA since 1996 IP Logged