Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Remove received invoice/items from inventory module. voided in AP

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Purchasing Inventory clerk made a shipment/invoice entry from PO in AP, then voided this transaction and remove it, but this transaction inventory items still found in inventory module. How to remove it or can reverse Qty & cost effect.

B.R

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Remove received invoice/items from inventory module. voided in AP

    Mounir

    Any updates on the issue above ?

    You may close the topic in case the issue has been resolved.

    Your feedback is highly appreciated,

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Remove received invoice/items from inventory module. voided in AP

    When posting any type of "out" transaction in the inventory module, such as Adjustment out. The system will not allow any user interruption to change the unit cost since it is primarily controlled by the valuation method.

    You do need to consider manual correction for this type of transaction.

    Not to keep your options limited, you can post a "return" transaction on the POP module. Although, this will double the vendor balance. You need to proceed with a manual correction as well to correct the vendor balance.

    Never hesitate to share any further inquiries,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remove received invoice/items from inventory module. voided in AP

    Mahmoud you have supposed the sequences that it is already done.

    When try to use adjustment or variance transaction in inventory module, they doesn't allowed to use purchased unit price cost but may be get weighted average unit price.

    May be I’ll use item transaction for quantity adjustment, but what about price variance adjustment?

    B.R

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Remove received invoice/items from inventory module. voided in AP

    Hello Mounir

    Basically, I suppose the following sequence of steps was performed by the purchasing clerk:

    • Receive inventory items: through shipment/invoice transaction on the purchasing module
    • The transaction above was voided on the AP level
    In case this is the scenario, you should not look for "remove transaction history", neither on the AP nor on the inventory level. For the inventory module, this utility removes the inventory history transactions (IV30300) leaving your cost layers untouched and available for further processing. 
    The shipment/invoice transaction resulted with the following journal entry :
    Financial Perspective :
    Account                           Debit                               Credit
    Inventory                              X                                    0
    AP                                         0                                     X
    Inventory Perspective : 
    Quantity increase for items by creating new cost layers which are available for processing
    Voiding the transaction on the AP level closes down the liability of the vendor without any further impacts on the inventory balance. In order to proceed, you need to post an (Adjustment Out) transaction to handle the inventory quantity. 
    In case the scenario above is not the actual scenario performed by the clerk, please never hesitate to elaborate furthermore.
    Your feedback is highly appreciated, 
  • Suggested answer
    soma Profile Picture
    soma 24,410 on at
    RE: Remove received invoice/items from inventory module. voided in AP

    Have you tried to remove the Inventory Transaction History in IV module(Tools-->Utilities-->Inventory-->Remove Transaction History)? If not run the same.

    Note: Before process Remove Transaction History, make sure you have a latest backup for your company DB.

    Hope this helps!!!

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remove received invoice/items from inventory module. voided in AP

    correction

    the Document Number voided is "Vendor Doc. No. ", that entery when received the PO

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Remove received invoice/items from inventory module. voided in AP

    Purchasing>utilities>Remove Payables transaction History .. then enter  Document Number 'PO Number' and checked box true for ( transaction, distributions, report)

  • soma Profile Picture
    soma 24,410 on at
    RE: Remove received invoice/items from inventory module. voided in AP

    How did you removed shipment/invoice entry from PO in AP module?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans