Neg on stock Status / pos. Qty on hand/ FIX didn't work

Yahoo Archive
1
We received the fix from Epicor but it didn't work.  Wondering if it worked for anyone else? 
 

From: Jacqueline Restivo <jacqueline_restivo@...>
To: "vantage@yahoogroups.com" <vantage@yahoogroups.com>
Sent: Friday, November 22, 2013 1:27 PM
Subject: Re: [Vantage] Re: Neg on stock Status / pos. Qty on hand

 

Hi Mike,
wondering if you installed the fix for this issue and if it worked? 
Thanks
Jacqueline
From: mdhoge <mhoge@...>
To: vantage@yahoogroups.com
Sent: Wednesday, November 20, 2013 1:05 PM
Subject: [Vantage] Re: Neg on stock Status / pos. Qty on hand

 
Hi

I am currently having the same issue (8.03.408). I and support recognize the root cause to be that the 'system date' went missing on my inventory receipt transaction. We received 25 in and pulled 25, so the stock status indicates a negative 25. Compare you part trasaction history and see what is missing. If this is a purchased part check purchase advisor and look for missing dates on receipts.

--- In vantage@yahoogroups.com, Jacqueline Restivo <jacqueline_restivo@...> wrote:
>
>  
> Hello, Good Morning,
>  
> I printed out a Stock Status, checked "neg on hand balance, purchased and manufactured, exclude 0 qty". Â An item came up neg 8,208pcs on the stock status, (correct dollar amount). BUT Part Tracker inventory is positive 216 pcs. 
> Same outcome when I print a Stock Status without Neg on hand balance checked.
>  
> When I review the Part History this neg qty amount is not anywhere! 
>  
> Thought I'd ask here before calling Epicor and getting a call #.
>  
> Thanks in advance
> Jacqueline
>  
> Enjoy the day!
>
>  
>
> >>>>
> >>>>[Non-text portions of this message have been removed]
> >>
>



#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063 -- #ygrps-yiv-668563656yiv0182714063ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp #ygrps-yiv-668563656yiv0182714063hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp #ygrps-yiv-668563656yiv0182714063ads {
margin-bottom:10px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp .ygrps-yiv-668563656yiv0182714063ad {
padding:0 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp .ygrps-yiv-668563656yiv0182714063ad p {
margin:0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mkp .ygrps-yiv-668563656yiv0182714063ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ygrp-lc {
font-family:Arial;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ygrp-lc #ygrps-yiv-668563656yiv0182714063hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ygrp-lc .ygrps-yiv-668563656yiv0182714063ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity span {
font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity span span {
color:#ff7900;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063activity span .ygrps-yiv-668563656yiv0182714063underline {
text-decoration:underline;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063attach div a {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063attach img {
border:none;padding-right:5px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063attach label a {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063bold a {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 dd.ygrps-yiv-668563656yiv0182714063last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 dd.ygrps-yiv-668563656yiv0182714063last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 dd.ygrps-yiv-668563656yiv0182714063last p span.ygrps-yiv-668563656yiv0182714063yshortcuts {
margin-right:0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063attach-table div div a {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063attach-table {
width:400px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063file-title a, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063file-title a:active, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063file-title a:hover, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063file-title a:visited {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063photo-title a, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063photo-title a:active, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063photo-title a:hover, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div.ygrps-yiv-668563656yiv0182714063photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 div#ygrps-yiv-668563656yiv0182714063ygrp-mlmsg #ygrps-yiv-668563656yiv0182714063ygrp-msg p a span.ygrps-yiv-668563656yiv0182714063yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063green {
color:#628c2a;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 o {
font-size:0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063photos div {
float:left;width:72px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063reco-category {
font-size:77%;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063reco-desc {
font-size:77%;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 .ygrps-yiv-668563656yiv0182714063replbq {
margin:4px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg select, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 input, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg pre, #ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 code {
font:115% monospace;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-mlmsg #ygrps-yiv-668563656yiv0182714063logo {
padding-bottom:10px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-msg p#ygrps-yiv-668563656yiv0182714063attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-reco #ygrps-yiv-668563656yiv0182714063reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-sponsor #ygrps-yiv-668563656yiv0182714063ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-text {
font-family:Georgia;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-text tt {
font-size:120%;}

#ygrps-yiv-668563656 #ygrps-yiv-668563656yiv0182714063 #ygrps-yiv-668563656yiv0182714063ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-668563656



2
My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.
3

Do they have an Epicor maintenance agreement?  If they do and what you describe is carried out, they can kiss that goodbye lol

 

Joshua Giese

CIO

920.437.6400 Ext. 337

Site ID: 27450-E905700B2-SQL64

Wisconsin Converting, Inc.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of epdba1337@...
Sent: Monday, November 18, 2013 2:18 PM
To: vantage@yahoogroups.com
Subject: [Vantage] ODBC Index problem

 

 

My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.

4
No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:

 
<div>
  
  
  <p>My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.</p>



</div>
 


<div style="color:#fff;min-height:0;"></div>

5

You'll want to create a VIEW - which should work with Access.

I believe there are instructions fro creating a VIEW of the customer table in the files section here.


You don't want to remove an index.




---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:

  
<div>
  
  
  <p>My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.</p>



</div>
 


<div style="color:#fff;min-height:0;"></div>

6

FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....


FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.


I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988...  I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway. 



---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:

  
<div>
  
  
  <p>My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.</p>



</div>
 


<div style="color:#fff;min-height:0;"></div>

7

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know
they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?



Sent from my Android phone using TouchDown (www.nitrodesk.com)



-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: [Vantage] RE: ODBC Index problem



 

FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....


FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.


I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988...  I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway. 



---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:
 

My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.


8

Exactly what I received.



---In vantage@yahoogroups.com, <jgiese@...> wrote:

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know
they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?



Sent from my Android phone using TouchDown (www.nitrodesk.com)



-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: [Vantage] RE: ODBC Index problem



 

FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....


FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.


I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988...  I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway. 



---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:
 

My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.


9
I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition... I ohpe ouy fnd wut ouy was lookin fir


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com

     Â


Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...> wrote:

 
<div>
  
  
  <p></p><p>Exactly what I received.</p> <div><br><br>---In <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>, &lt;jgiese@...&gt; wrote:<br><br><div>

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know
they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?



Sent from my Android phone using TouchDown (www.nitrodesk.com)


-----Original Message-----
From: epdba1337@... [epdba1337@...]
Received: Monday, 18 Nov 2013, 17:26
To: vantage@yahoogroups.com [vantage@yahoogroups.com]
Subject: [Vantage] RE: ODBC Index problem

Â

FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....


FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.


I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... Â I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.Â



---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:
Â

My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.


</div>
 


<div style="color:#fff;min-height:0;"></div>

10

Note, the correct way to use quotation marks:

 "or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server" 

@b_ordway, thanks this worked perfectly.

Additionally, I am here to help other people with upgrades from V6.1 to 9.05.702 or higher. I have been working alone on this for about 6 months and should have my new system up and running by the end of the year.



---In vantage@yahoogroups.com, <epdba1337@...> wrote:

Exactly what I received.



---In vantage@yahoogroups.com, <jgiese@...> wrote:

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know
they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?



Sent from my Android phone using TouchDown (www.nitrodesk.com)



-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com [vantage@yahoogroups.com]

Subject: [Vantage] RE: ODBC Index problem



 

FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....


FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.


I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988...  I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway. 



---In vantage@yahoogroups.com, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile

Quis custodiet ipsos custodes?


On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...> wrote:
 

My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.


11

 Rob,

  Use the annoying young hipster translator.  That should work.


Cheerio,

Thomas J. Curtis



---In vantage@yahoogroups.com, <rbucek@...> wrote:

Jose,

I used no less than six languages in Google translate and I still can't decipher what you're trying to say...



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez
Sent: Monday, November 18, 2013 6:02 PM
To: Vantage
Subject: Re: [Vantage] RE: ODBC Index problem


I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition... I ohpe ouy fnd wut ouy was lookin fir


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jgiese@...> wrote:
It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so... what exactly is it you're looking for from the group?

Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com>)
-----Original Message-----
From: epdba1337@... [epdba1337@...]
Received: Monday, 18 Nov 2013, 17:26
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]
Subject: [Vantage] RE: ODBC Index problem


FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....

FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.



I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...> wrote:
No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





[Non-text portions of this message have been removed]
12
Here you go Tom

hehe


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile
E: jose@…

http://www.josecgomez.com
     Â


Quis custodiet ipsos custodes?


On Tue, Nov 19, 2013 at 9:37 AM, <tcurtis@...> wrote:

 
<div>
  
  
  <p></p><p>Â Rob,</p><p>Â  Use the annoying young hipster translator. Â That should work.</p><p><br></p><p style="font-style:normal;font-size:13px;background-color:transparent;font-family:arial, helvetica, clean, sans-serif;">

Cheerio,

Thomas J. Curtis



—In vantage@yahoogroups.com, <rbucek@…> wrote:


Jose,



I used no less than six languages in Google translate and I still can't decipher what you're trying to say…







Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-4832

FAX: (715)284-4084

[cid:1.234354861@…]<http://www.dsmfg.com/>


(Click the logo to view our site)<http://www.dsmfg.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Monday, November 18, 2013 6:02 PM

To: Vantage

Subject: Re: [Vantage] RE: ODBC Index problem





I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition… I ohpe ouy fnd wut ouy was lookin fir





Jose C Gomez

Software Engineer





T: 904.469.1524 mobile


[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>


Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jgiese@...> wrote:

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?


Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com>)

-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]

Subject: [Vantage] RE: ODBC Index problem





FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.



It is also good practice to spell and grammar check before posting a message…



FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.




I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.



Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





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

</div>
 


<div style="color:#fff;min-height:0;"></div>

13

I was not very impressed with how the group handled this guys post.

I don't recall any pervious posts from him but you guys were pretty snarky right out of the chute.

His reply was pretty snarky but I don't think he expected to get piled on like that.

 

As a group, I have seen (and I hope in the future) that we can do better.

 

Neil 



---In vantage@yahoogroups.com, <jose@...> wrote:

Here you go Tom

hehe


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Nov 19, 2013 at 9:37 AM, <tcurtis@...> wrote:

  
<div>
  
  
  <p>&nbsp;Rob,</p><p>&nbsp; Use the annoying young hipster translator. &nbsp;That should work.</p><p><br></p><p style="font-family:arial, helvetica, clean, sans-serif;font-size:13px;font-style:normal;background-color:transparent;">

Cheerio,

Thomas J. Curtis



—In vantage@yahoogroups.com, <rbucek@…> wrote:


Jose,



I used no less than six languages in Google translate and I still can't decipher what you're trying to say…







Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-4832

FAX: (715)284-4084

[cid:1.234354861@…]<http://www.dsmfg.com/>


(Click the logo to view our site)<http://www.dsmfg.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Monday, November 18, 2013 6:02 PM

To: Vantage

Subject: Re: [Vantage] RE: ODBC Index problem





I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition… I ohpe ouy fnd wut ouy was lookin fir





Jose C Gomez

Software Engineer





T: 904.469.1524 mobile


[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>


Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jgiese@...> wrote:

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?


Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com>)

-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]

Subject: [Vantage] RE: ODBC Index problem





FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.



It is also good practice to spell and grammar check before posting a message…



FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.




I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.



Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





[Non-text portions of this message have been removed] 
</div>
 


<div style="color:rgb(255, 255, 255);min-height:0px;"></div>

14
Jose may not have said the comment politically correct but he sure is right about Access.  Jose and many others have been helpful in the past.   The very smart ones like Jose you have to take their comments like grains of salt----very lightly.   As long as I learn something I do not care how it is said. 

 I used Access to export the data from V8 to DMT into E9.  I had to used an Access pass through query to access the customer table.   Regular query would err.  Maybe if the guy is still viewing the group and if he has not tried a pass through query this post may help. 





On Nov 19, 2013, at 4:56 PM, <neil_willet@...> wrote:

 

<div id="ygrps-yiv-135767220ygrp-text">
  
  
  <p></p><p>I was&nbsp;not&nbsp;very impressed with how the group handled this guys post.</p><p>I don&#39;t recall any&nbsp;pervious posts from him but you guys were pretty snarky right out of the chute.</p><p>His reply was&nbsp;pretty&nbsp;snarky but I don&#39;t think he&nbsp;expected to get piled on like that.</p><p>&nbsp;</p><p>As a group, I have seen (and I hope in the future) that <var id="ygrps-yiv-135767220yui-ie-cursor"></var>we can do better.</p><p>&nbsp;</p><p>Neil&nbsp;</p> <div class="ygrps-yiv-135767220ygroups-quoted"><br><br>---In <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>, &lt;jose@...&gt; wrote:<br><br><div id="ygrps-yiv-135767220ygrps-yiv-717472731"><div dir="ltr"><div style="font-family:verdana, sans-serif;font-size:small;" class="ygrps-yiv-135767220ygrps-yiv-717472731gmail_default">Here you go Tom</div><div class="ygrps-yiv-135767220ygrps-yiv-717472731gmail_default"><font face="verdana, sans-serif"><a rel="nofollow" target="_blank" href="http://goo.gl/wvU2T">http://goo.gl/wvU2T</a></font><br>

hehe


Jose C Gomez

Software Engineer


T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Nov 19, 2013 at 9:37 AM, <tcurtis@...> wrote:

  
<div>
  
  
  <p>&nbsp;Rob,</p><p>&nbsp; Use the annoying young hipster translator. &nbsp;That should work.</p><p><br></p><p style="font-family:arial, helvetica, clean, sans-serif;font-size:13px;font-style:normal;background-color:transparent;">

Cheerio,

Thomas J. Curtis



—In vantage@yahoogroups.com, <rbucek@…> wrote:


Jose,



I used no less than six languages in Google translate and I still can't decipher what you're trying to say…







Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-4832

FAX: (715)284-4084

[cid:1.234354861@…]<http://www.dsmfg.com/>


(Click the logo to view our site)<http://www.dsmfg.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Jose Gomez

Sent: Monday, November 18, 2013 6:02 PM

To: Vantage

Subject: Re: [Vantage] RE: ODBC Index problem





I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition… I ohpe ouy fnd wut ouy was lookin fir





Jose C Gomez

Software Engineer





T: 904.469.1524 mobile


[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>


Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jgiese@...> wrote:

It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so… what exactly is it you're looking for from the group?


Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com>)

-----Original Message-----

From: epdba1337@… [epdba1337@…]

Received: Monday, 18 Nov 2013, 17:26

To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>]

Subject: [Vantage] RE: ODBC Index problem





FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.



It is also good practice to spell and grammar check before posting a message…



FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.




I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...> wrote:

No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.



Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





[Non-text portions of this message have been removed] 
</div>
 


<div style="color:rgb(255, 255, 255);"></div>


</div>
15
Known issue in 6.1 when accessing the Customer table via ODBC. There’s a documented workaround for this if the original poster is still interested.

Mike Lowe
Director of I.T.
Connor Manufacturing Services
USA-Singapore-China-Malaysia
Phone: +1 (503) 465-3904
Cell: +1 (949) 793-3433
Web: www.ConnorMS.com<http://www.connorms.com/>
[cid:image003.jpg@...5D070]
“Celebrating 100 years of Service”



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brinda Whitaker
Sent: Tuesday, November 19, 2013 7:57 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: ODBC Index problem


Jose may not have said the comment politically correct but he sure is right about Access. Jose and many others have been helpful in the past. The very smart ones like Jose you have to take their comments like grains of salt----very lightly. As long as I learn something I do not care how it is said.

I used Access to export the data from V8 to DMT into E9. I had to used an Access pass through query to access the customer table. Regular query would err. Maybe if the guy is still viewing the group and if he has not tried a pass through query this post may help.




On Nov 19, 2013, at 4:56 PM, <neil_willet@...<mailto:neil_willet@...>> wrote:


I was not very impressed with how the group handled this guys post.

I don't recall any pervious posts from him but you guys were pretty snarky right out of the chute.

His reply was pretty snarky but I don't think he expected to get piled on like that.



As a group, I have seen (and I hope in the future) that we can do better.



Neil


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...<mailto:jose@...>> wrote:
Here you go Tom
http://goo.gl/wvU2T

hehe


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[http://www.josecgomez.com/images/linkedin.png%5d<http://www.linkedin.com/in/josecgomez> [http://www.josecgomez.com/images/facebook.png%5d <http://www.facebook.com/josegomez> [http://www.josecgomez.com/images/google.png%5d <http://www.google.com/profiles/jose.gomez> [http://www.josecgomez.com/images/twitter.png%5d <http://www.twitter.com/joc85> [http://www.josecgomez.com/images/wp.png%5d <http://www.josecgomez.com/professional-resume/> [http://www.josecgomez.com/images/rss.png%5d <http://www.josecgomez.com/feed/> [http://www.josecgomez.com/images/uds.png%5d <http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Tue, Nov 19, 2013 at 9:37 AM, <tcurtis@...<mailto:tcurtis@...>> wrote:


Rob,

Use the annoying young hipster translator. That should work.



Cheerio,

Thomas J. Curtis


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <rbucek@...<mailto:rbucek@...>> wrote:
Jose,

I used no less than six languages in Google translate and I still can't decipher what you're trying to say...



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861@...>]<http://www.dsmfg.com/>

(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>] On Behalf Of Jose Gomez
Sent: Monday, November 18, 2013 6:02 PM
To: Vantage
Subject: Re: [Vantage] RE: ODBC Index problem


I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition... I ohpe ouy fnd wut ouy was lookin fir


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...>>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?
On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...><mailto:epdba1337@...<mailto:epdba1337@...>>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>, <jgiese@...<mailto:jgiese@...>> wrote:
It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so... what exactly is it you're looking for from the group?

Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com><http://www.nitrodesk.com>)
-----Original Message-----
From: epdba1337@... [epdba1337@...]
Received: Monday, 18 Nov 2013, 17:26
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>]
Subject: [Vantage] RE: ODBC Index problem


FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....

FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.



I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>, <jose@...<mailto:jose@...>> wrote:
No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@<mailto:jose@>...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@<mailto:epdba1337@>...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





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



______________________________________________________________________
This email has been scanned by the Connor Manufacturing Services Email Security System.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


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

No hard feelings.

The view method described in the files section worked perfectly. @b_ordway

Access does have its limitations, esp with big data/table size constraints, I have experience developing automation procedures in access so it was easier to use that platform rather than learn .net or jump back into JAVA and develop my own application to do my automation. I could use SQL Server but then have to learn all the ODBC connectors over again. I am currently familiarizing myself with the sqlexp commands and will attempt to incorporate those program calls into my current procedure. 

Context: Company wants historical data moved over, with db normalization. Long arduous process for cleaning 15+ years of data, but it will let me consolidate current 6.1 and DBASE systems.

I am creating a procedure to enable running the systems in parallel, downtime is not an option. This allows for training to occur with current data, and the advantages of EP9 over the current discrete systems are more easily recognized.
 



  



---In vantage@yahoogroups.com, <MLowe@...> wrote:

Known issue in 6.1 when accessing the Customer table via ODBC. There’s a documented workaround for this if the original poster is still interested.

Mike Lowe
Director of I.T.
Connor Manufacturing Services
USA-Singapore-China-Malaysia
Phone: +1 (503) 465-3904
Cell: +1 (949) 793-3433
Web: www.ConnorMS.com<http://www.connorms.com/>
[cid:image003.jpg@...5D070]
“Celebrating 100 years of Service”



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Brinda Whitaker
Sent: Tuesday, November 19, 2013 7:57 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] RE: ODBC Index problem


Jose may not have said the comment politically correct but he sure is right about Access. Jose and many others have been helpful in the past. The very smart ones like Jose you have to take their comments like grains of salt----very lightly. As long as I learn something I do not care how it is said.

I used Access to export the data from V8 to DMT into E9. I had to used an Access pass through query to access the customer table. Regular query would err. Maybe if the guy is still viewing the group and if he has not tried a pass through query this post may help.




On Nov 19, 2013, at 4:56 PM, <neil_willet@...<mailto:neil_willet@...>> wrote:


I was not very impressed with how the group handled this guys post.

I don't recall any pervious posts from him but you guys were pretty snarky right out of the chute.

His reply was pretty snarky but I don't think he expected to get piled on like that.



As a group, I have seen (and I hope in the future) that we can do better.



Neil


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <jose@...<mailto:jose@...>> wrote:
Here you go Tom
http://goo.gl/wvU2T

hehe


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...>
http://www.josecgomez.com
[http://www.josecgomez.com/images/linkedin.png]<http://www.linkedin.com/in/josecgomez> [http://www.josecgomez.com/images/facebook.png] <http://www.facebook.com/josegomez> [http://www.josecgomez.com/images/google.png] <http://www.google.com/profiles/jose.gomez> [http://www.josecgomez.com/images/twitter.png] <http://www.twitter.com/joc85> [http://www.josecgomez.com/images/wp.png] <http://www.josecgomez.com/professional-resume/> [http://www.josecgomez.com/images/rss.png] <http://www.josecgomez.com/feed/> [http://www.josecgomez.com/images/uds.png] <http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Tue, Nov 19, 2013 at 9:37 AM, <tcurtis@...<mailto:tcurtis@...>> wrote:


Rob,

Use the annoying young hipster translator. That should work.



Cheerio,

Thomas J. Curtis


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>, <rbucek@...<mailto:rbucek@...>> wrote:
Jose,

I used no less than six languages in Google translate and I still can't decipher what you're trying to say...



Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-4832
FAX: (715)284-4084
[cid:1.234354861@...<mailto:1.234354861@...>]<http://www.dsmfg.com/>

(Click the logo to view our site)<http://www.dsmfg.com/>

From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>] On Behalf Of Jose Gomez
Sent: Monday, November 18, 2013 6:02 PM
To: Vantage
Subject: Re: [Vantage] RE: ODBC Index problem


I aplogze taht ym tpyng is not ogod enuf to saststify you're sistuition... I ohpe ouy fnd wut ouy was lookin fir


Jose C Gomez
Software Engineer


T: 904.469.1524 mobile
E: jose@...<mailto:jose@...><mailto:jose@...<mailto:jose@...>>
http://www.josecgomez.com
[Image removed by sender.]<http://www.linkedin.com/in/josecgomez> [Image removed by sender.] <http://www.facebook.com/josegomez> [Image removed by sender.] <http://www.google.com/profiles/jose.gomez> [Image removed by sender.] <http://www.twitter.com/joc85> [Image removed by sender.] <http://www.josecgomez.com/professional-resume/> [Image removed by sender.] <http://www.josecgomez.com/feed/> [Image removed by sender.] <http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?
On Mon, Nov 18, 2013 at 6:59 PM, <epdba1337@...<mailto:epdba1337@...><mailto:epdba1337@...<mailto:epdba1337@...>>> wrote:


Exactly what I received.


---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>, <jgiese@...<mailto:jgiese@...>> wrote:
It sounds like your a glutton for punishment. Good luck with that when the customer is pissed they voided their warranty under your direction. At the least let them know they can stop their maintenance payments. It sounds like you know exactly what you want to do so... what exactly is it you're looking for from the group?

Sent from my Android phone using TouchDown (www.nitrodesk.com<http://www.nitrodesk.com><http://www.nitrodesk.com>)
-----Original Message-----
From: epdba1337@... [epdba1337@...]
Received: Monday, 18 Nov 2013, 17:26
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>> [vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>]
Subject: [Vantage] RE: ODBC Index problem


FYI: The quotation mark is reserved for direct quoting only. "I want to use Microsoft access" was never stated.

It is also good practice to spell and grammar check before posting a message....

FYI: The maintenance agreement is nearly worthless for the price you pay. Almost every time I call, I am left on hold, for them to call me back and say, "I'm sorry I couldn't find any information on that,would you like to speak to a consultant?" No, i would not. I would like TECHNICAL SUPPORT to SUPPORT their customers.



I am currently normalizing a database that has been without proper database administration for 15+ years. They still are using a DBASE system from 1988... I have already done a normalization/database transferal from an Access backend system to SQL server. Thus when I engaged in this project that was the tool I decided to use. If necessary I will extract the data via dump and load, run the CONV910 PROUTIL command and tell them, sorry your database is too broken. Here is what EPICOR CONSULTING will charge you 6000 dollars for, one command, freely available to learn online, for those who have the skill and discipline to implement it. Also no data normalization, please implement these procedures I have written so you can actually have data integrity. Project finished.

Also on "risking" damage to my application, no, its called a backup. Its called, I run whatever 4GL query I discover in these 2000+ page manuals on a test database. Its called a digital system, completely recoverable for someone with half a brain Mr. Gomez.

Thank you for letting me know about views b_ordway.

---In vantage@yahoogroups.com<mailto:vantage@yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>>, <jose@...<mailto:jose@...>> wrote:
No ofense but hte indexes are there for a reason and "I want to use microsoft access" is not a good enough reason to void any maintenance and risk ruining your application. Perhaps they should get a different piece of software. Also and for what is worth Access also has a limitation in the number of columns which a lot of the tables exeed.


Jose C Gomez
Software Engineer


T: 904.469.1524<tel:904.469.1524> mobile
E: jose@...<mailto:jose@<mailto:jose@>...>
http://www.josecgomez.com
Error! Filename not specified.<http://www.linkedin.com/in/josecgomez> Error! Filename not specified.<http://www.facebook.com/josegomez> Error! Filename not specified.<http://www.google.com/profiles/jose.gomez> Error! Filename not specified.<http://www.twitter.com/joc85> Error! Filename not specified.<http://www.josecgomez.com/professional-resume/> Error! Filename not specified.<http://www.josecgomez.com/feed/> Error! Filename not specified.<http://www.usdoingstuff.com>

Quis custodiet ipsos custodes?

On Mon, Nov 18, 2013 at 3:18 PM, <epdba1337@...<mailto:epdba1337@<mailto:epdba1337@>...>> wrote:


My customer table in Vantage 6.1 has an index for every column in the table. This makes it impossible to access via ODBC when using MS Access as the platform. I would like to know how to remove these indices. The index management functionality of the progress data administration application is disabled. Should I look into creating a 4GL query to modify the schema, or would it be more efficient to try to create a static query equivalent to a stored procedure in SQL server. I am using the MERANT 3.60 32-bit progress SQL92 v9.1D ODBC driver for exportation to a MSAccess 2010 database for processing.





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



______________________________________________________________________
This email has been scanned by the Connor Manufacturing Services Email Security System.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


[Non-text portions of this message have been removed]
17
 
Hello, Good Morning,
 
I printed out a Stock Status, checked "neg on hand balance, purchased and manufactured, exclude 0 qty".  An item came up neg 8,208pcs on the stock status, (correct dollar amount). BUT Part Tracker inventory is positive 216 pcs. 
Same outcome when I print a Stock Status without Neg on hand balance checked.
 
When I review the Part History this neg qty amount is not anywhere! 
 
Thought I'd ask here before calling Epicor and getting a call #.
 
Thanks in advance
Jacqueline
 
Enjoy the day!

 


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

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153 -- #ygrps-yiv-1355122151yiv7087495153ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp #ygrps-yiv-1355122151yiv7087495153hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp #ygrps-yiv-1355122151yiv7087495153ads {
margin-bottom:10px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp .ygrps-yiv-1355122151yiv7087495153ad {
padding:0 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp .ygrps-yiv-1355122151yiv7087495153ad p {
margin:0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mkp .ygrps-yiv-1355122151yiv7087495153ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ygrp-lc {
font-family:Arial;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ygrp-lc #ygrps-yiv-1355122151yiv7087495153hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ygrp-lc .ygrps-yiv-1355122151yiv7087495153ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity span {
font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity span span {
color:#ff7900;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153activity span .ygrps-yiv-1355122151yiv7087495153underline {
text-decoration:underline;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153attach div a {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153attach img {
border:none;padding-right:5px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153attach label a {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153bold a {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 dd.ygrps-yiv-1355122151yiv7087495153last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 dd.ygrps-yiv-1355122151yiv7087495153last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 dd.ygrps-yiv-1355122151yiv7087495153last p span.ygrps-yiv-1355122151yiv7087495153yshortcuts {
margin-right:0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153attach-table div div a {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153attach-table {
width:400px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153file-title a, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153file-title a:active, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153file-title a:hover, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153file-title a:visited {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153photo-title a, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153photo-title a:active, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153photo-title a:hover, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div.ygrps-yiv-1355122151yiv7087495153photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 div#ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg #ygrps-yiv-1355122151yiv7087495153ygrp-msg p a span.ygrps-yiv-1355122151yiv7087495153yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153green {
color:#628c2a;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 o {
font-size:0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153photos div {
float:left;width:72px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153reco-category {
font-size:77%;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153reco-desc {
font-size:77%;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 .ygrps-yiv-1355122151yiv7087495153replbq {
margin:4px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg select, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 input, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg pre, #ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 code {
font:115% monospace;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-mlmsg #ygrps-yiv-1355122151yiv7087495153logo {
padding-bottom:10px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-msg p#ygrps-yiv-1355122151yiv7087495153attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-reco #ygrps-yiv-1355122151yiv7087495153reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-sponsor #ygrps-yiv-1355122151yiv7087495153ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-text {
font-family:Georgia;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-text tt {
font-size:120%;}

#ygrps-yiv-1355122151 #ygrps-yiv-1355122151yiv7087495153 #ygrps-yiv-1355122151yiv7087495153ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1355122151



18
Try running conversion 6430 and see if that fixes the problem.

Steven G.


On Wednesday, November 20, 2013 10:18 AM, Jacqueline Restivo <jacqueline_restivo@...> wrote:
  
<div id="ygrps-yiv-903922147yiv3684739937ygrp-text">
  
  
  <div style="color:rgb(0, 0, 0);background-color:rgb(255, 255, 255);font-family:HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;font-size:12pt;"><div><span></span>&nbsp;</div>
Hello, Good Morning,
 
I printed out a Stock Status, checked "neg on hand balance, purchased and manufactured, exclude 0 qty".  An item came up neg 8,208pcs on the stock status, (correct dollar amount). BUT Part Tracker inventory is positive 216 pcs. 
Same outcome when I print a Stock Status without Neg on hand balance checked.
 
When I review the Part History this neg qty amount is not anywhere! 
 
Thought I'd ask here before calling Epicor and getting a call #.
 
Thanks in advance
Jacqueline
 
Enjoy the day!

 


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



</div>
 


<div style="color:#fff;height:0;"></div></div>
#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937 -- #ygrps-yiv-903922147yiv3684739937ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp #ygrps-yiv-903922147yiv3684739937hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp #ygrps-yiv-903922147yiv3684739937ads {
margin-bottom:10px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp .ygrps-yiv-903922147yiv3684739937ad {
padding:0 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp .ygrps-yiv-903922147yiv3684739937ad p {
margin:0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mkp .ygrps-yiv-903922147yiv3684739937ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ygrp-lc {
font-family:Arial;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ygrp-lc #ygrps-yiv-903922147yiv3684739937hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ygrp-lc .ygrps-yiv-903922147yiv3684739937ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity span {
font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity span span {
color:#ff7900;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937activity span .ygrps-yiv-903922147yiv3684739937underline {
text-decoration:underline;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937attach div a {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937attach img {
border:none;padding-right:5px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937attach label a {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937bold a {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 dd.ygrps-yiv-903922147yiv3684739937last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 dd.ygrps-yiv-903922147yiv3684739937last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 dd.ygrps-yiv-903922147yiv3684739937last p span.ygrps-yiv-903922147yiv3684739937yshortcuts {
margin-right:0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937attach-table div div a {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937attach-table {
width:400px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937file-title a, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937file-title a:active, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937file-title a:hover, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937file-title a:visited {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937photo-title a, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937photo-title a:active, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937photo-title a:hover, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div.ygrps-yiv-903922147yiv3684739937photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 div#ygrps-yiv-903922147yiv3684739937ygrp-mlmsg #ygrps-yiv-903922147yiv3684739937ygrp-msg p a span.ygrps-yiv-903922147yiv3684739937yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937green {
color:#628c2a;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 o {
font-size:0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937photos div {
float:left;width:72px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937reco-category {
font-size:77%;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937reco-desc {
font-size:77%;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 .ygrps-yiv-903922147yiv3684739937replbq {
margin:4px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg select, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 input, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg pre, #ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 code {
font:115% monospace;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-mlmsg #ygrps-yiv-903922147yiv3684739937logo {
padding-bottom:10px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-msg p#ygrps-yiv-903922147yiv3684739937attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-reco #ygrps-yiv-903922147yiv3684739937reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-sponsor #ygrps-yiv-903922147yiv3684739937ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-text {
font-family:Georgia;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-text tt {
font-size:120%;}

#ygrps-yiv-903922147 #ygrps-yiv-903922147yiv3684739937 #ygrps-yiv-903922147yiv3684739937ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-903922147



19

Also, in Part Trans History, change your cutoff date to 1/1/9666

 

Sometimes there are future transactions that screw things up.

 

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, November 20, 2013 7:31 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Neg on stock Status / pos. Qty on hand

 

 

Try running conversion 6430 and see if that fixes the problem.

 

Steven G.

 

On Wednesday, November 20, 2013 10:18 AM, Jacqueline Restivo <jacqueline_restivo@...> wrote:

 

 

Hello, Good Morning,

 

I printed out a Stock Status, checked "neg on hand balance, purchased and manufactured, exclude 0 qty".  An item came up neg 8,208pcs on the stock status, (correct dollar amount). BUT Part Tracker inventory is positive 216 pcs. 

Same outcome when I print a Stock Status without Neg on hand balance checked.

 

When I review the Part History this neg qty amount is not anywhere! 

 

Thought I'd ask here before calling Epicor and getting a call #.

 

Thanks in advance

Jacqueline

 

Enjoy the day!


 



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

 

 

 

20

Non Netting can also cause a difference between the Part Tracker and the Stock Status.

 

In Part Tracker are you using the Bins tab or the Warehouse tab?

 

I like to use the Bin tab. Â In the Warehouse tab, the quantity on hand for a non-netting bin, is in the non nettable qty bucket, not in the quantity on hand.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Miguel Santillan
Sent: Wednesday, November 20, 2013 8:53 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Neg on stock Status / pos. Qty on hand

 

 

Also, in Part Trans History, change your cutoff date to 1/1/9666

 

Sometimes there are future transactions that screw things up.

 

 

Miguel A. Santillan

Compass Manufacturing Systems

510-661-6666  Office

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Wednesday, November 20, 2013 7:31 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Neg on stock Status / pos. Qty on hand

 

 

Try running conversion 6430 and see if that fixes the problem.

 

Steven G.

 

On Wednesday, November 20, 2013 10:18 AM, Jacqueline Restivo <jacqueline_restivo@...> wrote:

 

 

Hello, Good Morning,

 

I printed out a Stock Status, checked "neg on hand balance, purchased and manufactured, exclude 0 qty".  An item came up neg 8,208pcs on the stock status, (correct dollar amount). BUT Part Tracker inventory is positive 216 pcs. 

Same outcome when I print a Stock Status without Neg on hand balance checked.

 

When I review the Part History this neg qty amount is not anywhere! 

 

Thought I'd ask here before calling Epicor and getting a call #.

 

Thanks in advance

Jacqueline

 

Enjoy the day!


 



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