Summary

The Account Assign process allows you to modify the general ledger accounts attached to a filtered group of inventory items. This process will delete all general ledger accounts attached to the inventory items and replace them with the selected general ledger accounts.

Step by Step

1     Open or create an Account Assignment batch.

• Select the Account Assignment palette in IC> Account Assignment. This will expand the Account Assignment palette and display the steps of the Account Assignment batch process.
• Modify an existing batch or create a new Account Assignment batch.
  • The Account Assignment process is a single batch process, meaning you can process only one batch at a time. If there is an open batch in the process, you will not be able to create a new batch. If you would like to create a new batch, you can either delete the existing batch (highlight the batch in the batch number drop-down at the top of the Account Assignment palette and press DELETE), or you can reset the steps on the palette by returning to the first step of the process. If you return to an earlier step of the process, all of the information in the previous batch will be overwritten.
  • Select New from the Account Assignment batch number drop-down menu to create a new batch. This will open the New Batch window.
  • Enter a Batch Month and Batch Year. These fields default to the current calendar period and are for reference only. The fiscal period of the transactions in the batch is determined by the Journal Entry Date entered during the Generate step.
  • Click the Generate icon to populate the Batch Number field with the next available batch number. Batch numbers are limited to five digits and must be unique within the batch month of the batch year.
    • You can also manually create a new batch by entering a Batch Number and clicking the Save icon.

2     Filter the inventory items included the batch. 

• Open the Generate window (IC> Account Assignment> Generate).
• Check the toggle next to each Location of the inventory items you would like to include in the batch. You must check at least one location to process the batch.
  • Press CTRL+A and then press SPACE to select all of the displayed locations.
  • Locations are created and maintained on the Location Maintenance window (IC> Maintenance> Location).
  • Inventory items are associated with locations on the Item Maintenance window (IC> Maintenance> Item> Quantity and Value tab> Location section).
• The From Item Number and To Item Number fields are used to specify an inventory item range that will be included in the batch.
  • Click the field labels to select the item numbers from a list.
• The Description Begins field is used to filter the items included in the batch by the item description.
  • Descriptions are added to inventory items on the Item Maintenance window (IC> Maintenance> Item> General tab> Description field).
• The Character fields are used to filter the items included in the batch by the user defined miscellaneous fields.
  • Miscellaneous field labels are maintained on the Miscellaneous Field Label Maintenance window (SS> Utilities> Miscellaneous Field Labels).

3     Add GL accounts to the batch.

• Click the Add icon to add a GL account to the Accounts section. This will open the Chart of Accounts Selection window.
  • Highlight the account you would like to add to the batch and click the Confirm icon   to add it to the batch.
• Enter an Account Type for the account line item or click the Ellipsis icon   to select an account type from a list.
  • Each GL account attached to an inventory item must have a specified account type. The account type determines which type of inventory transactions will use the selected GL account. This is a required field.
  • Account types are created and maintained on the Account Type Maintenance window (IC> Maintenance> Account Type).
• Enter a distribution Percentage for the account. This value must be between 1 and 100.
  • You can attach multiple accounts for each account type, but the total distribution for the account type cannot exceed 100%.
• Repeat this process to add additional accounts.
• Click the Confirm icon when complete.

4     Print the Account Assignment Proof List.

• Open the Account Assignment Proof List window (IC> Account Assignment> Proof List).
• Click the Print icon   to process the report immediately or enter a date and time in the field next to the Print icon to schedule the report to generate at a later time. You can view the progress of the report on the Job Viewer window (SS> Utilities> Show Scheduled Jobs).
  • Click the Print icon drop-down menu and select Print Preview to preview the report before printing.
  • Click the Print icon drop-down menu and select Excel to export the report data to an Excel spreadsheet as unformatted data.
  • Click the Print icon drop-down menu and select Excel (Formatted) to export the report data to an Excel spreadsheet that includes much of the Springbrook formatting found on the printed version of the report.
  • Once the report is generated, you can also display the report using the View Reports window (SS> Utilities> View Report).
• The report will display the Inventory Item, Description, Account Type, Account and Percentage for each line item included. A Percentage Total for each Account Type will also be included.

5     Commit the Account Assignment batch.

• Open the Commit Account Assignment window (IC> Account Assignment> Commit).
• Click the Confirm icon to commit the batch.
• If any of the inventory items included in the batch are associated with uncommitted transactions, you will not be able to commit the batch. The Jobs Viewer Exceptions window (SS> Utilities> Show Scheduled Jobs> Detailed Error Message icon) will display the process and batch number for each item that includes uncommitted transactions.