[Richard Corona]

Up

0

Down

::

Long story short, I don’t think there is an out-of-the-box report for your specific requirement; you will have to get creative.

If it were me, I’d export the item ledger with a filter “QTY remaining = <>0”
Meaning, “don’t show me things that are zero.”

I would ensure my Item Ledger Entries page, or config pack if you so choose, includes the lot + sn data.

Then with the raw data, Excel it out the rest of the way.
You can create a column to divide the field QTY by the Cost Amount, which would give you the unit cost.

Filters for dates, that kind of thing.

If you want to get fancy, you could do these same things in Power BI and set it up where all you have to do is refresh the data with a click of the button! It could update for any new lines added to the report, and you can move your dates around as needed. The bonus is, it’s not that difficult to set up, and you can probably get it created in an hour or so.

For reference, these are all the out-of-box reports for BC. Pretty handy for these kinds of questions.
Report overview – Business Central | Microsoft Learn

[Richard Corona]

Up

0

Down

::

Hello there!

Open up web services page.

Select “…” from the menu

Select “Actions”

Select “New Document”

Select “Create Data Set”

Go through the prompt and designate the comuns you want from the desired endpoint.

That should do it!

[Richard Corona]

Up

0

Down

::

In Dynamics Business Central,

> Undo registered picks, put-away and movement.

> When using Advanced Warehouse, Undo a posted receipt after the material has been moved from the receiving zone.

> Undo Receipt of Subcontracting PO when Subcontractor is last step in routing.
> “Reason code” is lost on Physical Inv Journal when “Calc. Warehouse Adjustment” is run.

[Richard Corona]

Up

0

Down

::

Usually, if there was no item tracking code on the item master before turning it on, you should be able to enable it. If you had one prior, it’s not likely you’ll be able to change it or add a different code after the fact.

You will likely need a new item card.

– Senior Functional Consultant

[Richard Corona]

Up

0

Down

::

My Pleasure!