Mod #1390 Foodbuy Sales Export Defaults to PIPE Format

The Foodbuy Export will always default to Use PIPE formatting.

 

•entrée V4 SQL will create a data folder Foodbuy that will be stored in your necs_shared\01\Foodbuy folder.

•Creates an output CSV file to export invoices.

 

Requires: Foodbuy Sales Export Mod #1242.

 

entrée Folder

The export staging: necs_shared\01\Foodbuy

Where "01" is the entrée company number.

 

entrée Settings

•Customer File: Mark all your Foodbuy Customers.

1.Go to the Customer ribbon menu click the Customer option.

2.Find the desired customer and go to the Miscellaneous tab on the far right.

3.In the Export Options check Foodbuy Customer.

4.Click Apply to save.

 

Configure the Export

1. Go to the Add-Ons ribbon menu  click Import/Export icon.

2. Select Export Data and the entrée Export dialog will open.

3. In Export the data To select Foodbuy Sales.

 

4. Click Configure to open the Foodbuy Configuration dialog.

5. Enter your assigned Distributor ID.

6. Click FTP Settings the first time you are in this dialog to setup your FTP connection.

 

7. Foodbuy FTP Configuration: Values are supplied by Foodbuy when they create your account. Enter the FTP connection settings provided.

 

 

8. Export Directory: Enter the location of your necs_shared\01 folder. Where "01" is the entrée company number.

Export File Ext is csv.

 

9. Click Apply then OK.

 

Export

1. Go to the Add-Ons ribbon menu click Import/Export icon.

2. Select Export Data and the entrée Export dialog will open.

3. In Export the data To select Foodbuy Sales.

4. Click Generate.

5. In the Foodbuy Export dialog set the Export data from and To dates.

•Checked by default is Use PIPE formatting.

 

6. Check the box for Include Invoice data that has already been sent if needed.

 

7. Click Generate to run the export.