inventree / InvenTree

Open Source Inventory Management System
https://docs.inventree.org
MIT License
4.27k stars 772 forks source link

Change part scheduling according to shipments instead of sales orders #5181

Open SchrodingersGat opened 1 year ago

SchrodingersGat commented 1 year ago

Discussed in https://github.com/inventree/InvenTree/discussions/5180

Originally posted by **HannesMorre** July 5, 2023 Since it is possible to split a sales order into multiple shipments, it seems logical to me that part scheduling should be adjusted according to these shipments instead of sales orders. See the example below: There is a sales order with target date 30/08/2023. This sales order holds 3 line items (articles A, B and C) each 50 pcs. Articles A and B are fully allocated to shipment 1 (which is scheduled for 15/07/2023) 25 pcs of article C are allocated to shipment 2 (scheduled for 01/08/2023) 25 pcs of article C are allocated to shipment 3 (scheduled for 15/08/2023) In the part scheduling of these parts (A, B and C) we will see a drop on 30/08/2023. I think this should be 15/07/2023 for articles A and B, and for article C this drop should be split up on 01/08/2023 and 15/08/2023 instead of 30/08/2023. Or am I doing something wrong?
miggland commented 1 year ago

Which date are you using to schedule the shipment?

There are two dates:

The shipment date is intended to mark when a shipment is actually sent out. The delivery date has no logic connected to it, but was intended to be set when the shipment had been delivered. It could be used as a target date.

matmair commented 1 year ago

For the internal projections, it makes sense to use shipment day IMO - as the stock is out of the house from there on.

miggland commented 1 year ago

It does - but that date is filled on shipping at the moment, and isn't directly available to set in advance. It if is set, the shipment is marked as shipped.

SchrodingersGat commented 1 year ago

For this to work, we might have to add a "target date" to outgoing shipments? This is only really applicable when you have projected shipment dates

miggland commented 1 year ago

Yes, that would make it clean, and would be better than using delivery date.

github-actions[bot] commented 1 year ago

This issue seems stale. Please react to show this is still important.

HannesMorre commented 1 year ago

When is this planned to be implemented?

matmair commented 1 year ago

@HannesMorre There is no plan to implement this, if someone picks it up it will be implemented. If not it will be closed at some point. Things that are (somewhat) on the roadmap have either the label roadmap label or someone is assigned (which means the person is interested in implementing it). We do not provide implementation or release timelines.

HannesMorre commented 1 year ago

Okay, thanks for the info. This means there is a chance this will never be implemented, right?

wolflu05 commented 1 year ago

Possibly yes, but you can develop this yourself and propose a PR or maybe also sponsor this development if you really need it. But details you would need to discuss with @SchrodingersGat

HannesMorre commented 1 year ago

I am not currently active as a developer, but looking into starting over again so I can contribute to the project in my free time.

github-actions[bot] commented 1 year ago

This issue seems stale. Please react to show this is still important.

SchrodingersGat commented 1 year ago

Not stale

github-actions[bot] commented 10 months ago

This issue seems stale. Please react to show this is still important.

SchrodingersGat commented 10 months ago

Not stale

github-actions[bot] commented 8 months ago

This issue seems stale. Please react to show this is still important.

HannesMorre commented 7 months ago

not stale

bberg115 commented 4 months ago

I have a similar request for part scheduling.

Additionally, we would like some options for filtering and what is presented.

  1. Having a filter to only use issued sales orders in the view. We use Sales Orders for quotes and actual sales orders. Ideally, the "issued" state could be use as some sort of filter.
  2. Total count - it's shown on the graph, can the value be shown in the interace somewhere.
  3. Downloadable - can the data in the table be downloadable (csv)?