Hi,
static void AlfasithInventDimInventTableRelation(Args _args)
{
InventTable InventTable;
InventDim InventDim;
InventDimCombination InventDimCombination;
PriceDiscTable PriceDiscTable;
while select InventDimId from InventDim where InventDim.InventColorId == " "
&& InventDim.InventStyleId == " "
&& InventDim.configId == " "
&& InventDim.InventSizeId == " "
{
select InventDimCombination where InventDimCombination.InventDimId == InventDim.inventDimId
&& InventDimCombination.ItemId == "1035";
if(InventDimCombination)
{
select PriceDiscTable where PriceDiscTable.ItemCode == 0
&& PriceDiscTable.ItemRelation == "1035" // Item Id
&& PriceDiscTable.InventDimId == InventDimCombination.InventDimId
&& PriceDiscTable.FromDate <= today()
&& PriceDiscTable.ToDate >= today()
&& PriceDiscTable.relation == PriceType::PricePurch // for Purch pirce
//&& PriceDiscTable.relation == PriceType::PriceSales // for Sales pirce
;
print PriceDiscTable.Amount; // when
}
}
}
Regards,
The purpose of this blog is for knowledge sharing and connect the relevant audience who are all into Microsoft Dynamics world.
Alfasith AX

اللَّهُمَّ انْفَعْنِي بِمَا عَلَّمْتَنِي، وَعَلِّمْنِي مَا يَنْفَعُنِي، وَزِدْنِي عِلْمًا
Subscribe to:
Post Comments (Atom)
Get a table ID in SQL - D365
Hi select ID from SysTableIdView where SysTableIdView .Name = 'CustTable' Regards,
-
Hi, AccountingDistribution ( accounting distribution 7452 ) AccountingDistributionEventTmp ( accounting distribution 100001 ) Accountin...
-
//< What is GUID> // GUID 16 bit large range of alphanumeric similar to RecID to treat as primary key of a table. static void CreateG...
No comments:
Post a Comment