Cost Price Issue

Finance and Operations/AX User Forum
1

Dear All Expert,

Please help me to get the right result for the cost after applying the import charges and fright charges.

Below is the issue i have mentioned.

{ i have purchase import item X with cost of 1 $ and applied frieght charges of 1 $ and import charges of 1 $

so my total cost of the item should come 3 $ but it is coming 2 $ in mange cost as well as in on hand in manage inventory tab

the charges code the way we have set is

freight charges debit

Type “ITEM”

posting “Empty”

Account “Empty”

posting Credit

Type “Customer/Vendor”

Posting “Empty”

Account “Empty”

for import expense changes

Posting Debit

Type:- ITEM

Posting “Empty”

Account"Empty

Posting Credit

Type"Ledger Account"

Posting “Purchase, Charges”

Account “2060009”

}

2

The setup looks fine.

On the PO invoice, what is the financial value of item? It should be 3.

Also, when did you applied the charges on PO and did you allocated both the charges on PO line. One of the charge didn’t got load to inventory.

Pranav…

3

As Pranav said there doesn’t seem to be a problem with the charges code set up.

  • I would suggest you to put the purchase price as 3 freight charges as 2 and Import charges as 1. At least, we can find out which charges are not applying.

  • After seeing which charges code is not applying, see the posting of this charges code. That may give us some understanding on to which accounts it is getting posted.

4

Dear Pranav and santosh,

thanks for your feedback.

actually freight charges was applied and import charges was not applied.

the main issue was regarding the wrong posting method was selected under import charges.

for import expense changes

The Above Posting Debit was right but in Posting Credit there was one issue which i have mentioned below.

Posting Debit

Type:- ITEM

Posting “Empty”

Account"Empty

Posting Credit

Type"Ledger Account"

Posting “Purchase, Charges” ( here it was selected Purchase Freight Instead of Purchase Charges.)

Account “2060009”

}

so this was not affecting the items.

but still thanks so much guys and one more thing want to know there are many method under posting drop down what is the use of each do any one have doc for this please share if some one has.