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

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (6)

Answers (0)

Bron 4 on at

Like (0)

Report

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.....:))))))

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Richard, was this from MS?

Could you PM me some details?

Ian.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No