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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Cannot locate serial n...
Microsoft Dynamics GP (Archived)

Cannot locate serial number received

(0) ShareShare
ReportReport
Posted on by baxter05

On 2/2/11 we received an item that is tracked by serial number.

Our ITEM INQUIRY shows there are FOUR of this item in inventory and all of them are shown to be ALLOCATED.

When we click the ALLOCATED button in the ITEM INQUIRY window, only THREE of this item(with s/n) shows up - the one I need, is not there.

When we go to INQUIRY>SERIAL/LOT NUMBER TRACE, and enter the serial number we are looking for, it only shows the RECEIPT NUMBER and date.

When we go to INQUIRY>SERIALS and type in the item number, all FOUR serial numbers (related to the amount shown as allocated in ITEM INQUIRY show up with the ALLOC button checked.

HOWEVER, we cannot locate this serial number in the system.  It shows as being received and shows as being allocated but cannot be found.

HOW do I find it and correct it?  It is on our warehouse shelf.  There are no items marked as In Use, Damaged etc.  It simply shows as being here and being allocated without being allocated.

We are using Dynamics GP 10

Thank you.

 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Pam,

    Straight away I would reconcile inventory, and then I would look in the list of tables below to see if I could track down the item.

    IV00200 Item Serial Number Master

    IV10002 Inventory Serial and Lot Number Work

    IV10004 Inventory Bin Quantity Transfer

    IV10302 Stock Count Serial Lot

    IV30400 Item Serial and Lot Number History

    IV30702 Stock Count Serial Lot History

    POP10330 Purchasing Serial Lot Work

    POP30330 Purchasing Serial Lot History

    SOP10201 Sales Serial/Lot Work and History

    Kind regards,

    Leslie

  • Suggested answer
    baxter05 Profile Picture
    baxter05 on at

    Leslie,

    Thank you for your response - Reconciling the inventory I knew would be my first step; but I wasn't sure of all the tables I would need to look in.  I think I only managed to come up with half of what you've suggested.

    I made arrangements with my accounting department yesterday to have all invoices posted by end of today so I could work on this tonight. (I have to schedule these reconciliations around the accounting departments posting schedule).

    I will respond on Monday with my findings.

    Thank you again.

    Pam

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Check to see if the firm is using Separate Fultillment.  If you are using Serial Numbers, it is almost required.  Otherwise, when an order is entered, it is fulfilled immediately and a serial number is taken.  Most of the time you want to pull a serialized item during picking and report the serial number used as part of a fulfillment process.

    Our Understanding Sales Order Processing manual explains order fulfillment completely and discusses serialized inventory as well.

  • baxter05 Profile Picture
    baxter05 on at

    Reconciling inventory was all that needed to be done - the errant sn is now available -

    thank you

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans