Hello Experts,In financial report templates for cash flow which G/L accounts to be mapped for receipts against invoices from customer and payment against invoices to suppliers.similarly for credit notes paid to customers and credit notes paid by supp...
Hello Experts,I want to display supplier wise sum of openqty and sum of opensum of items in purchase order falling in the respective dates as per the date on line level.so output will be like this.Through query is it possible ?supplier Item ...
Hello Shyam,When u link a UDF to the UDT, you don't have to enter the value.U can select the value from a drop down.After assigning a value from the drop down the code goes into the field. If you want to have name associated to it then you have to fr...
Hello Phil,You can try following query SELECT DISTINCT N'10' + N'10'FROM ORDR WHERE ORDR.CARDCODE = $[$4.1.0]to use it as FMS for qty field.It worked in my test db.Hope it will help you.
Hello Jitin,Thanks for the insightful thread. But, in the financial report template we are trying to map G/L account such that manual selection of line items at the time of payment and receipt can be avoided.Thanks.
