Reviewing Inventory Balances

The item, warehouse, and location quantity on-hand values from the source system are imported into CloudSuite Industrial through miscellaneous issues or miscellaneous receipts, using the default reason codes and the settings that are specified in the Import Parameters form.

This allows the corresponding material transactions and journal entries to be created in CloudSuite Industrial. The corresponding costing, lot and serial data for the items is also created.

After the source data is imported through the preliminary data transfer, you can use the Import Inventory Balances form to review and correct this item data as it will appear in CloudSuite Industrial. Do this before you run the final transfer.

On the Import Parameters form, ensure that a Miscellaneous Receipt Reason Code and a Miscellaneous Issue Reason Code are specified. These codes are applied to all receipt or issue transactions.
On the Import Data Transfer form, perform the preliminary data transfer of source tables that contain item, warehouse, and location on-hand quantities.
On the Import Inventory Balances form, review these values for each of the listed items:
- Item number, description and unit of measure
- Warehouse and location where the item will be placed, and the quantity on-hand in that location
- Lot or serial number of the item
- Material, labor, fixed overhead, variable overhead, and outside cost of the item
- Unit cost of the item
- Inventory account used for the item
Save any changes.

At this point, you can perform the final data transfer on the Import Data Transfer form.

Note: Because the journal entries created through these processes already exist in the source system, these accounts should not be included in the beginning balances. An Opening Balance account ensures that accounts are balanced after all data has been migrated. Also, the inventory balances that are migrated into CloudSuite Industrial already contain the changes caused by the issue or receipt of items for released jobs.