GL Categories Listing Instructions

Use the GL Categories Listing to generate a list of GL categories and their associated Cost of Goods sold (COGS) accounts, sales accounts, inventory accounts, markup accounts, and overage/shrinkage accounts.  GL Categories define the GL accounts the Inventory will post to in certain situations.

Tips:

• This report is only applicable if GL integration is active.

• For more information about running reports, see Print View.

• For more information about the buttons on the toolbar, see the Reporting Toolbar.

Directions:

To see directions for...

• Opening the GL Categories Listing, click More.

   

  1.  Click Listings from the Menu Bar.

  2.  Click GL Categories Listing.

   

  GL Categories Listing Window Example:

  

   

• Choosing the Selections for the report, click More.

   

  GL Categories Listing Prompts Tips:   To see more information about a field, click the hyperlink for the field name. GL Category Listing Parameters can saved and then, loaded after being saved.  For information, see Reporting Toolbar.
  ID	To specify a range of GL Category IDs to include in the report, enter the lower range/beginning ID.  To specify the ending range, enter the upper range ID. Notes:   To include all IDs in the report, leave the lower and upper range blank for All.   Or, to only include a specific item, enter the ID as the lower range. To search for an ID, click in the lower or upper range and then press [Ctrl + f].
  Sales Account	To specify a range of sales accounts to include in the report, enter the lower/beginning sales account.  To specify the ending range, enter the upper range sales account. Note:  To include all sales accounts in the report, leave the lower and upper range blank for All. Or, to only include a specific sales account, enter the specific sales account as the lower range.
  Inventory Account	To specify a range of inventory accounts to include in the report, enter the lower/beginning inventory account.  To specify the ending range, enter the upper range of the inventory account. Note:  To include all inventory accounts in the report, leave the lower and upper range blank for All.   Or, to only include a specific inventory account, enter the inventory account as the lower range.
  COGS Account (Non-Job)	To specify a range of  COGS (Non-job) accounts to include in the report, enter the lower/beginning COGS account.  To specify the ending range, enter the upper range COGS account. Note:  To include all COGS accounts in the report, leave the lower and upper range blank for All. Or, to only include a specific COGS account, enter the specific COGS account as the lower range.
  COGS Account (Job)	To specify a range of  COGS (Job) accounts  to include in the report, enter the lower/beginning COGS account.  To specify the ending range, enter the upper range COGS account. Note:  To include all COGS accounts in the report, leave the lower and upper range blank for All. Or, to only include a specific COGS account, enter the specific COGS account as the lower range.
  JC Markup Account	To specify a range of job cost (JC) Markup Accounts to include in the report, enter the lower/beginning JC Markup Account.  To specify the ending range, enter the upper range JC Markup Account. Note:  To include all accounts in the report, leave the lower and upper range blank for All. Or, to only include a specific account, enter the specific JC Markup Account as the lower range.
  Overage/Shrink Account	To specify a range of overage/shrink accounts to include in the report, enter the lower/beginning overage/shrink account.  To specify the ending range, enter the upper range of the overage/shrink account. Note:  To include all accounts in the report, leave the lower and upper range blank for All.   Or, to only include a specific overage/shrink account, enter the overage/shrink account as the lower range.
  Sort Parameters
  Sort	To specify the sort parameters, click Sort and the following screen displays.
  Order	To specify the fields to sort the report by, enter any positive number into the Order field.  A value of 1 means sort by this field first, 2 means sort by this field second and so on.  The numbers do not need to be sequential but they must be greater than zero.  In the example above, GL categories are sorted by ID. Notes: Two sorts with the same number will get sorted before others with larger numbers and after those with smaller numbers, but the actual order for those two sorts is indeterminate. To remove a sort order for a field, delete the value in the Order field.
  Ascending	To sort in an ascending manner, click to select the Ascending checkbox.  Or, leave the Ascending checkbox blank to sort in descending order.
  Active	The Active flag must to set to enable the field to be sorted.  To set the Active flag, click to check the corresponding checkbox.  Important:  If Active is unchecked, the field will not be used for sorting even if there is a Order value entered for the field.
  	To begin printing to the Windows® default printer, click Print, or press [ENTER]. Or, to print to the Print View window, click Print View . Or, to escape from the print routine, click Cancel .

   

• Report Sample(s), click More.

   

  To see an example of the report, click GL Categories Listing Sample.