Understanding the Accounts Receivable / Accounts Payable modules

The , Account Receivable (AR) and Accounts Payable (AP) modules in AX are very similar to one another. On one hand, you have customers and sales orders and on the other hand, you have vendors and purchase orders. The examples in this chapter are only from the AR module, but switching the example to AP should not be a problem for you at this point.

As you will see from the entity schema in the next section, the similarities between the tables on the different sides are taken to a common level using a table map in the in Application Object Tree (AOT). This enables you, as a developer, to write one class that can easily handle both AR and AP at the same time, as you can reference the table map instead of having two classes—one class to reference the AP tables and another class to reference the AR tables.

Entity schema – base data and orders

The entity schema shows how the base data in the AR and AP modules relate to one another. It also shows that the fields that are common in the AR and AP modules are put into maps to enable one piece of code to refer to the map and have it work for both the AR and the AP modules.

Entity schema – base data and orders

Again, this schema is very simplified as there are many more fields and other entities that also relate to the tables in the schema.

The following table gives a brief description of each of the tables shown in the preceding entity schema:

Table name

Description

CustGroup

This table contains a list of groups into which customers can be added. All customers must specify a CustGroup value with which they are associated. The group contains information such as default payment terms and settlement periods, and it is also used for reporting.

VendGroup

This table contains definitions of vendor groups.

CustTable

This table contains the list of customers for AR and customer relationship management.

VendTable

This table contains vendors for AP.

SalesTable

This table contains all sales order headers regardless of whether they have been posted or not.

PurchTable

This table contains all purchase order headers regardless of whether they have been posted or not.

SalesLine

This table contains all sales order lines regardless of whether they have been posted or not.

PurchLine

This table contains all purchase order lines regardless of whether they have been posted or not.

Entity schema – transactions

The transactions entity schema shows how the customer and vendor transactions link to settlement tables and the ledger transactions, and how all of these tables relate to the ledger dimensions. The following shows a transaction entity schema:

Entity schema – transactions

The following table gives a brief description of each of the tables shown in the preceding transactions entity schema:

Table name

Description

CustTrans

This table contains posted transaction information for the customer.

VendTrans

This table contains posted transaction information for the vendor.

CustSettlement

This table contains information relating to the settlement or reverse settlement of two transactions. They are used to link a transaction with the transaction it was settled against.

VendSettlement

This table contains information relating to the settlement or reverse settlement of two transactions. They are used to link a transaction with the transaction it was settled against.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.216.34.146