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 : Add Statement Charges to QB.Search Forum

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

 New Topic 
 
 Post Reply 
[1]  
 Add Statement Charges to QB. 
 Author   Message 
  SaSGurus 
  
 Group: Members 
 Posts: 26 
 Joined: 2006-04-02 
 Profile
 Posted : 2006-05-12 12:19:12
One of our customers is beginning QB, but has over 33 pages, about 500 transactions, or invoices, and credits (memos) to enter for each customer.  What file do I enter the statement charges to?  The data I have available is the customer list id, invoice number, invoice date, invoice amount, and Opening Balance List ID (or something similiar).  They would prefer to make statement charges because the open invoices has no line item detail in their old system.  

 
Victor Nahigian
617-965-4615 x110
jvn@sysgbs.com 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2006-05-12 13:11:28

Basically you need to first decide how you want to do this using the QuickBooks User Interface first.  You can enter the charges directly into each customer's register. You can also transfer reimbursable expenses to a billing statement.

Open the appropriate customer register and cChoose one of the following two options:

  • Click Customer Center. Select the customer or job that the statement charges apply to. Click New Transactions at the top of the list and click Statement Charges.
  • Go to the Customers menu and click Enter Statement Charges. Verify the name shown in the Customer:Job field. If the charges are for a different customer or job, select the correct customer or job from the list.

(Optional) Change the date of the statement charge.

In the Item field, enter the item you use to track this kind of charge.

Enter the quantity in the Qty field.

(Optional) Edit the description that QuickBooks provided in the Description field.

If you have more than one A/R account, click the account that you want to use from the Account drop-down list.

(Optional) Assign a class to the sale.

Click Record to record the charge.

If you have other charges to enter:

  • If the charges apply to the current customer or job, continue to enter them in the register below the charge you just entered.
  • If the charges apply to a different customer or job, choose that customer or job from the Customer:Job drop-down list at the top of the register and enter the charges.

When you're ready, you can create the billing statement.

You can use the A/R register instead
You can enter all your statement charges directly into your accounts receivable register instead of the individual customer registers. If you have a few customers, or if you like to see all your statement charges listed in one place, you may prefer the A/R register. Of course, each charge you enter in the A/R register also appears in the appropriate customer register.

After deciding how you want to handle it, enter a test statement change and examine it's entry in the Charge and ChargeLinkedTxn tables using QODBC.

See: Statement Charge Insert statement fails for more

 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to