Skip to Content
author's profile photo Former Member
Former Member

Landed Costs Journal Entry

My customer created a Purchase Order, then a GRPO based on the PO.(both in USD) for different items of different item groups.

They then created Landed Costs based on the GRPO in ZAR.

The journal created the following transactions :

Item Group A to Price Diff Account

Item Group B to Price Diff Account

Item Group C to Price Diff Account and to Stock Account.

For Item Group A & B there was no stock account postings.

Any ideas on how to sort this?

Thank you

Janice

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 28, 2008 at 01:03 PM

    Hello Janice,

    The Debit posting accounts in Landed Cost transactions depend on the current In Stock quantity of the item.

    If the In Stock Qty > = Landed Cost Qty, then only the Stock Account will be used.

    If the In Stock Qty < Landed Cost Qty, the landed cost amount will be split between the Stock and Price Difference accounts.

    If the In Stock Qty = Zero, then all the landed costs will be posted to the Price Difference account. This is in the assumption that all the items have been sold. Hence, any further costs pertaining to the sold items will be considered as an additional expense to appear in the Profit and Loss Report.

    The above scenarios are described in Note 1161695 entitled Price Difference in Landed Cost transactions.

    I hope it helps.

    Regards,

    Lorna Real

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 28, 2008 at 09:26 AM

    Hi Janice,

    Could you please check the quantity of the third item in stock is greater than the the quantity in GRPO or not?

    I think it is related to this.

    Thanks,

    Maggie An

    SAP Business One Forum Team

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 28, 2008 at 09:35 AM

    Hi Janice,

    I think these happened due the fact that at the time the landed cost posted to SAP all of item A & B already sold, and some of the the C still exist in the system.

    Cheers,

    Dody

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.