Question Status

Verified
jstewart asked a question on 28 Jun 2013 12:11 PM

We are looking to start using GP to purchase non inventory (but frequently purchased) consumables, such as lab supplies and office supplies.  I understand that currently it is possible to create PO's in GP for these items, but we would have to type in the items every time.  Is it possible to create a list of non-inventory items in GP that we can order/put on PO's?  If not, how have others handled this situation?  

We are small enough that a total procure-to-pay solution doesn't seem like a necessity at this time, but still want to be able to track the order, purchase, and receipt of these consumables without carrying them in inventory.  

Thanks!

Reply
Verified Answer
Ian Grieve responded on 28 Jun 2013 12:37 PM

You could add them as Service Items. This would allow you to select them fromlist while not tracking them in inventory.


Author of azurecurve|Ramblings of a Dynamics GP Consultant
Senior Consultant at Perfect Image Ltd

Perfect Image/ Dynamics GP
Tel: +44 (0) 843 289 2656
1 Kings Manor, Newcastle upon Tyne, NE1 6PA, United Kingdom

Reply
Verified Answer
Mahmoud M. AlSaadi responded on 28 Jun 2013 4:50 PM

"Service" item type is the solution for dealing with consumables.Although, you should consider a work-around to get these items expensed.

DynamicAccounting has came up with a smart work-around for this issue, you need to setup a “Consumables” profit and loss account as the Inventory account for these items. When the items are issued to a department, they get expensed to the requesting department as the Inventory Offset account.

This charges out consumables to the correct department but ensures that any leftover items are still expensed at month end as general consumables.

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Verified Answer
Richard L. Whaley responded on 30 Jun 2013 10:05 AM

The use of service vs consumable depends on whether you want to track an inventory of consumable items or not.  If not, use the service item.  Otherwise, as suggested, put the items in inventory as a Sales Inventory item in a class ID of Consumable.  Then when you pull them out of inventory, do an inventory adjustment transaction and change the account number to expense them to the correct departmental account.  If you upgrade to V2013, the Reason Codes can be setup so users do not have to change account numbers but can select reason codes such as "Issue to Shipping" and the correct expense account will be hit.

This feature of 2013 is discussed on our video on Version 2013.  Visit our website to view it.

www.accoladepublications.com

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply
Verified Answer
Ian Grieve responded on 28 Jun 2013 12:37 PM

You could add them as Service Items. This would allow you to select them fromlist while not tracking them in inventory.


Author of azurecurve|Ramblings of a Dynamics GP Consultant
Senior Consultant at Perfect Image Ltd

Perfect Image/ Dynamics GP
Tel: +44 (0) 843 289 2656
1 Kings Manor, Newcastle upon Tyne, NE1 6PA, United Kingdom

Reply
Verified Answer
Mahmoud M. AlSaadi responded on 28 Jun 2013 4:50 PM

"Service" item type is the solution for dealing with consumables.Although, you should consider a work-around to get these items expensed.

DynamicAccounting has came up with a smart work-around for this issue, you need to setup a “Consumables” profit and loss account as the Inventory account for these items. When the items are issued to a department, they get expensed to the requesting department as the Inventory Offset account.

This charges out consumables to the correct department but ensures that any leftover items are still expensed at month end as general consumables.

Best Regards,

Mahmoud M. AlSaadi

Dynamics GP Essentials |   mahmoudsaadi.blogspot.com

Reply
Verified Answer
Richard L. Whaley responded on 30 Jun 2013 10:05 AM

The use of service vs consumable depends on whether you want to track an inventory of consumable items or not.  If not, use the service item.  Otherwise, as suggested, put the items in inventory as a Sales Inventory item in a class ID of Consumable.  Then when you pull them out of inventory, do an inventory adjustment transaction and change the account number to expense them to the correct departmental account.  If you upgrade to V2013, the Reason Codes can be setup so users do not have to change account numbers but can select reason codes such as "Issue to Shipping" and the correct expense account will be hit.

This feature of 2013 is discussed on our video on Version 2013.  Visit our website to view it.

www.accoladepublications.com

Richard L. Whaley Author, Publisher, Consultant

http://www.AccoladePublications.com

Enhancing your Dynamics Knowledge!

Reply