Skip to main content

Hello,

       Our company are planning to do 2 kinds of business, storage service and distribution.
For storage serivce, the inventory are NOT supposed to post to ledger, it is customer’s inventory. 
For distriution , the inventory will post to ledger and will be counted as COGS when issuing and invoicing.
      So , to serve this need, we are planning to maintain the 2 kinds of business in 2 separated tenants.

     Here comes the quesiton, How can we combine the P&L report and Balance sheet easily,or even automatically?

You cannot access cross-tenant data. Everything is filtered by “CompanyID” behind the scene which represents your “Tenants”.

My pice of advice. Do no do this instead track those inventories that shouldn’t be posted either at zero cost if possible and if not just do not post the documents. If the consolidated report is important, you will be facing unsolvable problems.


To who also interested in this topic,  Acumatica is supporting “Financial consolidation”. Which can solve my need.
 

        You can get the details in help doc, like below:

 


@aaghaei  Thank you for your comment.  Luckily, Acumatica is supporting consolidate 1 tenant’s financial data to another tenant, which can solve my need. You can get more information in help doc.


If the aggregation (although it is called consolidation but it is not) of data at GL balance level serves your purpose and is all you want then go for it. It will do the work.


Thank you for sharing your solution with the community @ray20!


@aaghaei  hello, according to my test, the consolidation process is actually sync the total turnover of each account# in a given period, like below:
 

 


Yes, it is was I said. It aggregates. It doesn’t consolidate. In accounting world there is a huge difference between aggregation and consolidation. Please consult your CFO or Controller.

below is a quick link if spam filter allows to be posted.

https://www.imf.org/external/pubs/ft/fsi/guide/2006/pdf/chp5.pdf

 


Reply