Capturing info for items packed in multiple boxes

[former_member461091]

Hi All,

I am new to the forum and a relative novice at SAP.

We are running SAP Business One 9.10.160.

We have a situation where many of the products that we carry are packed into 2 or more boxes (biggest is 1 unit packed into 5 boxes). The boxes will also always be different dimensions.

How would I capture this info into Item Master data?

Is there a way to capture multiple sets of dimensions and or the weights for each box?

If not, is there a way to capture that this particular item comes in 3 boxes?

Here is an example:

Item: JPO1015G

Box 1: 118cm x 50.5cm x 48cm @ 73.5kg

Box 2: 118cm x 50.5cm x 29cm @ 49kg

This currently captured as follows:

JPO1015 - 118cm x 50.5cm x 77cm @ 122.50kg

The reason to change this is as follows:

1. To be able to do Packing Lists

2. To be able to create an excel file to upload direct to couriers for creating shipping labels.

Any assistance would be appreciated.

Thanks

Chesray

[frank_wang6]

I believe u will need to create a few UDF's to hold these info on ItemMaster, and using query to generate the info for that shipping software.

Frank

[former_member461091]

Thank you Frank.

Now to figure out how to create UDF's.

[frank_wang6]

Since u have max of 5 boxes per item, u might want to create at lease 5 or multiple of 5 UDFs to accommodate different info. Split info into different fields will be easier, such as length, and weight. In your case, u might need 4 for length, height, width and weight. So a total 20 UDF might be needed.

Or u can combine info into a single fields, but later you will need to parse the info in SQL, which sometimes create more trouble.

Frank