Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Not applicable

Does all accounting software provide same data format on Balace Sheet Table ?

‌Hi All

i am aware of for sales order table in any accounting software it is base on same format , mean sales amount is log by date . So in compute the sales by month table , dimension using month and expression = sum(sales).

i Notice that when get data from GL Table , to compute sales from GL table also similar approach .

When come to Balance sheet analysis using GL table , I do notice in order to compute the Account receivable or current asset like stock , it base on accounting period one opening balance and accounting period 2 closing balance to compute the open balance for period 3.

WWhich is a lot of different from sales order table.

now my question is , does all accounting software also create the raw data table using the same format ?

HOpe those expert have deal with GL table before share with me your insight pls .

PAul