Created by Miki Yanagi on Mar 29, 2021


Field Name Source or calculationNotes

Account

DESCR in UM_GLQ_ACCTA

Account Category

UM_ACCT_CAT_D in UM_GLQ_ACCTA

Account Category Code

UM_ACCT_CAT in UM_GLQ_ACCTA
Account GroupUM_ACCT_GRP_D in UM_GLQ_ACCTA
Account Group CodeUM_ACCT_GRP in UM_GLQ_ACCTA
Account NumberACCOUNT in UM_GLQ_REPRTINGtext
Account Number (int)ACCOUNT in UM_GLQ_REPRTINGinteger
Account Sub-CategoryUM_ACCT_SUBCAT_D in UM_GLQ_ACCTA
Account Subcategory CodeUM_ACCT_SUBCAT in UM_GLQ_ACCTA
Account TypeUM_ACCT_TYPE_D in UM_GLQ_ACCTA
Account Type CodeUM_ACCT_TYPE in UM_GLQ_ACCTA
Custom fields

Acct range (account receivable)

(Account[Account Number (int)] >=13000 && Account[Account Number (int)]<=13160)|| 
(Account[Account Number (int)] >=16000 && Account[Account Number (int)]<=16999)
Account range created for Account Receivable report
Acct range (account, grants & pledges receivable) 
(Account[Account Number (int)] >=13000 && Account[Account Number (int)]<=13409) || 
(Account[Account Number (int)] >=16000 && Account[Account Number (int)]<=16122) ||
(Account[Account Number (int)] >=13411 && Account[Account Number (int)]<=13452)
Account range created for Roll-Up RU-B Accounts, Grants and Pledges Receivable report
Group Inventory
each if ([#"Account Number (int)"] >= 14000 and [#"Account Number (int)"] <= 14500) then "Inventories" else if [#"Account Number (int)"] >= 15000 and [#"Account Number (int)"] <= 15100 then "Prepaids" else null)
Account group created for Inventories and prepaid expense report

Examples:


Attachments:

image2021-3-29_9-52-53.png (image/png)
image2021-3-29_9-8-38.png (image/png)
image2021-3-29_9-24-19.png (image/png)
image2021-3-29_9-24-34.png (image/png)
image2021-3-29_10-6-4.png (image/png)
image2021-3-29_10-6-52.png (image/png)