Is there a bug in expected cost posting in 5.0 SP1?

podollypodolly Member Posts: 84
Hi all,

I tried to post purchase receipt on PO, and find that even I run the adjust cost - item entries and post inventory cost to G/L, I cannot read any figure in the G/L. I have the below settings, please advice where I can check if this is a bug and whether there is any fix to it thanks.

Inventory Setup
Automatic Cost Posting
Expect Cost Posting

Gen. Posting Setup
Invt. Accrual Acct (Interim)

Inventory Posting Setup
Inventory Account
Inventory Account (Interim)

Comments

  • ara3nara3n Member Posts: 9,256
    look at the value entry and what is the cost amount (expected).
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • AdamRoueAdamRoue Member Posts: 1,283
    What is the costing method of the item and what is the cost on the PO/Item card?
    The art of teaching is clarity and the art of learning is to listen
  • podollypodolly Member Posts: 84
    I used Standard Cost for all items.

    In the item card, I set up the standard cost as 37. On the PO, the direct unit cost with VAT 17% is 40.

    Upon posting the receipt, all below fields are 0.00
    Sales Amount (Actual)
    Cost Amount (Expected)
    Cost Amount (Actual)
    Cost Amount (Non-Invtbl.)
    Cost Posted to G/L

    Thank you very much for your help.
  • AdamRoueAdamRoue Member Posts: 1,283
    Go to the purchase order and order button and find the receipt. Then go to the line and zoom. What values are in the unit cost (lcy) and direct unit cost fields. The first should be your standard, the seconf the purchase order cost.

    Then go to navigate, do you have 2 GL entries?
    The art of teaching is clarity and the art of learning is to listen
  • podollypodolly Member Posts: 84
    Thanks, I simulated the case again with a new database setup, and seems it's working. Maybe I have got some settings wrong in the previous case. But now I get another question on prepayment.

    When I post prepayment of 5% on the purchase order, I was prompted the message:
    The VAT Posting Setup does not exist.
    Identification fields and values:
    VAT Bus. Posting Group='PRC',VAT Prod. Posting Group=''


    I believe there is a table in between missing this field value during the posting, as I zoom on the purchase line, the VAT Prod. Posting Group is having value VAT17. Any idea on how to solve this problem? Many thanks.
  • AdamRoueAdamRoue Member Posts: 1,283
    Remove the prepayment - do you get the same error message?
    The art of teaching is clarity and the art of learning is to listen
  • podollypodolly Member Posts: 84
    It works fine with no prepayment.
Sign In or Register to comment.