Frequent use Script Events: Difference between revisions
Content added Content deleted
No edit summary |
|||
| Line 1: | Line 1: | ||
{{NavigateDeveloper|collapsed}} |
{{NavigateDeveloper|collapsed}} |
||
==Introduction== |
|||
Understand the usage of 5 Frequent use script events |
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.<br /> |
|||
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.<br /> |
|||
'''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. |
|||
<br /> |
|||
[[File:InvoiceFormWithDetailHighlight.png|none|frame|600px |
|||
|'''Invoice Entry Form'''<br /> |
|||
This screen shows there are two highlighted areas in '''<span style="color:green">Green</span>''' and '''<span style="color:red">Red</span>''',<br /> |
|||
which are master and detail area respectively.<br /> |
|||
]] |
|||
==Frequent Use Events== |
==Frequent Use Events== |
||
Revision as of 09:58, 1 November 2017
|
Go to top
|
|
Resources For AutoCount Software Developers
|
Understand the usage of 5 Frequent use script events
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".