Sage X3

Welcome to the Sage X3 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros from around the globe.

What does ZTABCHANGE do and should stored procedure ZREFCNVRATES run on a job?

Posted By Jonathan C over 7 years ago

Recently I ran into an issue where the our newly created fiscal year was not showing up in the GL Transaction Detail with Year-End Simulation. After some digging it was determined that the GL Transaction Detail with Year-End Simulation process had the selection filter "ZTABCHANGE.CHGTYP_0 = 1". It turned out, manually running the stored procedure SEI_LIVE.ZREFCNVRATES needed to be run to populate ZTABCHANGE with the necessary dates. After running the SP, fiscal year 17 appeared.

My question is, should this stored procedure be running on its own? Is there a job or scheduler failing somewhere?

0 Sage Employee over 7 years ago

Hi Jonathan,

Thank you for your question. Yes, you should have one SQL Server Agent job for each custom schema created during the template
import as noted in section 2.4.1 Setup on SQL Server of the Data Source and Template Configuration.

Note: This answer assumed you use SQL and references the PDF from SEI 7.2

If this answers your question, please mark you question as answered.

Cheers,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage X3

What does ZTABCHANGE do and should stored procedure ZREFCNVRATES run on a job?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING