Oracle EBS:PO入库(收货)价格不随Blanket更改

这个可真是差点出了大麻烦啊,呵呵。
事故描述:
1月下交期,2月调价,1月所下的PO没有交完货的情况下,在原PO上作更改PO交期。结果没想到的是:系统在入库时点会PO的价格重新获取差刷新一次,导致系统上的PO单位价与传真给供应商的PO上的单价有差异,财务对帐的异也有些产生。

解决方案:

问题 : POXPOEPO: Able to Update Unit Price After PO Has Been Received and Invoiced
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=397599.1

原因:Profile "PO: Allow Retroactive Pricing of POs" was not set to 'Never'.


设定:






Bug 5560982: ABLE TO CHANGE UNIT PRICE AFTER RECEVING PO  

--------------------------------------------------------------------------------


Bug 属性

--------------------------------------------------------------------------------
类型 B - Defect 已在产品版本中修复 -
严重性 2 - Severe Loss of Service 产品版本 11.5.10.2
状态 92 - Closed, Not a Bug 平台 212 - IBM AIX on POWER Systems (64-bit)
创建时间 22-Sep-2006 平台版本 5L
更新时间 31-Oct-2006 基本 Bug -
数据库版本 9.2.0.7.0  
影响平台  Generic  
产品来源 oracle

相反:要修改价格的话

此方案转自:来源:http://dgstonehuang.blog.163.com/blog/static/4693088820091024103334393/

设置如下:

1.在收货参数里设置“Retroactive Price Adjustment Account”,赋予调整PO价格的会计分录;

2.修改PO里Profile参数:PO: Allow Retroactive Pricing of POS,有3个选项,Never-->不允许修改、OPEN RELEASES-->还没收货(部分收+全收)仅核准状态、ALL RELEASES-->表示收货后可以修改价格。


要值得注意的是:

1。这个成PAC成本有所影响,在标准成本制下可以使用。

2.要注意产生的会计科目 Retroactive Price Adjustment Account



https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=339536.1
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=273918.1

---补丁

PO Price Changes When Need-By Date Is Changed [ID 379511.1]  

--------------------------------------------------------------------------------

  修改时间 10-JUN-2009     类型 PROBLEM     状态 PUBLISHED  

In this Document
  Symptoms
  Cause
  Solution
  References



--------------------------------------------------------------------------------



Applies to:
oracle Purchasing - Version: 11.5.10
This problem can occur on any platform.
POXPOEPO.fmb
Symptoms
When the user changes the need-by date in a purchase order that has been received or billed and is associated to a global blanket purchase agreement or a quotation, the price changes.

Steps to Reproduce the Issue:
------------------------------
1. Create a quotation for an item.
2. Create a standard PO referencing the quotation. Approve and  receive partially.
3. Change the price on the quotation.
4. Open the PO and change the need by date on the PO, the price changes  to the new quotation price.

Note: Only when accrual option is "at receipt" the price  should not  change after the line has been partially/fully received
This issue also happens when updating the need-by-date in the release


Cause
The prevent_price_update flag was not checked before calling the
functions to reprice the po line/shipment.

This is explained in the following bug:
Bug 5040211/4355088  PRICE CHANGE WHEN UPDATING NEED-BY:

Solution
To implement the solution,  execute the following steps:

1. Download and review the readme and pre-requisites for Patch 5040211.  (The fix is also included in Procurement Rollup Patch 3 and higher - see NOTE:222339.1 "Procurement Family Patch Release History" for information on the latest Procurement rollup patches.)

2. Ensure that you have taken a backup of your system before applying the recommended patch.

3. Apply the patch in a test environment.

4. Confirm the following file versions:
forms/US/POXPOEPO.fmb 115.445.11510.23
resource/POXPOPOS.pld 115.232.11510.8
resource/POXPOPOL.pld 115.228.11510.17
resource/POXPIPOS.pld 115.67.11510.3
patch/115/sql/POXPOL4B.pls-115.24.11510.2

5. Retest the issue.

6. If the issue is resolved,  migrate the solution as appropriate to other environments.




References
BUG:5040211 - Price Change When Updating Need-By-Date

[本日志由 admin 于 2010-10-13 05:18 PM 编辑]
上一篇: 《少有人走的路》读后感
下一篇: Oracle PL/SQL:IF语句的使用
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags: 入库(收货)价格
相关日志:
评论: 0 | 引用: 0 | 查看次数: 14108
发表评论
昵 称:
密 码: 游客发言不需要密码.
邮 箱: 邮件地址支持Gravatar头像,邮箱地址不会公开.
网 址: 输入网址便于回访.
内 容:
验证码:
选 项:
虽然发表评论不用注册,但是为了保护您的发言权,建议您注册帐号.
字数限制 30 字 | UBB代码 关闭 | [img]标签 关闭