【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
分享
二维码
打赏
海报
【NetSuite】总账成本四舍五入后不一致
问题:核算成本时,经过人工计算为56.565.但系统拉取明细的时候却有的显示56.57,有的显示56.56。 原因(直译): 当影响交易记录的库存中反映的成本超……
<<上一篇
下一篇>>