jdesmm
Well Known Member
We have been having a periodic problem that we have not yet been able to trace (although I've found some interesting food for thought in some past postings to the list) in which lines in the F4074 - Price History table - "disappear." This disappearance occurs at some late stage of the game apparently, because all of the related information - sales order detail unit price, G/L distributions, etc. are there to show that the lines did exist and were processed properly. We are pursuing the cause of this problem, but in the meantime, for reporting and auditing purposes, the company needs the lines re-added to the F4074 and has requested that IT insert them via SQL.
I have been researching the possible impact of doing this and so far, it looks like since we already have all of the financial information in place, it is a matter of inserting to the F4074 only, emulating the original data. To determine this, I went through the code in the P4210 / P4074 to follow along with what happens when users add pricing information during their normal process. I feel pretty confident at this stage that we can do this without adverse impact (we will of course test thoroughly in PY first!), and I would like to confirm with any gurus out there that there are no other related tables we need to hit given our scenario.
Thanks in advance!!
--Shelley
I have been researching the possible impact of doing this and so far, it looks like since we already have all of the financial information in place, it is a matter of inserting to the F4074 only, emulating the original data. To determine this, I went through the code in the P4210 / P4074 to follow along with what happens when users add pricing information during their normal process. I feel pretty confident at this stage that we can do this without adverse impact (we will of course test thoroughly in PY first!), and I would like to confirm with any gurus out there that there are no other related tables we need to hit given our scenario.
Thanks in advance!!
--Shelley