Department/Material Code Cross Reference

(DBMC.exe) This program will allow you to cross reference an account number and a material code to another account number for charging purposes. You will be able to enter in a specific account number and material code and then select the corresponding cross referenced account number.

Adding or Removing a Department/Material Code Cross Reference

First choose the Entity, on the right side of the screen, by using the drop down. In the Dept field, enter in the Department which will be charged to another account number, a list of account numbers assigned to that Department appears. In the Material Code field, select the material code, by clicking on that line that must be associated with the account number you have just chosen. To access the lookup click on any line and press F8. Then, in the Cross Reference Account # field, enter the account number which will be charged, change the Entity if applicable. You may do a lookup in any of these fields to find the desired account numbers. Move the appropriate Account No(s) into the center field by selecting the Account No(s) in the right column and using the (<) button. You may also choose to select by Sub Account instead of by Department in the right column, by clicking on Sub Acct radio button. You would then enter the Sub Account, and a list of Departments with that assigned Sub Account appears.
Use the (>) button to remove Account Numbers from the center column if necessary. May multi-select Account Numbers when adding or removing by using the CTRL key.

In View on the Applications menu, the user may elect to Only Show Cross Referenced Mat Codes. This will only display Material Codes that have already been cross referenced.