More About Tables | Part I | Procurement Process

Hi All,

Good Day!

This is the first blog (Part I) and I would rather prefer to call it "More About Tables". I am writing this post regarding the procurement process posting tables updates. AX will update different tables throughout the procurement process. As the user proceeds through different Procurement stages, AX will simultaneously update the records in the series of tables based on the task performed like purchase order header created, purchase order lines created, purchase order posted etc.

What are Tables?

Tables are the foundation objects in Microsoft Dynamics AX and store data used by the system. A table is made up of records (or rows) that contain information about a single entry in the table. For example, a specific vendor, customer or product. A record consists of one or more fields (or columns) that contain a discrete piece of data of a specific data type.

Below is the list of tasks which business user will perform throughout the Procurement Process 

Purchase Requisition Header And Lines Created: 

• AX will update the following tables once the purchase requisition header and lines are created

  • • VendPurchOrderJour and VendPurchOrderTrans tables contain Purchase requisition headers and lines.

Purchase Order Header Created:

• Once the purchase order header has been created, it will update the record in the following table
  • • PurchTable contains all purchase order headers (Posted as well as unposted)

Purchase Order Lines Created/Posted:

• PurchLine table contains the details for Purchase order lines (created as well as posted).

Purchase Order Header and Lines Posted:

• Once the purchase order is posted, it will update the following table
  • • PurchParmTable and PurchParmLine 

Purchase Order Receipt List Posted: 

• Once the purchase order receipt list posted, it will update the records in the following tables
  • • • VendReceiptsJour and VendReceiptsTrans tables contain posted receipt header and lines.

Purchase Order Packing Slip(GRN) Posted

• After the Purchase order packing slip(Good Receipt Note - GRN) will be posted, it will update the following tables with headers and line level information
  • • VendPackingSlipJour and VendPackingSlipTrans tables contain posted packingslip headers and lines.

Purchase Order Invoice

• Posted Purchase order vendor invoices will update the following tables

  • • VendInvoiceJour and VendInvoiceTrans tables contain the information of purchase order header and lines with status "Invoiced"

Cheers!

Ali Danish