Help working with batch, quantity and date

fnfrbr95 — Sat, 16 Nov 2024 20:31:59 GMT

Hey guys, I need help.

I am working with a table that has the following structure:

Type|Batch|Date|Quantity

0001|XXXXX|2019-01-01|1000

0002|XXXXX|2019-01-02|100

0002|XXXXX|2019-01-03|100

0001|XXXXX|2019-01-04|50

0002|XXXXX|2019-01-06|100

What I need is to use all quantity in the first row (1000), type 0001, before using the quantity produced in 2019-01-04.

My Result should be:

Type|Batch|Date|Quantity

0001|XXXXX|2019-01-01|1000

0002|XXXXX|2019-01-02|100

0002|XXXXX|2019-01-03|100

0002|XXXXX|2019-01-06|100

0001|XXXXX|2019-01-04|50

It's basically a Sorting problem, the information type 0001 and type 0002 are in the same table and have the exactly same structure, but one is Items produced (0001) and the other are Items Sold (0002).

I need to sort them in a way that I only consume from a Batch that is previous to the Selling date and that I always get my quantity from the oldest remaining Batch produced (type 0001).

I hope you guys understand, if not, please ask me.

Thanks in advance.

Re: Help working with batch, quantity and date

Lisa_P — Wed, 03 Jul 2019 03:32:30 GMT

Is the batch a number ? Can you load by batch ascending ?

Re: Help working with batch, quantity and date

fnfrbr95 — Wed, 03 Jul 2019 03:36:01 GMT

The batch isn't always just numbers, it can be number and letters, it's already ascending considering batch and date, but as I showed new batches come out with same number/code before the older batch ends.

topic Re: Help working with batch, quantity and date in App Development

Help working with batch, quantity and date

Re: Help working with batch, quantity and date

Re: Help working with batch, quantity and date