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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Inventory Reconciliation

(0) ShareShare
ReportReport
Posted on by 1,780
Hi! I would like to know what exactly system does when I perform Inventory Reconcile in GP10. I notice there are issues using Inventory Reconcile (1) When I enter a Sale Order, some of Inventory Items are showing the quantities under Allocated, in fact there are no such transactions blocking these quantities. I must run Inventory Reconciliation then only it will set correct quantities under Allocation. But the reconciliation report is showing some of lot quantities are adjusted during the reconciliation process and it increased my avaliable quantities. Is there a way to not allow system to automatically update such Lot/Serial Quantities and correct only Allocated Quantities when I perform Inventory Reconciliation? Advance thanks for your help. Regards, Mohan

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    on at

    Here is the text from Dynamics GP help file about the Effects of reconciling inventory records
    There is no option to change recompilation process.

    Effects of reconciling inventory records
    When quantities are reconciled, the quantities recorded for the item will be reset to match purchase receipt and serial number or lot number quantities. Purchase receipts won’t be removed during the reconcile procedures. Item quantities for unposted transactions are included in the reconciliation.

    The following rules also apply.

    Multiple bins
    If you’re using multiple bins, the quantities in the bins can be adjusted to match the quantity for the site. For example, suppose that the receipt quantity of Item A at the Warehouse is 45, the quantity at the Warehouse site is 50, and the total of the bin quantities for the item-site combination is 51. In this case, the site quantity would be adjusted to 45 and the bin quantity would be adjusted by six units.

    However, the allocated quantities for bins are not reconciled to the allocated quantities for the site, but to the allocated quantities in unposted transactions. This is because items can be allocated at the site level before they are allocated at the bin level. Generally, items are allocated at the site level at the instant the allocation occurs, but items are allocated at the bin level when the fulfillment of the allocation occurs.

    After you mark the option to enable multiple bins, you should reconcile inventory records. Doing so will create a bin for every item-site quantity that hasn’t already been assigned to a bin. For more information about what happens when you reconcile inventory after marking the options,

    Serial and lot numbers
    If serial numbers or lot numbers are missing, new serial numbers or lot numbers will be added during the reconciliation process. If you don’t want to use the numbers that have been added, you can enter decrease transactions to “back out” those changes, and then enter increase transactions for the correct numbers in the Item Transaction Entry window.

     


    Purchase order information
    Items entered on drop-ship purchase orders or drop-ship blanket purchase orders are reconciled to the Drop-Ship PO quantity in Inventory Control. The on-order quantities for items on a drop-ship purchase order or a drop–ship blanket purchase order aren’t reconciled. The remaining on-order quantity of released and change order purchase order line items and blanket line items are reconciled to the on-order quantity for the all-site of an item and each item–site combination of an item.

    Blanket line items are included in the reconcile process. The control line item for blanket purchase orders and drop-ship blanket purchase orders aren’t included.

    If you’re using Purchase Order Processing, reconcile purchasing information using the Reconcile Purchasing Documents window before reconciling inventory quantities. It’s important that purchasing documents are correct because purchasing information might be altered and will be used when reconciling quantities for inventoried items.

    Sales order information
    If you’re using Sales Order Processing, you also should reconcile that module before reconciling inventory.

  • Richard Whaley Profile Picture
    25,195 on at

    You are correct that you see errors especially in the allocations when using SOP.  I have been trying to track this down now for 6 years, trying to find the exact sequence of events that cause the allocations to be incorrect.

    Until one of us finds the pattern and can show MS what is happening so they can correct it, we all run reconcile frequently to realign the stars.

  • Community Member Profile Picture
    on at

    Rubel: We turned on out Lot Number tracking and after we did I have about 20 item numbers that had the Reconcile:0000000001.  Your above help in backing them out worked on all of them but one item number.  This item number is not an "On Hand" quantity, it is a "Returned" quantity.  I can not figure out how to add the Reconcile:0000000001 to the return sale so this goes away?  Any thoughts?

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans