Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Suggested answer

Inventory Reconcile Error

Posted on by 237
Dear All,
 
Recenlty when we ran inventory reconcile against an item, we got the following report, On Inventory Purcahse Receipts Work table it added records as reconcile and add new lot as reconile:0001 and so on. 
 
Further to my investigation, the last invocie posted against this item got pick the unit cost as /0/ and on IV Purchase receipts & HITB table the sales in not recoded. 
 
Kindly advise how to reverse the lots and bring back quantity, for your inforamtion, we use mutliple bins and Lot tracking
 
 System:     1/16/24     3:12:40 PM                                                    Page:    1
 User Date:  1/16/24                                      RECONCILE REPORT                                   User ID: ramanan
                                                          Inventory Control
   
 Ranges:         From:                            To:
    Item Number  UB1102/U3(AE) W/ DUST BAG        UB1102/U3(AE) W/ DUST BAG
   
 Item Number                    Description                                        Site               Bin
 -----------------------------------------------------------------------------------------------------------------------------------
    Error Message
 -----------------------------------------------------------------------------------------------------------------------------------
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG
    Updated Purchase Receipt SEQ record for Item UB1102/U3(AE) W/ DUST BAG.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      All Sites
    The On Hand Quantity has been adjusted from 1,878 to 3,756.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN
    Added lot number RECONCILE:0000000001.
    Added lot number RECONCILE:0000000002.
    Added lot number RECONCILE:0000000003.
    Added lot number RECONCILE:0000000004.
    Added lot number RECONCILE:0000000005.
    Added lot number RECONCILE:0000000006.
    Added lot number RECONCILE:0000000007.
    Added lot number RECONCILE:0000000008.
    Added lot number RECONCILE:0000000009.
    Added lot number RECONCILE:0000000010.
    Added lot number RECONCILE:0000000011.
    Added lot number RECONCILE:0000000012.
    Added lot number RECONCILE:0000000013.
    Added lot number RECONCILE:0000000014.
    Added lot number RECONCILE:0000000015.
    Added lot number RECONCILE:0000000016.
    Added lot number RECONCILE:0000000017.
    Added lot number RECONCILE:0000000018.
    Added lot number RECONCILE:0000000019.
    Added lot number RECONCILE:0000000020.
    Added lot number RECONCILE:0000000021.
    Added lot number RECONCILE:0000000022.
    Added lot number RECONCILE:0000000023.
    Added lot number RECONCILE:0000000024.
    Added lot number RECONCILE:0000000025.
    Added lot number RECONCILE:0000000026.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 37.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 44.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 22.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 255.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 255.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 45.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 128.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 127.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 63.
    The Quantity Received of purchase receipt Reconcile has been adjusted from 0 to 1.
    The On Hand Quantity has been adjusted from 1,878 to 3,756.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               06-AWRL
    Added purchase receipt /Reconcile/ for lot number MR-11805-CHINA.
 
   
   
 Item Number                    Description                                        Site               Bin
 -----------------------------------------------------------------------------------------------------------------------------------
    Error Message
 -----------------------------------------------------------------------------------------------------------------------------------
    Added purchase receipt /Reconcile/ for lot number MR-11805-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11925-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11925-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-12269-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-12269-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2514376A
    Added purchase receipt /Reconcile/ for lot number MR-11330-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11506-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11506-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2516246A
    Added purchase receipt /Reconcile/ for lot number MR-11750-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11750-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2517132A
    Added purchase receipt /Reconcile/ for lot number MR-11618-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11618-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2517266A
    Added purchase receipt /Reconcile/ for lot number MR-11536-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2517346A
    Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2517346B
    Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11611-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2518256B
    Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2518276A
    Added purchase receipt /Reconcile/ for lot number MR-11825-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2518316A
    Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2519192A
    Added purchase receipt /Reconcile/ for lot number MR-11966-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2519366B
    Added purchase receipt /Reconcile/ for lot number MR-11631-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-11631-CHINA.
 UB1102/U3(AE) W/ DUST BAG      ELECTRIC BLOWER WITH DUST BAG                      MAIN               2524244B
    Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
    Added purchase receipt /Reconcile/ for lot number MR-12054-CHINA.
   
 Total: 1
 
Categories:
  • Suggested answer
    Lisa at AonC.com Profile Picture
    Lisa at AonC.com 3,134 on at
    Inventory Reconcile Error
    Is this a new item that may have had some issues with setup and/or a change after it was created?  Or possibly an issue with posting a transaction?  Or maybe someone added lot number tracking to an item via SQL and GP has now had to get the missing records properly populated?

    If you have Historical Inventory Trial Balance (HITB) activated and are comfortable with SQL, there may be some clues to what happened in the SEE30303 table.

    Here is a nice blog post on the new transactions created with Inventory Reconcile:
     
    https://mahmoudsaadi.blogspot.com/2014/10/inventory-reconciliation-adding-new.html

    Depending on what you find with your research, you'll need to adjust the data.

    (When I can't figure out the root cause of an issue, I like to confirm the item is set up properly, complete inventory transactions to get the item all the way to zero units on hand.  Then, do an inventory transaction to bring in the quantities/lots at the current cost.  If it is a new item and I can't track it down, I will also consider renumbering the item when it is at zero and then re-create the item with the same number but being very certain that the setup is correct.)
  • Judy Profile Picture
    Judy Microsoft Employee on at
    Inventory Reconcile Error
    Hi,
     
     
    Please check the Microsoft Document about the Inventory Control in Dynamics GP  to see if it can help:
     Hope other experts can suggest on this.

    Best Regards,
    Judy

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

Product updates

Dynamics 365 release plans