Hello,
I was tasked with creating a DSO inquiry for us to use. After building one myself (see XML attached) I found one our VAR created (also attached). Here’s where i came across a few issues.
Mine is built off of invoices and memos from the ARInvoice module. To get this to line up the same as how the VAR lined up theirs I had to group and SUM all of my invoices. All numbers line up except for 04-2026 invoices. I assume those will match up once we close out the period since all past period match exactly. (i verified these numbers by going to the AR module and filtering by only Invoices or credit memos and matching total at bottom of page)
None of then numbers on the one that the VAR created match the one I created nor do they match what the AR module says when i filter down the types. Their DSO equation also seems to be broken beyond my knowledge to repair. That or it’s missing something or seeing a zero i don’t in order to pull in a NULL value.
I’d like to get some more smarter eyes on this. would the one the VAR created be better than the one I created? My biggest issue with my creation is getting FinPeriod # of days on there since i have to group and add all of the invoices. If i could get the VAR’s page to match up to my numbers and get their equation working might be faster and easier than me finding a way to connect ARInvoice to some sort of FinPeriod module and deal with the grouping / SUM garbage i had to pile together.
Advice?