group item

Why Are Items On Sales Orders Marked Closed Before Invoicing On a Partially Fulfilled Sales Order?

Chief Mechanic · September 13, 2010 ·

In QuickBooks 2009 for releases prior to R6, there was a bug (which has since been fixed) where undelivered items on a sales order that had previously been partially fulfilled had been incorrectly marked closed and could not be unchecked to be invoiced. This bug is discussed in this Intuit knowledge base article.

The bug only affects Sales Orders or Estimates that have partially invoiced line items where Unit of Measure has been enabled or where the Sales Order or Estimate contains a Group Item (with or without Unit of Measure enabled). For more information see our articles on the Unit of Measure preference and Group Items.

This bug has been corrected in the R6 release. Although the bug itself has been corrected, you may have previously entered Sales Orders or Estimates affected by the bug that will need to be fixed.

To correct the problems created by this bug, complete these steps:

Update QuickBooks to the R6 or later release
Run the Verify utility
Identify any incorrectly closed transactions
Repair those transactions
Rebuild
Re-run the Verify utility

Step 1 – Update QuickBooks to the R6 or Later Release

See our article for more information on updating your QuickBooks release.

Step 2 – Run the Verify Data Utility

To run the Verify Data utility, click the File->Utilities->Verify Data menu selection. See our article for more information on running the Verify Data utility. You’ll need to identify and correct any incorrectly closed transactions if the Verify Data utility displays this warning:

Some Sales Orders or Estimates may be incorrectly marked as closed or display incorrect invoiced quantities.

This procedure is discussed in this Intuit knowledge base article.

Step 3 – Identify Any Incorrectly Closed Transactions

If the Verify Data utility indicates that transactions were incorrectly closed, proceed to identify the affected transactions. Open the QBWin.log file in a text editor and search for Invalid Received/Invoiced Flag. Make a list of the Doc# for each affected Sales Order or Estimate. This procedure is discussed in this Intuit knowledge base article.

Step 4 – Repair the Affected Transactions

Using the list prepared in Step 3, find the first affected Sales Order or Estimate. To find a Sales Order, open the Create Sales Order window by clicking on the Customers->Create Sales Orders menu selection. Then, click the Find button and enter the first S. O. No. to be repaired.

QuickBooks Premier 2009 Create Sales Order Find

The procedure to find an Estimate is similar to that for finding a Sales Order except it starts from by clicking on the Customers->Create Estimates menu selection.

On a new blank line after the last line on the Sales Order or Estimate, enter any text at least 3 characters in length in the Description field. Save your changes by clicking the Save & New button and repeat these steps for each affected Sales Order or Estimate on the list prepared in Step 3. When you’ve repaired the last Sales Order or Estimate, you can click the Save & Close button. This procedure is discussed in this Intuit knowledge base article.

Step 5 – Run the Rebuild Data Utility

Run the Rebuild Data utility by clicking on the File->Utilities->Rebuild Data menu selection. See our article on running the Rebuild Data utility for more information.

Step 6 – Re-run the Verify Data Utility

To confirm that these steps have corrected the problem, re-run the Verify Data utility as described in Step 2 above. If the Verify Data procedure displays the warning discussed above, repeat Steps 3 through 6. If no warning appears, proceed to run inventory and sales reports to confirm that inventory data is now correct.

Prior to the availability of the R6 release, Intuit posted a description of this problem on its Wiki. See FAQ 14.

(+1 rating, 1 votes)

What Is a Group Item?

Chief Mechanic · August 23, 2010 ·

In QuickBooks a group item is a specific type of Item that is used to quickly enter a bundle of individual items that are typically bought or sold together where tracking the detail on individual items is desired.

See our article on all of the Item types supported by QuickBooks for more information.

It is similar to – but different from – an inventory assembly item, another approach to managing a bundle of individual items. An inventory assembly item is a new item created out of a bundle of individual items, reducing the quantity on hand of the individual items used to create the assembly. Where an inventory assembly item functions like a pre-assembled kit, a group item functions like an “on the fly” kit.

A group item enables a company to track the detail of each individual item in the group while optionally providing a way to simplify information presented to customers and vendors. Data entry is faster because a single group item automatically fills in the information for all of the items in the group.

QuickBooks Premier 2009 Edit Item Group Item

If the Print items in group box is not checked, QuickBooks will print only the group item itself. A customer or vendor will not see the detail on the individual items included in the group. However, company reports will track the detail of each item in the group.

Here’s an example of invoicing for the group item A1 Custom Storage Shed shown above. Entering the single group item automatically added the 2 individual items that make up the group.

QuickBooks Premier 2009 Create Invoices Customize

The price of a group item is the sum of the items in the group; the price of the group cannot be changed directly, but the price of each individual item can be changed.

Sales tax for group items is calculated based on the taxable status of each individual item in the group. In the example above, both taxable and non-taxable items are included in the group.

A group item can include any other item except other groups; it cannot be included in an inventory assembly item. There are no reports for group items. Instead, the detail of each individual item in the group is reported.

(+2 rating, 4 votes)

What Is an Inventory Assembly Item?

Chief Mechanic · August 23, 2010 ·

In QuickBooks an inventory assembly item is a specific type of Item that is the result of putting together a new inventory part out of a bundle of individual items to enable tracking finished goods separately from individual components. Normally, an inventory assembly item is used when separate raw materials are assembled, packaged, and sold as an inventory item that is separate from the component parts.

See our article on all of the Item types supported by QuickBooks for more information.

The inventory assembly item type is only available in QuickBooks Premier and Enterprise Solutions. It’s not available in QuickBooks Pro.

It is similar to – but different from – a group item, another approach to managing a bundle of individual items. A group item is a way to quickly add a bundle of items to a form while preserving the ability to track those items individually. Where an inventory assembly item functions like a pre-assembled kit, a group item functions like an “on the fly” kit.

An inventory assembly item is made up of a Bill of Materials (visible by clicking the Full View… button) which can contain a range of item types: service, inventory part, another inventory assembly, non-inventory part, and other charge. Note that a subassembly can be nested within an inventory assembly. However, the Bill of Materials cannot contain these item types: subtotal, group, discount, payment, sales tax item, or sales tax group. Further, there’s a limit of 100 items in the Bill of Materials for an inventory assembly in QuickBooks Premier; for Enterprise Solutions, that limit is 500 items.

QuickBooks Premier 2009 Bill of Materials Full View

The Cost shown for an inventory assembly item should normally not be entered. When a Cost is not entered, QuickBooks will use the Bill of Materials Cost that appears at the bottom of the table.

An inventory assembly is built from its components parts by clicking on the Vendors->Inventory Activities->Build Assemblies menu selection. During the build process, the Quantity on Hand of the inventory assembly item is increased by the Quantity to Build, and the Quantity on Hand of each component is reduced by the product of that item’s Qty in the Bill of Materials and the Quantity to Build.

Builds in QuickBooks can be either pending or final. If there are insufficient quantities of the component parts, a build will automatically be marked as Pending. You can also manually mark a build as pending by clicking on the Edit->Mark Build As Pending menu selection while the Build Assemblies window is displayed. The Pending Builds report (Reports->Inventory->Pending Builds) supports managing future build requirements.

Here’s an example of invoicing for the inventory assembly item Interior Door kit shown above. Unlike a group item, which automatically adds other items to a form and controls whether these other items are printed, the inventory assembly item appears as a single line item on a form.

QuickBooks Premier 2009 Create Invoices Inventory Assembly Item

The price of an inventory assembly item is specified, just like the price of an inventory item, and can be changed directly on a form.

Sales tax for an inventory assembly item is calculated based on the single Tax Code assigned to the inventory assembly.

(+1 rating, 1 votes)

What Item Types Does QuickBooks Support?

Chief Mechanic · August 23, 2010 ·

QuickBooks supports 11 Item Types.

Items themselves are maintained on the Lists->Item List menu selection, but the Item Types are pre-configured in QuickBooks and can’t be maintained by a user.

QuickBooks Enterprise Solutions 10 New Item

The 11 Item Types are:

Service
Inventory Part
Inventory Assembly
Non-inventory Part
Other Charge
Subtotal
Group
Discount
Payment
Sales Tax Item
Sales Tax Group

There is a 12th Item Type, Fixed Asset, which is maintained on the Lists->Fixed Asset Item List menu selection.

(+1 rating, 1 votes)

group item

Accounting

Developer

Intuit