2024.4.17.1748

4/17/2024 10:08 PM

Fixes

• Adding contact phone verification fails with Twilio exception

2024.4.16.1535

4/16/2024 10:08 PM

New

• Update nuget packages for changelog generator

2024.4.15.1904

4/16/2024 1:56 AM

New

• Update DTO for order details to use Item ExternalID if the detail externalID is empty to support ERP systems that need to match on their item ID. (netsuite, quickbooks)
• Publish event "Order Marked Reviewed" to message queue MQ so external consumers know when to retrieve orders

2024.4.13.2212

4/14/2024 3:13 AM

New

• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting

2024.3.27.2337

3/28/2024 1:00 PM

New

• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance

2024.3.23.1323

3/24/2024 1:23 PM

New

• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)

2024.3.19.117

3/19/2024 5:48 AM

Fixes

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs

2024.3.10.2330

3/11/2024 4:33 AM

Fixes

• APIlog method to update metadata should check the length of data before saving

New

• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast

2024.2.28.1856

2/29/2024 2:31 AM

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder

2024.2.19.1705

2/19/2024 10:53 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values

2024.4.16.1535

4/16/2024 10:08 PM

New

• Update nuget packages for changelog generator

2024.4.15.1904

4/16/2024 1:56 AM

New

• Update DTO for order details to use Item ExternalID if the detail externalID is empty to support ERP systems that need to match on their item ID. (netsuite, quickbooks)
• Publish event "Order Marked Reviewed" to message queue MQ so external consumers know when to retrieve orders

2024.4.13.2212

4/14/2024 3:13 AM

New

• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting

2024.3.27.2337

3/28/2024 1:00 PM

New

• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance

2024.3.23.1323

3/24/2024 1:23 PM

New

• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)

2024.3.19.117

3/19/2024 5:48 AM

Fixes

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs

2024.3.10.2330

3/11/2024 4:33 AM

Fixes

• APIlog method to update metadata should check the length of data before saving

New

• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast

2024.2.28.1856

2/29/2024 2:31 AM

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder

2024.2.19.1705

2/19/2024 10:53 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values

2024.4.16.1535

4/16/2024 10:08 PM

New

• Update nuget packages for changelog generator

2024.4.15.1904

4/16/2024 1:56 AM

New

• Update DTO for order details to use Item ExternalID if the detail externalID is empty to support ERP systems that need to match on their item ID. (netsuite, quickbooks)
• Publish event "Order Marked Reviewed" to message queue MQ so external consumers know when to retrieve orders

2024.4.13.2212

4/14/2024 3:13 AM

New

• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting

2024.3.27.2337

3/28/2024 1:00 PM

New

• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance

2024.3.23.1323

3/24/2024 1:23 PM

New

• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)

2024.3.19.117

3/19/2024 5:48 AM

Fixes

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs

2024.3.10.2330

3/11/2024 4:33 AM

Fixes

• APIlog method to update metadata should check the length of data before saving

New

• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast

2024.2.28.1856

2/29/2024 2:31 AM

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder

2024.2.19.1705

2/19/2024 10:53 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values

2024.4.16.1535

4/16/2024 10:08 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs
• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)
• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance
• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting
• Update DTO for order details to use Item ExternalID if the detail externalID is empty to support ERP systems that need to match on their item ID. (netsuite, quickbooks)
• Publish event "Order Marked Reviewed" to message queue MQ so external consumers know when to retrieve orders
• Update nuget packages for changelog generator

2024.4.15.1904

4/16/2024 1:56 AM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs
• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)
• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance
• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting
• Update DTO for order details to use Item ExternalID if the detail externalID is empty to support ERP systems that need to match on their item ID. (netsuite, quickbooks)
• Publish event "Order Marked Reviewed" to message queue MQ so external consumers know when to retrieve orders

2024.4.13.2212

4/14/2024 3:13 AM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs
• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)
• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance
• Add company configuration to allow custom URLs for PODs (company specfic URL generation)
• Update SMS order template to use short_url in template parameters
• Update job to create order from tank readings to handle situations where the last delivery qty was zero (rejected w tank full, zero delivered, etc.)
• Add route zone mapping to DM2 order import interface
• Add AlternateID column to items table to support kitting
• Add alternate ID and description (sold as ItemID and Desc) to DM2 API DTO to support kitting

2024.3.27.2337

3/28/2024 1:00 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs
• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)
• Add phone number validation properties to better validate SMS messages
• Add nightly background task to validate SMS phone numbers to avoid sending to invalid ones (e.g. landlines)
• Add validation for mobile phone on contact form
• Add admin table to track API performance

2024.3.23.1323

3/24/2024 1:23 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs
• Add API method to get customer assets - filtering by account # or customer name
• Add flag on orders to show when they are manually completed on the server versus a driver on the mobile app
• Update order and order details to use sequential unique IDs for better performance
• Update check installation script to check REDIS and RabbitMQ, if configured
• Update job to create recurring orders to use new config and include a depot filter
• When removing a CREDIT HOLD on a customer, mark all unrouted orders as ready to route.
• Use cache to manage API lookuptypes to improve performance (GetOrAddLookup)

2024.3.19.117

3/19/2024 5:48 AM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast
• automatically set "download to mobile" for uploaded "customer" photos and send *UTC dates for loads and orders to mobile
• Automatically mark a file attachment as "view on mobile" if the parent type is "customer"
• Include *UTC values from order and load entities when building a trip for downloading to the HHT
• Update job CreatOrderFromTankReadings to delete future order created by this job if the tank is removed from the VMI list (no longer vendor manage)
• When changing a tank from VMI to non-VMI, check and prompt user to delete future orders created by tank forecasting
• Allow negative values (pumpouts) for unit filling editing
• Allow editing net and gross directly even when there are unit filling details to accommodate gross differences
• Update order search to allow searching over a longer date range as long as the filter is specified and not
• Dm2 Job to create Sales Orders should update customers if the SO response is H for hold
• Add option in job to CreateRecurringOrders - to allow creating only for a filter on serviced by depot list of IDs

2024.3.10.2330

3/11/2024 4:33 AM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values
• APIlog method to update metadata should check the length of data before saving

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder
• Add OrderDate to the DM2 Create Sales Order job
• Tune job to CreateOrdersFromTankReadings to use last actual or calculated reading as the current qty, and tune for accuracy
• Add credit hold filter to tank list and customer list
• Tank list should show estimated current qty for tanks that do not have monitors but are forecast

2024.2.28.1856

2/29/2024 2:31 AM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values

New

• GZip apilog request and response data to more efficiently store and view
• Scheduled job to create orders from tank readings should have a config setting to disable creating orders for credit hold customers
• Add option to filter tank list by account number
• Add credit hold status to order well in RouteBuilder

2024.2.19.1705

2/19/2024 10:53 PM

Fixes

• Fix: correct a typo in the dto3PLexternal.EtaUpdateTrip class
• Activity eta does not update with the rest of atrip's stops
• PODData.PostOrder can fail if orderdate and deliveryscheduleddatetime are not valid values

2024.2.17.2311

2/18/2024 4:38 AM

New

• Scheduled job that update K-Factors and generates orders should email dispatch for all tanks that have k-factors updated
• Add option in OrtecV3 interface to NOT rollup realizations by actionID so driver added lines flow through to OIR. ( default is as is, rolling up by actionID)
• Order detail edit form should allow for negative order qty and gross/net to support pickup or pumpout orders.
• Update scheduled job that creates orders from tank reading to update any future orders with the revised qty and ETA based on delivery history
• Add delivery type to customers to enable flltering in RouteBuilder....AM/PM, short truck, etc.
• Performance tuning for RouteBuilder to search and calc time and distance faster
• Update scheduled job that creates orders from tank readings to also run the update tank metrics process

2024.2.15.1821

2/16/2024 12:16 AM

New

• Update DM2 processor to emit currently processing tenantID and use caching
• Add option to copy all assets from one customer to another (in company tasks)

2024.2.13.2324

2/14/2024 4:45 AM

New

• Add tuning index to order list
• Restrict date range for order search to 60 day windows for performance
• Limit max page size to 500 in standard list control to limit the number of records a single user can fetch (in batches)
• Scheduled job to create orders from tank reading (telemetry, delivery, etc.) should ONLY create if the customer is active
• Show and filter by Order Source in RouteBuilder
• Sort GetOrdersToExport_MarkedReviewed as ascending for all line numbers
• Prevent adding orders directly to a trip if the customer is on credit hold or is inactive

2024.2.12.2338

2/13/2024 4:58 AM

Fixes

• Posting orders created in the field does not update trip server version
• Order delivery window not getting set correctly in PODData API
• Routebuilder shows trip does not have a depot assigned when calculating time and dist. when it is assigned

2024.2.12.1137

2/12/2024 6:46 PM

Fixes

• Routebuilder launches and shows an empty dialog of "routing issues"
• Route builder is erroneously displaying a "Trip not assigned to a depot" message when route builder is opened or trips are searched

2024.2.11.2339

2/12/2024 5:02 AM

Fixes

• Routebuilder launches and shows an empty dialog of "routing issues"

2024.2.11.2249

2/12/2024 4:14 AM

Fixes

• Order details that are auto-split on the mobile should have their orderqty set to zero, not the original line# qty

New

• Add internal API method to get pick tickets for a list of trips - to display in the new web UI
• Add scheduled job to allow reposting Ortec OIRv3 and BigDataPortal messages

2024.2.9.1929

2/10/2024 12:51 AM

Fixes

• Order details that are auto-split on the mobile should have their orderqty set to zero, not the original line# qty

New

• Add internal API method to get pick tickets for a list of trips - to display in the new web UI

2024.2.7.2115

2/8/2024 2:50 AM

Fixes

• Routebuilder can throw an error if a truck profile is not setup or service times are not set for customer ship-to

New

• API3PLexternal AddUpdateTrip and ImportCSV for users should set the usertoken when adding external users

2024.2.5.1843

2/6/2024 3:03 AM

New

• Scheduled job to create Sales Orders in NetSuite should skip orders that fail and continue processing the batch
• Customer edit form should allow longer form entry in the notes field
• Update nightly job that purges orphaned orders/loads/trips to email the company system admin with the details
• Add environmental certification expiration date on tanks to allow for tracking and preventing order generation/routing if expired
• Add User Capabilities (ex. CDL license, hazmat certs,etc.) to track per user for routing eligibility
• Add Is Routable to order well in RouteBuilder to show if on credit hold or order is route ready is not checked
• Add tank forecasting method filter to tank list (manual, machine learning, degree day, ...)
• Performance tune the nightly job to purge gpseventlogs and audits
• Update job to create orders from tank readings to better calc degree day utilization
• Create trip form should enforce planned vehicle existing so dispatch has to route VALID trucks vs temp trucks or mistakenly typed ones
• Marking a customer inactive in customer edit for will prompt and mark all their assets inactive
• Update AdHoc view for orders to include additional driver info (full name, external ID)

2024.1.26.1708

1/26/2024 10:27 PM

Fixes

• Error loading customer edit due to recurrence date.

2024.1.26.1259

1/26/2024 6:25 PM

Fixes

• Config setting to adjust line numbers if set to zero can fail to post an order the order does not have any lines
• Recurrence control saves but does not show future recurrence dates for the start date

2024.1.25.2343

1/26/2024 5:04 AM

Fixes

• Integration to post activities to OIRv3 should check to confirm posted activities have the RTD set. If not, increment the RTA.
• Order reconciliation can fail as a background task but run correctly when run interactively. (should use background save process)

New

• Nightly job to get all orgs should exclude logo fields for better performance
• Add scheduled job that enables reposting a single order realization to Ortec B2B

2024.1.24.2232

1/25/2024 3:53 AM

Fixes

• Job to repost trips start/finish should look for different end trip message of "trip_finish"
• Load trip order reconciliation tab causes exception if an order is not posted

New

• Update job to export DM2 orders with an option to export batches by trip
• Update DM2 order export job to group by line number to ensure lines splits (e.g. split BOL when handling as invoices) are kept together
• Add job to create DM2 Sales Orders from MobileHub orders
• Update nightly job to purge unused work item messages from the message Q if older than 7 days
• CreateOrders from Tank Readings job should list all K-factor updates in a CSV in job args to easily tell what is updated or skipped
• Update nightly job to purge audits to delete via view for better performance and expand the runtime window
• Scheduled job to create tank orders should check if customer is on credit hold and set the order "ready to route" = false to prevent routing
• Tune job to purge GPS event log to use view for delete performance tuning

2024.1.19.1907

1/20/2024 3:07 AM

Fixes

• RouteBuilder trip scheduled start time includes the UTC offset but should convert to local time.

New

• Update PODData AddUpdateTrip delivery window handling
• Update audit feature for each time order reconciliation is invoked
• Add scheduled job to enable reposting to Ortec BigDataPortal by trip start date
• add entity PK to object_view and object_change audit records
• Add scheduled job to requeue trip start and trip end through integration based on message queue entries
• Scheduled job to create orders from tank readings should skip if a customer is marked inactive
• Add externalID as list of customer fields to import via CSV import
• RouteBuilder create trip dialog should include trip start time to allow a specific time override from the company default
• Add tuning index to inventory history

2024.1.4.1820

1/5/2024 3:36 AM

New

• Update job to create orders from tank readings to optionally update the k-factor based on the last delivery (rolling k-factor updates based on usage)
• Update DM2 requests to use sequential GUID (time sortable)
• Add system job to clean up DM2 requests on nightly schedule
• Update messageQ and audits to use sequential GUIDs for better performance
• Update inventory history and txns for sequential GUIDs for performance

2023.12.26.2213

12/27/2023 4:59 AM

Fixes

• api3PL Post Order does not set the order status to "delivered"

New

• Update auditing of recurrence patterns to show on the parent entity (e.g. order, trip)
• RouteBuilder should allow selecting multiple route zones when filtering orders
• Show asset audits for attributes on the asset (attributes=vehicle, trailer, tank, equipment)
• Update interface to Mansfield Energy to export orders based on account number versus name
• Add nightly task to remove expired webhook calls
• Update dataportal save audit to use JSON vs XML for space saving and compression
• Update dataportal audit save to use sequential guid for performance

2023.12.10.2210

12/11/2023 3:30 AM

Fixes

• For driver added items, if value is not set then set to the delivered qty
• When driver "delivers as ordered" if the line total is not set, then set the value to qty * price

New

• Add option to convert asset type (e.g. tank to vehicle, vehicle to equipment, etc.) on the Asset Edit form

2023.12.1.1854

12/3/2023 2:08 PM

Fixes

• Geocode API should only auto-apply and update if address confidence is greater than 90%

2023.11.30.2027

12/1/2023 1:59 AM

Fixes

• Launching Geocode form from customer edit can fail on the second attempt if there is invalid data in the shipto.address2 field

New

• Require a quantity for all order line items when creating or updating an order
• Add company config option to require a price on all order lines ( some ERP systems like NetSuite cannot create Sales Orders with zero price lines)

2023.11.27.2230

11/28/2023 4:13 AM

New

• Update PostOrder APILog to remove the signature image for better storage efficiency in logging
• Add the ExternalID field to the data import tool for Products
• Add company config option to renumber driver added line items with the next line # vs always being listed as line # zero
• Build a load in trips should filter terminal by supplier if an association is setup for terminal-supplier
• Update Customer Contacts API to make firstname optional, and required email or phone (not both)
• Show driver name in available columns for order list
• Add reconciliation config option to skip reconciliation for a list of depots (use to reconcile all but skip and not mark orders from these depots as reviewed)
• For company config where orders require a Sales Order from an external ERP system, do not export unless the order.externalID is populated (should be SO ref #)
• Add company config to specify account numbers to round to the nearest decimal. (certain accts such as Shell and Exxon master accounts require rounding to whole numbers)

2023.11.20.930

11/20/2023 3:40 PM

Fixes

• Opening audit log viewer shows errors with data type mismatch (combo box for user vs text box)
• RouteBuilder showed load times in UTC versus localtime

New

• add customer priority and order delivery window open/close to mobile order in PODData mobile API
• Update PODData public API to accept order priority and delivery window
• Update APIdocs to show how to use PODData AddUpdateTripsNoGuids for logistics system integration
• add API Logging for api3PL.EndTrip
• Performance tuning - remove unused indexes in db
• Add new order reconciliation option (off by default) "correct data gaps in meter totalizers"
• API Log should minify JSON requests and responses for space efficiency
• Show all RouteBuilder times in localtime and streamline the time format for each area (load, order, trip) for consistency and real-estate

2023.11.14.1458

11/14/2023 8:26 PM

New

• Extend the length of DriverNotes on activities and LineNotes on order details

2023.11.14.1009

11/14/2023 3:43 PM

Fixes

• RouteBuilder shows orders as not geocoded when adding to a trip (drag-drop or add from map)

2023.11.13.1853

11/14/2023 2:55 AM

Fixes

• PostedForm handler should return OK if a form comes in as null or empty (to avoid continued mobile retries)

2023.11.12.033

11/12/2023 5:47 AM

Fixes

• Background job NotifyUserWhenTripAssignedToThem fails if a driver is removed from a trip after the message is queued
• If invalid form is posted from mobile, return error status and message but do not throw exception because the form will continue to attempt reposting in error
• Routebuilder can show a concurrency issue when selecting and adding multiple orders from the map to a trip

New

• Tune API Log for Ortec B2B Trip ETA updates to store a minified dataset for improved size and searching
• add "2 phase" start trip to api3PL Mobile API
• Tune logging API calls from webhooks to reduce the payload size where possible (in the log for AddUpdateTrips)

2023.11.9.152

11/9/2023 7:13 AM

Fixes

• Background job NotifyUserWhenTripAssignedToThem fails if a driver is removed from a trip after the message is queued
• If invalid form is posted from mobile, return error status and message but do not throw exception because the form will continue to attempt reposting in error

New

• Tune API Log for Ortec B2B Trip ETA updates to store a minified dataset for improved size and searching

2023.11.7.840

11/7/2023 1:59 PM

New

• Add company config to toggle if geofence arrive/depart should be calculated

2023.11.6.2105

11/7/2023 2:21 AM

New

• DM2 Export to GenerateInvoices should have an option to use the truck code for the warehouse code (when trucks are warehouses)

2023.11.6.1045

11/6/2023 4:42 PM

New

• Add job PreDeliveryNotificationWeekBefore to send Mon orders on prior Thu, and Tue-Fri the prior Fri
• In data import tool, add new field 'IsExternalUser' to map 3PL drivers as users

2023.11.5.1803

11/5/2023 11:21 PM

Fixes

• API 3PL external AddUpdateOrders can duplicate order type lookups if there is already more than 1 of the same type

New

• Add tuning index to MessageQ table

2023.11.5.1555

11/5/2023 9:27 PM

Fixes

• Order controller that generates POD_URL should use a flag to determine if it should use the format (lightning vs webapi)

2023.11.2.2331

11/5/2023 4:18 AM

Fixes

• Ortec OB2B should skip updating contacts if key data(email, contact name) are not present

2023.11.2.2228

11/3/2023 2:51 AM

Fixes

• Customer terminal map should filter vendors by tenantID.
• Process MessageQ job can raise an error when searching for orders that have been updated/deleted since the job is queued and does not set the correct # of retries

2023.11.1.1902

11/2/2023 2:35 AM

Fixes

• Tune query to get the tripID from a GPS log to reduce concurrency (only return tripID)
• R217 trip summary by depot report reversed the ETA and ETD fields.
• Issue with driver manually initiating OTW (on the way) messages if driver assignment is removed (ex. order unrouted)
• POD API does not update existing tank data on trip update

New

• Update job to send customer portal orders to NetSuite as Sales Orders (for approval)
• Load builder should set the load ETA to just before the first order associated with the load (vs 1 hour before).
• Add time-sortable unique identifiers for APIlogs (for performance)
• Add time-sortable UUID for mobile APIs for audits and gpsevents (performance tuning)
• Scheduled job to export orders to DM2 should add an option to send all orders to GenerateInvoices, including fuel orders (if not tracking BOLs)
• DM2 ImportOrders process should convert to the tenant's timezone

2023.10.26.1826

10/26/2023 10:49 PM

New

• Add web config to set max hour to run debug audits across tenants

2023.10.25.2131

10/26/2023 1:54 AM

Fixes

• Notify driver trip assignment SMS message can fail when not checking for order info values

New

• Add savable fields to PODData AddUpdateTripNoGuids API
• Add db tuning indexes
• When saving an order and queueing the message "order_marked_reviewed", it should only send the message if the status = reviewed, not when unchecked
• Tune nightly process for purging audits to use configurable batches
• Add last delivered productID to the list of available import fields mapped to all assets (not just tanks)

2023.10.19.2306

10/20/2023 3:31 AM

Fixes

• Update RouteBuilder concurrency check - when creating a new trip you can receive a 'trip has been updated by someone else'

New

• Tune the process for deleting audits across all tenants for audit maintenance

2023.10.17.1907

10/18/2023 1:13 AM

Fixes

• Removing an order from a trip in RouteBuilder can occasionally result in a concurrency issue (someone else changed the trip)

New

• RouteBuilder trip sequencer should keep the selected order highlighted when moving up or down in the sequence (for easier use)

2023.10.16.2212

10/17/2023 2:36 AM

Fixes

• Attempting to send trip planned message via Rabbit MQ throws an exception
• RaptorApi.GetMessageTemplates is returning part of the template file name in the language property

New

• Add trip performance tuning index
• Log apicall for AddUpdateOrders if there is a validation result error
• 3PL Trip should be unstarted if there is an error starting it
• Order form should optimize the query for shipvia
• Remove unused database indexes based on production profile (performance tuning update)
• Add BillName in customer list
• Add order status in order list
• API to AddUpdateOrdersWithoutTrips, when line numbers are not sent in default to zero and does not remove duplicate lines based on itemID
• Show order sequence # in RouteBuilder and Trip optimizer

2023.10.10.2322

10/11/2023 3:58 AM

New

• APILog viewer should default to searching across all fields for quicker and easier searching

2023.10.10.1850

10/10/2023 11:13 PM

Fixes

• Routebuilder does not show a trip on the map if the trip's truck or trailer does not have a max capacity set

New

• Add UnstartTrip method to API3PL so workflows are 3PL specific
• Add stop sequence number to 3PL mobile order DTO

2023.10.9.1851

10/10/2023 12:38 AM

Fixes

• Routebuilder should calculate volume based on package size to accommodate package and bulk

New

• Order edit should always make order qty = piece count and not calculate qty for package items (e.g. drums, cases)

2023.10.8.912

10/8/2023 1:35 PM

Fixes

• Reject order/activity/loads in api3pl do not populate StartTimeUtc and EndTimeUtc fields

New

• Log message queue item when an order is posted and marked reviewed so it is available to send to external systems
• Add scheduled job to send/export Mansfield orders to the Mansfield D1 notification system
• Add list control to show orders generated in customer_portal or tank_forecasting. Enable sending to ERP for approval
• Add field to order table - approval requested date - to support sending to ERP systems for approval

2023.10.4.1711

10/4/2023 9:54 PM

Fixes

• 3PL Order DTO not getting customer geocode
• Repost Order job should repost based on the integration method vs always using PODDdata
• OB2B integrator not updating server version when orders or activities are removed from a trip in progress
• OB2B integrator not deserializing "Commitment" property from custom order line
• OB2B integrator not correctly recognizing all possible positive "redelivery" values
• OB2B integrator not correctly handling picked and substituted products in custom order line
• Delivery window not set for new customers can cause issues loading a customer edit form
• RouteBuilder should calculate volume on trips and not include service items
• OrtecB2B interface throws exception on removing rejected orders (custom processing). Error Collection Modified.
• PODData.GetTripEtas does not return the correct localized ETA for orders and loads

New

• Add TimezoneID to customer and depot to allow messages in customer's timezone
• Add scheduled job to notify users of upcoming trip assignments within the next xx hours
• Add internal webhook service to allow sending events from goRoam.MobileHub (Lightning) to MobileHub classic
• Ortec B2B integration should resend the StartOrder event along with the PostOrder when reposting an order
• Scheduled job to RepostOrders through MobileHub can set start time incorrectly if using Ortec B2B
• Don't updated order detail loaded qty if the value passed is null
• update customer import to populate routezone, serviced by depot, market, submarket, delivery point
• Update GetOrdersForExport_MarkedReviewed to return loaded qty
• Add FleetFueling ad hoc query
• Update DM2 interface to allow importing and adjusting order instructions in an optional custom handler
• Show trip volume and weight in RouteBuilde. When selecting or updating a trip, update volume/weight
• RepostOrdersThroughMobileHub job should have a way to not invoke the "StartOrder" if the order was previously started and the integration is with OB2B
• Add start/end time to request/response for each APIlog entry
• Log APIcall for Api3PL for PostOrder, PosteLoad, PostAudit to enable capturing api call duration
• Log APIcall for RejectOrder
• RouteBuilder should show if a trip is over weight or over volume when adding orders to a trip (capacity and vol set on truck attributes/compartments)
• Create recurring trips job should assign the actual truck and trailer ID (internal values) when creating a trip
• API 3PLexternal should cache item list from all orders in trip when AddUpdateTrip is called - for performance tuning
• API3PLexternal AddUpdateTripCustomer should only update customers no more frequently than every 12 hours (for performance)
• API3PLexternal AddUpdateTrip should only add depot, not update if it already exists
• Add tank asset reference to order detail to support line items for specific assets
• Add POD API methods to return the original loaded quantities for a BOL
• Add control to view and set timezone for each customer (ship-to) to support notifications in customer's timezone
• Add company level settings for the time window in which to send SMS and WhatsApp so message do not go out in the middle of the night. Use customer timezone if available
• Add API support for pre-assigning a tank to be filled on an order line
• Allow editing tripcode in RouteBuilder on Create Trip - to support tripcodes from external systems

2023.9.5.1808

9/5/2023 10:40 PM

Fixes

• Generate SMS message to customer for order scheduled was not called - used email but should generate SMS
• Scheduled Job - Repost Orders to MobileHub should account for max retries and cases where orders do not have an assigned driver
• API Log list does not correctly filter on correlation ID when value is null
• 3PL order rejection does not clear RTA fields on order
• RouteBuilder tab to exclude a list of products did not have scrollbars set correctly
• api3PL.GetTripUpdates does not return delivered quantities
• api3pl.GetTripUpdates returns zero for delivered qty when nulll is expected

New

• Add time and distance to customer-terminal setup so both can be included in trip calculations
• Update trip schedule and order departed depot notifications to include date formatting helpers (short date, nearest hour)
• Add externalID to activity entities to allow easier mapping to outside keys
• Add order sequenceNum to the API to get posted orders (batch export API)
• Set order completion sequence number when posting orders via mobile
• Enforce only allowing trips to start within +/- hours of the preference 3PL_HOURS_WINDOW_TO_START_TRIP so drivers cannot start trips in the future (or past)

2023.8.23.1938

8/24/2023 12:48 AM

New

• Add geofence arrive and depart to trip depots
• Add loaded_qty to API3PLexternal.AddUpdateTrips to allow recording loaded qty for each detail coming from external systems
• Add 3PL Api method to set the pre-trip odometer separately from trip start
• Update Ortec B2B .barcode mapping on order import
• Add notifications to customer when trip starts - orders out for delivery (email, SMS, WhatsApp)
• add customer notification when an order is scheduled via an API (external routing system)
• Increase length of tripcode to 100 chars to support longer codes
• return trip activities in api3PL find trips mobile API method
• Update customer - terminal mapping to allow easier customer searching
• Add filters for vendors and terminals in vendor-terminal-customer setup for easier finding/filtering
• update system.threading references to the latest version
• add support for ETA updates in 3PL mobile API
• Update scheduled job to export order PDFs to FTP to use SFTP
• Add company config to allow for custom pre-processor for import order list DTO's (to allow transforming incoming DTO's before processing)
• Update driver trip assignment to HTML email and include order line items

2023.7.30.1251

7/30/2023 5:26 PM

Fixes

• RouteBuilder - dispatch trips function skips the last trip and does not show in the selection dialog
• Ortec B2B interface is not sending the correct GPS breadcrumb event date

New

• Add externalID field to order detail to allow mapping to line#'s or identifiers that may be strings
• Add publicOrderShowTruckLocation company config
• Add tuning index to scheduled job history
• Add freezer and cooler temps to orderinfo to support food deliveries
• Add order section to extra_custom/shuttle section on shuttle delivery orders
• Add freezer and cooler temps to 3PL API
• Save line item exceptions when orders are posted via 3PL private API
• Add warehouse_code filter to DM2 process to import orders "ready to route"
• Add MQ events registrations for start trip and complete order
• Add geofence radius to depot to support geofence arrive/depart
• Update DM2 interface to not update customer name on order import (allows updates in MobileHub to remain and not be overwritten)

2023.7.12.2152

7/13/2023 2:27 AM

New

• Add option to dispatch trip notifications to users and WM modules in RouteBuilder
• Add loaded item to order detail to accommodate substituted items from loading
• Add 1 hour timeout for select background jobs that run once per minute (hangfire - to auto-delete succeeded)
• Save line comments from driver on 3pl based applications
• Add 1 hour timeout on PostGPS job to delete when successful
• Update OrtecB2B API schema for custom fields
• Updated job to create recurring trips to show the trip template upon which the recurrence is created
• Extend length of pre/post trip external actionIDs to accept more descriptive data (ex. route+guid)
• Add correlationID to the ApiLog to enable tracking multiple messages to a single entity (e.g. trip, order, load)
• update DM2 interface to allow spaces in shipvia (this allows RTR ready to route) to show up as the first shipvia in DM2

2023.7.9.1337

7/10/2023 2:43 AM

New

• Add option to dispatch trip notifications to users and WM modules in RouteBuilder
• Add loaded item to order detail to accommodate substituted items from loading
• Add 1 hour timeout for select background jobs that run once per minute (hangfire - to auto-delete succeeded)

2023.6.30.822

6/30/2023 12:48 PM

Fixes

• Mobile Forms Question editor doesn't populate IsRequired correctly
• Completed orders can be rejected
• Update NetSuite export JSON serializer to include null values

New

• Update R0045_DeliveryReceipt_P49
• Optionally retrieve started orders/loads/activities with the api3pl.GetTripUpdates endpoint
• Scheduled job to create recurring orders should use better defaults to determine if a line should be created to avoid adding driver-added lines
• Capture line notes from the mobile app for each order detail
• DM2 order import should trim the ShipVia filter in order to support filters with spaces
• Update SQL script to create adhoc export views to comply with versions prior to SQL 2016
• Update OrtecB2B interface to handle pickup orders

2023.6.27.907

6/27/2023 7:51 PM

Fixes

• Mobile Forms Question editor doesn't populate IsRequired correctly

New

• Update R0045_DeliveryReceipt_P49
• Optionally retrieve started orders/loads/activities with the api3pl.GetTripUpdates endpoint
• Scheduled job to create recurring orders should use better defaults to determine if a line should be created to avoid adding driver-added lines
• Capture line notes from the mobile app for each order detail
• DM2 order import should trim the ShipVia filter in order to support filters with spaces

2023.6.18.1834

6/18/2023 10:58 PM

Fixes

• private 3PL Order dto doesn't have a customerrefid column
• Import customer CSV skipped importing the field ContactName

New

• Add/update realizations for OrtecB2B (start/end trip, start/end/cancel order, gps)
• Add scheduled job to export order PDFs by date range and account number to FTP
• Add start and stop totalizer values to the trip audit XLS for inventory transactions (e.g. FLUSH, CLEAR, PUMPOUT)
• Update API external method GetOrdersToExport_MarkedReviewed to include optional order_no field to pull for specific orders
• Add flags to order detail for isRedelivery,isCommitment, and isSubcription.
• Add child table to order details to capture delivery exceptions per line item
• Update api3PL.PostOrder to accommodate food service line item properties
• Add item_barcode, line_barcode, unit_weight, unit_vol, and loaded_qty to the API3PLexternal to AddUpdateOrders - to support 3PL line deliveries
• Rename isRelivery to isRedelivery on orderdetail
• Add pre/post trip actionID to the trip edit form - use these for external routing system's keys for start/end trip activities
• Add routezone to order to allow grouping by planning zone
• Add performance tuning index to audit table for nightly maintenance (remove old audits)

2023.5.30.1356

5/31/2023 1:41 AM

New

• Break out reconciliation process to improve testability

2023.5.26.1829

5/26/2023 10:55 PM

New

• Add views to export master data (suppliers, tanks, etc) for easier transfer between Mobilehub environments (test->prod)
• Add tuning to nightly jobs to purge apilogs and debug audits
• Add table to support webhooks logging
• Add API support for order sequence number when receiving routes from external systems
• Add API support for order detail to include unit_weight when receiving routes from external systems
• Add API key list and add/edit/delete keys to use for external programmatic access to MobileHub
• Add initial setup job to register Ortec B2B (Finished Goods Logistics) to register our webhooks
• Update Restsharp to the latest version - note that has breaking changes - all webservice calls were updated to fix known issues

2023.5.13.1047

5/14/2023 3:59 AM

Fixes

• FuelOrderDetail.UserEntered not being set correctly when orders are posted from mobile POD
• API to get message templates did not handle ASN's that contained an underscore.
• Job to create recurring orders always appends customer notes - should only append if they are not already applied

New

• Utilize should send otw notifications company config with ETA notifications
• Update resend failed shuttle start order and post order messages to use OrtecORD3PL
• Update scheduled job to get DM2 ShipToInfo to include UDF field for driver instructions
• Update Ortec OIR and OIRv3 interface to auto-log all API calls except GPS
• Add relationship to items table for order detail delivered item
• Add customer to the order entity for the SMS_OTW (on the way) template so Customer variable are available in the template
• Update 3pl mobile API to support food service and loaded vs ordered items
• Add config for requiring mobile user to change password on first app login
• Update format for OTW notification to be "Mon May 1, 10:01AM EST" to make it clear for customers the day of the week
• Add API to get all message templates so they can be easily added/edited in customization for the goRoam web app
• Use existing methods for locating email templates for OTW notifications
• Add scheduled job to auto-add Petro Data Sync (PDS) email so order PODs will always be copied to PDS document manager
• Add Post Start item task calls to 3plExternal api
• Add API method so external systems can generate a MobileHub admin email for cases where external apps need to notify MH
• Add default french and spanish templates for ASN, OTW, POD customer messages
• Add menu item to remove fuel load detail on load form
• Default sort on unit filling should be start time versus assetID, in order to show them chronologically

2023.4.24.1834

4/24/2023 10:59 PM

Fixes

• Add check for OTW notifications to only send one time to each contact (except for driver initiated)

New

• Update jobstodelete text file for jobs that are no longer used and can be purged via the batch script
• Move option to send OTW notifications to company config to more easily manage in a central location

2023.4.23.739

4/23/2023 12:59 PM

Fixes

• Update TripEntity's method of determining if delivery is out of sequence
• CreateRecurringOrders can create additional orders when using the relative schedule (every XX days)
• FuelOrderDetail PkgDesc is not populated from product PackageType when item is assigned to detail
• Recurring Trip scheduled job does not work correctly when using repeat every XX days
• Refactor post item start tasks to work with Hangfire
• Check HERE geocoder for bad gateway and gracefully handle the error

New

• Create on time variance company config
• Add RabbitMQ hooks to publish/subscribe to message queues
• Add hook to publish OrderRoute updates (trip assignment updates) to RabbitMQ
• Add option to have different POD receipts by depot. This is email only, not mobile receipts.
• Set 24 hour TTL on RabbitMQ exchange for order assignment to trips
• Update DM2 interface to GetTankData for receiving driver instructions on a per ship-to basis.
• Update DM2 API interface to use AddTruckActvity to send fuel orders with BOLs to DM2 for invoicing (replace GenerateBOLs)
• Upgrade SFTP client to the latest version to support the latest encryption protocols
• Upgrade to MobileHub controls to v22.5 on DevExpress
• Break out reconciliation process to improve testability
• Add Report R244 Customer Assets (filtered by depot)
• Add Mobile API method to generate driver initiated "on the way" message
• Scheduled job to CreateRecurringTrips needs additional logic checks on recurrence pattern 'every XX days'
• Add system job to handle sending driver initiated OTW (on the way) notifications
• Update PostForm to include a reference to the form definition for reporting
• Update FuelOrderDetails Ad Hoc view to include package type
• Add tuning indexes for trip metrics
• Update api3plExternal.UpdateTripEta to schedule ETA notifications
• Cancel undelivered ETA notifications for voided orders
• Create remove ETA notification on ETA Notification manager
• Refactor PostStartItem classes for testability
• Add SMS and WhatsApp recipients for Eta notifications
• Don't use customer.email for ETA notification recipients.
• Create company config defining which on the way notification method to use
• Use otw method config to determine if ETA notifications should be sent
• Refactor post item start tasks to work with Hangfire
• Refactor apiExternal.UpdateTripEtas to a component
• Create company config that enables/disables MobileHub ETA updating
• Don't update ETAs if the enable update etas by mobilehub config is disabled
• Create job to re-send DHL Shuttle StartOrder and PostOrder messages to ORD
• For DM2 interface, add option to import multiple order statuses (ex. N, O)
• Add ScheduledSendDate to the MessageQueue list and edit form to support showing notifications scheduled times
• Update job that sends customer POD to allow adding extra emails from the web client - send to existing contacts plus dynamic ones added when resending PODs from the web
• Add checkbox filter on schedule job list to only show enabled jobs
• Update OIRv3 to take full unit filling list from posted order
• Update DM2 order export to handle order types other than fuel and lube to generate invoices

2023.3.19.1631

3/19/2023 8:46 PM

New

• Create on time variance company config
• Add RabbitMQ hooks to publish/subscribe to message queues
• Add hook to publish OrderRoute updates (trip assignment updates) to RabbitMQ
• Add option to have different POD receipts by depot. This is email only, not mobile receipts.

2023.3.13.1836

3/13/2023 10:50 PM

Fixes

• Error sending trip end with inventory email

New

• Add schedule job to email forms when there is an email list
• Add schedule job to email forms when there is an email list
• Add user filter on audit list to include disabled users
• Ka 1907 add user filter on audit list to include disabled users
• Add order or pick ticket barcode to R215 Pick Ticket report so external picking systems can scan the pick ticket

2023.3.8.2215

3/9/2023 3:28 AM

New

• Add product info for retained products when getting pre-trip inventory
• Add DM2 config option to apply terms to order delivery instructions (ex. terms-01, instructions - PLEASE COLLECT CHECK)
• Add DM2 Import job to pull DeliveryNotes from ShipInfo and apply to customers and orders
• Increase length of tankshape in tank readings table
• When using integrated AD authentication, log the last logon time for the user

TripReconciliation

3/8/2023 2:04 PM

Fixes

• ReferenceData service not populating UseAllCalibrations property of DTO

New

• Add R0045_DeliveryReceiptP49 and HomeHeat to mirror the mobile receipt from LCR printers for PODs
• Add priority to orders to enable filtering by priority level
• Add priority to RouteBuilder unrouted order filter
• Add priority to customers (ship to)

2023.3.2.2045

3/3/2023 1:54 AM

Fixes

• ReferenceData service not populating UseAllCalibrations property of DTO

New

• Add R0045_DeliveryReceiptP49 and HomeHeat to mirror the mobile receipt from LCR printers for PODs

2023.2.26.1409

2/26/2023 7:54 PM

Fixes

• RouteBuilder should display the order's serviced by depot by default, and fall back to the customer's depot if the order is not assigned to a depot
• Geocode form does not increment when there is more than one result (shows all at ID #1)

New

• Add user filter on audit list to include disabled users
• Force company config serverURL for customer emails and mobilehub to use https if URL is a .COM (allow http: for internal addresses)
• Update fuel load detail screen to show net and gross loaded quantities
• Add a new email notification to confirm for the customer that a delivery has been made and details will be sent later
• Return vehicle tags with trip in the api3PL GetFirstAvailableTrip method
• Implement time based driver on the way notifications
• Add IsDeliveredInSequence property to trip entity
• add last product filled to centeron tank monitor import job export spreadsheet
• Update SaaS Terms of Service target uptime to 99.5%

2023.2.24.1813

2/25/2023 5:24 PM

Fixes

• Otodata tank import is interpreting the value incorrectly
• Fuel Load Detail list on fuel load page shows zero product loaded
• Add tuning index on message queue table to find customer email notifications faster (avoid timeouts on order reject)

New

• Ka 1907 add user filter on audit list to include disabled users
• Add schedule job to email forms when there is an email list
• Add Last Sensor Fill Percentage to the VMI Tank Info list

2023.2.19.1624

2/19/2023 11:18 PM

New

• Revise target .NET framework to 4.6.2
• Add schedule job to email forms when there is an email list
• Amazon S3 file provider can take a long time searching for file versions (which are no longer supported) - remove version check for performance
• Updated Windows UNC file provider to improve performance when searching for files
• Optimize save pipeline when rejecting orders to log events outside of the order processing (optimization/perf tuning)
• Update POD API's to accommodate Gross and Net loaded quantities
• Add degree day history table
• Add degree day stationID and KFactor as CSV import option for tank imports
• Add net qty delivered on loads as an export field in the API3PLexternal method to export loads
• Add degree day as a tank forecasting option for order generation
• Add EmployeeID and ShipVia to API external GetOrders to support driver and employee matching, and shipping provider
• Add grossQty on order detail export for API external calls to export orders

2023.2.14.1450

2/14/2023 10:20 PM

New

• Revise target .NET framework to 4.6.2
• Add schedule job to email forms when there is an email list

2023.2.14.1139

2/14/2023 4:52 PM

Fixes

• Update process to generate changelog to set last release date

2023.2.13.1905

2/14/2023 2:39 AM

New

• Add DeliveredItemRefId to FuelOrderDetail
• Add job to export all relevant analytics data to SQL Server for external reporting - continuously update data with changes
• Update FluentMigrator to latest version - includes binding redirects for prior versions
• In RouteBuilder, add option to print all pick tickets for a given depot
• Update MobileHub to use .NET 4.7.2 runtime
• Update DAL to add QtyToLoad property on FuelLoadDetail entity
• Add emaillist to forms table

2023.2.3.1856

2/5/2023 3:28 AM

Fixes

• Unstarting, ending, or otherwise changing trip start and end time from the UI doesn't update trip status correctly
• Start load records RTAUTC value with zero timezone offset. The value is correct but it should store as local time with offset for easier viewing
• Orders won't load in RouteBuilder
• Report subscription uses the wrong link for attached files URL.
• Start trip on mobile can fail if there are invalid escape characters in item or customerItem descriptions (e.g. \n)

New

• Update R045 Std Delivery Receipt report to show pricing if the flag is set on the order
• API to GetOrdersToExport_MarkedReviewed should log an event if an order export fails and put the order back in the unreviewed order well
• Save DeliveredItemRefId when order is posted
• Remove Bing maps provider - no longer used for mapping or geocoding
• Add PO # as a search item in the order list
• Update Amazon S3 nuget to the latest version for file uploads
• Add report R243 Exported Orders not reviewed (incl. reconcile status)
• "Lock" the trip during the start trip process so multiple people can't start the same trip
• Add ability to delete saved Ad Hoc queries
• Refine trip prior cargo report (attached XLSX) to recalc total gals from inventory

2023.2.1.1849

2/2/2023 12:03 AM

Fixes

• Unstarting, ending, or otherwise changing trip start and end time from the UI doesn't update trip status correctly
• Start load records RTAUTC value with zero timezone offset. The value is correct but it should store as local time with offset for easier viewing
• Orders won't load in RouteBuilder
• Report subscription uses the wrong link for attached files URL.

New

• Update R045 Std Delivery Receipt report to show pricing if the flag is set on the order
• API to GetOrdersToExport_MarkedReviewed should log an event if an order export fails and put the order back in the unreviewed order well
• Save DeliveredItemRefId when order is posted
• Remove Bing maps provider - no longer used for mapping or geocoding
• Add PO # as a search item in the order list
• Update Amazon S3 nuget to the latest version for file uploads

2023.1.20.1853

1/21/2023 12:12 AM

Fixes

• Unstarting, ending, or otherwise changing trip start and end time from the UI doesn't update trip status correctly
• Start load records RTAUTC value with zero timezone offset. The value is correct but it should store as local time with offset for easier viewing
• Orders won't load in RouteBuilder
• Report subscription uses the wrong link for attached files URL.

New

• Update R045 Std Delivery Receipt report to show pricing if the flag is set on the order
• API to GetOrdersToExport_MarkedReviewed should log an event if an order export fails and put the order back in the unreviewed order well
• Save DeliveredItemRefId when order is posted

2023.1.20.1748

1/20/2023 11:06 PM

Fixes

• Unstarting, ending, or otherwise changing trip start and end time from the UI doesn't update trip status correctly
• Start load records RTAUTC value with zero timezone offset. The value is correct but it should store as local time with offset for easier viewing
• Orders won't load in RouteBuilder
• Report subscription uses the wrong link for attached files URL.

New

• Update R045 Std Delivery Receipt report to show pricing if the flag is set on the order
• API to GetOrdersToExport_MarkedReviewed should log an event if an order export fails and put the order back in the unreviewed order well
• Save DeliveredItemRefId when order is posted

2023.1.18.1144

1/18/2023 8:40 PM

Fixes

• Unstarting, ending, or otherwise changing trip start and end time from the UI doesn't update trip status correctly
• Start load records RTAUTC value with zero timezone offset. The value is correct but it should store as local time with offset for easier viewing

New

• Update R045 Std Delivery Receipt report to show pricing if the flag is set on the order

2023.1.16.1855

1/17/2023 12:06 AM

Fixes

• Update tank forecasting job to create a new order if the current one is already delivered
• StartTripPhase1 fails with an index out of range exception

New

• Add orderRefID (Guid) on order export APIs so external systems have a known unique ID for each order export
• Remove option to group orders for the same customer in API GetOrdersToExport_MarkedReviewed - not used
• Tank forecasting list control should allow selecting the number of tanks to view
• Update report R238 Orders with BOL Details to allow filtering by market, submarket, and routezone
• Optimize database save sequence when rejecting orders to reduce concurrency conflicts
• Update product compatibility matrix editing for easier use and fix issue with not adding compatibility
• Add tank forecasting method (manual, machine_learning, etc) to tank data import from CSV
• Add report R243 Orders Exported Not Reviewed - to better manage orders to export and the review process

2023.1.16.1855

1/17/2023 12:06 AM

Fixes

• Update task that exports to Big Data Portal to handle if a driver unstarts a trip (do not send to BDP)
• Update tank forecasting job to create a new order if the current one is already delivered
• StartTripPhase1 fails with an index out of range exception

New

• Return the stop count with the listtrips mobile API result
• Add audit in trip reconciliation for reviewed for export and exported flags
• Perform DB tuning- remove unused indexes and add performance tuning ones
• Add nightly system job to purge event logs based on date
• Add company configuration option to empty truck inventory at then end of each shift (for companies that do not track loads)
• Improve filter for inventory location list (add checkbox by type)
• Log a timeline event each time an order is requested to be reconciled
• Add form to show order lifecycle events (e.g. created, assigned, started)
• CreateTankOrdersFromTankReadings job should update orders with must fill date = today if the must fill is less than today
• Add tuning indexes for GPS events and message Queue
• Add orderRefID (Guid) on order export APIs so external systems have a known unique ID for each order export
• Remove option to group orders for the same customer in API GetOrdersToExport_MarkedReviewed - not used
• Tank forecasting list control should allow selecting the number of tanks to view
• Update report R238 Orders with BOL Details to allow filtering by market, submarket, and routezone
• Optimize database save sequence when rejecting orders to reduce concurrency conflicts
• Update product compatibility matrix editing for easier use and fix issue with not adding compatibility
• Add tank forecasting method (manual, machine_learning, etc) to tank data import from CSV
• Add report R243 Orders Exported Not Reviewed - to better manage orders to export and the review process

2022.12.16.1757

12/20/2022 3:37 PM

Fixes

• AddUpdateTrip API for 3PL should skip processing orders that are already started, including skip removing from trips
• Reconciliation report displays incorrect value for some orders' summed calc_val.
• MobileHub QB app stops importing a list of orders when a single order fails to import
• PDI Export SingleLineFuel job should filter on order type if populated in the job config
• API external should use itemDescription if customerItemDescription is empty
• Update GPS arrive/depart calculations to handle multiple orders at the same GPS geofence

New

• Add driver_notes to activity realization XML for Ortec OIR
• Add configuration to mark orders and loads when driver breaks geofence to arrive
• Add and record lifecycle events on orders (create order, assign to trip, start, arrive, etc.) to enable dispatchers to view the order lifecycle
• Create drum deposit report
• Log order reconciliation errors as events that are attached to the order to make it easier to monitor and manage releasing orders for invoicing (by exception)
• Add external API method to mark orders NOT exported and NOT reviewed. Used when not able to post an order in an external ERP system.
• Add R242 Report to show exported orders and orders NOT exported with their errors (if any)
• Export order list control should show a tooltip on each order with any reconciliation or export errors for easy viewing and management

2022.11.27.1434

11/27/2022 7:34 PM

Fixes

• FuelLoad edit form overlaps instructions with driver comments textboxes.
• RouteBuilder Sequence trip form should adjust for longer tripcodes and still show 'optimize' button
• Update QuickbooksEnterprise interface to round qty ordered and amount delivered to 2 decimals
• On the order edit form, ETA and ETD should alway be required

New

• PostActivity API needs to call the integration controller to send completed activities to subscribed endpoints
• Update web.config to include binding redirects to enable caching from db and objectcache
• Remove unused AdHoc views to make it easier to see key views and assign user permissions
• Add tenant context to error when calculating trip time and distance in RouteBuilder
• Update Wesroc (Anova) tank import to import all tanks with their last reading versus each tank individually
• Add reference to next order in tank attributes to assist in forecasting and viewing next planned order
• Update job to create orders from tank reading or tank history - add tuning params for more options on order creation
• Default recurrence pattern to 5am daily versus every minute to make it easier to schedule recurring daily activities
• Color code map pins on tank list to reflect days to empty, and add that info on the map pin tooltip
• Show next order# in the tank list to highlight tanks that need filling but do not have orders generated
• Add customer Acct# to asset list and asset edit form to better differentiate customers when many have the same or similar name

2022.11.8.1744

11/8/2022 10:49 PM

Fixes

• Add order from trip edit can fail due to order list (shows null error)

2022.11.7.1651

11/7/2022 9:57 PM

Fixes

• Order list in trip edit does not have data binding to show order #, address, and customer info

New

• Add available fields in MobileForms to auto-populate from orders, order details, loads, load details, trips, unitfilling

2022.11.7.956

11/7/2022 3:02 PM

Fixes

• Revise trip and activity entity to remove usings for Linq in user generated code
• Adding new order to trip edit form causes when sorting by RTA (if populated) ETA if not
• WhatsApp job uses SMS list vs WhatsApp list for recipients
• Schema upgrade fails on FuelLoad due to unused index on bill fields info length

New

• Update WhatsApp # length to 50 chars to support longer or multiple #'s
• Enforce compartment ID to 2 characters in form to edit asset compartments

2022.10.25.1229

10/25/2022 4:35 PM

Fixes

• Set insights email from address to the company config's smtp sent from value

New

• Add ParentType to MessageQueue list and edit (to see notification type, associated objects, etc.) for better filtering
• Orders in the trip edit form should be sorted by RTA first, and if no RTA then by ETA to show the actual delivery sequence (vs planned)
• When a trip is started, set the planned ETA (initial plan value) for orders, loads, and activities to support sending time-based OTW notifications

2022.10.24.943

10/24/2022 1:47 PM

New

• Update MessageQueue processing to use the scheduled send date field
• Remove all scheduled notifications for rejected or cancelled orders
• Implement start load and start activity methods in PODData
• Update ETAs and OTW notifications when loads or activities are started

2022.10.21.1851

10/21/2022 10:57 PM

Fixes

• Schema upgrade can fail if index on AssetReading was not created prior to upgrade

New

• Add job to export orders for PDI Single File Line Fuel (to export fuel orders matching the PDI csv spec)

2022.10.20.1821

10/20/2022 10:28 PM

New

• Implement company config that will turn off non-pod notifications for non-reconciled orders
• add depotname to trip list DTO in POD private mobile API
• Update Centeron tank import to emit XLS of tanks and show last product delivered for each tank, and date of delivery
• Update fuelload state field and related field lengths to better support non-US locales
• Add Centeron ProductID to XLS export to better track and correlate Centeron tanks with MobileHub tanks

2022.10.18.1857

10/18/2022 11:04 PM

Fixes

• Petrochoice Boomi integration returns 0 for Http status
• Import-Export tool for configs and preferences could fail when updating a config setting(should add ones that are not found via new entity)

New

• Increase the length of contact fields: firstname, lastname to accomodate longer names from other cultures

2022.10.17.1836

10/17/2022 10:42 PM

New

• Return stop name with the stop instructions when getting a list of potential trips

2022.10.17.1538

10/17/2022 7:44 PM

New

• Increase the length of customer fields: firstname, lastname to accomodate longer names from other cultures

2022.10.14.2247

10/15/2022 2:54 AM

Fixes

• Insights email failed to send because the email template could not be found

New

• Add PlannedETA column to Order, Load, and Activity
• If a scheduled job fails, auto-email the system admin
• Add filter and column for tank monitor mfg in tank list
• When geocoding customer addresses, try address2 if address1 fails (handles cases where address1 is info vs valid street address)
• In Ad Hoc Query tool, add options to filter for "IS NULL" and "IS NOT NULL"
• In customer edit form, move geocode button and related fields to the shipping address group to more easily see geocode/address results
• Add scheduled job to purge files for orders, loads, trips, message each with a setting for ## days to keep

2022.10.3.2132

10/4/2022 1:39 AM

New

• Add API Logging to PostInventoryTxns
• Activate truck filter to R219_TripSummaryActuals report
• Add company code to device license dialog
• Copy license to clipboard and set license expiration date to a date far in the future
• Add option to import and export preference, config settings, and email templates to make it easier to migrate tenant configurations

2022.9.30.920

9/30/2022 1:26 PM

Fixes

• Posting inventory txns can fail on associated object refid

2022.9.29.1803

9/29/2022 10:09 PM

Fixes

• Export orders control does not consistently show the order's tripcode

New

• Copy last customer order should check item price on CustomerItem and default based on whether to use item table or CustomerItem

2022.9.29.1706

9/29/2022 9:12 PM

Fixes

• AssetReading tuning index fails on databases less than SQL 16

New

• Update R239 Report Customer Product Summary to filter on 2 products
• Add CustomerItem price checkbox to default to item price for most current price

2022.9.28.1923

9/28/2022 11:29 PM

New

• Update API GetOrdersToExport_MarkedReviewed - add extended unit attributes
• Add tuning index to AssetReading table to improve getting the last asset reading

2022.9.27.1606

9/27/2022 8:14 PM

New

• DB performance tuning - remove unused indexes

2022.9.27.1450

9/27/2022 6:55 PM

New

• Make the GPSEventLog DTO more "compact"
• Add ScheduledSendData for MesageQueue to support time-based notifications in the future

2022.9.22.1903

9/22/2022 11:04 PM

Fixes

• Routebuilder does not save the user preference on whether to filter orders by date

New

• API calls to Ortec should log the response from OIR and ORD

2022.9.22.1213

9/22/2022 4:55 PM

Fixes

• DM2 API monitor service can fail checking for message retries on the first time processing messages

New

• Update DM2 monitor to email the admin when a sync error occurs so they can see the details (ex. driver code not setup)
• Quickbooks Enterprise monitor should check if a job name (customer) is empty and use the parent name (full name)
• AddUpdateItem API should use MobileHub item UOM as the system of record. If MobileHub UOM is set, do not update the UOM from the API

2022.9.21.943

9/21/2022 1:50 PM

Fixes

• Customer list does not filter correctly when using "serviced by depot" - included inactive depots
• BigDataPortal provider can fail if a trip is edited after posted and the driver is removed - should pass an empty driver

New

• Save Associated Object RefID to InventoryTxns from mobile

2022.9.16.1854

9/16/2022 11:01 PM

New

• Add "Send Insights Emails" to company config
• Update Centeron tank monitor import job to optionally generate Excel xls of all tanks and their UIDs
• Add files control to scheduled job edit form so files can be attached to jobs

2022.9.16.1140

9/16/2022 3:47 PM

New

• Insights email images should link to raptor dashboard

2022.9.16.1044

9/16/2022 2:51 PM

Fixes

• During reconciliation the unit filling versus totalizers variance seemed to be more than the configured allowed variance
• DateTimeOffset causes an exception when ad hoc report is exported to Excel

2022.9.13.2326

9/14/2022 3:32 AM

New

• Save compartment in inventory transactions
• Create BizSpeed.Insights email nightly maintenance job
• Add sensorID to tank list in forecasting tanks
• Add filter for showing only monitored tanks in tank like
• Update Centeron tank monitor import to set days till empty based on monitor readings

2022.9.9.1112

9/9/2022 3:20 PM

Fixes

• DM2 lubes order export can fail if the driver is removed from a completed order
• Update scheduled job to RepostOrdersThroughMobileHub to reset retries immediately to avoid continued retries when failing
• R0045 Delivery Receipts By Trip report does not update the signature for each delivery ticket.

New

• Job to export files to external FTP site should skip if a file is not found
• Enable deleting ad hoc queries so users can save/delete
• Update DM2 GenerateInvoices API call to include DriverCode (lubes vs fuel/BOL)

2022.9.5.1723

9/5/2022 9:30 PM

New

• Add shipaddress2 to customer CSV file import

2022.8.31.1818

8/31/2022 10:26 PM

Fixes

• Fix tag checking logic in order reconciliation

2022.8.31.1813

8/31/2022 10:15 PM

New

• Update trip metrics to include retained qty and # of rejected orders (missed)

2022.8.22.1836

8/22/2022 10:38 PM

New

• Update API3pLexternal to add/update customers and items by matching on externalID if populated, and fallback to itemID and accountNumber if not. This enables other systems to use their externalID as the key.

2022.8.19.1007

8/19/2022 2:13 PM

Fixes

• Orders are not re-reconciled when trip reconciliation force reconciliation option is true.
• email for truck returning with inventory sometimes does not get queued
• Dm2 import should coalesce billtoname, shiptoname, "no name provided" so the default bill name is displayed correctly

2022.8.15.1244

8/15/2022 4:51 PM

Fixes

• Customer asset list has an error enumerating certain assets

2022.8.11.945

8/11/2022 1:53 PM

Fixes

• Roadnet order import doesn't handle lines split across trips

2022.8.8.1850

8/8/2022 10:57 PM

Fixes

• OIRv2 post order outbound message can sometimes be missing a non-delivery reason

2022.8.8.1057

8/8/2022 3:04 PM

Fixes

• Event emails can have duplicated recipient lists
• Trip audit xls report should sum when auto-BOL line splitting occurs (sum by line for ordered/delivered)

2022.8.8.1024

8/8/2022 2:26 PM

Fixes

• Order reconciliation should check units with the same parent account for total capacity (e.g. driver and passenger)

New

• Trip audit xls report should highlight in yellow any assets filled over capacity (calc based on driver+passenger if applicable)

2022.8.4.1308

8/4/2022 5:15 PM

Fixes

• RouteBuilder does not filter correctly if a customer is not assigned to a depot but an order is assigned to a depot

New

• Add form name column to the list of completed forms (mobile forms)
• Add schedule job to export all orders (routed and unrouted) to an Excel xls and email to a list

2022.8.2.1713

8/2/2022 9:20 PM

New

• Tune Routebuilder order filter UI

2022.8.2.1522

8/2/2022 7:29 PM

New

• Add forms control to trip to view ALL forms completed with any entity associated with the trip (trip, order, order detail, load, etc.)

2022.8.1.704

8/1/2022 11:12 AM

Fixes

• Change scheduled job to export all image files on a trip - should email once per trip and use the messageQ for sending emails

2022.7.29.1537

7/29/2022 7:45 PM

New

• Capture trailer ID and pass it along to ORD for shuttle orders
• Update SSID label to network name for better describing fleet attributes

2022.7.26.1822

7/26/2022 10:25 PM

Fixes

• Driver OTW email template does not get customer information in its context

New

• For shuttle postorder messages, include the suborder info in the suborders element
• Update Excel formatting for MobileForms - add images to a separate tab with hyperlinks

2022.7.22.1222

7/22/2022 4:29 PM

New

• Skip trip updates for configured trip types in apiExternal.AddUpdateTrip()

2022.7.21.1141

7/21/2022 3:48 PM

New

• Update R219 and R0045 reports to display customer item id and/or customer item description
• Add skip trip update company config
• Add Excel report for posted mobile forms
• Forms editor should include timing sequence of when form is called: any, before, after

2022.7.20.2136

7/21/2022 1:43 AM

Fixes

• Checkinstallation can fail on certain database instances if messagequeue indexes were already created

New

• Add support for sending WhatsApp messages via Twilio
• Update line items on the R0045_DeliveryReceiptStd_ByTrip to use customer item id and description

2022.7.19.1704

7/19/2022 9:11 PM

New

• Add geofence arrive and depart times to trip, order, load tables

2022.7.19.1116

7/19/2022 3:24 PM

New

• SearchCustomers API should check customerType and only include it in the filter if it has a value

2022.7.19.751

7/19/2022 11:58 AM

Fixes

• Mobile authentication can fail if the MobileHub server cannot access the file store

New

• Implement a product compatibility matrix
• Implement a way to gracefully handle mobile timeouts when starting trips

2022.7.13.1343

7/13/2022 5:50 PM

Fixes

• AddUpdateCustomer public API method does not handle ParentAccountNumber correctly
• GetCustomerList doesn't set RelatedAssetsKey or ParentAccountNumber correctly

New

• DM2 export to create invoices in DM2 should include DriverNo to enable cost allocation for trips/customers in DM2
• R201 ordered vs delivered variance report should show over-delivery as positive vs negative
• Return vehicle tags with trip information when calling api3PL StartTrip
• Implement searching by tag in the PODData.SearchCustomers function
• Optimize indexes in MessageQueue and update to process messages based on a max date (configurable)

2022.7.8.1841

7/8/2022 10:48 PM

Fixes

• EmailTripEndedWithInventory can fail parsing some inventory quantities. Should coalesce to integer

2022.7.8.1816

7/8/2022 10:24 PM

New

• Update internal API for AddUpdateOrder to map shipping address and related fields when creating orders in the mobile app

2022.7.8.1456

7/8/2022 7:03 PM

New

• Update PhoneNumbers to exclude from SMS - add reason message and associated entity to more easily find and manage (ex. find the associated customer)

2022.7.7.1924

7/7/2022 11:31 PM

New

• Add method for searching items to the api3PL module

2022.7.7.1226

7/7/2022 4:34 PM

Fixes

• Order reconciliation with totalizers should compare based on meter number - total all units per meter and compare qty delivered with that meter's start/end totalizer

New

• Add optional group filter to the get item list api call in the api3PL module

2022.7.1.1801

7/1/2022 10:09 PM

New

• Add option to search for customer NOT assigned to a depot in customer list
• Update product lookup when editing order details to show ID, description and UOM more clearly (improve search)

2022.7.1.1204

7/1/2022 4:11 PM

New

• Add scheduled job to import orders from Oakland Point of Sale (POS) via csv

2022.6.29.1914

6/29/2022 11:21 PM

New

• Add support for saving and fetching driver "exemplar" signatures
• Add option to import and export form definitions (as JSON)

2022.6.29.1157

6/29/2022 4:05 PM

New

• Update MobileForms api to accept data and log GPS of form completion location

2022.6.29.1011

6/29/2022 2:17 PM

Fixes

• Job to send SMS messages does not always increment retry count and may resend messages that fail

New

• Add job to import tank readings from Anova/WesRoc tank monitors
• Add formpost table

2022.6.26.1626

6/26/2022 8:34 PM

New

• Update OrtecOIRv2 interface to emit zero-value delivery qty at integer vs F2 0.00

2022.6.24.1915

6/24/2022 11:22 PM

Fixes

• PODData's AddUpdateOrder method does not map customer ref ID to orders
• Update order reconciliation check for assets over capacity - ensure rollup capacity on assets where assets have more than 1 tank (ex. driver + saddle tank)

New

• PODData's AddUpdateOrder method does not map customer ref ID to orders

2022.6.23.1940

6/23/2022 11:47 PM

New

• Add option in trip list to filter for unreconciled trips (to speed up reconciliation)

2022.6.23.1108

6/23/2022 3:10 PM

Fixes

• Audits inserted from forms are not being saved with the parent entity information

New

• Add EtaVersion to trip to enable notifying drivers when ETA's are updated but not the trip itself. This supports dynamic ETA updates as orders are completed.
• Add tuning indexes for last meter product info so drivers know the last product per meter
• Add audits for adding and removing tags on entities
• Add customer type parameter to pod data search customers method.

2022.6.20.1747

6/20/2022 9:51 PM

Fixes

• Update Ortec OIRv2 interface to NOT rollup by actionID for package items

New

• Add Report R304_ProductSummaryByDepot to show products ordered/delivered by depot and date range

2022.6.16.1516

6/16/2022 7:24 PM

New

• Add public API for accepting trip ETA updates only

2022.6.16.1021

6/16/2022 2:30 PM

New

• Add CustomerType to AddUpdateCustomer API

2022.6.16.835

6/16/2022 12:43 PM

Fixes

• OIRv3 reject order doesn't normalize reject date to the local date

New

• Add customer entity to "customer comments" email template so it can be used in template customization. Update the template to include account#
• Add IsTransport and HasMixedMeters options on fleet info tab. Mixed meters for assets with both eMeter and Mechanical meters
• Add option on depots to set the terminal - so depots function like a terminal

2022.6.10.1908

6/10/2022 11:16 PM

Fixes

• Nightly job to purge audits needs db index to ensure it does not slow down users logging in

New

• Schedule Reject Order integration message to run 5 minutes after receiving so any image files are also received and can be sent in the integration message to routing systems
• Update tank order generation to save to MobileHub or a CSV/XLS file for new tank orders

2022.6.8.1906

6/8/2022 11:15 PM

New

• Send last product through register in pre-trip totalizer message to goRoamPOD
• Capture meter number and start/stop totalizer readings from inventory transactions from mobile
• Add truckID filter on R219 daily operations report

2022.6.7.1032

6/7/2022 2:40 PM

Fixes

• API Log list screen shows time in UTC time rather than local time
• Email test panel on org edit screen uses incorrect "from" address

New

• Make debug audit purge a company system config preference for the hours after which it does not run (to prevent running during business hours)

2022.6.3.1827

6/3/2022 10:31 PM

Fixes

• Otodata tank reading import job re-imports the same tank and readingtime

New

• Update SMS sending job to log and skip sending if a phone number is listed in the "do not send" list
• Add "MeterNumber" column to InventoryTxns table

2022.6.2.1125

6/2/2022 3:33 PM

Fixes

• Limit SMS retries to a max of 3
• Otodata tank import should use a max window of 14 days to retrieve history

New

• Add table to track phone numbers (DO NOT SEND) for SMS - whether reply STOP or invalid #

2022.6.1.1625

6/1/2022 8:29 PM

Fixes

• URL shortner service does not set the shortcode part which is used for an alternate lookup

New

• Add option in email for PODs to format date as ShortDate in addition to "g" time

2022.5.31.1857

5/31/2022 11:05 PM

New

• AddUpdateCustomer API should convert contacts from a single to an array if passed in as a single (from XML/SOAP vs JSON)

2022.5.31.1705

5/31/2022 9:14 PM

Fixes

• International SMS messages can fail format validation and US numbers fail if a leading + but no country code

2022.5.31.1033

5/31/2022 2:41 PM

New

• Add Comments to FuelOrderDetailInventory

2022.5.27.1507

5/27/2022 7:16 PM

New

• Update contact phone number length to accomodate up to 2 #'s and international extensions
• Update POD email to allow subject line to use mustache template for customization of subject

2022.5.27.1311

5/27/2022 5:14 PM

Fixes

• Routebuilder should filter orders that are not marked "Ready to Route" (new field to support web and tank orders)

New

• Make SMS notifications (ASN, OTW, POD) configurable per tenant and enable multi-language support

2022.5.24.1752

5/24/2022 10:01 PM

New

• Add tuning for nightly job to deactivate customer assets if not filled in XX days

2022.5.20.1116

5/20/2022 3:24 PM

Fixes

• Copy last order details copies services and fees
• Put action element in the correct location on the Ortec RejectOrder messages
• Process to send SMS messages should reset error messages when sent successfully on subsequent attempts

New

• Record the correct "OrderSource" when orders are created in the field or via an API call
• Allow the user to filter the order list by the "source" and add a column for the source in the grid
• Show Order Source on the order edit form
• Add SaveTrip as an option for custom save handlers
• When processing event emails, send to all depot emails for truck, trip, and customer
• Add Proposed Order review form to approve orders from tank forecasting, customer portal, etc. where they are not yet assigned and ready to route

2022.5.17.1817

5/17/2022 10:25 PM

New

• Update ApiDocs to include DeleteTrip

2022.5.17.1752

5/17/2022 9:56 PM

Fixes

• Nightly job to mark assets inactive set to use months versus days not filled - may result in marking more assets inactive than planned

New

• Add Nightly Job to create/update customer items based on past orders
• Update order import API methods to update customer item tax rate
• Tune the nightly job that purges debug info for better db performance

2022.5.13.1646

5/13/2022 8:55 PM

New

• Send a "Server Compartment" with the trip load
• Add fields on orders to show order source (tank forecasting, API, customer portal)
• Update R212 Daily Ops report to show depot on rejected orders and to show manual entries ONLY for trucks with and OBC for eMeter integration

2022.5.13.1111

5/13/2022 3:14 PM

New

• Add multi-tenant snapshot report to view stats across tenants

2022.5.11.1655

5/11/2022 9:04 PM

Fixes

• RouteBuilder does not show assigned depot to all customers
• Message Queue list does not show "SMS" as a message type in the filter
• URL Shortener generates inaccessible URLs for POD text messages

New

• Update OrtecORD3PL api to handle posting DHL I2M loads
• Update R233 report to show order summary and include product totals for routed and unrouted orders, as well as ordered
• Add start trip handler for early departures for AFS

2022.5.7.1332

5/7/2022 5:40 PM

Fixes

• public AddUpdateCustomer API doesn't update the AllowNewAsset value correctly

New

• Add AppVersion column to DeviceLicense table
• Ortec APIv2 should group by actionID which occurs when splitting lines (ex BOL split) so lines are summed by actionID
• Post completed orders to Ortec (v3) should include URLs for images attached to the order

2022.5.5.2245

5/6/2022 2:53 AM

Fixes

• P21 Processor - when item unit price is zero, a divide by zero exception is thrown when calculating tax rates
• P21 Processor: Fix issue where will call orders have empty address fields
• Order List "Truck" column is always empty
• AddUpdateCustomer public API doesn't clear out values when they are submitted in the DTO as empty strings

New

• Show odometer and meter totalizer differences on trip edit
• Add more diagnostic code to the P21 Processor to help track down issues
• P21 Processor: Add try/catch statements inside foreach loops to allow processor to continue even if an individual pick ticket fails to import...
• Improve auditing when user accounts are created or updated
• Add diagnostic code to the order sweep functionality to help determine http error
• Update Quickbooks processor to optionally create an excel workbook with all QB customers and items
• Change Parent Account Number labels on the bulk customer edit form to "related assets key"
• Updated system scheduled jobs to use local time vs UTC for easier management
• Disable "operational" elements on the trip edit screen if the trip is still in progress
• P21 Processor: If ship address is missing and a value is present for ship address 2, populate address 1 with address 2
• Add support in mobile customer search to restrict list by sales rep
• Add method to provide start trip save handler for custom logic per tenant
• update ortec 3PL to adjust for shuttle service options

2022.4.29.846

4/29/2022 12:55 PM

Fixes

• AddUpdateTripNoGuids API should remove rejected orders so they are not orphaned on other trips (prevent duplicate order #'s where one order is never assigned or completed)
• Trip reconciliation tab - meter totalizer comparison versus prior trip should round differences to the nearest 1 decimal

New

• Increase autoretry count from default of 10 to 20 for BigDataPortal integration with Ortec (to allow for longer periods of BDP downtime)

2022.4.26.1806

4/26/2022 10:15 PM

Fixes

• Nightly job to deactivate assets not filled in XX days may mark assets inactive that have been filled more recently

2022.4.25.1651

4/25/2022 9:00 PM

Fixes

• Trip status board V2 does not correct for timezone and may miss trips that start early in the morning

New

• Update trip status boardV2 to optimize UI space (compress and show more items)
• Automatically mark trip as reconciled if all loads have BOLs and trip totalizers are within the equivalent of < 5 gal variance

2022.4.25.930

4/25/2022 1:39 PM

Fixes

• Fix Epicor P21 processor to calculate taxes based on percentage approach used in goRoam (15% versus .15%)

New

• Add checkbox to filter orders by date in RouteBuilder - default to show all orders to include those with earlier ship dates
• Add isWillCall to the add order api to denote orders to be picked up at the depot. Set the address = depot if not set
• Add taxpct to customer item table

2022.4.22.1808

4/22/2022 10:16 PM

New

• Save AppVersion in AssetReading and in device license table
• Add AppVersion column to device license list screen
• Add IsEnabled flag on CustomerItems to be able to turn on/off item availability
• Add Delivery Window hours of service (by day) to the AddUpdateCustomer API. Delivery windows are used for routing

2022.4.19.1614

4/19/2022 8:23 PM

Fixes

• FileAttachments.UploadFileAttachment duplicates the file's extension when downloading the file

New

• Add OBC version info to fleet attributes to track OBC software updates

2022.4.19.740

4/19/2022 11:49 AM

New

• AddUpdateTrip API should attempt to match load details on item AND associatedOrderNo so loads can have details with the same item across orders

2022.4.15.100

4/15/2022 5:09 AM

Fixes

• Notify next customer that driver is on the way can fail with invalid lat/long (email or text customer)

New

• Convert truck returning with inventory email to a template versus fixed content.

2022.4.13.851

4/13/2022 1:01 PM

New

• Update OrtecV2 interface to rollup PostOrder realizations by actionID (where a line is split on delivery w same actionID)

2022.4.12.1243

4/12/2022 4:52 PM

Fixes

• P21 Process monitor should auto-requeue orders if there is an error sending

New

• Add nightly job to deactivate assets if unfilled after XXX days. Deactivate scheduled job if exists and migrate to company config settings.
• Add willcall flag on orders to specifically denote those to be picked up at a depot

2022.4.5.1838

4/5/2022 10:47 PM

Fixes

• Trip status board V2 does not highlight rejected orders in orange (shows transparent), shows without rejection reason

2022.4.5.1514

4/5/2022 7:23 PM

Fixes

• Error when generating SMS messages for trip assignments to drivers (fix phone# format)

2022.4.4.1721

4/4/2022 9:30 PM

Fixes

• When emailing next customer OTW (on the way), check to ensure there are additional stops. If not, then do not attempt to send an email (this occurs when drivers self dispatch)

New

• Add properties to FleetAssetAttributes for IsTransport and MixedMeters
• Add a property to the Terminals collection in the POD Reference data to indicate that a terminal is a "Home" terminal
• In the trip reconciliation audit XLS report, add meter#, sale#, scan/picked, and compartment

2022.4.4.1117

4/4/2022 3:26 PM

Fixes

• Sites.State length is too long for mobile meter ticket printers
• Unable to edit assets that are imported and have capacity greater than max value. Reset to max value when loading edit forms.

New

• add R241 scan vs pick report for each unit scanned

2022.3.29.1522

3/29/2022 7:30 PM

Fixes

• Order Status Code not being added to OIRv3 "extra_stop" data section

New

• Refine order reconciliation to compare begin/end totalizers and total asset capacity to allow validation to pass
• update OIR interface to pass along the order status

2022.3.25.1903

3/25/2022 11:12 PM

Fixes

• Job to import DM2 CSV files does not map customer itemID and description

2022.3.24.1118

3/24/2022 3:26 PM

Fixes

• Remove compressed indexes in db upgrade script as some older SQL Server installs do not support them.

New

• Remove compressed indexes in db upgrade script as some older SQL Server installs do not support them.

2022.3.21.905

3/21/2022 1:14 PM

New

• In order reconciliation - when qty is negative and less than -1 (from hoses without backflow preventer valves), adjust qty to zero.
• In reconciliation, if beginning totalizer is zero, get the last asset ending totalizer and assign to the beginning
• In reconciliation, if manually added compare against total tank capacity for the unit versus individual tank capacity

2022.3.18.1843

3/18/2022 10:48 PM

New

• Update form table to handle JSON based definitions

2022.3.17.1757

3/17/2022 10:06 PM

New

• Update OIRv3 interface to add "xtra_stop" section for rejected orders
• Add company configuration setting to enable rounding delivered qty for ERP systems (Shell, ExxonMobil) that only take integers

2022.3.17.1322

3/17/2022 5:31 PM

Fixes

• When more than 1 trip is assigned to a driver, and only 1 is not started, the mobile app does not find the unstarted trip and locks the change truck list

New

• Update DM2 CSV import to allow switching ship to address1 and address2 when using national account #'s for address1

2022.3.15.1807

3/15/2022 10:16 PM

New

• Update DM2 CSV import job to accept case-insensitive headers

2022.3.15.1215

3/15/2022 4:19 PM

Fixes

• OrderDate of orders created in the field is not getting set

New

• Add ability to search for scheduled trips by driver
• Add tax to R0045_DeliveryReceiptStd_withFilelinks delivery receipt
• Update P21 connector to mark orders as COD when the term_id is 3 or 12

2022.3.11.1134

3/11/2022 4:36 PM

New

• Add tuning indexes to message queue and gps event log
• Build report viewer page for raptor reports
• Add credit hold flag to order import APIs to ensure customers credit status is updated in cases where drivers attempt to add orders in the field.

2022.3.10.1730

3/10/2022 10:31 PM

New

• Add start GPS (lat/long) to orders and loads

2022.3.9.928

3/9/2022 2:31 PM

Fixes

• ShipperState fails on some order saves due to column len

2022.3.8.1058

3/8/2022 4:00 PM

New

• Update Ortec Integrator Windows Service to log request/response pairs to APILog for visibility in MobileHub
• Add vendor info to the order to denote if an order is Shell DFOA, ExxonMobil buyback, etc.
• Increase depot state length to support non-US locals
• Add wasScanned to unit filling to compared scanned versus selected units to fill
• Increase column length for state code

2022.2.28.1906

3/1/2022 12:08 AM

Fixes

• Site status dropdown has more than one "Open" status choice

New

• Auto add sysconfig to each company during nightly maintenance
• Add customer map to show customers serviced by 1-n depots on a map (for territory planning)

2022.2.15.1802

2/15/2022 11:05 PM

Fixes

• External public API doesn't correctly respect pieces to quantity multiplier on inbound request
• AddUpdateTripNoGuids API method in PODData does not include pcs to quantity multiplier for items

New

• when authenticating a mobile user, check user role against app being used
• update Epicor P21 monitor to use Hangfire for background processing (queue) and only send orders if date_last_modified is newer

2022.2.9.1743

2/9/2022 10:46 PM

Fixes

• Package Size maximum value is too low on Item Edit form

New

• Update DAL to include Preference.PreferenceType
• when posting an order, set order status from mobile, if present
• Add scheduled job to import DM2 standard CSV order exports via FTPS. Enables uploading a CSV of DM2 orders to be routed.

2022.2.8.929

2/8/2022 2:31 PM

Fixes

• Stale asset check could return asset for wrong customer if related assets key is empty
• If the OBC does not generate and Out of Band delivery, infer the OOB based on asset readings and show in trip reconciliation

New

• Add truck and driver to BDP "UpdateTrip" object
• Add "PreferenceType" field to preferences table
• In trip reconciliation XLS file, add tabs for order summary and out of band deliveries

2022.1.17.1626

1/17/2022 9:30 PM

Fixes

• Update ad hoc view 'fuel loads with bols' to group by compartment

2022.1.14.1853

1/14/2022 11:57 PM

Fixes

• Add method to check GPS on Out-of-Band Deliveries and adjust based on mobile device GPS

New

• Add company config parameter for default trip start time
• Add report to show product totals by customer, depot and date range (R239)

2022.1.11.1709

1/11/2022 10:13 PM

Fixes

• Add tuning indexes and remove unused indexes on audit table to reduce concurrency (write heavy)

2022.1.9.1334

1/9/2022 6:37 PM

New

• Add nightly job to delete failed hangfire jobs after xx days

2022.1.7.1039

1/7/2022 3:42 PM

New

• Improve API response formatting for AddUpdateTrips to include delete order info in response
• Show DM2 request/response in local time vs UTC

2022.1.6.1902

1/7/2022 12:04 AM

Fixes

• Send email/text notification should check to see if this is the last order (no more notifications)
• Export posted orders fails if an order is removed from a trip ( orders should always be on a trip, but should be handled if manually removed after delivery)
• Trip reconciliation may miss CLEAR line operations in the trip summary totalizer tab

New

• Add performance tuning index to API log for categories

2021.12.28.1937

12/29/2021 12:44 AM

New

• Add job and related functions to text ASN, OTW, POD (advanced ship notice, on the way, proof of delivery)

2021.12.27.1618

12/27/2021 9:22 PM

Fixes

• EventLog emails should associate the depot for rejected orders when they are removed from a trip

New

• Add filter for APImethod in API List

2021.12.23.900

12/23/2021 1:59 PM

New

• Disable checking the exported flag in the trip reconciliation form (so it is not inadvertently checked and then skipped being exported)

2021.12.17.1823

12/17/2021 11:26 PM

New

• Upgrade Hangfire queue processing to v1.7
• Add new table to separate API logs from audits

2021.12.17.835

12/17/2021 1:38 PM

Fixes

• Process to determine which eventlogs to email does not capture first or last csv list items correctly (has a leading/trailing ")
• Order list only shows orders with a trip assigned. Needs to show all meeting the criteria.

2021.12.16.819

12/16/2021 1:21 PM

New

• Update product filter on active orders to make it easier to search for orders with specific products
• Requeue Big Data Portal when trip is saved and trip is complete

2021.12.9.1521

12/9/2021 8:23 PM

New

• Create custom ImportOtodataTankReadings job for Cooper Equipment Rentals

2021.12.6.1803

12/6/2021 11:07 PM

New

• Update Point of Interest (POI) Search for fuel stations to show all along the route versus the top 15 nearest

2021.12.6.900

12/6/2021 2:02 PM

New

• Add section to company config to exclude list of eventcodes from email (ex. GEOFENCE, LUNCH, etc) things that do not need an email notification
• Update API to AddUpdateOrders to allow matching on itemID if line# is not set.

2021.12.4.1114

12/4/2021 4:17 PM

New

• Update checkinstallation script to publish new or updated SSRS reports

2021.12.3.1533

12/3/2021 8:35 PM

Fixes

• Searching for a new product from the mobile app fails when looking at customer specific items (left join customeritems)

New

• Add ORTEC config setting to allow not sending driver added items for specific categories, such as fees
• Add default system reports and setup for each role (admin, dispatch, customer service) in each tenant

2021.12.2.952

12/2/2021 2:56 PM

New

• Update biztalk export to audit order changes

2021.11.30.1914

12/1/2021 12:20 AM

Fixes

• Trip reconciliation does not show inventory transactions for the trip (clean, flush, pump_out, etc.)
• Reposting orders to reprocess through integration should retain the assigned driver

New

• Add order reconciliation option to allow passing if delivery over capacity within XX qty variance
• Add order reconciliation option to allow passing if totalizers within XX variance in qty

2021.11.29.1602

11/29/2021 9:05 PM

New

• Add config options in order reconciliation to allow passing if minimal (config setting) qty overfilled or totalizers within qty tolerance. Ex. overfill 4 gals.

2021.11.29.1349

11/29/2021 6:52 PM

Fixes

• Otodata tank import has some null values for non-nullable properties

New

• Ortec OIRv3 interface should group by action ID when sending order realizations to OIR. (For example, when splitting a BOL they are on the same action so qty should sum by action)
• Defer Ortec PostTrip realization web call to ensure all order realizations are actually realized before ending the trip

2021.11.16.802

11/16/2021 1:05 PM

New

• Update I2M mapping fields for load details

2021.11.12.1301

11/12/2021 6:00 PM

Fixes

• BizTalk export does not sum/emit unit filling if grouping on BOL

New

• On order reconciliation, when manually invoked force are recalc on all reconciliation items regardless of past status

2021.11.10.017

11/10/2021 5:20 AM

New

• Add job parameter to optionally only send POD emails to a list of depots

2021.11.9.2257

11/10/2021 4:00 AM

Fixes

• Epicor P21 monitor did not map the supplier_order_no to the release number. Supplier order # is SOPUS or Shell number, or Mobil buyback #.

New

• Update Epicor P21 processor to requeue orders that were not sent to MobileHub

2021.11.9.1137

11/9/2021 4:40 PM

New

• Update 3pl-external api to capture LoadDetail.AssociatedOrderNo field

2021.11.9.954

11/9/2021 2:57 PM

New

• Add AssociatedOrderNo to 3PL LoadDetail DTO

2021.11.9.814

11/9/2021 1:16 PM

Fixes

• Change AddUpdateTrip API to default to searching for details by 1) line#, 2) itemID 3) customerItemID.

New

• Extend max date range on API ExportPostedOrders_byFilter to 90 days (from 14)
• Add associateOrderNo to load detail to use when mapping a load detail with an order

2021.11.1.1000

11/1/2021 2:04 PM

Fixes

• "Is Metered" checkbox on Fleet Info tab is not populated correctly w.r.t. database values

2021.10.31.1851

10/31/2021 10:55 PM

New

• Add ParentAccountNumber to API to ExportPostedOrders_byFilter - this is the acct# of the parent, not the related assets key

2021.10.29.1534

10/29/2021 7:38 PM

Fixes

• API to AddUpdateCustomer fails if mapping to a depot (uses tag vs depot to check depotID)
• BizTalk export fails when rolling up by BOL...and converting all BOLS to RETAIN

2021.10.29.1449

10/29/2021 6:51 PM

New

• Add LineNotes to dto3pl.LoadDetail and populate it when loads are posted

2021.10.29.1210

10/29/2021 4:13 PM

New

• Add LineNotes to load detail

2021.10.29.933

10/29/2021 1:35 PM

New

• Add additional fields to load detail DTO to meet DHL I2M requirements

2021.10.27.1904

10/27/2021 11:07 PM

Fixes

• Reposting orders should apply appropriate timezone offset at the unit filling level (based on order UTC time)

New

• Add trip_type to the AddUpdateTrip API. Use this to filter by trip type for metrics and other reporting/integration.
• Record GPS lat/long for each unit filling record

2021.10.27.854

10/27/2021 12:57 PM

New

• Change tank monitor to export proposed orders using Excel viewer vs direct CSV (so exports can be xlsx, csv, etc)

2021.10.25.1759

10/25/2021 10:02 PM

New

• Streamline AddOrder API when checking for changes to save new items

2021.10.22.1142

10/22/2021 3:46 PM

New

• Update API to AddUpdateOrdersWithoutTrips to handle null line numbers and match on itemID

2021.10.21.1826

10/21/2021 10:29 PM

New

• AddUpdateTrip API should handle ERP systems that change itemIDs for the same line number
• Add option for fleet assets to specify net vs gross for meters (which will send to the truck meter controller)
• Add gps lat/long to unit filling records

2021.10.21.853

10/21/2021 12:58 PM

Fixes

• AddUpdateTrip API causes concurrency failure when checking for updates to order details

2021.10.20.1919

10/20/2021 11:22 PM

New

• Streamline API pipelines for api3PLexternal to reduce calls to the database when no changes occur (perf tuning)

2021.10.20.1131

10/20/2021 3:34 PM

New

• Update the 3PL api PostOrder method to account for the DHL I2M process

2021.10.19.1005

10/19/2021 2:09 PM

New

• Retrieve dunnage and parts items in the 3PL api

2021.10.18.1116

10/18/2021 3:20 PM

Fixes

• Concurrency check can fail if a table is plural versus singular from the object gen tool

New

• Update standard receipt template to improve formatting and remove lines under each asset fill. Add option to include start/finish times in header

2021.10.18.928

10/18/2021 1:28 PM

Fixes

• Ad Hoc reports can fail if a column changes in a saved query
• Job to email PODs does not send to the always_cc_email list if the customer is not setup to receive POD emails
• Ad Hoc table "fuelorderwithdetails" should show all orders, even if they are not assigned to a trip
• Starting a trip when loading by weight (scale heavy) can cause an error if inventory is not setup

New

• Add report R237 Trip Compliance to show if orders are done in the planned sequence
• Change Ad Hoc reports export so the default is to Excel vs CSV (easier for users to not have to import to Excel)
• Update schema to add a "UseNet" property to the assetfleetattributes table and update the UI to be able to set/unset the value
• On order details tab, when exporting to Excel, prompt user to save to file or view in Excel viewer

2021.10.10.1035

10/10/2021 2:39 PM

Fixes

• DM2 import process fails when DM2.TIMEUPDATED does not have the hour component in the string

New

• Update Epicor P21 monitor to retry if sending any orders for routing has errors
• For fleet assets, if isMetered is unchecked then set the meter count to zero
• Add Trip Metric to calculate if done in sequence

2021.10.7.1529

10/7/2021 7:34 PM

New

• Add bit field on Fleet Attributes to denote using Net vs Gross on the OBC - allows pushing from the server versus setup on OBC

2021.10.7.1036

10/7/2021 2:39 PM

Fixes

• Extend command timeout on nightly job to update tank capacities
• Schedule job to repost orders through integration should use UTC times for RTA/RTD, not local time
• Add unit filling can add a unit that does not have an associated asset if closing the form (not saving)

New

• Add performance tuning indexes on vehicle, tank, trailer attributes
• include asset "notes" in with customer assets downloaded to mobile POD

2021.10.5.1203

10/5/2021 4:08 PM

Fixes

• Report subscription could lose the enabled setting when saving and re-opening

2021.10.5.041

10/5/2021 4:41 AM

New

• Add Excel report for trip audit with all actions by driver

2021.9.28.1542

9/28/2021 7:47 PM

New

• Include the trip type when retrieving trips for the 3PL api

2021.9.28.1404

9/28/2021 6:04 PM

New

• Add order instructions on R215 Pick Ticket report

2021.9.28.926

9/28/2021 1:26 PM

New

• Add trip type to TripDTO for 3pl DTOs

2021.9.21.1842

9/21/2021 10:47 PM

New

• ORTEC PostTrip message start/end times should be the same (end time for the trip)

2021.9.21.1829

9/21/2021 10:33 PM

New

• In device license checker, normalize the SalesAssist bundle identifiers for iTunes app store
• Ensure ORTEC odometer realizations are int vs double
• Update PostOrder process to queue all orders for email to customer and use the email generation job to determine processing/recipients - removes need for setting autoemail tag from mobile app

2021.9.16.1458

9/16/2021 7:02 PM

Fixes

• In RouteBuilder, if a destination is unreachable by truck, fall back to car routing

2021.9.16.1436

9/16/2021 6:36 PM

New

• Roadnet Import should accommodate "line splits" and "reloads"

2021.9.15.1839

9/15/2021 10:43 PM

New

• AddUpdateCustomer API should handle GPS values as numbers or strings
• Add notes to unit filling assets so notes will auto-display when filling tanks, trucks, etc.

2021.9.7.1525

9/7/2021 7:29 PM

Fixes

• When checking device licenses, com.bizspeed.goroam.pod is failing license checks

New

• Require RTA and RTD on order edit form if saving and the order is posted

2021.9.3.1710

9/3/2021 9:15 PM

Fixes

• Reposting orders through the integration services can duplicate each line item

New

• Make the truck inventory download time horizon configurable

2021.9.2.1914

9/2/2021 11:18 PM

Fixes

• Update CommandAlkon interface to include entityRef in SupplierParty - to associate tickets to correct tenant
• Ortec BDP interface is not sending correct "reconciled" status for posted orders and trips

2021.8.31.1856

8/31/2021 11:00 PM

Fixes

• Stale Asset Check not returning correct status
• UploadCustomerContact throws unhandled exception if last name is null

New

• Update AddCustomerContacts API to allow removing contacts not in the list
• Add option to export order details and unit filling to Excel (from the order edit form)

2021.8.30.2158

8/31/2021 2:02 AM

Fixes

• Stale asset search throws an exception looking for asset customer

2021.8.30.1322

8/30/2021 5:26 PM

New

• Roadnet Import should accommodate "line splits" and "reloads"
• Add option to "Re-Post" orders to re-run the post order process and perform integration (calc taxes, service fees, send to ERP or other systems)

2021.8.24.2346

8/25/2021 3:50 AM

New

• Add context menu item in RouteBuilder to allow updating Truck, Trailer or Driver for trips that have not started

2021.8.20.1454

8/20/2021 6:58 PM

Fixes

• Fix issue with storm fueling where saving a new event without specifying a type causes an error

New

• Add R712 report that shows orders started in one month and finished the next (ex. Jul 31 and finished Aug 1) for month end close reconciliation
• Add new delivery receipt template that shows Sales Order (SO) qty so customer see the original order qty when there are multiple fulfillments
• Force Asset Class data to upper case when importing assets

2021.8.17.1617

8/17/2021 8:22 PM

Fixes

• Order search with sort by Vehicle Code throws error

New

• Add start and end meter totalizers for each unit fill in unit filling grid for order details.

2021.8.17.938

8/17/2021 1:42 PM

Fixes

• Ortec DIP interface is including services, charges, and fees in the total delivered quantity

New

• Assign correct "DisplayOrder" to fuel order detail taxes rows from tax engine
• In trip reconciliation, add validation to check each unit fill begin/end totalizer and compare against qty delivered, and if totalizers were not captured.

2021.8.12.1838

8/12/2021 10:42 PM

Fixes

• Product Blending screen display is incorrect
• Product blending matrix does not show all products associated a specific blend in the UI - mapping is not correct for display grid
• Trip edit - on creating new trip the first time the form is saved, and error is shown because the server version of the trip is empty. This did not impact data, just inconvenient seeing the message.
• Quantity control on Unit Filling dialog has a max value that is too small

New

• Asset edit form for tanks should use preference for meter types
• Add Sales Order Quantity to order detail DTO when presenting the trip to the mobile
• On trip edit form, change the depot for the trip when the planned vehicle changes
• Add planned qty to load list form - separate from total qty loaded
• Implement bootstrap styling on the terms of service page so it will be readable on mobile apps.
• UI to specify available terminals for a depot and available suppliers for a terminal
• API call to GetOrdersToExport_MarkedReviewed should include leading info if export list > 0 to make audit searches easier to see exports with data
• Update DAL to include ResetKey.ExpiresOnDate field

2021.8.11.1740

8/11/2021 9:41 PM

Fixes

• Load instructions are overwritten by comments in api3PLexternal.AddUpdateTrip

2021.8.11.1244

8/11/2021 4:48 PM

Fixes

• NullReferenceException in AssetTracking.CheckIfAssetIsInactiveBySerialNum
• Load instructions are overwritten by comments in api3PLexternal.AddUpdateTrip

New

• Add BeginTotalizer and EndTotalizer columns to FuelOrderDetailInventory table schema and DAL
• Add DisplayOrder column to FuelOrderDetailTaxes table

2021.8.6.1854

8/6/2021 11:00 PM

New

• Add RTA to the list of orders on a trip in RouteBuilder - so dispatchers can see what time orders were delivered
• Add performance tuning index on inventorytxns

2021.8.6.1823

8/6/2021 10:23 PM

New

• Add ability to search for orders by BOL

2021.8.4.2214

8/5/2021 2:19 AM

New

• Add files for orders as clickable links on the R219 report and in the R0045 delivery receipt std
• Add vendor-terminal mapping to terminal edit. Allows vendors to be assigned to terminals.
• Add depot-terminal mapping on depot edit form. This allows assigning a subset of terminals to an individual depot.

2021.7.30.1418

7/30/2021 6:24 PM

New

• Log all external API requests
• Add API for adding loads without a trip
• Update APIdocs to include AddUpdateTrip and AddLoadWithoutTrip

2021.7.29.1719

7/29/2021 9:23 PM

New

• Add external API method to create loads without trips
• Add form to manage splash blending of products (product blending on the truck to combine 2 products and make a 3rd)
• Add line notes for order details in 3PL API to get orders/trips so they can be used in the 3PL app

2021.7.28.1028

7/28/2021 2:30 PM

Fixes

• Trailer import fails when looking for "fuelcapacity" column

2021.7.27.1859

7/27/2021 11:05 PM

Fixes

• When saving a trip the first time, if a driver is not assigned, you receive an error message because it cannot send a notification of assignment

New

• add additional auditing and logging for BDP driver incentive requests
• Change system job that adds default system preferences to always use our latest comments (overwrites customer notes) so descriptions are accurate and clear
• Update Epicor P21 monitor to include supplier_order_no when sending orders for routing
• Add release# to R0045 Delivery Receipt Std (also used as a sales order#)
• Return credit status of customer with mobile POD Customer Search results
• Add list and editor for product compatibility mapping

2021.7.21.1826

7/21/2021 10:31 PM

Fixes

• Saving asset readings in mobile POD API can cause PK violations in the database
• API to GetLoadsToExport fails if the terminal is not set (should not have completed loads without terminals) - but this needs a guard in case someone manually changes loads

New

• Add asset compartment information to mobile OrgAsset reference data

2021.7.20.1707

7/20/2021 9:13 PM

Fixes

• MobileHub installs prior to 2017 may fail schema update if missing QA related tables (e.g. QAFuelOrderDetailInventory) - should check to conditionally remove them

New

• Update logic to get Terms of Service based on whether the user is on a hosted SaaS server or on-premise
• Add driver and truck info to the order section for R219 trip summary (to make it easier when invoicing from this report when a trip has a large # of orders)
• Add product compartment and type to manage compartment capacities

2021.7.16.1855

7/16/2021 11:00 PM

Fixes

• API3PLexternal to DeleteTrip returns an error that the entity is deleted from the db and cannot be used - this is a misplaced log after deleting the trip.
• Inactive products can be added to the charges and fees list for mobile orders

New

• [Mobile API] Include customer contacts with trips and new orders
• Add company preference setting for the default hours window for starting a trip via 3PL API (default = 12 hrs)
• Add driver and phone to OrtecV3 realization - so they are sent when using the 3PL mobile app by 3rd party carriers

2021.7.12.1753

7/12/2021 9:54 PM

Fixes

• Add project management list and edit back into MobileHub to allow for storm fueling projects

2021.7.9.1807

7/9/2021 10:13 PM

Fixes

• CommandAlkon API - when exporting/creating orders, only the first line item should be marked as primary

2021.7.9.1002

7/9/2021 2:08 PM

Fixes

• [Jacobus] Charges request date(s) can come in with a value of DateTime.MinValue

New

• Add customer contacts API to allow add/update, delete and query for contacts

2021.7.7.1908

7/7/2021 11:14 PM

New

• Change OrtecOIRv3 to realizations to send pre/post trip odometers readings as integers vs doubles

2021.7.7.1859

7/7/2021 11:05 PM

New

• Add default of "cylinder" to tank type list if there are not tank types defined
• Return trip_shortcode in API to AddUpdateTrip for PODData - so this is available in all API environments, not just 3PL

2021.7.6.1709

7/6/2021 9:15 PM

New

• In PODData.CreateOrder, look for a parameter indicating that re-fetching assets is not required.

2021.7.3.1230

7/3/2021 4:36 PM

New

• Add SalesOrderQty to API AddUpdateTrips - used so one sales order with multiple fulfillments (pick tickets) can show the original order qty on receipts

2021.7.3.1206

7/3/2021 4:07 PM

Fixes

• Concurrency error in PODData.AddUpdateTrip

New

• Add "Transient" asset type in asset creation type list

2021.6.30.1910

6/30/2021 11:14 PM

Fixes

• Unit filling max value should be > 50,000 to accommodate liters where you have a tanker and a pup

New

• Add "ExpiresOnDate" to ResetKey table
• Ortec OIR integration should always include isFull, percentFull and reason code for extra data related to tanks

2021.6.29.1810

6/29/2021 10:15 PM

New

• Add R236 - EventLog report - to show events over a date range, by depot
• Ensure all CSV import fields use common names such as capacity and DoNotFill
• Update EventLog section of R212 Daily Ops Report - include more info on associated objects
• Add ability to filter load list by depot and truck, and in the results

2021.6.28.1659

6/28/2021 9:04 PM

Fixes

• API to AddUpdateTrips does not handle loads correctly when compartments are specified and there are multiple lines for the same product

New

• Update Jacobus tax/pricing provider to include the order date in the request
• Add better error handling for timeouts on audit screen - when search over large resultsets

2021.6.28.1030

6/28/2021 2:35 PM

New

• Add option to create default email settings for Office365 for email testing
• Add additional connection logging for DM2 Rosetta API monitor
• Show duration on order edit when changing planned (ETA/ETD) or actual (RTA/RTD) times
• Remove unused tables (related to lease and asset management/audits) - modules are no longer supported

2021.6.24.1833

6/24/2021 10:39 PM

New

• Unit filling audits should be logged at the line detail level and include add/update/delete audit info

2021.6.24.1138

6/24/2021 3:43 PM

Fixes

• PODData.PostEvent can throw exceptions when the event description is too long
• When changing the driver on trip edit, ensure that driver is also reassigned to all orders that have not started
• Do not notify drivers of trip updates if the trip is ended (e.g. editing after completed)

New

• Add driver and truck to the export orders control/workflow
• Default new asset to vehicle when creating from asset list (add new) since this is the most common selection
• Streamline trip search - remove not started and not ended search options since these can be seen in resulting grid
• Add tank capacity to equipment attributes edit form

2021.6.21.1902

6/21/2021 11:08 PM

New

• Add barcode to api3PLexternal methods that export unit filling (get orders methods)

2021.6.21.1058

6/21/2021 2:59 PM

New

• Extend length of terms field in orders to accommodate longer values/text

2021.6.21.918

6/21/2021 1:23 PM

Fixes

• API AddUpdateOrdersWithoutTrips does not emit correct error messages if multiple errors

2021.6.20.1021

6/20/2021 2:25 PM

Fixes

• Search control does not remember the most recently used search (by filter) if the value is empty. Always skips empty last search for filter field.
• Import tanks from CSV does not set the customer field when importing

New

• Ortec Big Data Portal DIP provider token should include a payload
• Update R215 Pick Ticket to show harmonized (customer item description) if different than item description in order detail section
• Remove the following fields from asset list search based on lack of use - warranty, purchased from/to
• Update nightly job to remove unused preferences (legacy)
• Ensure data import tool used IsEnabled for all import formats (for consistency in templates)
• Add ExternalID as a field for all data imports from CSV

2021.6.18.958

6/18/2021 2:04 PM

Fixes

• GeneratePODUrl adds an extra / if the url is not set in the company config

New

• Add method to automatically generate API documentation
• API GetLoadsToExport should default the supplierID and name to the Org if not set (which happens if the driver rejects a line to load)

2021.6.15.1624

6/15/2021 8:29 PM

New

• Update Epicor P21 order monitor to include line items with disposition 'C', when the order is not cancelled. 'C' cancels all remaining p21 qty on the line, but not the line if there is qty allocated.
• Update Ortec OIRv3 interface to use a list of order types (CSV format) to identify package vs bulk orders

2021.6.14.822

6/14/2021 12:23 PM

Fixes

• Nightly job to check expiring licenses should skip tenants that do not have a license assigned
• Scheduled job to ExportPODsToFTP should skip and log orders that cannot generate a POD
• Order reconciliation does not map the 'driver added orders' correctly. And the label should specify 'driver added orders' for clarity

New

• Send all inventory on truck/trailer to OIR in integrations
• Remove time component on load date in load edit form. Use eta/etd for exact times

2021.6.10.2136

6/11/2021 1:38 AM

New

• For inventory snapshots posted from mobile, add indicator that the product is on the current trip
• Job to export orders to NetSuite should add a default option to exclude COD orders
• 3PL API to export orders marked reviewed - should allow exporting manually entered orders without assigning to a trip

2021.6.9.1415

6/9/2021 6:21 PM

Fixes

• Add reference to hangfire.core in trip reconciliation form

2021.6.8.1858

6/8/2021 11:04 PM

New

• Fix layout in org edit to use full screen when available

2021.6.8.949

6/8/2021 1:55 PM

New

• Add copy tripcode option on order edit form - when trip editing is disabled

2021.6.7.1907

6/7/2021 11:13 PM

New

• Add number of meters to vehicle import

2021.6.7.1854

6/7/2021 10:55 PM

Fixes

• Truck/Trailer inventory returned to mobile doesn't have enough product information
• CSV data import for equipment fails mapping equipment attributes

New

• remove Depot and IsMeteredVehicle from vehicle and trailer import file spec
• Update CSV vehicle import to only include customer assets. Add separate import for fleet vehicle import
• Add new import for fleet delivery vehicles

2021.6.7.1134

6/7/2021 3:40 PM

Fixes

• Service charge items added when querying back-end systems aren't set "Enabled"

New

• Include Customer Name with Ortec Big Data Portal order object
• Update tank forecasting methods in tank edit form

2021.6.4.1732

6/4/2021 9:36 PM

Fixes

• biztalk order export job uses the wrong day of week
• Get pricing and taxes during post order and get trip are not correctly coalescing customer item id with the inventory item ID

New

• Add parameter to API GetLoadsToExport - param = require_review_to_export - so optionally only reviewed loads are exported
• Add setting to company config always_email_pod_to_cc. Always send a cc/to email even if the customer opts out on mobile, so email archives will receive copies.

2021.6.3.1517

6/3/2021 7:23 PM

Fixes

• Customer Import API - RelatedAssets Key is not mapped
• POD report R0045_DeliveryReceiptStd_AssetRollup sums up delivery total incorrectly
• Trip reconciliation fails if trip is not ended. Should not be able to run if the trip is not complete.

New

• Orders created in the field should be added to the trip on the server
• Make setting things like company SMTP server settings more clear

2021.6.3.1443

6/3/2021 6:48 PM

Fixes

• in mobile POD API, StartTrip, EndTrip, GetTrip don't use the the correct UTC offsets

New

• Add mobile API method to get tax components for an order
• Update PostOrder mobile API to include inserting line item taxes
• Evaluate line item pricing and taxes when mobile gets trip updates
• Add Jacobus provider for getting pricing, taxes, and charges/fees
• Add suppliers to the list of columns in the load list

2021.6.3.1117

6/3/2021 3:22 PM

Fixes

• Weekly job to shrink signature images or remove after XX days can hang if transaction log size is set to a hard max value
• Add unit filling asset does not filter correctly if the related assets key is empty - should include the current customer
• Trip reconciliation layout overlaps out of band deliveries with the order list
• Load list does not filter on terminal name (only terminal ID)

New

• When processing a truck-truck transfer, make sure to update target vehicle post-trip BOL and compartment inventory
• Add reconciled status in the order list
• Add link to reconciliation status and messages on order edit form
• Add release# to POD report R0045_DeliveryReceiptStd_WithTankFull
• Add IsReviewed flag to Loads so they can be filtered before exporting to ERP systems

2021.5.28.1704

5/28/2021 9:10 PM

Fixes

• Edit vehicle asset has error when loading due to mis-mapping of max capacity with fuel capacity for a vehicle
• Order reconciliation should skip orders that are not posted (delivered) even if manually requested for reconcile check

New

• Add TagID to import equipment and trailers from CSV

2021.5.27.2311

5/28/2021 3:12 AM

Fixes

• Order reconciliation should not check totalizers for lines that are services or fees
• Order reconciliation does not show negative volume passed (not bound to correct property)

New

• Show IsPosted and Exported in the order list and in the order list inside a trip
• Trip reconciliation should check sum of unit filling and compare to totalizers with customer deliveries to validate trip totalizers

2021.5.25.2202

5/26/2021 2:09 AM

Fixes

• POD API for adding trips, loads, orders doesn't respect load item compartment

New

• Add TagID to ImportVehicle fields for CSV import tool
• Add externalID to API3PLexternal AddUpdateOrderWithoutTrips - to set the value for each order

2021.5.24.1858

5/24/2021 11:04 PM

Fixes

• Import data - tank import mislabeled the key for assetID causing an error on import (key missing)

New

• In order reconciliation - check if there are lines missing sale #'s if the truck or trailer is metered and uses the OBC

2021.5.21.1914

5/21/2021 11:21 PM

New

• Add audit records for requests to external pricing providers
• Add ortec_config to company configs. Set property to determine if MH should email when drivers add items to orders
• Migrate ortec setting to mark orders as exported from a config to the ortec_config and default to FALSE

2021.5.21.1454

5/21/2021 7:00 PM

Fixes

• Edit form for vehicles should show fuel capacity

2021.5.21.1305

5/21/2021 5:12 PM

Fixes

• When posting an order, check customer contacts to see if there are POD recipients. If so, always email them even if the customer opted out on the mobile
• Confirm that we are using the customerItemID (Sold-as product) to get pricing from JDE at Jacobus
• Jacobus - Look at item pricing not shown in MH after a showprice order is posted.
• Trailer asset tank capacity not being set when new trailer assets are added in the field

New

• Add nightly job to set all asset capacity = attribute (tank, vehicle, equip, trailer) capacity. If not set, use zero as default
• Improve detail information on order reconciliation messages to make it easier to see/investigate order issues
• Add order reconciliation check to see if meter sale numbers are not sequential (skip) on a given order

2021.5.20.1726

5/20/2021 9:33 PM

Fixes

• api3PLExternal.ExportPostedOrders_byFilter and GetOrdersToExport_MarkedReviewed doesn't export BOL numbers on order details
• Fix docking issues in Trip Edit form - reconciliation tab

New

• If pricing and charges provider returns an error in PostOrder, set PricingError on order entity to "true"

2021.5.19.1354

5/19/2021 6:00 PM

Fixes

• POD PostOrder lacking instrumentation
• Show Price On Ticket for order doesn't copy when trip is copied
• Trailer tank capacity is not coalesced when querying for customer assets for download to mobile
• Customer Assets list does not show the coalesced capacity from the underlying attribute (vehicle, tank, equip, trailer)
• Customer asset list in customer edit form filters using customer and assigned site - site filter should be removed
• Data import should use acct# and assetID as the compound key when importing tanks, trailers, vehicles and equipment

New

• Add tips for each type of CSV data import when using the Data Import tool.
• Add method to ImportEquipment from CSV file
• Show terms on order edit form
• Add terms to AddUpdateTrip API for each order
• AddUpdateTrip API should check for ShowPriceOnOrder changes to determine if order needs to be updated

2021.5.17.1916

5/17/2021 11:24 PM

Fixes

• AddUpdateCustomer API should only match on account number to see if a customer exists (not name)

New

• when posting trips to the Big Data Portal, include posted orders with the payload
• Add company config setting to ePOD_config_per_customer to enable different reports based on order type (e.g home heat vs lubes or fuel)
• Add flag to autoemail PODs to 3PL API (per order/customer setting)
• Order detail edit should toggle pieces vs bulk unit size based on UOM changing in addition to item changing (to handle manual overrides of UOM)

2021.5.14.923

5/14/2021 1:30 PM

Fixes

• Import data utility - import vehicles should require customer account number to ensure fleet assets are mapped to a given customer

New

• Import data - import vehicles should include unitnumber to allow assets to rollup

2021.5.13.1619

5/13/2021 8:21 PM

Fixes

• api3PLExternal.GetOrdersToExport_MarkedReviewed throws an exception for orders not on trips

New

• Add integration to Ortec Big Data Portal for driver incentives

2021.5.13.1230

5/13/2021 4:37 PM

New

• Add UnitNumber on ImportVehicle data import - to support rolling up fleet assets (driver, passenger, refer) tanks

2021.5.11.1816

5/11/2021 10:22 PM

Fixes

• Method to recalculate trip time and distance should return the trip without calcs if a site (depot) is not assigned to the trip

2021.5.10.1817

5/10/2021 10:24 PM

New

• Add start trip time window preference to default preferences
• Add property to customer allowNewAsset to tag through the AddUpdateCustomer API - if set to true, allow drivers to add assets, if false then no new assets by drivers
• In RouteBuilder, alllow multi-select in orders to remove from a trip (remove orders from trip)

2021.5.7.1834

5/7/2021 10:41 PM

Fixes

• If pod_url is not set for the company config, the URL for customers does not include the base server. Set defaults if not present.

2021.5.6.1703

5/6/2021 9:10 PM

New

• Accept COD flag when creating new orders from mobile
• Add load comments to load section of r219 report

2021.5.6.1659

5/6/2021 9:01 PM

New

• Add parameter to job that emails PODs to conditionally send only if marked 'reviewed for export'

2021.5.6.1422

5/6/2021 6:29 PM

New

• 3PL API to AddUpdateOrders may skip a new customer if it does not detect changes

2021.5.5.1842

5/5/2021 10:49 PM

Fixes

• Calculating trip time and distance should skip calcs if there are no orders on the trip

2021.5.5.1829

5/5/2021 10:36 PM

New

• In RouteBuilder - show special instructions if order has comments or internal notes (and highlight)

2021.5.5.1754

5/5/2021 10:01 PM

New

• Add ShipVia field to the unrouted orders in RouteBuilder so dispatchers can see/filter orders scheduled by 3rd party carrier, salesman deliver, etc.
• Add depot in the RouteBuilder unrouted orders so dispatchers can see/filter by multiple serviced by depots
• Update API3PLexternal AddUpdateOrders method to set serviced_by_depot at the order level to support customers serviced by multiple depots
• Add files tab to messageQ edit to view/edit attachments to messages

2021.5.4.1411

5/4/2021 6:17 PM

New

• Add ShipVia property to orders to denote if shipped by 'our truck', '3rd party', 'salesman', etc
• Add ServicedByDepot reference to orders to support same customer serviced by different depots

2021.5.3.1712

5/3/2021 9:19 PM

Fixes

• Default reconciliation settings for trips and orders will not save if not initially set manually

2021.5.3.1329

5/3/2021 5:36 PM

New

• Epicor P21 processor should look at all open orders when finding 'ready to route', including those with zero allocated or picked (could have qty backordered)
• Epicor P21 processor should calculate order qty as priority1: qty_on_picket_tickets and priority 2: qty_allocated
• API3PLexternal AddUpdateOrders should allow reusing order #'s when there is a backorder qty even if order qty is zero

2021.5.2.1611

5/2/2021 8:18 PM

New

• Routebuilder should highlight orders that have internal special instructions so dispatchers know to look before routing

2021.4.30.1713

4/30/2021 9:20 PM

New

• Add db tuning for reports associated with trips, orders, and event (ex. zero delivery)

2021.4.30.1223

4/30/2021 4:29 PM

New

• Add parameter to enable sending PreDelivery Notifications (ASN) by depot - different template per depot

2021.4.29.1858

4/29/2021 11:05 PM

New

• Add option in job arguments to always CC: an email list when sending POD receipts

2021.4.29.1611

4/29/2021 8:18 PM

Fixes

• Job to create PODs (MessageQAutoEmail) does not correctly separate emails if their is a primary email and multiple contacts

2021.4.28.1914

4/28/2021 11:21 PM

Fixes

• Load data is not always populating in the R219_LoadedvsOrdered sub-report
• Org reconciliations settings do not align with the checkboxes for each setting

New

• Sending inventory snapshots to Ortec OIR should go through v3 interface vs v1
• Add non-delivery inventory sub report to the non-depot R219 report

2021.4.27.1754

4/27/2021 10:01 PM

Fixes

• AddUpdateTrip API should perform a deep inspection on loads and load details (itemIDs) to determine if the load is updated. Ensures updated load is applied.

2021.4.27.1105

4/27/2021 3:11 PM

Fixes

• Ortec OIRv3 integration does not send order and load rejections to OIR because the trip has already been removed from them

New

• Create 219_NonDeliveryInventory sub report and add to R219_TripSummaryActuals_ByDepot report
• Epicor P21 processor should optionally look at order requested date when cancelling and completing orders (based on config)

2021.4.26.1841

4/26/2021 10:47 PM

Fixes

• API3PLexternal AddUpdateTrip should not allow duplicate order numbers. Only process the first copy
• Update R219_StartingEndingInvetory report to display all products on the order

New

• Add method to return the last post-trip totalizer for a vehicle
• Update trip and order reconciliation logic

2021.4.22.1022

4/22/2021 2:29 PM

Fixes

• api3PLexternal.GetLoadsToExport fails when trip actualvehiclerefid is null
• Update file service API to handle longitude as gpslong and gpslon to ensure GPS is captured
• Update job to export files to JSON contents to always serialize null values

2021.4.19.1709

4/19/2021 9:15 PM

New

• Update Epicor P21 integrator to only send orders to route if they have line items with qty > 0

2021.4.16.1319

4/16/2021 5:25 PM

Fixes

• Company logo can fail to upload if loading improperly formatted JPEG files

New

• Send order ReleaseNo to mobile when trip updates are requested
• add planned miles, duration and qty to the trip API so they can be used when calculating driver metrics with external routing systems

2021.4.14.1725

4/14/2021 9:27 PM

New

• Add link on fuel order form to resend email to customer

2021.4.14.930

4/14/2021 1:34 PM

New

• Update system jobs to purge inventory history and audits to use batches versus single transaction sets to run in smaller chuncks

2021.4.12.1909

4/12/2021 11:15 PM

Fixes

• Copying an order's previous details should not copy BOL from last line item
• When "assets.donotfill" is null, mobile "staleness" checks fail.

New

• Validate orders to ensure itemID and itemDescription are populated in API AddupdateTrip PODData. Fail whole trip if any orders or loads fail validation.
• Validate driver email and phone before changing in API to AddUpdateTrip in PODData

2021.4.1.1810

4/1/2021 10:14 PM

New

• Tune performance of APIexternal method ExportPostedOrders_byFilter for larger result sets
• Add full text search in system audit - use SQL Server full text

2021.3.29.1852

3/29/2021 10:58 PM

Fixes

• API GetLoadsToExport can fail if a trip is not assigned to a depot. If that happens, use the truck's depot

2021.3.26.1711

3/26/2021 9:15 PM

New

• Add job to import Centeron tank readings via their web API

2021.3.25.1730

3/25/2021 9:36 PM

New

• Add IsPreferred field to PointsOfInterest table
• Add migration for ApiKeys table
• Setup new tenant should invoke process to add default configs and params

2021.3.24.1842

3/24/2021 10:48 PM

Fixes

• User list control has an alignment/anchor issue with the site list
• Update job to send predelivery notifications to allow sending same day when days_ahead=0

2021.3.22.947

3/22/2021 1:53 PM

New

• Add job to export posted orders to NetSuite using Netsuite web API (export with API GetOrdersToExport_MarkedReviewed)

2021.3.22.513

3/22/2021 9:15 AM

New

• Update DM2 interface to import primary bin location for each warehouse so pick tickets show the what bin to use

2021.3.19.1156

3/19/2021 4:02 PM

New

• Update DM2 export for GenerateInvoices to group lubes orders by warehouse code

2021.3.17.1439

3/17/2021 6:45 PM

Fixes

• Update custom reports to mark as content vs compiled - custom templates are read at runtime

New

• RouteBuilder should adjust estimated trip time if there are multiple orders to the same customer. 2nd thu N should be at half time to more accurately estimate trip time
• Add RelatedAssetsKey to api3PLexternal when adding or updating customers. This allows grouping related ship-to locations
• Update 3PL api's to use dataportal so changes are audited

2021.3.16.532

3/16/2021 9:39 AM

New

• Change timeout on nightly job to purge debug audits - 15 mins per org

2021.3.16.502

3/16/2021 9:09 AM

New

• Update site check to better test database status for app monitoring (ensure write as well as read)
• Add mobile API method to get tax components for an order
• Add API method to mark orders complete from external systems (so they are removed from routes)
• Enable deleting trips from the RouteBuilder trip list if trips do not have orders, loads or activities assigned
• Update Epicor P21 monitor filter items not to route, such as DFOA fees.
• Update Epicor P21 monitor to include orders with back ordered quantities so they are visible in the Routebuilder (BO=highlighted)

2021.3.15.1113

3/15/2021 3:20 PM

Fixes

• Update job z_driver_shift_report to calculate the last ending time
• Update api3PLexternal api's to set datatimekind.utc for all dates, so conversion to localtime is correct (on ETA and ETD)

New

• Update api3PLexternal to audit all core data changes (trips, customers, order, loads, activities) using standard DataPortal

2021.3.11.1222

3/11/2021 5:28 PM

Fixes

• Order edit allows assigning to an inactive user. Should only filter on active users.

2021.3.7.2223

3/8/2021 3:29 AM

New

• Add option to print pick ticket directly from the RouteBuilder
• Add company config for order status to "do not route". In RouteBuilder, highlight these orders and display a message to prevent routing

2021.3.7.1534

3/7/2021 8:40 PM

New

• Show route zones as a dropdownlist in RouteBuilder
• Tooltips for orders in Routebuilder should auto-resize based on content so they do not wrap text
• Add PrimaryBin to order details to know which bin should be used for picking. Populate from 3PL external API

2021.3.7.949

3/7/2021 2:55 PM

New

• Increase length of routezone and related ship_to fields (market, submarket, county, carrierrte)

2021.3.5.1803

3/5/2021 11:10 PM

Fixes

• AddUpdateTrip in api3PLexternal may add an order or load a second time with duplicate order#'s

2021.3.4.1649

3/4/2021 9:56 PM

New

• Add "Terms" from FuelOrderEntity to the order DTO presented to the mobile
• Add menu link in lookups edit to delete lookup
• Set entry in global app startup to support TLS1.2, TLS1.1 or TLS

2021.3.4.1045

3/4/2021 3:51 PM

Fixes

• Update job to ImportAppian orders - fix shipto zipcode not mapping correctly
• Reset Key list in MobileHub Legacy shows used keys
• Start trip should only check for duplicate assets based on the asset type (vehicle or trailer). Start trip fails if duplicate assetIDs exist.

New

• Add job argument to ProcessMessageQ to force all emails to a single address. This allows testing emails in production with customers, but always sending to one internal email address.
• Add job arg to allow including each customer's sales rep when sending ASN (advanced ship notification) emails.
• Add option to add prefix and suffix to order number for schedule job: ExportOrdersToCsvFTP
• Add filter ordertype_filter to API method ExportPostedOrders_byFilter to enable exports by order type
• Add config setting to determine if GPS events should be forwarded to external systems such as Ortec
• In RouteBuilder, lock column width of Order# in stop list so it is always displayed in full

2021.2.27.1810

2/27/2021 11:17 PM

New

• Update OrtecV3 integration to use config setting -ortec_include_trips_from_these_users - to send trips to Ortec ONLY if created by this list of users ( or blank created_by)

2021.2.25.1254

2/25/2021 6:00 PM

New

• Add mobile API methods to return POIs by category and/or distance
• Add created_by and created_at to Trip to know whether it was created by a user or an API call

2021.2.23.2033

2/24/2021 1:36 AM

Fixes

• R219 Trip Summary report should use order RTA/RTD and load RTA/RTD in each detail (versus trip start/end)
• Orders created in the field (by drivers) do not set the correct Bill To Name

New

• Add unit filling record details to 3PL api to export orders marked reviewed
• Add tooltip in RouteBuilder - show order line items when mouse over orders on a trip
• Update nightly job to purge messageQ work items that are older than 90 days (purge even if not processed)
• Add PointsOfInterest table to support fuel location lookups for company authorized fueling

2021.2.19.1818

2/19/2021 11:25 PM

Fixes

• Start and post activity should handle the case when an activity does not exist on the server.

New

• Add parent customer name, related assets key, and customer external ID to 3PL APIs to export orders
• Add support to add activities on the mobile to support fueling, breaks, etc. as an official trip action (counts on trip time)

2021.2.19.1053

2/19/2021 3:59 PM

New

• Add R232 - Truck2DbarcodeByDepot report - prints QRcode to pair handheld to truck (when moving to a different truck)
• Update permission process so any authorized user can run a job - does not explicitly require individual job permissions
• Add flush location (incl customer waste tank) for R231 Flush Report By Depot
• Update job to CalcTripMetrics to handle tenants who may manually edit trip data (start/end times, drivers, etc.) and cause the job to not calc for a given trip
• Add ReportRoles to migrate system report access to Raptor web client

2021.2.14.1723

2/14/2021 10:25 PM

Fixes

• OIRv3 interface to post completed orders to Ortec can fail on package goods due to item not being fetched
• Legacy goRoam clients can't post orders

New

• Add OBC Config information to OrgAssets in the mobile reference data

2021.2.11.1904

2/12/2021 12:11 AM

Fixes

• OIRv3 interface to post completed orders to Ortec can fail on package goods due to item not being fetched

2021.2.11.1713

2/11/2021 10:19 PM

New

• Increase TerminalID length to 250 chars for larger names

2021.2.11.749

2/11/2021 12:56 PM

New

• OIRv2 integration should include payment amount and paymentID in message

2021.2.10.1809

2/10/2021 11:16 PM

Fixes

• When copying a trip or creating recurring trips, if the original order detail has a null UOM, the copy process should revert to the item to get the UOM
• Create new object (trip, order, etc) from a base list control, and then closing without saving, will cause an error
• Customer Item mapping does not show new items after they are added.

New

• Update PostOrder mobile API to include inserting line item taxes
• Add GPS lat and long to API3PLexternal when getting completed orders
• Add pod_url API3PLexternal when getting completed orders - this is the external URL that is used to uniquely access an order by customers

2021.2.10.1118

2/10/2021 4:25 PM

New

• Add Order Detail Taxes table to support multiple taxes per line item - such as excise, county, local, etc.

2021.2.8.1838

2/8/2021 11:45 PM

Fixes

• CheckInstallation shows "send message fails" if SMTP_SENTFrom or CheckInstallationEmail are not set

New

• Add "do_not_exceed_flag" to the API AddUpdateTrips line items to denote the order qty will stop the meter at that qty
• Add customer_comments field to API AddUpdateTripNoGuids so comments can be pre-populated
• Add order instructions and customer_comments to export API's
• Add 'show price on order' to the order table and API to AddUpdateTripNoGuids
• Add meter_sale_no to the 3PLexternal API for retrieving order data (GetOrdersToExport_MarkedReviewed and ExportPostedOrders_byFilter)

2021.2.5.1332

2/5/2021 6:38 PM

New

• Add truckID and trailerID to order export in api3PLexternal methods (add to each order)

2021.2.3.1834

2/3/2021 11:41 PM

Fixes

• Update R0045 Delivery Receipt Std to account for duplicate order numbers and filter for only the current one

New

• in mobile POD GetTrip API method, If order has no instructions, pull customer notes
• in Mobile POD GetTrip method, return item DOT and EPA codes in the trip items collection
• Update map cache cleanup process to keep the cache size small and tidy
• Update API method ExportPostedOrders_byFilter to allow filtering by trip start or order start using use_trip_startdate (default is false)

2021.1.29.1837

1/29/2021 11:44 PM

New

• Add company config ortec_mark_posted_orders_as_exported to determine if Ortec realizations mark orders exported (set = false if MobileHub sends completed orders to the ERP)
• Add JSON API to ExportLoads and mark them exported for external systems (load and load details with BOLs)
• Revise API Method BrokerXMLtoJSON to post directly to the requested API versus calling via the web service

2021.1.28.2029

1/29/2021 1:35 AM

Fixes

• SendMessage fails if SMTPSSL config parameter is missing or not correctly formatted

New

• Add data import for Customer Contacts in the Import toolset
• Add R231 Flush Report - to show flush activities by driver, product and depot over a date range

2021.1.25.1843

1/25/2021 11:49 PM

New

• Add created_on date field for items and add to item edit form

2021.1.25.1526

1/25/2021 8:33 PM

Fixes

• OrtecOIRv3 "starttrip" realization message has invalid element

New

• Add barcode generator service to return images for POD reports

2021.1.22.833

1/22/2021 1:40 PM

Fixes

• Licensed apps list doesn't refresh correctly when a new license is applied

New

• Return blending matrix products with mobile items collection
• Return product blending matrix with mobile reference data

2021.1.20.1704

1/20/2021 10:10 PM

Fixes

• Dispatcher role can have duplicate security items as part of the dispatch->dispatcher migration. Nightly job should remove duplicates

New

• API to AddUpdateTrips should check if PO number (alternate order number) has changed to determine if orders need to be updated or skipped (no changes)
• Add job to post order URLs to SAP web service

2021.1.19.1509

1/19/2021 8:19 PM

New

• Update Symbology export job to exclude commas in driver instructions and skip orders where the trip is started since Symbology is batch only
• Add service and fee products to items collection returned with trip
• Add tables to support compartment configuration and product blending matrix for splash blending

2021.1.14.1300

1/14/2021 6:08 PM

New

• Ortec OIRv3 interface should use updated/consolidated method names for OIR

2021.1.13.1552

1/13/2021 8:59 PM

New

• Ortec OIRv3 interface should use updated/consolidated method names for OIR

2021.1.13.951

1/13/2021 2:55 PM

Fixes

• API3PLexternal method ExportPostedOrders_byFilter should throw an exception and return an error if an order is complete but NOT assigned to a trip (in cases where manually rejected or unassigned)

New

• Upgrade all DevExpress controls to v20

2021.1.8.839

1/8/2021 1:45 PM

New

• Add Mobile API method to get the last post-trip odometer for the selected vehicle
• Add backorder qty and "unit conversion" (1 @ 55G drum = 55 gals) to AddUpdateOrder API
• RouteBuilder unrouted order well should highlight orders with backorders, tooltip should highlight backorder line

2021.1.6.1254

1/6/2021 6:01 PM

Fixes

• R0037 Customer Fleet Fueling Report should coalesce parent acct# and acct# to null to ensure it finds all assets

New

• Change CustomerPortal/EntityImage page to support PDF
• Move custom report handler to use standard job to AutoEmailInvoice
• Add option to test mail SMTP settings directly on company form

2020.12.30.1859

12/31/2020 12:05 AM

Fixes

• Message edit form does not scale the message status box when resizing the window
• Update web method to use default Terms of Service if not setup for a specific tenant

New

• Separate preference for ASN and autoemail POD
• Update external API to AddUpdateItem for adding products

2020.12.30.1603

12/30/2020 9:10 PM

New

• Add lookup of customerType 'National' so all tenants have at least 1 type of customer

2020.12.30.1211

12/30/2020 5:18 PM

New

• Change AssetID length to 128 for larger values from customers or trucks
• Update mobile POD API to return a "preferred culture" in orders
• Update customer emails (POD, ASN, etc.) to use language specific to their ship-to (french, spanish, or english (default))
• Add columns to AssetFleetAttributes table for meter ip address and whether to use all calibrations

2020.12.29.1339

12/29/2020 6:46 PM

New

• Add preferred language (culture) to customer ship-to for support of different language emails and PODs

2020.12.28.1838

12/28/2020 11:45 PM

New

• Add customer ItemID on order detail edit to support harmonized products
• Eventlog email should show additional fields for order info, display event timezone info, customer and depot
• Add UI to geocode vendors and view on a map, like with customers
• Add ability to geocode terminals
• Migrate all MapQuest mapping requests to HERE maps (deprecate MapQuest MQ)
• Add "Equipment" to list of new asset types in asset list control
• Add a filter to the audit list to filter "mobile only" audits
• Add batch geocode function to terminal list

2020.12.27.1745

12/27/2020 10:52 PM

New

• Add BillName to customer CSV data import
• Translations control needs to support removing translations and label renaming

2020.12.23.1821

12/23/2020 11:27 PM

New

• Update Texada API interface to create a new line item for each asset filled when creating an invoice

2020.12.23.1559

12/23/2020 9:06 PM

Fixes

• Background task for clearing map cache tiles can run during non-peak hours and cause the app to crash (between 1-3am local)

2020.12.22.1828

12/22/2020 11:35 PM

New

• About form should use new database version info - migrate from legacy version methods

2020.12.22.1327

12/22/2020 6:33 PM

Fixes

• Map cache cleanup could cause app to crash if accessing a map at the same time

New

• Add Customer Order History to sales support customer fetch
• Inventory location should show only non-zero inventory
• Add R230 Report - inventory loaded, delivered, received by depot
• Add R219 trip summary report by depot - and tune for better performance

2020.12.17.1109

12/17/2020 4:16 PM

New

• Add R229 report to show tank deliveries with less than 50% (configurable param) delivery efficiency

2020.12.15.1806

12/15/2020 11:13 PM

New

• Update ad hoc view TankFillPercent to use maxfill if available, capacity if maxfill is not set

2020.12.15.1543

12/15/2020 8:51 PM

Fixes

• Modifying trip "metadata" doesn't increment the trip's version

New

• Create new OIR v3 interface
• Add R228 Tank Delivery Efficiency report - to show % filled versus capacity

2020.12.14.1532

12/14/2020 8:39 PM

New

• Create API for goRoam SalesSupport
• Add text options to contacts for ASN, POD and driver on the way notifications
• Add externalID to order edit form - to map to external systems identifier for orders

2020.12.14.1449

12/14/2020 7:56 PM

New

• Return goRoamMessage along with details of authentication failure to make it easier for 3rd party API access to determine auth failure due to credentials (in addition to returning 403 status)

2020.12.11.1746

12/11/2020 10:50 PM

New

• RouteBuilder should autosize all columns for orders in the order well - add horizontal scrolling if needed
• Add ad hoc view for tank fill percent to show fill efficiency across depots (need for use in the dashboard)

2020.12.10.1214

12/10/2020 5:21 PM

Fixes

• App can crash when multiple services are trying to render maps (RouteBuilder, Orders, etc) and the mapcache file is locked

2020.12.9.1842

12/9/2020 11:50 PM

Fixes

• When removing an order from a trip in the RouteBuilder, the order should revert to its original ETA ETD

New

• Add street as a filter in the order list
• Add acctNo as filter in R0038 Customer Fleet Fueling Report
• Importing orders from DM2 should reset the internally tracked original ETA so it can be used if orders are added/removed from trips in RouteBuilder

2020.12.8.1926

12/9/2020 12:33 AM

New

• Add Asset latitude,longitude to AssetDTO
• Add release number to the order edit form

2020.12.7.1001

12/7/2020 3:09 PM

Fixes

• Concurrency check fails when creating new order

2020.12.6.2344

12/7/2020 4:51 AM

New

• Add nightly job to assign users and customers to a depot based on the last trip (if depot is unassigned)

2020.12.6.1801

12/6/2020 11:04 PM

New

• Return the PcsToQtyMultiplier (aka PackageSize) in the items list when downloading a trip
• Add 3PLexternal API method to get customers

2020.12.3.1851

12/3/2020 11:58 PM

New

• Update base control list to always refetch edited objects, even if they do show saved, to reduce concurrency messages for users

2020.12.3.1739

12/3/2020 10:46 PM

New

• Update API to Texada - do not export orders or lines with zero delivered qty

2020.12.2.1525

12/2/2020 8:31 PM

New

• Add org and depot to tripmetrics so all queries can be filled without using the trip table

2020.12.1.1043

12/1/2020 3:50 PM

New

• In POD Customer Search API, add support for a radius during geo-search

2020.12.1.926

12/1/2020 2:28 PM

Fixes

• Integrated Active Directory Auth should return error details and authstatus when schema is not updated

New

• Add system job to purge older message queue workitem
• Update system job to purge inventory history and txns to remove zero qty entries, extend to run longer, and run only once per week

2020.11.24.858

11/24/2020 2:04 PM

Fixes

• Rejecting an order while offline causes a completed order to be cleared out
• Reject order should skip processing if order is already started

New

• Create a true "Do Not Fill" feature in MH and gR
• Update Epicor P21 monitor service to only process during specified hours (from config)

2020.11.19.1812

11/19/2020 11:19 PM

Fixes

• AddUpdateTrip API should set the BillName on the order and the Customer.

New

• Add option in user list to only show disabled users

2020.11.19.1517

11/19/2020 8:24 PM

Fixes

• Save Order fails with wrong Newtonsoft version - needs binding redirect for new version

2020.11.17.1436

11/17/2020 7:43 PM

New

• Add customer tag list to ExportPostedOrder_byFilter API
• Nightly job to remove reset keys (PIN codes) should excludes ones that are already used (keep for tracking usage)

2020.11.14.933

11/14/2020 2:40 PM

New

• API for ExportPostedOrders_byFilter should include tripStartTime for each order
• NOTE upgrade Newtonsoft.Json binding redirect in web.config to 12 (from 11)

2020.11.13.1741

11/13/2020 10:49 PM

Fixes

• on Petrochoice roadnet import, fractional packages can be rounded to zero ordered
• Texada API to create invoices did not serialize line items notes correctly - default serializer should use JsonProperties (JSON.NET)

New

• 3PL API to AddUpdateTrip should set 3rd party carrier drivers to external = true to enable mobile logon via shortcode

2020.11.10.1844

11/10/2020 11:50 PM

New

• Add truck meter IP address in fleet info tab to auto-generate barcodes for dual-pumping trucks

2020.11.6.1816

11/6/2020 11:23 PM

Fixes

• 3PL Export Orders API should include driverID and customer contact, phone

New

• Predelivery notifications should use contacts and their email preference to send emails

2020.11.6.1007

11/6/2020 3:14 PM

New

• Update 3PL API AddUpdateTrip to allow sending and setting 3rd party carriers versus name drivers and trucks

2020.11.5.1549

11/5/2020 8:56 PM

Fixes

• Trip Summary report page size is wider than allowable on letter
• R217 trip summary report does not include UOM value or EPAcode description for product (where)
• When saving trip in trip edit form, ensure TLS1.2 is used as the default with fallback to prior versions (should not fail if only TLS 1.2 is enabled)

2020.11.4.2318

11/5/2020 4:26 AM

New

• On Otodata import, don't restrict updating readings on "out of service" tanks
• Show tank capacity on customer asset list (customer edit form).
• Add "Delivery Point" to roadnet import and P21 connector

2020.11.3.1653

11/3/2020 9:58 PM

New

• In POD API, return item group and subgroup with vehicle inventory
• Add Application to columns and filters in device license list to show which mobile app is registered to each device

2020.11.2.2208

11/3/2020 3:15 AM

Fixes

• OrtecOIR integration converting local time to DateTimeOffset has mismatched GMT offsets

2020.10.30.846

10/30/2020 12:49 PM

Fixes

• Can't see sensor serial number on attributes tab for tank assets.

New

• On Asset list control, change "serial number" to use VehicleIdentificationNumber property
• Add API method to export orders with unit filling details for 3rd party apps. Repeatable data export without marking orders as exported
• P21 interface should use ship2_name for customer and set the customer credit hold status

2020.10.28.1857

10/28/2020 11:03 PM

Fixes

• Otodata import is recording the wrong reading values
• Texada API to create invoice does not include order comments in the invoice.notes array

New

• Restrict InventoryLocations in mobile ref data to only sites, terminals, org assets
• Update device license validation API to include parameter for license type
• Change Roadnet import to use tank numbers on line notes
• Audit all imports/updates with data import tool and provide additional data validation on blank keys

2020.10.27.1654

10/27/2020 9:01 PM

New

• Add associated object tracking info on reset codes to better show what happened with their use

2020.10.27.1615

10/27/2020 8:21 PM

New

• Add POD template to rollup by asset/line number so tank deliveries sum qty delivered across split BOLs

2020.10.26.1744

10/26/2020 9:51 PM

New

• Report Subscriptions should include a direct file download link in addition to the file attachment - to accomodate email services that strip attachments

2020.10.25.1820

10/25/2020 10:27 PM

New

• Add AGID field to StormTrack events and update the export job to include that field

2020.10.21.901

10/21/2020 1:08 PM

Fixes

• Otodata import reports 404 errror
• P21 order connector does not pull in harmonized product information

New

• Appian API import should read line item hazard code description and apply to linenotes

2020.10.15.1736

10/15/2020 9:42 PM

New

• Mark reset key as used instead of deleting it
• Add order export interface to CompanyCard for invoicing and fuel tax calculations

2020.10.14.1800

10/14/2020 10:06 PM

New

• Add DoNotFillFlag to all assets to alert drivers to not fill
• Report subscription email subject should be the subscription (job) name versus the report ID to allow better subjects for customers/users

2020.10.14.1649

10/14/2020 8:55 PM

New

• Add loaded and unloaded user link in trip table
• Add created-by and used on info in reset keys to track who issued and who used keys

2020.10.12.750

10/12/2020 11:56 AM

Fixes

• AddUpdateOrders API should handle calls where the param to allow order reuse is missing

2020.10.11.2307

10/12/2020 3:14 AM

New

• Add parameter in API call AddUpdateOrder to allow reusing order numbers when one order can have multiple delivery tickets (e.g. P21)
• Update API GetOrdersToExport_MarkedReviewed to group orders based on a parent customer, list each product/order on a separate line but on one order export

2020.10.6.1436

10/6/2020 6:38 PM

Fixes

• Update Texada API interface to calc price, MST timezone and item ID based on service delivered (per Texada API update)

2020.10.6.916

10/6/2020 1:23 PM

New

• Add QtyLoaded to staging tables to assist in load reconciliation

2020.10.1.1649

10/1/2020 8:56 PM

Fixes

• Fix concurrency check on trip edit form - preventing closing if an order or load was updated prior

2020.9.30.1642

9/30/2020 8:48 PM

Fixes

• New portal users are put into the wrong role

2020.9.30.1147

9/30/2020 3:50 PM

New

• Add database tuning for trips and orders

2020.9.29.1924

9/29/2020 11:31 PM

Fixes

• Add additional validation checks when saving trip edit form - and alert user to issues if unstarting a trip in progress

New

• Add additional filters to terminal list (search)
• Add date range search filters on loads
• Show audit history options for loads and load details (add audit history button on their forms)
• Add tuning index on assets table for filtering by depot
• Consolidate system maintenance params for nightly jobs into one config setting (SystemMaintConfig)

2020.9.29.1526

9/29/2020 7:32 PM

New

• Add picked qty, date and user on order detail to support reconciling picked(loaded) vs delivered and whse app integration

2020.9.25.1841

9/25/2020 10:47 PM

Fixes

• VisualSupplier interface should concatenate emails from ALL contacts at a given customerID and locationID

New

• Increase customer email length to better accommodate multiple emails

2020.9.18.1745

9/18/2020 9:48 PM

Fixes

• Parent Customer, when set, not saved on the Customer edit form

New

• Return a value to indicate that a trip was preloaded when listing trips for mobile

2020.9.16.1139

9/16/2020 3:46 PM

New

• Update external API to AddUpdateCustomer for adding customers - move from internal POD API
• Add externalID to the items table to better support integration with external systems

2020.9.4.1052

9/4/2020 2:59 PM

New

• MessageQ edit form should have status message as a scrollable textbox to better see long workitem or email status values

2020.9.3.1854

9/3/2020 11:01 PM

New

• Auto-shrink all signature images from mobile orders to 25k (unless already smaller)

2020.9.2.1903

9/2/2020 11:10 PM

New

• Add scheduled job to export orders to the Texada API (create invoices)

2020.8.27.1602

8/27/2020 8:04 PM

Fixes

• AddUpdateTrip API does not set load eta and etd UTC formats (only base eta/etd)

New

• Add API method to create trip from mobile

2020.8.27.1227

8/27/2020 4:29 PM

New

• Add Depot as a template fields with properties for the pre-delivery notification email template

2020.8.26.1829

8/26/2020 10:31 PM

Fixes

• Asset Readings can be duplicated when saving checked reading types

2020.8.26.1507

8/26/2020 7:09 PM

Fixes

• Email customer comments to dispatch failed if salesRep was not set
• Tank list screen does not apply filter for non-monitored tanks (will not show in results)
• There is a warning if an asset ID is already in use for a tenant
• Trip edit form would not close if failed concurrency check - should be updated for simpler check and trip versioning

New

• Ensure serial number and barcode are used consistently between asset form and asset list

2020.8.25.1533

8/25/2020 7:35 PM

New

• Update DevExpress Controls for MobileHub UI

2020.8.25.1007

8/25/2020 2:09 PM

New

• Add account# filter in order list

2020.8.24.1721

8/24/2020 9:24 PM

Fixes

• Report subscription form can inadvertently set the subscription as disabled when editing

New

• Add order status in columns displayed for control - Review Orders For Export
• Add trip loaded and unloaded date to enable load integration with warehouse mobile app

2020.8.19.1913

8/19/2020 11:16 PM

Fixes

• Trip edit form should check to ensure the trip has not been updated prior to saving ( concurrency check).

New

• Add "NotToExceed" field on FuelOrderDetail to support preset delivery quantities
• Add checkbox on Order Detail to denote if the value should be used as a meter preset to limit qty delivered

2020.8.12.1821

8/12/2020 10:25 PM

Fixes

• Asset Filling "IsFull" not being set correctly when orders are posted from Mobile

New

• Update otodata tank customer location
• Update control "Review Orders for Export" to enable batch select and update as "reviewed"

2020.8.7.1247

8/7/2020 4:51 PM

New

• Add WorkOrderID to Storm Tracking Time Card

2020.8.6.1741

8/6/2020 9:42 PM

New

• Add job to Export completed orders to Accumatica ERP for invoicing

2020.7.31.1643

7/31/2020 8:47 PM

New

• Add separate LoadInstructions for loads versus using the comments field.
• Update nightly job that purges orphaned orders, loads and trips - delete if not used within config setting number of days - change default to 90 days
• Change label from "Add Tag" to "New Tag" in tag manager form...for better clarification

2020.7.28.1439

7/28/2020 6:44 PM

New

• Add vehicleFueling property to storm fueling storm DTO

2020.7.28.902

7/28/2020 1:06 PM

New

• Add separate LoadInstructions for loads versus using the comments field.

2020.7.27.1849

7/27/2020 10:53 PM

Fixes

• AddUpdateOrder API should not update email and customer info if API data is null or empty

New

• Add Depot to column list in trip list

2020.7.27.1229

7/27/2020 4:33 PM

Fixes

• Geocode customers in bulk can fail if an address is not provided

New

• Add tuning indexes to MessageQ for higher volume SaaS concurrency

2020.7.23.1812

7/23/2020 10:17 PM

New

• Use preference 'monitor_types' to enable adding other sensor mfgs including Otodata when adding or editing tank assets

2020.7.23.1006

7/23/2020 2:11 PM

New

• AddUpdateTrip API should check isSignatureRequired for deep inspection to determine if order needs to be updated
• Update job to generate customer POD emails to provide better concurrency in multi-tenant installations - process 1 message at a time versus batches
• Add comment to InventoryHistory to enable snapshot tracking for inventory at start and end of trip

2020.7.15.1637

7/15/2020 8:43 PM

Fixes

• Improve function to check for server updates and include company code in update email

New

• Add fromInventoryLocation on pick ticket table

2020.7.10.1622

7/10/2020 8:27 PM

New

• Remove event log notification list and coalesce to: depot email list, then fuel delivery notification list
• Email order events (reject order, backorder, geofence violation, etc.) to the customer's sales rep, in addition to the depot email list
• Add additional started status checking for DeleteTrip API method to ensure loads, orders and activities are NOT started before deleting

2020.7.8.1711

7/8/2020 9:17 PM

New

• Add table to track bulk products that are staged (before loading).

2020.7.8.1458

7/8/2020 7:03 PM

Fixes

• Integration.PostGPS generating hundreds of errors

2020.7.7.1526

7/7/2020 7:31 PM

New

• Add custom error pages so errors, 403 and 404 are redirected without server info

2020.7.2.1329

7/2/2020 5:35 PM

New

• Weighmaster number generation needs to ensure each number is unique per trailer (or truck) and sequentially numbered (required in CA)

2020.7.1.1543

7/1/2020 7:49 PM

New

• Add LoadStagedBulk table to track staging of bulk products in one or more totes

2020.7.1.1209

7/1/2020 4:15 PM

Fixes

• RouteBuilder trip list does not update ActualStartTime when trip is started (incorrect binding)
• Nightly job to update configs and preferences should automatically set company timezone to a default EST if not set

New

• Job to export orders to Symbology (xml file) should use a list of item groups to filter (e.g. bulk-diesel, bulk-gas, fuel) vs a single itemgroupname

2020.6.24.1837

6/24/2020 10:50 PM

New

• Implement harmonized products in roadnet/P21 import pre-processor
• Update Symbology order export to include all order fields when sending deleted orders (via xml)

2020.6.24.1321

6/24/2020 5:35 PM

Fixes

• Email for Customer Comments should send to depot email list if available, and should include helper to FormatDate

2020.6.23.1911

6/23/2020 11:25 PM

New

• Streamline GPS breadcrumb processing to support faster throughput - tune batch size
• Fuel Load Detail edit screen needs a field for compartment
• Remove feature to add file versions using check-in and check-out as it is not used and impacts file performance
• Tune FTP FilesProvider to find files by name versus using file version wildcard

2020.6.18.1801

6/18/2020 10:14 PM

New

• Log message type associated with customers to better report communication - POD, driver on the way, ASN, etc.

2020.6.17.1750

6/17/2020 10:03 PM

Fixes

• Generate POD email can fail when running on SQL Server Express with SSRS
• AddUpdateTrip API should increment server version number if Activities (lunch, break, etc) have changes

New

• Enable setting 'serviced by depot' and other route zone info when bulk editing customers
• Add MessageQueue parentType to capture message types like pre-delivery notification, POD, driver on the way, etc.

2020.6.14.1500

6/14/2020 7:08 PM

New

• Add WayMasterNo field to FuelOrderInfo to generate unique tracking numbers after orders are posted

2020.6.14.1143

6/14/2020 3:51 PM

New

• Add tuning indexes for DM2 API monitor
• Update SMTP defaults to use TLS (587) if not set

2020.6.12.1508

6/12/2020 7:09 PM

Fixes

• DM2 Import fails when Rosetta SHIPTONAME is missing

2020.6.11.1854

6/11/2020 11:01 PM

Fixes

• StartTimeUTC and EndTimeUTC not set in RejectOrder/RejectLoad

New

• Include tripcode in list of orders that cannot be exported to DM2 due to missing BOL
• If enabled, send customer comments on orders to the depot mailing list vs catch-all list

2020.6.10.1835

6/10/2020 10:55 PM

Fixes

• MOP ePOD doesn't show pricing for COD orders

New

• Add performance tuning indexes on EventLog table for secondary associated objects such as order details
• Move realisationkind element to order item level and add reason_code element in PostOrder message to OIR

2020.6.9.1516

6/9/2020 7:17 PM

Fixes

• Route Builder replaces trailer with truck name

2020.6.5.1611

6/5/2020 8:20 PM

New

• Update routable order export to Symbology to denote order status as A, U or D (add, update, delete)

2020.6.5.843

6/5/2020 12:44 PM

New

• Update db schema using FluentMigrator - remove dependency on ApexSQL diff script generator

2020.5.29.1731

5/29/2020 9:39 PM

New

• Don't allow inventory to "go negative"

2020.5.21.1028

5/21/2020 2:33 PM

New

• Update AddTrips API to allow null values when sending depot and terminal lat/long

2020.5.17.2342

5/18/2020 3:51 AM

New

• Update Amazon S3 file system API to current AWS version with .NET Core
• Update list of excluded file extensions to filter when adding or uploading a file

2020.5.14.1827

5/14/2020 10:36 PM

New

• Add OpenSite StormFueling API method
• Include barcode column in order details...unit filling tab

2020.5.12.1722

5/12/2020 9:32 PM

Fixes

• Default inventory location category and description lookup types are not meaningful
• PODData.GetTrip throws NRE
• PODData.SearchItems pulls inactive products

New

• Add long-running job timeout parameter in SS2JobSchedulerV2 config - so jobs can run hours if needed

2020.4.30.1602

4/30/2020 8:11 PM

Fixes

• AddUpdateTrip API should add additional validation on vehicles and trailers to confirm their asset type 'vehicle' and 'trailer'
• Unstart a trip from the mobile should NOT reset the assigned trailercode

New

• Implement scheduled job to pull Otodata tank levels

2020.4.28.1401

4/28/2020 6:10 PM

Fixes

• ExportOrdersToCsvFTP Scheduled job can miss orders with no line items
• Scheduled job edit- history tab does not scale correctly and overlaps the lower navigator buttons

New

• Add goRoam Mobile API methods to accept truck inventory snapshots

2020.4.23.1920

4/23/2020 11:30 PM

New

• Add Depot level for preferences
• Add nightly job to set IsMetered flag for fleet attributes with tag of metered_vehicle

2020.4.23.137

4/23/2020 5:47 AM

New

• Add IsMetered to fleet assets to denote meter integration, separate from electronic meters

2020.4.23.041

4/23/2020 4:52 AM

Fixes

• AddUpdateOrders API should not change ETA/ETD if order is assigned to a trip
• VisualSupplier monitor should remove pricing when line item is 'sales tax'

New

• Add report to show all orders with driver comments

2020.4.22.1952

4/23/2020 12:04 AM

New

• Create API user if one does not exist
• Add DeleteTrip API method for 3PL API. Trip cannot be started.

2020.4.21.1805

4/21/2020 10:15 PM

New

• Return register count with orgassets reference data
• Add private API method to enable Raptor web app to call MobileHub functions

2020.4.21.1311

4/21/2020 5:21 PM

New

• Add apiRaptor method to return POD template name for specific order

2020.4.20.1822

4/20/2020 10:32 PM

New

• Add flag on fleet assets to denote if they are manual meter vs electronic
• Add table to track which items will have demand forecast by depot, by item

2020.4.20.1742

4/20/2020 9:51 PM

Fixes

• Copy/Paste with CTL+V on preferences screen crashes the app
• Emailing PODs does not handle case sensitive order parameter - for reports that contain FuelOrderRefID - same POD is sent to all recipients

New

• Save license plate data from mobile
• In Mobile POD API, only get recent inventory for trucks and trailers
• Add config parameter to allow different POD receipts by state/province, account#, or account pattern - to enable French in Canada

2020.4.13.1435

4/13/2020 6:46 PM

New

• AddOrders 3PL API should auto-geocode customers without a lat long

2020.4.8.1928

4/8/2020 11:39 PM

Fixes

• Streamline save processing for API GetOrdersToExportWithDetails to eliminate deep graph inspection

New

• Add option to NOT log API calls to Ortec - turn off logging GPS messages by default

2020.4.8.1430

4/8/2020 6:40 PM

New

• Update Demand Forecast job and module to filter by item and show ordered vs delivered chart

2020.4.7.1853

4/7/2020 11:04 PM

New

• Add option to enter preferences at the depot level (in addition to company and user)

2020.4.3.1843

4/3/2020 10:55 PM

Fixes

• When creating an order in the field and copying details, the copied details are not associated with the new order
• Ortec OIRv2 start of trip load should include retained based on inventory date
• Trip edit for does not anchor the order list or activity list when maximized

2020.3.31.1638

3/31/2020 8:49 PM

Fixes

• Add additional check for report params when emailing POD - to see if report contains orderRefID

New

• Add driver in trip list shown in RouteBuilder
• VisualSupplier Monitor service should ignore customer type and exclude all DFOA line items from the config file list

2020.3.24.1850

3/24/2020 11:01 PM

Fixes

• Image resizing sets background on signatures to transparent, which shows as black when generated on PDFs

2020.3.23.1720

3/23/2020 9:34 PM

New

• Add sample project to show how to call goRoam server APIs from a REST web service

2020.3.23.1418

3/23/2020 6:30 PM

New

• Data import form - enable adding driver role when importing users

2020.3.22.1841

3/22/2020 10:53 PM

New

• Update SFTP to support 2020 ciphers and encryption levels

2020.3.12.1432

3/12/2020 6:44 PM

Fixes

• PODData.RejectOrder throws exception when no rejected status exists
• CSV import for tanks should set default tank type if not provided

New

• When returning asset inventory, include the last trip compartments and bols
• Save last BOL and compartment info when trip is ended

2020.3.10.1800

3/10/2020 10:12 PM

Fixes

• Switch MapTile provider for Osmose to HERE from MapBox

2020.3.6.1830

3/6/2020 11:42 PM

New

• Add Bolnumber and ShipperTerminal to order in PODData.GetTrip
• Update ConEd export to include fluke voltage
• Perform daily check for expiring goRoam Mobile license key and email sys admin and BizSpeed Support
• Add BOLNumber and ShipperTerminal on order for API AddUpdateTrip
• Add LastTripInventory to FleetAssets to track BOLs, products and compartments between trips

2020.3.4.1903

3/5/2020 12:12 AM

New

• Add option to import Orders via CSV file using Data Import menu option

2020.2.25.2250

2/26/2020 4:00 AM

Fixes

• AddUpdateTrip API did not set terminal inventory location as active when adding a new inventory location

New

• Return last order details when creating new order in PODData.CreateOrder

2020.2.21.1532

2/21/2020 8:42 PM

New

• Add mobileLogo field to Org to enable printing on mobile receipts (black and white)

2020.2.20.1330

2/20/2020 6:40 PM

Fixes

• In PODData.AddUpdateTripNoGuids, import chokes when activities don't have lat/lon values

New

• For Ortec https integration, write to the MessageQueue table and process posts via windows service
• Add OrtecMobileHubIntegrator as a windows service to post HTTPS to OIR

2020.2.18.1735

2/18/2020 10:45 PM

New

• Add Data Import form to import fleet trailers (incl metered)and customer trailers

2020.2.18.1259

2/18/2020 6:09 PM

Fixes

• AddUpdateTrip API does not correctly set terminal type when creating inventory location

New

• Return trailerId in PODData.ListTrips
• Add Orgs.Logo to ref-data DTO
• Upgrade CsvHelper to v15 - and update all CSV import/export jobs to use the Culture specific setting
• Add StartLoad realization for OrtecV2 integration

2020.2.12.1143

2/12/2020 4:53 PM

Fixes

• Update AddUpdateTrips API to handle null activiites list and null load details

2020.2.7.1833

2/7/2020 11:44 PM

New

• Add Job to Reset all Tank Capacities to zero
• Change reset codes to numeric vs alpha, and auto-expire
• Add Ortec OIR realization for loads to include retained product for the first load

2020.2.6.1605

2/6/2020 9:15 PM

New

• AddUpdateTrip API should accept both ETA and EtaUTC for scheduled times. And ETD EtdUTC
• ActivityType DTO field was missing an i. Add correct spelling and handle the misspelling in AddUpdateTrip API
• Add scheduled job to reset all asset capacities to zero for customers who do not want validation.

2020.2.2.2315

2/3/2020 4:26 AM

New

• Update nightly job that shrinks images to shrink all signatures greater than 25kb
• Export orders to PDF job should have params to allows saving a zipfile with directories embedded
• Add new customer ENV to PowerSurvey

2020.1.27.1847

1/27/2020 11:59 PM

New

• Enable deletion of work orders under PSC/Osmose events

2020.1.27.755

1/27/2020 1:00 PM

Fixes

• Add background task to purge maptile cache
• Change custom reports (.cs) to use a simpler version of timezone determination to account for Euro zones that are NOT standard

New

• Reset vehicle, trailer and terminal inventories that are less than zero
• Add Activities to the AddTrip web service API. to schedule things like breaks, fueling, etc.

2020.1.22.1727

1/22/2020 10:39 PM

New

• Add incoming and outgoing message data to payload audits
• Update PostOrder and scheduled job that sends PODs to use the internal ID in addition to the order number to address customers who reuse order#'s (eg.backorders)

2020.1.16.1354

1/16/2020 7:05 PM

Fixes

• Scheduled Job ExportOrderPDFstoFTP skips processing if importCSV file doesn't exist
• PODData.SearchItems uses empty customerRefId

New

• API3PL should accept pipe delimited list of tags in PostOrder for things such as 'unable to reconcile'
• Update DiscountTire receipt to show if 'unable to reconcile' and highlight the field in the PDF

2020.1.9.1720

1/9/2020 10:31 PM

New

• Inventory List shows too many decimal places
• DM2 API should import contact name (CONFIRMTO) and customer phone #(FAXNO)
• Sending Loads to OIR should include BOL, actionID and itemID for easier matching

2020.1.8.1753

1/8/2020 11:05 PM

New

• Migrate Dispatch role to Dispatcher and delete 'dispatch' role

2020.1.8.1307

1/8/2020 6:15 PM

Fixes

• Items on loads are not copied to items list in PODData.GetTrip
• Save trip function should save and update the server version so users are not required to re-fetch before saving
• Reverse route in RouteBuilder does not save changes

New

• [DM2] Add smarter Use-Retain to fuel export
• Add BOL info in PostLoad realization sent to Ortec OIRv2
• Modify ListTrips POD API to return trip instructions

2020.1.4.1841

1/4/2020 11:49 PM

New

• Tune and remove unused indexes for better performance
• Tune nightly maintenance to prune audits for private API calls and assetfilling json backups

2020.1.1.2034

1/2/2020 1:42 AM

New

• Add Trip Type to trip metrics table to allow better filtering on fuels, lubes, transport, etc.

2020.1.1.1947

1/2/2020 12:50 AM

New

• Add Delivery Point (from Customer ship to ) as a drop down filter for the R702 Customer Asset Filling report

2019.12.31.1339

12/31/2019 6:46 PM

New

• Tank list export to create orders fails if a tank has no forecast or delivery history
• Add link to create new tank on tank list view
• Update map tile provider to HERE and use load balancing for better performance

2019.12.27.1115

12/27/2019 4:24 PM

New

• Email the system administrator if a user exceeds max logon attempts and is set to disabled
• RouteBuilder sequencer should allow for reversing a route
• RouteBuilder sequencer should provide option to sequence by starting with the farthest stop first

2019.12.21.1226

12/21/2019 5:35 PM

New

• Add comment field to preferences table and display standard comments/notes for preferences

2019.12.19.1820

12/19/2019 11:30 PM

Fixes

• Downgrade 2019-12-10 SQL upgrade script to support SQL server versions less than 2016
• Terms of service and delivery receipts (incl 3PL) have invalid CSS styling

New

• Add Account Number column in Merge Tanks controls
• Add recurrence tab to tanks so they can be scheduled to be filled.
• Job scheduler arguments are limited to 256 chars but needs to increase for more complex arg size
• Add comment field to preferences to better explain specific settings
• Add city, state on TripStatusBoard - for legacy users to see the order city

2019.12.18.1745

12/18/2019 10:52 PM

New

• Update PreDelivery Notifications job to only send when customers are tagged versus sending to ALL customers except tagged
• Change last filled date to -2 years if no history is found

2019.12.18.1326

12/18/2019 6:32 PM

New

• Add "IsMetered" property to mobile OrgAsset reference data

2019.12.17.2250

12/18/2019 3:57 AM

New

• Save BOL number in T2T transfer
• In Stale asset check; exclude assets with tag "MERGED"
• Add startTime to the unit filling data grid
• Change unit filling from inline in data grid to a modal form for easier data entry
• Add Sales Summary ad hoc view to show sales by depot, date and product
• Routebuilder should also filter on itemID as well as description and customer item description (harmonized products)
• Tune job scheduler to check in a shorter date range if a job is currently running (performance improvement)
• Add FuelCapacity on bulk import tool when importing customer vehicle assets
• 3PL API should ensure users are enabled when assigning to EXTERNAL 3rd party carriers. Fixes issue with shortcode login

2019.12.12.838

12/12/2019 1:47 PM

Fixes

• PostOrder event processing should check if signature is required/exists before attempting to shrink it

2019.12.10.1916

12/11/2019 12:25 AM

Fixes

• When resubmitting to the AddUpdateTrip API, a load could fail if it has the exact same detail: item, qty, supplier. Add check for actionID additionally

New

• Update nightly job to purge INFO level audits based on a company config parameter setting
• Allow copying of trip shortcode on trip edit form

2019.12.9.1630

12/9/2019 9:40 PM

Fixes

• Adding orders to a trip in RouteBuilder shows Geocoding error even when the customer is geocoded

2019.12.9.1008

12/9/2019 3:17 PM

New

• Add ProductCompatability table to database

2019.12.8.1357

12/8/2019 7:06 PM

New

• Add Data warehouse Sales Summary table for reporting and forecasting inventory

2019.12.6.1725

12/6/2019 10:34 PM

Fixes

• Deleting a preference doesn't seem to work
• AddUpdateTrip API should not set customer email if the value is null or empty
• Order Detail List doesn't show total line item price for COD orders
• BOL Number isn't displayed on FuelOrderDetailEdit screen

New

• Create customeritem row when importing trips and orders
• Add TankCapacity column to AssetsEntity
• Add description in trip list view and filter fields
• Add customer "route zone" to route builder order well filter screen
• In the Route Builder order filter, make the product a lookup or allow searching by product code
• Add empty string handler to convert 53foot trailer boolean in truck profile for AddUpdateTrip
• Update Roadnet import API to map parent account number to customer
• Import DM2 line item comments at the Order level
• Remove site selection info from database
• Update Tank import option for data import to include sensor serial numbers and other data
• allow for customizable date format in ExportOrdersToCsvFTP
• When recording the audit for a PIN code usage, save the actual usage description
• Update FleetControl trip and order import to set UTC dates (coming from P21)
• Return 'return item' along with 'misc item' in the 3PLapi get reference data call
• [DM2] Don't export fuel line items with no product delivered

2019.12.5.1510

12/5/2019 8:19 PM

Fixes

• Message Queue list returns no results if you select "unsent" but also select a date
• Modifying an order that's on a trip does not cause the trip version to be incremented

New

• Customer List screen should have a filter for the "serviced by depot"
• Add files tab to load edit screen
• Add tool to merge tanks that have been replaced (merge delivery history for forecasting)

2019.12.3.1900

12/4/2019 12:10 AM

New

• Send Unstart Trip message to Ortec and integration services when driver unstarts trip

2019.11.28.1011

11/28/2019 3:21 PM

New

• Add weekly job to shrink order signature images

2019.11.25.1844

11/25/2019 11:54 PM

Fixes

• Tank export should include product and last fill info

2019.11.25.1721

11/25/2019 10:31 PM

Fixes

• AddTrip API should initialize load details to handle cases with loads without details

2019.11.25.741

11/25/2019 12:52 PM

Fixes

• [Petrochoice] Update Roadnet pre-processor to categorize products based on type

2019.11.21.1716

11/21/2019 10:26 PM

Fixes

• DWTankFillSummary foreign key to assets was UID but should be assetRefID

2019.11.19.1311

11/19/2019 6:22 PM

Fixes

• ORM Concurrency Exception when creating new inventory transactions

2019.11.19.851

11/19/2019 1:58 PM

Fixes

• When saving a new site, the associated inventory location has a name of ""
• New users do not need to have their own inventory locations
• Geocoding terminals from the terminal list throws an exception

New

• Change "Assigned Site" label on asset screen to "Assigned Depot"

2019.11.16.1431

11/16/2019 7:45 PM

New

• Remove reference to GeoMicro web service and also simplecrypt library for GeoMicro
• Remove Janus controls (scheduler and timeline) from references - no longer used

2019.11.15.1843

11/15/2019 11:57 PM

New

• Add API method for "truck to truck transfer"

2019.11.13.1927

11/14/2019 12:57 AM

Fixes

• Update 3PL API from mobile to account for misc items and returns. If not found on order, add on server.

New

• Add API method for "truck to truck transfer"
• Add interface to select and export orders to VisualSupplier (or Excel)

2019.11.11.1418

11/11/2019 7:32 PM

New

• Remove references to 32 bit DLLs that are no longer used

2019.11.6.1900

11/7/2019 12:15 AM

Fixes

• Remove hangfire sql scripts from schema upgrade

New

• Automatically set the geofence radius when adding trips through the API and lat/long are sent

2019.11.5.1832

11/5/2019 11:48 PM

New

• Return activities with trip in POD API
• Update the sys admin function to allow deleting an org

2019.11.1.1316

11/1/2019 5:33 PM

Fixes

• When unstarting a trip on the mobile, mark the startTimeUTC as null so it shows correctly in the web app

2019.11.1.938

11/1/2019 1:56 PM

New

• Add return items to 3PL API so they can be added in the field

2019.10.29.2231

10/30/2019 11:44 AM

New

• Upgrade LLBLGEN from 5.4 to 5.6 - to enable advanced SQL like over and row_number

2019.10.29.1336

10/29/2019 5:57 PM

New

• DM2: Look for driver carrier ID in InvoicePrefix property

2019.10.23.1732

10/23/2019 9:51 PM

Fixes

• RouteBuilder refresh trip menu item has error refreshing trips in certain situations

New

• Add order barcode image to standard delivery receipt PDF
• In Stale asset check; exclude assets with tag "MERGED"
• RouteBuilder should show and highlight pushpin, and center map each time you select an unrouted order

2019.10.21.1359

10/21/2019 6:22 PM

Fixes

• Update nightly maintenance to singularize all roles - dispatch, customer, etc.

New

• Remove OpenCageGeocoder - use HERE as the default

2019.10.20.1529

10/20/2019 7:39 PM

Fixes

• DM2 BOL Export duplicates retain and useretain elements
• Posting GPS Events to OIR is using wrong time conversion
• DM2 BOL export is returning non-BOL items
• DM2 BOL Export not setting CarrierID correctly
• DM2 BOL Export rounding too far
• Updated VisualSupplier monitor to use correct part_number for item ID (from inventory master)

New

• DM2 BOL PickupPointCode is concatenation of vendor.alternatevendorname and terminal.terminalid

2019.10.14.1730

10/14/2019 9:51 PM

New

• Add DM2 request filter in DM2 API monitor

2019.10.11.1813

10/11/2019 10:33 PM

New

• DM2 BOL export should handle when matching loads are not found

2019.10.8.1655

10/8/2019 9:16 PM

New

• Add order line item filter in RouteBuilder to NOT show specified items...like fees

2019.10.7.2343

10/8/2019 4:04 AM

New

• Add tank edit form as a subset of asset edit - to streamline tank info

2019.10.4.1809

10/4/2019 10:31 PM

Fixes

• Concurrency factory needs to remove underscore in table names because ORM does not support it
• Update job to calculate tank metrics (data warehouse) to update tank attributes

2019.10.2.1637

10/2/2019 8:56 PM

Fixes

• Company Name textbox on Org edit screen only allows 10 characters
• Fuel order detail edit screen validates backordered quantities incorrectly

New

• Add an "Audit History" Button for fuel order details
• Update MobileHub customer portal admin to use the new Raptor Web App

2019.9.26.1753

9/26/2019 10:13 PM

Fixes

• ImportAnovaTankReadings causes runtime error
• Database timeouts searching for data should not cause unhandled exception

New

• Refactor PostOrder db transaction handling
• Create private API method to confirm orders are posted
• VisualSupplier interface should filter specific accounts (national/DFOA) and remove items from the
• VisualSupplier interface should remove orders when their status changes to cancelled

2019.9.22.1824

9/22/2019 10:44 PM

New

• Update Numerex tank data feed to ANOVA format

2019.9.20.1603

9/20/2019 8:23 PM

New

• Capture latitude and longitude on eventLogs
• Send EventLogs to Ortec in 3PL module to process as EDI 214 messages

2019.9.19.1435

9/19/2019 6:53 PM

Fixes

• Ensure customer portal user admin checks password requirements defined at company level

2019.9.19.1213

9/19/2019 4:33 PM

New

• Capture item price and cost to 4 decimal places
• Be able to forecast individual tanks from the tank list screen
• Provide for filtering out DM2 orders by account number
• Return assigned driver in ListTrips
• Update Customer Portal User Admin to include customers by parent accountNo
• Visual Supplier interface monitor should allow filtering by shipped_via

2019.9.13.1125

9/13/2019 3:44 PM

Fixes

• Backordered Quantity is not editable on Order Details screen
• Some uploaded files do not have extensions in the filelocation column

New

• Add shipped_via filter for VisualSupplier interface

2019.9.11.1920

9/11/2019 11:29 PM

Fixes

• RouteBuilder orders filter panel did not autoscroll for low res screens

New

• Add filtering customer list by serviced_by_depot
• Add specific tank list control to just show tanks and their key attributes

2019.9.9.1723

9/9/2019 9:45 PM

Fixes

• SalesmanName not being saved in PostOrder

New

• Add AutoRefresh settings to RouteBuilder to automatically update trips on set schedule

2019.9.4.1625

9/4/2019 8:46 PM

New

• Add predictableScore field for tank forecasting - to determine the predictability of a given tank using forecasting

2019.9.3.1152

9/3/2019 4:13 PM

Fixes

• RouteBuilder depot filter did not filter using the customer service by depot

2019.9.2.1328

9/2/2019 5:50 PM

Fixes

• MobileHub system job to check for server updates reports false positive if minutes element is greater than current version

New

• Increase ExternalID field on orders to have a len of 100

2019.8.27.1836

8/27/2019 11:00 PM

Fixes

• Add depot if one does not exist when adding orders from api3PLexternal

2019.8.27.1702

8/27/2019 9:24 PM

Fixes

• Fix issue on RegisterDevice where WinMo devices do not support datetimeoffset datatype - remove that col from assets

New

• Scheduled job to run tank forecasts

2019.8.26.1708

8/26/2019 9:33 PM

Fixes

• Mobile Product Search doesn't evaluate harmonized product info correctly

2019.8.22.1221

8/22/2019 4:41 PM

New

• Update bulk import tool with additional tank attributes to import
• Add daysToFill to tank attributes to represent the number of days notice to get to the tank

2019.8.21.1837

8/21/2019 10:57 PM

New

• In RouteBuilder - add option to filter orders by the depot that services the customer (on the customer record)

2019.8.21.1604

8/21/2019 8:24 PM

Fixes

• API3PL external should remove order details when order updates do not contain them

New

• Add servicedByDepotID to the 3PL API to set the customer service depot

2019.8.19.1753

8/19/2019 10:15 PM

Fixes

• PostOrder fails if Qty, PcsQty, or BackorderQuanity values are null in incoming JSON
• Fix 3PL API to add orders - should calculate if non-bulk and set the pieces count

New

• DWCalcTripMetrics job to calc trip metrics should calculate delivered volume based on UOMs to include package items

2019.8.13.1401

8/13/2019 6:21 PM

Fixes

• PostOrder fails if Qty, PcsQty, or BackorderQuanity values are null in incoming JSON

2019.8.12.1804

8/12/2019 10:24 PM

New

• Save monitor type and ID from new assets created in the field

2019.8.9.1802

8/9/2019 10:18 PM

Fixes

• ExportOrdersToCsvFTP should report which orders were exported
• Change default AddUpdateTrip API to require a signature vs not require a signature on orders

New

• Update barcode and customer asset ID filters on R701 and R702 Asset Filling Reports

2019.8.5.2151

8/6/2019 2:10 AM

New

• Add SecondaryAssocObjectRefId to PostEvent

2019.8.1.1759

8/1/2019 10:19 PM

Fixes

• PODData.GenerateMeterTicketDocument not generating complete PDF's
• Preserve null values for pre-/post-trip totalizers

New

• Update R219 Trip Summary Report - add ending inventory (retain) and unload transactions
• Add customer name on email template for rejected orders

2019.7.29.1055

7/29/2019 3:16 PM

New

• 3PL API should add method to GetItemList for items that can be added in the field

2019.7.26.1423

7/26/2019 6:41 PM

Fixes

• Griffith Cargas export shows incorrect times for asset fueling start/end
• Eventlog default email template escapes HTML

New

• record LOGON_SUCCESS audit when driver authenticates from mobile
• Change POD product search to restrict results based on itemgroup
• 3PL API should return items users can add in the field - including the miscellaneous item

2019.7.8.1528

7/8/2019 7:48 PM

Fixes

• Add Update Trips API does not set ETDUTC value

2019.7.8.1445

7/8/2019 7:04 PM

New

• Add checkinstallation task to remove stale / old jobs that are no longer used
• Remove control that allows setting/lookup for parent customer - this is now just a text field
• Enable searching for BOL in loads, and displaying BOL in load details

2019.7.5.1955

7/6/2019 12:14 AM

New

• Add BOLnumber, parentAcctNo and supplier to standard CSV order export

2019.7.4.929

7/4/2019 1:48 PM

Fixes

• DevExpress charts control core not automatically included - causes error when loading tank asset

New

• Add parameter to DM2 order export to optionally export fuel orders (BOLS)
• Add BOL# (if it exists) on standard delivery receipt line items

2019.7.3.1301

7/3/2019 5:21 PM

New

• Change EntityImage.aspx so it returns the correct mime type

2019.6.25.1739

6/25/2019 9:58 PM

Fixes

• Preference screen did not delete preference if only one item was in the list - this applies to all editable grids
• AddUpdateTrips API did not properly set the ETA and ETD UTC values
• Uploading images from mobile duplicated file extension - change to -img for image type files

New

• Update to the new MapTiler API
• Add Email Delivery Receipt preference to allow including images the driver takes, like BOLs
• Add scheduled job to email customers all images attached to an order

2019.6.14.1721

6/14/2019 9:31 PM

Fixes

• Fix issue with uploading CSV files to SFTP file server

2019.6.14.1606

6/14/2019 8:26 PM

New

• Add web hook to email the next customer the driver is on the way when the driver finishes the current stop

2019.6.4.1851

6/4/2019 11:10 PM

Fixes

• Ortec OIR interface for start/end trip should send odometer values as integers

2019.5.31.1821

5/31/2019 10:38 PM

New

• Add last license check datetime to the Device License list
• Add Scheduled Job to import P21 marine orders (not associated w a trip)
• Update scheduled job ExportOrdersToCsvFTP to support SFTP

2019.5.28.1601

5/28/2019 8:11 PM

New

• Add chart of ordered vs delivered for tanks in Asset Form, and show tank delivery stats

2019.5.23.1632

5/23/2019 9:08 PM

New

• Add warehouse code to order detail edit form
• Add Serviced By Depot lookup to the customer edit form

2019.5.18.1539

5/18/2019 7:58 PM

New

• Add validation in fleet info (trucks/trailers) to require SSID and wifi password if asset has OBC
• Add DM2 Monitor to show API calls to and from DM2, and enable reprocessing calls
• On DM2 order import, automatically geocode customers without geocodes

2019.5.15.1729

5/15/2019 9:48 PM

New

• DM2 Interface - add shipvia filter to allow only importing orders matching this filter

2019.5.14.1138

5/14/2019 3:58 PM

New

• Change toast notification on app update to include BizSpeed MobileHub so users know it is a message from the Mobilehub

2019.5.13.045

5/13/2019 5:02 AM

New

• Log API response to AddUpdateTrip in audit table to better track responses sent to 3rd parties like Ortec OIR

2019.5.9.1649

5/9/2019 9:08 PM

New

• Add isSignatureRequired to the Add Trip API - to control if signature is required for a customer
• Add pickup items to Ortec OIRv2 realization

2019.5.8.1127

5/8/2019 3:47 PM

Fixes

• Log PostAudit message data to the logfile and return status to mobile as OK

2019.5.6.1350

5/6/2019 6:10 PM

New

• Add fleet attributes table to track truck SSID, meter address, etc for trucks and trailers with OnBoardComputers

2019.5.6.1021

5/6/2019 2:41 PM

Fixes

• RouteBuilder should handle unrouteable truck orders by attempting to use a car route and alert the dispatcher

New

• Trip summary report should be available from trip edit screen for all users
• R215 Pick Ticket Report should group by warehouse and consolidate all item groups of type 'fuel' to one warehouse
• Add UOM Conversion to data import tool
• Add tank history and forecasting info to tank fill summary to record accuracy of different forecasting methods
• Remove employee badge history as legacy that is no longer used
• Add job to assign customers to depots based on their last fill history

2019.5.1.1345

5/1/2019 6:04 PM

New

• Add scheduled job to check Ortec OIR and ORD interface status 'OrtecHealthCheck'

2019.5.1.029

5/1/2019 4:47 AM

Fixes

• OrtecOIRv2 background processor should send items added in the field to OIR / ORD (actionID will be zero)

New

• Create CustomerItemEntity if it doesn't exist
• Automatically add new customer item description and customer item number to CustomerItems table via API calls when values are new
• PostOrder API should set customer item description and number on items added in the field
• In RouteBuilder, when removing order from trip, reset ETA to default OrderDate

2019.4.25.1427

4/25/2019 6:49 PM

New

• Add serviced by depot to the customer record (which depot services them)

2019.4.24.2043

4/25/2019 1:02 AM

Fixes

• CalcPlanTripTime should use ETD-ETA for unstarted order dwell time

2019.4.22.1001

4/22/2019 2:22 PM

Fixes

• Make RouteBuilder layout proportional to screen size when initially shown - fix order well being collapsed

New

• Enable bulk customer edits for: email, parent acctNo and geoFence radius
• Change Symbology Export to send fuelType as the itemID
• Show current vehicle location for trip in RouteBuilder map

2019.4.16.1324

4/16/2019 5:33 PM

Fixes

• Terminal info is not being updated
• Update Trip.ServerVersion on 3PL API to AddUpdateTrip
• RouteBuilder trip list does not scale when screen is resized

New

• Include esignature in OIRv2 post order message
• Add scheduled job to add AssetReadings to specific tanks, vehicles, etc. to collect things like tank capacity
• Change commercial truck routing profile: hazmat codes and truck profile to 255 char len
• Update AddUpdateTrip API to better map commercial truck profile hazmat codes if description contains code
• Migrate API3PL test suite from NUnit to VSTest
• Add boolean converter so API AddUpdateTrip can accept strings or bool for Truck Profile (commercial Route)
• Add pre/post trip comments to Ortec API

2019.4.2.1106

4/2/2019 3:22 PM

Fixes

• AddUpdateTripNoGuids returns NullReferenceException

2019.3.29.1244

3/29/2019 4:56 PM

Fixes

• Trip updates are not propagating to devices in the field

New

• Symbology Export for Dion needs to have the truck number modified

2019.3.23.1717

3/23/2019 9:43 PM

Fixes

• PostOrder RTA can be outside the bounds of SQL date time

2019.3.22.1646

3/22/2019 8:55 PM

Fixes

• Import data methods does not map fields with different names than the target field name
• R215_PickTicket should return "Not Assigned" for trips that don't have drivers assigned

New

• In StormFueling.CreateFuelingSite, make sure to create inventory location
• Add method in StormFueling to closeout a fueling site

2019.3.15.1833

3/15/2019 10:44 PM

New

• Send pre and post trips notes from the driver to Ortec OIR
• Add option to import users in import data form

2019.3.14.1636

3/14/2019 8:55 PM

Fixes

• Change compartment length to 50 chars

2019.3.14.1231

3/14/2019 4:50 PM

Fixes

• Trip list filter does not apply dates correctly if end date is < start date

2019.3.13.1902

3/13/2019 11:22 PM

Fixes

• When editing users, if the user 'is external', force password entry if user token is not set

New

• Lock companycode one the company is setup - should be readonly in the Company Edit form
• Record last GPS reading and time on assets when recording GPS Event Logs

2019.3.13.1449

3/13/2019 7:09 PM

New

• Add lastGPS reading time on Assets

2019.3.12.1438

3/12/2019 7:12 PM

New

• API methods to check if a scanned barcode has been deactivated
• Add nightly job to purge orphaned trips, orders and loads create by recurring jobs and never started
• Add standard export job to send orders to CSV using FTP

2019.3.7.1756

3/7/2019 11:12 PM

New

• When returning preferences to mobile, return correct value in the hierarchy
• Add order status filter for DM2 import interface

2019.3.3.1827

3/3/2019 11:48 PM

Fixes

• Order list filter does not filter orders by product when ALL filter selected

New

• Add POD API method to get list of planned vehicles for date

2019.2.27.1845

2/28/2019 12:01 AM

Fixes

• UTC delivery fields are not consistent in how they are represented

New

• Update DM2 interface to support warehouse code on each line item vs the order header

2019.2.27.919

2/27/2019 2:39 PM

New

• Add warehouseCode on fuelorderdetail

2019.2.13.129

2/13/2019 6:49 AM

New

• Add new utility customers for PSC

2019.2.6.1442

2/6/2019 7:58 PM

New

• Set order type to FUELS instead of DEFAULT in petrochoice roadnet importer

2019.1.25.1819

1/25/2019 11:38 PM

New

• DM2 Interface should set order type based on the products on the order (fuel or lubes)

2019.1.25.1631

1/25/2019 9:50 PM

Fixes

• 3PL External API should perform deep inspection of loads to determine if they are changed before re-adding

New

• Update procedure to better track and lockout users after xx failed logon attempts
• Change inventory by truck to round away from zero and use 1 decimal point
• Add default system preferences for backorder processing on mobile

2019.1.24.1709

1/24/2019 10:28 PM

New

• Include maps and geocode API keys in customer facing web.config file

2019.1.23.1706

1/23/2019 10:24 PM

New

• Use HTTP Status codes more consistently in the goroam API methods
• Change terminal name length to 250 chars

2019.1.22.1737

1/22/2019 10:46 PM

New

• AddUpdateTrip API should compare line# and itemID to look for changes (vs just line#)
• R212 Daily Ops Review report should convert audits from UTC to local time

2019.1.21.012

1/21/2019 5:39 AM

New

• Add job to export dispatched orders to Symbology for delivery

2019.1.17.1804

1/17/2019 11:12 PM

New

• Add more timeout and tuning parameters for DM2 Rosetta API

2019.1.17.1451

1/17/2019 8:01 PM

New

• Use HTTP Status codes more consistently in the goroam API methods
• Add function to all migrating a company(org) to a new database. Enables migration to SaaS instance or from SaaS instance
• Add R704 customer fleet fueling report that is formatted for Excel output
• Add RTD column in Trip Edit form when showing the order list

2018.12.30.1029

12/30/2018 3:48 PM

New

• Change External API log level from debug to info
• Add additional logging when order is attempted to post a second time

2018.12.22.1405

12/22/2018 7:24 PM

Fixes

• PostOrder API should return if an order has already been posted (do not repost)

New

• Add job to re-export a CSV list of order POD's (PDFs)
• Add timeout parameter for job to ExportPetroFleetFuelingSummary ( data warehouse job)

2018.12.11.1539

12/11/2018 8:57 PM

New

• Add UOM filter for products in RouteBuilder

2018.12.10.1501

12/10/2018 8:19 PM

New

• Set orderPiececount in 3PL API to add trips and orders

2018.12.8.1145

12/8/2018 5:04 PM

Fixes

• 3PL external API does not correctly check for null item description on order import

2018.12.6.1919

12/7/2018 12:37 AM

New

• Add user preference to change the MobileHub auto-logout number of minutes

2018.12.5.1747

12/5/2018 11:05 PM

New

• Add Scheduled Job to Import XML files that can post to the JSON web service (as a proxy for it)

2018.12.3.2001

12/4/2018 1:19 AM

New

• Add API method to 3PL to AddUpdateOrders that are not assigned to a trip

2018.11.30.1653

11/30/2018 10:11 PM

New

• Return more user info from "checklogin" API call
• Add MeterSaleNumber (int?) to AssetFillingRecord
• Add UOM in products for an order view/grid in RouteBuilder

2018.11.21.1712

11/21/2018 10:30 PM

New

• Add weight to tripmetrics table

2018.11.15.1833

11/15/2018 11:50 PM

Fixes

• Fix issue where some customer addresses do not geocode with invalid address

New

• Ensure post order and load API's store UTC time values
• Add scheduled job to export all images from a trip(incl orders and loads) to a single file and email to a list

2018.11.12.1234

11/12/2018 5:52 PM

New

• Add logging for post order from mobile to capture raw JSON

2018.11.12.1042

11/12/2018 4:02 PM

Fixes

• Fix PostOrder API to handle null pieces value

2018.11.8.1830

11/8/2018 11:48 PM

New

• Update geocoding service to use address names and fuzzy search vs individual address parts

2018.11.6.1357

11/6/2018 7:19 PM

New

• Add new API methods for Ortec OIR integration - standardize for fuels and lubes
• Add report to show asset readings on unit filling - ex DEF used, EngineHrs, Percent Full, etc.

2018.11.2.1901

11/2/2018 11:21 PM

New

• Add depot and terminal lat long info for API access

2018.10.31.1847

10/31/2018 11:08 PM

New

• Add API methods to support the "load by weight" use case on mobile

2018.10.28.1317

10/28/2018 5:40 PM

New

• Change FTP files provider to use fluentFTP client

2018.10.25.1220

10/25/2018 4:41 PM

Fixes

• Add new assets does not assign to customer

2018.10.22.1639

10/22/2018 8:59 PM

Fixes

• Update mapping for order billing and shipping addresses in Appian Import

New

• Import Roadnet orders API should map parentAccount the customer's parent acct field
• Import Appian orders should trip zipcodes that are longer that 10 chars
• Update customer, depot and vendor zip codes length to accomodate longer codes

2018.10.18.1623

10/18/2018 8:44 PM

Fixes

• Upload file may fail and not log sufficient info in the failure. Add additional logging and remove check of file versions #

2018.10.18.1439

10/18/2018 6:58 PM

Fixes

• Job to import Appian orders does not import special instructions

2018.10.17.1338

10/17/2018 5:50 PM

New

• Post GPS events to all Ortec integrations

2018.10.10.1437

10/10/2018 6:59 PM

New

• Change job to import Roadnet orders to filter on additional fuel depots

2018.10.8.1312

10/8/2018 5:31 PM

Fixes

• FTP service should automatically add a '.' for file extensions if it is not provided in the request

2018.10.8.1001

10/8/2018 2:21 PM

New

• Split accountNo on first 4 chars for custom 3PL export job @ DHL

2018.10.5.1439

10/5/2018 6:58 PM

Fixes

• Messages logged to the system log should have more context
• Fix checkinstallation script to include legacy authentication check for older customers

New

• Messages logged to the system log should have more context
• Add standard menu items, config and preferences when creating new company from admin console
• Update Roadnet import process to account for line items that have the order header (vs blank header(std))
• Add DM2 request/response backing table and processor

2018.10.1.1637

10/1/2018 8:45 PM

New

• Update License Generator to ask about truck routing

2018.9.25.1415

9/25/2018 6:32 PM

Fixes

• Save asset should only save asset reading codes, not the whole string with ~ description
• Add check to see if file has already been uploaded. if so, then skip it.

2018.9.19.1417

9/19/2018 6:35 PM

New

• Add parent acct number to 3PL API

2018.9.18.1635

9/18/2018 8:53 PM

New

• Add parentAcctNo and customer info to export files JSON for 3PL

2018.9.14.1533

9/14/2018 7:48 PM

Fixes

• Check installation script should throw error on invalid login before updating database schema
• Change user edit form label to 'lock out user'

2018.9.11.1855

9/11/2018 11:12 PM

Fixes

• copy trip duplicates order notes when copying orders

2018.9.11.1414

9/11/2018 6:33 PM

Fixes

• Fix concurrency check to ignore case when using the new ORM. Affects 'Z' tables

2018.9.7.1552

9/7/2018 8:10 PM

Fixes

• Update installation script to access database directly in db upgrade scripts vs using ORM models

2018.9.7.1122

9/7/2018 3:40 PM

New

• For 3PL orders, show order# as BOL on receipt and show alternate order #
• Update data import tool to map customers, products and vehicles with the new import mapping format

2018.8.31.1838

8/31/2018 10:54 PM

Fixes

• Change BulkOrdersDeliveryReceipt to use vehicle vs trailer to correctly show the order depot
• When resetting a user and marking them enabled, reset the last failed logon time

New

• Job SetUnfilledAssetsToInactive should not deactive metered_vehicles

2018.8.30.1751

8/30/2018 10:06 PM

New

• Add option to reset password from login form - and lockout user

2018.8.29.1845

8/29/2018 11:01 PM

New

• Add AssetEquipmentAttributes to DAL

2018.8.29.1704

8/29/2018 9:21 PM

Fixes

• Cargas export fails on long GPS longitude values

New

• Add option for 'password never expires' for users
• Return Trip depot lat/lon to mobile
• Add button in preferences list to add all system default preferences
• Add CompartmentId in GetTrip and PostLoad
• Change job to export orders to JSON to get all orders in the last 90 days

2018.8.24.1846

8/24/2018 11:06 PM

New

• Add job to import Roadnet routed trips and orders through the standard API

2018.8.22.1743

8/22/2018 10:02 PM

Fixes

• Fix issue in ExportFuelOrder_SOStoFTP scheduled job to not skip manually entered asset filling records

New

• Change post audit web service to be case insensitive

2018.8.20.1821

8/20/2018 10:39 PM

New

• Change job that exports orders to JSON files to only include posted orders

2018.8.20.1646

8/20/2018 9:04 PM

New

• Capture parentrefid and type when saving an audit from the mobile device

2018.8.7.1623

8/7/2018 8:32 PM

New

• Update LLBLGEN ORM to to v5

2018.8.3.1349

8/3/2018 6:05 PM

Fixes

• GetTrip returns zero for order detail delivered quantity

2018.7.31.1420

7/31/2018 6:29 PM

New

• Update AddNewCustomerAssets API method to accept some new fields

2018.7.28.1336

7/28/2018 5:54 PM

Fixes

• Add existing order on trip should use ETA vs ETA_UTC for search

New

• For job ExportFiles_JSONembedded - change address field to address1, address2

2018.7.26.2048

7/27/2018 1:04 AM

Fixes

• AddUpdateTrip API should check if loads have changed before deleting and re-adding

2018.7.26.1744

7/26/2018 10:00 PM

New

• Add parameter for max logon attempts at the company level

2018.7.25.1844

7/25/2018 11:01 PM

Fixes

• Griffith Export cannot handle more than one of certain asset readings
• Search for existing orders did not find orders not assigned to a trip

New

• Update map and geocode providers to a new service (MapTiler and Google)

2018.7.20.1912

7/20/2018 11:30 PM

New

• Add order address block to job that exports files to JSON objects

2018.7.19.1643

7/19/2018 9:00 PM

Fixes

• AddUpdateTrip API method should check for order changes and use existing order and detail ID's so duplicate (zero qty) rows are not posted on saving a mobile order
• When checking 3PL short code validity, password is not sent back to mobile

New

• Add POD opcode for converting meter ticket string to PDF attached to order
• Implement API methods to check and use mobile app "reset" PINs
• Re-assigned rejected orders should get new status and ETA

2018.7.18.1038

7/18/2018 2:54 PM

Fixes

• ItemSubGroupName being overwritten on order import (PETRO)

New

• Reset last logon date to current time when changing a users password (so they do not get disabled by inactivity)
• Add refresh option on Admin->Company->Config to allow refreshing the list without relaunching the form

2018.7.16.1215

7/16/2018 4:33 PM

Fixes

• Job to ExportOrdersToJSON does not set last run changestamp if order list is empty

2018.7.14.1957

7/15/2018 12:16 AM

Fixes

• Save new trip throws a message 'object not set to value' when checking for concurrency changes

2018.7.14.1043

7/14/2018 3:01 PM

New

• Update POD API to search for trip updates by server version

2018.7.10.1932

7/10/2018 11:49 PM

Fixes

• If a trip is changed while a user has the trip edit form open, they receive a non-descript save message.

New

• When copying trip, all orders should have status set to scheduled
• When adding existing orders to a trip, allow lookup and display of orders that are already assigned to other trips
• When adding a new order to a trip, set the ETA to an hour past the last order so it is easier to schedule

2018.7.6.1930

7/6/2018 11:46 PM

New

• Return full address with lat/lon on terminals for POD
• On trip form, expand searching for existing fuel orders to include order status and dates
• On trip edit form, add ability to move orders up/down in list with context menu

2018.6.25.1719

6/25/2018 9:36 PM

New

• Change RecordGPS batch API method to use MessageQueue and return immediately

2018.6.14.1234

6/14/2018 4:53 PM

New

• On copy trip function, add option to copy rejected orders

2018.6.13.1616

6/13/2018 8:34 PM

New

• Change SOAP headers to https from http for WSDL users

2018.6.11.1038

6/11/2018 2:55 PM

Fixes

• Change length of BillState to match len on customer record so orders created in the field can post

2018.6.8.1751

6/8/2018 10:07 PM

Fixes

• When posting an order via the API, if order is new then use customer item description and ID (not item desc, ID)

New

• Add ability to copy a trip from the trip list
• When adding an order from within a trip, use the trip scheduled date as the order eta, etd

2018.6.7.1650

6/7/2018 9:06 PM

New

• Change SiteSupervisor name to MobileHub

2018.6.6.1826

6/6/2018 10:43 PM

New

• Sign all assemblies and apps with Code Signing Certificate
• Add category and lat/long to pictures and files
• Add Reset keys to company so mobile devices can be reset individually by reset key

2018.6.2.1442

6/2/2018 6:57 PM

New

• Add latitude, longitude and category to files and the file upload API

2018.6.1.1750

6/1/2018 10:07 PM

Fixes

• Files provider throws exception if file not found, name is invalid or blank

2018.5.30.1436

5/30/2018 6:53 PM

New

• sign clickonce app and manifests with code signing certificate

2018.5.23.1247

5/23/2018 5:03 PM

New

• Disable user account if user has not logged in within a configured number of days
• Display last logon date in user list
• Add terminal info to API 3PL
• Add report R700 Customer Fleet Fueling that shows only ONE asset per page

2018.5.22.1538

5/22/2018 7:54 PM

New

• Add item group and subgroup to API 3PL for orders

2018.5.21.1549

5/21/2018 8:04 PM

New

• Add system job to delete device licenses after a set period of time
• Change 3PL API to assume all dates come with datetime offset

2018.5.18.1732

5/18/2018 9:47 PM

New

• Add import job to import hauling rates from CSV

2018.5.14.1815

5/14/2018 10:28 PM

New

• Sign all assemblies and apps with Code Signing Certificate

2018.5.10.1314

5/10/2018 5:29 PM

New

• Add contact on orders for the API method to add trips

2018.5.9.1849

5/9/2018 11:05 PM

New

• Increase length of customer comments and order instructions on Order to 8000

2018.5.4.1807

5/4/2018 10:21 PM

Fixes

• AddUpdateCustomerList overwrites customerrefid that might already exist

2018.5.4.1159

5/4/2018 4:16 PM

Fixes

• Ensure asset reading is populated when sync occurs

2018.5.4.844

5/4/2018 1:00 PM

New

• Change order signed by name to 256 length

2018.5.4.712

5/4/2018 11:27 AM

New

• Add itemgroup and itemsubgroup to orders and loads API for categorization and reporting

2018.5.2.1432

5/2/2018 6:43 PM

New

• Add FTP export to SOS systems ERP app for fuel orders

2018.5.1.1005

5/1/2018 2:20 PM

New

• Add Terms of Service web page for mobile devices to accept

2018.4.27.1556

4/27/2018 8:06 PM

New

• Add Terms of Service table for each company - users acknowledge TOS
• Add ResetKey table to hold codes to allow devices to be reset

2018.4.26.1506

4/26/2018 7:21 PM

New

• Add last checked datetime to devicelicense so old devices can be purged

2018.4.18.1847

4/18/2018 11:02 PM

New

• Add API method to allow login by shortcode

2018.4.16.1902

4/16/2018 11:19 PM

Fixes

• Report scheduler does not correctly validate custom dates (e.g. Date-7) and booleans

2018.4.5.1642

4/5/2018 8:50 PM

Fixes

• App crash when attempting to geocode a customer

2018.4.5.946

4/5/2018 2:04 PM

Fixes

• with OIR, tank ID is not being returned correctly with stock_measurement realization
• Job scheduler sometimes catches more than one recurrence in a window

2018.4.2.1509

4/2/2018 7:26 PM

Fixes

• Ensure GPS batch recording checks if breadcrumb does NOT exist to save it

2018.3.29.1842

3/29/2018 10:56 PM

New

• Update JSON.net to v11

2018.3.29.1733

3/29/2018 9:50 PM

Fixes

• Update DevExpress Mapping controls to 17.2.4 or higher to fix 3D graphics bug

2018.3.22.1640

3/22/2018 8:54 PM

New

• Return company logo with orgid

2018.3.13.1913

3/13/2018 11:28 PM

New

• Change name of customer receipt attachment to order- versus orderreceipt- for better consistency
• Notify Drivers of trip assignment email should include orders and customers

2018.3.8.1849

3/9/2018 12:04 AM

Fixes

• Jobscheduler does not always fire when requesting 'run now' and can hang on jobs where internet connectivity was lost

2018.3.7.1713

3/7/2018 10:27 PM

New

• Add custom error pages so errors, 403 and 404 are redirected without server info

2018.3.6.1543

3/6/2018 8:57 PM

Fixes

• Order detail set quantities to zero when changing price under bulk delivery when not editing asset filling records

2018.2.21.1709

2/21/2018 10:59 PM

Fixes

• UnstartTrip throws an invalid cast exception
• Scheduled jobs do not always run when they have a single hour and minute set

2018.2.19.1653

2/19/2018 10:09 PM

New

• Update stored procedure to better manage failed logon attempts

2018.2.16.1829

2/16/2018 11:43 PM

Fixes

• Saving users should not require you to re-enter a password.

New

• Export attachments to FTP should put all files in same folder vs by month-year

2018.2.13.1212

2/13/2018 5:26 PM

Fixes

• Automapper must be initialized in startup, not asset classes. Causes issues with recording GPS in batch

2018.2.5.1808

2/5/2018 11:21 PM

New

• Make Load externalID field 512 chars to accommodate more load info from Ortec
• Add datetimeoffset fields to trip, order, load and event tables

2018.2.2.1905

2/3/2018 12:19 AM

New

• Use explicit "SELECT" clause in legacy "gettripdata" webmethod
• Update nightly maintenance jobs to purge data with longer timeouts

2018.2.1.1903

2/2/2018 12:12 AM

Fixes

• Save/Close on user roles form can cause PK violation

New

• Report to view "stale" assets
• Add report to show inventory transaction - like pump and flush
• API methods to check if a scanned barcode has been deactivated

2018.2.1.1207

2/1/2018 5:21 PM

Fixes

• Primary Key violations adding/updating assets from mobile

2018.1.29.1438

1/29/2018 7:57 PM

New

• Add UOM to columns on product list page

2018.1.28.1323

1/28/2018 6:36 PM

New

• Add scheduled task to check for server updates and email admin email for the org

2018.1.26.1741

1/26/2018 10:53 PM

New

• Display toast notification in web app if server version is updated - alert user to reload app

2018.1.25.1534

1/25/2018 8:47 PM

Fixes

• Some WinForms controls throw file not found exception looking for XtraPrinting.dll

New

• Add web method to post GPS event in batches

2018.1.23.1849

1/24/2018 12:02 AM

New

• Scheduled job to deactivate stale customer assets

2018.1.20.1829

1/20/2018 11:43 PM

New

• Pass LastDeliveredProductId to mobile

2018.1.19.1542

1/19/2018 8:57 PM

Fixes

• Item edit screen doesn't show UOM or ItemSubGroup

2018.1.15.1846

1/16/2018 12:01 AM

New

• Pull in customer notes when creating new orders
• On order details, do not allow gross/net qty edit if there are unit filling records
• On recurrence tabs, automatically set the start date if the recurrence is checked

2018.1.11.1826

1/11/2018 11:38 PM

New

• Add import job for Insite Tank Monitoring (SkyTracker)

2018.1.10.1643

1/10/2018 10:20 PM

Fixes

• Customer list screen does not show parent acct #

New

• Customer list screen should show and allow filtering on email

2018.1.5.1047

1/5/2018 4:02 PM

New

• Add Internal Notes field to orders so comments field is only associated with customer comments (not notes)

2018.1.4.1527

1/4/2018 8:45 PM

New

• Update customer comments email to new handlebars template
• On PowerSurvey form, if lookup status is disabled then ensure it is still in list for existing orders

2017.12.28.2132

12/29/2017 2:40 AM

Fixes

• Event log email does not include truck on rejected orders and loads.

2017.12.21.1636

12/21/2017 9:51 PM

Fixes

• Save or Save and Close on new customer has error from DeliveryWindow

2017.12.21.1402

12/21/2017 7:14 PM

New

• Remove unused workflow and survey tabs from customers, assets, products

2017.12.20.1415

12/20/2017 7:23 PM

Fixes

• Assets list does not show type = equipment

2017.12.19.1545

12/19/2017 8:59 PM

New

• Filter warehouseOD (lubes) orders as the only ones to export for job ExportFuelOrdersWNR

2017.12.18.1736

12/18/2017 10:48 PM

New

• Add ability to delete scheduled job - and log to audit table

2017.12.6.1554

12/6/2017 9:10 PM

New

• PostOrder should allow an empty triprefid

2017.12.4.1406

12/4/2017 7:24 PM

Fixes

• AddUpdateAsset web API does not save if asset exists

2017.12.1.1535

12/1/2017 8:51 PM

New

• Update all maps to use DevExpress map control and Bing Maps. Remove EO web components.

2017.11.22.1213

11/22/2017 5:29 PM

New

• Add Retest functionality to SVD work orders

2017.11.17.1731

11/17/2017 10:42 PM

Fixes

• "Geocode me!" throws an error on the Depot and Customer pages
• Confirm emailing to depot emails first when sending event logs

New

• Add audit table to job to export orders to json
• Add "RejectLoad" method

2017.11.9.1435

11/9/2017 7:49 PM

New

• Add email list to depot list form

2017.11.1.1815

11/1/2017 10:22 PM

New

• Negative inventory email should round and not send if qty is zero

2017.11.1.1203

11/1/2017 4:19 PM

Fixes

• New order does not generate new order number

2017.11.1.1052

11/1/2017 3:08 PM

Fixes

• Users table needs field isPagerPreferred changed to a bit type

2017.10.31.1619

10/31/2017 8:37 PM

New

• Update AddUpdateTrip API method to record and end trip

2017.10.31.1216

10/31/2017 4:33 PM

New

• Truck returning with inventory email should show depot name, not ID

2017.10.30.1757

10/30/2017 10:14 PM

Fixes

• Order detail edit does not allow saving net and gross qty even if there are no detail txns

2017.10.30.1206

10/30/2017 4:24 PM

Fixes

• Allow edit order number for new orders

2017.10.25.1515

10/25/2017 7:28 PM

Fixes

• Storm Fueling storms don't get employee fueling tag

2017.10.19.1839

10/19/2017 10:55 PM

New

• Update event log template to use new HTML format

2017.10.4.1230

10/4/2017 4:44 PM

New

• Add trip metrics to the trip, and calculate metrics when trip is done

2017.10.3.1408

10/3/2017 6:22 PM

Fixes

• List trips should only include trips scheduled for today

2017.10.2.1435

10/2/2017 7:04 PM

Fixes

• PostOrder does not save itemPrice and BOL for items added in the field

2017.9.28.1856

9/28/2017 11:12 PM

New

• Capture payment amount and ID in Post Order web service

2017.9.27.1146

9/27/2017 4:00 PM

New

• Add account logout with xx failed attempts, and password complexity requirement

2017.9.26.1604

9/26/2017 8:19 PM

New

• Modify "Truck Returning With Inventory" to show tenths
• Add handler to send email on event = truck inventory is negative

2017.9.14.1736

9/14/2017 9:51 PM

New

• Send optional text notification to drivers when trips are assigned

2017.9.6.1619

9/6/2017 8:27 PM

Fixes

• OIR "Reject" message <extra_stop /> node in wrong place

2017.9.1.1628

9/1/2017 8:43 PM

Fixes

• MobileHub doesn't respond to resolution changes

2017.9.1.1459

9/1/2017 7:14 PM

New

• If email format is invalid, set error and show status as red on message form

2017.8.30.1249

8/30/2017 5:05 PM

Fixes

• AddupdateTrip API incorrectly sets the customerItemDescription

2017.8.29.1739

8/29/2017 9:54 PM

New

• Update JSON API's to support StormFueling
• Appian Interface should import the PO#
• Add WaterReading as a decimal value vs true/false

2017.8.26.1409

8/26/2017 6:25 PM

New

• JDE export to OIR needs additional fees and a flag if driver entered new items

2017.8.25.1443

8/25/2017 6:57 PM

New

• Add new customer form edits for PowerSurvey

2017.8.11.1551

8/11/2017 8:07 PM

New

• Add new fee fields in fuel order export -MacP

2017.8.8.1311

8/8/2017 5:24 PM

Fixes

• ImportAppianOrders job needs to account for 1-n stop to order

2017.8.7.1543

8/7/2017 7:59 PM

New

• Implement a MobileDevice "lookup" API method

2017.8.2.1543

8/2/2017 7:51 PM

Fixes

• Reject Order web api method should not return an error if the order doesn't exist

2017.8.2.1520

8/2/2017 7:35 PM

New

• Pre and Post trip totalizers should show decimals
• Add Customer ItemID and ItemDescription on AddUpdateTrip API for harmonized products
• Include GPS information in with the ARRIVE/DEPART Ortec messages
• Email fuel distribution list if driver adds items in the field

2017.7.31.1659

7/31/2017 9:17 PM

New

• Sort WorkOrderID as number vs string for PowerSurvey

2017.7.28.1018

7/28/2017 2:32 PM

New

• PowerSurvey needs parentID field to accept 6 digits

2017.7.26.1818

7/26/2017 10:36 PM

New

• Add additional fees for Ortec OIR to JDE interface

2017.7.26.1723

7/26/2017 9:42 PM

Fixes

• Reject order message needs to send the server time to Ortec

2017.7.13.1558

7/13/2017 8:15 PM

New

• Add HERE.com mapping

2017.7.3.1202

7/3/2017 4:14 PM

New

• Add HERE.com as maps provider

2017.6.28.2124

6/29/2017 1:39 AM

New

• Change ExportFuelOrderWNR job to not write file if there are no orders to export

2017.6.27.1028

6/27/2017 2:45 PM

New

• AddTrip API should default bill to = ship to if billing info is empty

2017.6.22.1744

6/22/2017 10:00 PM

New

• Backorder and delivery receipt emails need to be responsive

2017.6.14.1553

6/14/2017 8:10 PM

New

• Add scheduled job to ExportBOLsToFTP

2017.6.14.1102

6/14/2017 3:19 PM

Fixes

• API AddImportTrips needs case insensitive check for bulk UOM list to set bulk vs package order details

2017.6.6.1136

6/6/2017 3:53 PM

New

• Update web.config to enable SSL calls from the job scheduler

2017.5.31.1403

5/31/2017 6:18 PM

New

• Add CUS customer form for PSC

2017.5.26.1801

5/26/2017 10:18 PM

New

• Add customerItemID and customerItemDescription to AddTrip API

2017.5.22.1842

5/22/2017 11:01 PM

New

• Migrate Job Scheduler to .NET 4.6

2017.5.17.1347

5/17/2017 6:04 PM

New

• Add terminal address lines to XML and JSON interface - AddTrips
• Ortec OIR - message containing stick readings should have reading time set to order RTD

2017.4.28.1549

4/28/2017 8:06 PM

New

• Add additional validation checks to AddUpdateTrip API

2017.4.25.1251

4/25/2017 5:07 PM

New

• Upgrade DevExpress controls from v16.1 to v16.2

2017.4.23.1622

4/23/2017 8:36 PM

New

• Add ReleaseNo field to the FuelOrder table

2017.4.14.1025

4/14/2017 2:40 PM

New

• Nightly job to purge audits should delete entities directly for better performance

2017.4.11.1910

4/11/2017 11:24 PM

New

• Add screen to view VMI tanks, tank levels and next order

2017.4.4.1127

4/4/2017 3:43 PM

Fixes

• Don't send FuelLoadDetail.UOM in legacy GetTrip methods

New

• Log whenever a report is called

2017.3.27.1406

3/27/2017 6:20 PM

New

• Add nightly job to purge debug audits and scheduled job history
• Update Tank Readings form to better incorporate forecasting and different tank vendors

2017.3.23.1723

3/23/2017 9:38 PM

Fixes

• Dispatcher can specify out of service trucks for planned vehicle
• HHT can download out of service OrgAssets

New

• update product list screen to display, sort, filter on DOT(placard), EPA, DEXA

2017.3.20.1343

3/20/2017 5:59 PM

Fixes

• ListTrips shows trips scheduled for tomorrow today.
• on Trip List, "not ended" filter should not include not started trips

2017.3.15.1707

3/15/2017 9:14 PM

Fixes

• OIR PostOrder method uses wrong node name for delivered quantities

2017.3.14.1719

3/14/2017 9:34 PM

New

• AddUpdateTrip web method should update order line detail based on UOM for bulk vs package

2017.3.14.1415

3/14/2017 6:30 PM

Fixes

• Alternate Order Number was not updated in PostOrder web method unless it was a new order
• Line item BOL values are not updated in the web method
• AddUpdateTrip web method does not update the item description

2017.3.13.1833

3/13/2017 10:48 PM

New

• Add job to auto-export all files associated with a company to FTP

2017.3.10.1558

3/10/2017 9:14 PM

New

• Create user in web method AddUpdateTripNoGuids if user is not found

2017.3.3.1655

3/3/2017 10:10 PM

Fixes

• TripStatusBoard doesn't show rejected orders

New

• Add accountNumber to ExportOrdersToJSON
• Generate Ortec messages from GpsEventLog entries
• Load form should make ETA and ETD required
• Add inputs for EPACode and DEXACode to item edit screen
• Remove DEXA code field from items table

2017.2.23.1546

2/23/2017 9:01 PM

Fixes

• Fix error in ExportOrdersToJSON job - when customer is null

2017.2.22.1012

2/22/2017 3:28 PM

Fixes

• Account for possibility that LoadDetail.netQtyLoad could be null
• Ensure GPS event logs check if they have already been posted

2017.2.19.1745

2/19/2017 10:53 PM

New

• Remove DEXACode and add LineNotes to Order Detail

2017.2.13.1605

2/13/2017 9:21 PM

Fixes

• Stock correction form does not allow saving

2017.2.6.1125

2/6/2017 4:41 PM

New

• Updated license key for Essential Objects web browser

2017.2.2.1035

2/2/2017 3:51 PM

New

• Allow for batch/lot/serial numbers in Post Order
• Support SSL/TLS in SMTP messages

2017.1.31.1109

1/31/2017 4:22 PM

New

• Add AGID number on work order form

2017.1.17.1827

1/17/2017 11:41 PM

New

• Add ActionID's for order details and load details in JSON API

2017.1.13.1346

1/13/2017 7:00 PM

Fixes

• Remove duplicate check for SMTP_SENTFROM in check installation

2017.1.13.1154

1/13/2017 5:01 PM

Fixes

• Make sure items posted from mobile are not re-inserted

2017.1.10.1743

1/10/2017 10:52 PM

Fixes

• ExportFuelOrdersPetro does not convert cancelremaining to bool
• Fix scroll and sum in fuel order detail inventory view

New

• ExportPetrolianceFleetFuelingSummary: Add "last modified date" to exported data
• Allow Trip Edit form to resize and scale order tab

2016.12.28.1030

12/28/2016 3:45 PM

Fixes

• PostEvent throws NullReferenceException

New

• Add StatusDescription to ExportOrdersToJSON job

2016.12.21.1722

12/21/2016 10:38 PM

Fixes

• Recurring Trips selector should disregard the "started on, not started, not ended, etc"

2016.12.21.1512

12/21/2016 8:25 PM

Fixes

• Export orders to JSON is not including shipperName and TripCode values in the export

New

• Make sure to check for new/updated loads when sending trip updates to mobile
• Add Hangfire.io to support additional background job processing

2016.12.9.1804

12/9/2016 11:14 PM

New

• Add TMLP customer type for PowerSurvey

2016.11.30.1721

11/30/2016 10:31 PM

Fixes

• Audit transdate is being adjusted too early
• alternateOrderNo was not read in PostOrder method for new orders

New

• Add actionID to loads
• Return DOT, EPA, DEXA codes for order lines
• Update API's to accept item DOT, EPA, DEXA codes; order detail action ids; and load action id's

2016.11.21.1739

11/21/2016 10:51 PM

New

• Send/Receive backordered amount to/from mobile

2016.11.15.1558

11/15/2016 9:11 PM

New

• ProcessMessageQ and AutoemailFuelInvoice should ensure a sent from email address

2016.11.14.1808

11/14/2016 11:29 PM

New

• Create custom form for MLGW for PSC

2016.11.11.1444

11/11/2016 7:55 PM

New

• Change order export to JSON job to include company code in filename
• Add recurring orders to orders export JSON

2016.11.2.1039

11/2/2016 2:45 PM

Fixes

• Use inventory transaction date in inventory history snapshot

New

• Support posting Events from the mobile

2016.10.20.1224

10/20/2016 4:37 PM

New

• Make sure all email addresses contain a valid value before attempting to send

2016.10.18.1233

10/18/2016 4:47 PM

Fixes

• Manual FODI entries set AssetID to wrong property

New

• Update DAL for PSC DEA changes

2016.10.12.1509

10/12/2016 7:23 PM

New

• Add validation to Exelon form

2016.10.12.1145

10/12/2016 4:00 PM

New

• Implement Geo-based searching for customers

2016.10.10.1611

10/10/2016 8:25 PM

Fixes

• Report Subscription form gets caught in infinite unhandled exception loop with some parameters

New

• Change authentication to return immediately if anyone of username, password or company code are blank.

2016.10.5.1538

10/5/2016 7:50 PM

New

• Export fuel orders to JSON
• Change MDS field to lookup for Exelon form in SVD

2016.10.4.1122

10/4/2016 3:35 PM

New

• Setup Con-Ed Inspections company workflow for PSC

2016.10.3.1024

10/3/2016 2:38 PM

Fixes

• GetTrip returns NRE when a new order and load are added to trip

2016.9.29.1733

9/29/2016 9:45 PM

Fixes

• New assets from mobile unit are not getting created

2016.9.27.1746

9/27/2016 9:55 PM

New

• Add job to import Numerex tank readings

2016.8.31.1153

8/31/2016 4:03 PM

Fixes

• Ortec web service export did not use timezones for start and end times

2016.8.30.1342

8/30/2016 5:53 PM

Fixes

• Ortec exports transposed start and end times for 'depart' and 'posttrip' actions

2016.8.29.1637

8/29/2016 8:47 PM

New

• Add Ortec web service integration

2016.8.26.1539

8/26/2016 7:49 PM

New

• Add job to export Ortec messages using their web service

2016.8.11.1647

8/11/2016 8:53 PM

Fixes

• ePOD auto-email job can sometimes throw ORM concurrency errors