Subversion Repositories SmartDukaan
(root)/trunk/profitmandi-dao/src/main/resources/sql/fix_invoice_receiveDate_from_purchase.sql – Rev 36314
Directory listing | Details | Blame | View Log | RSS feed
Last modification
- Rev 36314 – 16 d 4 h
- Author: amit
- Log message:
- Fix Dummy warehouse creation defaults and backfill invoice receiveDate
- ensureDummyForBillingRegion: set isAvailabilityMonitored=0, transferDelayInHours=0,
source=0 explicitly; copy logisticsLocation and pincode from billing warehouse
(matches createVendorWarehouse pattern)
- Add SQL to backfill warehouse.invoice.receiveDate from warehouse.purchase.receivedOn
for received invoices where receiveDate is NULL
