Hi all,
I want to ask when doing a posting of a Purchase Order, which posted tables are being updated?
Please does both the options ‘Receive’ and ‘Invoice’ affect the same posted tables?
Also, at what point of times do the fields ‘Qty. to Receive’ , ‘Quantity Received’, ‘Qty. to Invoice’, ‘Quantity Invoiced’ get updated on the Purchase Line.
I really need some explicit clarifications.
Did you try by posting and navigating?
Essentially there are posted purchase receipt header and line tables and posted purchase invoice header and line tables.
(Purch. Rcpt. Header, Purch. Rcpt. Line, Purch. Inv. Header and Purch. Inv. Line are the table names).
When you post a purchase receipt, the purchase order (purchase header and purchase line tables) will be updated. So, if you have a purchase order qty of 10 and you post a receipt of 6, at this point you will create a purch. rcpt header and purch. rcpt lines (for 6 units).
The purchase order will be updated to have Quantity = 10, Qty. Received = 6.
Be careful if you look at the form, as there is a setting in the purchase & payables setup, to specify whether the default “qty. to receive” calculation should be blank or the remaining amount.
Until you have a qty. received, you would not be able to enter a “qty to invoice”. But if you want to invoice 5 of the 6 that you have received, the “qty to invoice” can be changed to 5 and you can post the invoice. At this point you would have a quantity = 10, qty received = 6, qty invoiced = 5, qty recvd. not invoiced = 1.
two other final thoughts; it is possible to force receipt of the goods on posting of the invoice (again this is a setup flag), be aware of this, secondly, depending on your reasons for asking, be aware that there are comparible fields for the base qty (i.e. there is field “qty to receive (Base)”. This handles any unit of measure calculations that need to take place).
hope this helps
Receive effects the below tables
Posted Purchase Receipt
Item Ledger Entry
Invoice effects the below tables
Posted Purchase Invoice
G/L Entry
Vendor Ledger Entry
Detailed Vendor Ledg. Entry
Value Entry
Additional - Tax entries if Any.
’Qty. to Receive’
Is updated when you change the value in Quantity field.
When PO is received.
When PO is received + Invoice.
’Quantity Received’
When PO is received.
When PO is received + Invoice.
’Qty. to Invoice’
Is updated when you change the value in Quantity field.
Is updated when you change the value in Quantity field.
When PO is Invoiced.
When PO is received + Invoice.
’Quantity Invoiced’
When PO is Invoiced.
When PO is received + Invoice.
Thanks.