If you use the General Ledger Interface to export general ledger transactions to MAS 90 or MAS 200 or export journal entries to QuickBooks, every product that you sell must be assigned to a financial group. For information about assigning products to financial groups in the Products & Services window or in the Maintain Products window, go to the “Maintaining Product & Service Information” in the OfficeMate Home Office User’s Guide.
To determine which products in your database have not been assigned to a financial group, you must create a report that lists these products. To create a report for products without financial groups, perform the following steps:
-
From the OfficeMate or OfficeMate Home Office main window click Reports.
The Reports & Statements window opens.
-
Click the Custom tab.
-
Select Inventory Custom Reports.
-
Click Open.
The OfficeMate Custom Inventory Reports window opens.
-
Type a name in the Report Name field, for example, “Products without Financial Groups.”
-
Select the Use as Title check box.
-
Select Stock Status from the Report Type drop-down menu.
-
Select Product Name from the Report Detail drop-down menu.
-
On the Report Options tab, select all of the Product Status and Consignment check boxes, deselect the Include Inactive Products check box.
-
Select the Include Products with Zeros in All Selected Quantity Columns check box.
-
Click the Product Types tab.
-
Select the Financial Groups radio button.
-
Click the double-left arrow (<<) to move all items from the Selected column to the Available column.
-
Double click [None] to move it back to the Selected column.
-
Select Manufacturer check box from the Report Grouping group to list the products by Manufacturer.
-
Click Save to save the report settings.
-
Click Process to run the report.
Use the report to determine which products need financial groups and update the product information in the Products & Services window or the Maintain Products window.