Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

POP - Enter Match PPV question

Posted on by 1,455

Customer has inventory in another system, and populates GP POP.  When receivings come in they also come in through the other system and are imported and posted. No actual inventory items reside in GP.  They have many pricing differences from standard cost, but when they do the Enter/Match process to match the invoice to the receipt, it will not allow them to change the inventory account for the pricing difference. So, on each enter/match they have to manually edit the distributions with 2 'other' type lines to back the inventory account out and post it to the correct PPV account.

The vendors do not have a default PPV account set up, but I am not sure that would work anyway because they have multiple locations thay are tied to the GL so, they cannot default one GL account on a vendor since it may hit 9 different locations which would determine the first segment of the GL account string.

I looked at the site setup, but all of the importing only comes into MAIN so there would be no substitution there.

Customer said she would even prefer to have the GL line blank for PPV - if it cannot default by the location.

Does anyone have a clue as to how er can set this up to default a blank account for PPV or default a PPV by the location already in the rest of the distribution?

*This post is locked for comments

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    RE: POP - Enter Match PPV question

    The inventory receipt (which is imported) typically debits Inventory, credits Received Not Invoiced, and, if there is a difference from Standard, a PPV account.  However, since you have no inventory, the system cannot determine the valuation method of the item received, and treats it as a non-inventory item.  Thus RNI and Inventory are hit.

    During the matching, the RNI is reversed, the amount on the invoice is posted to payables, and, if there is a difference, again a ppv account is hit.  Without sites, and receipts to sites, the site segment cannot be changed.  In other words, why are you receiving everything to the site Main?  

    GP does not have default PPV accounts by site, only the ability to change certain accounts by the site segment.  I do not believe that the PPV account is one of those. (inventory asset, sales, cost of goods sold, and returns)

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans