This below mentioned Query needs a Doctype parameter I was able to set DATE And Status but couldn't set Doctype as parameter, Kindly checkout and if yes kindly share the knowledge.   --/*SELECT FROM [dbo].[OINV] T0 INNER JOIN OUSR T1 ON T1.[USERID] =...

Hi All, I need to block posting A/R invoice for the open GRPO (Purchased Items) without landed cost for the Document Quantity alone, this sp should not affect the prior instock items when added in A/R Invoice.

Hi All, Hope all are doing Great I have an doubt that can we create a Block in the pick list, i.e if the Account balance is more than the Credit limit for a customer, it should not allow the user to release the open documents in the Pick List. Is...

How can i join ORCT header table and its History table ARCT

Hi all I am trying to write a parameter to get the Sales Order data for the customer where the Business Properties are selected 'Yes'. Is it possible?