Functional area

Guidance for scoping

General ledger history

• Prior years' history: Periodic balances for 2 years
• Current year until a set date, periodic balances

Customers

• All the active customers (and addresses)
• Has performed a transaction in the last 18 months, has an open balance, or has open sales orders

Vendors

• All the active vendors (and addresses)
• Has performed a transaction in the last 18 months, has an open balance, or has open purchase orders

Products and prices

• All the active products and prices
• Products have been created in the last 6 months, there is stock in hand, the product has open purchase, sales, or production orders, or the product was sold in the last 12 months
• Prices: All the active and future prices for customers and vendors
• Trade agreements and sales/purchase agreements in Dynamics 365 for Finance and Operations terminology

Open AP

• Migrate all the open documents: Invoices, payments, and debit notes
• Key fields: Vendor ID, open amount, description, due date, invoice number, document number, document date (original invoice date), method of payment, PO/reference, or any other information that you need in order to pay the vendor
• You should be able to run vendor aging and pay the vendors (1099 reporting considerations)

Open Accounts Receivable (AR)

• Migrate all open documents: Invoices, payments, and credit notes
• Key fields: Customer ID, open amount, description, invoice number, original date, due date, method of payment, customer PO number, and reference to sales order number
• You should be able to run customer/AR aging and collect payments from the customers

Inventory (on hand)

• Migrate in-hand inventory for each product by dimensions
• Are your product's numbers changing (this would mean changing labels in the warehouse)?
• Cost for each lot and dates for batch numbers
• Review the impact on inventory costing

Open orders

• Open sales orders and open purchase orders – orders that haven't been delivered yet
• Discuss the returns (you may need to refer to the old system for a short period of time)
• Orders that are delivered but yet not invoiced

Bank balances

• The last-reconciled balance
• Unreconciled transactions

Fixed assets

• The active assets: Assets that are in the possession and in the books
• Key values: Fixed asset number, acquisition price, accumulated depreciation till date, remaining periods, acquisition date/put-in-service date, date depreciation last run, serial number, assigned to, dimensions, and so on