Share
Report
815We use Extended Pricing on GP10, with extensive use of distributor level discounting based on item Price Groups, so that certain PriceGroups get certain discounts.
When we redesigned our discount structure, we re-assigning almost all of our items PriceGroups to use the new ones, but since the move was happening in groups (of items), the old Price Groups still existed in our system.
I discovered oddities in that items appeared to revert back to their old Price Group at seemingly random intervals. I originally thought that I'd just failed to move the complete set of items over to the new Price Group, but I confirmed that the value had changed by taking a snapshot of the ItemNmbr & PrcGrpID data in IV10400, and the comparing it to a later snapshot of the same data.
It appears (though I have not studied this completely) that when an inventory transaction takes place on an item that has had a recent change to it's Price Group, the Price Group master reverts to the old value. It appears that there is inventory activity - a released backorder, a posted asembly, (maybe an inventory receipt?) that occurs around the same time that the reversion takes place.
My solution has been to schedule this snapshot hourly, and script a comparison between snapshots. Several times a day, it identifies a few items that I have to RE-switch to the new Group.
Any thoughts? Why should an inventory transaction alter a master file like the Price Group?
*This post is locked for comments
All responses (
Answers (
