Capex Unpaid
2023-02-08 08:20:29 12 举报AI智能生成
Capex Unpaid
作者其他创作
大纲/内容
Part 1: GRIR
(exlude DP part)
(exlude DP part)
GRIR List
DP List
Part 2: Uncleared AP
Step 1: Extract capex related
open PO
open PO
Get capex related info.
(PO&Item&Vendor&Asset#)
(PO&Item&Vendor&Asset#)
Extract PO from text
of open AP
of open AP
Mapping PO base on
above two steps to get
capex related AP doc. infor.
above two steps to get
capex related AP doc. infor.
Step 2 : Export capex invoice report
to build a data source
to build a data source
Step 3: Calculate capex unpaid
Calculate the proportion(%) for
each PO&ITEM in one AP doc.
each PO&ITEM in one AP doc.
Mapping tax % for
each PO&Item
each PO&Item
Batch calculate capex uncleared amount *%
to get capex unpaid for each PO&Item
to get capex unpaid for each PO&Item
Mapping and exclude tax rate
Exlude non-capex
Get all capex related
uncleared PO&Item
uncleared PO&Item
自由主题
收藏
0 条评论
下一页
