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() ))


image-20240724-015339.png
Screenshot from example.