Data validation

Use this guide to create Inform reports to substantiate converted records for customers, vendors and products.

1. Run reports substantiating converted balances

   1. Produce an Accounts Receivable Aging Report to produce a record of the converted customer balances.

      This report will also be saved on the DDI server at D > IBM > ACCOUNTS > DDI > PRINT.FILES > AR GO-LIVE.

      1. Go to Accounting > Accounts Receivable > Aging Report.
      2. Click Detail and leave all other fields at the default setting.
      3. Click Run.

         

      4. The Print Document window will appear. To export the report to Excel choose Save.

         

      5. Inform will proceed to your Windows environment. Choose a file location and name and save as .xls or .xlsx.

         

         The completed report is sorted by customer name and open invoice number.

         

   2. Produce an Accounts Payable Aging Report to produce a record of the converted vendor balances.

      This report will also be saved on the DDI server at D > IBM > ACCOUNTS > DDI > PRINT.FILES > AP GO-LIVE.

      1. Go to Accounting > Accounts Payable > Aging Report.
      2. Click Detail and leave all other fields at the default setting.
      3. Click Run.

      

      4. The Print Document window will appear. To export the report to Excel click Save.

         

      5. Inform will proceed to your Windows environment. Choose a file location and name and save as .xls or .xlsx.

         

         The completed report is sorted by vendor name and open invoice number.

         

   3. Produce an Inventory Value Report to validate converted stock items.

      This report will also be saved on the DDI server at D > IBM > ACCOUNTS > DDI > PRINT.FILES > INV VAL GO-LIVE.

      1. Go to Inventory > Inventory Value Report.
      2. The Product Selection Criteria window will appear. This is useful for filtering the request for a specific category of items and sorting the output.
      3. Click OK to bypass the criteria and choose all records.

         

      4. A message will ask whether you want to report on all products. Click Yes.
      5. The Inventory Value Report window will appear. Fill out the following requirements.
         • Warehouse: Leave blank to choose all warehouses. See footnote below about Drop Ship Warehouse Value.
         • Cost Column: The displayed value is your inventory G/L costing method.
         • Detail or Summary: Choose Detail.
         • Product Line Page Break: Leave unchecked.
         • Include Negative Inventory: Choose Yes.
         • The remaining items may be left blank.
      6. Click Run.

         

      7. The Print Document window will appear. To export the report to Excel click Save.

         

      8. Inform will proceed to your Windows environment. Choose a file location and name and save as .xls or .xlsx.

         

         The completed report lists every on hand item with a column for each warehouse and a total column.

         

      9. *Go to File > Company > Master > Pricing and Costing > Include Drop Ship Warehouse in Inventory Value for All Warehouses to enable this setting. The monthly export will include a Drop Ship Column.

         

2. Create customer and vendor listings to verify key fields

   1. Produce a Customer Master Report to produce a record of key fields.
      1. Go to File > Customer > Master > Report.
      2. The Customer Selection Criteria window will appear. This is useful for filtering the request for a specific category of customers and sorting the output. The default filter excludes prospects. If this field is clicked a system prompt will ask whether to choose all customers. Choose OK to bypass the criteria.

         

         

      3. The Field Selection window will appear. Build the report by dragging fields from Available Fields on the left to Print Order on the right. The Filter icon may be used to search for a particular field.

         

      4. Click OK and the Print Document window will appear.

         

      5. Click Save to convert the content into Excel format.

         

   2. Produce a Vendor Master Report to produce a record of key fields.
      1. Go to File > Vendor > Master > Report.
      2. The Vendor Selection Criteria window will appear. This is useful for filtering the request for a specific category of customers and sorting the output. A system prompt will ask whether to choose all vendors. Click OK to bypass the criteria.

         

         

      3. The Field Selection window will appear. Build the report by dragging fields from Available Fields on the left to Print Order on the right. The Filter icon may be used to search for a particular field.

         

      4. Click OK and the Print Document window will appear.

         

      5. Choose Save to convert the content into Excel format.

         

3. Validate Accounting Records

   1. Produce a G/L Account Report to produce a record of converted accounts.
      1. Go to Accounting > General Ledger > G/L Account.
      2. The G/L Account Master window will appear. Click the Report button to create a custom list.
      3. The Field Selection window will appear. Build the report by dragging fields from Available Fields on the left to Print Order on the right.

         

      4. Click OK and the Print Document window will appear.

         

      5. Click Save to convert the content into Excel format.

         

      6. Content may also be exported to a pdf document by changing the file type to Portable Document Format.