I have used the follwing code.
/* main
[
SysEntryPointAttribute(false)
]
public void processReport()
{
SintoPInventAdjustcontract Contract;
Contract = this.parmDataContract() as SintoPInventAdjustcontract;
voucher=Contract.Parmvoucher();
// mainAccountNum=Contract.ParmMainAccountNum();
if(voucher!="")
{
while select * from inventSettlement
join inventTransOrigin
order by inventSettlement.ItemId
where inventSettlement.Voucher == voucher
// && inventSettlement.OperationsLedgerDimension==dimensionAttributeValueCombination.RecId
&& inventTransOrigin.InventTransId == inventSettlement.InventTransId
{
this.insert(InventSettlement);
}
}
/*insert
private void Insert(InventSettlement ObjInventSettlement)
{
select * from dimensionAttributeValueSetItem
join dimensionattribute
join DimensionAttributeValue
join dimensionAttributeValueCombination
join MainAccount
where dimensionattribute.RecId == DimensionAttributeValue.DimensionAttribute &&
DimensionAttributeValue.RecId == dimensionAttributeValueSetItem.DimensionAttributeValue &&
dimensionAttributeValueSetItem.DimensionAttributeValueSet == ObjInventSettlement.DefaultDimension &&
dimensionAttributeValueCombination.RecId == ObjInventSettlement.OperationsLedgerDimension
&& dimensionattribute.Name == "Project";
{
// if(dimensionattribute.Name == "Project")
{
// select * from ProjTable
//where ProjTable.ProjId == dimensionAttributeValueSetItem.DisplayValue;
sintoinventsumtmp.Project = dimensionAttributeValueSetItem.DisplayValue;
//sintoinventsumtmp.LedgerAccount =ObjInventSettlement.OperationsLedgerDimension;
}
}
// select * from inventTransOrigin
// join ObjInventSettlement
// where inventTransOrigin.InventTransId ==ObjInventSettlement.InventTransId;
sintoinventsumtmp.VoucherNo=ObjInventSettlement.Voucher;
sintoinventsumtmp.Date=ObjInventSettlement.TransDate;
// sintoPInventoryTmp.ItemId=ledgerjournaltran
sintoinventsumtmp.BasicValueAmount=ObjInventSettlement.CostAmountAdjustment;
sintoinventsumtmp.ItemId=ObjInventSettlement.ItemId;
sintoinventsumtmp.ReferenceId=inventTransOrigin.ReferenceId;
//sintoinventsumtmp.LedgerAccount =
sintoinventsumtmp.LedgerAccount=generalJournalAccountEntry.LedgerAccount;
// sintoPInventoryTmp.ItemId=inventSettlement.ItemId;
sintoinventsumtmp.Insert();
}
