MYOB EXO: Update GL Codes on historical data

Highlighted
Contributing User suretek
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

MYOB EXO: Update GL Codes on historical data

We have inherited a messed up GL and we are trying to clean it up ourselves as much as possible. 

 

We have gone through and created new GL sub-groups for SALES, COS and PURCH as required and re-mapped them to all our stock items (using QITs). This is now displaying stock items grouped correctly in GL reports for new orders, however not for historical orders that has already been batched. Is there any way to update the historical order data so that all stock items have the correct GL groups & sub-groups we desire? 

Ideally we want to be able to provide reports to owners & managers as per the GL groups & sub-groups we have configured. 

Any guidance highly appreciated. Thanks! 

8 REPLIES 8
MYOB Staff Post CarlBrooks
234 Posts
MYOB Staff Post
Australia
MYOB Staff Post

234Posts

66Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

@suretek 

 

If I understand you correctly you have remapped your inventory items to different Sales and COS GL Codes? If that is correct then of course these would be used in new transactions but historical transactions will remain with the old codes.

 

The primary reason is the design of the database, the GL Account number is the primary key and used in each of the transactions. 

Contributing User suretek
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

Yes that is exactly what is happening. But my question is, is there any way to remap / update the historical records to correct GL codes? 

 

 

MYOB Staff Post CarlBrooks
234 Posts
MYOB Staff Post
Australia
MYOB Staff Post

234Posts

66Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

@suretek 

 

Unfortunately not, the previous transactional data cannot be pointed to the new GL codes through the user interface.

 

Carl 

Contributing User suretek
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

But can it be changed directly on the SQL database? 

Contributing User suretek
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

@CarlBrooks So the question remains, can this be updated??  Can it be changed directly on the SQL database or via a script?? 

MYOB Staff Post CarlBrooks
234 Posts
MYOB Staff Post
Australia
MYOB Staff Post

234Posts

66Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

@suretek I would not recommend this as an option to be considered as the risk of corrupting your whole database is not worth it.

Valued Partner Steve_Marriott
193 Posts
Valued Partner
Australia
Valued Partner

193Posts

48Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

Hi @suretek (and @CarlBrooks )

 

Just to backup what Carl is saying, if you change the GL Codes on the old journals using an SQL script you will make the database useless. Nothing will balance, you will not be able to run historical period reports, nothing will balance anymore. When a posting is done in Exo, it performs many tasks, updating Balances that are held by Account being 1 of them.

 

Unfortunately you will need to go to your Exo Support partner to ask if they have a tool that will do what you want as it will invalidate the status of the database and you will not be able to get further support ongoing.

 

Regards

 

Steve

 

Steve Marriott
Very Impressive Software
steve@veryimpressive.co.nz
Contributing User suretek
10 Posts
Contributing User
Contributing User

10Posts

0Kudos

0Solutions

Re: MYOB EXO: Update GL Codes on historical data

But if the GL references on stock items on past data is incorrect then our database is already messed up. 

 

We currently cant look at historical GL transaction reports to compare as they are inaccurate. 

 

 

Didn't find your answer here?
Try using advanced search to find a post more easily Advanced Search
or
Get the conversation started and make a new post Start a Post