Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Smart Notification
Measures on a Condition
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Kyle P.
Past 24 Hours:
1
Prev. 24 Hours:
1
Overall:
5177
People Online:
Visitors:
199
Members:
0
Total:
199
Online Now:
New Topics
Lawson S3 Procurement
Adding Std Comments to all PO's
9/17/2024 7:06 PM
Does anyone know of a way to get trailing comments
Lawson S3 Procurement
Missing po info
9/4/2024 3:34 PM
We are experiencing an issue where freight account
Lawson S3 Procurement
We need to charge multiple items to 1 dept no mattter who orders the items. Our POs are out of company 1000 and cost centers are set up in company 1300. Does anyone else have this issue and have a way around it?
8/16/2024 1:55 PM
We have 3 items that need to be charged to the lab
Infor CloudSuite
Dbimport - only importing 1st record of file
8/13/2024 3:51 PM
In FSM Cloudsuite, I've got a file containing
Lawson S3 Procurement
How does everyone charge an item to 1 dept no matter who orders the item?
8/12/2024 6:20 PM
We have 3 items that need to be charged to the lab
IPA/ProcessFlow
WFWORKUNIT table, WF-STATUS field value set
7/25/2024 8:51 PM
documentation I can find has values for this field
Lawson S3 HR/Payroll/Benefits
Benefit change/termination rules
7/23/2024 2:22 PM
Can old benefit change/termination rules be delete
IPA/ProcessFlow
this.bean is null
7/19/2024 5:42 PM
Getting this error when my IPA gets to the second
IPA/ProcessFlow
Converting UTC Date to EST Date using Javascript
7/16/2024 2:53 PM
I'm looking for how others are performing a co
S3 Systems Administration
Changing the orgs email domain
7/12/2024 8:44 PM
Hello! We're changing our email
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3291
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1360
Roger French
1315
mark.cook
1244
Forums
Filtered Topics
Unanswered
Unresolved
Announcements
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Performance Management
Smart Notification
Measures on a Condition
Please
login
to post a reply.
12 Replies
2
Subscribed to this topic
72 Subscribed to this forum
Sort:
Oldest First
Most Recent First
Author
Messages
Ellen Bats
Advanced Member
Posts: 21
12/1/2011 10:15 AM
I have build an Infoset for the orderlines. After that I what a Smart Note with the detail information. However the detail information is a condition. In the Smart Note I have also a counting for the total amount by facility. When I look at the result of the Smart Note I saw that the detail information is correct. But when I verify the total amount by facility the result is not correct. The result of the measure is based on the INFOSET and not on the CONDITION.
How get I the right results of the total amount that is based on the CONDITION ?
Ellen Bats
Advanced Member
Posts: 21
9/17/2012 11:02 AM
Does anybody knows how to resolve this.
Matthew Nye
Veteran Member
Posts: 514
9/17/2012 11:27 AM
can you provide some screen prints? Specifically of your KEYS in the infoset and the selection of your multifacts and lastly of your conditions.
most likely this is just an issue of either incorrect setting of KEYS or selecting a multifact that returns duplicate lines. either of these would result in inaccurate counts.
Ellen Bats
Advanced Member
Posts: 21
9/17/2012 12:16 PM
Please look at the attachment. The samples are in dutch but i have added some comment in english
Attachments
SmartNote_Example.xlsx
Matthew Nye
Veteran Member
Posts: 514
9/17/2012 12:28 PM
Sample_Smart_Note_with_wrong_total_counts_and_amou was attached as an aspx page. any chance you can upload a word doc? I think the issue is going to hinge on the InfoSet definition and the multifact select. the display of the tables wont help too much.
Ellen Bats
Advanced Member
Posts: 21
9/18/2012 6:48 AM
I have zip the word document to a zip-file.
Attachments
Sample_Smart_Note_.zip
Matthew Nye
Veteran Member
Posts: 514
9/18/2012 7:17 AM
I would start by changing your filters on the infoset. Right now you have it set to No Filters. I would take either Unique Row or Unique Key. Let me know if that fixes it.
Matthew Nye
Veteran Member
Posts: 514
9/18/2012 7:21 AM
one more question, which count is correct, 152 or 148?
Ellen Bats
Advanced Member
Posts: 21
9/18/2012 7:45 AM
I have changed the settings to Unique Row or Unique Key but the result is still the same. The total count/amount is wrong.
The count 148 is correct.
Matthew Nye
Veteran Member
Posts: 514
9/18/2012 8:09 AM
this one is pretty complex to troubleshoot with screen shots. i still think its related to your selection of items/keys in your multifact. it could be that your conditional range is including 80 and 76 Laagste status when you expect it to be excluded?
if you can identify the 4 extra lines that are being included this should give you a better idea of where the issue is. Instead of doing a could, display it as a table and compare to the excel spreadsheet.
Ellen Bats
Advanced Member
Posts: 21
9/19/2012 3:07 AM
Oke I shall try to analyse the detail information with the total values.
Ellen Bats
Advanced Member
Posts: 21
9/19/2012 10:14 AM
I have analyse the detail information with the figures of the total of the measures and it look likes that the total of measures contains all records and not the records which I have excluded with my condition.
I have build a new Smart Note and I have in my InfoSet added a new field so that I can combine the two selections, selection on the status of the orderheader and selection on the invoicedate. There is now one condition in the Smart Note. This condition is the basis for the Smart Note. When I added a Multi-Fact for only the total amount and the total count of the records the figures are based on the original Multi Fact.
I have tried several things but I everythings what I try I get not the right figures. The figures are based on the original multifacts and not on the Condition.
Ellen Bats
Advanced Member
Posts: 21
10/1/2012 5:51 AM
We get answer from Lawson Support :
My name is Mike and I have been reviewing your case. The totals are for the full amount of the columns that are selected. There is not an option in SN to give the total of just certian conditions that you trying to meet. This does seem liek something that would be helpful and you may want to submit a enhancement request on My Lawson regarding this rerquest.
It is not possible
Please
login
to post a reply.