Knowledgebase
[QODBC-Desktop] Troubleshooting: The Template Type Problem When Creating a Sales Order
Posted by Juliet (QODBC Support) on 04 November 2011 02:53 AM

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 not compatible 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'

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