• Jérome Perrin's avatar
    bank_reconciliation: add scripts for indexing bank_reconciliation in stock table · cfec8d2b
    Jérome Perrin authored
    These scripts are not used by default, because it's not convenient to
    extend stock table, but sites with large amount of payment transactions
    are advised to customize stock table (by patching `z_create_stock` and
    `z_catalog_stock_list` to add:
    
     * `stock.aggregate_bank_reconciliation_date`, indexing
      `Movement_getSourceAggregateBankReconciliationDate` for source side
      and `Movement_getDestinationAggregateBankReconciliationDate` for
      destination side.
    * `stock.aggregate_bank_reconciliation_uid`, indexing
      `Movement_getSourceAggregateBankReconciliationUid` for source side
      and `Movement_getDestinationAggregateBankReconciliationUid` for
      destination side.
    * configure `aggregate_bank_reconciliation_date` and
      `stock.aggregate_bank_reconciliation_date` as datetime keys.
    
    These two columns `aggregate_bank_reconciliation_date` and
    `aggregate_bank_reconciliation_uid` should have priority over related keys
    of the same name (It may be needed to remove the related keys as part of
    the customisation)
    cfec8d2b
Movement_getDestinationAggregateBankReconciliationDate.py 218 Bytes