>> Fastbase Business Software Ltd

Fastbase Accounting System - Online Manual

Printing Stock Bin Location

Document 102761/1

Entered Mon, 13 Jan 2003 17:03 by Peter Campbell
Updated Mon, 13 Jan 2003 17:05
Previous


You can print the stock bin location on any form as required, typically they would print on the picking slip.

Example:

(body section of the layout)

# find the stock location for this part/branch
set location [lindex [lindex [sql "SELECT WAREHOUSE_LOCATION FROM STOCK_QTY
where COMPANY_ID = '$login::company_id'
and PART = $part(NUMBER)
and BRANCH = '$order_header(BRANCH)'"] 0] 0]

# output the location at position 100
text $location 100


Online documentation: enter keywords to search for: