Integration»Adding Complex Features

Adding Complex Features

Adding Complex Features

While the walk thru provides a simple overview of creating and shipping records in NRGship, it is likely that you may need to create complex shipments which include third-party/recipient billing and/or international shipping. By adding additional logic to your scripting you can easily add support for complex shipments.

Saturday Delivery

For Saturday Delivery option, set field UPS_Ship::SaturdayDelivery to "1" - Saturday Delivery

Third Party/Bill Recipient/Consignee

Often the recipient will want to bill shipping on an alternate account. In order to facilitate this type of shipping, set the following fields in the UPS_Ship table: - Billing Options

BillToRadio [My UPS Account|My Credit Card|Receiver|Third Party|Consignee]

Alternate Account

If you have multiple accounts setup in NRGship and you'd like to script shipping from an alternate account, you can set the field UPS_Ship::Account_Alias to one of the account alias values from Preferences.

COD Shipment

To ship COD, the payment method is still the shipper but in the Packages table you will set the CODAmount field to the total amount that should be collected, including any shipping costs. If you will only accept Cashiers Check or Money Order as payment, set field Packages::CODCashiersCheckMoneyOrderOnly to 1. Note that the CODAmount is per package - you should set each package value if sending multiple packages. - COD Shipping

Multiple Packages

If you have package data in your solution, you can easily create additional related records in the UPS_Ship_Packages table. Rather than the 1:1 relationship from the Basic integration, a more complex script could be utilized to create additional records in the UPS_Ship_Packages table by setting the value of UPS_Ship_Packages::Ship_ID to the value from UPS_Ship::Ship_ID

For example, in your ship script, after you create a record in UPS_Ship you could set a variable $ship_id to the incremental UPS_Ship::Ship_ID.
When you are ready to create packages you can switch over to a layout based on UPS_Ship_Packages.
For each package, create a new record and set the UPS_Ship_Packages::Ship_ID value to the variable $ship_id.
Next, set all of the package values like weight, dimensions and reference number. Remember to commit the record after setting these values.

Post-shipment, if you wanted to grab all tracking numbers you could use a custom function like GetNthRecordSet and call using GetNthRecordSet ( UPS_Ship_Packages::Response_TrackingNumber; 1 ; ) to get a list of all tracking numbers for the shipment.

Multiple Shipments (for CRM or Backorders on Invoices)

If you would like to do multiple shipments from a CRM system (ex: Contacts) or an invoice /order database where you split shipments due to back orders, then you will likely want to create an interim "join" table between your table and the NRG tables.
Simply create a new record in the join table and then create your related record in UPS_Ship based on this ID instead of the primary key in your contacts or invoice table.
Thru a portal of the MultiShip table you could easily display each shipment's master tracking number along with associated costs.

Drop Shipments

You may want to create shipments that have an address displayed on the label that is different from the actual sending location. In order to facilitate these shipments, you will need to set values in these fields in the UPS_Ship table:
# These are the fields which will appear on the printed label

# These fields are used for rating purposes

NOTE: Some international shipments MUST display the actual origin address.

Email Notifications

By setting a valid email address in UPS_Ship::ShipTo_EmailAddress and UPS_Ship::Email_SendEnabled to 1 then the information will be passed to UPS for automated notifications based on your NRGship preferences.

You can set specific notification types for the shipper by setting UPS_Ship::Email_Notifications1 to values Ship|Exception|Delivery (return delimited)

You can set specific notification types for the recipient by setting UPS_Ship::Email_Notifications2 to values Ship|Exception|Delivery (return delimited)

You can set the Sender's Name by setting UPS_Ship::Email_Sender, along with UPS_Ship::Email_Siubject and UPS_Ship::Email_Message

It may be preferred to take the post-ship UPS_Ship::Response_ShipmentIdentificationNumber value and send out notifications from your own database so that you can include supplemental order information. - Notification Services

Shipper Release

By setting field UPS_Ship_Packages::ShipperRelease to value "1" (checked) UPS will deliver the package with no signature required. - What is Shipper Release?

Delivery Confirmation

By setting a value UPS_Ship_Packages::DeliveryConfirmationType UPS will provide Delivery Confirmation services. Note that Delivery Confirmation is a paid service so any option other than "-Choose-" or "" will incur fees. - Delivery Confirmation

Additional Reference Fields

By setting a value UPS_Ship_Packages::ReferenceNumber3, UPS_Ship_Packages::ReferenceNumber4 or UPS_Ship_Packages::ReferenceNumber5 additional data can be passed to UPS for packages that will not print on the ship label, but will appear in billing data. This makes it possible to pass additional data to reconcile with that will not print on the label.

Return Shipments

By setting a value in UPS_Ship::ReturnService to one of the value below, you can easily create return labels that can be printed or emailed to your customer. The label type will be based on your default preferences. If you normally generate a thermal label, but would like to produce a label for email use, you can set the value of UPS_Ship::LabelType to "Laser". You can then print using the OS to a PDF file, or use alternate FileMaker scripting to create an email. - UPS Returns

UPS Print Return Label
UPS Electronic Return Label
UPS Print and Mail Return Label
UPS Returns Plus (Call Tag) - 1 Attempt
UPS Returns Plus (Call Tag) - 3 Attempts

UPS Access Point

By setting values in the Ship table, you can setup deliveries to UPS Access Point locations. You will first need to capture the location information and AccessPointID values so they can be set in NRG. These can be obtained thru the UPS Locator API and generally would be implemented on your website. The fields below would then be populated based on your needs. - What is a UPS Access Point?

AlternateDeliveryAddress_UPSAccessPointID - Value from UPS for the Access Point
DeliverToAddresseeOnlyIndicator - Set to 1 if true
AlternateDeliveryAddress_ResidentialIndicator - Set to 1 if true
AlternateDeliveryAddress_POBoxIndicator - Set to 1 if true

Complex Printing

If you have multiple users with multiple output devices, you can control label output with finite control by setting several fields.
Ship::LabelType - Thermal|Thermal DocTab|Laser|Zebra|Zebra Doctab|Eltron|Eltron Doctab
Ship::Output_IPNumber - If has a value, will override default value with given IP #
Ship::Output_Username - Username for thermal printer if IP
Ship::Output_Password - Password for thermal printer if IP
Ship::Output_WindowsPort - If has a value, will override default value with given port
Ship::Output_ShipAndPrint - If ship and print is disabled in prefs, set this value to 1 and it will ship & print
Ship::Output_PrintDialogs - If dialogs are disabled in prefs, set this value to 1 and dialogs will appear

Labels to PDF

NRGship does not have an option to print labels directly to PDF (or to email). In order to produce output to PDF you would need to use the NRGship preference to print with dialogs (and then the user would manually select PDF or email) or you could add some scripting to utilize the field UPS_Packages::Response_GraphicImage on your own layout which would then use standard FileMaker scripting to print to PDF.

Simple International Shipments

If you are already producing international paperwork outside of NRGship then you can easily produce international shipments by providing a value in the two fields below. Note that you can fully automate international shipping by following the Full International Shipment information.
Description - Description of goods
InvoiceLineTotal - Total value of goods

Full International Shipments

NRGship provides the ability to printed or electronic commercial invoices. In order to populate the line items for a commercial invoice, you will need to create a relationship from UPS_Ship to UPS_Ship_IntlProduct based on UPS_Ship::Ship_ID to UPS_Ship_IntlProduct::Ship_ID. In the UPS_Ship_IntlProduct table, you will want to populate the following fields:
Unit_Number (Quantity)
Unit_UnitOfMeasurementCode (Normally, "Pieces")

In addition to the basic ship values you may also need to populate additional fields in the UPS_Ship table:
International_Forms_Invoice [Invoice|Partial Invoice]
International_AdditionalDocumentIndicator [1 if checked]
International_Forms_Other [NAFTA|CO|SED]
ItemizedPaymentInformation_BillToRadio [Shipper|Receiver|Third Party]

Please consult the International layout for additional fields to populate when using NAFTA, CO or SED.