Knowledgebase: Tutorials
[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 item in a group? Is it possible? If yes, please give me an example.

Solution:

The ItemInventory, ItemService, and ItemOtherCharge item itself determines the price of an item within an ItemGroup. The cost 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. To do 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.

(1 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).