PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

(0) Share

Report

Posted on by Community Member

When trying to do a Shipment/Invoice for a PO using the Auto-Rcv button we get an error that "All line items have been received" when indeed nothing has yet to have been received. This is recreated by

1. Allow the Receipt No to default

2. Then click the Auto-Rcv button

3. Then select a PO

4. Then click View Details

5. Then select or unselect your line items

6. Then click Receive

7. Then get prompt that "All line items have been received"

8. No line items are brought into the Receipt

If you choose Receive All after selecting the PO without clicking View Details it pulls the lines in. I checked the PO and no line items have been received and all, including the PO itself, are in Released status. This NOT happening on every PO and is NOT happening in every company database.

This is GP 2013 R2 with Workflow for PO's active. Any insight would be appreciated.

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (1)

soma 24,410 on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

Please run the below query in SQL server against your company database. And check if anyone of this query returns values or not. If this returns, you can find out which item is already received, than can verify easily.

select * from POP10310 WHERE PONUMBER ='XXXXX'

select * from POP10500 WHERE PONUMBER ='XXXXX'

select * from POP30310 WHERE PONUMBER ='XXXXX'

Note: Replace XXXXX with your PO number.

Hope this helps!!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

Soma,

That's the point. The data shows there is still some to be received. In one example, the line item had 2,800 ordered and only 2,100 received yet when we try to receive it via the Auto-Rcv button it says all line items have been received. If we do it directly in the Receivings Transaction Details Grid directly it accepts it with no error.

If you go to the Edit Purchase Order Status screen you see 2,800 ordered and 2,100 received as well. Leaving 700 left to be received.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

After 3 hours of testing various scenarios I confirmed this is being caused by GP 2013 R2 Workflow. For some reason if the Workflow_status in the POP10100 table for the PO is set to 6 it does not allow you to use Auto-Rcv. If it is set to 3 it does. The difference between 3 and 6 from what I can see is that 3 is a status of approved when no approval was required (it also shows a solid green circular icon with a white checkmark in the Workflow section of the PO). The 6 status is a status of approved when someone other than the submitter had to approve it and/or that it is final approved. That status has a white circular icon outlined in green with a green checkmark in it. I confirmed that the status of 6 prevents using Auto-Rcv by manually changing the status to 3 which resolved the issue.

Without knowing the difference between an approval with a white icon and one with a green icon (3 status versus 6 status) I can't say for sure if this is a bug or not. That said, the fact that it lets you receive the PO lines one line at a time in the Receivings Transaction grid leads me to believe that it is indeed a bug.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

I tracked down the difference between the two status icons. The white circular with green checkmark is a status of "Approve" which has the "date completed" to the right of it on the PO screen. The green circular with the white checkmark is a status of "Task Complete" and has "No Action Needed" to the right of it in the PO screen. Whether it is "Approve" or "Task Complete" your only workflow action available (whether an approver or a submitter) is to Recall it. There is now way to change the status to "Task Complete" that I can tell. The fact that the SYSTEM is the assigned user on the Approve action in the Workflow History when the status is "Task Complete" leads me to believe there is no way to move it from "Approve" to "Task Complete". Another thing to note is when the status is "Task Complete" in the Workflow History the Workflow Step in the left navigation pane has the Green icon and the Approval within it in the right pane has the white icon and the Action is "Approve". In the DEXSQL.log there is no indication of what is causing this, but it does show a call to DYNAMICS.dbo.zDP_SY01700SS_1 ( 0, 35639 ) which the 35639 error code is the "All line items have been received" error.

My guess is that this is a bug, but due to lack of documentation for the new Workflow I can't say for sure.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

The icons I explained above are the "Workflow Step" status icons. To be more specific, the "Workflow" status icons are "No Action Needed" (green icon with white checkmark) and "Completed" (white icon with green checkmark). The error happens when it is in a Workflow Step status of "Approve" and a Workflow status of "Completed". The Auto-Rcv does not error when the Step status is "Approve" and has a Workflow status of "No Action Needed".

Was this reply helpful? Yes No
Suggested answer

Mohamed El-Tohamy 305 on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

If your PO is appearing in POP10500 and QTYSHPPD and QTYINVCD are grater than 0 so you need to rest this field to make it 0.00000 or add the actual received qty, also if your receiving number is in POP10600 and QTYINVCD is greated than 0 so you have to do the same rest that field to be 0.00000 or add the actual received qty.

Please feedback

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

All, this is not an issue with data. All data is as it should be. That is why when you don't use the Auto-Rcv button you are able to receive all line items as expected. This is a bug with the new Workflow for PO's. Upgrading to the latest version resolves this issue. We have implemented that and have tested it over the past few weeks and the issue is resolved. We could not find any mention of this in the list of fixes for any service pack or hot fix but it does indeed resolve it.

Was this reply helpful? Yes No
Mahmoud Saadi 32,738 on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

If you are on GP 2013 R2, then be sure that this is a reported bug.

For the reference, Quality report number is TFS 79917.

Was this reply helpful? Yes No
Derek Albaugh on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

Looking at this known issue, it appears that while this is an issue in 12.00.1745 for Dynamics GP 2013 R2, it has been fixed in the March hotfix > 12.00.1894.

On both versions of Dynamics GP 2013 R2, I submitted a PO for approval through Workflow 2.0, then approved it so it showed ‘Complete’. Then I selected the same PO in the PO Entry window, clicked on Actions > Receive the PO Items, which opened the Receiving Transactions Entry window and the Select Purchase Order Items window.

On the 12.00.1894 build, when I mark an item(s) to receive against and click the ‘Receive’ button, it does so without any errors and goes back to the Receiving Transaction Entry window to continue the process.

On the 12.00.1745 build, when I mark an item(s) to receive against and click the ‘Receive’ button, I get the 'All line items have been received' message that you mentioned you’re currently seeing.

Based on this, my recommendation is to upgrade to build 12.00.1894 for Dynamics GP 2013 R2, which is our March, 2015 hotfix. The links and information to this patch is here:

mbs.microsoft.com/.../MDGP2013_PatchReleases

The file name is MicrosoftDynamicsGP12-KB3045189-ENU.msp

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

RE: PO Can't Be Received Via Auto-Rcv. Get "All line items have been received"

Derek,

You are correct. That is what I found. Again, when we installed the latest version the issue was resolved.

Thanks.

Was this reply helpful? Yes No