GL Accounting Variables are used for reporting designations like companies, divisions, departments, geographies, cost centers, profit centers, or business units. If set up, these variables would be used on source transactions, such as Billings, and Payables.  For example, if you elect to use a GL Account Variable to track departmental costs, you may set up GL Account Variable Type 1 to represent your Departments and setup values such as Sales, Marketing, Product Development, Services, etc. Then, when recording a Payable for the Sales department, you would populate GL Variable 1 as Sales for that particular Payable.  

Accounting Seed allows for four General Ledger Variables with unlimited values in each. The GL Variable field name can be changed to reflect what it represents with the Translation Workbench Salesforce tool. For example, this would allow for the GL Variable 1 field name to be replaced with “Department” on all your source entries (Billings, Payables, Journal Entries, etc…) See also  Changing Labels for GL Variables.

Summary of Steps:

  1. Navigate to Accounting Home and in the General Ledger Setup section click the General Ledger Variables link.
  2. Click New Accounting Variable button.
  3. Enter the Accounting Variable Name.
  4. Choose the Type: GL Accounting Variable 1, 2, 3 or 4.
  5. Check the box if the Accounting Variable is Active.
  6. Click Save or Save & New to add another variable.



ASU-banner-4.jpg 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

4 Comments

  • 0
    Avatar
    Rebecca Ralls

    Do you know of anyone who has made GLAV variables dependent on other GLAV?  For example: The GLAV 3 values that are valid/available to be assigned to a transaction depend on which GLAV 2 value the user has selected? Do you have suggestions on the best way to accomplish this? TIA!

  • 0
    Avatar
    Tony

    Hi Rebecca,

    You can block certain combinations of GLAVs using validation rules, but we do not have dependent GLAVs like you would Dependent Picklists. 

  • 0
    Avatar
    Jackie Southon

    Do you see any issues with us creating validation rules that make the use of GL Variables 1 to 3 mandatory for our Billings and Payables and Journal Entries? Are there any background transactions / rules we need to be aware of if we make GL Variables mandatory for our transactions?

  • 0
    Avatar
    Bao Do

    Hi Jackie,

     

    I would recommend going to the Billing Line, Payable Line and JE Line page layouts and editing the fields to make them required rather than creating a validation rule.  If not designed correctly, a custom validation rule can interfere with the creation and saving of Billing and Payable Aging History records during the Accounting Period close process.

    Also goto the MassAddEditRows Field Set and make the GLAVs there required as well.

     

    Thanks,

    Bao

Please sign in to leave a comment.