Ask the Expert - Consignment Inventory - Accounting Software Secrets
17138
book-template-default,single,single-book,postid-17138,bridge-core-2.6.3,qode-page-transition-enabled,ajax_fade,page_not_loaded,,qode-theme-ver-24.8,qode-theme-bridge,qode_header_in_grid,wpb-js-composer js-comp-ver-6.5.0,vc_responsive

Ask the Expert – Consignment Inventory

Ask the Expert – Consignment Inventory

Ask the Expert – Consignment Inventory

Q – How would I set up a system of invoices to track goods I consign to customers, but actually still need to be considered as part of my overall inventory?  Does QuickBooks support consignment invoicing as opposed to sales invoicing?  I am using QuickBooks Premier – Manufacturing and Wholesale Edition 2004.  Submitted by Jay

A – We presented information in a case study a couple of years ago that dealt with the consignment issue by using the item list. Now we will provide an additional alternative for those users have Premier 2003 and higher.

When the items are shipped to the consignment location, create a sales order and this can be used to create the invoice when the items are actually sold.  The other advantage of this approach is the ability to see the number of items in inventory, as well as the number of items that are held in consignment locations.

QBRA-2005: Lists > Item List

The other advantage is it is possible to create an Inventory Stock Status by Item to see the quantity available for sale.

QBRA-2005: Reports > Inventory > Inventory Stock Status by Item

Or create a Quick report for an item which includes that detail.

QBRA-2005: Lists > Item List > Single click on the item > Reports > QuickReport

List Limits Expanded

For most QuickBooks users, the list limit for the QuickBooks Pro and Premier products of 14,500 is sufficient.  For some, however, that is not the case.  We have been seeing increased list size for a variety of reasons.  One of the most common is the increased number of customers as the result of web site sales.  For version 6 and prior, the list limit was doubled for the Enterprise Solutions Product.  New with version 7, the Enterprise Solutions limit has been removed.

More information on this topic

Items

Miscellaneous Transactions