web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Orphaned Serials

(1) ShareShare
ReportReport
Posted on by

Hi All,

Users, Users, Users...

It appears that a user was processing a serialized product in the Receiving Transaction Entry.  And, based on what I can peice together the events:

1.  The user had entered the base information for the receipt/product and was on the placed on the Serial entry screen.

2.  The user proceeded to enter 3 serials agains the product and then closed.  BTW -- There were 13 serials to be entered.  So, the total number of serials were not entered when the serialization window was closed.

3.  After the user was returned back to the Receipt entry..  They deleted the receipt.

4.  On attempting to create a new receipt for the same product the user was presented with an error on the serialization entry screen that the serial(s) 3 previously entered are already associated with the product.

5.  A quick search of all the Company tables identifies that the only place these 3 serials exist is on Table POP10330.  See clipping below.

6.  Interestingly, if you looka t the above clipping, it looks like the user used a Non-Traditional Receipt Number (actually the value corresponds to the vendor's PO number. 

7.  If I try to retreive the above receipt nothing is returned.  And, GP does not seem to recognize it as a previous receipt.

Anyway, the transaction was re-created (receiving 10 items vs the original 13) and posted successfully with the exception of the 3 serials above which GP says are already correlated to the product.

The question: Can I simply delete the 3 above rows to resolve the Serialization issue without further issues?

Thanks,

Gus

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Redbeard Profile Picture
    12,931 on at
    RE: Orphaned Serials

    Gus -

    Here is a link to a similar post.  

    community.dynamics.com/.../109386.aspx

    You should delete the receipt in question, and then run the reconciliation routines recommended in the post.

  • Community Member Profile Picture
    on at
    RE: Orphaned Serials

    Hi Redbeard,

    Thanks for the response.  I had already read the lost you linked.  The situation, i believe,  is different in that:

    1.  The receipt is not available. 

    2.  The reconcile and links check all return no errors.

    3.  The provided script returned no records in any of the tables.

    Thanks,

    Gus

  • Verified answer
    Redbeard Profile Picture
    12,931 on at
    RE: Orphaned Serials

    Gus -

    Your query in step 5 above indicates you have records in the POP10330 table (Purchasing Serial Lot Work) for POPRCTNM '20141217-LVP' - if the queries in the other post don't produce results for this POPRCTNM, then you have abandoned records in the POP10330.

    These need to be cleaned up - if running Check Links on the Purchasing files doesn't clean these abandoned records up, then you may need to run a delete query in SQL.  Once these records are gone the utilities will likely produce different results.

    As long as the records exist in the POP10330 table, you will not be able to reassign these serial numbers.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    32,738 on at
    RE: Orphaned Serials

    Nothing more valuable at all to what's mentioned above by Harry. I may have a little to add up

    • Run the search all db stored procedure for the specific receipt number, which is provided on spSearchOnAllDB: SQL Stored Procedure to Search an Entire Database
    • Delete the records retrieved by the stored procedure above
    • Run reconciliation for the selected modules in the following order (POP, IV, GL)
    • Re-enter the receipt correctly
    • Check the vendor, item and GL balances accordingly

    Never forget to take a back up first

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    on at
    RE: Orphaned Serials

    Hi Redbeard,

    Very sorry for the delay..  This implementation is driving me into the ground.   I finally got it resolved.

    Thank You and Mahmoud for your help.

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans