Calculate square feet for non-stock items entered in SI based on inch dimensions entered in the line's description!

NOTE: This requires enhancement SCQ - Sales Custom Quantities to fill the Qty Shipped. If SCQ - Sales Custom Quantities is not active, the square feet calculation will still happen, and the result will be stored in the U/M field, but the Qty Shipped will not be automatically filled.

Also, SSN - Permanent Non-Stock Items may be helpful, it allows you to set up non-stock items in Inventory.

When entering a document (quote, order, or invoice), you will enter an SQ transaction type (square feet calculation), which will turn into an SN (sale of non-stock) on the document. Once you have entered the Product ID, a box will pop up with two fields, where you will enter the item's dimensions (in inches).

+------------------------------------------------------------------------------+
¦SIPROC1                         Add Documents              COMPANY ID: SP     ¦
¦02/25/97                     Software Profesionals                            ¦
+------------------------------------------------------------------------------+
DOC TYPE....: I  Invoice                DOC STATUS.: A Active
DOC NUMBER..: 023556
CUSTOMER ID.: ANDERA  Anita S. Anderson
DOC DATE....: 02/25/97
                       PROD            QTY         QTY  PRICE           DISC T/
LN.TYP...PRODUCT.ID.....CD.U/M.......ORDERED.....SHIPPED.CD..UNIT.PRICE..PCT..E
 1 SN SMILight Maple

                +------ Dimensions -------+
                ¦ 29 7/8     X 17 3/8     ¦
                +-------------------------+

Once you've entered the dimensions, the program will put them in the line's description, separated by an X. The program will also convert the dimensions to square feet, and store the number of square feet in the U/M (Unit of Measure) field. To convert the dimensions to square feet, the program will round the dimensions up to the next higher whole inch, multiply them together, divide the result by 144 (inches / square foot) and round this final result to one decimal place. If this number is less than one, it will be forced to 1. This is the number that will be stored in the U/M (Unit of Measure) field. You will need to press return past the Product Code field to see this result.

+------------------------------------------------------------------------------+
¦SIPROC1                         Add Documents              COMPANY ID: SP     ¦
¦02/25/97                     Software Profesionals                            ¦
+------------------------------------------------------------------------------+
DOC TYPE....: I  Invoice                DOC STATUS.: A Active
DOC NUMBER..: 023556
CUSTOMER ID.: ANDERA  Anita S. Anderson
DOC DATE....: 02/25/97
                       PROD            QTY         QTY  PRICE           DISC T/
LN.TYP...PRODUCT.ID.....CD.U/M.......ORDERED.....SHIPPED.CD..UNIT.PRICE..PCT..E
 1 SN SMILight Maple     A 3.8
         Description.: 29 7/8 X 17 3/8

 F1-Help                  ShF5-Status Chg                                 I

Now enter the Qty Ordered. This is the number of units (doors, etc.) that the customer ordered. The Qty Shipped will automatically be filled with the total square feet for this order. This is the number of square feet per item (as stored in the U/M field) times the number of items ordered (as stored in the Qty Ordered field). In this example that's 3.8 square feet times 2 items, or 7.6 square feet.

+------------------------------------------------------------------------------+
¦SIPROC1                         Add Documents              COMPANY ID: SP     ¦
¦02/25/97                     Software Profesionals                            ¦
+------------------------------------------------------------------------------+
DOC TYPE....: I  Invoice                DOC STATUS.: A Active
DOC NUMBER..: 023556
CUSTOMER ID.: ANDERA  Anita S. Anderson
DOC DATE....: 02/25/97
                       PROD            QTY         QTY  PRICE           DISC T/
LN.TYP...PRODUCT.ID.....CD.U/M.......ORDERED.....SHIPPED.CD..UNIT.PRICE..PCT..E
 1 SN SMILight Maple     A 3.8          2.00         7.60        0.0000
         Description.: 29 7/8 X 17 3/8

 F1-Help                  ShF5-Status Chg                                 I

The other fields will be entered as you would for a normal SN line. i.e. You would enter a unit price, discount percentage, taxable/exempt, and unit cost.

+------------------------------------------------------------------------------+
¦SIPROC1                         Add Documents              COMPANY ID: SP     ¦
¦02/25/97                     Software Profesionals                            ¦
+------------------------------------------------------------------------------+
DOC TYPE....: I  Invoice                DOC STATUS.: A Active
DOC NUMBER..: 023556
CUSTOMER ID.: ANDERA  Anita S. Anderson
DOC DATE....: 02/25/97
                       PROD            QTY         QTY  PRICE           DISC T/
LN.TYP...PRODUCT.ID.....CD.U/M.......ORDERED.....SHIPPED.CD..UNIT.PRICE..PCT..E
 1 SN SMILight Maple     A 3.8          2.00         7.60        8.0600  0.00 T
         Description.: 29 7/8 X 17 3/8        UNIT COST:         5.7000


 F1-Help                  ShF5-Status Chg                                 I

Please Note:

If you entered the line as an SN (rather than SQ), you could enter the dimensions directly in the description field. If you do this, the dimensions must be in a format that the program recognizes. The following are examples of acceptable formats:

29 7/8 X 20 7/8
    23 X 14 7/8
17 7/8 X 17 15/16

The required format is: a number, optionally followed by a fraction in the format xx/yy, followed by an X, followed by another number, optionally followed by another fraction in the format xx/yy. A space is required between a number and a fraction, and ignored anywhere else.

After pressing return through the Product Code and U/M fields, you will enter the Qty Ordered. The Qty Shipped will be pre-filled with the Qty Ordered times the square feet stored in the U/M field. (Current SCQ - Sales Custom Quantities functionality.)