NameDescriptionTypeAdditional Information
ProductSetGUID

The GUID of the product set to edit the information for

globally unique identifier

Required

NewSetDescription

The new unique name of a blend product set within the Agvance database.

string

Max length: 15

Must not contain invalid characters which include: '

SetType

The type of the Product Set. Valid entries are Dry, Feed, Liquid, Suspension, Other; null or not including this property is also valid

string

Must be one of these values: Dry,Feed,Liquid,Suspension,Other

WaterRatePerAcre

If the water percentage is not used, this optional Rate/Acre settings may be used to indicate the default amount of water to include. This must be included in the product details as well as in the Key Inventory Item to be used.

string

Max length: 6

Must be numeric

ClayRatePerAcre

If the clay percentage is not used, this optional Rate/Acre settings may be used to indicate the default amount of clay to include. This must be included in the product details as well as in the Key Inventory Item to be used.

string

Max length: 6

Must be numeric

MinimumGalPerAcre

Applicable only to liquid and suspension blend sets, the program adds enough water to meet this minimum if the calculated Gallons/Acre falls below this figure during the formulation process. If filled out, when a Blend Ticket is created, on the Products tab the water product is added in an amount so the blend meets this minimum setting.

string

Max length: 8

Must be numeric

WaterPercent

This optional setting causes water to be added in as a percentage of the total product. If using this percentage, the Water Rate/Acre must be zero or blank. To utilize this item, it must be included in the product details making up the Product Set and in the Key Inventory Item.

string

Max length: 6

Must be numeric

ClayPercent

This optional setting causes clay to be added in as a percentage of the total product. If using this percentage, the Clay Rate/Acre must be zero or blank. To utilize this item, it must be included in the product details making up the Product Set and in the Key Inventory Item.

string

Max length: 6

Must be numeric

AllowNToRunOver

Allow Nitrogen to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowPToRunOver

Allow Phosphorus to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowKToRunOver

Allow Potassium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowSToRunOver

Allow Sulfur to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowUdToRunOver

Allow User Defined to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowCaToRunOver

Allow Calcium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowMgToRunOver

Allow Magnesium to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowZnToRunOver

Allow Zinc to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowFeToRunOver

Allow Iron to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowMnToRunOver

Allow Manganese to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowCuToRunOver

Allow Copper to overfill an analysis request.

boolean

Must be 0, 1, True, or False

AllowBToRunOver

Allow Boron to overfill an analysis request.

boolean

Must be 0, 1, True, or False

PercentWaterToPreload

If set, the percentage of water is listed first on the Blend Ticket regardless of its blend order.

decimal number
BaseGradeProductIdentifier

The product identifier for the BaseGradeProduct - Either the GUID or the Department/Product combination must be provided. Guid will be used if populated

ClsProductIdentifier
PercentBaseGradeToPreload

If set, the percentage of the Base Grade product is listed first on the Blend Ticket regardless of its blend order.

decimal number
ClayProductIdentifier

The product identifier for the Clay Key Inventory Product - Either the GUID or the Department/Product combination must be provided. Guid will be used if populated

ClsProductIdentifier
DryFillerProductIdentifier

The product identifier for the Dry Filler Key Inventory Product - Either the GUID or the Department/Product combination must be provided. Guid will be used if populated

ClsProductIdentifier
WaterProductIdentifier

The product identifier for the Water Key Inventory Product - Either the GUID or the Department/Product combination must be provided. Guid will be used if populated

ClsProductIdentifier
BlenderCapacity

The default for the blender used to mix the product (may also be used as the capacity for the spreader). The capacity has an effect on the number of batches required for the mix. The capacity may be overridden when creating a blend or field plan.

integer

Cannot be negative

SuspensionBlendTargetPercent

This is the total analysis % (sum of the nutrients’ percent concentration) that the guaranteed analysis cannot exceed when formulating a Suspension blend. If the percentage is higher than this number, a prompt appears for the blend operator to decide if water is to be added to the blend until the total of the nutrients’ guaranteed analysis is at or below this setting. The default value is 38.

decimal number
PhosphatePercentLimit

This upper limit setting for the P2O5 Guaranteed Analysis adds water to the blend until this blend’s P2O5 guarantee is at the upper limit entered here. This is used by companies when the amount of a product should be limited, such as Acid, to keep the fertilizer mixture from getting too hot. A setting of ‘999’ deactivates this checking.

decimal number
SaltOutSystem

The setting that indicates which calculations are used to calculate the Salt Out Temperature 0 = None, 1 = NoPolyUan, 2 = Poly55Uan, 3 = Poly70Uan, 4 = NoPolyUrea, 5 = Poly55Urea, -1 = NoPolyUanByEquations, -2 = Poly55UanByEquations, -3 = Poly70UanByEquations, -4 = NoPolyUreaByEquations, -5 = Poly55UreaByEquations; null or not including this property is also valid

string

Must be one of these values: 0,1,2,3,4,5,-1,-2,-3,-4,-5

PercentChlorineWarning

The percentage at which a warning is displayed after formulating a blend. If set to zero, the warning is disabled.

decimal number
BlenderCapacityUnits

The Blender Capacity Units; null or not including this property is also valid

string

Must be one of these values: Lbs,Gal,KG

EqualOrPartial

Equal or Partial Batch Defaults; null or not including this property is also valid

string

Must be one of these values: E,P

FormulateToAGivenSaltOutTemperature

This setting allows the program to verify the salt out temperature during formulation and make adjustments if needed. This is only available for ‘Suspension’ type Product Sets and when the SaltOutSystem is greater than 0. Note: If formulating To a given salt out temp, Then Set the SuspensionBlendTargetPercent To 9999.

boolean

Must be 0, 1, True, or False

FormulationMaximumSaltOutTemperature

The maximum salt out temperature used for a ‘Suspension’ type Blend Product Set. The SaltOutSystem must be greater than 0.

string

Max length: 10

Must be numeric

LocationIdentifier

The location identifier for this Product Set - Either the GUID or the ID must be provided. Guid will be used if populated Only the Product Sets created for the location assigned to a Blend Ticket are available for selection when the Blend Ticket is created. When an existing Blend Ticket is edited, product sets from all locations are available to use as needed.

ClsLocationIdentifier
AutomatedBlenderType

The Automated Blender Type for this blend product set. N = None, L = SsiStandardXml, S = SsiStandardAscii, R = SsiRancoAutomation, K = Kahler, J = JungeLiquid, A = JungeDry, O = MurrayRemote, U = MullayLiquidExtended2, V = MurrayDryExtended2, E = MullayLiquidExtended, X = MurrayDryExtended, W = MurrayLiquidWin, Z = MurrayDryWin, T = RepeteSabreNxt, C = SSIManualEntry; null or not including this property is also valid

string

Must be one of these values: N,L,S,R,K,J,A,O,U,V,E,X,W,Z,T,C

AutomatedBlenderDataStoragePath

The network path used when creating automated blender interface files.

string

Max length: 100

RancoBlenderSettingsPrinted

Enable the Ranco RPM settings to be printed on the Blend batch ticket.

boolean

Must be 0, 1, True, or False

RancoMaximumCapacity

The maximum downflow capacity of the Ranco blender in Lbs/Min.

string

Max length: 6

Must be numeric

RancoMaximumDialSetting

The maximum dial setting for the Ranco control panel. Typically this is set to 999.

string

Max length: 6

Must be numeric

PercentBoronWarning

The percentage at which a warning is displayed after formulating a blend. If set to zero, the warning is disabled.

decimal number
SuppressBatchSheetLoadCheckboxes

The setting that indicates if the boxes to mark for orders requiring multiple batches are suppressed when printing the Blend Ticket.

boolean

Must be 0, 1, True, or False

AutomatedBlenderProductAttributeKey

The MasterCrossRefNamesKey of the Product Attribute to use - if set to 0, this will use the default for the Automated Blender Type The Product Attribute to use as the product id in the automated blender interface files. This allows the same product to have multiple blend factors for different blending systems.

integer

Cannot be negative

Inactive

Indicates the Blend Product Set is inactive. Setting Product Set inactive prevents it from being available in the list of Blend Product Sets on the General tab of the Blend Ticket window.

boolean

Must be 0, 1, True, or False

AutomatedBlenderShippedFromLocationCode

A special code that is used for some automated blender interfaces that indicate a shipped from location different from the Agvance Ship From Location ID.

string

Max length: 20

AutomatedBlenderAlternateCompletionFileExtension

The alternate extension to search for when getting the completed files back from an automated blender other than the standard that the program was coded for.

string

Max length: 5

AutomatedBlenderUseBlendFactorForProductID

An automated blender interface setting to override the Product ID value in the file that is created with the blend factor of that product.

boolean

Must be 0, 1, True, or False

AutomatedBlenderFromRemoteDataStoragePath

For selected automated blenders, a secondary network path that is where the completed files are read from.

string

Max length: 100

AutomatedBlenderExpirationDate

For selected automated blenders, a default setting for the expiration date of the blend ticket. To clear this date - Set to an empty string.

string

Format must be MM/dd/yyyy

VisibleToDispatchOnly

A Blend Product Set that is “Dispatcher Only” is not visible to blend operators when adding or editing a Blend Ticket unless the dispatcher has saved the Blend Ticket with one of these product sets assigned to it.

boolean

Must be 0, 1, True, or False

ShipFromLocationIdentifier

The ship from location identifier for this Product Set - Either the GUID or the ID must be provided. Guid will be used if populated This setting relates to the Dispatch module only. Specifying a Ship From Location on the product set allows the Dispatcher to be more in control of products available when selecting product sets in Dispatch to create automated blender files. This is available regardless of the selections in Accounting for the Ship From Location or Sell From DeptID preferences. Setting a location on a job through one of the viewing buttons (Ship From or Sell From) has the original product set associated with the blend, as well as any other blend product sets from other locations which match that location, available in the Blend Product Set drop down list.

ClsLocationIdentifier
AutomatedBlenderImportRoundToScale

A setting that indicates that for Automated Blender Files, if the final product amounts should be rounded based on the scale settings from Agvance.

boolean

Must be 0, 1, True, or False

FullDetailProductReplacementList

The list of detail products to replace all existing products in the set IF Populated the UpdateDetailProductItemList property will be ignored

Collection of ClsBlendSetDetail

Maximum of 50 allowed

UpdateDetailProductItemList

The list of detail products to UPDATE based on the ProductIdentifier and properties not set to null

Collection of ClsBlendSetDetailWithRemoveOption
FullAddOnReplacementList

The list of addon products to replace all existing records in the set IF Populated the UpdateAddOnItemList property will be ignored Setting to an empty array will clear the Addons for this set

Collection of ClsBlendSetAddOn
UpdateAddOnItemList

The list of addon products to UPDATE based on the ProductIdentifier and properties not set to null

Collection of ClsBlendSetAddOnWithRemoveOption