Question

Consolidation int the same tenant - 2 Ledgers in one within the same tenant

C
Rank

Hello !

My client use two differents ledgers.

The first one is for accounting and official purpose.

The second one is for estimation and subledgers corrections.  It doesn’t need to be published fot accounting autorities. 

 

I need to consolidate both into a third that would give the real position of the subaccount.

(Users would like to keep using the standard screens like GL401000 & GL404000 wich very convenient).

At first, I thought use consolidation feature but is there any possibilies to make it work within only only one tenant ? 

 

Thank for your help. 

Cécile

3 replies

Laura02
Rank
Badge +18

Hello,

To report ledgers summed together, try using ARM Financial Reports to create Balance Sheet, Income Statement/Profit & Loss, and/or Trial Balance style reports.

Financial Reports may have different ledgers in each column, with a Total column so you can see Accounting entries plus Estimations/Corrections = Real Position.

 

Your second and third columns will represent the Accounting and Estimation Ledgers. The last column will calculate the Total.

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~
C
Rank

Thanks @Laura02  for replying

 

I hipped avoiding to create special ARM and keep users in standards screen such as balance.

 

Laura02
Rank
Badge +18

Hi,

I feel certain none of the standard screens combines figures from two Ledgers.

Velix o is likely another good option (Excel) - though not a free option.

Laura

Laura ~ Klear Systems, Inc. Irvine, CA. ~ AUG Forums Episode130 ~

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved