【NetSuite】总账成本四舍五入后不一致
问题:核算成本时,经过人工计算为56.565.但系统拉取明细的时候却有的显示56.57,有的显示56.56。
原因(直译):
- 当影响交易记录的库存中反映的成本超过2位小数时,总账影响将四舍五入到2位小数。
- 如果成本被四舍五入,系统将检查成本的第三位数字是否可以进行更改,而不管小数精度有多少。
- 如果四舍五入时的第三个数字等于5,则总账影响将在影响交易的第一个存货中四舍五入。然后它将在下一个事务中取整,这是为了抵消上一个事务中出现的超额。如果成本为0.005,则下一笔交易不会显示成本的总账影响。
SuiteAnswers:
Inconsistent Rounding Off Of Cost In GL Impacts
Applies To Product: NetSuite 2020.1
Scenario:Different scenarios on how system considers rounding-off the Cost
Scenario 1: Cost = 0.0247
Invoice 1 GL Impact: 0.03
Invoice 2 GL Impact: 0.02
Scenario 2: Cost = 0.0243
Invoice 1 GL Impact: 0.02
Invoice 2 GL Impact: 0.02
Scenario 3: Cost = 0.0253
Invoice 1 GL Impact: 0.03
Invoice 2 GL Impact: 0.02
Scenario 4: Cost = 0.0245
Invoice 1 GL Impact: 0.03
Invoice 2 GL Impact: 0.02
Scenario 5: Cost = 0.02472
Invoice 1 GL Impact: 0.03
Invoice 2 GL Impact: 0.02
Scenario 6: Cost = 0.005
Invoice 1 GL Impact: 0.01
Invoice 2 GL Impact: No GL Impact
Solution:
- When the Cost reflected in an Inventory Affecting Transactions have more than 2 decimal places, the GL Impact will round it up to 2 decimal places.
- The system checks the third digit of the Cost if it can make possible changes if the Cost was rounded-off, regardless of how many decimal precision there are.
- If the third digit when rounded up was equal to 5, the GL Impact will round up in the first Inventory-affecting transaction. Then it will round down for the next, and this is to neutralize the overage presented in the previous transaction.
- In case the cost is 0.005, the next transaction will not show GL Impact for the cost.
THE END
0
二维码
打赏
海报
【NetSuite】总账成本四舍五入后不一致
问题:核算成本时,经过人工计算为56.565.但系统拉取明细的时候却有的显示56.57,有的显示56.56。
原因(直译):
当影响交易记录的库存中反映的成本超……