Automation

ensure var VarConditionUpdateAssetRemove kind: condition deploy: fixedOnDeploy
  value: "<root>
      <stmt>${f:Details.TransactionType} == ${d:TransactionType.keyDebit}</stmt>
    </root>" 
  sourceForm: EntityQuickBook

ensure var VarConditionUpdateAssetAdd kind: condition modules: ["Expense"] deploy: fixedOnDeploy
  value: "<root>
      <stmt>${f:Details.TransactionType} == ${d:TransactionType.keyCredit}</stmt>
    </root>" 
  sourceForm: EntityQuickBook

ensure automation AutomateQuikBookSheet kind: spreadsheet
  modules: ["Expense"] 
  spreadsheet: QuikBooksSheet

ensure event BeforeInsert fire: beforeInsert

ensure var VarMappingQuickBookCopyRowId kind: mapping 
  modules: ["Expense"] 
  deploy: fixedOnDeploy
  fromForm: EntityQuickBook 
  toForm: EntityQuickBook 
  fieldMappingMap: {
      'updateVariant': 'updateForced',
      'emptyVariant': 'ignoreEmptyField',
      'map': {
        '${f:SysRowId}': 'Details.QuickBookRowId'
      }
    }

ensure step CopyRowId kind: copyField 
  mappingVar: VarMappingQuickBookCopyRowId

ensure var VarOutputMappingGetSpreadsheetRowId kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityAsset 
  toForm: EntityQuickBook 
  fieldMappingMap: {
      'updateVariant': 'updateForced',
      'emptyVariant': 'ignoreEmptyField',
      'map': {
        '${f:SysRowId}': 'Details.AssetRowId'
      }
    }

ensure step GetSpreadsheetRows kind: getSpreadsheetRows 
  targetSpreadsheet: AssetSheet 
  targetToSourceMappingVar: VarOutputMappingGetSpreadsheetRowId

ensure event AfterInsert fire: afterInsert

ensure step UpdateAssetRemove kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetRemove 
  operation: subtract 
  value: "${f:Details.TotalAmount}" 
  rowField: Details.AssetRowId 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset

ensure step UpdateAssetAdd kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetAdd 
  operation: add 
  value: "${f:Details.TotalAmount}" 
  rowField: Details.AssetRowId 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset

ensure event BeforeUpdate fire: beforeUpdate

ensure pipelineVar PipelinePrevAmount form: FormPipelineAmount

ensure var VarMappingQuickBookCopyTotalAmount kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityQuickBook 
  toForm: FormPipelineAmount 
  fieldMappingMap: {
      'updateVariant': 'updateForced',
      'emptyVariant': 'ignoreEmptyField',
      'map': {
        '${f:Details.TotalAmount}': 'Details.CurrentAmount'
      }
    }

ensure step CopyTotalAmount kind: copyField 
  targetPipelineVar: PipelinePrevAmount 
  mappingVar: VarMappingQuickBookCopyTotalAmount

ensure var VarTargetSpreadsheetGetSpreadsheetRows kind: condition
  modules: ["Expense"] 
  deploy: fixedOnDeploy
  value: "<root>
      <stmt>${in:Details.QuickBookRowId} == ${f:Details.QuickBookRowId}</stmt>
    </root>" 
  sourceForm: EntityQuickBook 
  inputForm: EntityQuickBook

ensure var VarOutputMappingGetSpreadsheetRows kind: mapping
  modules: ["Expense"] 
  deploy: fixedOnDeploy
  fromForm: EntityQuickBook 
  toForm: FormPipelineAmount 
  fieldMappingMap: {
      'updateVariant': 'updateForced',
      'emptyVariant': 'ignoreEmptyField',
      'map': {
        '${f:Details.TotalAmount}': 'Details.PrevAmount'
      }
    }

ensure step GetSpreadsheetRows kind: getSpreadsheetRows 
  targetSpreadsheet: QuikBooksSheet 
  targetSpreadsheetFilterVar: VarTargetSpreadsheetGetSpreadsheetRows 
  outputFormPipelineVar: PipelinePrevAmount 
  targetToSourceMappingVar: VarOutputMappingGetSpreadsheetRows

ensure step CalculateDebitAmountDiff kind: calculateFormulas 
  formulaFormPipelineVar: PipelinePrevAmount

ensure newFormula AmountDiff 
  assignToField: Details.AmountDiff 
  formula: "${f:CurrentAmount} - ${f:PrevAmount}"

ensure event AfterUpdate fire: afterUpdate

ensure var VarOutputMappingGetNetAssetRowId kind: mapping 
  deploy: fixedOnDeploy
  fromForm: EntityAsset 
  toForm: FormPipelineAmount 
  fieldMappingMap: {
      'updateVariant': 'updateForced',
      'emptyVariant': 'ignoreEmptyField',
      'map': {
        '${f:SysRowId}': 'Details.AssetRowId'
      }
    }
ensure step GetNetAssetSpreadsheetRows kind: getSpreadsheetRows 
  targetSpreadsheet: AssetSheet 
  targetToSourceMappingVar: VarOutputMappingGetNetAssetRowId

ensure step UpdateAssetRemove kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetRemove 
  operation: subtract 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset

ensure step UpdateAssetAdd kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetAdd 
  operation: add 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset

ensure event BeforeRemove fire: beforeRemove

ensure step UpdateAssetDebit kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetRemove 
  operation: add 
  value: "${f:Details.TotalAmount}" 
  rowField: Details.AssetRowId 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset

ensure step UpdateAssetCredit kind: updateLogNumber 
  executionConditionVar: VarConditionUpdateAssetAdd 
  operation: subtract 
  value: "${f:Details.TotalAmount}" 
  rowField: Details.AssetRowId 
  targetSpreadsheet: AssetSheet 
  targetField: Details.NetAsset