You have 2 options:
1) Use the Genie to create the reports as per your client's requests
2) Generate the MP layout, and manually add the report categories (use SUBTOTAL function to add subtotals to the amounts, for the report not to…"
My client is wanting to add in a additional level into his management pack reports by adding in the report writer category above the account number. Is this possible and if so how can i achieve this?See More
Why not create ONE w/book, with all the stores in ONE w/book.
You then put up a menu to each w/sheet (store).
Each w/sheet are password protected, so each (store) can only it's own data.
This makes admin much easier. You can even upload…"
I am running Pastel Evolution with a segmented GL .I have to issues which I am hoping to get some ideas on. Firstly I need to run a P&L each month for every one of these stores automatically. I was thinking of setting up 100 different versions of the report, one for each store but the pain stakeing thing is having to change the date on each reports every month. Secondly is i would like each report only to contain the reelvant accounts that beloong to that store but the management pack seems…See More
"Hi Fred,,, Thank you sooooo much, I found your discussion above very informative and helpful and I've got my head around adding new columns to the layout. I have very limited knowledge of VBA, but find it very interesting, I was wondering…"
"Is there anyway of getting around formatting the Excel file each time.
I have a weekly report that is run each week from a CSV file. The format of the file stays the same each week but needs alot of formating to use for our reports…"
Sage Alchemex runs weekly, topical webinars regarding the Sage Intelligence solution as well as products powered by Sage Alchemex. These webinars are recorded and you will find links to these videos in this group.See More
"This is awesome info, thanks Fred. I understand most of what you've explained, what I am struggling with is changing the -sequence- of the displayed IS. I want to show Cost of Sales (for example) at the bottom of the report and not the top -…"
""For some reason I cannot get this report to appear in Evolution."
you need to ensure "Make Available via SDK" is ticked in your specific reports Advanced section in Report Manager
Not sure why your PLMAINT.exe won't start…"
Hi Guys I have created a customer delivery report through the report manager the report uses a custom view to get the data into the data container. For some reason I cannot get this report to appear in Evolution. I have checkall the repository locations and set up options. The report can be seen by anypc through the report manager . I have called upon the Pastel support guys who have no answers either. I have compactedand backed up the metadata. Any ideas why this wouldn’t work ?I get a…See More