- Contents
- Index
- Search
Display results with all search words
gtINStockItemSupplier
This function updates inventory item Supplier information to Greentree Desktop and can also be used to create a Supplier details record.
Company
The company code that the inventory item belongs to.
Supplier
The Supplier's identifying code. This must be unique in the Company. If supplier details already exist for the inventory item specified then an error is returned.
StockItem
The inventory item to be updated with supplier details.
Location
The location path for the inventory item.
CurrencyCode
The currency code to use for the supplied inventory item — for example, NZD (New Zealand Dollars)
UOM
The unit of measure for this inventory item — for example, EA (each)
SupplierPartNo
The Part Number allocated by the Supplier.
QuotedCost
Tthe Supplier's quoted cost for the inventory item.
LastCost
The last cost for the inventory item from this Supplier.
ReviewDate
The date of review for this inventory item Supplier.
ShippingMethod
The default shipping method for the inventory item supplied by this supplier.
LeadTime
The default lead time for this part from this Supplier. A numerical value is entered to represent this value.
IsPreferred
A flag to indicate whether the Supplier is the preferred Supplier for the inventory item for example, True or False.
IsActive
A flag which indicates whether the Supplier is active for this inventory item for example, True or False.
Returns
- Not Updated - if no error is encountered
- Updated - after running the update function
- Error message - if an error is encountered
Example
=gtINStockItemSupplier(01,100002,68SC SECRETARY,A01,NZD,EACH,100002,44.10,44.2489, 23/10/00,Courier,2,True,True)
Errors Returned
- Must have a Company identifier
- Must have a Supplier
- Must have a Stock Item code
- Must have a location path
- Must have a currency code
- Must have a Unit of Measure