Bug in BED calculation

vicky_dada

Hi Guys,

We are facing a logical error in the calculation of “BED Credit” field in RG 23 A PART II table and this is happening in the standard Navision.
Case 1 : Create a purchase order for foreign vendor with CVD in structure field, make sure that currency code is not blank
Calculate the structure values and post the invoice. Select “Receive and Invoice” (Enter CIF and BCD amount manually)
Result : Navigate to the posted invoice, you will find the BED Amount in the Excise entry table is same as “BED Credit ” in RG 23 A Part II

Case 2: Create the same purchase order, you first receive and then invoice
Result: Same as case 1

Case 3 (error): Create a purchase order for foreign vendor with CVD in structure field, make sure that currency code is not blank
Receive the purchase order from warehouse receipts
Invoice the document through purchase invoices, not through the same purchase orders
Result: Navigate to the posted receipts, you will find the system creates an extra entry which is not the same as in above cases

has any one faced this kind of error in the standard Navision or am doing any wrong posting?

ssingla

I can confirm that this is a bug. You can report it to MS (https://connect.microsoft.com)

vicky_dada

Thanks for confirming singla. It took my two days sleep in debugging code.

I will see the reply from MS, if there is nothing then I know its checkExcisepostingdiff function in c 90 that making the difference I shall correct these :-k

ssingla

Let us know the MS response. Have you logged a support incident. The difference is occuring due to exchange rate conversion/calculation.

vicky_dada

Sure Singla, you are right the error is due to exchange rate conversion.

They have sent me new object but it is bringing wrong calcuation in some cases, I have reverted back expecting a reply, I shall update once I receive the reply from MS

vicky_dada

I have a doubt, in the training manual i saw that the Excise Duty is the sum of BED + ADC + ecess + shecess etc, but BCD amount is also payable to custom, so the calculation should also include BCD AMount * Quantity

Is there any setup or we need to customise the Excise calculation in T 39?

ssingla

Since the BCD has been included in the standard NAV functions I have not done any implementation involving custom duty calculation so can't really comment on it. But from the plain reading of the feature instruction manual I can make out that MS has tried not to involve NAV in BCD calculation and have simply made a field to type BCD amount of the item(Probably due to rounding problems that we normally face in VAT/Excise input credit). In case you need unit wise BCD value you can have a formula doing the same.

vicky_dada

was my question logically correct?

In the training manual, we see the Excise is 4393/- so it is nesscary to add BCD to that 4393 + (2*1000)

So should I code the BCD in the excise calculation

vicky_dada

Guys, to load the BCD on the custom duty payable, I am using CESS as 1005 of BCD in the excise posting setup, this gives me correct calculations

is there any risk in using the CESS as BCD in excise posting setup?

ssingla

There is no problem except that you might need to change certain captions in the forms and reports and pray that the Govt. does not levy Cess again on the items client is dealing.

Cess/SED/AED was widely used by people in 3.7 and 4.0 when E-Cess and SHE-Cess was introduced so I see no problem but test the solution before deploying and also define the correct "set off" setup.

vicky_dada

I have setup the same and tested, its fine with the setup.

I got the reply from MS, they said it may take 4-6 weeks to release the fix.

Thanks for your support

ssingla

Do post the KB Article no. or the fix so others may use the same.