Aggregation of Balances during Multi-location Synchronisation

No Comments

AGGREGATION OF BALANCES DURING MULTI-LOCATION SYNCHRONISATION

DESCRIPTION

Companies having business in different locations may want to consolidate Branch Data with HO Data to find the Turnover/Outcome. To have consolidated data along with Opening Balances, users will synchronise the data from multiple locations (Branches) to Server Company (HO).

Company’s Branches and HO may be dealing in similar Stock/Inventory or different Stocks. If all the Branches and HO are dealing in the same Stock, then there is a possibility, that you can find few/many stock items being available in all Data with stock balances. When the Data with the common stock item(s) are synchronised, instead of displaying the combined opening stock balance for similar stock items, it displays the stock balance available in the last company synchronised.

Example: ABC Company is having branches in – Mumbai, Calcutta and Ahmedabad. It synchronises branches data with its Bangalore HO data. In all the data one stock Item HP –Computer is common and it has opening balance in all the locations: Bangalore -56, Mumbai – 150, Calcutta -70 and Ahmedabad – 30. On synchronisation of Data, instead of displaying the combined balance – 306, it displays 70 as the Opening Balance (Calcutta Branch stock balance, which was synchronised at the end).

The problem of opening balance aggregation in Multi-location Synchronisation also exists for Ledger Balances.

ALTERNATE SOLUTION/WORKAROUND

Export the Masters manually from different locations and Import the masters with Treatment of Entries as Combined Opening Balances at the location where you want to consolidate the Data.

Note: While manual Export and Import of masters ensure that, the option Update/ Modify Opening Balances in Client & Server Rule is set to No at all Locations.

RESOLUTION TIMELINES

Resolution for the above stated problem will be provided in Tally.ERP 9 Series B JAS (July, August, September) Release.

    About us and this blog

    RK Solutions is an authorized solution provider of Tally Solutions Pvt. Ltd. for its various products & services Located at Chennai, India, the company has been providing scalable, reliable, and highly efficient solutions to clientele across the World.

    Request a free quote

    We offer professional SEO services that help websites increase their organic search score drastically in order to compete for the highest rankings even when it comes to highly competitive keywords.

    Subscribe to our newsletter!

    More from our blog

    See all posts
    No Comments