Microsoft Dynamics GP (Archived)

purchase receipt not showing in item receipt

(0) Share

Report

Posted on by Ting Ling Heong

475

Dear all,

Would like to seek advice on below scenario:-

User received an item (serialized) without PO - said GRN12345
Account matched invoice for the GRN12345 without issue
Now, the user just realize that the GRN12345 did not showing in item receipt/item stock inquiry (qty not added)
The GRN12345 found only updated the record to POP and GL but not INV

Note:

User claimed that nothing happened during posting but he said the window "Purchasing Serial-Lot ..." did not pop up during receiving as i told him there's no serial number record found for the item received. Tried to re-create the same scenario but couldn't. The system not allowed to save/post if no serial number is entered for equal qty.
as compared, purchase receipt without PO will not have a record in table POP10500, but the GRN12345 do exist in the table.

Reconcile and check links for purchasing/inventory/PA Inventory/ PA purchasing can't re-create the missing GRN12345 on inventory side.

Is there any way to insert back the missing GRN12345 for inventory side?

Thank you.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

babubaskaran@outloo... 12 on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Hi Ting,

I think it look like you recived non inventory item.

you can return orginal receipt and book again the inventory receipt.

Was this reply helpful? Yes No
Ting Ling Heong 475 on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Hi Mr Babu,

Thanks for reply.

It can't be returned due to invoice matched and posted.

From the table POP, the item received is inventory item ( NONINVEN = 0).

Was this reply helpful? Yes No
Suggested answer

Justin Thorp 2,265 on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Hi,

As it sounds like everything is correct expect Inventory, I recommend posting an inventory increase adjustment in order to put this QTY/SerialNumber into Stock/Inventory. If the users isn't prompted to enter a serial number, please check to make sure the Item's tracking option is set to track serial numbers.

Feel free to add a note, and/or change the document number on the inventory adjustment to document why the adjustment was posted.

Thanks,
Justin

Was this reply helpful? Yes No
Verified answer

Mahmoud Saadi 32,738 on at

Like (0)

Report
RE: purchase receipt not showing in item receipt

Hello Ting,

I personally believe that this is either a non inventory item (which you already excluded as an option), or a posting corruption in which inventory records are not populated.

For option one, lets check this further from the application and specifically the module level.

Go to Inquiry > Purchase Order Documents.

Drill down to open the "Receiving Transaction Inquiry Zoom" window,

Highlight the line item, then click on the arrow identified in the screen shot below

This will open the "Receiving Item Detail Inquiry Zoom", you may check the item type which will either be "Sales Inventory" or "Non inventory"

If this is a "Sales Inventory" item type, then you shall check option 2 for resolution. If it is a non inventory item, then let us know to provide a preventive configuration that shall control such entry issues.

For option two, you do need to check the following inventory tables, IV30300, IV10200, SEE30303, IV30400 (for serial number details), and POP30330 for purchasing serial history table.

If the item doesn't exist in all the tables above, consider posting an inventory adjustment with associated serial details to correct the inventory module. If the General Ledger module is correct, uncheck the option to "Post To general Ledger" from the inventory batch window in order not to duplicate the GL values.

Your feedback is highly appreciated,

Was this reply helpful? Yes No
Ting Ling Heong 475 on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Dear Mr Mahmoud,

Thanks for detail explanation.

Checked and confirmed the Item Type is Sales Inventory:-

So, your option 2 is working in our case.

Thank you very much!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Hi Mr Mahmoud,

I have the same problem, in SEE30303 and IV30400 the serials doesn't exist but in IV30300, IV10200 and POP30330 the serials are there.

May i know how can i fix this and appear the serial numbers.

Thanks in advance :)

Was this reply helpful? Yes No
haroonattari 2,332 on at

Like (0)

Report

RE: purchase receipt not showing in item receipt

Hi Mahmoud

I am facing similar problem where I have posted Shipment/Invoice against a purchase order but it is not showing in 'Inventory Transactions' SmartList. As suggested in your post, I have checked and the items have been received as 'Sales Inventory'.

I have around 30 companies on the server and there is another company whether it is working fine means 'Inventory Transactions' is showing Purchase Receipt transactions.

Any clue is this because of any configuration or something else?

Thanks

Haroon

Was this reply helpful? Yes No