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