Dear Allrequired a query for open GRPO at a particular date like belowdocentry     docnum     docstatus openamount     open quantityThanks in advanceDeepak

Dear Allbelow query is working fine but I do want to bit change in existing. If there is more than on item in document then the results are being repetitive in rows.I do want that if there are 2 item or three item in document than there should be 2 o...

HiI am running below query and its duplicating the records. When I remove the t3.quantity from this query its pick the correct records. How I can stop the duplication with t3.quantity.select distinct t0.docnum 'Invoice Doc Num',t0.docdate,t0.cardcode...

Dear AllWe wrote below validation at sales order for credit limit.------------------Declare @BPBalance Decimal(19,2)            Declare @BPCreditLine Decimal(19,2)            Declare @DocTotal Decimal(19,2)            Set @BPBalance = 0.0            ...