Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
 Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Bill Item and Expenses data entry in QuickbooksSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v8 Forum

 New Topic 
 
 Post Reply 
[1]  
 Bill Item and Expenses data entry in Quickbooks 
 Author   Message 
  Nasarudin 
  
 Group: Members 
 Posts: 24 
 Joined: 2008-07-17 
 Profile
 Posted : 2008-11-22 07:49:49
Hi,

I enter 2 bills in Quickbooks (newly created Quickbooks file with only the 2 new Bills entered).
1. Bill with Expenses
2. Bill with Items

Followed the instructions in

How do I create Bills? 

Querried all possible Bill tables returned blank records.
Querried :
1. ItemReceipt tables produced the 2 bills
2. ItemReceiptItemLine produced the bill with items
3. ItemReceiptExpenseLine produced bill with expenses

Below is the screen captures of the Bills entries :

1. Bill with Expenses


2. Bill with items


And this is the capture of the querries using Foxpro


I'm suppose to get something from Bill, BillItemLine and BillExpenseLine tables.


Am I suppose to enter my bills into Bill, BillItemLine and BillExpenseLine tables and retrieve the records from ItemReceipt, ItemReceiptLineItem and ItemReceiptExpeseLine tables ?

TQ.

 

 
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-22 08:57:55
Not to sure why your looking at Item Receipts here. Try looking at: How do I receive Items against a Purchase Order? Receive Inventory without Bill? ItemReceipts for the actual process. 

  Top 
  Nasarudin 
  
 Group: Members 
 Posts: 24 
 Joined: 2008-07-17 
 Profile
 Posted : 2008-11-22 16:37:57
>> Not to sure why your looking at Item Receipts here.

I myself also not sure where to look for the records.
Just that the Item Receipts tables are the tables that contains Bills record that I entered in Quickbooks.
Could not find any records in the Bill tables.
I just want to know where to look for the Bill data when entered in Quickbooks.


I'll try to rephrase my question.

I entered 2 bills in quickbooks :

1.

2.


Which table should I querry to retrieve the bills ?
TQ 

 
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-22 17:34:27

Those screens are for Item Receipts which are used to receive stock without a Bill. Bills look like this:

 

  Top 
  Nasarudin 
  
 Group: Members 
 Posts: 24 
 Joined: 2008-07-17 
 Profile
 Posted : 2008-11-22 19:30:10
Ok.
Will try to check the Bill Received option in my entry and try to look for the data.

FYI, done entering Bill with the Bill Received option checked and waiting to resolve :
http://www.qdeveloper.com.au/forum.php?homeinclude=topicdetails&forum_id=1&category_id=42&post_id=2831
to further check the data.

 

 
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) 
 
  Top 
  Nasarudin 
  
 Group: Members 
 Posts: 24 
 Joined: 2008-07-17 
 Profile
 Posted : 2008-11-22 23:38:36
Hi,

Go it.

Realize that :
1. Receive Item, Bills follow later will put data in ItemReceipt tables
2. Receive Item and Bill will put data in Bill tables

The difference in the Bill Received checkbox on the Enter Bills form in Quickbooks.

Am I correct ? And got anything to add that can help me understand better ?

TQ. 

 
QODBC Desktop Read Write 2007 Asia Pacific Version 8.00.00.242
(upgrade to 9.00.00.250 @20080927)
(upgrade to 9.00.00.253 @20081125)
(downgrade to 8.00.00.242 @20081126)
Quickbooks Premier 2007/2008 Asia Edition (Malaysia) 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2008-11-23 17:31:45
I have no idea why you would enter Item Receipts with the Bill Received checkbox received and not just enter the bill in the first place. How you use QuickBooks or QuickBooks Support is not the purpose of this forum. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to