Multi-Line Invoices with Discount (QBOE) |
Author |
Message |
|
Posted : 2007-11-28 17:53:07 |
Has anyone concurred this.. the example in the forum doesn't work for QBOE? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-11-29 07:00:37 |
Do you mean: How do I apply PriceLevel Profile to Invoice Line Items?
QuickBooks will use the default date if no date is specified in transaction inserts, but the Online Edition requires a date! So you must include a transaction date like this :-
INSERT INTO "InvoiceLine" ("CustomerRefListID", "TxnDate", "RefNumber", "InvoiceLineItemRefListID", "InvoiceLineDesc", "InvoiceLineQuantity", "InvoiceLineRate", "InvoiceLineSalesTaxCodeRefListID", "FQSaveToCache") VALUES ('800000AA-1197768105', {d '2007-11-28'} , 'Discount10', '10000-933272655', 'Picture Framing North Wall', 5.00, 49.50, '20000-999022286', 0)
and all the ListIDs will be shorter in QBOE.
|
|
|
|
|
Posted : 2008-01-06 07:18:31 |
The customer is ready to make this enhancement, but there is no "pricelevel" table in QBOE??.. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-08 12:00:38 |
Sorry, the QuickBooks Online Edition (QBOE) has a lot fewer tables than its desktop version. You will need to set up your own external pricing profile. |
|
|
|
|
Posted : 2008-01-08 12:19:52 |
but how do I get that information into QBOE so that it subtracts the discount.
I thought I could insert one invoiceline for the purchase, then insert a second invoiceline for the discount with a negative amount. That's how I interpreted the examples..
How can I do that for QBOE.. I don't care if it's a "discount", a "pricelevel" or "donuts".. as long as i can programmitically account for the discounts the same way you can in the webui..?.. n'est-ce pas? :)
For a detailed example I would fly to australia and deliver to you my mother's home-backed cookies..
Regards.. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-08 12:44:18 |
|
|
|
|
Posted : 2008-01-08 13:08:18 |
Great.. We have that already.. the part this is still missing and really the critical piece is how do I add an invoice with two lines. one line for the purchase and the second line for the discount and have QB resolve the discount automatically.. ?? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-08 13:21:53 |
You don't do two lines. Simply insert the discounted price. In the previous link, the example shows how queries are used to work out the discount as (55*((100 + -10)/100))=49.50. So it's just a case of using 49.50 as the InvoiceLineRate. |
|
|
|
|
Posted : 2008-01-08 13:35:10 |
Thanks,
How would I account for the differences in price then. When I use the QBOE website I can apply a discount (promo code) to a purchase. The discount amount and a description are available? I tried manually inputing that data, then looking to see what changes. Is there are way to do that via SQL QODBC? I just need to know what tables use for the insert and what fields are required if you already know. Or if this is one of those things that is available only through the UI then that's fine.. I just need to know.. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-01-08 13:47:48 |
QODBC is primary built for the desktop version of QuickBooks. QBOE has had a lot of revisions done to it and now has some features not in the current desktop version. Try running the query:
Select * from invoiceline where RefNumber='invoiceno'
for the invoice you created to see what lines were generated. |
|
|
|
|
Posted : 2008-01-08 14:26:10 |
will try that.. and I've tried it before.. this has been an issue since October though.. I'll let you know what I find out.. |
|
|
|