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