Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Cost is a "Wash"?

Posted on by 3,480

Hi:

In a test company I tested the posting of a sales invoice, and pasted below are the resulting General Ledger Entries.

5000 is Cost of Goods Sold, while 1200 is Inventory.  FIFO is the inventory valuation method.

It would appear that posting both increased and decreased Cost of Goods Sold and Inventory, as if the transaction had been a "wash" (i.e. no effect).

Why?

Thanks!

John

pastedimage1644262086501v1.png

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Cost is a "Wash"?

    I suggest reaching out to your partner, so they can log into your system and dig a little deeper. I truly believe its something in setup.

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Cost is a "Wash"?

    Nope, same result...

    By the way, I don't have any account in the "Purch. Account" of General Posting Setup.  Should I?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Cost is a "Wash"?

    That is a safer way.  It also help if you can close your browser and open. Also,  after login back create new SO as well and try.

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Cost is a "Wash"?

    Since 5000 is the only cost of goods sold account and since there is no comparable expense account, I changed the Inventory Adjustment account and the Direct Cost account from 1200 to 5000.

    Unfortunately, I got the same original result.  Do I need to log out and log back in and try the sales preview posting, again?

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Cost is a "Wash"?

    Okay, your inventory adjustment account in general posting setup should be an account in the cost of goods section of your income statement or an expense account but NOT a balance sheet account. Same goes for the Direct Cost applied account.

    There are only two columns in general posting setup that could possibly have balance sheet accounts and both are used for expected cost posting (COGS Interim and Inv Accrual Interim)

    Likewise on your Inventory Posting Setup, the first 3 columns should always be balance sheet accounts.

    I know you are saying that this is only a problem with Lot tracked items but you are probably having an inventory to GL reconciliation problem as well.

    I would be concerned also if in General Posting Setup you have put your inventory account in the Purchase Account column.

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Cost is a "Wash"?

    Hi:

    Below are some screenshots.  Please let me know what else is needed.

    Thanks!

    John

    1106.Item.PNG

    Item2.PNG

    General-Product-Posting-Group.PNG

    Inventory-Posting-Setup.PNG

    1070.Inventory-Setup.PNG

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Cost is a "Wash"?

    The problem that we are all having is that nothing works differently in the general ledger posting for lot numbered items than for items without lots.

    I still believe it's a setup issue as I've never seen such an issue.

    Do you have any add-ons to Business Central?

    Also, more screenshots would be helpful...

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Cost is a "Wash"?

    Automatic Cost Posting is set to "on".

    I did discover that this lot-numbered item is in a different General Product Posting Group from the other items.  (It's the only lot-numbered item.)  But, there is no difference in accounting between that group and the others.

    Is there anything else that I can check?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Cost is a "Wash"?

    Thanks 

    It depends. if in Inventory Setup you have Automatic Cost Adjustment to Always then the answer is now. Otherwise you need to run that. 

    pastedimage1644444473206v1.png

  • john.ellis Profile Picture
    john.ellis 3,480 on at
    RE: Cost is a "Wash"?

    1) buy

    2) only one posting group for all items

    3) I can try this.  Does this have to be run often?

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,537 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,520 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans