Add - Hutility Dev Tools

Name

Description

Views

Content

Sub(MainSub);
  //
  // Sage 300 Macro file: C:\ACCPAC\MACROS\MACRO01.AVB
  // Recorded at: Wed Jul 21 09:44:23 2021
  //
On(Error(GoTo(ACCPACErrorHandler)));
  // TODO: To increase efficiency, comment out any unused DB links.
using(HuAPConnection Connection = new HuAPConnection())
using(HuView ICITEM = Connection.GetView("IC0310"))
using(HuView ICUNIT = Connection.GetView("IC0750"))
using(HuView ICITMTX = Connection.GetView("IC0330"))
using(HuView ICITEMO = Connection.GetView("IC0313"))
using(HuView ICITMV = Connection.GetView("IC0340"))
using(HuView ICITMC = Connection.GetView("IC0319"))
using(HuView ICITEMSO = Connection.GetView("IC0314"))
using(HuView ICITEMLO = Connection.GetView("IC0312"))
{
	ICITEM.Compose(ICUNIT,ICITMTX,ICITMV,null,null,null,null,ICITEMO,ICITMC,ICITEMSO,ICITEMLO);
	ICUNIT.Compose(ICITEM);
	ICITMTX.Compose(ICITEM,null,null);
	ICITEMO.Compose(ICITEM);
	ICITMV.Compose(ICITEM,null,ICUNIT);
	ICITMC.Compose(ICITEM,null,ICUNIT);
	ICITEMSO.Compose(ICITEM);
	ICITEMLO.Compose(ICITEM);
	ICITEM.Fetch();
	ICITEM["ITEMNO"] = "A1-103/0";  // Unformatted Item Number
	ICITEM["COMMENT1"] = "Comes with stand and mounting bracket for wall or shelf.2";  // Comment 1
	ICITEM.Update();
}

Add or modify

Save sample Sage code