Change/Move GL Account for Existing Entries
Is there a way to change/move GL-related data from one account code to another?
For example... We have been entering utilities payments all under one GL COA. We may want to split this account into sub-accounts so we can better track costs.
7660-Utilities
Becomes:
7660-Utilities
- 7661-Natural Gas
- 7662-Internet
- 7663-Electric
- 7664-Etc.
So... Is there a way to do this now or do we need a new utility script? If we need a new "Z_" utility script I am willing to take a crack at it...
FYI I have done this manually via DB export, modify, import and then running the Z_RePostGLFromPeriod.php script. However, the context was simply moving data from account 2400 to account 6500, which was not too much of a stretch.
https://www.linkedin.com/in/eclipsepaulbecker
|