on 2023 Nov 28 8:14 AM
Hi
I have Packing size of an item mentioned in item master. and also mentioned as first three numbers in item description
when they post sale order quantity is divided by packing size and reflect in no packages.
select T1. quantity / T2.U_PackingSize from RDR1 T1
Left Join oitm T2 1. item code = T2. item code
I tried this query It Won't work.
Request clarification before answering.
User | Count |
---|---|
91 | |
11 | |
9 | |
7 | |
6 | |
4 | |
4 | |
4 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.