• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Re-Populate F4074 records

Hi all,

Does have anyone have a SQL script for populating the F4074 Price History table? We have a process that splits large orders and that hasnt been adding the rebates onto these new orders and I need to find a way to quickly recreate the missing entries so that our reporting system had all the correct information.

If not a SQL script can the business function be worked into a new program to fix this?

Cheers
Jason
 

Larry_Jones

Legendary Poster
-- INSERT PRICING HISTORY FOR SO'S INTO F4074
USE JDE_PRODUCTION;

insert into proddta.f4074
values (77668, 'SO', '00022', ' ',6000, 0, ' ', 20,0,0, 'GENERAL', 'BASE', 0,0,' ','EA',0, ' ',' ', '5',9400,'N',9400,0,' ',
'AD ','1',' ','Y','1',3,0,0,0,0,0,'0',' ',0,' ','1',' ',' ',0,0,' ','0',' ','0',0,0,' ',' ',' ',' ',' ',' ',' ',
'CCARVO','SQL','XY20304',120099,111111,' ',' ',' ',' ',0,' ',' ');

insert into proddta.f4074
values (77668, 'SO', '00022', ' ',6000, 0, ' ', 40,0,0, 'GENERAL', 'COMM2', 0,0,' ','EA',0, ' ',' ', '5',0800,'N',0800,0,'COMM',
'CR ','1',' ','Y',' ',5,0,0,0,0,0,'0',' ',0,' ','1',' ',' ',0,0,' ','0',' ','0',0,0,' ',' ',' ',' ',' ',' ',' ',
'CCARVO','SQL','XY20304',120099,111111,' ',' ',' ',' ',0,' ',' ');
 
Top