Non-stock and Quantity Bearing, flags in the Part Master

Andrew,

Could you expand on the ability to have a warehouse bin excluded
from the regular inventory?

Are you saying that I can define two locations for the part, and one
will be considered part of inventory (QOH and $ in G/L), and the
other won't?

What would be the transactions for the part? Would they go as
follows:
1) PO entered to by part to location INV (the inventoried location).
2) Receipt of part. QOH and G/L inv. acct both appropriately
adjusted.
3) Transfer parts from loaction INV to FLOOR (the "expensed"
location). QOH of INV and FLOOR adjusted, G/L transactions to debit
inv.acct and credit the related "expense" account.
4) Specify location FLOOR for the part in BOMs.
5) Mass issue parts to job. The QOH of location FLOOR is reduced by
the job qty, and job cost does not include the cost of the parts
(since we've already captured their cost when they were expensed
during the transfer in step 3).
6) Any adjustments to quantity in location FLOOR, don't create G/L
transactions.

Would that really work?

Thanks,

Calvin Krusen
--- In vantage@yahoogroups.com, "Andrew Best" <abest@...> wrote:
>
> Set the item up in Part Maintenance. Turn off MRP and PO
Suggestions
> for the part and mark it as backflush. Add the items to the BOM
and
> mark them to backflush. This way you can add them to the BOM. If
you
> don't assign a cost to the item, then inventory will go negative,
but
> won't affect the G/L. You could set the item up to pull from a bin
> marked as expense in a WH. This way, Inventory won't be affected
at
> all.
>
>
>
> Regards,
>
>
>
>
>
> Andrew Best
>
> Kice Industries, Inc.
>
> P(316)744-7151
>
> F(316)295-2412
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of bdpickering06
> Sent: Wednesday, March 26, 2008 1:29 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Non-stock and Quantity Bearing, flags in
the Part
> Master
>
>
>
> We have a similar situation. We have multiple items that we want on
> our BOM so we can view on which production units they are used. We
> aren't really interested in costs, just the ability to look up
where
> the items will be used. Unfortunately we can't find a way to add
this
> to the BOM without causing multiple problems with job
> completion/closing parameters. We don't want to have one bill in
> Vantage and a separate bill in another location that we use to
look up
> all of the supplied items like Loctite, tape, and other various
items
> that are hard to track actual quantity and cost through a bill.
> Any ideas and help would be appreciated.
> Thanks,
> Brian Pickering
> Helmer Inc.
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Is there a way to have: A)a material stocked (ie: QOH tracked), B)
used in an assembly/BOM, and C) not have its QOH automatically
adjusted when jobs for the assembly referencing the material are
processed?

Maybe an example would help. Lets pretend we use a special glue
made out of the rare material (but often used) "Unobtanium". The
Unobtanium glue is expensive, only comes in cases of twelve, 32-oz
jars, and we only need a little(~ 0.5 oz) at a time.

We want to be able to track the QOH (of 32 oz jars), include the
cost of ~0.5 oz in the cost roll-up of a related BOM, but don't want
the system to decrement inventory by the 0.5 oz per usage.

Here are the 'desired' steps...
1. PO placed for 1 case of P/N 'U-Glue'. Purch -> Inv factor = 1:12

2. Shipping recieves the case of U-Glue, causing QOH to go up by 12.

3. A stock Status report would show the 12 jars and their associated
inventory value.

4. An engineer includes U-Glue in a BOM to get accurate costing.

5. A job using U-Glue is issued, and processed normally (ie: mass
issue of materials to job). AND, the QOH of U-Glue remains
unchanged and the cost of the U-Glue is excluded from the job
material cost.

6. Workstation 'A' needs a new jar. They requisition it from
inventory, and materials managment issues it against the 'Special
Shop Supplies' account. QOH is decremented, Stock Status is still
accurate.


Any Ideas?

Thanks,

Calvin Krusen
So you would have material on a job not flagged as Backflush or Purchas
direct or Make direct. In theory it should work. The questions would be
if it will cause a suggestion some where that someone then has to
ignore. Or if it will raise a red flag when someone goes to close the
job since you would have a pending requirement still open. Depending on
how often jobs are closed it may make it difficult to know when stock
should be replenished base on actual open requirements.

Jim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Calvin Krusen
Sent: Monday, March 24, 2008 2:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Non-stock and Quantity Bearing, flags in the Part
Master



Is there a way to have: A)a material stocked (ie: QOH tracked), B)
used in an assembly/BOM, and C) not have its QOH automatically
adjusted when jobs for the assembly referencing the material are
processed?

Maybe an example would help. Lets pretend we use a special glue
made out of the rare material (but often used) "Unobtanium". The
Unobtanium glue is expensive, only comes in cases of twelve, 32-oz
jars, and we only need a little(~ 0.5 oz) at a time.

We want to be able to track the QOH (of 32 oz jars), include the
cost of ~0.5 oz in the cost roll-up of a related BOM, but don't want
the system to decrement inventory by the 0.5 oz per usage.

Here are the 'desired' steps...
1. PO placed for 1 case of P/N 'U-Glue'. Purch -> Inv factor = 1:12

2. Shipping recieves the case of U-Glue, causing QOH to go up by 12.

3. A stock Status report would show the 12 jars and their associated
inventory value.

4. An engineer includes U-Glue in a BOM to get accurate costing.

5. A job using U-Glue is issued, and processed normally (ie: mass
issue of materials to job). AND, the QOH of U-Glue remains
unchanged and the cost of the U-Glue is excluded from the job
material cost.

6. Workstation 'A' needs a new jar. They requisition it from
inventory, and materials managment issues it against the 'Special
Shop Supplies' account. QOH is decremented, Stock Status is still
accurate.

Any Ideas?

Thanks,

Calvin Krusen






[Non-text portions of this message have been removed]
You can't maintain perpetual inventory while ordering per shop
requisitions and issuing an "estimated" amount to jobs and also to a
special account. You will need to give up issuing to a special account
and regularly cycle count inventory.



Regards,





Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jim Frice
Sent: Monday, March 24, 2008 4:05 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Non-stock and Quantity Bearing, flags in the Part
Master



So you would have material on a job not flagged as Backflush or Purchas
direct or Make direct. In theory it should work. The questions would be
if it will cause a suggestion some where that someone then has to
ignore. Or if it will raise a red flag when someone goes to close the
job since you would have a pending requirement still open. Depending on
how often jobs are closed it may make it difficult to know when stock
should be replenished base on actual open requirements.

Jim

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Calvin Krusen
Sent: Monday, March 24, 2008 2:07 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Non-stock and Quantity Bearing, flags in the Part
Master

Is there a way to have: A)a material stocked (ie: QOH tracked), B)
used in an assembly/BOM, and C) not have its QOH automatically
adjusted when jobs for the assembly referencing the material are
processed?

Maybe an example would help. Lets pretend we use a special glue
made out of the rare material (but often used) "Unobtanium". The
Unobtanium glue is expensive, only comes in cases of twelve, 32-oz
jars, and we only need a little(~ 0.5 oz) at a time.

We want to be able to track the QOH (of 32 oz jars), include the
cost of ~0.5 oz in the cost roll-up of a related BOM, but don't want
the system to decrement inventory by the 0.5 oz per usage.

Here are the 'desired' steps...
1. PO placed for 1 case of P/N 'U-Glue'. Purch -> Inv factor = 1:12

2. Shipping recieves the case of U-Glue, causing QOH to go up by 12.

3. A stock Status report would show the 12 jars and their associated
inventory value.

4. An engineer includes U-Glue in a BOM to get accurate costing.

5. A job using U-Glue is issued, and processed normally (ie: mass
issue of materials to job). AND, the QOH of U-Glue remains
unchanged and the cost of the U-Glue is excluded from the job
material cost.

6. Workstation 'A' needs a new jar. They requisition it from
inventory, and materials managment issues it against the 'Special
Shop Supplies' account. QOH is decremented, Stock Status is still
accurate.

Any Ideas?

Thanks,

Calvin Krusen

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





[Non-text portions of this message have been removed]
I am a little confused about the desired result. If Engineering
wants the U-Glue to be on the BOM for "accurate costing", why
wouldn't you want to issue the material and adjust inventory
accordingly?

I had a client that wanted track production critical glue, but the
quantity was so small that the cost was insignificant. The actual
use varied greatly, depending on the job quantity and the number of
back to back jobs. There were also shelf life issues, so ordering
mass quantities wouldn't solve the problem. We had to get a little
creative with that situation, but it sounds completely different.
Their goal was "Don't run out", instead of "Capture the costs".

Can you provide a little more information to the group?


Michael Randolph
Infinity Business Consulting
mrandolph@...


--- In vantage@yahoogroups.com, "Calvin Krusen" <ckrusen@...> wrote:
>
> Is there a way to have: A)a material stocked (ie: QOH tracked), B)
> used in an assembly/BOM, and C) not have its QOH automatically
> adjusted when jobs for the assembly referencing the material are
> processed?
>
> Maybe an example would help. Lets pretend we use a special glue
> made out of the rare material (but often used) "Unobtanium". The
> Unobtanium glue is expensive, only comes in cases of twelve, 32-
oz
> jars, and we only need a little(~ 0.5 oz) at a time.
>
> We want to be able to track the QOH (of 32 oz jars), include the
> cost of ~0.5 oz in the cost roll-up of a related BOM, but don't
want
> the system to decrement inventory by the 0.5 oz per usage.
>
> Here are the 'desired' steps...
> 1. PO placed for 1 case of P/N 'U-Glue'. Purch -> Inv factor =
1:12
>
> 2. Shipping recieves the case of U-Glue, causing QOH to go up by
12.
>
> 3. A stock Status report would show the 12 jars and their
associated
> inventory value.
>
> 4. An engineer includes U-Glue in a BOM to get accurate costing.
>
> 5. A job using U-Glue is issued, and processed normally (ie: mass
> issue of materials to job). AND, the QOH of U-Glue remains
> unchanged and the cost of the U-Glue is excluded from the job
> material cost.
>
> 6. Workstation 'A' needs a new jar. They requisition it from
> inventory, and materials managment issues it against the 'Special
> Shop Supplies' account. QOH is decremented, Stock Status is still
> accurate.
>
>
> Any Ideas?
>
> Thanks,
>
> Calvin Krusen
>
We have a similar situation. We have multiple items that we want on
our BOM so we can view on which production units they are used. We
aren't really interested in costs, just the ability to look up where
the items will be used. Unfortunately we can't find a way to add this
to the BOM without causing multiple problems with job
completion/closing parameters. We don't want to have one bill in
Vantage and a separate bill in another location that we use to look up
all of the supplied items like Loctite, tape, and other various items
that are hard to track actual quantity and cost through a bill.
Any ideas and help would be appreciated.
Thanks,
Brian Pickering
Helmer Inc.
Set the item up in Part Maintenance. Turn off MRP and PO Suggestions
for the part and mark it as backflush. Add the items to the BOM and
mark them to backflush. This way you can add them to the BOM. If you
don't assign a cost to the item, then inventory will go negative, but
won't affect the G/L. You could set the item up to pull from a bin
marked as expense in a WH. This way, Inventory won't be affected at
all.



Regards,





Andrew Best

Kice Industries, Inc.

P(316)744-7151

F(316)295-2412



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of bdpickering06
Sent: Wednesday, March 26, 2008 1:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Non-stock and Quantity Bearing, flags in the Part
Master



We have a similar situation. We have multiple items that we want on
our BOM so we can view on which production units they are used. We
aren't really interested in costs, just the ability to look up where
the items will be used. Unfortunately we can't find a way to add this
to the BOM without causing multiple problems with job
completion/closing parameters. We don't want to have one bill in
Vantage and a separate bill in another location that we use to look up
all of the supplied items like Loctite, tape, and other various items
that are hard to track actual quantity and cost through a bill.
Any ideas and help would be appreciated.
Thanks,
Brian Pickering
Helmer Inc.





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