Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Too lazy to check myself....cannot change PURCH distribution at a summary level.

Posted on by Microsoft Employee

SP 2 of GP 10 stopped users changing the PURCH type distribution on a PO at the summary level - and forced them to change it at a line level.

Was this reversed at all in later service packs?...or indeed later version.

If not, does anyone know if there are plans to bring back this functionality - at least for non-inventoried items?

Ian.

 

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    Services Summary:     A change was instituted in GP 10 SP2 that prevents a user from changing the PURCH type account in the Distribution window opened from either Receivings Transaction Entry or Enter/Match Invoices window.  This change was incorporated so that the HITB report would be accurate.  

    This customization will allow the user to change the PURCH type account in the Distribution window opened from either Receivings Transaction Entry or Enter/Match Invoices window even if the Inventory Control module is registered.   The result of allowing the user to change the PURCH type account will be that Inventory and GL will not balance and the HITB report will not be accurate and will be unusable.  

    The Product ID assigned to this was 6227. I can only assume they will charge something for this. Maybe if enough people ask for this they will create a PO option that you can set on or off.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    Yes, this was provided by Microsoft. The code basically makes the PO module behave as it did prior to the IV HITB requirement came along. It allows you to change the distibution on the PO at the header level and no longer having to go to each line and change the distribution. When I get back to my office I will forward along the exact description of the module.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    Hi Richard, was this from MS?

    Could you PM me some details?

    Ian.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    I had to breakdown and ask support to provide the customization to reverse the update. They provided it to us so hopefully they would not charge too much for it. We have the same situation where PO's are used just for the processing portion. Everything is a service item.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    Yes,considered all of these.

    The issue is though, one customer has become used to short circuiting the system. They enter a line for a non inventory item called 'Stationery', with a quantity of 1 and a cost of say $1000.00.

    In GP version 9 they could click the Summary Distributions button on the Receipt Document and split out the PURCH distribution...$500 to this account, $250 to another account, $100 to another account etc. (because say, the sales department gets 20 reams of paper, and the accounts department gets 10 etc etc.)

    In Version 10 - this is taken away. They are faced with:

    1. Entering a MISC type distribution to reverse the PURCH type distribution...and then entering various MISC type distributions to split the line cost.

    2. Creating a Fixed Allocation account...and manipulating the Percentages to suit each receipt.

    3. Splitting the stationery line into multiple lines - each representing the amount that needs to be posted to each account.

    I know there are very good reasons for this...and in a way it closes a potential hole in GP - however, for Non inventoried items, I can't see the sense...a check box that would turn on / off this functionaity would have been a better solution.

    One for the suggestions box.

    Ian.

  • Bron Profile Picture
    Bron 4,887 on at
    Re: Too lazy to check myself....cannot change PURCH distribution at a summary level.

    It was never reversed and I don't think it will be. Accounts can be changed at the PO receipt entry window - unfortunately it's by item only - so if you have a PO with 30 items - you need to change all 30 - most people for non inventory will try to setup account at vendor level so - there is at least an account defaulting in when the PO is received..........

    This was changed because GP did some changes to inventory revaluation, HITB, etc....have fun.....I wondered (have never tried) if I could create a SQL trigger that 'rolls' down changes from the PO receipt entry window - just like we used a trigger to update requested ship dates from SOP header to detail back in the day.....:))))))

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans