- Microsoft Dynamics GP 2013 Cookbook
- Ian Grieve Mark Polino
- 547字
- 2021-08-20 16:54:17
Gaining visibility by using horizontal scroll arrows
A consequence of company growth is that not only does the chart of accounts grow larger and less intuitive, but also the actual lengths of account numbers tend to grow longer as well. Companies want to be able to report by account, department, location, and so on, which results in a proliferation of segments added to the main account number and can create very long accounts. Dynamics GP can accommodate an account number as long as 66 characters. The longest I've seen used in practice was of 27 characters and even that was unwieldy. Most users only need a portion of that length for their day-to-day work.
This presents a problem because very long account numbers won't fit into the account number field on most screens. For this recipe, we'll look at how Dynamics GP provides a solution to this in the User Preferences area.
How to do it...
Here we'll see how to increase the visibility of long account numbers.
- In the navigation pane on the left, select Home.
- Click on User Preferences on the shortcut bar.
- Check the box for Horizontal Scroll Arrows.
This turns on the functionality that allows users to scroll horizontally within the Account field, allowing them to see the full account number.
How it works...
Once horizontal scroll arrows are activated, small arrows appear at the left and right side of the Account field, letting users scroll right and left to see the full account number.
There's more...
Horizontal scroll arrows are implemented on a per user basis, meaning each user has to turn this on individually. Administrators can make this active for all users with a SQL script.
Additionally, for companies using alphanumeric characters in their chart of accounts, wide letters such as M or W are often difficult to see. There is also an option to increase the visible width of a particular segment.
Activating horizontal scroll arrows for all users
Horizontal scroll arrows are activated by the user. However, an administrator can turn this feature on for all users in all companies by running the following SQL script against the Dynamics database:
Update SY01400 Set HSCRLARW=1
Widening segments for better visibility
When companies use alphanumeric characters in their chart of accounts, wide letters, such as M or W, are often cut off. Horizontal scroll arrows don't help because the problem is that the segment field is too narrow, not the entire account field. To resolve this problem, Dynamics GP provides an option to widen the segment fields as well.
In the navigation pane, click on Administration and select Account Format. For each segment that needs to be wider, select the Display Width column and change it from Standard to Expansion 1, Expansion 2, or Expansion 3 to widen the field; Expansion 3 represents the widest option.
Companies using only numbers in their chart of accounts won't need to widen the segment field, but firms that include letters as part of their charts will need to increase the width. The following is a list of the expansion options and the letters they are designed to accommodate:
- Expansion 1: A, B, E, K, P, S, V, X, Y
- Expansion 2: C, D, G, H, M, N, O, Q, R, U
- Expansion 3: W
- GitLab Cookbook
- 編程的修煉
- SQL學習指南（第3版）
- Java加密與解密的藝術（第2版）
- 數據結構（Java語言描述）
- 匯編語言程序設計（第2版）
- MATLAB應用與實驗教程
- Python貝葉斯分析（第2版）
- 名師講壇：Spring實戰開發（Redis+SpringDataJPA+SpringMVC+SpringSecurity）
- 零基礎學單片機C語言程序設計
- Learning Three.js：The JavaScript 3D Library for WebGL
- PHP 7+MySQL 8動態網站開發從入門到精通（視頻教學版）
- Getting Started with LLVM Core Libraries
- Visualforce Developer’s guide
- IBM Cognos TM1 Developer's Certification guide