Skip to main content
Skip table of contents

Sage 100 ProvideX SQL: BM_ProductionHistoryDetail Load Replace Example

BM_ProductionHistoryDetail

SQL
SELECT 
          D.[CommentText],
          D.[ComponentDesc],
          D.[ComponentItemCode],
          D.[ComponentRevision],
          D.[ComponentWarehouseCode],
          D.[ExtendedQuantity],
          D.[GLAccountKey],
          D.[ItemCode],
          D.[ItemDesc],
          D.[ItemType],
          D.[LineKey],
          D.[LineSeqNo],
          D.[ProductionNo],
          D.[ProductionSeqNo],
          D.[QuantityPerBill],
          D.[TotalCost],
          D.[UnitOfMeasure],
          D.[Valuation], 
         H.ProductionDate
 FROM 
     { IJ  BM_ProductionHistoryHeader  H  INNER JOIN 
           BM_ProductionHistoryDetail  D 
           ON 
            H.ProductionNo    = D.ProductionNo   AND
            H.ProductionSeqNo = D.ProductionSeqNo   }

Load Replace Settings

  • Source Field = ProductionDate

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


JavaScript errors detected

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

If this problem persists, please contact our support.