I have attempted to copy an estimate into a invoice, in general it works fine, but I am encountering some problems releated to the total amount of each item and subsequently the total of the estimate does not match the total of the new copied invoice.  

For example: When adding items in estimate the qodbc automatically adds markup. When adding items in invoices there is no mark up applied. I can work around this problem for regular items by setting the InvoiceLineAmount, but how can I work around this problem for invoice items that belong to a group since group items are added by only inserting the header and each group item is automatically added by qodbc.

Thanks in advance.

See: How do I convert an Estimate to a Sales Order? and How do I convert a Sales Order into an Invoice? 

You can also read the estimate directly and write the Invoice without a Sales Order if you wish.

I have seen the tutorials, but they do not help me. Here is the problem stated more clearly:

I create an estimate with a single group item from the demo qb file. The group item is called Rock Fountain Group. The estimate is created with the following lines:

Rock Fountain - Group Header

Fountain - Group Item $275.00

Pump - Group Item $56.00

Concerete - Group Item $0.00

Installation - Group Item $35.00

                       Group Footer $385.00

I then want to copy this estimate into an invoice. To do so I use:

Insert into InvoiceLine(InvoiceLineGroupItemGroupRefListID,FQSaveToCache) Values ('1C0000-934380927',true)

Insert into "Invoice" (CustomerRefListID) Values ('840001-1197739634')

The above sql statement generates the following line estimate:

Rock Fountain - Group Header

Fountain - Group Item $275.00

Pump - Group Item $56.00

Concerete - Group Item $0.00

Installation - Group Item $30.00 //THIS PRICE IS DIFFERENT THEN ON THE ESTIMATE

                       Group Footer $380.00 //THIS PRICE IS DIFFERENT ALSO

The problem is that qodbc does not create Estimates and Invoices the same way for the same item group. The Estimate TotalAmount does not match the Invoice TotalAmount.  How can this be fixed?

//Note: I have tried to add use the following query and received xml parse error after running the insert into Invoice

Insert into InvoiceLine(InvoiceLineGroupItemGroupRefListID, InvoiceLineGroupTotalAmount,FQSaveToCache) Values ('1C0000-934380927', 391.13,true)

Insert into "Invoice" (CustomerRefListID) Values ('840001-1197739634')

When creating a new Estimate with rock fountain group and a new invoice with rock fountain group the total amounts are different, exactly like the example that I listed.  However if I use the "copy to invoice" feature in quickbooks my invoice totals are the same as the estimate totals.