![\"Change\"](\"https:\/\/www.greytrix.com\/blogs\/sageaccpacerp\/wp-content\/uploads\/2013\/08\/1.-Change.png\")
<\/a><\/p>\n1. Change<\/b> \u2013 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.<\/p>\n
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.<\/p>\n
This would help in viewing reports using simple from and to filters to have category wise Trial Balance.<\/p>\n
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.<\/p>\n
Once done, you can create a new account, say 5001 Petty Cash, Store.<\/p>\n
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.<\/p>\n
Also Read:<\/strong>\u00a0Fiscal Set Comparison in Sage 300 ERP 2012<\/a><\/em><\/p>\n 2. Combine <\/b>\u2013 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.<\/p>\n 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.<\/p>\n In above example, Sage 300 combines account 1020 into 1021.<\/p>\n 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.<\/p>\n 3. Copy<\/b> \u2013 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.<\/p>\n Unlike \u2018Change\u2019 and \u2018Combine\u2019, 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.<\/p>\n This option is\u00a0useful\u00a0in 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\u00a0transactions\u00a0from old account to new account and maintain both the accoounts here onwards.<\/p>\n Using above three feature you can easily manage changes that needs to be done at GL account level.<\/p>\n 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:<\/p>\n 4. Change by Example –\u00a0<\/b>You can access this field in Edit option of\u00a0 \u2018Account Code Change\u2019. 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\u00a0referring\u00a0this account.<\/p>\n For Example:<\/b> 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\u00a0structure\u00a0for 1 such account using \u2018Change\u2019 option from above and then use the \u2018Change by Example\u2019 option to change the rest of series.<\/p>\n Once confirmed you can click on Post to make the changes in GL chart of accounts.<\/p>\n 5. Import Accounts File –\u00a0<\/b>This option enables user to Change, Copy or Combine multiple accounts at a single go by importing them using an excel or csv file.<\/p>\n This option is very\u00a0convenient\u00a0in 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.<\/p>\n Format of file should be \u2018Microsoft Excel 97-2003 Worksheet (.xls)\u2019 with same columns as mentioned in below excel sheet.<\/p>\n Here, in column C of \u2018Action type\u2019, can have any of the following values as per your requirement:<\/p>\n 0 for \u2018Change\u2019<\/em> After selecting of the file and clicking on Import will list all accounts to be changed in screen of \u2018Account Code Change\u2019.Then, you can post all accounts to get their code changed in GL Chart of account.<\/p>\n Note<\/b>: Before doing any change in Account code, make sure all Sage 300 users are logged off and take back up of database.<\/em><\/p>\n This would help Users in changing account codes with ease and will reduce manual work.<\/p>\n About Us<\/strong><\/span> Greytrix<\/a>\u00a0offers unique GUMU™ integrated solutions of\u00a0Sage 300 with Sage CRM,<\/a>\u00a0Salesforce.com\u00a0<\/a>and\u00a0Magento eCommerce<\/a>\u00a0along with Sage 300 Migration from\u00a0Sage 50 US, Sage 50 CA, Sage PRO, QuickBooks, Sage Business Vision and Sage Business Works<\/a>. We also offer best-in-class\u00a0Sage 300 customization and development services<\/a>\u00a0and integration service for applications such as\u00a0POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage 300 ERP<\/a>\u00a0and 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 \u00a0to 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\u00a0GreyMatrix<\/a>,\u00a0Document Attachment<\/a>,\u00a0Document Numbering<\/a>,\u00a0Auto-Bank Reconciliation<\/a>,\u00a0Purchase Approval System<\/a>,\u00a0Three way PO matching<\/a>,\u00a0Bill of Lading<\/a>\u00a0and\u00a0VAT for Middle East<\/a>.<\/p>\n For more details on Sage 300 and 300c Services, please contact us at\u00a0accpac@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n
\n 1 for \u2018Combine\u2019<\/em>
\n 2 for \u2018Copy\u2019<\/em><\/p>\n
\nGreytrix<\/a>\u00a0a 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.<\/p>\n