V30 ODBC - Get Sage Reports

SOLVED

Hi all. Is there a way to get the reports from Sage, accessible via ODBC? Or a way to get the SQL that the reports use to do it manually in Excel?

We're using the POP_ITEM via ODBC, but we've noticed that any lines removed from the PO still appear in the POP_ITEM table with no discernible flag set in any column to suggest that it has been removed. The only difference I can see if that the ITEM_NUMBER is 0 for both the deleted line, and the first valid line. After that it increments by 1 each line.

Looking at the reports available directly in Sage, running the PO_LIST report does not include the deleted lines. I'd like to replicate that behaviour, or in this specific case we could even use that report as-is as it includes the details that we need.

Top Replies

Parents
  • 0

    I feel your pain on this one! I have a number of reports that pull via ODBC that insist on hanging on to things that should not be there anymore. On a weekly basis (out of hours when I know nobody will be logged in) I run a re-index and compression and it sorts everything out, but it is frustrating I agree!

Reply
  • 0

    I feel your pain on this one! I have a number of reports that pull via ODBC that insist on hanging on to things that should not be there anymore. On a weekly basis (out of hours when I know nobody will be logged in) I run a re-index and compression and it sorts everything out, but it is frustrating I agree!

Children
No Data