Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

duplicated quantity in same item 3 times with same document number

Posted on by 375

dear friends , i really in a big trouble and need very important help , i'm facing problem in purchasing module in GP10 , it's about the quantity have been duplicated in the store for this received items after i have made posting in receiving shipment invoice in Receiving transaction entry , have any one got idea how can i control it or resolve it ?
and i thought about the return window to make returning the another 2 quantities but , it refuses to make it many times . and i will be very thanks if anyone has the resolving issue , bast regards

*This post is locked for comments

  • Mohammad Abou Aly Profile Picture
    Mohammad Abou Aly 375 on at
    RE: duplicated quantity in same item 3 times with same document number

    I totally agree with you , anyways i will be time to time contact to you always , you are very beat solution person in GP10 amd really helper and supportive , keep going forward MR  RICHARD WHEELER and god be with you forever , a gain thanks alot for answering my question

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: duplicated quantity in same item 3 times with same document number

    It all depends on how extensive the damage is. What you have said has happened is unusual. There may be damage to your data. So the firrst thing you do is create a backup and then  run check links on the purchasing series. If there error still exists, then doing as Frank suggested is correct. However, the next problem may be your stock quantity. If you check the stock quantity it is wrong? You should also run Inventory Reconcile(Tools->Inventory Reconcile) to correct any errrant amounts. Now if check links and reconcile do not resolve the issue then doing a negative inventory adjustment would be the simplist way to correct the stock quantity.Now it would also be interesting to see waht Inquiry->Purchasing->Purchase Order documents shows. Does it also show the multiple receipt lines? You can always click on a person's name on this website if you want to task this conversation offline. However, it is always good to get mulitple points of view so it may be best to continue this conversation in this forum.

  • Mohammad Abou Aly Profile Picture
    Mohammad Abou Aly 375 on at
    RE: duplicated quantity in same item 3 times with same document number

    Dear Mr Rechard , i really thanks alot for replying me a gain with appreciating my issue , i was searched on internet many times and i saw some resolving and comments by the SQL tables , some people proposed to editing it by table pop30300 or pop30310 , and your resolving is totally right and cleared , but i'm totally confused , is the other way can help also or not ? , BTW i wish if i could contact to you my private e-mail , would you mind mr Rechard if we became friends ? thanks alot for your answering me and your awesome replying , with my best wishes : mohammad abou aly  

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: duplicated quantity in same item 3 times with same document number

    Are you saying you posted a PO shipment receipt for an item and after posting you now see duplicated? Is this just for one PO or is this a recurring problem? I would start by running check links on the purchasing series, Has this PO been closed or can you still do a return against it? What type of Return are you tring to do? Return, Return wCredit, Inventory or Inventory w/Credit? Please read the manual by pressing F1 while on that screen to read the differences. If this fails you can do an negative inventory adjustments to get those items out of stock.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans