Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
I am developing a report GRN not invoiced but i dont know how to pick service item that not been invoiced.
As there is no inventory transaction for service item you can use Purchase line status.
Purchline status will tell you whether it is invoiced or not and check the product type which should be service.
You can check the below query which gives you all open or received purchase order lines of service items
while select PurchId, ItemId, PurchStatus from purchline
where purchline.PurchStatus <= PurchStatus::Received
&& purchline.IsDeleted == NoYes::No
join ItemId from inventTable
where inventTable.ItemId == purchline.ItemId
join RecId from EcoResProduct
where EcoResProduct.RecId == inventTable.Product
&& EcoResProduct.ProductType == EcoResProductType::Service
info(strFmt("Purchase order: %1 Item Id: %2", purchline.PurchId , inventTable.ItemId));
Business Applications communities