Inventory question

Yahoo Archive
1
Vicky,

Which costing method are you using? If you always purchase to a job
and only have inventory when there is "free" excess material, then
you should be able to return or salvage the material from the job.
If you NEVER purchase to stock, the inventory cost would be zero.
Standard Costing and sometimes purchasing to stock will make this
more complicated. One option is to consider using Lot Costing for
this specific part and creating a "free" lot and a "standard" lot.

As far as sheet sizes in your Access DB, Dimensional Inventory
(available in V6.1 and I assume is in V8) is designed to handle
this. As a word of caution, there are some bugs with Dimensional
Inventory in V6.1 involving DMR's (not fatal, but surprising). I
would test it out in all possible scenarios before implementing. If
it works, it is a great inventory management feature.

I hope this helps.

Michael Randolph



--- In vantage@yahoogroups.com, "regalproto" <regalproto@...> wrote:
>
> Hi Michael,
>
> We are currently on Vantage 8.0. We issue the material to the job
> upon receipt but sometimes we do not use all the material for the
> job (but we do apply all the costs regardless if there is leftover
> material). We want to just track the leftover quantity somehow
> without pushing the costs on a different job if we use it.
>
> In fact we do not want to have any costs allocated to our
inventory
> because of the fact that the material costs is allocated when we
> create the purchase order for the material. We know our job
rating
> is off utilizing this method but in the end the costs usually even
> out.
>
> Currently we use an Access Database that stores the sheet type,
size
> and quantity on hand and we would like to move this over to
Vantage
> if possible (which I think is possible as long as if does not
affect
> our GL accounts).
>
> Hope this clarifies...
>
> and thank you,
>
> Vicky Crnovrsanin
> Regal Prototypes, Inc.
>
> --- In vantage@yahoogroups.com, "ami_miker" <michael.randolph@>
> wrote:
> >
> > What version of Vantage are you on?
> >
> > Are you not issuing the material to the job upon receipt? My
> guess
> > is that you are wanting to "reserve" the material for the job,
but
> > the material may sit on the shelf for a period of time before
> actual
> > use.
> >
> > We've done something like this in V6.1, but our Plan A and Plan
B
> > had side effects. Can you give any more info on your situation?
> >
> >
> > Michael Randolph
> >
> >
> > --- In vantage@yahoogroups.com, "regalproto" <regalproto@> wrote:
> > >
> > > Is there a way to track inventory in Vantage without applying
> its
> > > costs to a job? We want to track inventory but have it stand
> > alone
> > > from our General Ledger. Reason being is that we already
apply
> > the
> > > costs of the material to a job via the purchase order and we
do
> > not
> > > want to double dip funds.
> > >
> >
>
2
Is there a way to track inventory in Vantage without applying its
costs to a job? We want to track inventory but have it stand alone
from our General Ledger. Reason being is that we already apply the
costs of the material to a job via the purchase order and we do not
want to double dip funds.
3
Is there a way to track inventory in Vantage without applying its
costs to a job? We want to track inventory but have it stand alone
from our General Ledger. Reason being is that we already apply the
costs of the material to a job via the purchase order and we do not
want to double dip funds.
4
What version of Vantage are you on?

Are you not issuing the material to the job upon receipt? My guess
is that you are wanting to "reserve" the material for the job, but
the material may sit on the shelf for a period of time before actual
use.

We've done something like this in V6.1, but our Plan A and Plan B
had side effects. Can you give any more info on your situation?


Michael Randolph


--- In vantage@yahoogroups.com, "regalproto" <regalproto@...> wrote:
>
> Is there a way to track inventory in Vantage without applying its
> costs to a job? We want to track inventory but have it stand
alone
> from our General Ledger. Reason being is that we already apply
the
> costs of the material to a job via the purchase order and we do
not
> want to double dip funds.
>
5
Hi Michael,

We are currently on Vantage 8.0. We issue the material to the job
upon receipt but sometimes we do not use all the material for the
job (but we do apply all the costs regardless if there is leftover
material). We want to just track the leftover quantity somehow
without pushing the costs on a different job if we use it.

In fact we do not want to have any costs allocated to our inventory
because of the fact that the material costs is allocated when we
create the purchase order for the material. We know our job rating
is off utilizing this method but in the end the costs usually even
out.

Currently we use an Access Database that stores the sheet type, size
and quantity on hand and we would like to move this over to Vantage
if possible (which I think is possible as long as if does not affect
our GL accounts).

Hope this clarifies...

and thank you,

Vicky Crnovrsanin
Regal Prototypes, Inc.

--- In vantage@yahoogroups.com, "ami_miker" <michael.randolph@...>
wrote:
>
> What version of Vantage are you on?
>
> Are you not issuing the material to the job upon receipt? My
guess
> is that you are wanting to "reserve" the material for the job, but
> the material may sit on the shelf for a period of time before
actual
> use.
>
> We've done something like this in V6.1, but our Plan A and Plan B
> had side effects. Can you give any more info on your situation?
>
>
> Michael Randolph
>
>
> --- In vantage@yahoogroups.com, "regalproto" <regalproto@> wrote:
> >
> > Is there a way to track inventory in Vantage without applying
its
> > costs to a job? We want to track inventory but have it stand
> alone
> > from our General Ledger. Reason being is that we already apply
> the
> > costs of the material to a job via the purchase order and we do
> not
> > want to double dip funds.
> >
>