NAV 2013R2 IN inconsistency Error while Posting Partial Charge Item with Tax on Purchase Order

abhi1901

Hi Guys,

In NAV 2013 R2 IN cronus DB I am getting inconsistency Error while posting any Purchase Order having Charge Item with VAT and Posting partial Charge Item.
Steps ::
1. Go to DepartmentsPurchase -> Order Processing->Purchase Orders
2. Create a new Purchase Order.
3. Select Buy-from Vendor No as ‘10000’.
4. Select Location Code as ‘Delhi’.
5. Enter Posting Date as Work Date
6. Select Structure as ‘VAT’.
7. On the line level, select Type as ‘Item’.
8. Select No. as ‘1000’.
9. Fill in the Quantity as ‘10’ and Direct Unit Cost as ‘1000’.
10.
11. Enter on the second line– Charge(item) - JB-FREIGHT
12. Fill in the Quantity as 2 and Direct Unit Cost – 500
13. Enter Qty to invoice - 1.
14. Click Line  Item Charge Assignment.
15. On the Functions menu button, select the Suggest Item charge menu item and click amount as option.
16. The program will assign partial amount to the receipt line.
17. Calculate VAT amount using FunctionsCalculate Structure Values.
18. Post the Purchase Order as Receive and Invoice.


While Posting you will get inconsistency Error.

Reason - Suppose the total TAX amount for charge item with 2 quantity is 100.
In Credit lines in GL for tax is posting with 100 tax amount(which is wrong. it should be 50).
In Debit GL lines it is going correct as 50.


Kindly let me know if anyone has any solution.

abhi1901

Kindly ignore.
This problem has been solved.
Need to modify code in Item Charge Assignment for Amount to Assign field and have to modify the CU 90 for calculating proper tax amount.

nowsheenms

Hi Abhi,
I have got the same error. Can you please share the code that fixed the bug. Thank you.

manisharma31

Its a bug, we too had the issue, you modified the code in CU90, this you need to find using debug.
There are functions created for itemcharge assignment in there, check the one that is related to your process.