每人,每天,做好每件事
Everyone,Everyday,Everything

【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.
赞(1) 打赏
未经允许不得转载:辣椒小鱼のBlog » 【NetSuite】总账成本四舍五入后不一致
分享到: 更多 (0)

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏

×
订阅图标按钮