cancel
Showing results for 
Search instead for 
Did you mean: 

Fms query condition for sale order

80153
Member
0 Kudos

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.

Accepted Solutions (0)

Answers (0)