i want check amount from outgoing payment means to checks for payment i need a FMS query please help

i have 2 condtions in my query if my line item from po (container no) having a grpo so it should display 'shipment received' if no grpo so it should display 'no shipment received' need your expertie here please. SELECT OPOR.DocNum , POR1.U_Cont...

i have this query please check i want total ap reserve invoice count in report and i have this query i am facing issue with joins please check select OPOR.CardCode, OPOR.CardName, OPOR.U_ReferenceNo, OPOR.NumAtCard, OPOR.DocNum, count(OPCH.DocNum)...

Dear Expert, I have created a formatted search to copy order date from production order to issue for productions, when I execute the formatted search, an error message " Internal error (-1004) occurred [Message 131-183] " popped up. SELECT ...