Sage 300 ERP – Tips, Tricks and Components
Greytrix is one of the oldest Sage Development Partner of two decades and Reseller of Sage 300 ERP (formerly known as Sage Accpac ERP) and has been awarded "Sage Partner of the Year" multiple times for rendering quality services for Sage product lines both as developers and resellers. Greytrix has accumulated hundreds of man years of experience in Sage 300 ERP. In these blogs, Greytrix will endeavour to share its knowledge with regards to implementation, training, customisation, components, current technology trends and help users to understand in depth techno – functional aspects of Sage 300 ERP! Contact our team at accpac@greytrix.com
Follow us on LinkedIn Follow us on Twitter Follow us on Facebook Follow us on YouTube
Skip to content
  • Home

GL Account Code Change in Sage 300 ERP

By Greytrix | August 2, 2013
0 Comment

Many-a-times it happens that there is requirement to change Name/Description of a General Ledger Account. Say for an instance, there is an account named ‘Motor Car Expenses’ where you debit all your Vehicle expenses till now. However, to keep a better track of Vehicle wise expenses you require accounts to be separate, hence you may rename  first account from ‘Motor Car Expenses’ to ‘Motor Car Expenses – ‘Car Number1’ ’ and open a new account for another vehicle say ‘Motor Car Expenses – ‘Car Number2’ ’.

However, if you wish to change account number instead of account description, then it has to be handled through a separate utility called “GL Account Code Change in Sage 300 ERP”.

This utility comes with 3 options to cater 3 separate functional requirements. Let’s go through each one of them in detail:

Change

1. Change – In this option, you can change Account number of an account to a new number. For example: consider a case, where we have a GL account as 1000 Petty Cash for our factory and store location.

Say, now we want to split this location into 2 separate locations and hence require maintaining 2 separate accounts instead of 1. Also, we require all similar type of accounts in Sage to be in sequence i.e. all assets and liabilities should be in sequence.

This would help in viewing reports using simple from and to filters to have category wise Trial Balance.

Now, in order to do so, we have to change account number and description of the above said account to, say 5000 Petty Cash, Factory. Then, To Process this in Sage 300 GL Account Code Change, one has to mention the source account and the destination account.

Once done, you can create a new account, say 5001 Petty Cash, Store.

There is also an option to change the attributes of account, like the Structure Code. If structure code is to be changed then decide on new Structure Code by clicking on the List Button beside the Structure Code field. Then enter new Account Code and change Description as required.

Also Read: Fiscal Set Comparison in Sage 300 ERP 2012

2. Combine – This option allows us to combine one account and all its relevant details into the second account. In this case, initial account will get combined in second account and will get disappeared from chart of accounts list.

Say for example, we have merged 2 of our bank accounts into 1 account in system or accounts were a duplicate of each other and hence need to be merged. In this case, we can use combine feature.

Combine

In above example, Sage 300 combines account 1020 into 1021.

After this process all the transactions present in account 1020 will get combined in account 1021 and then the account 1020 will not be visible in Chart of accounts list.

3. Copy – This feature is used to copy the contents of one account to the newly created account. In the below screen as specified 1020 is the account whose details has to be copied in the new account 1030.

Copy

Unlike ‘Change’ and ‘Combine’, this old account code will also be visible in GL Chart of Accounts after changing its account code but transaction that would be done in future will show its effect in new account only i.e. old account will record transactions till date you have copied it to the new one.

This option is useful in case, where you earlier had 2 entities but had maintained only 1 account for one of them and had maintained the other account out of your books. Since, entries in both accounts were supposed to be same you can copy transactions from old account to new account and maintain both the accoounts here onwards.

Using above three feature you can easily manage changes that needs to be done at GL account level.

Above all applies to changes in only 1 account code at a time, but if you want to change account code for multiple accounts then it would be a better practice to use anyone of the following two options:

4. Change by Example – You can access this field in Edit option of  ‘Account Code Change’. This is useful in case when you have made the change to 1 account manually and require system to do the same to a list of accounts referring this account.

For Example: We have created accounts with code starting with 4010-100 which fall under Profit and Loss. Now, we have restructured our Chart of Accounts and hence need all P&L accounts to be in Series starting with 9010, here we can change the structure for 1 such account using ‘Change’ option from above and then use the ‘Change by Example’ option to change the rest of series.

Change by Example

Once confirmed you can click on Post to make the changes in GL chart of accounts.

5. Import Accounts File – This option enables user to Change, Copy or Combine multiple accounts at a single go by importing them using an excel or csv file.

This option is very convenient in case there are more than few accounts to be changed at 1 go. The simple way is to create a list of all such accounts in a spreadsheet or csv format and then import this into system to complete the procedure.

Account Code Change Import

Format of file should be ‘Microsoft Excel 97-2003 Worksheet (.xls)’ with same columns as mentioned in below excel sheet.

Excel

Here, in column C of ‘Action type’, can have any of the following values as per your requirement:

0 for ‘Change’
1 for ‘Combine’
2 for ‘Copy’

After selecting of the file and clicking on Import will list all accounts to be changed in screen of ‘Account Code Change’.Then, you can post all accounts to get their code changed in GL Chart of account.

Note: Before doing any change in Account code, make sure all Sage 300 users are logged off and take back up of database.

This would help Users in changing account codes with ease and will reduce manual work.

About Us
Greytrix a globally recognized Premier Sage Gold Development Partner is a one stop solution provider for Sage ERP and Sage CRM needs. Being recognized and rewarded for multi-man years of experience, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation expertise.

Greytrix offers unique GUMU™ integrated solutions of Sage 300 with Sage CRM, Salesforce.com and Magento eCommerce along with Sage 300 Migration from Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works. We also offer best-in-class Sage 300 customization and development services and integration service for applications such as POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP and in Sage 300c development services we offer services such as upgrades of older codes and screens to new web screens, newer integrations using sdata and web services  to Sage business partners, end users and Sage PSG worldwide. Greytrix offers over 20+ Sage 300 productivity enhancing utilities that we can help you with such as GreyMatrix, Document Attachment, Document Numbering, Auto-Bank Reconciliation, Purchase Approval System, Three way PO matching, Bill of Lading and VAT for Middle East.

For more details on Sage 300 and 300c Services, please contact us at accpac@greytrix.com. We will be glad to assist you.

Related Posts

  • Migrate Salesperson Code from Sage 100 ERP to Sage 300 ERP
  • Change Print Destination in Sage 300 ERP
  • GL Account History Inquiry in Sage 300 ERP
Category: Sage 300 Tags: Account Code Change, Account number, GL Chart of Accounts, Sage 300 ERP, Sagge Accpac ERP
Post navigation
← User Role and Security Application in Sage 300 ERP Order Process for Manufacturing Company in Sage 300 ERP →

GUMU™- Hero System Integrator

https://www.youtube.com/watch?v=sROA766iq9A

Greytrix Websites and Blogs

  • Greytrix
  • Greytrix Africa
  • Greytrix Australia
  • Sage X3 – Tips, Tricks and Components
  • Sage 100 & 500 ERP Tips and Tricks
  • Sage CRM – Tips, Tricks and Components
  • Salesforce.com Tips and Tricks by Greytrix
  • Sage Intacct– Tips, Tricks and Components
sage crm and sage 300 integration

Categories

  • Sage 300
    • ACCPAC SDK
  • Sage 300 People
  • Sage 50 US
  • Sage Business Cloud
  • TDS
  • Uncategorized

Recent Posts

  • WCT Process
  • IC Stock Statement Report in Sage 300c
  • Third Party Integration on Order Entry in Sage 300C
  • Compile error: User defined type not defined
  • Document attachment for sage 300 Advanced & Standard edition released

Archives

Awards

Greytrix Top ISV Partner
Greytrix Revenue Growth Enterprise Business
Greytrix Africa Highest Revenue
Greytrix Prtner of the Year
Greytrix Partner Award
Copyright 2022
Sage 300 ERP – Tips, Tricks and Components
Iconic One Theme | Powered by Wordpress