Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP forum
Suggested answer

Inventory Adjust Costs JE Account Entry is Incomplete

Posted on by 5

I used the Inventory Utility Adjust Costs to adjust the cost on 2 RCT.  The Cost Adjustment Audit Report shows total Debit and Credit of $40.00 each.  The problem is the JE won't post.  The General Posting Journal shows "Account entry is incomplete."  What do I need to do?  What accounts should be on the JE?   

Categories:
  • VickieJ Profile Picture
    VickieJ 5 on at
    RE: Inventory Adjust Costs JE Account Entry is Incomplete

    Yes, that helps.  I ended up correcting the JE by using the same account for the debit and credit.

  • Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Inventory Adjust Costs JE Account Entry is Incomplete

    Hello Vickie,

    Thank you for your response!

    Based on your scenario provided above, I would agree you handled this correctly.

    Regarding if you should enter a Journal Entry. I would say no.

    Here is an example of what i would say no.

    I bring in 10 qty at 1.00 and 10 qty at 3.00.  So I have 20 qty at a total ( in GL ) of 40.00.   I then adjust the 10 at 1.00 to be 2.00 ( debit 10.00 ) and adjust the 10 @ 3.00 to be 2.00 ( credit 10.00 ).  End result 20 qty @ 40.00

    I hope this helps!

    Brandon Jarrett | Microsoft Support Engineer

  • VickieJ Profile Picture
    VickieJ 5 on at
    RE: Inventory Adjust Costs JE Account Entry is Incomplete

    Brandon,

     Thanks for replying.  Our offset account is Inventory Adjustments.

     Let me explain what led to the cost adjustments: We had a PO with 4000 lbs of an item on it.  The person who entered the receiving only scanned in 2000 lbs and added landed costs based on the full 4000 lbs.  Then they scanned in the remaining 2000 lbs without any added landed costs.  This caused a layer of 2000 lbs at $1.468/lb and a layer of 2000 lbs at $1.428/lb.  The correct cost per lb is $1.448.  So I did cost adjustments to make them all $1.448/lb.  So 2000 lbs went up by $.02/lb and 2000 lbs went down by $.02/lb.  The net effect is $0.00 which might be why there is no JE?   Should I have handled this differently or not at all?  Should I do a JE debiting and crediting Inventory Adjustments $40.00?

  • Suggested answer
    Hokuminaria Profile Picture
    Hokuminaria 2,950 on at
    RE: Inventory Adjust Costs JE Account Entry is Incomplete

    Hello Vickiej,

    When testing this in my environment, the two accounts that get update are the Inventory Account and Offset Account. You will need to know what accounts these are for your company.

    To get the Journal Entry to post, what you will need to do is edit the Journal Entry for the missing account.

    1. Transactions | Financial | Batch.
    2. Select the batch.
    3. Click Transactions.
    4. Select the Transactions.
    5. Enter the missing Account.
    6. Click Save.
    7. Close the window.
    8. Print the Edit List of the batch to verify there are no error.
    9. Post the batch when needed.

    I hope this helps!

    Brandon Jarrett | Microsoft Support Engineer.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Product updates

Dynamics 365 release plans