Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
Click Here
|
Buy Support
Incidents |
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
Click Here
|
|
Can I Change the pricing and quantity of Items in a groupitems |
Author |
Message |
|
Posted : 2006-11-30 04:57:29 |
Hello Everybody, How can I change the price of each individual item in a group. Is it possible? If yes please give me an example. |
|
|
Abdul Rahim Khan
Idealcomputing co. Ltd. Edinburgh Scotland, UK. |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-11-30 12:50:15 |
The price of a item within an ItemGroup is determined by the ItemInventory, ItemService, ItemOtherCharge item itself. The price of a ItemService item can be done using standard UPDATE statements, for example:
Update ItemService Set SalesOrPurchasePrice=40 where Name='Floor Plans'
|
|
|
|
|
Posted : 2006-11-30 21:56:38 |
Hello Tom, You have not understood my question as i think. I am writing a query which is used for insertion of groupitems in that query I am able to change the quantity of the item but i want to change the price which is not able through this query. " InvoiceLineSave = "INSERT INTO InvoiceLine (invoicelinegroupitemgroupreffullname,invoicelinegroupitemgroupreflistid," & _ "invoicelinetype, invoicelinegroupquantity,invoicelinesalestaxcodereffullname,FQSaveToCache)" & _ "values ('" & Partno & "','" & ListIdAndItemType(0) & "','GroupHeader','Tax',1, 1)"
"
I know that we can update the price from the query u told, I also know that the price is automatically coming from iteminventory or itemservice. But I want to change that price when i generate invoice for the group item. So, My question was is it possible to generate invoice for group item in which i can change the price of each individual item during invoice generation.
Thanks looking for your reply as early possible. |
|
|
Abdul Rahim Khan
Idealcomputing co. Ltd. Edinburgh Scotland, UK. |
| Top | |
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-12-01 08:47:31 |
You cannot currently change the price or quantity of individual item group lines within an invoice. If you want to that, you should read the itemgroup lines and write each item seperately on seperate invoice lines. You can however state the quantity of the item group itself.
See: How do I invoice item groups? for more. |
|
|
|
|