Troubleshooting - How can I change the pricing and quantity of Items in an ItemGroup?

Problem Description:

How can I change the price of each individual item in a group? Is it possible? If yes please give me an example.

Solution:

The price of an item within an ItemGroup is determined by the ItemInventory, ItemService, ItemOtherCharge item itself. The price of an ItemService item can be done using standard UPDATE statements, for example:

For Example:

Update ItemService Set SalesOrPurchasePrice=40 where Name='Floor Plans'

You cannot change the price or quantity of individual item group lines within an Invoice. If you want to that, you should read the item group lines and write each item separately on separate invoice lines. You can, however, state the quantity of the item group itself.