I have information on a number of accounts and their contracts in Secure which I can’t find back in Exact Online in PowerBI. This is because these customers fall under a so-called reseller; this field is indeed available in the PowerBI Exact Online data, but these fields are empty. Is it possible to retrieve this?
We’re having trouble understanding your question.
Could you make it more concrete, such as what “Secure” refers to, how contracts are defined, as well as which field it’s exactly about (via a full screenshot, anonymised where necessary)?
Secure is the invoicing program my company uses. It contains all customers with their accounts as follows:
[Removed due to sensitive data]
The Account.nu field is unique for each customer and contains a symbolic representation of the customer. This data is imported into Exact Online and used to check the turnover for each customer. Now, in the link between Exact Online and PowerBI, I’m looking for this field so that I can connect the two systems to create a dashboard, but I can’t find this Account.nu anywhere in Exact Online.
Is it possible to show the field “account.nu” from Secure in Exact Online, via a sufficiently large (anonymised) screenshot from Exact Online?
This is going to be difficult to anonymise, but it’s about customers that fall under ‘resellers’. There is a field for this in the link between Exact Online and PowerBI, but it’s empty because the reseller isn’t broken down into the individual customers that fall under that reseller, which makes it tricky. So what I’d like to know is whether this is possible.
Based on this information, it is not possible to determine what is being sought.
The advice is to carefully rephrase or clarify the question so that it is clear to a reader outside your organisation what is being sought.
This question was automatically closed after 1 week of inactivity. The last answer given has been marked as the solution.
Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question by pasting its URL into the text.