Microsoft Dynamics NAV News / Updates

This version supports PDF printing as a complement to Integrated Printing. To enable this there is a new setting in LogTrade Connect Setup: “Print Destination” with the options “Integrated Printer” and “PDF”.

Bug fixes/changes:

Automatic creation of consignments from posting of inventory pick did not filter the order automation setup on shipping agent and shipping agent service code

Numeric values for service parameters was calculated double when service was inserted automatically based on service setup.

VAT Registration No. was not fetched from customer or vendor when creating consignment without a source document.

Internal unit for weight (kilogram or gram) can now be specified in the setup.

Bug fixes/changes:

When using order automation to create consignments from sales order and purchase order with multiple location codes the location code on the sales/purchase header could be changed.

Consignments created on posting of inventory pick used the location code from the header of the source document instead of the location code from the inventory pick.

Shipment Date can now be calculated based on Shipment Date on Warehouse shipment.

Names and addresses on Consignment was always recalculated when changing shipping agent/-service code even if the address setup was identical for the previous and new shipping agent service code.

Booking Reference can now be specified on a consignment.

When entering Volume on a consignment line width, length and height were cleard on packages. This is changed so these fields are only cleared if all three have a value (and thus have been used to calculate volume for the package)

Consignment can now be created/sent automatically when posting an Inventory Pick.

The extension for changed standard objects now contain Package Type Shortcut Code, No of Packages, Gross Weight, Volume and Load Meters on Inventory pick. Together with automatic creation and sending of consignment on Inventory Pick posting, this means that it’s possible to get labels printed automatically when posting the Pick.

It was not possible to setup a default property value without specifying a service

The filter on Country/Region Code when searching for inhouse customer numbers was based on the Sender address. This has been changed so the filter is based on the Country/Region Code on the source document.

Custom Field Mappings to Consignment Address with Type = Delivery did not update the deliver address fields on the Consignment.

“To Table” and “To Address Type” were missing in the primary key for the Custom Field Mapping table

A new table “LogTrade Web Shop Instruction” that can be populated from a web shop integration with order specific values such as mobile phone no. reference, gate code etc., which the consignment will pick up when the source document number is validated. This table means that LogTrade Connect supports the new LogTrade Checkout functionality.

The extension for standard objects in NAV2017 now includes new fields on sales order and sales return order (Package Type Shortcut Code, No of Packages, Gross Weight, Volume and Load Meters). If Package Type Shortcut has been specified these fields are used to automatically create a consignment line. There’s also a new action in to create and print a consignment. This means that printing labels from a sales order is now only one click away.

The update of “Sent to LogTrade” on consignment is now updated regardless if there’s an answer from LogTrade or not. This eliminates the LogTrade error “Consignment with ID already exists” when the response from LogTrade for some reason wasn’t received/processed.

The function “CreateFromInvPick” has been removed from codeunit 12057533. The function “CreateFromInvtPick” should be used instead.

“Do not use with EUR pallet customer No.”-functionality on consignment costs did not work after upgrading to version 27.

Automatic freight cost inserts on source document did not work since version 27

This version includes a major refactoring in how names and addresses are managed. Upgrading to this version requires data upgrade. Fobs for data upgrade are available for all supported NAV versions (2013 and later). 2013/2013R2 consists of Step1 and Step2 codeunits and from 2015 it’s an upgrade codeunit. Please observe that you need to be on version 23 or later when upgrading to version 27.

Please test thoroughly and involve the customer before go-live since a lot of the functionality in the consignment has changed.

New functionality:

Addresses and customer numbers has been moved away from the Consignment Header table to a separate table with Consignment Addresses. Only the delivery address fields are available directly on the consignment (and kept in sync with the address with Address Type = Delivery in the new Consignment Address table.

There’s a new setting in the setup called “Internal Unit Measure” which decides if meter/cubic meter or decimeter/cubic decimeter is used internally in NAV.

It is now possible to import/export forwarder mappings and additional product settings in the generic import/export tool.

Freight Supplement Charge can now be specified on Forwarder Product which will (if set) overrule the generic setting. This way you can have different freight markups on different products.

There are two new settings in LogTrade Connect Setup than enables automatic assignment of “Note of Goods” on Consignment Lines. This can be useful when consolidating consignments to keep references from the original consignment.

Custom Field Mappings now support more filter columns (Shipping Agent, Shipping Agent Service Code and From Location Code) and fixed values. This way it is possible to automate gate codes, opal numbers etc.

Extensions for NAV2017. One for LTC objects and one for changes in standard pages. This means you can run all LTC functionality as an extension or only use extension for changes in standard objects.

Costs can now be calculated on a set of rules based on Order Value, Shipping Value, Weight etc.) and also inserted automatically when sending the consignment to have the Source document updated with handling costs etc.

A brand-new Setup Wizard which takes you through the basic setup step-by-step.

It is now possible to specify on a cost code if it shall be used in sales, purchase or both. The field “Unit Price (LCY)” has been changed to “Sales Unit Price (LCY)” and is now only used towards a customer.

All five different mobile phones numbers and e-mail address on a consignment are now possible to use for default service parameter values.

SMS functionality with support for automatic SMS from a number of system events as well as manual SMS, template support, phone no. lookups, dynamic parameters etc.
Please note that this functionality requires changes in standard NAV2013/2015 but not in NAV2016 since we use events there.

Printer setup per computer. A new table where default printer can be specified based on the local computer. This also works in citrix/wts where we use the session variable “clientname”.

Running the Setup wizard in a tenant caused a permission error on the Permission table and the Chart table when defaultsettings.xml was imported if the user didn’t have permission to update in the application database.

Calculation of EUR-pallets in Consignment Header was wrong when using automatic calculation based on Package Type Shortcuts.

It was not possible to use automatic printing of local Customs Invoice on release when the release was done from the Consignment (instead of the worksheet)

It is now possible to choose when archiving Released Consignments in the Released Consignment Worksheet if only the current Consignment shall be archived or all Consignments (within the filter) shall be archived

A new concept regarding send/print has been implemented. The behavior depends on the setup or “Print Method”. If print method is “LogTrade Controlled” there’s no longer a Send action. The user now selects “Print” and if the Consignment hasn’t been validated it gets validated and printed (based on setup in LogTrade). After validation the Consignment is no longer editable until it’s reopened. When a Consignment is reopened it is sent to LogTrade back to status “Saved” (formally called “New”). Printing a Consignment that is already validated will prompt the user for what to be printed. If “Print Method” is not “LogTrade Controlled” the user use “Send” to send the Consignment (and print if the send method corresponds to the print method setting). If no print command is specified in the setup the user is prompted what to print, otherwise what’s in the setup will print.

It’s now possible to print a transport label for one single package even if there’s more than one package on a Consignment Line.

It is now possible to define separate transport discounts for back order consignment and non-back order consignments.

Local print of Customs Invoice can now be automated also on release of consignment.

There was a bad Location Filter when fetching lines from Linked Source Documents to Customs Invoice.

When changing product, the Tracking No. on the Consignment are cleared, and Package Numbers on Packages are cleared. If Package Numbers has been created by NAV (e.g. SSCC) the user must first confirm to reset the Package Numbers. This was a change in version 18 for 2013 and later versions and upgraded to a bug for classic in this release.

The description on tracking entries has been extended to 250 characters.

Update of fright cost on Source Document was also activated for Transfer Orders.

There’s a new setting “Single Package Lines” in the LogTrade Connect Setup that controls if Consignment Lines shall have a one-to-one relationship with a package, or if multiple packages with the same Package Type Shortcut Code shall be aggregated into one single Consignment Line.

There is a batch job that query Control Tower for multiple released Consignments. The Consignment is updated with Date and time when delivery was made to the Recipient. There’s also a report for follow up on delivery times and comparison with Promised Delivery Date (when Source Document Type is “Sales Order”).

Custom Data 1..5 is now supported on Customs Invoice, Custom Invoice Line and Dangerous Goods.

It is now possible to setup on a user level if consignments shall be filtered based on the Warehouse Employee table.

User-ID has been added to the Sender Address Code setup so that default Sender Address Code can be implemented on user level.

Country/Region Code is now available when setting up default Service Property Values.

Sender codes are now fetched from LogTrade through a web service.

It is now possible to download and view Consignment Events from LogTrade and view them in a list form/page. An event can be: Validation, Release, Print, EDI transfer etc. Each event is tracked with date/time, user id and a description.

The User ID field in table 12057526 “LogTrade User Setup” has been extended back to 50 characters in versions for NAV2013 and later. In version 15 this fields were decreased to 20 characters by mistake.

Update of freight cost on Source Document now support Warehouse Shipments. A Warehouse Shipment Line is inserted and ready to ship regardless of Location requires Pick or not.

The form/page for Linked Source Documents was not editable in some situations. This has been corrected.

A rule-based notification functionality that sends e-mail on release, on prepare or manually with information about the Consignment, PDF-link, Tracking link etc. The primary targeted use is to notify shipping agents that do not support electronic bookings.

Create LogTrade web users from LogTrade Connect.

Links for External Login, Tracking, Labels, Bill of Lading etc. are now stored in a separate table for Consignment Links.

Return Address fields on consignment and setup on Split point if Return Address shall be used and if it should be the standard sender (company/location address) or the inherited address from the Split Point.

Further changes to support country specific Consignment Services such as PostNordSwedenContainedProducts so that data for these are saved after fetch from Consignment so that default property values can be defined (after the first usage on a Consignment)

It is now possible to define discounts on the transport cost that is used to update source documents. This means that you can define freight free limits, customer specific agreements and make sure that a Shipment Method meaning free freight really results in that.

The method of grouping lines on Customs Invoice is now setup per Country and it is also possible to group on Item No. and have Item No. shown on the invoice.

In the setup there is now a new field “Default Source Document Type” that is used to automatically set the Source Document Type on new Consignments that is created manually.

If you manually link Source Documents to a Consignment a list of Linked Source Documents (+ the “Main Source Document”) will open in a list instead of just the Source Document specified on the Consignment after sending the Consignment.

Weight and Volume sent to LogTrade are also based on new fields “Total Weight” and “Total Volume” on Consignment Line. This means that re sending an old consignment after upgrading to version 12 means that no weight or volume is sent to LogTrade. Therefore, the fields “Total Weight” and “Total Volume” should be assigned the values from the old fields. This can be done by using this report:

New functionality:

Package Type Shortcuts can now be defined and mapped to actual Packet Types. This means that you can define i.e. a shortcut called PALL that you map to different packet types for different Forwarder Products. This makes it easier to choose Package Type since the same Shortcut Code can apply to different Package Type Names.

Default Package Type Shortcut on Forwarder Product.

Advanced Management:Packet Type Shortcut Setup with Weight, Pallet Places, Volume on Packet Type Shortcuts. Volume can be defined as Including or excluding the actual goods. New fields on consignment line: “Packaging Weight”, “Total Weight”, “Packaging Volume” and “Total volume”. With these functions the weight/volumes for pallets etc. can be maintained automatically on Consignment Lines. Packet Type Shortcuts can also be linked to Cost Codes to enable automatic order lines for charging costs for pallets etc.

If the Primary Contact No. on a Customer or Vendor did not exist as a Contact, it was not possible to create a Consignment linked directly to the Customer/Vendor

Weight and Volume was not calculated correctly on package spec lines if the setup was to calculate weight/volume from Source Document. This only caused a problem if the user opened the Package Specification Lines on such a consignment before sending it to LogTrade (not that likely to occur).

When using the Drop Down on Consignment Line to select Package Type all Package Types was shown in the RTC. This has been corrected so that only Package Types marked as “default” in LogTrade are shown (as in the Classic Client). To show also the Package Types that are not marked as default the user must choose “Advanced” to open the list of Package Types and remove the filter on “Default”. Please observe that the filter on Default does not work in 2009 RTC due to a platform bug.

Functions to call from Source Documents to query the Time Table (pick-up and delivery time)

Functions to call from Sales Order, Purchase Return Order and Service Order to calculate the freight price and have it inserted as a document line.

Function to call from Warehouse Shipment Line to create Consignment for the Source Document on the current Warehouse Shipment Line. This way it is possible to create consignments either for a Warehouse Shipment as a whole or for individual Source Documents on the Warehouse Shipment.

Test Mode per user in the User Setup. Filtering of consignments based on Test Mode Yes/No meaning that you can switch between production mode and test mode for a single user in your production environment to do testing, training etc.

This version supports 2013 R2 and are in many terms an RTC-release with a brand-new Role Center for LTC, fact boxes etc. Other big changes are the support for Warehouse Shipments and creating Consignments for already posted documents.

New functionality:

The XML file logging on the file system has been replaced with table-based logging and XML files stored as blobs.

There is now a Role Center for LogTrade Connect. Several pages have also been changed to include fact boxes with Consignment statistics. For the classic client statistics forms (F9) has been added. Some fields have been moved from the Consignment to the Consignment fact box.

LogTrade Connect now supports Warehouse Shipments. One or more Consignments can be linked to a Warehouse Shipment and there is also a function to automatically created all consignments necessary for a Warehouse Shipment. (Advanced Management)

To support Warehouse Shipments where several Source Documents for the same recipient can be treated at once it is now possible to link source documents to a Consignment. The consignment will have one “main document” and other source documents of the same type for the same recipient can be linked. Linking can be done manually, from a Warehouse Shipment or by using a function on the Consignment to find Source Documents for the same recipient to add as Linked Documents.

The 2013 version of LogTrade Connect now uses .Net for all web service communication, XML file handling etc. All COM variables and code has been replaced by .Net equivalents. This means that NAV Server can run the functionality in LogTrade Connect to use in situations with automation, handheld devices, web client etc.

The Setup Wizard will now suggest three User Roles for permissions. The roles are “Settings”, “Working with Consignments” and “Reader”. When importing defaultsetings.xml the import will create table permissions for the three roles.

If a consignment is sent to LogTrade with action “Save” and is later validated in the LogTrade GUI, the function that updates status on consignments in LogTrade Connect will now populate existing package lines with package number and create package tracking lines.

Declared Value and Declared Currency Code has been added to consignment.

Default settings on logtradeconnect.se/public are now version aware in that sense that every new release of LTC will suggest a different filename. Version 09 will suggest importing defaultsettings_09.xml. The existing defaultsettings.xml is for version 08.

There is a new setting in LogTrade Connect Setup called “Remove Country from Post Code” that if enabled will clear out Country Code (and any hyphen) used in the beginning of a post/zip code when sending post codes to LogTrade.

It is now possible to also use “Source Type”, “Source No.” and “Source Address Code” in the Split Point Setup which gives the possibility to link recipients to different split points within the same country.

It is now possible to define on a Split Point if the connected “children” shall inherit the sender address from the address source that is defined on the Split Point.

It was not possible to send Sender Address ID to LogTrade for Consignment linked to Sales Return Order or Purchase Order. This has been corrected.

It was not possible to enter Package Specifications Lines without first inserting a Consignment Line. This is corrected so that the consignment line is inserted automatically when the Package Specification lines are summarized to update the Consignment Line.

When sending email with external login or PDF URL for a consolidated consignment the e-mail addresses are now fetched from the consolidation consignment and the URL is for the consolidated consignment.

Consolidated consignments are no longer possible to modify or delete since all actions should be performed on the consolidation consignment.

Codeunit 12057538 “LogTrade Update Shpmt. Status” that is used for updating consignment status from LogTrade when a change has occurred in the LogTrade GUI mistakenly archived the consignment if the consignment e.g. had been saved in the GUI and then released. This has been corrected

Missing ML-captions has been added

A slight restructure has been done in the menu for settings for Shipping Agent Invoice import specifications

Source document lines can now be used to create Free Text lines for printout on certain documents.

It is now possible to send a link in an email for downloading PDF’s to e.g. the customer.

It is now possible to send a link in an email to the consignment to e.g. a vendor so that the vendor can use LogTrade to complete and send the consignment. This requires additional license in LogTrade.

It is now possible to send a link to the consignment to e.g. a vendor so that the vendor can use LogTrade to complete and send the consignment. This requires additional license in LogTrade.

If consignment is sent to LogTrade with status “New” and the consignment is completed and released in LogTrade web GUI the functionality that updates the status from LogTrade also can fetch package lines and tracking information from Control Tower.

If there was one (1) print queue defined in LogTrade on the LogTrade account used when running the LogTrade Setup Wizard in LogTrade Connect the settings from defaultsettings.xml was not stored in the LogTrade Setup Table. This has been corrected.

The lookup button in the toolbar did not work on released/archived consignments in the Classic Client. This has been corrected.

This version is from a user perspective mainly about services. The setup of default services and dynamic calculations of service parameter values makes it possible to automatically link services to consignments and calculate parameters for the services. This version also supports agent offices received from LogTrade through web services based on recipient address.

For a partner the setup wizard has been more streamlined and easier to use with file open dialogs, easier import of shipping agent mapping data etc.

New functionality:

It is now possible to specify more parameters for default services. It is now possible to use also these fields when setting up the prerequisites for a default parameter to be applied:
– Document Type
– Source Type
– Source No
– Address Code
The default services are also easier to work with since it now is Shipping Agent and Shipping Agent service that are used instead of Forwarder and product when setting up the default services.

It is now possible to setup generic service shortcuts for e.g. e-mail which is linked to all similar services in all products. It is also possible to setup default services on different combinations of Shipping Agent/-Service, Source Document Type, Source Document No., Source Type, Source No and Source Address Code. This way it is possible to setup that e.g. an e-mail advice service shall be used for a specific customer regardless of shipping agent/-service. It is also possible to use this default setup for specific documents so e.g. a salesperson gives instructions to be used by the yet not created consignment. On the shortcuts (inherited down to default services) it is possible to set if the service is mandatory or if the user can confirm a missing service. This way it is possible to setup mandatory services for e.g. a customer or that e.g. CashOnDelivery is mandatory.

It is now possible to look up a list of available Agent Offices in the field “Agent Office ID” on a consignment. The lookup triggers a web service request to LogTrade which returns the available agent offices based on the location of the recipient. It is also possible to display an agent office in Google Maps (or any other web-based map service accepting longitude and latitude as parameters).

It is now possible to setup default send action on individual forwarder products that will (if set) override the Default Send Action in LogTrade Setup.

This version introduces the Customs Invoice, a new setting for default Shipment Date on consignment and a new separate field for Sender Reference. Besides that, there are bug fixes and GUI enhancements.

New functionality:

Customs Invoice is now supported.
It is now possible to create a customs invoice linked to a consignment automatically (if there is a source document) or manually given that the recipients country code is not blank and not an EU country. The Customs Invoice is printed together with the other LogTrade documents.

The default shipment date can now be based on the source document.

Sender Reference now has its own field on the consignment instead of using Source Document No. This makes it possible to create consignments without using a source document where the Shipping Agent Service requires a sender reference (such as DHL Express). By default, the Source Document No. is used to populate the Sender Reference field.

Bookings is now supported. Bookings can be LogTrade controlled, Automatic on validation, Automatic on release or Manual. Booking can be done both from the Consignment Worksheet and from a Consignment. Please note that not all Shipping Agents support bookings.

This version introduces a new export/import which will make setup easier since the shipping agent mapping now can be exported/imported in the Setup Wizard. Besides that this version is mostly about corrections/adjustments in pages for 2009 RTC and 2013.

New functionality:

It is now possible to export and import the mapping table for forwarders/products and shipping agents/-services. Export can be done at any time, but import is only possible when Setup wizard has been launched and mapping lines created and before settings has been implemented. Once the wizard has been run it is no longer possible to import mapping. The import will only update existing mapping lines so it’s possible to have a generic mapping supporting all forwarders even though the customer does not have all these in the LogTrade License.

Print Queues are no longer maintained manually. In the print queue list, there is now a function to get Print Queues from LogTrade. Print Queues are also imported automatically when running the Setup Wizard and if there is only one print queue that print queue will automatically be set as default print queue in the setup.