Get data from superview AR0160 1

[vbdbcoder]

I have a need to get data from a superview,AR0160. Is it feasible?

My code:

private void get_ARCBAL()
{
AccpacDataSrc.AccpacDataSource ads = new AccpacDataSrc.AccpacDataSource();
ads.Session = vSession; //active accpac session
ads.ViewID = "AR0160"; //this is superview
ads.Active = true;
ads.GoTop();
ads.Order = 0;
ads.Browse ("IDCUST = 103", true); //customer 103 has data
int i = 0;
if (ads.Fetch())
{
string CUSTID = ads.Fields.FieldByName["IDCUST"].get_Value().ToString();

string NameCUST = ads.Fields.FieldByName["NAMECUST"].get_Value().ToString();
//Current A/R Invoice Amt
string AMTARINVC = ads.Fields.FieldByName["AMTARINVC"].get_Value().ToString();
//Pending A/R Amt
string AMTARPEND = ads.Fields.FieldByName["AMTARPEND"].get_Value().ToString();
//Pending O/E Amt
string AMTOEPEND = ads.Fields.FieldByName["AMTOEPEND"].get_Value().ToString();
//Pending Other Amt
string AMTXXPEND = ads.Fields.FieldByName["AMTXXPEND"].get_Value().ToString();
//Total Outstanding Amt
string AMTTOTCUST = ads.Fields.FieldByName["AMTTOTCUST"].get_Value().ToString();
//Customer Limit
string AMTLIMITC = ads.Fields.FieldByName["AMTLIMITC"].get_Value().ToString();
//Customer Limit Left
string AMTLEFTC = ads.Fields.FieldByName["AMTLEFTC"].get_Value().ToString();

i = i + 1;
string sMsg = "Item #: " + i.ToString() + " [CUSTID = " + CUSTID +
"] [NameCUST = " + NameCUST + "] [AMTARINVC = " + AMTARINVC +
"] [AMTARPEND = " + AMTARPEND + "] [AMTOEPEND = " + AMTOEPEND +
"] [AMTXXPEND = " + AMTXXPEND + "] [AMTTOTCUST = " + AMTTOTCUST +
"] [AMTLIMITC = " + AMTLIMITC + "] [AMTLEFTC = " + AMTLEFTC;

MessageBox.Show(sMsg);

}
ads.Close();
}

The fetch() works but no other field values are returned.

Thanks.

 

[Jay Converse]

No, it's not feasible, that's not a user-enabled view.

 

[DjangMan]

Try calling .Read or .Process after you've fetched the record.

 

[vbdbcoder]

.Process works. Thanks

ads.Fields.FieldByName["IDCUST"].set_Value("103");
ads.Process();