Receipt Not Invoiced (8.03.403D)

I do understand what you are saying....







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Wednesday, January 19, 2011 3:06 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)





My experience with custom programming has been that by the time you wait
the
six weeks to actually talk to someone, then have to write up the specs,
wait
for them to return their design, go back through and correct them on it,
test what they gave you and figure out it solves a problem, just not
your
problem, etc, etc, etc.

You end up spending $2000 of your time to pay them $4000 for something
you
could've done for $500 yourself.

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:54 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

Sorry Kevin,

The point was that if YOU were too busy to do it, then having custom
programming do it for you is not a big deal. For what this guy wants it
should not cost more than $1200 or so...it is a simple program in terms
of what he wants done. But then Epicor has it standards and I am sure
it is more now than it was 5 years ago!

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kevin Simon
Sent: Wednesday, January 19, 2011 1:49 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

$500 for a program from Custom Programming? Can I have the name of your
sales rep please - I'm going through them from now on!!

Kevin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

Unless you are a programmer, I'd bite the bullet, pay about $500 for a
program from Epicor to close these all out!

Or maybe someone on this list has something like this already and can
help out...

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Receipt Not Invoiced (8.03.403D)

I've seen a couple of threads about clearing up 'Received Not Invoiced'
receipts, but the solutions(create a $0.00 invoice) seem to be for the
occasional cleanup.

I've got the problem where receipts go back for years (and from versions
back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without
creating a storm of GL transactions), without having to go into each
one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W
link to tables), but this makes me shudder (as most of you are probably
doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin

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

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

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

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





[Non-text portions of this message have been removed]
I've seen a couple of threads about clearing up 'Received Not Invoiced' receipts, but the solutions(create a $0.00 invoice) seem to be for the occasional cleanup.

I've got the problem where receipts go back for years (and from versions back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without creating a storm of GL transactions), without having to go into each one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W link to tables), but this makes me shudder (as most of you are probably doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin
Unless you are a programmer, I'd bite the bullet, pay about $500 for a
program from Epicor to close these all out!



Or maybe someone on this list has something like this already and can
help out...







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Receipt Not Invoiced (8.03.403D)





I've seen a couple of threads about clearing up 'Received Not Invoiced'
receipts, but the solutions(create a $0.00 invoice) seem to be for the
occasional cleanup.

I've got the problem where receipts go back for years (and from versions
back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without
creating a storm of GL transactions), without having to go into each
one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W
link to tables), but this makes me shudder (as most of you are probably
doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin





[Non-text portions of this message have been removed]
I am a programmer (at least I pretend to be), but my time (and worry) would quickly add up to $500.

But as an academic question, Is there any way to determine the dependencies on a field throught the system?

We all know some fields are benign (OrderDet.Char01, doesn't trigger anything, unless you've added customizations), but what finding out the others?

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Unless you are a programmer, I'd bite the bullet, pay about $500 for a
> program from Epicor to close these all out!
>
>
>
> Or maybe someone on this list has something like this already and can
> help out...
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of to.crds
> Sent: Wednesday, January 19, 2011 1:02 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Receipt Not Invoiced (8.03.403D)
>
>
>
>
>
> I've seen a couple of threads about clearing up 'Received Not Invoiced'
> receipts, but the solutions(create a $0.00 invoice) seem to be for the
> occasional cleanup.
>
> I've got the problem where receipts go back for years (and from versions
> back as far as Vista 4), and number at about 15,000.
>
> Is there a way to force those recipts to be marked as Invoiced, (without
> creating a storm of GL transactions), without having to go into each
> one, one at a time?
>
> In the past I've "tweaked" the databases (using MS Access with a R/W
> link to tables), but this makes me shudder (as most of you are probably
> doing right now). Any way to do a "where used" for a field in table?
>
> Thanks in advance,
>
> Calvin
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Do you know about the data dictionary? It's under System Management.
This will tell you all of the fields that are in all of the tables in
the database you are using.



Is this what you are looking for?







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:36 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Receipt Not Invoiced (8.03.403D)





I am a programmer (at least I pretend to be), but my time (and worry)
would quickly add up to $500.

But as an academic question, Is there any way to determine the
dependencies on a field throught the system?

We all know some fields are benign (OrderDet.Char01, doesn't trigger
anything, unless you've added customizations), but what finding out the
others?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Unless you are a programmer, I'd bite the bullet, pay about $500 for a
> program from Epicor to close these all out!
>
>
>
> Or maybe someone on this list has something like this already and can
> help out...
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of to.crds
> Sent: Wednesday, January 19, 2011 1:02 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Receipt Not Invoiced (8.03.403D)
>
>
>
>
>
> I've seen a couple of threads about clearing up 'Received Not
Invoiced'
> receipts, but the solutions(create a $0.00 invoice) seem to be for the
> occasional cleanup.
>
> I've got the problem where receipts go back for years (and from
versions
> back as far as Vista 4), and number at about 15,000.
>
> Is there a way to force those recipts to be marked as Invoiced,
(without
> creating a storm of GL transactions), without having to go into each
> one, one at a time?
>
> In the past I've "tweaked" the databases (using MS Access with a R/W
> link to tables), but this makes me shudder (as most of you are
probably
> doing right now). Any way to do a "where used" for a field in table?
>
> Thanks in advance,
>
> Calvin
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
There is also dataset relationships, but this only gives relationship
dependencies on some tables, not all.







Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Manasa Reddy
Sent: Wednesday, January 19, 2011 1:40 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Receipt Not Invoiced (8.03.403D)





Do you know about the data dictionary? It's under System Management.
This will tell you all of the fields that are in all of the tables in
the database you are using.

Is this what you are looking for?

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:36 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Re: Receipt Not Invoiced (8.03.403D)

I am a programmer (at least I pretend to be), but my time (and worry)
would quickly add up to $500.

But as an academic question, Is there any way to determine the
dependencies on a field throught the system?

We all know some fields are benign (OrderDet.Char01, doesn't trigger
anything, unless you've added customizations), but what finding out the
others?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Unless you are a programmer, I'd bite the bullet, pay about $500 for a
> program from Epicor to close these all out!
>
>
>
> Or maybe someone on this list has something like this already and can
> help out...
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of to.crds
> Sent: Wednesday, January 19, 2011 1:02 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Receipt Not Invoiced (8.03.403D)
>
>
>
>
>
> I've seen a couple of threads about clearing up 'Received Not
Invoiced'
> receipts, but the solutions(create a $0.00 invoice) seem to be for the
> occasional cleanup.
>
> I've got the problem where receipts go back for years (and from
versions
> back as far as Vista 4), and number at about 15,000.
>
> Is there a way to force those recipts to be marked as Invoiced,
(without
> creating a storm of GL transactions), without having to go into each
> one, one at a time?
>
> In the past I've "tweaked" the databases (using MS Access with a R/W
> link to tables), but this makes me shudder (as most of you are
probably
> doing right now). Any way to do a "where used" for a field in table?
>
> Thanks in advance,
>
> Calvin
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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





[Non-text portions of this message have been removed]
I'm famailiar with the Data dictionaries. I'm looking to findout where a field is referenced by other tables, or processes.

Usually when a field is R/O for all data views, that means the system wants exclusive control, and it's either changed by specific processes, or changing it triggers other processes.

Calvin

--- In vantage@yahoogroups.com, "Manasa Reddy" <manasa@...> wrote:
>
> Do you know about the data dictionary? It's under System Management.
> This will tell you all of the fields that are in all of the tables in
> the database you are using.
>
>
>
> Is this what you are looking for?
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of to.crds
> Sent: Wednesday, January 19, 2011 1:36 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Receipt Not Invoiced (8.03.403D)
>
>
>
>
>
> I am a programmer (at least I pretend to be), but my time (and worry)
> would quickly add up to $500.
>
> But as an academic question, Is there any way to determine the
> dependencies on a field throught the system?
>
> We all know some fields are benign (OrderDet.Char01, doesn't trigger
> anything, unless you've added customizations), but what finding out the
> others?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Unless you are a programmer, I'd bite the bullet, pay about $500 for a
> > program from Epicor to close these all out!
> >
> >
> >
> > Or maybe someone on this list has something like this already and can
> > help out...
> >
> >
> >
> >
> >
> >
> >
> > Manasa
> >
> > 630.806.2000 x1515
> >
> >
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of to.crds
> > Sent: Wednesday, January 19, 2011 1:02 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Receipt Not Invoiced (8.03.403D)
> >
> >
> >
> >
> >
> > I've seen a couple of threads about clearing up 'Received Not
> Invoiced'
> > receipts, but the solutions(create a $0.00 invoice) seem to be for the
> > occasional cleanup.
> >
> > I've got the problem where receipts go back for years (and from
> versions
> > back as far as Vista 4), and number at about 15,000.
> >
> > Is there a way to force those recipts to be marked as Invoiced,
> (without
> > creating a storm of GL transactions), without having to go into each
> > one, one at a time?
> >
> > In the past I've "tweaked" the databases (using MS Access with a R/W
> > link to tables), but this makes me shudder (as most of you are
> probably
> > doing right now). Any way to do a "where used" for a field in table?
> >
> > Thanks in advance,
> >
> > Calvin
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
$500 for a program from Custom Programming? Can I have the name of your
sales rep please - I'm going through them from now on!!



Kevin



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:25 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)





Unless you are a programmer, I'd bite the bullet, pay about $500 for a
program from Epicor to close these all out!

Or maybe someone on this list has something like this already and can
help out...

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Receipt Not Invoiced (8.03.403D)

I've seen a couple of threads about clearing up 'Received Not Invoiced'
receipts, but the solutions(create a $0.00 invoice) seem to be for the
occasional cleanup.

I've got the problem where receipts go back for years (and from versions
back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without
creating a storm of GL transactions), without having to go into each
one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W
link to tables), but this makes me shudder (as most of you are probably
doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin

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





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



The point was that if YOU were too busy to do it, then having custom
programming do it for you is not a big deal. For what this guy wants it
should not cost more than $1200 or so...it is a simple program in terms
of what he wants done. But then Epicor has it standards and I am sure
it is more now than it was 5 years ago!











Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Kevin Simon
Sent: Wednesday, January 19, 2011 1:49 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)





$500 for a program from Custom Programming? Can I have the name of your
sales rep please - I'm going through them from now on!!

Kevin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

Unless you are a programmer, I'd bite the bullet, pay about $500 for a
program from Epicor to close these all out!

Or maybe someone on this list has something like this already and can
help out...

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Receipt Not Invoiced (8.03.403D)

I've seen a couple of threads about clearing up 'Received Not Invoiced'
receipts, but the solutions(create a $0.00 invoice) seem to be for the
occasional cleanup.

I've got the problem where receipts go back for years (and from versions
back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without
creating a storm of GL transactions), without having to go into each
one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W
link to tables), but this makes me shudder (as most of you are probably
doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin

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

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





[Non-text portions of this message have been removed]
Yep, I'm the wrong person to ask...I'm sure someone else WILL answer
your question eventually!



Good luck!









Manasa

630.806.2000 x1515





________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Receipt Not Invoiced (8.03.403D)





I'm famailiar with the Data dictionaries. I'm looking to findout where a
field is referenced by other tables, or processes.

Usually when a field is R/O for all data views, that means the system
wants exclusive control, and it's either changed by specific processes,
or changing it triggers other processes.

Calvin

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Manasa Reddy" <manasa@...> wrote:
>
> Do you know about the data dictionary? It's under System Management.
> This will tell you all of the fields that are in all of the tables in
> the database you are using.
>
>
>
> Is this what you are looking for?
>
>
>
>
>
>
>
> Manasa
>
> 630.806.2000 x1515
>
>
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of to.crds
> Sent: Wednesday, January 19, 2011 1:36 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Receipt Not Invoiced (8.03.403D)
>
>
>
>
>
> I am a programmer (at least I pretend to be), but my time (and worry)
> would quickly add up to $500.
>
> But as an academic question, Is there any way to determine the
> dependencies on a field throught the system?
>
> We all know some fields are benign (OrderDet.Char01, doesn't trigger
> anything, unless you've added customizations), but what finding out
the
> others?
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Manasa Reddy" <manasa@> wrote:
> >
> > Unless you are a programmer, I'd bite the bullet, pay about $500 for
a
> > program from Epicor to close these all out!
> >
> >
> >
> > Or maybe someone on this list has something like this already and
can
> > help out...
> >
> >
> >
> >
> >
> >
> >
> > Manasa
> >
> > 630.806.2000 x1515
> >
> >
> >
> >
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of to.crds
> > Sent: Wednesday, January 19, 2011 1:02 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Receipt Not Invoiced (8.03.403D)
> >
> >
> >
> >
> >
> > I've seen a couple of threads about clearing up 'Received Not
> Invoiced'
> > receipts, but the solutions(create a $0.00 invoice) seem to be for
the
> > occasional cleanup.
> >
> > I've got the problem where receipts go back for years (and from
> versions
> > back as far as Vista 4), and number at about 15,000.
> >
> > Is there a way to force those recipts to be marked as Invoiced,
> (without
> > creating a storm of GL transactions), without having to go into each
> > one, one at a time?
> >
> > In the past I've "tweaked" the databases (using MS Access with a R/W
> > link to tables), but this makes me shudder (as most of you are
> probably
> > doing right now). Any way to do a "where used" for a field in table?

> >
> > Thanks in advance,
> >
> > Calvin
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
I am not sure what your question is.

RcvHead.Invoiced and RcvDtl.Invoiced are the flags that mark a receipt as invoiced or not.

As for a where-used for a field name, the following progress code will tell you where a particular field name is used (in this case, the field name is systemabc. That tells you which tables have a field with that name. I don't know if you have a progress editor, but there is an equivalent command in sql to read the metaschema.

FOR EACH _field
WHERE _field._field-name = "systemabc",
EACH _file OF _field:
DISPLAY _file._file-name.
END.


--- In vantage@yahoogroups.com, "to.crds" <ckrusen@...> wrote:
>
> I've seen a couple of threads about clearing up 'Received Not Invoiced' receipts, but the solutions(create a $0.00 invoice) seem to be for the occasional cleanup.
>
> I've got the problem where receipts go back for years (and from versions back as far as Vista 4), and number at about 15,000.
>
> Is there a way to force those recipts to be marked as Invoiced, (without creating a storm of GL transactions), without having to go into each one, one at a time?
>
> In the past I've "tweaked" the databases (using MS Access with a R/W link to tables), but this makes me shudder (as most of you are probably doing right now). Any way to do a "where used" for a field in table?
>
> Thanks in advance,
>
> Calvin
>
My experience with custom programming has been that by the time you wait the
six weeks to actually talk to someone, then have to write up the specs, wait
for them to return their design, go back through and correct them on it,
test what they gave you and figure out it solves a problem, just not your
problem, etc, etc, etc.



You end up spending $2000 of your time to pay them $4000 for something you
could've done for $500 yourself.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)





Sorry Kevin,

The point was that if YOU were too busy to do it, then having custom
programming do it for you is not a big deal. For what this guy wants it
should not cost more than $1200 or so...it is a simple program in terms
of what he wants done. But then Epicor has it standards and I am sure
it is more now than it was 5 years ago!

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Kevin Simon
Sent: Wednesday, January 19, 2011 1:49 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

$500 for a program from Custom Programming? Can I have the name of your
sales rep please - I'm going through them from now on!!

Kevin

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf Of
Manasa Reddy
Sent: Wednesday, January 19, 2011 2:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Receipt Not Invoiced (8.03.403D)

Unless you are a programmer, I'd bite the bullet, pay about $500 for a
program from Epicor to close these all out!

Or maybe someone on this list has something like this already and can
help out...

Manasa

630.806.2000 x1515

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of to.crds
Sent: Wednesday, January 19, 2011 1:02 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Receipt Not Invoiced (8.03.403D)

I've seen a couple of threads about clearing up 'Received Not Invoiced'
receipts, but the solutions(create a $0.00 invoice) seem to be for the
occasional cleanup.

I've got the problem where receipts go back for years (and from versions
back as far as Vista 4), and number at about 15,000.

Is there a way to force those recipts to be marked as Invoiced, (without
creating a storm of GL transactions), without having to go into each
one, one at a time?

In the past I've "tweaked" the databases (using MS Access with a R/W
link to tables), but this makes me shudder (as most of you are probably
doing right now). Any way to do a "where used" for a field in table?

Thanks in advance,

Calvin

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

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

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





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