Datanory Production » Datanory - GOLDCREST

Debug script:
sp_sync_download_txn_stock_transfer

Testing script:
SELECT
--h.txn_no [TXN_KEY]
h.warehouse_txn_hdr_id [TXN_KEY]
,h.txn_no [TXN_NO]
,h.doc_no [REF_NO]
,m.login_id [SLSMAN_CD] -- No integrate from SQL accounting?
,w.warehouse_code [WHS_CD] --??
,case when h.txn_type='Stock In' then m.login_id else (case when m.org_id = 'GOLDCREST' and (m.login_id like 'W%' or m.login_id = 'MCJ') then 'KL' else 'HQ' end) end as FROM_LOCATION
,case when h.txn_type='Stock In' then (case when m.org_id = 'GOLDCREST' and (m.login_id like 'W%' or m.login_id = 'MCJ') then 'KL' else 'HQ' end) else m.login_id end as TO_LOCATION

-- MCJ & start with W -

,CONVERT(varchar(10), h.txn_date,120) [TXN_DT]
            ,h.[txn_type] [TXN_TYPE]
            ,h.remarks [REMARK]
            FROM warehouse_stock_transaction_header h
            INNER JOIN member m ON h.salesman_id=m.member_id
            inner join warehouse w on h.warehouse_id=w.warehouse_id

WHERE isnull(h.salesman_id,'') <> ''
            AND h.org_id = 'goldcrest' AND (h.sync_date IS NULL OR 2023-11-17 <> '')
            --and h.txn_no='GOLDCREST-WST-000021'
            ORDER BY FROM_LOCATION --h.txn_no
            --OFFSET @batch_no * @batch_size ROWS
            --FETCH NEXT @batch_size ROWS ONLY;