NAV FoodSoft Integration
NAV FoodSoft, provided by Compusoft Australia, is an ERP system for Food and Beverage Wholesalers. DSD Assist integrates with NAV FoodSoft to allow deliveries to be planned and Proof of Deliveries to be captured and sent to NAV FoodSoft.
Master File information from NAV FoodSoft to DSD Assist
The masterfiles for Customers, Products and Product Locations are emailed to the DSD Assist server once per day on a schedule set in NAV FoodSoft. The files should be emailed to files1@dsdassist.com. The schedule should be set so that the files are imported into DSD Assist before the Delivery Planning occurs so that any new customers and products are included.
The emails need to have the csv file attached with the name of searchresults.csv. The title of each email is as follows, replacing XXX with the three letter client code provide by DSD Support
Customers DSD_XXX:Customer
Products DSD_XXX:Product
Retrieving Orders from NAV FoodSoft into DSD Assist
From the DSD Portal navigate to the Trip Planning screen and select the Get Latest Orders button.
When pressed this button
- Writes back to NAV FoodSoft the Run Number and Delivery Sequence for each order on an Open Delivery Trip
- Executes a query on NAV FoodSoft to extract Sales Orders for the future and places them on the default Delivery Trip for each customer
Posting the Invoices in NAV FoodSoft
When the Invoices for the Run are posted in NAV FoodSoft the script in NAV FoodSoft creating an XML file of the finalised orders for the delivery run. This includes all pick time adjustments and represents a finalisation of the run.
The DSD Assist Extract Schedule checks the FTP site for the existence of the file. If a file is found it
- Deletes the orders for the Delivery Trip
- Recreates the Delivery Trip based on the finalised picking information
- Closes the Trip in DSD Assist so that no further changes can be made
- Creates the data for the delivery driver
- Deletes the file from the FTP site
Delivering Orders using DSD Delivery
When orders are delivered by the driver several integrations occur
- The Receiver Name is written to the Invoice in NAV FoodSoft
- The Delivery Temperature is written to the Invoice in NAV FoodSoft
- The date and time of the delivery is written to the Invoice in NAV FoodSoft
- The POD delivery docket is written to NAV FoodSoft including the signature and delivery photograph
Related Articles
MYOB AccountRight Integration
DSD Assist supports MYOB AccountRight Live using the MYOB API for data integration. It is possible to integrate with MYOB AccountRight on premiss but that is not our preferred option. The AccountRight API supports all versions of AccountRight, for ...Routific Integration
DSD Assist can be connected to Routific route optimisation using our standard connector. When orders are imported into the DSD Connect portal the delivery sequence can be optimised so that your delivery drivers are as efficient as possible. ...Ordermentum Integration
DSD Assist can be connected to Ordermentum using our standard connector. The integration allows clients to enhance the data they receive from their accounting system with additional information held within Ordermentum. Using DSD Salesforce a sales ...Mailchimp Integration
DSD Assist can be connected to Mailchimp using our standard connector. DSD Connect Customer and Contact data is sent to Mailchimp once each day so that you can create and send emails to your customers. We load the Mailchimp Audience with the ...Unleashed Integration
DSD Assist can be connected to Unleashed using our standard connector. The integration allows clients to use of DSD Connect Portal to plan their delivery trucks and DSD Delivery mobile application to obtain a Proof of Delivery. We extract ...