Wednesday, 16 May 2007

Create Purchase Order

Have you ever wondered what will happen to Navision database when we create a PO. The following steps explains what will happens to the database when we create and post a PO.

In the Purchase Order window, Press F3 and then hit the Enter button to create a new Purchase Order. The following fields are updated when the record is created

  • Document Type
  • No.
  • Ship-to Name
  • Ship-to Address
  • Ship-to City
  • Order Date
  • Posting Date
  • Posting Description
  • Applies-to Doc. Type
  • Ship-to PostCode
  • Bal. Account Type
  • Document Date
  • No. Series
  • Posting No. Series
  • Receiving No. Series
  • Status
  • Invoice Discount Calculation
  • Doc. No. Occurence

Enter 10000 in the Vendor No. field. This will caused Table 38 - Purchase Header and Table 357 - Dimension to be updated.

Table 38 - Purchase Header

  • Buy-from Vendor No.
  • Pay-to Vendor No.
  • Pay-to Name
  • Pay-to Address
  • Pay-to City
  • Pay-to Contact
  • Payment Terms Code
  • Due Date
  • Pmt. Discount Date
  • Shipment Method Code
  • Vendor Posting Group
  • Invoice Disc. Code
  • Language Code
  • Purchaser Code
  • SST Registration No.
  • Gen. Bus. Posting Group
  • SST Country Code
  • Buy-from Vendor Name
  • Buy-from Address
  • Buy-from City
  • Buy-from Contact
  • Pay-to Post Code
  • Pay-to Country Code
  • Buy-from Post Code
  • Buy-from Country Code
  • SST Bus. Posting Group
  • Buy-from Contact No.
  • Pay-to Contact No.
  • Responsibility Center

Table 38 - Purchase Header

  • Table ID
  • Document type
  • Document No.
  • Line No.
  • Dimension Code
  • Dimension Value Code

When we post the Purchase Order as Receive, 16 tables will be updated. Tables updated when we post PO are:
  1. Table 309: No. Series Line
  2. Table 38: Purchase Header
  3. Table 39: Purchase Line
  4. Table 6224: SynchMgt. Message Queue
  5. Table 120: Purch. Rcpt. Header
  6. Table 359: Posted Document Dimension
  7. Table 28003: Address ID
  8. Table355: Ledger Entry Dimension
  9. Table 32: Item Ledger Entry
  10. Table 46: Item Register
  11. Table 339: Item Application Entry
  12. Table 5802: Value Entry
  13. Table 27: Item
  14. Table 121: Purch. Rcpt. Line
  15. Table 7152: ItemAnalysis View
  16. Table 7154: Item Analysis View Entry

No comments: