Microsoft Dynamics AX (Archived)

VAT and mischarge in Purchase order

(0) Share

Report

Posted on by Mustafa Barry

Dear

our purchase order have mischarge such as (Freight, Customs) the amount of those misc should be included on VAT

E: Purchase price for one pcs is 100 , Freight is 10 , Customs is 20)

when I implemented on AX the system calculate the VAT as 100 - 10 - 20 = 70 * 0.05

but I thing it should be 100 + 10 + 20 = 130 * 0.05

any idea about this.

thanks.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mustafa Barry,

I am not clear how you recorded your charges. Did you make use of a charge code? If so, how did you set it up? Have they linked an item sales tax group?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mustafa,

How did you setup the charges? Possibly you have put the customer/vendor on the wrong side. Did you do the setup on the debit or the credit side? Try to switch this.

Was this reply helpful? Yes No
Suggested answer

guk1964 10,888 on at

Like (0)

Report

AP-Setup- MIsc Charges -Misc. charges code

Set up your freight misc charge with an item tax group assigned. This will default the tax group when you add the misc charge on an order. With your tax codes are configured AX should apply tax.

Was this reply helpful? Yes No
Mustafa Barry 45 on at

Like (0)

Report

Yes we are using the charge code as below ,

once I allocate the misc and then check the sales tax it become negative

Was this reply helpful? Yes No
Mustafa Barry 45 on at

Like (0)

Report

Hi,

I traced the code for the sales tax calculation , the system change the sign to negative because it's purchase related.

the below code from mrkuptrans\signedvalue.

AmountCur signedValue(AmountCur _amountCur)

{

AmountCur signedValue;

if (this.isMarkupSalesRelated())

{

if (this.markupTable().CustType == MarkupType::CustVend)

{

signedValue = _amountCur;

}

else

{

signedValue = -_amountCur;

}

}

else

{

if (this.markupTable().VendType == MarkupType::CustVend)

{

signedValue = _amountCur;

}

else

{

signedValue = -_amountCur;

}

}

return signedValue;

}

Was this reply helpful? Yes No
Suggested answer

Mahmoud Hakim 17,887 on at

Like (0)

Report

hi Mustafa Barry

this code is normal, based on your charge code setup

so can you share screen shoot from your charge code setup , maybe as André said Possibly you have put the customer/vendor on the wrong side

Was this reply helpful? Yes No
Mustafa Barry 45 on at

Like (0)

Report

this is how we setup the freight mischarge , our company will paid the tax on the freight not by the vendor. the mischarge posted correctly to the GL and the amount debit the inventory , but once I activate the tax , the amount of tax become negative which reduce from the total tax for the purchase order amount.

thanks

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Mustafa,

What do you mean by saying that you activate the tax?

What did you do for this activation?

Best regards,

Ludwig

Was this reply helpful? Yes No