count the Orditems.CTN_NOS question
Real Packing list case can be:
Sample Packing list:
CTN_NOS ITEM DIMENSION
001 CM-1234-T1-M 43x46x25cm.
001 CM-1238-T1-M
001 CM-1467-T1-M
002-003 CM-1477-T1-M 27x25x26cm.
004,008,012 CM-1677-T1-M 26x24x22cm.
005-007,009-011 CM-1678-T1-M 26x25x22cm.
013 CM-1688-G1-M 28x29x30cm.
I need to calculate the correct Carton # with calculate the Final cbm of whole shipment.
In above example, repeating 001 mean same carton, user only fill one time on pklength, pkwidth, pkwidth.
Thus, the count would be 1 only if exist Volume.
001 with DIMENSION give 1 as combine carton
001 with NO dimension give 0 as counted already
002-003 will be subtract the value and give 2 as count.
004,008,010 will be individual count, i.e. 3 as count
005-007,009-011 will also give 6 as result
013 give 1 as count because it represent one carton# only
How can I count it? currently using manual count will be very poor.
Second, how can I check out it is already counted and prompt user error?
001-010
008-009 <~ it will be error, duplicate carton#
Thanks. :)
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.