Solved

QuickBooks QBFC

Posted on 2013-01-16
5
1,679 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
  • 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 92

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 92

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction Although it is an old technology, serial ports are still being used by many hardware manufacturers. If you develop applications in C#, Microsoft .NET framework has SerialPort class to communicate with the serial ports.  I needed to…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

911 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now