Landed Cost ID not matched

(0) Share

Report

Posted on by Sheila O.

250

We are getting a message when we try to close a PO through Edit POs. Message is "One or more line items have a Landed Cost ID that hasn't been matched. Do you want to close the purchase order?" and then it gives the option to say yes or no.

What happens if we say yes?

We are trying to cancel a remaining qty on a PO that will not be delivered for a line item.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

soma 24,410 on at

Like (0)

Report

This is just an information for the PO with landed cost which is not fully matched to landed cost id. You can click Yes to achieve your task without any issue. Look into the below link it will help you for the PO with landed cost items.

community.dynamics.com/.../automatic-close-for-po-with-landed-cost-items.aspx

Hope this helps!!!

Was this reply helpful? Yes No
Richard Whaley 25,195 on at

Like (0)

Report

WELL...it actually means that you have not performed your 3 point match for the landed costs against the PO/Receipt. Yes, if you say Yes, It will close the PO but it will leave dollars in the Accrued Receipts GL account for the amounts on the Landed Costs that were received. Best option is to match Landed Cost Invoices to the PO/Receipt.

Was this reply helpful? Yes No
Sheila O. 250 on at

Like (0)

Report

The problem we are having is that we received most of the product on the line item and matched it, however there is a small amount of product left on the line to be recieved, but we will not be getting that, so we need to cancel the remaining amount. Therefore, we won't be matching the landed cost for the remaining items.

Also, we have found in some testing that if we say yes to the message when we try to close the one PO line, then it removes the landed cost from the remaining PO lines.

What are we missing?

Sheila

Was this reply helpful? Yes No
Sheilajr 745 on at

Like (0)

Report

Hello Sheila - I have the same issue at a customer site.

The problem in this case is that landed costs were added to the PO Receipt as an estimate. Then they find out that there will not be a landed cost for that amount. They enter all the landed costs that do come in but leave the remaining LC's unmatched.

Because they are revaluing the inventory I believe that the inventory is now overstated by these estimated landed costs that have not been invoiced/matched. What can we do to back these unmatched landed costs out of the inventory costs and close the PO's?

Sheila Jefferson-Ross

Was this reply helpful? Yes No
Suggested answer

Reuben Cook 100 on at

Like (0)

Report

Sheila, you are right about the inventory unit cost including the landed cost estimate. To fix it, you will need:

1. Open the Enter/Match Invoice window and enter the Vendor ID that is on the Landed Cost ID for the PO in question.
2. Click the LC checkbox on the first line item.
3. Select the Landed Cost used on the original PO/Receivings Transaction.
4. Enter a $0 amount for the line item and match that line to the original shipment (click the Matched to Shipment blue arrow to match).
5. Click the Revalue IV and Match checkboxes and make sure it shows a variance for the total original landed cost.
6. Post the $0 Invoice.
7. This will revalue the inventory previously inflated by the value of the landed cost estimate and will create the appropriate journal entries to move the costs out of the inventory GL account.

This is assuming the Revalue IV was used in the initial Receivings transaction.

Reuben Cook]
reubenc@squire.com
www.squire.com

Was this reply helpful? Yes No