显示"税金百分比"值不正确和已过帐的销售/采购发票行在印度版本的 Microsoft Dynamics 导航 2009 SP1 中销售/采购订单行

本文适用于 Microsoft Dynamics 导航（中）语言区域设置印度洋。

症状

在印度版本的 Microsoft Dynamics 导航 2009 Service Pack 1 (SP1) 中，显示"税金百分比"值不正确和已过帐销售发票行中某一销售订单行。希望"税金百分比"值与税务详细信息设置中税低于最小值保持一致。为采购单据也发生了同样的问题。

解决方案

修补程序信息

受支持的修补程序现已从 Microsoft 推出。然而，它仅用于纠正本文中描述的问题。它仅应用于正经历此特定问题的系统。此修补程序可能会接受进一步的测试。因此，如果这个问题没有对您造成严重的影响，我们建议您等待下一个 Microsoft Dynamics 导航 2009 服务包或包含此修复程序的下一步的 Microsoft Dynamics 导航版本。注意：在特殊情况下，可免收的支持电话，可免收如果技术支持专业人员对 Microsoft Dynamics 和相关的产品的费用确定某个特定的更新能够解决您的问题。照常收取支持费用将应用于其他支持问题和对于特定更新无法解决的问题。

安装信息

Microsoft 提供的编程示例仅用于说明，没有任何明示或暗示的担保。这包括但不限于适销性或特定用途适用性的暗示担保。本文假定您熟悉所演示的编程语言和用于创建和调试过程的工具。Microsoft 的支持工程师可以帮助解释某个特定过程的功能，但是他们不会修改这些示例以提供额外的功能或构建过程以满足您的特定要求。注意：安装此修复程序之前，请验证所有 Microsoft Navision 客户端用户都注销系统。这包括 Microsoft Navision 应用程序服务 (NAS) 客户端的用户。要实现此修补程序时，在登录的唯一客户端用户。若要实现此修补程序，必须使用开发人员许可证。我们建议在 Windows 登录窗口或数据库登录窗口中的用户帐户将分配该"超级"角色 id。如果不能将用户帐户分配成"超级"角色 ID，则必须验证用户帐户具有下列权限:

您将更改该对象的修改权限。
为系统对象 ID ™ 5210对象和系统对象 ID 9015对象的 Execute 权限。

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

代码更改

注意：始终测试代码修复在受控环境中应用之前与您的生产计算机的修补程序。若要解决此问题，请执行以下步骤：

更改中OnValidate触发器的金额包括纳税销售行表 (37) 中的代码，如下所示︰现有代码

...                                                                      ELSE
                                                                    "Amount To Customer" :=
                                                                      ROUND("Line Amount" - "Inv. Discount Amount" + "Excise Amount" + "Charges To Customer" -
                                                                        "Bal. TDS/TCS Including SHECESS"  + "Service Tax Amount" +"Service Tax eCess Amount" +
                                                                         "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision");
                                                                END;

// Delete the following lines.
                                                                //IF "Tax Base Amount" <> 0 THEN 
                                                                //  "Tax %" := ROUND(100 * ("Amount Including Tax" - "Tax Base Amount") / "Tax Base Amount",Currency."Amount Rounding Precision") 
                                                                //ELSE 
                                                                //  "Tax %" := 0; 
// End of the deleted lines.

                                                                InitOutstandingAmount;
                                                              END;    
...

替换代码

...                                                                     ELSE
                                                                    "Amount To Customer" :=
                                                                      ROUND("Line Amount" - "Inv. Discount Amount" + "Excise Amount" + "Charges To Customer" -
                                                                        "Bal. TDS/TCS Including SHECESS"  + "Service Tax Amount" +"Service Tax eCess Amount" +
                                                                         "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision");
                                                                END;

// Add the following lines.
                                                                 IF "Tax Base Amount" = 0 THEN 
                                                                  "Tax %" := 0; 
// End of the added lines.

                                                                InitOutstandingAmount;
                                                              END;  
...

更改销售线该表 (37) 中的UpdateTaxAmounts函数中的代码，如下所示︰现有代码 1

...     "Bal. TDS/TCS Including SHECESS" + "Service Tax Amount"  + "Service Tax eCess Amount" +
      "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision")
END;

IndianSalesTaxCalculate.SetCurrency("Currency Code" <>'');

// Delete the following lines.
//LineTaxAmount := IndianSalesTaxCalculate.CalculateTax( 
//  "Tax Area Code","Tax Group Code","Tax Liable",SalesHeader."Posting Date", 
//  "Tax Base Amount",Quantity,SalesHeader."Currency Factor","Form Code");
// End of the deleted lines.

TotalTaxAmount := 0;
TotalStdDeductionAmt := 0;
...

替换代码 1

...     "Bal. TDS/TCS Including SHECESS" + "Service Tax Amount"  + "Service Tax eCess Amount" +
      "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision")
END;

IndianSalesTaxCalculate.SetCurrency("Currency Code" <>'');

// Add the following lines.
LineTaxAmount := IndianSalesTaxCalculate.CalculateTax( 
  "Tax Area Code","Tax Group Code","Tax Liable",SalesHeader."Posting Date",
  "Tax Base Amount",Quantity,SalesHeader."Currency Factor","Form Code","Tax %"); 
// End of the added lines.

TotalTaxAmount := 0;
TotalStdDeductionAmt := 0;
...

现有代码 2

...      END ELSE
      IndianSalesTaxCalculate.GetStandardDeductionAmt(Rec,StandardDeductionAmount,LineTaxAmount);
  END
END;
"Amount Including Tax" := ROUND("Tax Base Amount" + LineTaxAmount,Currency."Amount Rounding Precision");

// Delete the following lines.
//IF "Tax Base Amount" <> 0 THEN 
//  "Tax %" := 
//     ROUND(100 * ("Amount Including Tax" - "Tax Base Amount") / "Tax Base Amount",Currency."Amount Rounding Precision") 
//ELSE 
//  "Tax %" := 0; 
// End of the deleted lines.

IF "Standard Deduction %" <>0 THEN
  "Standard Deduction Amount" := ("Tax Base Amount" * "Standard Deduction %" / 100)   
...

替换代码 2

...    END ELSE
      IndianSalesTaxCalculate.GetStandardDeductionAmt(Rec,StandardDeductionAmount,LineTaxAmount);
  END
END;
"Amount Including Tax" := ROUND("Tax Base Amount" + LineTaxAmount,Currency."Amount Rounding Precision");

// Add the following lines.
IF "Tax Base Amount" = 0 THEN 
  "Tax %" := 0; 
// End of the added lines.

IF "Standard Deduction %" <>0 THEN
  "Standard Deduction Amount" := ("Tax Base Amount" * "Standard Deduction %" / 100)   
...

更改OnValidate触发器的金额包括税金中的采购订单行的表 (39) 中的代码，如下所示︰现有代码

...       "Amount To Vendor" := ROUND("Line Amount" -"Inv. Discount Amount" + "Excise Amount" + "Tax Amount" -
      "Bal. TDS Including SHE CESS"  + "Charges To Vendor" + "Service Tax Amount" +
      "Service Tax eCess Amount" + "Service Tax SHE Cess Amount");
END;

// Delete the following lines.
//IF "Tax Base Amount" <> 0 THEN 
//  "Tax %" := ROUND(100 * ("Amount Including Tax" - "Tax Base Amount") / "Tax Base Amount", 
//     Currency."Amount Rounding Precision") 
//ELSE // Delete
//  "Tax %" := 0; 
// End of the deleted lines.

InitOutstandingAmount;  
...

替换代码

...       "Amount To Vendor" := ROUND("Line Amount" -"Inv. Discount Amount" + "Excise Amount" + "Tax Amount" -
      "Bal. TDS Including SHE CESS"  + "Charges To Vendor" + "Service Tax Amount" +
      "Service Tax eCess Amount" + "Service Tax SHE Cess Amount");
END;

// Add the following lines.
IF "Tax Base Amount" = 0 THEN // Add
// End of the added lines.

InitOutstandingAmount;  
...

更改采购订单行的表 (39) 中的UpdateTaxAmounts函数中的代码，如下所示︰现有代码 1

...     "Bal. TDS Including SHECESS" + "Service Tax Amount"  + "Service Tax eCess Amount" +
      "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision")
END;

IndianSalesTaxCalculate.SetCurrency("Currency Code" <>'');

// Delete the following lines.
//LineTaxAmount := ROUND(IndianSalesTaxCalculate.CalculateTax( 
//    "Tax Area Code","Tax Group Code","Tax Liable",PurchHeader."Posting Date", 
//    "Tax Base Amount",Quantity,PurchHeader."Currency Factor","Form Code"),Currency."Amount Rounding Precision"); 
// End of the deleted lines.

AmountonInventory := 0;
InputTaxCreditAmount := 0;
...

替换代码 1

...     "Bal. TDS Including SHECESS" + "Service Tax Amount"  + "Service Tax eCess Amount" +
      "Service Tax SHE Cess Amount",Currency."Amount Rounding Precision")
END;

IndianSalesTaxCalculate.SetCurrency("Currency Code" <>'');

// Add the following lines.
     LineTaxAmount := ROUND(IndianSalesTaxCalculate.CalculateTax( 
    "Tax Area Code","Tax Group Code","Tax Liable",PurchHeader."Posting Date", 
    "Tax Base Amount",Quantity,PurchHeader."Currency Factor","Form Code","Tax %"),Currency."Amount Rounding Precision");
// End of the added lines.

AmountonInventory := 0;
InputTaxCreditAmount := 0;
...

现有代码 2

...  "Tax Amount" := ROUND(TaxAmount,Currency."Amount Rounding Precision");
"Amount Including Tax" := ("Tax Base Amount" + "Tax Amount");

// Delete the following lines.
//IF "Tax Base Amount" <> 0 THEN
//  "Tax %" := ROUND(100 * ("Amount Including Tax" - "Tax Base Amount") / "Tax Base Amount", 
//    Currency."Amount Rounding Precision") 
//ELSE 
//  "Tax %" := 0; 
// End of the deleted lines.

ServiceTaxSetup.RESET;
...

替换代码 2

...   "Tax Amount" := ROUND(TaxAmount,Currency."Amount Rounding Precision");
"Amount Including Tax" := ("Tax Base Amount" + "Tax Amount");

// Add the following lines.
IF "Tax Base Amount" = 0 THEN 
  "Tax %" := 0;
// End of the added lines.

ServiceTaxSetup.RESET;
...

更改UpdateTaxAmount 增值税期初日志表 (16569) 中的函数中的代码，如下所示︰现有代码

...  IF "Transaction Type" = "Transaction Type"::Purchase THEN BEGIN

// Delete the following lines.
  //LineTaxAmount := IndianSalesTaxCalculate.CalculateTax(
  //  "Tax Area Code","Tax Group Code",TRUE,"Posting Date", 
  //  "Tax Base Amount",Quantity,0,''); 
// End of the deleted lines.

  IF LineTaxAmount <> 0 THEN
    IndianSalesTaxCalculate.GetVATOpeningInputTaxCredit(Rec,"Amount Loaded on Item",
      "Input Credit/Output Tax Amount",TRUE,TaxAmount);
  "Tax Amount" := TaxAmount;
  IF GLSetup."VAT Rounding Precision" <> 0 THEN
    "Tax Amount" := ROUND("Tax Amount",GLSetup."VAT Rounding Precision",Direction);

// Delete the following lines.
  //IF "Tax Base Amount" <> 0 THEN 
  //  "Tax %" := 100 * (("Tax Base Amount" + "Tax Amount") - "Tax Base Amount") / "Tax Base Amount" 
  //ELSE 
  //  "Tax %" := 0; 
// End of the deleted lines.

END ELSE IF "Transaction Type" = "Transaction Type"::Sale THEN BEGIN
  IF ("Export or Deemed Export") THEN
    EXIT;

// Delete the following lines.
  //LineTaxAmount := IndianSalesTaxCalculate.CalculateTax( 
  //   "Tax Area Code","Tax Group Code",TRUE,"Posting Date", 
  //   "Tax Base Amount",Quantity,0,''); 
// End of the deleted lines.

  IF LineTaxAmount <> 0 THEN
    IndianSalesTaxCalculate.GetVATOpeningSTD(Rec,StandardDeductionAmount,TaxAmount);
  "Tax Amount" := TaxAmount - StandardDeductionAmount;

// Delete the following lines.
  //IF "Tax Base Amount" <> 0 THEN 
  //  "Tax %" := 100 * (("Tax Base Amount" + "Tax Amount") - "Tax Base Amount") / "Tax Base Amount" 
  //ELSE 
  //  "Tax %" := 0; 
// End of the deleted lines.

  "Input Credit/Output Tax Amount" := "Tax Amount";
  "Amount Loaded on Item" := 0;
END;
...

替换代码

...  IF "Transaction Type" = "Transaction Type"::Purchase THEN BEGIN

// Add the following lines.
  LineTaxAmount := IndianSalesTaxCalculate.CalculateTax( 
    "Tax Area Code","Tax Group Code",TRUE,"Posting Date", 
    "Tax Base Amount",Quantity,0,'',"Tax %"); 
// End of the added lines.

  IF LineTaxAmount <> 0 THEN
    IndianSalesTaxCalculate.GetVATOpeningInputTaxCredit(Rec,"Amount Loaded on Item",
      "Input Credit/Output Tax Amount",TRUE,TaxAmount);
  "Tax Amount" := TaxAmount;
  IF GLSetup."VAT Rounding Precision" <> 0 THEN
    "Tax Amount" := ROUND("Tax Amount",GLSetup."VAT Rounding Precision",Direction);

// Add the following lines.
  IF "Tax Base Amount" = 0 THEN 
    "Tax %" := 0; 
// End of the added lines.

END ELSE IF "Transaction Type" = "Transaction Type"::Sale THEN BEGIN
  IF ("Export or Deemed Export") THEN
    EXIT;

 // Add the following lines.
  LineTaxAmount := IndianSalesTaxCalculate.CalculateTax( 
     "Tax Area Code","Tax Group Code",TRUE,"Posting Date", 
     "Tax Base Amount",Quantity,0,'',"Tax %"); 
// End of the added lines.

  IF LineTaxAmount <> 0 THEN
    IndianSalesTaxCalculate.GetVATOpeningSTD(Rec,StandardDeductionAmount,TaxAmount);
  "Tax Amount" := TaxAmount - StandardDeductionAmount;

 // Add the following lines.
  IF "Tax Base Amount" = 0 THEN // Add
    "Tax %" := 0; // Add
// End of the added lines.

  "Input Credit/Output Tax Amount" := "Tax Amount";
  "Amount Loaded on Item" := 0;
END;
...

更改印度销售税计算codeunit (13704) 中的代码，如下所示︰现有代码

...        Taxamount := TaxBaseAmount * TaxDetail."Tax Below Maximum" / 100;

      IF (TaxJurisdiction."Tax Type" = TaxJurisdiction."Tax Type"::VAT) OR
         (TaxJurisdiction."Tax Type" = TaxJurisdiction."Tax Type"::CST)              
...

替换代码

...         Taxamount := TaxBaseAmount * TaxDetail."Tax Below Maximum" / 100;

// Add the following line.
      TaxPercent :=  TaxDetail."Tax Below Maximum";
// End of the added line.

      IF (TaxJurisdiction."Tax Type" = TaxJurisdiction."Tax Type"::VAT) OR
         (TaxJurisdiction."Tax Type" = TaxJurisdiction."Tax Type"::CST)
...

7. Codeunit 13704 Indian Sales Tax Calculate
 Function CalculateTax
 Add the below Parameter
 VAR TaxPercent Type Decimal

系统必备组件

您必须安装要应用此修补程序的印度版本的 Microsoft Dynamics 导航 2009 Service Pack 1 (SP1)。

删除信息

您不能删除此修补程序。

状态

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

参考资料

VSTF DynamicsNAV SE: 252133

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

显示"税金百分比"值不正确和已过帐的销售/采购发票行在印度版本的 Microsoft Dynamics 导航 2009 SP1 中销售/采购订单行

症状

解决方案

修补程序信息

安装信息

代码更改

系统必备组件

删除信息

状态

参考资料

需要更多帮助?

需要更多选项?

此信息是否有帮助?

谢谢您的反馈！