If you're wondering why your ERP system's data isn't visible, unassigned accounts might be the culprit. This guide provides a straightforward solution, helping you identify and map unassigned accounts in Catalyst. We'll walk you through the steps and shed light on the importance of mapping in keeping your financial data organized. Whether you're using overnight automation or manual uploads, this guide ensures your Catalyst reports are accurate and comprehensive.
Common Question
"Our ERP system shows certain data and amounts, but we can't see these data in the Catalyst Excel cube. Why not?"
Answer
The data visibility issue in the Catalyst Excel cube often stems from unassigned accounts. Unassigned accounts act as a common stumbling block, as any amounts tied to these accounts remain hidden until they are assigned to the correct buckets.
Resolution Steps
- Navigate to Admin > Hierarchies > Account Hierarchy > Export/Upload tab > Unassigned.
- Unassigned accounts can be found under the Export/Upload tab within the Account Hierarchy section or under the Tree View tab.
- Unassigned accounts can be found under the Export/Upload tab within the Account Hierarchy section or under the Tree View tab.
- Go to Administration > Site Management > Hierarchy > Edit Account Hierarchy.
- Toggle to Export/Upload to filter to the company you're interested in and select Unassigned.
- Export the list and fill in the levels to map these accounts to the correct area in your P&L or Balance Sheet.
Detailed Resolution
- Export Unassigned Accounts
- Go to Administration > Site Management > Hierarchy > Edit Account Hierarchy.
- Toggle to Export/Upload and filter to the relevant company.
- Select the Unassigned option. Click Apply.
- Download and Open in Excel
- Export the list and open it in Excel.
- Export the list and open it in Excel.
- Attribute Hierarchical Relationships
- Fill in the levels in Excel to properly attribute hierarchical relationships.
- Populate the unassigned cells with existing names, such as Income Statement > Net Sales > Online Sales > Department > Account Name > Account ID.
- Map to Correct Area
- Once filled, these hierarchical relationships will help map unassigned accounts to the correct area in your Profit & Loss (P&L) or Balance Sheet.
- Upload back into Catalyst
- To apply your mapping, upload the data from your file using the EBM Office Bridge ribbon upload button.
- To apply your mapping, upload the data from your file using the EBM Office Bridge ribbon upload button.
By following these steps, you can effectively resolve the issue of missing or incorrect data in your Catalyst Excel cube, ensuring that unassigned accounts are properly mapped and contribute to accurate financial reporting.
Comments
0 comments
Article is closed for comments.