Microsoft Dynamics GP: Missing Item Receipt Transaction
Hi, I have received in a PO with multiple lines but on the first line, even though it has been invoiced, it does not show up in the item enquiry windows. I have run checklinks & there were no errors. When I go in the POP item enquiry screen, Qty Ordered = 23, Qty Shipped = 23 & Qty Invoiced = 23, yet nothing appears in the item enquiry window. Any suggestions? Thanks, Calvin
All Replies
Calvin,
What is the type of the item? Only Sales Inventory items will track quantities. If it is Sales Inventory, next thing to verify is that you are tracking history for this item by clicking on the Options button from the Item Maintenance window. By default, when you create a new item none of the Maintain History options are selected.
-Victoria
http://victoriayudin.com/- Hi Victoria,
Thanks for your reply.
This item is a Sales Inventory item which also has all the options ticked for keeping history. I'm just a bit stumped as to where it has disappeared to.
Cheers,
Calvin - Another possibility, non-inventory items. If an item is entered on a PO and it does not exist in inventory, it is marked as a non-invnetory item. Even if the item is added to the inventory later, the PO line is still marked as non-inventory and the receipt of a non-inventory marked line will not update quantities.
You could have entered the item on the PO before putting the item in inventory, or
You could have mistyped the part number slightly.....
There is a chunk file called AddItem that can be dropped in the GP folder that will change the operation of the PO line entry window. It will warn you everytime you enter a non-inventory item on the PO. You might want to get that.
Richard L. Whaley
Consultant, Author
www.AccoladePublications.com - Richard is Correct which looks to be a real possibility. You can install Add Item functionality which will serve your purpose in future.
You can download the Additem Functionality by going to the following download link
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?WTNTZSMNWUKNTMMYKKQRRUZVRPSSXNSNWPYKNNOPMYTXPSMVPWVTNLWVQRMXVVPMOLSLOXYKXUKSMRZTXYRZROMPZTTXNXTW
Janakiram M.P. MCP-GP Almoayyed Computers Bahrain - Hi Victoria,
Yes I have & still the same thing.
Cheers,
Calvin As Richard suggests, did you take a look at the original PO to see if this was an inventory item at the time of the PO? If it's not self-evident from the user interface, you can look at the POP10110 (open PO line items) or POP30110 (historical PO line items) tables. For example, if you replace YourPO and YourItem in the query below with yours, you'll get a 0 or a 1 in the NONINVEN field. 0 = it was an inventory item at the time of the PO, 1 = it was not an inventory item at the time of the PO.
SELECT A.NONINVEN, A.PONUMBER, A.ITEMNMBR, A.LineNumber FROM (SELECT NONINVEN, PONUMBER, ITEMNMBR, LineNumber FROM POP10110 UNION ALL SELECT NONINVEN, PONUMBER, ITEMNMBR, LineNumber FROM POP30110) A WHERE A.PONUMBER = 'YourPO' AND A.ITEMNMBR = 'YourItem'
-Victoria http://victoriayudin.com- Hi Victoria,
I ran the script & the result was a 0. It's just a really strange one.
Cheers,
Calvin - Calvin,
Certainly seems like something went wrong here. Not sure what to tell you. If this is important to track down, you might want to start a support incident and see if they can help you track it down. The only other thing I can think of that I don't think anyone has asked is whether you have any customizations or 3rd party products that may have caused something to behave differently?
-Victoria http://victoriayudin.com - Hi Victoria,
No it's not that important...I just did an adjustment but it's just weird.
Yes there are customisations on this screen, but it's only selecting a value in a radio button...that's about it.
Cheers,
Calvin
