Sage 100 ProvideX SQL: GL_DetailPosting Load Replace Example
GL_DetailPosting
Use the unmodified SQL generated by ETL+ for the Extract SQL Statement panel.
Load Replace Settings
Source Field =
GL_DetailPosting
Target Value or Constant =
DATEADD(DAY,-365,CONVERT(DATE, GetDate() ))