landedcost

[Former Member]

Hi Experts,

There is some issue regarding the landed cost.

when i make grpo and aftr that i make a/p invoice and aftr that i make landed cost.

while i make A/P credit memo price diffrence acount is hit. why?

and the my stock in hand acount also debited with extra amount who is equl to landed cost amount.

there is problem bcz i have made reverse JE against landed cost So some Some Acount are Standing with sme Amount:--

EXAMPLE:--

For GRPO--

P.Stock in hand- Dr.(143000)----Cr.(0)

GRNI--

---

Dr.(0)----Cr.(143000)

Purchase material- Dr.(143000)----Cr.(0)

Purchase Offset--- Dr.(0)----Cr.(143000)

and when I made A/P Invoice--

Party--

---

Dr.(0)----Cr.(143000)

GRNI--

---

Dr.(143000)----Cr.(0)

Aftr In Landed Cost---

P.Stock in hand- Dr.(11000)----Cr.(0)

Freight--

---

Dr.(0)----Cr.(11000)

Purchase material- Dr.(11000)----Cr.(0)

Purchase Offset--- Dr.(0)----Cr.(11000)

I have made reverse JE for Landed Cost .

when i Make A/P creditmemo----

Party--

---

Dr.(0)--

---

Cr.(-143000)

P.Stock in hand- Dr.(-154000)----Cr.(0)

Price Diffrence- Dr.(11000)--

---

Cr.(0)

Purchase Return- Dr.(-154000)----Cr.(0)

Purchase Offset--- Dr.(0)----Cr.(-154000)

Experts Plz help me for balance my acount,

plz guide me which acount debit and which acount credit for nill the impact of this transcatiuon.

and. is this nessasery to make A/P invoice aftr the making of landed cost.

or we can make landed cost before Invoiceing..

THANKS a LOT in ADVANCED:----

JRAJPUT

[Former Member · Accepted solution]

Hi,

Please check your GL determination first.

Why you are making reverse JE for landed cost when you are making credit memo automatic that effect will return off.

AP Credit memo's effect as

Party--

---

Dr.(143000)--

---

Cr.(0)

Tax A/c--

---

Dr.(0)--

---

Cr.(0)

P.Stock in hand- Dr.(0)----Cr.(154000)

Expense clearing account- Dr.(11000)--

---

Cr.(0)

Purchase Return- Dr.(0)----Cr.(154000)

Purchase Offset--- Dr.(154000)----Cr.(0)

Thanks

Sachin

[Former Member · Accepted solution]

Hi Ashu/Joseph,

this is not mandatory to making reverse landed cost JE.

But now what can i do for acount settalment.

and joseph my items was still in warehouse when i make credit note.

tell me . wht's up for acounting .....

JRAJPUT

[ashutosh_tomar · Accepted solution]

Sit with your accounts guy, and make necessary adjustments first in Test environment. Ask him how to resolve the account mess, He/She will suggest you right accounts. Make changes. Re run Landed cost Cycle and check whether this time the accounting is correct.

Mr. Joseph is correct in saying that Price difference account only comes to seen if there is no material in that particular WH.

Thanks for specially assigning this query to me.

Take Care-

Ashutosh T

[Former Member · Accepted solution]

Hi,

Due to the reversal of Landed cost JE, your stock account got credited twice. Try the following in your test db nd see if its givin you the desired result.

Check this in test environment first:

Stock account --- 11000 Dr

Purchase return -- 11000 Cr

Freight --Dr

Price Difference --Cr

Thanks,

Joseph

[Former Member · Accepted solution]

Hi Joseph,

U mean to say pass a JE for same .

but in my case i anlyses all the acount so result:----

SIH----

---

(-11000)Dr.

PRICE DIFF act.----

---

11000Dr.

purchase return----

---

(-154000)Dr.

PURCHASE OFF -

---

11000CR.

so wht JE should be make ????

so result i can all the act nullify...means sattele all the acount...

JRAJPUT

Edited by: J2663312 on Jun 21, 2010 5:12 PM

PLZ help me somebody on this issue .....

Edited by: J2663312 on Jun 22, 2010 5:54 PM

[Former Member · Accepted solution]

hi J,

I would suggest you to take a back up of the db, restore it and pass a je as suggested and check the results.

Thanks,

Joseph

[Former Member]

Hi,

Thankss 4 u Ashu...

JRAJPUT

[Former Member]

Hi J Rajput,

The price difference account was hit cause at the time when you created the credit memo, the material might not have been in that warehouse.

You can create the landed cost document as soon as you create the GRPO.

Thanks,

Joseph

[ashutosh_tomar]

Dear J,

Why are you creating Reverse JE. I am not sure but this is not required in general cases.

Is there any specific requirement to do so?

Regards

Ashutosh T