Have City spent a billion since the Sheikhs joined, out of interest?

He's a talented player but doesnt really excel in any area Rev

Didnt know SWP was still so young and still had the possibility to reach the top of the game. Can't wait till you all see that once again i am right, and you are all wrong, again.

Rev always has to be different

The moment Ramsey gets good he takes him out of his name, facking hipster

HK ?

yes mate?

I took ramsey out of my name as my job is done. everyone has realised i was right. Then i noticed OX was being criminally underrated. he is my next mission.

comment by HK - Ozil's Sexy Eyes (U8418)
posted less than a minute ago
yes mate?
----------------------------------------------------------------------


Can you give me some maths help?

go on

OK, give me a second to type out the problem

1+4=5 Chris I told you already

Trying to code a delivery note.

On it you start with two quantities - Quantity Ordered (in Warehouse Qty) and Quantity Ordered (in Customer Quantity).

OK so a customer could order 6 boxes which contain 5 aerosols in each. So warehouse quantity would be 6 , customer quantity would be 30.

Now what happens is that this stuff has batches, so sometimes my delivery note will break a line down by batch.

So we might ship out, from the above example, 4 boxes on batch123, and 2 boxes on batch234, so then obviously the customer qty would be 20, warehouse quantity would be 4.

One thing is that either warehouse or customer quantity can be higher or lower, it's not always customer quantity is higher.

So question is - what piece of 'logic' can I apply to my code to calculate the customers quantity from the warehouse qty shipped?

i salute your mission Corporal Rev

How can customer quantity be lower when each box has at least 5 products?

That was just an example. Some customers could have less in their quantity.

So another example would be a warehouse quantity of 5, but a customer quantity of 1

oh right. Probably the easiest way is to turn the warehouse quantity into individual item. So instead of 4 in your example, use 4*5=20. Then it will be easier to calculate

How do you mean?

Dont have the warehouse quantity as a box, but the same as the customer quantity, right?

So question is - what piece of 'logic' can I apply to my code to calculate the customers quantity from the warehouse qty shipped?
---------------------------------------------------------------
Not sure if I'm not getting what you are asking.

That would depend on the size of the batch. If the batch has 7 products and customer orders 4, then that's 28.

It can be either way. So the warehouse quantity can be a box, a unit, a carton whatever and the same for customers quantity.

Very confusing stuff

Chris or to keep ti simple. Warehouse quantity before shipping - warehouse quantity after shipping = customer quantity


of course you would multiply it by the number products in the box

So basically

Qty Ordered / Qty Shipped is system generated.

But our customers send a customer quantity on each orderline, we don't do anything with this quantity it's just for their reference. So if we pick the order line in full, we can just put the customers quantity straight in there.

BUT if we split the customers order or ship less, we have to calculate it somehow.

A better example

Usually :

Ordered Qty : 20
Shipped Qty : 20
Cust qty : 40
Shipped cust qty : 40

But if we 'short ship'

Qty Ordered : 20
Qty Shipped : 15
Customer Qty : 40
Shipped cust qty : ??

Now I know it's 30, but what piece of maths needs to take place here?

Customer Qty : 40 divide by Qty Ordered : 20

Then times the answer by Qty Shipped : 15

so 40/20 * 15 = 30