|
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
|
|
| AP / Bill Open Amount for Vendor Invoice and Credit Balances |
| Author |
Message |
|
|
| Posted : 2008-12-09 08:57:16 |
I saw in your schemas that at one time there was a Bill.OpenAmount field. Using QuickBooks Pro 2006 it does not appear to be there any longer. Is there a quick and easy one place location of the current open amount/balance for AP/Vendor Invoices or Credits? From what I can see there is not, and I would need to apply all transactions to a specific BIll or Vendor Credit. However, if I am overlooking something please let me know. I will keep looking!
Thank you!
Scott Washburn
BCR Software
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2008-12-09 10:56:46 |
Try:
select Name, Balance from Vendor unoptimized
or
sp_report VendorBalanceDetail show Blank, TxnType, Date, RefNumber, Account, Amount, RunningBalance
parameters DateMacro = 'ThisYear'
|
|
|
|
|