Announcements
No record found.
Can you think of any reason why the landed cost is not available to select in match shipments to invoices? It's been received in.
*This post is locked for comments
Hello again Shelly
It could be one of two reasons, either the landed cost has already been invoiced, or there is some sort of a glitch occurred throughout the posting process which prevents you from being able to match the LC.
Could you please initially check whether the receiving has been fully invoiced ? You can make use of the SQL script provided on Purchase Order Receiving and Invoices Details – SQL Script in order to help you retrieve all the associated details for a specific receiving.
Then you may proceed with a reconciliation as a health check.
Your feedback is highly appreciated,
ShellyAnn
Just following up, what's the status of this case ?
Hi Mahmoud, I did run your script. It pulled up 24k records. It was hard to go through it all. In GP the PO shows closed?
You should have filtered by the specific PO to retrieve only the associated records.
But anyway, if the PO is closed, then all the items have been received and matched and there is no remaining quantities to receive or match to invoices.
lol well I am not that sql savy! Still learning =) Thanks for your help much appreciated!
No worries :)
Never hesitate to share any further inquiries,
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Shravan Attelli 1
