楼主: tianshaguxing20

GR amount的奇怪问题

[复制链接]
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
11#
 楼主| 发表于 2011-7-15 09:38 | 只看该作者
再附上FI的凭证,和正常的对比了一下,多了最后一个Z30010,但是把这个51.53加上去算出来也不对,不知道这个是做什么的。

FI.jpg (90.13 KB, 下载次数: 1)

FI.jpg

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
12#
 楼主| 发表于 2011-7-15 09:47 | 只看该作者
好像是原物料差异科目,但是这个差异是怎么来的呢

使用道具 举报

回复
论坛徽章:
73
技术图书徽章
日期:2014-05-13 10:13:152012新春纪念徽章
日期:2012-02-13 15:13:362012新春纪念徽章
日期:2012-01-04 11:49:54ITPUB十周年纪念徽章
日期:2011-11-01 16:20:28ERP板块每日发贴之星
日期:2011-06-15 01:01:01茶鸡蛋
日期:2011-06-09 15:59:122011新春纪念徽章
日期:2011-05-10 14:10:24现任管理团队成员
日期:2011-05-07 01:45:082011新春纪念徽章
日期:2011-04-28 16:02:102010广州亚运会纪念徽章:排球
日期:2011-03-10 17:59:11
13#
发表于 2011-7-15 10:22 | 只看该作者
原帖由 Phoenix_Reborn 于 2011-7-15 09:21 发表

Cann't access the SAP note.




Note 49995 - MMIM: Valuation of return deliveries and GR revrsls
Symptom

1. The return delivery or reversal of a goods receipt for a purchase order, scheduling agreement, or production order is valuated differently than the original goods receipt.
2. In the case of a return delivery or reversal of a goods receipt for a subcontract order, the component is reversed on the basis of a different value than in the case of the original goods receipt.
3. In the case of a return delivery or reversal of a goods receipt for a purchase order or scheduling agreement, delivery costs are valuated differently than in the case of the original goods receipt.
4. The reversal of a goods receipt returns (movement type 162) for a purchase order or scheduling agreement is valuated differently than the original returns (movement type 161).
5. During the return delivery or reversal of a goods receipt for a purchase order, scheduling agreement the negativ delivery costs (as rebate accruals) are valuated differently than during the original goods receipt.
Other terms

Return delivery, GR/IR clearing account, valuation, MB01, MB31, MBRL, MBST, BWA102, BWA106, BWA122, BWA161, BWA162, BWA543, BWA544, BWA545, BWA546, material document, exchange rate, reversal, conversion, provision of material, freight, subcontracting, subcontract order, subcontractor scheduling agreement, volume-based rebate, returns item, WRX, MMVAL

Reason and Prerequisites

This situation can occur in the following cases:

Note: In the following examples, the amount which the system posts to the GR/IR clearing account is given in each case. The examples apply to both, to assigned purchase order items and to purchase order items that are not assigned or production order items or scheduling agreement items.


1. Case A:
              There are two goods receipts with different values. This situation occurs when the order price between the two goods receipts was changed. The system valuates the return delivery or the reversal with the average value of goods received.


              Example: 100 pieces of a material are ordered at 10 DEM per piece.

1. Goods receipt:  10 pieces at 100 DEM
Price change in the purchase order: Order price now 12 DEM per piece.
2. Goods receipt:  10 pieces at 120 DEM, so that a total of 20 pieces was posted with DEM 220.
Return delivery (or reversal) of 10 pieces is now valuated with the proportional value of goods received of 10 pieces * 220 / 20 pieces = 110 DEM.

2. Case B:
              There are two goods receipts with different values in local currency for a purchase order in foreign currency. This situation occurs with an unchanged order price if different exchange rates between external and local currency were used for the two goods receipts. The system valuates the return delivery or the reversal with the average value of goods received in local currency.


              Example: 100 pieces of a material are ordered at 7 USD per piece.


1. Goods receipt:  10 pieces at 70 USD or 100 DEM, with an exchange rate of 70 USD = 100 DEM.
2. Goods receipt:  10 pieces at 70 USD or 120 DEM, with an exchange rate of 70 USD = 120 DEM now. Now, 20 pieces with DEM 220 were posted as a receipt in total.
Return delivery (or reversal) of 10 pieces is now valuated with the proportional value of goods received of 10 pieces * 220 / 20 pieces = 110 DEM.

3. Case C:
              An invoice with a different amount is posted after a goods receipt. A later return delivery (or reversal) is carried out with the invoiced amount. If the invoice is net-posted, this is the invoiced amount minus cash discount.


              Example: 100 pieces of a material are ordered at 10 DEM per piece.

Goods receipt:                    10 pieces at 100 DEM
Invoice:                          10 pieces at 110 DEM.
Return delivery (or GR reversal): 10 pieces at 110 DEM.

4. Case D:
              An order price unit (OPUn) (different to the order unit (OUn)) was defined in the purchase order. The relationship between quantity in OUn and quantity in OPUn is different in the (sum of all) goods receipts to that in the (sum of all) invoices.

              Example:         100 pieces of a material are ordered at 1 DEM per kg.

                  1 piece (OUn) correspond to 10 kg (OPUn)

Invoice:         100 pieces with 1000 kg at 1000 DEM
Goods receipt:    90 pieces with 950 kg at 950 DEM
Goods receipt:    10 pieces with 100 kg at 100 DEM
Return delivery:  10 pieces with 105 kg at 105 DEM
              The difference of 5 DEM in the valuation of the return delivery (or reversal) is a result of the system determining the returned quantity in OPUn - as long as the user has not entered anything different - with the portion of the returned quantity in OUn (10 pieces from 100 pieces, since in OPUn 105 kg from 1050 kg), and valuating with the proportional value delivered to date.


5. Case E:
              There are two goods receipts for one subcontract order with a component being posted with different values. This situation occurs if the material price of a component has changed between two goods receipts. The system evaluates the return delivery or the reversal with the average value of the adjustment postings.


              Example: material price is 10 DEM per piece.

1. Goods receipt: Adjustment posting of 10 pieces of 100 DEM
The material price changes to 12 DEM per piece.
2. Goods receipt: Adjustment posting of 10 pieces of 120 DEM so that a total of 20 pieces with DEM 220 have been posted.
The cancellation of the adjustment posting of 10 pieces is now valuated with the proportional value of 10 pieces * 220 DEM / 20 pieces = 110 DEM.



This valuation logic in its general sense is used for delivery costs too.
This valuation logic in its general sense is used for returns items too.
This valuation logic in its general sense is also used for negative delivery costs.

For users of the subsequent settlement function:
When you change fields for subsequent settlement or change the document conditions (pricing), please note the following:
A new pricing or other changes to the document conditions (also implicit changes by changing price-relevant fields, see Note 486757) are allowed only, if goods receipt quantity and invoice quantity are zero, i.e. if there are either no follow-up documents or if the follow-up documents were cancelled completely. This is called an open purchasing document item.
Otherwise - apart from the posting of undesired accrued incomes - the sales date become inconsistent too, i.e. the reconstruction and the detailed statement provide different data from the ones determined in previous updates (see statistics statement).
The background is that due to the data model all essential data are stored in the purchasing document. A change may cause data to be lost for all existing follow-up documents so that the sales data can no longer be determined correctly. This means that all updates would be carried out with the sales data existing after the change instead of the values that were originally valid.
Example: GR1 was updated with 100 p - 1 000 USD. then, the document conditions are corrected, GR 2 - 100 p - 1 200 USD is posted. Both the detailed statement and the reconstruction/subsequent update determine a total of 200 p - 2 400 USD. The information regarding GR1 are lost. As a matter of course, the statistics statement function will display 200 p - 2 200 USD. Only after the reconstruction, the result would be 200 p - 2 400 USD. This does not correspond to the posted values, however.

[ 本帖最后由 LostHorizon 于 2011-7-15 10:32 编辑 ]

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
14#
 楼主| 发表于 2011-7-15 10:44 | 只看该作者
Tkz LostHorizon!
但是没有查到物料价格有更改的记录。
有没有大牛帮忙看下啊. 需要什么记录我再传。

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
15#
 楼主| 发表于 2011-7-15 14:50 | 只看该作者
再顶一下

使用道具 举报

回复
论坛徽章:
73
技术图书徽章
日期:2014-05-13 10:13:152012新春纪念徽章
日期:2012-02-13 15:13:362012新春纪念徽章
日期:2012-01-04 11:49:54ITPUB十周年纪念徽章
日期:2011-11-01 16:20:28ERP板块每日发贴之星
日期:2011-06-15 01:01:01茶鸡蛋
日期:2011-06-09 15:59:122011新春纪念徽章
日期:2011-05-10 14:10:24现任管理团队成员
日期:2011-05-07 01:45:082011新春纪念徽章
日期:2011-04-28 16:02:102010广州亚运会纪念徽章:排球
日期:2011-03-10 17:59:11
16#
发表于 2011-7-15 15:05 | 只看该作者
以上notes已经说明了有5种状况会导致return price差别,你自己要根据你具体case具体自己分析呀

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
17#
 楼主| 发表于 2011-7-15 16:01 | 只看该作者
1.PO和inforecord里都没有查到物料价格的更改记录。
2.用的都是RMB结算,汇率没有更改。
3.离6/9最近的一次IR也是54.70/8=6.8375
4.单位都是PC,没有单位换算。
5.目前怀疑和这个有关,因为这也是一个subcontract PO,和1的区别是不是指
BOM下的原物料在两次GR之前价格有改变啊?原物料的价格是不是就是指accounting view下的价格?是怎么影响其上阶物料的?附上原物料的收发记录.

component.jpg (147.41 KB, 下载次数: 1)

component.jpg

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
18#
 楼主| 发表于 2011-7-15 16:39 | 只看该作者
现在的问题是怎么解决这个异常了,我相反转掉这笔122重做看看,但是库存不够,又不能反转。
大家有没有什么好的方法?

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
19#
 楼主| 发表于 2011-7-15 16:59 | 只看该作者
错了,不是库存不够,是PO已经没有open数量了

使用道具 举报

回复
论坛徽章:
3
ITPUB十周年纪念徽章
日期:2011-11-01 16:25:512012新春纪念徽章
日期:2012-01-04 11:56:44优秀写手
日期:2013-12-18 09:29:09
20#
 楼主| 发表于 2011-7-16 15:03 | 只看该作者
再战略性顶一下

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表