gbronson

Forum Replies Created

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • in reply to: Error connecting to QB file, unable to authorize. #64669

    gbronson
    Premium Member

    If you email a solution to someone directly, how does it help anyone else here?

    in reply to: Where are my post going? #64609

    gbronson
    Premium Member

    Can’t post replies with code

    in reply to: Where are my post going? #64575

    gbronson
    Premium Member

    Okay i give up. My forum post with code on them won’t show up. I’m pasting it here to see if it shows up.

    How frustrating!!

    I’m using the trial in a C# Windows Application. I can connect to the QB database. I am attempting to return data from a report i normally run in OpenSync. Its the Profit and Loss Budget Overview Report. Here is the code i used which i had to figure our on my own using some samples from this forum and trying to figure it out on my own.

    It returns the following XML

    "<BudgetSummaryReportQueryRq><BudgetSummaryReportType>ProfitAndLossBudgetOverview</BudgetSummaryReportType><FiscalYear>2018</FiscalYear><ReportClassFilter><FullName>Inn:Rooms</FullName></ReportClassFilter></BudgetSummaryReportQueryRq>

    Its not returning any data. Are there any decent C# examples on how to return the data using this product?

    in reply to: Where are my post going? #64574

    gbronson
    Premium Member

    Now this one worked – Hmmmm

    in reply to: Edit "Button" does not display the correct table name #64567

    gbronson
    Premium Member

    It definitely something to do with the newest version. I uninstalled OpenSync and reinstalled. If i use 3.0.19 the selections show the correct properties. If i choose the upgrade option to 3.0.24 then the selections are incorrect.

    in reply to: Edit "Button" does not display the correct table name #64563

    gbronson
    Premium Member

    Very strange. I open the application for the first time and select a task. The properties to the right shows the correct data. If i select on another one, the properties of the first task are displayed. I’m afraid to run or edit anything because i don’t know what it will do. See attached screen shots.

    Can you help?

    Attachments:
    You must be logged in to view attached files.
    in reply to: Edit "Button" does not display the correct table name #64560

    gbronson
    Premium Member

    There appears to be more problems than that. The details section is listing the wrong output table as well. All of my Tasks were imported from the version 2 configuration so maybe the import process is at fault. I’m not sure.

    in reply to: How to select multiple reports and run them. #63134

    gbronson
    Premium Member

    Do you have another product that would allow me to run multiple reports? Like COREOBJX through Visual Studio or something like that?


    gbronson
    Premium Member

    Sorry for the delay. It is attached. I’m getting ready to run the reports again tomorrow.

    Attachments:
    You must be logged in to view attached files.

    gbronson
    Premium Member

    Attached

    Attachments:
    You must be logged in to view attached files.

    gbronson
    Premium Member

    I closed QB and it does the same thing.


    gbronson
    Premium Member

    A solution for this is looking like it is going to get a bit complicated so I wanted to make sure i was clear on the problem i was having. I don’t need to really look up when an account assigned to an item was changed and by who or anything like that. I just need to run a SQL query and have the results match what i see in a report in QB. If i run a report for 2015 in QB it will accurately show the amounts and somehow know that an account was assigned to an item differently in 2015. When i run a report for 2016 or at any time after the account was reassigned to a different account, QB also knows that and displays the proper amounts and account information in the details. I assumed this historical entries would be stored in the transaction table but it doesn’t seem to be the case. I just thought i needed to link to another table to match up the right item and account. Shouldn’t the transaction table hold all the historical data?


    gbronson
    Premium Member

    Boy i wish I would have known that earlier. I have lots of hours wrapped up in this project. But Ok. I had to dump reports for the budget data so why not this. Any idea what report i would think about running to get the change history of at least the items and account associations?

    Thanks.

Viewing 13 posts - 1 through 13 (of 13 total)