Report Template help - easy for someone who knows!

[CMJtype256]

Hi,

I've modified at stock report template to show items required for each of my build orders, but it's only showing allocated stock (and not those few items that are not allocated yet as they're on order). I want it to show all items for that build, allocated and unallocated. What do I need to change in the bit I've circled in red (I've guessed at 'all_stock' etc with no luck)?

Thanks in advance!

[SchrodingersGat]

@CMJtype256 there are a few options here:

• build.allocated_stock: All StockItem objects which are allocated to the build
• build.bom_items: All underling BOM items for the assembly
• build.line_items: The required line items for the assembly (taken from the BOM items, multiplied by the build quantity)
• build.build_outputs: The "output" items (created instances of the assembly part)

To get the "on order" quantity you will need to iterate through each of the build.line_items, find the underlying Part instance, and then display the "on order" quantity for that part

[CMJtype256]

@SchrodingersGat Many thanks....trouble is when I substitute "build.allocated_stock" with any of your suggestions, my report table returns nothing. I'm guessing I'm misunderstanding the basics here! Do I need to adjust the line data in my report (also shown above in the snapshot) to suit?

[CMJtype256]

@wolflu05 Hi again - I've installed it via the Docker route, but when clicking the "Report LSP" button, the status text at the bottom goes from 'Starting LSP...(Connecting)" to Disconnected within a couple of seconds...any thoughts? Thanks.

[CMJtype256]

Looks like it's got something to do with Docker as it keep restarting....

[CMJtype256]

I've since pulled the Stable version but same thing. I'm sure it's something simple and me just being stupid! :)

[wolflu05]

That's interesting. That can be related to the recent base image change of inventree, I will have to do some tests in the next days. It would be helpful if you can provide the log output from the report LSP container. You may can click on it if that's docker desktop, or you can also exec docker compose logs -f report-lsp

[CMJtype256]

@wolflu05 Hi - sure, log coming up in a moment. I'm still stuck on getting my report sorted so keen to give your plugin a try once it's up and running again.... hopefully later today haha!

[CMJtype256]

[wolflu05]

Yes, that's due to the changed base image. Just change /bin/ash to /bin/bash in the added service in de docker compose file.

[CMJtype256]

Ok many thanks will give that a go!

[wolflu05]

I have updated the docs now.

[CMJtype256]

Thanks @wolflu05 The plugin is working great. Despite that, I'm still trying to work out how to get my build report to list non-allocated items as well as allocated!