MYOB Greentree

HideShow

  • Contents
  • Index
  • Search
 
Display results with all search words

 

gtINReorderDetail


Use this function to update inventory item Reorder information to Greentree Desktop and can also be used to create a reorder details record.

Company

The Company code the inventory item belongs to.

StockItem

The inventory item code that reorder details are to be updated to.

Active

The status of the reorder detail.

ShippingMethod

The shipping method for the inventory item.

MinQty

The minimum quantity of the order.

MaxQty

The maximum quantity of the order.

EconomicalOrder

The economical order quantity for this inventory item.

LeadDays

The number of lead days for the reorder.

ReorderType

The type of reorder for example, 'Minimum/Maximum'.

Location

The location of the inventory item relevant to this reorder.

Returns

  • Not Updated - if no error is encountered
  • Updated - after running Greentree Desktop update function
  • Error message - if an error is encountered

Example

=gtINReorderDetail(01,68SC SECRETARY,True,Courier,2,20,10,5,Minimum/Maximum,A01)

Errors Returned

  • Must have a Company identifier
  • Must have a Stock Item
  • MinQty must be numeric or omitted
  • MaxQty must be numeric or omitted
  • EconomicalOrder must be numeric or omitted
  • LeadDays must be numeric or omitted