Update Account segment to capital letter

(1) Share

Report

Posted on by JR-09071457-0

Hello I am trying to see if there is a way to update the second segment to have capital "CC" instead of lower case "cc". The reason I am asking for the update is due to how we push information for budget to great plains. We would need to have a note that we have an exception when we do our yearly budget for that segment and we would rather see if GP would allow us to update. We currently use an excel add on with eone solution to open accounts and I have attempted to reupload with the capital letter but great plains does not see the difference. I also tried mass update with no luck. any help would be appreciated.

I have the same question (0)

All responses (3)

Answers (1)

Sort by

André Arnaud de Cal... 304,837 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved the question to the Dynamics GP forum.

Was this reply helpful? Yes No
Suggested answer

Jothi Krishnan N 1,897 on at

Like (0)

Report
Copy link

Link copied!

Did you try Account Modifier in PSTL tool. try it in test company first.

Was this reply helpful? Yes No
Verified answer

BJ-09051414-0 397 on at

Like (0)

Report
Copy link

Link copied!
Hello,

To change this, you will need to use the Account Modifier/combiner to change the numbering on an account from lower case to capital letters.

You can either do this for one account, a range of accounts, or using an import file.

For one account you can test the steps below. This is suggested to be done in test and have a valid backup before doing it in live.

Open PSTL - Professional Server Tools.

This is a free module if you do not have it installed.

In PSTL, mark the Account Modifier/Combiner and click next.

In the window, select by = Account.

Account Number = the current account that you want to change.

You will need to use the lookup because you cannot enter lowercase values in the account field.

Convert to Account Number = What you want the account to be.

Click Convert.

Click continue on the pop up.

Click continue on the next pop up telling you post all Intercompany transactions that use this account after verifying if any need to be posted.

Click Continue.

Review the report for changes.

Verify the end results.

Please note. if you have third party tables that have ACTINDX in their tables, this will not work as the PSTL tools will not work with third party tables.

I hope this helps!

Thank you!

Brandon

Microsoft Dynamics 365 Implementation & Support | Cloud ERP Consultant (enavate.com)

Was this reply helpful? Yes No