• Quantity – Based on the Expenditure Type definition, quantity is verified by checking the PA_QUANTITY column in the AP_INVOICE_DISTRIBUTIONS_ALL. If the COST_RATE_FLAG column in PA_EXPENDITURE_TYPES table is set to Y, then the quantity field in the Payables Invoice Workbench needs to be filled in.

Once all the requisite information has been entered and the invoice distribution saved, the system checks whether the values given in the Project, Task, Expenditure Type and Expenditure Organization fields are active as of the Expenditure Item Date.

成都創(chuàng)新互聯(lián)公司主營白云網(wǎng)站建設(shè)的網(wǎng)絡(luò)公司,主營網(wǎng)站建設(shè)方案,成都app軟件開發(fā)公司,白云h5微信小程序搭建,白云網(wǎng)站營銷推廣歡迎白云等地區(qū)企業(yè)咨詢

The following columns in the AP_INVOICE_DISTRIBUTIONS_ALL table are relevant for project-related supplier invoices:

1. PROJECT_ACCOUNTING_CONTEXT – This column is set to Yes if the Project ID column is filled.
2. ASSET_ADDITION_FLAG – If the project-related invoice distribution is charged to a Capital Project, then the ASSET_ADDITION_FLAG is set to P when the PA_ADDITION_FLAG is set to Y, Z or T.

To avoid the same invoice distribution being interfaced to both Projects and Fixed Assets, you must interface any project-related invoice distribution to Oracle Projects before you interface it to Oracle Assets.

1. PA_ADDITION_FLAG- The PA_ADDITION_FLAG tracks the status of project-related supplier invoice distribution lines and expense report distribution lines. For supplier invoice distributions entered via Oracle Payables, the PA_ADDITION_FLAG is set to N if the distribution is project-related, otherwise it is set to E and it is updated by Oracle Projects when the distribution is processed by the Oracle Projects Interface Supplier Invoice process. Oracle Projects sets the PA_ADDITION_FLAG to Y or Z after the item is successfully processed, or may be set to a rejection code if the line is rejected during transfer to Projects. For supplier invoice adjustment lines interfaced from Projects to Payables (which must net to zero with another line), the value for the PA_ADDITION_FLAG is set to T. Listed below are the Quick Codes available for the PA_ADDITION_FLAG:

PA_ADDITION_FLAG	DESCRIPTION
B	No open PA period
C	Task does not allow charges
D	Outside project dates
E	Non-project related invoice distributions
I	Outside task dates
J	Project level transaction controls violated
K	Task level transaction controls violated
M	Invalid project/task combination
N	New line not yet processed by Oracle Projects
P	Project is closed
Q	Transaction control extension violated
S	Temporary status used during processing
T	Adjustment line transferred from Oracle Projects
V	Invalid data (catch-all error)
X	Burdening error
Y	Transferred to Oracle Projects
Z	Net zero adjustment line. Never transferred to PA

2. If an item is rejected, you must correct the rejection reason and re-run the interface process.
3. Once the Invoice is interfaced to Projects, the following tables are populated with appropriate values:

• PA_EXPENDITURE_GROUPS_ALL
• PA_EXPEDITURES_ALL
• PA_EXPENDITURE_ITEMS_ALL
• PA_COST_DISTRIBUTION_LINES_ALL

網(wǎng)站欄目：OracleProjects-APIntegrationPart2
轉(zhuǎn)載源于：http://www.jinyejixie.com/article8/jogeop.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供用戶體驗、面包屑導(dǎo)航、網(wǎng)站改版、外貿(mào)網(wǎng)站建設(shè)、、建站公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)