Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

QuickBooks QBFC

Posted on 2013-01-16
5
Medium Priority
?
1,765 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 97

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 97

Accepted Solution

by:
John Hurst earned 600 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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…
This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…
Suggested Courses

715 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