In this walkthrough, you will learn how to add data and opening inventory to your first PILOT company. A PILOT company is a test company where you can test your setup and data.
This walkthrough provides an overview on how to do the following:
Louise's Bakery is implementing JustFood, and wants to test the product before going live. Before testing can start, data needs to be imported into the LouiseBakery_PILOT1 company.
Setup data, regular data, and opening inventory can all be imported using configuration packages.
Setup data can be imported into the new company using the JUSTFOOD package. The JUSTFOOD package contains the typical JustFood setup.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
Import the JUSTFOOD package.
Note: You'll need to contact your JustFood representative to obtain the JUSTFOOD package, and then store the package in an accessible folder location.
On the Home tab, choose Import Package.
Navigate to the JUSTFOOD package (PackageJUSTFOOD.rapidstart), and click Open. The JUSTFOOD package is added to the Configuration Packages window.
Double-click the JUSTFOOD package.
Review and update the package data. This is the data that will be imported in to the LouiseBakery_PILOT1 company.
Select the table that you want to review.
In the Tables tab, choose Package Data. The Config. Package Records window opens and lists the data in the package for the selected table.
If required, update the data.
If you don't want to import the data, delete the line.
Click OK. The Config. Package Records window closes.
Repeat for the remaining tables.
On the Home tab, choose Apply Package.
Click Yes to apply the package. This may take a few minutes.
Click OK. Any tables that had an error will be in red. If a table had an error, then the data from that table will not have been applied to the company database.
Correct any errors.
Select the table that had the errors.
On the Table tab, choose Errors. The Config. Package Records window opens showing the records that had an error.
Select a line.
On the Home tab, choose Show Error. Make a note of the error so that you can fix it.
Close the Error window.
On the Config. Package Records window, correct the data that is causing the error, and then click OK.
On the Config. Package Card window, select the table where you corrected the errors.
In the Functions tab, choose Apply Data.
Click Yes. The package data is now applied to the company database.
If a value other than zero exists in the No. of Package Records column, then that data was not applied to the company database.
You need to import company data such as customers, vendors, locations, items, etc.
This example is going to show how to import customers.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
On the Config. Packages window, choose the New action. A configuration package allows you to choose a table and the fields that you want to populate with data.
On the Config. Package Card window, populate the following fields on the General FastTab:
Code: Enter CUSTOMERS.
Package Name: Enter Customers.
On the Tables FastTab, in the Table ID field, select 18, which represents the Customer table.
Select the fields that you want to populate with data. You don't want to enter data for every customer field so you need to choose the fields that you want to add data to.
On the Table tab, choose the Fields action.
On the Config. Package Fields window, choose the Clear Included action. This clears the Include Field check boxes.
Select the Include Field check box for the following fields: No., Name, Address, City, Contact, Phone No., Credit Limit, Country/Region Code, Post Code, County and E-Mail.
The fields, where the Include Field check box is selected, will appear in the Excel spreadsheet where you will enter the customer information.
Note: The County field represents the state or province.
Click the Include Field column heading, select Filter and select Yes to see the fields where the check box was selected.
The fields are listed in the spreadsheet according to the Processing Order field.
Using the Move Up or Move Down actions on the Actions tab, update the order of the fields by updating the value of the Processing Order field to be the same as the screen shot below.
For fields that have a value in the Relation Table ID field, that means you need to enter codes that exist in the system. Before you begin entering data in the Excel spreadsheet, you need to know what those codes are. In this example, the Post Code, Country/Region, and County tables need to contain the records that you will be using when adding vendor records.
Close the window.
The No. of Fields Included field was updated.
These steps explain how to export the package to Excel, and to populate the spreadsheet with data.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
On the Config. Packages window, open the CUSTOMERS record.
Export the configuration package to Excel. This creates an Excel spreadsheet with the fields that you selected.
Select the Customer row in the Tables FastTab.
On the Excel tab, choose the Export to Excel action.
Choose Yes to continue.
Save and open the spreadsheet.
Enter the data in the Excel spreadsheet.
Some points to be aware of:
No.: You can leave this field blank since the number will be automatically populated based on the number series defined in the Customer Nos. field on the Sales & Receivables Setup window. If you want to enter customized customer numbers, you can choose to enter a value.
City, and ZIP Code: It is recommended that values entered in these fields exist in the Zip Codes window. If you enter values that do not exist in the window, you will NOT receive an error when importing but the zip code/city/country/state combination will not be added to the Zip Codes window.
State: The values entered here should exist in the States window. If the values do not exist, you will receive an error when importing the data.
Country/Region Code: The values entered here should exist in the Countries/Regions window. If the values do not exist, you will receive an error when importing the data.
Save and close the spreadsheet. Important: If you do not close the spreadsheet, you cannot import it into JustFood.
Now that you have populated the spreadsheet with some customer data, you can now import that data into JustFood.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
On the Config. Packages window, open the CUSTOMERS record.
On the Excel tab, choose the Import from Excel action.
Click Choose.
Select the spreadsheet that you populated with the customer data.
The No. of Package Records field is updated to show the number of records to be applied to the database. At this point, the records have not been added to the database.
Note: If the spreadsheet wasn't imported, make sure that you closed the spreadsheet in Excel.
Review the data. You can double-check the data and make any necessary changes.
In the Tables FastTab, click the number in the No. of Package Records field.
On the Config. Package Records window, review the data.
You can update the data, or delete a line, but you cannot add lines here.
Click OK to close the window.
Apply the data to the database. This step adds the customer records to the database.
In the Tables FastTab, select the Customer row.
On the Functions tab, choose the Apply Data action. This action applies the data in the selected table.
Click Yes to continue. A message is displayed showing records were inserted.
The customer records are added to the database. Any tables that had an error will be in red. If a table had an error, then the data from that table will not have been applied to the company database.
Now that all of the required data has been added to the LouiseBakery_PILOT1 company, the opening inventory can be added so that Louise Bakery can start testing.
The OPENING INVENTORY package allows you to add inventory. The Item Journal table, in the OPENING INVENTORY package, allows lot numbers, item expiration dates and net weights to be loaded into the Item Journal, and then be posted without adding item tracking.
These steps are going to explain how to add lot numbers to the data without adding item tracking.
Data has been added to the database, such as items, locations, and bins.
Item tracking is set up for the items being added to inventory. That is, on the Item Card window, a value was selected in the Item Tracking Code field.
You need to populate the Item Journal window with the items that you want to add data to.
Open the Item Journal window.
Select a batch name. For example, OPENINV. Make note of the batch name.
Delete any lines in the journal.
Add the following information for each item that you want to add inventory to:
Entry Type: Select Positive Adjmt.
Document No.: Enter a document number.
Item No. Select the item that you want to add inventory to.
Location Code: Select the location of the inventory.
Bin Code: Select the bin that the inventory will be placed in.
Quantity: Enter the amount of items to add to inventory.
Unit of Measure Code: If not populated, select a unit of measure code.
Choose the Search icon, enter configuration packages, and select Configuration Packages.
On the Config. Packages window, open the OPENING INVENTORY package. This package is added when a new company is created.
Select the Item Journal Line record.
In the Excel tab, choose Export to Excel.
Click Yes.
Save the file.
From the Excel spreadsheet, you can enter the lot number, and choose the setting that allows you to add inventory without item tracking.
Open the Excel spreadsheet that you just created.
Delete all of the lines except for the ones where the Journal Batch Name is the same as the batch that you selected when populating the item journal.
Enter the lot numbers in the values in the Lot No. field.
If required, enter the total net weight of the items in the Net Weight field. Note: If the Net Weight field is blank, then the net weight will be inherited from the item card. If the Net Weight field is zero (0), then the net weight will remain zero.
Enter TRUE in the Post Using Line-Level Lot No. field for all items that you want to add the lot number. This will allow you to post the records from the Item Journal without having to add item tracking.
Save and close the spreadsheet. Important: If you do not close the spreadsheet, you cannot import it into JustFood.
From the OPENING INVENTORY Config. Package Card window, select the Item Journal Line record.
In the Excel tab, choose Import from Excel.
Select the Excel spreadsheet that you just saved. The value in the No. of Package Records field is updated once the spreadsheet is imported.
On the Functions tab, choose Apply Data.
Click Yes to continue. You will receive a message saying how many records were modified.
Now that the lot numbers have been assigned to the item, you can return to the Item Journal window, and add the items to inventory.
Open the Item Journal window.
Select the batch name that corresponds with the batch name where you added your items for opening inventory.
On the Home tab, choose Post.
Click Yes to post the journal lines.
The items have now been added to inventory.
Testing can begin now that the LouiseBakery_PILOT1 company is populated with data. See Working with PILOT Companies and Creating a LIVE Company for information about how to create new PILOT companies and a LIVE company.
About JustFood RapidStart
About RapidStart Walkthroughs
About JustFood Walkthroughs
© 2018 Microsoft and IndustryBuilt. All rights reserved.
JustFood 2018 (11.00.00.00) | February 2018