Hi Experts, I need to validate the production order through SP. Partial issue and and receipt qty alone system needs to accept. The below query executing no error but not validating. IF (:object_type = '202' AND (:transaction_type in ('A','U'))...

Hi Experts, I Need a validation query to block outgoing payment- if bank charges is given in OP then UDF(Bank)) field is mandatory. Thanks Ram

Hi All, My customer has bp code automatically generating next no. but suddenly not working SELECT CASE N'C' WHEN 'C' THEN 'C' WHEN 'S' THEN 'S' WHEN 'L' THEN 'L' END + (SELECT RIGHT('0000000' + LTRIM(RTRIM(CAST((SELECT MAX(Right(...

Hi, How to find the canceled journal entry is there any field in OJDT and JDT1 tables which specifies the journal entry have been canceled. select sum(debit) as debit,sum(Credit) as credit from JDT1 t0 inner join OJDT t1 on t0.transid=t1.transid ...

Hi Experts, In SAP b1 I want to create a new company with existing company data(COA,Item master, BP master data needs to load). How to achieve this in copy data between companies. Thanks Vinoth