https://help.myob.com/wiki/x/awmc
RetailManager
ANSWER ID:9419
This page describes how to export stock records from RetailEnterprise into RetailManager. First, you'll run the Import & Export Wizard in RetailEnterprise, then import the file into RetailManager.
1. Run the Import & Export Wizard in RetailEnterprise
- Open RetailEnterprise Central.
- Go to the File menu and choose Import & Export. The Import & Export Wizard is launched as shown below.
- Select the Export Data option.
- Click Browse and open the RMCentral.mdb file.
- From the drop-down list select the table called Stock and click Export. This will export all stock from your Enterprise Database.
- Specify the folder where you want to save the export file. You can choose to export the file to any location, including a USB sick, CD ROM, or over a network to another computer. To change the location, click the drop down arrow on the right hand side of the Save In field then browse to the location of your choice.
- Click OK to the following message.
When Exporting Stock from RetailManager Enterprise all Cost and Sell Prices are Tax Inclusive.
2. Import stock into RetailManager
- Start RetailManager at your store location.
- Go to the File menu and choose Import & Export.
- Click Continue.
- Select Import then click Next.
- Browse to find your stock.txt file which was exported in the first part of this support note.
- Bowse to find your Shopfront Folder (the database you want to import into), and open recent.mdb, then click Next.
- Change the Field Separator option to Tab as shown below.
- Click Next.
- Select the Add or Update option depending upon the function you are performing. An Add import will only add new records to the database; if the record already exists it will be ignored. An Update import will only update changes to existing records; if the record does not exist in the database it will be ignored. Select Tax Inclusive for the Imported costs and sell prices are option. See our example below.
- Click Next.
- Select the Match All By Name option and confirm that all fields are matched appropriately.
- Click Import.
For detailed Import/Export utility instructions, please refer to your RetailManager user guide.