Hi Brenda

There isn't any table called vndact.  The 6 letters to the left of the ^ need to be an actual table in Sage, only the right 6 letters can be whatever you want.  If you only need the ytd total, then you can get that from the actpay table.  Perhaps that what you meant to do.  Compare your calculated field to others that are already in Sage and you'll see the difference.

Hi Char,

The actual table/field I used in the report (now that I'm at the office and can look) was vndytd.ytdact.

This is the new table created to hold multiple fiscal year activity for a vendor in version 19.2.

I selected this table/field directly from the vendor tables provided and copied it exactly.

Here's the problem, as I see it.

In order to get expired certificate information, the primary table that you have to use is "Vendor Certificates."

There is another table called "Vendor Invoice Activity"

Ultimately, I need information from both of these tables to write the report that I want, as I want to see expired certificates for vendors with whom we have had activity in this fiscal year.

If I select "Vendor Certificates" as the primary table, the "Vendor Invoice Activity" table is not one of the additional tables listed as available. Even if I use a global calculated field (which is what I've been doing), the system doesn't seem to like this - as it prints vndytd.ytdact - instead of the amount of activity in this fiscal year.

If I select "Vendor Invoice Activity" as the primary table, the "Vendor Certificates" table is not one of the additional tables listed as available. If I create a global calculated field using information from the vendor certificates table (again, copying the table name and field names directly from those tables), I get a report that shows the vendor name and correct invoice activity, but prints the field names (vndcrt.dscrpt and vndcrt.expdte) instead of the actual description and expiration date.

This leads me to conclude that the problem is that the report writer only allows use of tables that are included in the "sub tables"  under the primary table - and that the issue here is that the vendor certificates table (vndcrt) and the vendor activity table (vndytd) are not linked in a way that allows them to be combined on one report.

Does this description make more sense to you now? I am still hoping to get some resolution without having to spend hundreds of more dollars and still needing a program fix at the end of the day.

Again, we used to be able to create this report just fine in version 18.3 - but in that version, the vendor ytd activity was included in the accounts payable table. In version 19.2, a new table has been created to hold that information.

Hi James

I'm sorry I wasn't able to get back with you but we hadn't upgraded yet so I couldn't test your issue.  Please let us all know if you get an answer from tech support.

Hi James

I'm sorry I wasn't able to get back with you but we hadn't upgraded yet so I couldn't test your issue.  Please let us all know if you get an answer from tech support.