Frequent use Script Events
Go to top
|
Resources For AutoCount Software Developers
|
Introduction
Understand the usage of 5 Frequent use script events
What is MasterColumn and DetailColumn?
All document entry, whether it is Sales Invoice or AR Payment, they consist of at least 2 DataTable, master table and detail table.
Usually the master table is where it stores the document information, such as document number, document date, company name and etc... Whereas, the detail table stores multiple records that are related to this document. Such as Items and account double entry transactions.
MasterColumn is referring to the value of a field in master table. Likewise, DetailColumn is referring to the value of a field in detail table.
Frequent Use Events
Go to top
|
Resources For AutoCount Software Developers
|
OnMasterColumnChanged
OnMasterColumnChanged is triggered when user changes the value on master area of entry form, except detail area.
OnMasterColumnChanged event in Sales Invoice
public void OnMasterColumnChanged(BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceMasterColumnChangedEventArgs e)
Example
- Prompt message box to display Price Category of selected customer, when DebtorCode is changed.
public void OnMasterColumnChanged(BCE.AutoCount.Invoicing.Sales.Invoice.InvoiceMasterColumnChangedEventArgs e)
{
if (e.ChangedColumnName == "DebtorCode")
{
DebtorRecord debtor = CommonRecordUtils.GetDebtor(
e.DBSetting, e.MasterRecord.DebtorCode);
if (debtor == null)
{
return;
}
else
{
BCE.Application.AppMessage.ShowMessage(
string.Format("{0}\n{1}\nPrice Category: {2}",
debtor.AccNo, debtor.CompanyName, debtor.PriceCategory));
}
}
}
It is important to control only execute the statements when the changed is "DebtorCode".