Knowledgebase: TroubleShooting
[QODBC-Desktop] Troubleshooting - How can I change the pricing and quantity of Items in an ItemGroup?
Posted by Jack - QODBC Support on 09 March 2016 12:44 PM

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.

(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).