Ok @crispin....its solved
[SysEntryPointAttribute]
public void processReport()
{
SalesTable SalesTable;
CustTable CustTable;
CustAccount CustAccount;
SalesId SalesId;
CustCreditMaxMST CreditMax;
AMYcustcontract contract;
contract = this.parmDataContract(); //as AMYcustcontract;
SalesId = contract.paramSalesId();
CustAccount = contract.paramcustaccount();
if(CustAccount!="" && SalesId!="")
{
select SalesTable where SalesTable.SalesId == SalesId
&& SalesTable.CustAccount == CustAccount
join CustTable where CustTable.AccountNum == SalesTable.CustAccount;
{
AMYcust_Temp.CustCreditMaxMST = CustTable.creditmax;
AMYcust_Temp.CustAccount = SalesTable.CustAccount;
AMYcust_Temp.LogisticsDeliveryName = SalesTable.DeliveryName;
AMYcust_Temp.SalesId = SalesTable.SalesId;
AMYcust_Temp.VATNumJournal = SalesTable.VATNum;
AMYcust_Temp.insert();
}
}
else
{
while select SalesTable join CustTable where CustTable.AccountNum == SalesTable.CustAccount
{
AMYcust_Temp.CustCreditMaxMST = CustTable.creditmax;
AMYcust_Temp.CustAccount = SalesTable.CustAccount;
AMYcust_Temp.LogisticsDeliveryName = SalesTable.DeliveryName;
AMYcust_Temp.SalesId = SalesTable.SalesId;
AMYcust_Temp.VATNumJournal = SalesTable.VATNum;
AMYcust_Temp.insert();
}
}
}
this is the code i use
