The Template Type Problem When Creating a Sales Order

Troubleshooting: The Template Type Problem When Creating a Sales Order

Problem Description

Query in QODBC Test Tool

Here is a query; its function is to create a sales order line.

INSERT INTO "SalesOrderLine"
("CustomerRefListID", "TemplateRefListID", "SalesOrderLineItemRefListID",
"SalesOrderLineQuantity," "SalesOrderLineRate", "FQSaveToCache")
VALUES
('4C0000-1040154668', '80000023-1481819084', '670004-1044572237', 5.00000, 1.00000, 0)

Error in the Result

But when executed in QODBC Test Tool, we got an error like this: "There is an invalid reference to QuickBooks Template '80000023-1481819084' in salesOrder.QuickBooks error message: The Custom Style associated with this txn is incompatible with this txn."

Instructions

This error is caused by the template list ID 80000023-1481819084. So we checked the template type of this list ID and found out that this is an invoice template.

Solution

Then we must use a sales order template to replace it.

Get a Sales Order Template ID

Query in QODBC Test Tool

INSERT INTO "SalesOrderLine"
("CustomerRefListID", "TemplateRefListID", "SalesOrderLineItemRefListID",
"SalesOrderLineQuantity", "SalesOrderLineRate","FQSaveToCache")
VALUES
('4C0000-1040154668','110000-1048186767', '670004-1044572237', 5.00000, 1.00000, 0)

This time, the query works fine.

Result

Query in QODBC Test tool, and here is the result.

Select * From SalesOrderLine Where CustomerRefListID='4C0000-1040154668' AND TemplateRefListID='110000-1048186767'