Hi experts,
is there any options (SDK;IF) where we can schedule running of Inventory Audit Report without manual action.
Idea is to run task every night, so it could update the 'Last Evaluated Price' pricelist.
The pricelist is used in Sales Re...
Hi,
I've created some custom excel and IA report based on semantic layer views as described in manual
'How to Work with Excel Report and Interactive Analysis' chapter 6.2.1. You can see the attachment.
Is there any way to copy custom reports to...
Hi,
I am working on extending system ProfitabilityAnalysis IA report.
First step was copy of SalesAnalysisFact View. When deploying model I am getting error.
System cannot deploy system views inside of SalesAnalysisFact, like 'ARCreditMemoDetai...
Hi,
i'm trying to calculate Unit Price by WHS UoM by dividing Unit Price/Items per Unit on Sales Order.
I'm using next query:
SELECT REPLACE(REPLACE(SUBSTRING($[$38.14.0],5,30),'.',''),',','.') /REPLACE(REPLACE($[$38.213.0],'.',''),',','.') FR...
SOLVEDProblem was in Unit Price.FMS triggers on opening document when UnitPrice is '' so its dividing '' with 0.Next query solved the problemSELECT CASE WHEN "Price"<>'' THEN "Price"/"Qty" ELSE NULL END FROM (
SELECT REPLACE(REPLACE(SUBSTRING($[$38.1...