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

(0) Share

Report

Posted on by Val Gameiro Consult...

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:

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?

All responses (6)

Answers (0)

Val Gameiro Consult... 23 on at

Like (0)

Report

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 11,425 User Group Leader on at

Like (1)

Report

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.
Val Gameiro Consult... 23 on at

Like (0)

Report

RE: Having a Posting Problem with too many Direct Cost entries in Business Central SaaS
Val Gameiro Consult... 23 on at

Like (0)

Report

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 11,425 User Group Leader on at

Like (0)

Report

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

Dallefeld 11,425 User Group Leader on at

Like (0)

Report

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?