Add or modify

Save sample Sage code

---

Name

Description

Views

Content

// TODO: To increase efficiency, comment out any unused DB links. using(HuAPConnection Connection = new HuAPConnection()) using(HuView ICREOR = Connection.GetView("IC0599")) using(HuView ICREORD = Connection.GetView("IC0600")) using(HuView ICREORO = Connection.GetView("IC0601")) { ICREOR.Compose(ICREORD,ICREORO,null,null); ICREORD.Compose(ICREOR); ICREORO.Compose(ICREOR); ICREOR["ITEMNO"] = "A11030"; // Item Number ICREOR["LOCATION"] = "2"; // Location ICREOR.Read(); ICREOR.Process(); ICREORO.Init(); ICREORD["PERIODSTRT"] = DateSerial(1900,7,1); // Period Start ICREORD["PERIODSTRT"] = DateSerial(1900,7,1); // Period Start ICREORD.Read(); ICREORD["MINLEVEL"] = "24.0000"; // Minimum Quantity ICREORD["MAXLEVEL"] = "510.0000"; // Maximum Quantity ICREORD["REORDERQTY"] = "500.0000"; // Reorder Quantity ICREORD["SALESPROJ"] = "500.0000"; // Projected Sales Qty. ICREORD.Update(); ICREORD["PERIODSTRT"] = DateSerial(1900,7,1); // Period Start ICREORD.Read(); ICREORD.RecordCreate(0); ICREORD["PERIODSTRT"] = ""; // Period Start ICREORD["MINLEVEL"] = "22.0000"; // Minimum Quantity ICREORD["MAXLEVEL"] = "23.0000"; // Maximum Quantity ICREORD["REORDERQTY"] = "24.0000"; // Reorder Quantity ICREORD["SALESPROJ"] = "25.0000"; // Projected Sales Qty. ICREORD.Insert(); ICREORD["PERIODSTRT"] = DateSerial(1900,8,1); // Period Start ICREORD.Read(); ICREORD.RecordCreate(0); ICREORD["PERIODSTRT"] = DateSerial(1900,8,1); // Period Start ICREORD.Read(); ICREORD["PERIODSTRT"] = DateSerial(1900,8,1); // Period Start ICREORD.Read(); ICREOR.Update(); }

---

Add/Update

---