Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Answered

Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

(0) ShareShare
ReportReport
Posted on by 23

Dear all, I have a customer I’m setting up, and for some reason, the way I set up their system, I’m getting too many Direct Cost transactions posting to the G/L.

You can see in the attachment that I’m getting 2 Direct Cost (in-and-out) that don’t need to be there:
pastedimage1675085687105v1.png


I have Direct Cost posting turned on, but in Cronus it’s there too, and I don’t get the extra lines.

It’s forcing me to add an Inventory Adjustment Account (50300), but I’m not sure why it’s posting t to that account when I simply post a purchase invoice and a payment against it.

Anyone have any idea what I’ve done wrong?

  • RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    Thanks for helping me with this... learning that Cronus General Ledger Setup is improperly set up was mind-blowing. Thanks MS! Also the refresher on data migration!

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    Val, your interco setup in General Posting Setup is concerning and may be the cause of your problem.

  • RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    PINV-108008.png

  • RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    Hi Kim, thanks for responding. I've been sick, so slow to respond.

    The payment is an "intercompany" transaction.

    The duplicate Direct Cost 2 entries are the concerning bit.

    General-Posting-Setup.xlsx

    Inventory-Posting-Setup.xlsx

  • Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    pastedimage1675092698777v1.png

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS

    It's hard to assist not knowing what this transaction is from start to finish. It looks like a purchase with an automatic payment but there's a reference to a Sales invoice in the External Document No. Also, it's hard to know your general ledger accounts.

    A purchase will debit the Purchases GL Account from General Posting Setup 50110 and credit accounts payable 20100 from the Vendor Posting Group, I highlighted in yellow. Additionally, inventory will be debited 12000 and direct cost applied will be credited--this shoiuld be a contra account to purchases but it looks like you have it set to 12000; these are highlighted in blue. I definitely  think you have the wrong account setup for Direct Cost Applied; you should not use inventory adjustment.

    Payment entries are highlighted pink.

    The entries in green are a concern.

    Screenshot of your general posting setup and inventory posting setup would be helpful. Do you have expected cost turned on?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans