Total Pageviews

Saturday, December 8, 2012

DAX – Journal posting used following tables


In DAX journal posting used following tables, ledgerJournallTable is a main table to store header information about the journal and the ledgerJournalTrans table to store line information.

After posting of journal the information is entered in the following tables.

-          If the Vendor account is used in the ledger account field then the information will be stored in vendTrans also.

-          If the Customer account is used in the ledger account field then the information will be stored in custTrans also.

-          If the bank account is used in the ledger account field then the information will be stored in bankAccountTrans also.

-          If the tax information exists on the line, it is stored in taxtrans table.

-          If there is a localization license for countries like  India, UK then the tax related information will also store in taxTrans_In, taxTrans_UK  tables

2 comments:

  1. There are more for sure. Another key table for journal posting.

    When invoicing and posting journal, custTranOpen table is major one together with custTrans table, and when settled, custSettle would be balance back so that AX can know which transaction is closed when money gets paid.

    And for min.Charge as shipping charge, there is also other table.

    ReplyDelete