Margin on a sales order in SAP Business one Answered

Chris Pilbeam

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.

Comments

2 comments

Date Votes
  • Comment author
    Naama Aharoni
    • Official comment

    Hi Chris,

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

    Thanks, Naama

  • Comment author
    Maurice

    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

    0

Please sign in to leave a comment.