Hi,
I need to design a report whereby I can list all customers from multiple datasources/companies.
Regards,
LH
Date
Votes
3 comments
-
Jet Reports Historic Posts Hi LH,
Depending on how you want the report structured, this could be done multiple different ways. There are NP(Companies) and an NP(DataSources) functions which you can put inside an NL(Rows) or NL(Columns) to list out data sources or companies. Then in the NL function you can use DataSource= or Company= to refer to set the data source and company for that particular function.
If you want a combined list of customers (rather than having them split out by data source and company) it gets a little more tricky. In this case you have to use NP(Union) in combination with NL(Filter) to combine multiple lists of customer numbers. Does that help?
Regards,
Hughes -
Sandeep Kuntam Hi Hughes,
How would use a GL function to get a sum of balance from different companies? like if there are 3 companies A, B and C and I need the consolidated balance of all 3 companies for an account, how would i include this NP function in the GL function?
-
Harry Lewis Hello Sandeep -
With Microsoft Dynamics NAV and GP, queries which return a summed amount can be set to return a combined value from multiple companies. This includes the NL(Sum) function and GL functions which return balance, budget, credit or debit amounts.
To set an NL(Sum) function to return data from multiple companies, use the Company= keyword and specify your companies.
In the GL functions, specify multiple companies in the Company filter.
Operators such as “*”, “|” and “..” can be used in this way with either the GL or NL(“Sum”) function.
Note – when multiple companies are selected in a query the drilldown feature is deactivated for that query.
Please sign in to leave a comment.