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

Cost is a "Wash"?

(0) Share

Report

Posted on by john.ellis

3,510

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

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (20)

Answers (0)

Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I think you need to check that the inventory posting group and your general posting setup is correctly set up.

My best guess is that your general posting setup is incorrect.

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Well, any other hints are welcome. I have looked all over these setups and troubleshooted to no avail.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Hi

As Inge suggested please check two places

1) General Posting Setup and look for COGS and COGS interim and see if you have the same account number there.

2) Inventory Posting Setup and see Inventory Account and Inventory Account Interim and see if you have the same account number there.

Then see the below chart for transactions. as you can see at the time of Shipping BC Debit the COGS Interim and at the time of Invoicing it Credit Interim and Debit actual COGS. The reverse is for Inventory and Inventory interim. if you ship and invoice at the same time it may looks like the wash. Can you try to ship and see transactions then invoice and see the transactions?

I hope this help

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Thanks! I don't have Interim accounts in place.

I conducted additional testing. This "issue" does not occur, unless I'm selling a lot numbered item.

That's very curious. How does lot numbering "cause this"?

John

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

That is interesting. I hope Dallefeld or Gavin or or JAngle can provide some insight.

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

There is something in setup as this is not standard functionality.

Do you have expected cost posting turned on? If so what are your Inventory Interim and COGS interim accounts?

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

Hi Kim:

Expected Cost Posting is not turned on, and no interim accounts are set up.

John

Was this reply helpful? Yes No
Dallefeld 211 User Group Leader on at

Like (0)

Report

Is there an assembly involved?

Was this reply helpful? Yes No
john.ellis 3,510 on at

Like (0)

Report

No.

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

Just some more area to check

1) Do you buy or produce those lot numbers item?

2) Does that lot number item (in item card) has similar posting groups (inventory, Gen) similar to other items?

3) After invoice what will happen if you run Adjust Cost - Item Entries for that item?

Was this reply helpful? Yes No