升级会导致库存估价的 WIP 报表 (5802) Microsoft Dynamics 导航 2009 年显示不正确的金额

模板︰ CPR-Navision 代码 Fiacx 模板

错误 #: 208379 (内容维护)

症状

在从 Microsoft Dynamics 导航 3.7 升级到 Microsoft Dynamics 导航 2009年之后,库存估价的 WIP报表 (5802) 可以展示正确的金额。升级工具包已填充数值输入项中的字段预期成本已过帐到总帐时成本尚未过帐到 G/l。 按照代码更改部分,若要解决此问题的步骤。下列产品中发生此问题︰

  • Microsoft Dynamics NAV 2009 R2

  • Microsoft Dynamics NAV 2009 Service Pack 1 (SP1)

解决方案

修补程序信息

受支持的修补程序现已从 Microsoft 推出。然而,它仅用于纠正本文中描述的问题。它仅应用于正经历此特定问题的系统。此修补程序可能会接受进一步的测试。因此,如果这个问题没有对您造成严重的影响,我们建议您等待下一个 Microsoft Dynamics 导航 2009 服务包 或包含此修复程序的下一步的 Microsoft Dynamics 导航版本。

注意: 在特殊情况下,可免收的支持电话,可免收如果技术支持专业人员对 Microsoft Dynamics 和相关的产品的费用确定某个特定的更新能够解决您的问题。照常收取支持费用将应用于其他支持问题和对于特定更新无法解决的问题。

如果此修补程序未放在网上供公共下载 (指本文中未提供此修复程序的公共 URL),分发需要技术组长、 问题上报小组成员或经理的批准并且以下信息适用︰

  • 要收到此修复程序,客户必须遇到"症状"一节中提到的错误。

  • 您必须跟踪客户向其发送此和可用 (如果发布服务包) 时提供他们的下一个 service pack。

此修补程序不计划将包含在 Microsoft Dynamics 导航服务包。

安装信息

Microsoft 提供的编程示例仅用于说明,没有任何明示或暗示的担保。这包括但不限于适销性或特定用途适用性的暗示担保。本文假定您熟悉所演示的编程语言和用于创建和调试过程的工具。Microsoft 的支持工程师可以帮助解释某个特定过程的功能。但是,他们不会修改这些示例以提供额外的功能或构建过程以满足您的特定要求。

注意:安装此修复程序之前,请验证所有 Microsoft Dynamics 导航客户端用户都注销系统。这包括 Microsoft Dynamics 导航应用程序服务器 (NAS) 服务。要实现此修补程序时,在登录的唯一客户端用户。

若要实现此修补程序,必须使用开发人员许可证。

我们建议在 Windows 登录窗口或数据库登录窗口中的用户帐户将分配该"超级"角色 id。如果不能将用户帐户分配成"超级"角色 ID,则必须验证用户帐户具有下列权限:

  • 您将更改该对象的修改权限。

  • 为系统对象 ID™ 5210对象和系统对象 ID 9015执行权限

    对象。

注意:您不需要具有对数据存储区的权限,除非您需要执行数据修复。

代码更改

注意:始终测试代码修复在受控环境中应用之前与您的生产计算机的修补程序。

要解决此问题,请更改升级导航 2009年步骤 2 codeunit (104048) 中的UpdateValueEntry函数中的代码,如下所示︰

现有代码 1

...ExpValueEntry."Sales Amount (Expected)" += "Sales Amount (Expected)";
ExpValueEntry."Cost Amount (Expected) (ACY)" += "Cost Amount (Expected) (ACY)";

// Delete the following lines.
CASE TRUE OF
(("Cost Posted to G/L" = 0) AND ("Cost Posted to G/L (ACY)" = 0) AND
ItemLedgEntry."Completely Invoiced"):
BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" -= "Expected Cost Posted to G/L";
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -= "Exp. Cost Posted to G/L (ACY)";
END;
(("Cost Posted to G/L" = "Cost Amount (Expected)") AND
("Cost Posted to G/L (ACY)" = "Cost Amount (Expected) (ACY)")):
BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";
END;
("Cost Posted to G/L" <> 0) OR ("Cost Posted to G/L (ACY)" <> 0):
BEGIN
"Expected Cost Posted to G/L" :=
ROUND("Cost Amount (Expected)" * QtyFactor,GLSetup."Amount Rounding Precision");
"Exp. Cost Posted to G/L (ACY)" :=
ROUND("Cost Amount (Expected) (ACY)" * QtyFactor,Currency."Amount Rounding Precision");

ExpValueEntry."Expected Cost Posted to G/L" -=
ROUND("Expected Cost Posted to G/L",GLSetup."Amount Rounding Precision");
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -=
ROUND("Exp. Cost Posted to G/L (ACY)",Currency."Amount Rounding Precision");
END;
// End of the deleted lines.

END;
"Cost Posted to G/L" := 0;
"Cost Posted to G/L (ACY)" := 0;
...

替换代码 1

...ExpValueEntry."Sales Amount (Expected)" += "Sales Amount (Expected)";
ExpValueEntry."Cost Amount (Expected) (ACY)" += "Cost Amount (Expected) (ACY)";

// Add the following lines.
IF InvtSetup."Expected Cost Posting to G/L" THEN
CASE TRUE OF
(("Cost Posted to G/L" = 0) AND ("Cost Posted to G/L (ACY)" = 0) AND
ItemLedgEntry."Completely Invoiced"):
BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" -= "Expected Cost Posted to G/L";
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -= "Exp. Cost Posted to G/L (ACY)";
END;
(("Cost Posted to G/L" = "Cost Amount (Expected)") AND
("Cost Posted to G/L (ACY)" = "Cost Amount (Expected) (ACY)")):
BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";
END;
("Cost Posted to G/L" <> 0) OR ("Cost Posted to G/L (ACY)" <> 0):
BEGIN
"Expected Cost Posted to G/L" :=
ROUND("Cost Amount (Expected)" * QtyFactor,GLSetup."Amount Rounding Precision");
"Exp. Cost Posted to G/L (ACY)" :=
ROUND("Cost Amount (Expected) (ACY)" * QtyFactor,Currency."Amount Rounding Precision");

ExpValueEntry."Expected Cost Posted to G/L" -=
ROUND("Expected Cost Posted to G/L",GLSetup."Amount Rounding Precision");
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -=
ROUND("Exp. Cost Posted to G/L (ACY)",Currency."Amount Rounding Precision");
END;
// End of the added lines.

END;
"Cost Posted to G/L" := 0;
"Cost Posted to G/L (ACY)" := 0;
...

现有代码 2

...TempDocValueEntry."Cost Amount (Expected) (ACY)" += "Cost Amount (Expected) (ACY)";
TempDocValueEntry.MODIFY;

// Delete the following lines.
IF (ABS(ExpValueEntry."Expected Cost Posted to G/L") > ABS("Cost Amount (Expected)")) OR
(ABS(ExpValueEntry."Exp. Cost Posted to G/L (ACY)") > ABS("Cost Amount (Expected) (ACY)"))
THEN BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" -= "Cost Amount (Expected)";
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -= "Cost Amount (Expected) (ACY)";
END ELSE BEGIN
"Expected Cost Posted to G/L" := ExpValueEntry."Expected Cost Posted to G/L";
"Exp. Cost Posted to G/L (ACY)" := ExpValueEntry."Exp. Cost Posted to G/L (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" := 0;
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" := 0;
END;
// End of the deleted lines.

END;
END;
UpdateCostToPostToGL(ValueEntry);

...

替换代码 2



...
 TempDocValueEntry."Cost Amount (Expected) (ACY)" += "Cost Amount (Expected) (ACY)";                      TempDocValueEntry.MODIFY;

// Add the following lines.
IF InvtSetup."Expected Cost Posting to G/L" THEN
IF (ABS(ExpValueEntry."Expected Cost Posted to G/L") > ABS("Cost Amount (Expected)")) OR
(ABS(ExpValueEntry."Exp. Cost Posted to G/L (ACY)") > ABS("Cost Amount (Expected) (ACY)"))
THEN BEGIN
"Expected Cost Posted to G/L" := "Cost Amount (Expected)";
"Exp. Cost Posted to G/L (ACY)" := "Cost Amount (Expected) (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" -= "Cost Amount (Expected)";
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" -= "Cost Amount (Expected) (ACY)";
END ELSE BEGIN
"Expected Cost Posted to G/L" := ExpValueEntry."Expected Cost Posted to G/L";
"Exp. Cost Posted to G/L (ACY)" := ExpValueEntry."Exp. Cost Posted to G/L (ACY)";

ExpValueEntry."Expected Cost Posted to G/L" := 0;
ExpValueEntry."Exp. Cost Posted to G/L (ACY)" := 0;
END;
// End of the added lines.

END;
END;
UpdateCostToPostToGL(ValueEntry);
...


系统必备组件

您必须具有要应用此修补程序的安装以下产品之一︰

  • Microsoft Dynamics NAV 2009 R2

  • Microsoft Dynamics 导航 2009 SP1

删除信息

您不能删除此修补程序。

状态

Microsoft 已经确认这是“适用于”一节中列出的 Microsoft 产品中的问题。

参考资料

VSFT DynamicsNAVSE: 359675

注意:这是直接从创建 Microsoft 支持部门内的"快速发布"的文章。此处包含的信息是作为为了响应新出现的问题而提供的。由于以使其可用的速度,而材料可能包含印刷错误,恕不另行通知,随时可能进行修订。其他考虑因素,请参阅使用条款

作者︰ hholmin
Writer: v-luzo
技术审阅︰ hholmin
Editor:

需要更多帮助?

扩展你的技能
了解培训
抢先获得新功能
加入 Microsoft 内部人员

此信息是否有帮助?

谢谢您的反馈意见!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×