help needed with table query

[kamey]

Hello
I need some assistance.
we would like to extract a report that gives:

Customer contact details
Bill To customer details
Outstanding Balance
Invoice Ref number
Due Date
Item Description

I have got close by using:
Customer table
Invoice table
Item table

but I cannot extract the data correctly

could you please help by advising how to setup up this query and table
linkages, using any other query method if better

ALSO:

please advise if there is another way to run the 'report genie' or
'quick report' when modifying an existing query - I cannot work it out

many thanks in advance for any help anyone can provide

kamran

[Al Buchholz]

Welcome.

what is missing from your current attempt?

What contact information are you looking for?
Some new fields have been added to Quickbooks but not added to the sdk so we can read them.

The quick report and genie are a create only tool. Use the report editor to edit a saved report.

[kamey]

Welcome.

what is missing from your current attempt?

What contact information are you looking for?
Some new fields have been added to Quickbooks but not added to the sdk so we can read them.

The quick report and genie are a create only tool. Use the report editor to edit a saved report.

Many thanks for your reply Al.

currently, the report doesn't pull out outstanding balance or item description - those fields are all blank, despite being fully populated in the tables when in browse data table mode

the customer details needed are in billto fields and shipto fields

many thanks

[Al Buchholz]

I'm guessing that the linkage of the tables is not correct...

Would have been a great topic at the webinar a few hours ago...

Can you send me an image of the set linkage or describe the fields that are linked?

[kamey]

I'm guessing that the linkage of the tables is not correct...

Would have been a great topic at the webinar a few hours ago...

Can you send me an image of the set linkage or describe the fields that are linked?

sure, see attached:

[kamey]

sorry AL there is some fault where vBulletin will not uplaod image or any other files, giving error 2038 - can I email them or PM the images to you?

[Al Buchholz]

sorry AL there is some fault where vBulletin will not uplaod image or any other files, giving error 2038 - can I email them or PM the images to you?

Email them. Use the address you sent the other message to.