Solved

QuickBooks QBFC

Posted on 2013-01-16
5
1,715 Views
Last Modified: 2013-01-22
I am new to quickbooks.
I have developed an application that producess the following Invoice Add File.
The SDK complains about "Terms" and does not process it.
Also, how do I add Totl amount using SDK? invoiceAdd.Total amount does not exist.
<?xml version="1.0" ?>
<?qbxml version="6.0"?>
<QBXML>
<QBXMLMsgsRq onError = "continueOnError">
<InvoiceAddRq requestID = "0">
<InvoiceAdd>
<CustomerRef>
<FullName>CV</FullName>
</CustomerRef>
<TxnDate>2013-01-16</TxnDate>
<RefNumber>12345</RefNumber>
<BillAddress>
<Addr1>461</Addr1>
<Addr2>Ave</Addr2>
<Addr3>--</Addr3>
<Addr4>--</Addr4>
<City>New York</City>
<State>NY</State>
<PostalCode>10033</PostalCode>
<Country>USA</Country>
</BillAddress>
<PONumber>123456789</PONumber>
<TermsRef>
<FullName/>
</TermsRef>
<DueDate>2013-01-16</DueDate>
<InvoiceLineAdd>
<ItemRef>
<FullName>New Item</FullName>
</ItemRef>
<Desc>New Desc</Desc>
<Quantity>1</Quantity>
<Rate>1.00</Rate>
<Amount>1.00</Amount>
</InvoiceLineAdd>
</InvoiceAdd>
</InvoiceAddRq>
</QBXMLMsgsRq>
</QBXML>
0
Comment
Question by:josephdts
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 

Assisted Solution

by:josephdts
josephdts earned 0 total points
ID: 38785126
I have got a partial answer. The Item did not exist in QB.
What I do not understand is how to create one using QBFC SDK.
There are plenty of examples how to list items, and nothing on how to add one.
0
 
LVL 95

Expert Comment

by:John Hurst
ID: 38786728
Can you add the items in QuickBooks so that they are there?  "Terms" are a function of Customer:Job (although they can go onto an invoice temporarily).  Perhaps add the terms in each Customer:Job in advance in QuickBooks.

Even without the use of an SDK, I set up my items, Vendors, and Customer:Jobs separately and in advance so the bills and invoices can be entered without "QuickAdds"

... Thinkpads_User
0
 

Author Comment

by:josephdts
ID: 38787959
Understood. Is Vendor you are referring to a <CustomerRef> node?
Is there another attribute associated with vendor, like an Id?
Thanks for the help.
0
 
LVL 95

Accepted Solution

by:
John Hurst earned 150 total points
ID: 38787998
In terms of "Terms", Vendors and Customer:Jobs work the same way.

You can add payment terms to a vendor permanently or to the Bill temporarily.
You can add due date terms to a Customer:Job permanently or to the Invoice temporarily.

These things are different but work the same way.

Customers and Vendors have a name in the main setup field that is the name QuickBooks uses as an index. There is more than one name field, but the main name cannot change. These are normal database rules.

Is there another attribute associated with vendor, like an Id?

So then, it is the main vendor name you must use for lookup. In the setup screen it is called Vendor Name. The other (changeable name) is called Company Name. There is no id number for Vendors (or for Customers).

.... Thinkpads_User
0
 

Author Closing Comment

by:josephdts
ID: 38804813
I figured out that jobs have to be created before importing invoices. The explanation on the QB structure helped.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question