Skip to main content
Skip table of contents

Sage 100 ProvideX SQL: IM_ItemTransactionHistory Load Replace Example

IM_ItemTransactionHistory

Use the unmodified SQL generated by ETL+ for the Extract SQL Statement panel.

Load Replace Settings

  • Source Field = TransactionDate

  • Target Value or Constant = DATEADD(DAY,-365,CONVERT(DATE, GetDate() ))

image-20240724-015522.png

Screenshot from example.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.

Contact Support Close