Please enable JavaScript.

Coggle requires JavaScript to display documents.

換季大魔王_尋找Info Record≠PO Price, ps.要使用內網雲端檔案總管2003開啟, 執行, 另存新檔, ↓, ↓, 用意?,…

- - - - Mark: DOC Price ≠ Info Price → Diff≠0
    - - 排除(灰)
        
        Call off PO: DOC#5開頭
        
        Vendor Code:11885
        
        Diff%=0
      - Mapping CFM Date&Qty(AQ-AN欄)
        
        Step
        
        AQ欄
        
        設定KEY值：PO&Item
        
        AR-AW欄
        
        Mapping CFM Date &Qty 1, 2, 3
        
        AX欄
        
        Match with CFM date 1 QTY
        
        比對是否與Qty1(AS欄)與Open Qty(Y欄)是否一致
        
        Formula=IF()
        
        拆成兩個檔案
        
        用CFM Datet拆分
        
        多筆Partial: zd468_Multi CFM
        
        One CFM Date: zd468_One CFM Date
        
        AN欄
        
        SQ01
        
        PN Owner: Buyer Code
        
        T-code
        
        SQ01_MM Module_03 OPEN PO
        
        輸入PN&Plant
        
        Result: OPO工作表
        
        Purpose
        
        Buyer可透過Shipment Date確認貨物狀態，決定價格上傳與否
    - - Upload
        
        Step
        
        篩除
        
        Buyer反灰的部分→不用上傳
        
        刪除
        
        AQ-AN欄位
        
        填入
        
        AO欄: 幣別
        
        複製J欄INFcu
        
        AP欄: Unit Price
        
        複製K欄INF price
        
        Check :star:
        
        Title正確
        
        Upload
        
        T-code: ZSZD397→Upload PO Price
        
        Result
        
        Delete
        
        T-Code: ZD822
        
        1 more item...
        
        Error
        
        +MP欄
        
        排除Change OK
        
        ERROR貼給採購
        
        Upload Round 2
        
        ERROR to Buyer
        
        發信
        
        Q槽