Monday, 30 July 2007

Post Receive and Invoice in Purchase Order

To Post Receive and Invoice:
  1. At the Purchase Order, click Posting --> Post (F11)
  2. Select Receive and Invoice
  3. Click on the OK button. That's it.The posting will begin and a series of tables will be updated as follows:
Note: I have highlighted the table name in red for easier identification.

INSERT a new record into Purch. Rcpt Header.
INSERT records into Posted Document Dimension table for the Purch. Rcpt. Header inserted. One record is inserted for each dimension selected in the PO.
DELETE AddressID records that are associated with the Purch. Rcpt. Header record.

INSERT a new record into Purch. Inv. Header.
INSERT records into Posted Document Dimension table for the Puch. Inv. Header inserted. One record is inserted for each dimension selected in the PO.
DELETE AddressID records that are associated with the Purch. Inv. Header record.

INSERT new records into Ledger Entry Dimension table for records to be inserted into Value Entry table. One record is inserted for each dimension selected in the PO.
INSERT new record into Value Entry table.
* 2 associated value entries will be created for each item ledger entry if you post receipt and invoice seperately - 1 for receipt and another one for invoice. The 2 lines will have different document no.

* The receipt line will have value in the Item Ledger Entry Quantity field while the invoice line will have value in the Invoiced Quantity field.

* If you post receive and invoice at the same time, the 2 lines will be combined into 1 line with both the Item Ledger Entry Quantity and Invoiced Quantity fields populated with data.

* The value entries will link to the item ledger entry by using the Entry No. field in the value entry table.

* The Average Cost (LCY) field in the Item card is calculated from these value entries.

INSERT new record into Item Register table.

INSERT new records into Ledger Entry Dimension table for an Item Ledger Entry record.
INSERT new record into Item Ledger Entry table.
* 1 record will be created for each receipt posted.

INSERT a new record into Item Application Entry table.

INSERT new records into Ledger Entry Dimension table for a Value Entry record
INSERT a new record into Value Entry table.

INSERT a new record into Purch. Rcpt. Line table.
INSERT new records into Posted Document Dimension table for a Purch. Rcpt. Line record.

INSERT a new record into Purch. Inv. Line table.
INSERT new records into Posted Document Dimension table for a Purch. Inv. Line record.

INSERT a new record into VAT Entry table.

INSERT a new record into G/L Entry table for a Purchase Account (Debit).
INSERT new records into Ledger Entry Dimension table for the G/L Entry record inserted. One record is inserted for each dimension selected in the PO.

INSERT a new record into G/L Entry table for VAT Account (Debit).
INSERT new records into Ledger Entry Dimension table for the G/L Entry record inserted. One record is inserted for each dimension selected in the PO.

INSERT a new record into G/L Register table.

INSERT a new record into Vendor Ledger Entry table.
INSERT new records into Ledger Entry Dimension table for the Vendor Ledger Entry record inserted. One record is inserted for each dimension selected in the PO.
* Vendor Invoice No. field in Purchase Order will be populated to the External Document No. field in Vendor Ledger Entry table.

* Invoice Amount will be populated to Original Amount, Amount and Remaining Amount. Whenever payment to the vendor is posted and applied, the Remaining Amount will be reduced with the amount posted. When the invoice is fully paid and applied, the Remaining Amount will become 0.

INSERT a new record into Detailed Vendor Ledg. Entry table.

INSERT a new record into G/L Entry table for Account Payable (Credit Vendor Account).
INSERT new records into Ledger Entry Dimension table for the G/L Entry record inserted. One record is inserted for each dimension selected in the PO.

DELETE records in Document Dimension table that are associated with the Purchase Header record.

DELETE records in Document Dimension table that are associated with the Purchase Line record.

DELETE Purchase Header record.

DELETE Purchase Line record.

* Please note that once you have completely received and invoiced a purchase order in Navision, the purchase order will be converted to posted invoice. Therefore, the purchase order will be deleted from Navision while a new posted invoice will be created. You can access the posted invoice from the Purchase menu under History --> Posted Invoices.

* Posted Invoices are not editable. You can view and print the document but cannot modify it.

DELETE Item Charge Assignment (Purch) records that are associated with the Purchase Header record.

DELETE Purchase Comment Line records that are associated with the Purchase Header record.

DELETE Warehouse Request records that are associated with the Purchase Line record.

DELETE AddressID records that are associated with the Purchase Header record.

INSERT a new record into Item Analysis View Entry table.

1 comment:

purchase order form said...

How Great site. It s very perfect I already tried to use that. But let me forward this to my friends.