Does anyone on the forum have an example of a Goods Received Not Invoiced Report. I'm unsure as what tables will hold the data I need, such as the User ID of the person who posted the receipt?, the line amount in the Vendor currency, and also in local currency.I can get most of the data I need from the Purchase Line table but I'm a bit stumpted on other data.
Any help appreciated.
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment The purchase receipt line table has a field of "Qty. Rcd. Not Invoiced". That will give you the rows. You can get the user id from the purchase receipt header table and also use the order no. to get back to the original PO and purchase line data.
-
Jet Reports Historic Posts Hi,
If you are talking about MS Dynamics NAV system, then the tables for Good Received and Posted Purchase Invoice are completely separated.
Go ahead and look for these tables for Good Received info:
Header: Purch. Rcpt. Header, table no: 120
you'll get the User ID of the person who posted the receipt in this table. You'll also get info regarding your PO no. your vendor name, …
Line: Purch. Rcpt. Line, table no: 121
you'll get info about your received items, the quantity, order date,… here
For info regarding Posted Purchase Invoice, look for these tables:
Header: Purch. Inv. Header, table no: 122
you'll get the User ID of the person who posted the INVOICE here, as well as info regarding PO No., Posting date, vendor name, …
Line: Purch. Inv. Line, table no: 123
Here, you'll also got info regarding your INVOICED items, meaning: your items, quantity, line amount, gst,… that already being INVOICED by your vendor.
================================================================================================
In essence, if you just want to get info regarding what & when your items are being received, go and look in table 120 & 121.
if you want info regarding Items that are already received but not yet invoiced, then you need to compare data from table 120 & 121 with data from table 122 & 123.
Look for items that are in table 121 (Purch. Rcpt. Line) but not in table 123 (Purch. Inv. Line)
Does it help?
Andy
Please sign in to leave a comment.