Please enable JavaScript.
Coggle requires JavaScript to display documents.
換季大魔王_尋找Info Record≠PO Price, ps.要使用內網雲端檔案總管2003開啟, 執行, 另存新檔, ↓, ↓, 用意?,…
換季大魔王_尋找Info Record≠PO Price
T-code:ZD468
撈取Info Record & PO Price資料
Plant:2310&2350&2380
Code Page:4110
Purchasing org:2000
Vendor Code:Q槽Sheet1全部
Company Code:2300
New Worksheet
ZD468_Raw
Mark
: DOC Price ≠ Info Price → Diff≠0
zd468_TW Buyer
排除(灰)
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確認貨物狀態,決定價格上傳與否
To Buyer to Check
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槽
ps.要使用內網雲端檔案總管2003開啟
執行
另存新檔
↓
↓
用意?
不上傳原因EX: 貨物已在途中,需用舊價格