diff options
| author | stephanchrst <stephanchrst@gmail.com> | 2024-03-26 09:05:45 +0700 |
|---|---|---|
| committer | stephanchrst <stephanchrst@gmail.com> | 2024-03-26 09:05:45 +0700 |
| commit | 22188a7899a54b48142e9ab45c1a31b3c0290a1f (patch) | |
| tree | da98fa0b4ba858033083377097d8a3a1cf24077d /import_purchase_pricelist.ktr | |
| parent | 3af3dcebb085de4afef6d7381b574149f8e90ccc (diff) | |
add override vendor pricelist compute
Diffstat (limited to 'import_purchase_pricelist.ktr')
| -rw-r--r-- | import_purchase_pricelist.ktr | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/import_purchase_pricelist.ktr b/import_purchase_pricelist.ktr index bf19d39..13decff 100644 --- a/import_purchase_pricelist.ktr +++ b/import_purchase_pricelist.ktr @@ -557,7 +557,7 @@ </partitioning> <connection>erp indoteknik production (localhost)</connection> <sql>select pp.id, pp.product_id, pp.vendor_id, rp.name as vendor, pp.product_price, pp.write_date, -pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price +pp.system_price, pp.system_last_update, pp.human_last_update, pp.include_price, pp.brand_id from purchase_pricelist pp join res_partner rp on rp.id = pp.vendor_id where pp.write_date >= (now() - '10 days'::interval)</sql> @@ -863,6 +863,11 @@ where pp.write_date >= (now() - '10 days'::interval)</sql> <rename>include_price</rename> <update>Y</update> </value> + <value> + <name>brand_id</name> + <rename>brand_id</rename> + <update>Y</update> + </value> </lookup> <attributes/> <cluster_schema/> |