Hi Phil Bernardin ,

Apologies for the delayed response. Did you find a solution to the discrepancy you're experiencing between the ODBC database (specifically the TPROJECT.DSEXPBALNY table) and the job allocation expense reports in Sage 50?

If you're still looking for guidance, here are some resources and steps that might help resolve the issue:

1. Verify Job Allocation Setup: Double-check that your job allocation settings are correctly configured. Discrepancies can often be traced back to allocation issues. You can troubleshoot job allocation settings by following the steps outlined in this Sage Knowledgebase article.

2. ODBC Data Sources: It's essential to confirm that your ODBC setup is correctly pulling data. Incorrect data sources or query parameters can lead to mismatches. You can review the Sage Knowledgebase article on configuring ODBC for Sage 50 to ensure your setup is correct.

3. Power BI Integration: If you're using Power BI for data visualization, ensure the data connection between Sage 50 and Power BI is properly configured. Incorrect queries or data transformations in Power BI may also contribute to the issue. This guide on using ODBC data with Power BI could provide valuable insights.

4. Sage Expert Services: If the issue persists, you might benefit from the assistance of Sage Expert Services. These experts offer personalized help for more complex or technical issues, including troubleshooting advanced data discrepancies and optimizing Sage 50 configurations. For more information on what Sage Expert Services can offer, check out this article on Sage Expert Services.

If you need further assistance or have any more questions, feel free to reach out. I hope this helps clarify the issue!

Warm regards,
Erzsi

Thanks for the answer! Yes, I ended up finding the issue. Total project allocations are everything from the LY PLUS the journal entries that have been allocated (two separate tables). Works like a charm!