Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Packing list Carton# counting question.
Message
From
28/09/2001 05:02:28
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Packing list Carton# counting question.
Miscellaneous
Thread ID:
00561824
Message ID:
00561824
Views:
49
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.
Next
Reply
Map
View

Click here to load this message in the networking platform