Solved

QuickBooks QBFC

Posted on 2013-01-16
5
1,737 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 96

Expert Comment

by:Experienced Member
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 96

Accepted Solution

by:
Experienced Member 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

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

Article by: Najam
Having new technologies does not mean they will completely replace old components.  Recently I had to create WCF that will be called by VB6 component.  Here I will describe what steps one should follow while doing so, please feel free to post any qu…
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…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

617 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