ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Items >> IN-A Shipments - Calculate Totals
http://www.istechforum.com/YaBB.pl?num=1394551367

Message started by cellis on 03/11/14 at 08:22:46

Title: IN-A Shipments - Calculate Totals
Post by cellis on 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??

Title: Re: IN-A Shipments - Calculate Totals
Post by Lynn_Pantic on 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.

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 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?

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 09/19/14 at 14:02:54

What do you want to calculate?
A date range total value shipped?

:-?

Kelloggs

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 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.

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 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

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 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.

Title: Re: IN-A Shipments - Calculate Totals
Post by Lynn_Pantic on 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.

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 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

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 09/22/14 at 08:02:18

Sorry, Kellogg. I didn't mean to make you angry. I very much appreciate your help!

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 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 !!!

:D

Kelloggs

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 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);

;D

Kelloggs

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 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?

Title: Re: IN-A Shipments - Calculate Totals
Post by Kelloggs on 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

8-)

Kelloggs

PD: This is not a filter. I gave up on them long time ago.
This is sql query. They work better, faster....

Title: Re: IN-A Shipments - Calculate Totals
Post by cellis on 09/23/14 at 05:04:37

Perfect!! Thank you so much!! ;D