gtINLocation
This function creates and updates inventory location information to Greentree.
Company
The Company Identifier for the Inventory location.
LocationPath
The full location path to be created or updated.
Name
The name of the inventory location.
Branch
The branch code for this inventory location.
IsStockAtThisLevel
Indicates whether inventory is to be held at this level. Specify True or False.
isWarehouseAtThisLevel
Indicates whether there is a warehouse at this level. Specify True or False.
IsActive
Indicates whether the location is an active one.
Address1
The first address line. If the location has a warehouse at this level then an address is required.
Address2
The second address line.
Address3
The third address line.
Phone
The phone number of the location's contact.
StockAccountNo
The GL Inventory on Hand account for the location.
IsProtected
Indicates whether the location is protected.
PrintLocTrfs
Indicates whether to print a location transfer report for transfer transactions for this location.
PostCode
The post code of the location's address.
Suburb
The suburb of the location's address.
CityOrState
The city or state of the location's address.
CountryCode
The country code of the location's address.
time zone
The time zone of the location's address.
Fax
The fax number of the location's contact.
Contact
The contact of the location.
The email address of the location's contact.
IsBin
Indicates whether the location is a bin location (only applicable if Warehouse Bin Management is in use).
IsMixedBin
Indicates whether the bin is a mixed bin.
UseBinMgt
Indicates whether the warehouse is a bin-managed warehouse.
BinType
This must be a valid bin type (set up on the Bin Type Maintenance form).
Note: The option is mandatory if IsBin is selected, and is only valid for a bin location.
Returns
- Not Updated - when no error is encountered
- Updated - after running the update function
- Error message - if an error is encountered
Example
=gtINLocation(01,A01,Union St, Auckland,01,True,True,True).
creates the Auckland warehouse with inventory at this level in company 01.
Errors Returned
- Must have a Company identifier
- Must have a location path
- Must have a branch code
- An address is required for this location (if inventory at this level)