Margin on a sales order in SAP Business one

Respondida

Chris Pilbeam

• 11 de marzo de 2016 11:17

I've created a line loop on a sales order to calculate the margin for each line and if below 15 to pop up a message, We are having the message pop up for some lines even when above 15 but it works for most lines:-

code:-

IF (($[$38.21.NUMBER]-$[$38.10002049.NUMBER])/$[$38.21.NUMBER]*100) <'15' AND $[$38.21.NUMBER] >'0'
BEGIN
SELECT 'BELOW_15' FOR BROWSE
END

boyum is picking the above up as IF ((116-88)/116*100) <'15' AND 116 >'0'

sap fields are

 (T1.[LineTotal] - T1.[GPTtlBasPr])/T1.[LineTotal]*100

can anyone tell me what im doing wrong.

Vote

0

• Comentario oficial

  

  Naama Aharoni

  • 15 de marzo de 2016 14:38

  Hi Chris,

  I suggest you open a ticket to support with a screenshot of the line-loop and the UF attached.

  Thanks, Naama
• 

  Maurice

  • 10 de junio de 2016 08:28

  

  Hi Chris

  I have a similar line loop running on quotations. The problem you have is that despite SAP showing a value in field 38.21.NUMBER the query always returns 0. I use the single price to calculate the margin on qty 1 which works fine

  IF (($[$38.17.NUMBER]-$[$38.37.NUMBER])/$[$38.17.NUMBER]*100) < 10 AND $[$38.17.NUMBER] <> 0.0000 and ($[$38.14.NUMBER]-$[$38.37.NUMBER]) <> 0 and $[$38.3.0] not like '%Carriage%'
  BEGIN
  SELECT 'BELOW_10' FOR BROWSE
  END

   

  Maurice

Iniciar sesión para dejar un comentario.