[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

QuickBooks QBFC

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

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 101

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

You may need to view past transactions from previous QuickBooks files or other QuickBooks company files when:       1. you are working in another QuickBooks file       2. QuickBooks is closed QuickBooks users who would benefit from this artic…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
Suggested Courses

590 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