Inventory on-hand values for a specific historical date

I have a Crystal Report that can do this. You might be able to apply the principles of this to a BAQ.

I start with the current on-hand quantity - taken from PartWhse.

Then I work backwards through the PartTran table - that's using TranDate in descending order - toting up TranQty for each entry occuring after the historical date I'm looking for. Note that you have to reverse the sign of TranQty on any "STK-CUS" entries.

I use subreports to accomplish the above. How you'd do it in a single BAQ, I don't know.


HTH,

Nigel.

--- In vantage@yahoogroups.com, Carey S <rotary1@...> wrote:
>
>
> I have a BAQ set up that basically takes all of the parts in the partmaster, and shows them , the on-hand quantities from the partWhse table, the costs from the PartCost table. This is ok. We can get it into Excel from here just fine. However, management wants to somehow get this data from two specific historic dates. Does anyone have something built, or a specific process for how to extract this data?
>
>
> Thanks
>
> Carey
>
> 803.404
>
>
>
> _________________________________________________________________
> Hotmail: Powerful Free email with security by Microsoft.
> http://clk.atdmt.com/GBL/go/201469230/direct/01/
>
> [Non-text portions of this message have been removed]
>
Good morning all. We went live to Vantage last July 2009. It's been working
out well for the most part however, our manufacturing teams and some of our
sales reps have had some performance issues due to long processing times of
various tasks. Our manufacturing teams experience a 4 minute delay to start
work queue and select a job to work -just one job.

Are there any specific settings on the Vantage server or client PC that can
be configured to decrease processing time as a user navigates and processes
jobs in Epicor? Please help!



Some additional information:



We are a small company with Vantage 8.03.408B

We have about 25 to 30 licensed PC users from sales to engineering and
manufacturing personal.

Our Vantage server has the following specifications:

Dell Server PE2900

Intel Xeon CPU

E5405 @ 2 GHz

2 GHz, 4 GB of Ram

370 GB Hard drive

Network bandwidth is 100 MB





Best Regards,



Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@...

607-754-9187 ext. 3078

www.ergpower.com











[Non-text portions of this message have been removed]
Server and network seem a little under powered. Thought version 8.03 recommended dual xeon processors. What speed are your hard drives and how many do you have? Also has your network been tested at 100 mb or are your switches just 100mb?

1st thing I would do is find where the bottle neck is. Check your processor load on the server, and then hard disk and network load. I'm assuming that your server is 32 bit windows so you can't add anymore RAM, but you can see how big your page files is. If it's more than double your RAM then your putting a huge load on your disk and disk controller. If the server is good you need to get something like Wireshark and sniff the network to see if that is your slow down. Could be a lot of traffic (streaming audio/video, Facebook, twitter crap) eating up the bandwidth, or it could be your switches can't handle the load. Switches have internal bandwidth limits specially the cheaper switches. If you have hubs instead of switches then swap those out asap.

Finally make sure the client pc are up to spec and that your anti-virus isn't scanning Vantage folders or traffic. You will find that a pc running XP needs 2 gig of ram to make vantage happy. Windows 7 or Vista should be at 3 if not 4 gb of ram.

Hope this helps.

--- In vantage@yahoogroups.com, "Herby Dallard" <hdallard@...> wrote:
>
> Good morning all. We went live to Vantage last July 2009. It's been working
> out well for the most part however, our manufacturing teams and some of our
> sales reps have had some performance issues due to long processing times of
> various tasks. Our manufacturing teams experience a 4 minute delay to start
> work queue and select a job to work -just one job.
>
> Are there any specific settings on the Vantage server or client PC that can
> be configured to decrease processing time as a user navigates and processes
> jobs in Epicor? Please help!
>
>
>
> Some additional information:
>
>
>
> We are a small company with Vantage 8.03.408B
>
> We have about 25 to 30 licensed PC users from sales to engineering and
> manufacturing personal.
>
> Our Vantage server has the following specifications:
>
> Dell Server PE2900
>
> Intel Xeon CPU
>
> E5405 @ 2 GHz
>
> 2 GHz, 4 GB of Ram
>
> 370 GB Hard drive
>
> Network bandwidth is 100 MB
>
>
>
>
>
> Best Regards,
>
>
>
> Herby Dallard
>
> Information Technology Engineer
>
> Endicott Research Group
>
> hdallard@...
>
> 607-754-9187 ext. 3078
>
> www.ergpower.com
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Thanks David.



I will investigate your recommendations.







Best Regards,



Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@...

607-754-9187 ext. 3078

www.ergpower.com







_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
David G
Sent: Tuesday, March 09, 2010 3:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage MES performance issues





Server and network seem a little under powered. Thought version 8.03
recommended dual xeon processors. What speed are your hard drives and how
many do you have? Also has your network been tested at 100 mb or are your
switches just 100mb?

1st thing I would do is find where the bottle neck is. Check your processor
load on the server, and then hard disk and network load. I'm assuming that
your server is 32 bit windows so you can't add anymore RAM, but you can see
how big your page files is. If it's more than double your RAM then your
putting a huge load on your disk and disk controller. If the server is good
you need to get something like Wireshark and sniff the network to see if
that is your slow down. Could be a lot of traffic (streaming audio/video,
Facebook, twitter crap) eating up the bandwidth, or it could be your
switches can't handle the load. Switches have internal bandwidth limits
specially the cheaper switches. If you have hubs instead of switches then
swap those out asap.

Finally make sure the client pc are up to spec and that your anti-virus
isn't scanning Vantage folders or traffic. You will find that a pc running
XP needs 2 gig of ram to make vantage happy. Windows 7 or Vista should be at
3 if not 4 gb of ram.

Hope this helps.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Herby
Dallard" <hdallard@...> wrote:
>
> Good morning all. We went live to Vantage last July 2009. It's been
working
> out well for the most part however, our manufacturing teams and some of
our
> sales reps have had some performance issues due to long processing times
of
> various tasks. Our manufacturing teams experience a 4 minute delay to
start
> work queue and select a job to work -just one job.
>
> Are there any specific settings on the Vantage server or client PC that
can
> be configured to decrease processing time as a user navigates and
processes
> jobs in Epicor? Please help!
>
>
>
> Some additional information:
>
>
>
> We are a small company with Vantage 8.03.408B
>
> We have about 25 to 30 licensed PC users from sales to engineering and
> manufacturing personal.
>
> Our Vantage server has the following specifications:
>
> Dell Server PE2900
>
> Intel Xeon CPU
>
> E5405 @ 2 GHz
>
> 2 GHz, 4 GB of Ram
>
> 370 GB Hard drive
>
> Network bandwidth is 100 MB
>
>
>
>
>
> Best Regards,
>
>
>
> Herby Dallard
>
> Information Technology Engineer
>
> Endicott Research Group
>
> hdallard@...
>
> 607-754-9187 ext. 3078
>
> www.ergpower.com
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
You may also be able to improve network performance by setting up VLans.
I know that for us this has helped with network response times.



Tim Dines

Information Technology

Steel Parts Manufacturing, Inc.

801 Berryman Pike

Tipton, IN 46072

Direct: 765-675-5201

Cell: 765-437-1402



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Herby Dallard
Sent: Tuesday, March 09, 2010 3:21 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Vantage MES performance issues





Thanks David.

I will investigate your recommendations.

Best Regards,

Herby Dallard

Information Technology Engineer

Endicott Research Group

hdallard@... <mailto:hdallard%40ergpower.com>

607-754-9187 ext. 3078

www.ergpower.com

_____

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
David G
Sent: Tuesday, March 09, 2010 3:06 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Vantage MES performance issues

Server and network seem a little under powered. Thought version 8.03
recommended dual xeon processors. What speed are your hard drives and
how
many do you have? Also has your network been tested at 100 mb or are
your
switches just 100mb?

1st thing I would do is find where the bottle neck is. Check your
processor
load on the server, and then hard disk and network load. I'm assuming
that
your server is 32 bit windows so you can't add anymore RAM, but you can
see
how big your page files is. If it's more than double your RAM then your
putting a huge load on your disk and disk controller. If the server is
good
you need to get something like Wireshark and sniff the network to see if
that is your slow down. Could be a lot of traffic (streaming
audio/video,
Facebook, twitter crap) eating up the bandwidth, or it could be your
switches can't handle the load. Switches have internal bandwidth limits
specially the cheaper switches. If you have hubs instead of switches
then
swap those out asap.

Finally make sure the client pc are up to spec and that your anti-virus
isn't scanning Vantage folders or traffic. You will find that a pc
running
XP needs 2 gig of ram to make vantage happy. Windows 7 or Vista should
be at
3 if not 4 gb of ram.

Hope this helps.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"Herby
Dallard" <hdallard@...> wrote:
>
> Good morning all. We went live to Vantage last July 2009. It's been
working
> out well for the most part however, our manufacturing teams and some
of
our
> sales reps have had some performance issues due to long processing
times
of
> various tasks. Our manufacturing teams experience a 4 minute delay to
start
> work queue and select a job to work -just one job.
>
> Are there any specific settings on the Vantage server or client PC
that
can
> be configured to decrease processing time as a user navigates and
processes
> jobs in Epicor? Please help!
>
>
>
> Some additional information:
>
>
>
> We are a small company with Vantage 8.03.408B
>
> We have about 25 to 30 licensed PC users from sales to engineering and
> manufacturing personal.
>
> Our Vantage server has the following specifications:
>
> Dell Server PE2900
>
> Intel Xeon CPU
>
> E5405 @ 2 GHz
>
> 2 GHz, 4 GB of Ram
>
> 370 GB Hard drive
>
> Network bandwidth is 100 MB
>
>
>
>
>
> Best Regards,
>
>
>
> Herby Dallard
>
> Information Technology Engineer
>
> Endicott Research Group
>
> hdallard@...
>
> 607-754-9187 ext. 3078
>
> www.ergpower.com
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
I have a BAQ set up that basically takes all of the parts in the partmaster, and shows them , the on-hand quantities from the partWhse table, the costs from the PartCost table. This is ok. We can get it into Excel from here just fine. However, management wants to somehow get this data from two specific historic dates. Does anyone have something built, or a specific process for how to extract this data?


Thanks

Carey

803.404



_________________________________________________________________
Hotmail: Powerful Free email with security by Microsoft.
http://clk.atdmt.com/GBL/go/201469230/direct/01/

[Non-text portions of this message have been removed]
Carey, good afternoon.

I did something like that but with another ERP (MAPICS) and -just an idea- what I did, I backed ALL inventory transactions for the desired parts down to the "historical date" I wanted the on-hand quantities to represent through the sum of transaction quantities; this is: CURRENT OH minus RECEIPTS plus SHIPMENTS.... If you are going to do it for all your Part Master, it can be a "heavy" task, but still, if you do a BAQReport and save your XML files, you can work and get the result easily off-line through Crystal.

Send me an e-mail if I can further assist on chipping in ideas.

Regards.

Roel Martinez
ERP Analyst

SABRE TUBULAR STRUCTURES (tm)
www.sabretubularstructures.com<http://www.sabretubularstructures.com/>
8653 E. Hwy 67 | Alvarado, TX 76009
Phone: 817-852-1700 ext. 11858 | Direct Line: 817-852-1858 |Fax: 817-852-1705



[Non-text portions of this message have been removed]