Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Beat Bucher]

Good day everyone,

My AP person sent me an e-mail yesterday stating that he couldn’t invoice a received PO because the system told him that one of the line item was already invoiced, which is not true according to him.

When checking in GP PO document inquiry for that particular PO, the system returns only one Receipt with the 3 line items from the original PO.

However, when running a smartlist of open PO’s to invoice, it shows only a partial amount rather then the total amount of the PO. When running a SQL query against that PO accross multiple POP tables, I found an entry that I can’t find anywhere in GP for a second receiving that was done against 1 line item in that PO.. strangely I can’t seem to get rid of that receiving document, since GP doesn’t display it. Trying to edit the receipt by the Number, GP complains that the document already exists in history and I should use another number..

Checked also the transactions by Vendor, and there is no trace of that receiving or invoice related to this PO yet..

What can I do ? Is there a way to remove that receiving transaction so he can complete the invoicing for the full PO amount ?

Thanks in advance for your tips,

PS: One thing that I just remembered, is that the PO is associated with a Fixed Asset purchase and somehow the 2 line items made their way already into the FA, but were not processed yet.. Normally all 3 line items should be assigned to FA

PPS: double-checked and actually all 3 line items made their way into the FA module.. The entries from the POP10600 & POP10500 tables are showing that an invoice document exists already for that PO with only 1 line item, but the system thinks it was already processed and is not accesible anymore.  I’m going to delete the 2 entries after having backed them up..

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
——————————

[Beat Bucher]

we ended up appliying the solutions suggested in this forum post :

https://community.dynamics.com/gp/f/32/t/120668

But also had to change manually the status of the PO from closed to received, as it got automatically closed after another receiving.. kept banging our heads due to this.

https://community.dynamics.com/gp/f/32/t/185329

This allowed us to post the invoice against the received PO and then close manually the PO again.

Due to our FA module interconnexion in the POP, I had to delete the addtionnal lines from the FA01100 table before they got processed.. otherwise it would have tripled the asset entries.

——————————
Beat Bucher
Business Analyst, Dynamics GP MVP
Ultra-Electronics Forensic Technology Inc.
Montreal QC/Canada
+1-514-489-4267
@GP_Beat http://dyngpbeat.wordpress.com/
Montreal QC GPUG Chapter Leader
GP2013R2 / MR2012 CU14
————————————————————————-