Tracking consumables using Inventory Module GP

[H@discussions.microsoft.com Frank H]

I would like to know if im able to track consumables using great plains
inventory module, there's this company that purchases office supplies
(Ej. Masking Tape Roll, Rubber Bands, Staples) and they have designated a Bin
Location to those Items, also those items are not added to the inventory
account, so when trying to create an adjustment it asks for an offset
account, how do i set that up so that Purchasing creates the PO, they
get approved, the vendor ships the order, we receive it in GP the item
quantities are updated, and when the "Payroll Department" asks for 3
Masking Tapes those are deducted from the inventory but it does not
affect the Inventory Offset Account, because it's a consumable.

Thanks for any help provided.

[Frank Hamelly, MCP-GP]

>From one Frank H to another:

One way you could handle this is to setup a 'Consumables' inventory
account - make it a P&L account so the items are expensed when they
are received. Then, when the consumables are issued to the requesting
department, use the requesting department expense account as the
Inventory Offset account. This way, the costs of the consumables
would be charged out to the correct department and anything left in
that account at period-end could be considered general consumables
expense.

Hope this helps,

Frank Hamelly, MCP-GP
NOVA Solutions LLC
Melbourne, FL

[Victoria [MVP]]

I would just like to second that advice. We have a customer doing this and
it's working great for them.

--
Victoria Yudin
Dynamics GP MVP
Flexible Solutions, Inc.

"Frank Hamelly, MCP-GP" <fham...@cfl.rr.com> wrote in message
news:1187788293.8...@22g2000hsm.googlegroups.com...

[Mark Polino (dynamicaccounting.net)]

Frank,

Any objection to my adding this advice to DynamicAccounting.net? With
credit to you of course. I like this suggestion.

Mark

On Aug 22, 9:38 am, "Victoria [MVP]" <victo...@flex-solutions.com>
wrote:

> I would just like to second that advice. We have a customer doing this and
> it's working great for them.
>
> --
> Victoria Yudin
> Dynamics GP MVP
> Flexible Solutions, Inc.
>

[Frank Hamelly, MCP-GP]

Go for it Mark. We're all here to help the users :)

Thanks for asking.

Frank