• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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

Member
-- 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