Issue / Summary

Financials > Reporting > Financial Data Extraction > Inquiry (GESTXW) 

Explanations of the extraction result.

Resolution

Before obtaining the financial data extraction you need to put the right formulas in FDE parameterization: Parameters > Financials > Accounting forms > Financial Data Extraction

Example:

• Companies: 911

• Total credit of account with root 4 = 702,5

• Credit balance 602.5

• Debit balance 1052.5

• Total debit of account with root 4 = 1152,5

• The account balances:

Account / Description / Ledger debit period balance / Ledger credit period balance / Ledger period debit / Ledger period credit.

401000 / Supplier /         / 475 / 100 / 575.

411000 / Customer / 977,50 /          / 977,50 /        .

445660 / Deductible VAT / 75 /            / 75 /           .

445710 / Collected VAT /           / 127,50 /         / 127,50.

To get the results: Financials > Inquiries > Account Balances.

Formulas / Result / Explanations.

4 / 450 / Total debit - Total credit = 1052,5 - 602,5 = 450, Formula “4” means that X3 will calculate the balance of all the account with root ”4”

C4/ -603 / 475 + 127,50 = 603, With this formula, X3 will extract just accounts with root “4” with a credit balance.

D4 / 1053 / 977,50 + 75 = 1053, With this formula, X3 will extract just accounts with root “4” with a debit balance.

MC4 / -703 / 575 + 127,5 = 703, With this formula X3 will extract the amount of every account with root “4” with a credit balance

MD4 / 1153 / 100 + 977,50 + 75 = 1153, With this formula X3 will extract the amount of every account with root “4” with a debit balance

41..44 / 925 / (977,5+75) - 127,5 = 925, This formula means that X3 will extract all the account with root “41” to “44” include

4(1) / -528 / 75 – 475 - 127,5 = -528, This formula means that X3 will extract all the account with root “4” excluding all the root “41” in our example the account 411000 is exclude

411 445 / 925 / (977,5+75) - 127,5 = 925, This formula means that X3 will extract all the account with root “411”  AND “445”

I(C1) / 978 / With this formula X3 will do an individual path in the collective account C1 (Customer). For the supplier the collective account is F1 ==> I(F1)=-475

H(C1) / 978 / With this formula X3 will do an individual path in the collective account C1 (Customer) BUT with no details of the accounts.