Fastbase Accounting System - Online Manual

Printing Supplier Part Number

Entered Mon, 13 Jan 2003 17:09 by Peter Campbell
Updated Mon, 13 Jan 2003 17:11
Previous

You can print the supplier part number, typically on a purchase order.
Insert the following code into the body section:

if {$part(MAIN_SUPPLIER) == $supplier(NUMBER)} {
field part(SUPPLIER_PART_NO) 37 15 -size 9
} else {
variable alternate_suppliers

sql::find alternate_suppliers "COMPANY_ID = '$login::company_id'
and PART = $part(NUMBER)
and SUPPLIER = $supplier(NUMBER)" "" -fields {SUPPLIER_PART}

field alternate_suppliers(SUPPLIER_PART) 37 15 -size 9
}