Keeping inventory of expensed items

From my understanding (only been on V8 since January), any PO that
uses a P/N that is in the Part Master, will only allow that item to
be purchased 'To Inventory'. Upon receiving the items (using
Receipt Entry) the QOH will be adjusted, and the GL account
specified in the Part's Part Class setting, will be debited. (Part
Class is sometimes refered to as Inventory Class).

!IMPORTANT! - A part in the part master without a Part Class, or an
Part Class w/o a GL acct assigned will default to the GL setup for
the main inventory.

Like John said, exclude the InvClass from the Stock Status Report.

What do you plan to do about the QOH? If you 'issue' any of the
parts to keep your QOH accurate (assuming you want to know how many
grease gun cartridges you have), you will have to do a 'Issue Misc
Material' and may have to rely on the 'Reason Code' settings to keep
the original GL acct from getting Credited (as what happens to real
inventory when it's issued to a job, Inv Credited, WIP debited.)

I'm not it won't work, but here's the first couple of 'potential
issues' that come to mind:

1. Only items purchased using a PO can automatically assign a GL
acct.
2. Items without the proper Part Class (or improperly configured
Part Class) will default to the production inventory GL.
3. The GL acct cannot be changed at the time the PO is entered.
4. Item must be Received via Receipt Entry. So those color toner
cartriges delivered right to the marketing dept. will never be
received, until marketing passes on the packing slip.
5. GL won't actually see the receipts until the WIP/Recon is
processed.
6. QOH maybe meaningless unless rigid enforcement of requisitioning
happens.
7. Issuing the items to maintain the QOH might undo the initial
debit to the desired GL expense acct.


Just my 4 cents (yeah the price of everything is going up)

Calvin



--- In vantage@yahoogroups.com, "John Atwood" <John.Atwood@...>
wrote:
>
> We use a part class for all expensed items, tie that class to the
> appropriate "expensed" GL chart and then exclude the class when
> running a stock status report.
> John Atwood
> Stellar Micro
>
> --- In vantage@yahoogroups.com, "Chamberlin, Richard"
> <rchamberlin@> wrote:
> >
> > (Vantage 8.03.405 / Target implementation Nov 08)
> >
> > For items that we expense on receipt (computer supplies, machine
> > maintenance parts, specialty tools, etc.) We want to keep
inventory
> > counts, and use Purchase Kanban as a flag for re-ordering.
> >
> > For such items we will set up part numbers with the following
> > parameters:
> >
> > Process MPR: NO
> >
> > Quantity Bearing: YES (must be Yes for inventory functionality
to
> work)
> >
> > Non-Stock Item: NO (As I read the Vantage help, this should not
> matter
> > either way because we will not be creating sales orders, or
running
> MRP
> > against them).
> >
> > Phantom: NO
> >
> >
> >
> > 1) How do we buy these, (expensed on receipt), and put
them
> into
> > inventory, without them showing up as inventory value on the
books?
> > I.e.- When we run an inventory valuation report, these should
show
> up at
> > no value, since we already expensed them. They will be in a
> separate
> > warehouse code.
> >
> > 2) We also want to hit appropriate expense GL accounts, so
we
> can
> > see what we are spending on various types of these items.
> >
> >
> >
> > Rick Chamberlin
> > Manufacturing Engineer - Planner
> > Triumph Composite Systems
> > MS# W1-71
> > (509) 623-8581
> > Cell (509) 842-4503
> > FAX (509) 623-8560
> > rchamberlin@ <mailto:rchamberlin@>
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
(Vantage 8.03.405 / Target implementation Nov 08)

For items that we expense on receipt (computer supplies, machine
maintenance parts, specialty tools, etc.) We want to keep inventory
counts, and use Purchase Kanban as a flag for re-ordering.

For such items we will set up part numbers with the following
parameters:

Process MPR: NO

Quantity Bearing: YES (must be Yes for inventory functionality to work)

Non-Stock Item: NO (As I read the Vantage help, this should not matter
either way because we will not be creating sales orders, or running MRP
against them).

Phantom: NO



1) How do we buy these, (expensed on receipt), and put them into
inventory, without them showing up as inventory value on the books?
I.e.- When we run an inventory valuation report, these should show up at
no value, since we already expensed them. They will be in a separate
warehouse code.

2) We also want to hit appropriate expense GL accounts, so we can
see what we are spending on various types of these items.



Rick Chamberlin
Manufacturing Engineer - Planner
Triumph Composite Systems
MS# W1-71
(509) 623-8581
Cell (509) 842-4503
FAX (509) 623-8560
rchamberlin@... <mailto:rchamberlin@...>





[Non-text portions of this message have been removed]
We use a part class for all expensed items, tie that class to the
appropriate "expensed" GL chart and then exclude the class when
running a stock status report.
John Atwood
Stellar Micro

--- In vantage@yahoogroups.com, "Chamberlin, Richard"
<rchamberlin@...> wrote:
>
> (Vantage 8.03.405 / Target implementation Nov 08)
>
> For items that we expense on receipt (computer supplies, machine
> maintenance parts, specialty tools, etc.) We want to keep inventory
> counts, and use Purchase Kanban as a flag for re-ordering.
>
> For such items we will set up part numbers with the following
> parameters:
>
> Process MPR: NO
>
> Quantity Bearing: YES (must be Yes for inventory functionality to
work)
>
> Non-Stock Item: NO (As I read the Vantage help, this should not
matter
> either way because we will not be creating sales orders, or running
MRP
> against them).
>
> Phantom: NO
>
>
>
> 1) How do we buy these, (expensed on receipt), and put them
into
> inventory, without them showing up as inventory value on the books?
> I.e.- When we run an inventory valuation report, these should show
up at
> no value, since we already expensed them. They will be in a
separate
> warehouse code.
>
> 2) We also want to hit appropriate expense GL accounts, so we
can
> see what we are spending on various types of these items.
>
>
>
> Rick Chamberlin
> Manufacturing Engineer - Planner
> Triumph Composite Systems
> MS# W1-71
> (509) 623-8581
> Cell (509) 842-4503
> FAX (509) 623-8560
> rchamberlin@... <mailto:rchamberlin@...>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>