Calculate backlog

[takbb]

Ok @Gabriel2020 , so a couple of things to keep in mind here .

The java snippet in the thread that you are referring to, as mentioned, performed a very specific task described here, and I stated its limitations along with questions that needed to be answered regarding any additional rules that might be required:

@takbb

This is only applying the rules:
(1) current backlog = Shipping Volume - Receiving Capacity + previous backlog
(2) if current backlog <0, then set current backlog to zero.
…
What are the other rules concerning start of week etc, and did it need to take into account ORIGIN and DESTINY?

I suspect that within the limitations I stated, it is doing what it was coded to do. If it isn’t working as you needit to, it’s probably because it did not take into account ORIGIN and DESTINY.

But I thought that this all moved on with the following post…

General summase

thanks @iCFO . I haven’t incorporated the “week grouping”, but I’m guessing that is where you ended up heading on the other thread. I thought I’d uploaded this though. Perhaps the week groups can be incorporated back in relatively easily? I may be returning the favour and asking you for your assistance on working that back in here… @Gabriel2020 , please take a look at the attached. I decided to ditch the java snippet that I posted before and instead make use of the alternative which uses…

Did this later solution not fully cover the calculations you needed? In that post you will see I said

@takbb

I decided to ditch the java snippet that I posted before and instead make use of the alternative which uses components (which contain java snippets) to do the job. This way, I could then more easily add the refinements.

Generally if I ditch an idea it is because I found it deficient compared with an alternative so I’m not sure we should be trying to start from here again unless we really need to.