Looks like quite a few were hit by Nimda - we still haven't recovered
completely.
I thought I would take the time to explain in more detail why the
mass update of our shipping department bins works for us.
No, we do not interface inventory with the GL, one reason is the
same 'personnel problem' and inaccurate data entry. That doesn't
mean we're not using standard costing in some form. We apply costs
with the help of special reports and programs that calculate standard
and actual for finished goods in the shipping warehouse. Our custom
inventory program and database allows us to track in-process material
and apply costs to it also. Manual GL entries are then made.
We also have a Vantage WIP program that takes a snapshot of part
quantities and locations, and applies cost, and then compares to cost
of physical inventory.
Back to Jason's question. If Vantage is not posting inventory to GL,
he could change bin values at will, couldn't he? Well, at least with
the correct tools..
Even if posting to GL, I don't see a problem creating PartTran
entries to balance bins to zero, as Mark brought to my attention.
Lonnie
completely.
I thought I would take the time to explain in more detail why the
mass update of our shipping department bins works for us.
No, we do not interface inventory with the GL, one reason is the
same 'personnel problem' and inaccurate data entry. That doesn't
mean we're not using standard costing in some form. We apply costs
with the help of special reports and programs that calculate standard
and actual for finished goods in the shipping warehouse. Our custom
inventory program and database allows us to track in-process material
and apply costs to it also. Manual GL entries are then made.
We also have a Vantage WIP program that takes a snapshot of part
quantities and locations, and applies cost, and then compares to cost
of physical inventory.
Back to Jason's question. If Vantage is not posting inventory to GL,
he could change bin values at will, couldn't he? Well, at least with
the correct tools..
Even if posting to GL, I don't see a problem creating PartTran
entries to balance bins to zero, as Mark brought to my attention.
Lonnie
--- In vantage@y..., Lydia Coffman <lcoffman@c...> wrote:
> I too have been off-line for a few days, but I would suggest that
in this case, using the inventory count is probably the best idea.
You have a definite trail-when you zeroed it, when you put in the
actual count, and your costs are accounted for-I'm sure that there
are some G/L issues that will bite you in the butt, maybe Lonnie's
accountant has made allowances for that, but some accountants (ours
in particular) would have a fit.
Try just doing a few items first, the data entry is very fast-and as I
recall, you don't actually have to print the tags. Way back -- we
had to count our full inventory every couple of months due to some
internal personnel problems, (which are now resolved), so we got
really good at it. Even the quantity adjustment feature seems like a
better idea, and it has its own set of problems.
I would think that especially a new user should think long and hard
before you start poking around in your database. The ripple effect
will almost certainly rear its ugly head.
Just my three cents worth - haven't said much lately.
Lydia
lcoffman@c...
>
>
> -----Original Message-----
> From: Wayne Cox [mailto:wmc@u...]
> Sent: Monday, September 24, 2001 7:39 AM
> To: vantage@y...
> Subject: RE: [Vantage] Re: Mass Zero
>
> At 08:21 AM 9/24/2001 , you wrote:
> >Now let me see if I got this right. There is progress code that
can do
> >this. But there are some issues. 1) I have never done anything
like that
> >and 2) you could perminently mess up you Vantage code.
>
> You would need to procure the ProVision development package and
your own
> programming resources; Or make arrangements with an outsider who
does to
> compile a program to do it. Yes, it is possible to bung up your
data, or
> at least make things inconsistent with how the Vantage programs
expect it.
>
> If Epicor gets wind of it.... well, in the past they've made some
nasty
> threats, like cutting off tech support and such, if you start
bypassing
> Vantage and poking your own data in directly. Though some places
seem to
> have gotten their blessing to make updates.
>
> >The other option is to use count entry and generate tags and go
line
> >by line adjusting your counts.(time consuming but safer) Could
you explan
> >the Ground Control utility or can I find info on this somewhere.
>
> Ground Control is a share-ware windows scripting or macro utility.
You can
> write scripts to send key strokes, mouse actions, etc to another
windows
> program to automate repetitive tasks. An evaluation version 2.10
is in our
> files page at Yahoo. The company that writes it is currently up to
version
> 3.0, but found it wasn't compatible with Vantage 4 / Progress 9.0.
>
> -Wayne