Sage 100

Do their bills go deeper than just one level?

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.

HI @Beth Bowers & @Kevin Moyes,

   The bills are only single level.    The data is "there" but because of the way the report is grouped I am only getting one of the Bills on the detail line.   I would LOVE to look at the data but they are premium and I know that it generates tamp tables and it have been able to find them but they never have had data in them when I looked. the tables were empty.   If you can tell me how to see the data, that would be great.

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.

I don't know about Premium, but if the Temps are providex files instead of SQL, then you can look at them while previewing a standard report.  Just leave the report open and previewed and you can look at a temp file (if Providex, it's the one with the User code and other blah blah in the file name at the end).

HI @Beth Bowers & @Kevin Moyes,

   The bills are only single level.    The data is "there" but because of the way the report is grouped I am only getting one of the Bills on the detail line.   I would LOVE to look at the data but they are premium and I know that it generates tamp tables and it have been able to find them but they never have had data in them when I looked. the tables were empty.   If you can tell me how to see the data, that would be great.

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.

Hi Beth, very familiar with that but it is different in SQL.    I may need to test in on an Providex version.

I don't know about Premium, but if the Temps are providex files instead of SQL, then you can look at them while previewing a standard report.  Just leave the report open and previewed and you can look at a temp file (if Providex, it's the one with the User code and other blah blah in the file name at the end).

HI @Beth Bowers & @Kevin Moyes,

   The bills are only single level.    The data is "there" but because of the way the report is grouped I am only getting one of the Bills on the detail line.   I would LOVE to look at the data but they are premium and I know that it generates tamp tables and it have been able to find them but they never have had data in them when I looked. the tables were empty.   If you can tell me how to see the data, that would be great.

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.

Hi Beth, very familiar with that but it is different in SQL.    I may need to test in on an Providex version.

I don't know about Premium, but if the Temps are providex files instead of SQL, then you can look at them while previewing a standard report.  Just leave the report open and previewed and you can look at a temp file (if Providex, it's the one with the User code and other blah blah in the file name at the end).

HI @Beth Bowers & @Kevin Moyes,

   The bills are only single level.    The data is "there" but because of the way the report is grouped I am only getting one of the Bills on the detail line.   I would LOVE to look at the data but they are premium and I know that it generates tamp tables and it have been able to find them but they never have had data in them when I looked. the tables were empty.   If you can tell me how to see the data, that would be great.

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.

Hi Beth, very familiar with that but it is different in SQL.    I may need to test in on an Providex version.

I don't know about Premium, but if the Temps are providex files instead of SQL, then you can look at them while previewing a standard report.  Just leave the report open and previewed and you can look at a temp file (if Providex, it's the one with the User code and other blah blah in the file name at the end).

HI @Beth Bowers & @Kevin Moyes,

   The bills are only single level.    The data is "there" but because of the way the report is grouped I am only getting one of the Bills on the detail line.   I would LOVE to look at the data but they are premium and I know that it generates tamp tables and it have been able to find them but they never have had data in them when I looked. the tables were empty.   If you can tell me how to see the data, that would be great.

Look at the raw work table data (with a Preview open) to properly understand the shape of that data.  It is often not what you think it "should" be.