Hello can any one help me out
I have a sales orde...
# suitescripta
Arham Momin
03/28/2023, 12:33 PMHello can any one help me out
I have a sales order with 128 line items and i want to calculate commission on each line item ,when i loop through each line it loop only till 98 lines and stops
I tried to loop in descending order from 128 to 0 again it stops on 30 that means from 128 till 20
it only processing not 97 lines
can any one help me out how to process all 128 lines
b
battk
03/28/2023, 12:50 PMyou may want to check your logs for errors
battk
03/28/2023, 12:51 PMinefficient scripts can run out of governance points on many line items
a
Arham Momin
03/28/2023, 1:50 PMOk sir thanks for help let me check
Arham Momin
03/28/2023, 2:08 PM Copy code
Script Execution Usage Limit Exceededb
battk
03/28/2023, 2:16 PMSuiteScript Governance and Limits is where you want to start
battk
03/28/2023, 2:16 PMyour script is using too many points and you will have to make it more efficient
a
Arham Momin
03/28/2023, 4:45 PMOk sir thanks i ll definitely look into it
e
ec
03/28/2023, 9:10 PMif you describe exactly what you need done and perhaps when it needs to be done (or in what context) we can help design that
a
Arham Momin
03/31/2023, 8:49 AMI have a So of more then 120 lines ok
There is a column call commission
I have to calculate commission on amount and set on commission column
but it only calculate till 97 lines and throw error of usage limit exceeds (means governance unit exceeds)
because in map reduce Map stage has only 1000 governance unit)
b
battk
03/31/2023, 10:42 AMyou will likely need to share the code if you wish to receive specific advice about how you can reduce your points usage
a
Arham Momin
03/31/2023, 11:12 AMsure sure
Arham Momin
03/31/2023, 11:16 AMmr_calculate_commission.js
b
battk
03/31/2023, 11:18 AMprimary offender on points is how you use getAccount
battk
03/31/2023, 11:18 AMyou pass it one item at a time and it does one search per item
battk
03/31/2023, 11:18 AMdo better, pass it an array of all the items and do a search for all of them
battk
03/31/2023, 11:23 AMthere are variations of doing this better, like using N/cache to just search all of your items once to share with each map
a
Arham Momin
04/02/2023, 9:17 AMOk ok sure sir i try to apply this