February 2024

Hi.When I use MMCL to 002 to change equipment characteristics. It’s ok. However, when I make for batch 023. I have the message: no value. Regards.

Hi all, I have a program that is using part of the selection screen from the logical database PNP.  I also have my own selection screen criteria as well.  Is there any way that my section of the selection screen show first on the screen and the LDB selection options show second? Thanks in advance.Kevin

Hello Frnz,   I am trying to modify a webi report and adding a @prompt condition to it, but its throwing invalid relational operator error. Any suggestions please. Adding the query below i am using. Report is a custom SQL report. case when ‘ALL’ in @prompt(‘BT:’,’A’,,Multi,Free,Not_Persistent,{‘ALL’,’B’,’D’},User:0) then 1when ‘B’ in @prompt(‘BT:’,’A’,,Multi,Free,Not_Persistent,{‘ALL’,’B’,’D’},User:0) thenCase when trim(table.col1)) not …

Case statement in webi report throwing error Read More »

Hello i will try to explain my doubt, im looking for the source of the corect syntax in both places but they work diferent, example in query manager i can make a formated serch but the syntax is diferent in the other area where i make post transaction notifiction so the sql functions and syntax …

syntax query Read More »

Hi everyone, my company uses SAP B1 without much development. We are currently manually reconciling every single payment across our accounts everyday which takes us a minimum of 2 hours at a time. We have to manually reconcile an invoice with the journal payment for our orders. Is there a way we can limit the …

Manual Reconciliation help for multiple BP Read More »