Is it possible to reconstruct missing POP10500 records?

[Bud]

Someone brought to my attention today an odd PO receipt transaction...

When you look at the receipt on the Inquiry screen, it shows all the lines
but the quantities are all zero. Looking "under the covers", I discovered
that the quantity records were missing from the POP10500 table. Fortunately,
this is the only receipt that this happened to, and it looks like the other
tables (IV30300, etc.) are OK.

Regardless of how this happened, I was wondering if there is any way to
rebuild the missing POP10500 records without affecting anything else? I
thought of running a reconcile, but I was afraid it might alter the other
records based on the missing POP10500 ones.

Any thoughts?

--
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Financials
Currently supporting: GP 9.0, SP2

[Adam]

Hi Bub

I would try the 'Check Links' function.

In GP 10.0, it is under, Microsoft Dynamcis GP > Maintenance > Check Links.
Select the Purchasing Series & run for all. Make sure you backup your DB
before running & run while logged in as the sa.

Adam

[Mohammad R. Daoud]

Bud,

The Inventory Reconcile will fix this issue out, you could reconcile this
item records ONLY, however, regarding your question below:

“I was afraid it might alter the other records based on the missing POP10500
ones”

Reconcile corrects any incorrect numbers in your inventory, so if it did
alter the other records then you had a problem in those transaction which
should not remain as is.

Regards,
--
Mohammad R. Daoud
MVP, MCP, MCBMSP, MCTS, MCBMSS
Mob: +962 - 79 -999 65 85
Great Package For Business Solutions
dao...@greatpbs.com
http://www.greatpbs.com
http://mohdaoud.blogspot.com/

[Bud]

The reconcile process doesn't help. I went into our test company and deleted
the POP10500 records for a receipt to try it out, and here's what I found:

After running an Inventory reconcile for the items, nothing changed on the
receipt (that is, the POP10500 records were not readded).

I then ran a reconcile on the associated purchase order, and it 1) adjusted
the uncommitted quantity to reflect the deleted quantities, and 2) changed
the status of the PO line items to Released (from Received - as if the items
were never received).

I ran the inventory reconcile again to see what would happen, and it
adjusted the On Order quantities UP as if the items were never received.

This is what I was afraid would happen if I ran the reconcile routines - the
system recalculates things as if they were never received. I can't do this,
because the G/L has had transactions posted for the receipt and there are
inventory transactions posted, as well.

I wonder if somehow I can manually reconstruct the missing POP10500 records?

--
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Financials
Currently supporting: GP 9.0, SP2

[Frank Hamelly, MCP-GP, MCT, MVP]

I would think you could manually update POP10500 Bud but you would
also need to check the following tables to see if they need records
added also -

POP30300 Receipt History
POP30310 Receipt Line History

And if it was a PA related receipt -

POP11300 POP PA Receipt View
POP11310 POP PA Receipt Line View

You'd want to run Checklinks and Reconcile after adding the records.

Hope this helps,

Frank Hamelly
MCP-GP, MCT, MVP
East Coast Dynamics
www.eastcoast-dynamics.com
blog: www.gp2themax.blogspot.com

[Bud]

The POP30300/30310 are OK, it's just the POP10500 records that are missing
for some reason. Thanks!

--
Bud Cool
Microsoft Certified Business Management Solutions Specialist, GP 9.0
Financials
Currently supporting: GP 9.0, SP2