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.

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

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  hello, according to my test, the consolidation process is actually sync the total turnover of each account# in a given period, 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!