Active Contributor
Member since ‎02-10-2009

User Statistics

  • 1,166 Posts
  • 104 Solutions
  • 0 Kudos given
  • 48 Kudos received

User Activity

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 distinct t0.docnum 'Invoice Doc Num',t0.docdate,t0.cardcode...
Dear Allbelow query is working fine if I run the query for A/P Invoice and Credit Memo but when running the same with Outgoing payment its giving error (Msg 8114, Level 16, State 5, Line 9Error converting data type varchar to numeric.) but if do exec...
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            ...