Ghulaam's Groups
-
VIP PAYROLL Business Int…
21 members
-
Report Designer
99 members
-
Pastel Evolution Busines…
83 members
-
Pastel Auditor
20 members
Ghulaam's Discussions
Re: Conversion of reports from Pervasive Sql to Ms Sql
2 Replies
Hi My client is upgrading from Accpac pervasive to Msql. I have not looked at permutations but would appreciate any inputs if there is anything specific one should keep in mind i.e. 1) Custormised…Continue
Started this discussion. Last reply by Ghulaam Sep 22, 2011.
Audit trail report
Hi I need to extract the data as shown in the audit trail report in Partner i.e. GL >> Transactions >> audit trail. Apart from being able to print to one note any suggestions how to…Continue
Started Aug 11, 2010
Pastel Partner Invoice
2 Replies
I need to to create a invoice with information going across as opposed to row by row.As there is very little additional required I need help with:Which container will I use to extract the standard…Continue
Tags: Invoice
Started this discussion. Last reply by Ghulaam Jun 18, 2010.
Segmenting Pastel Partner General Ledger Accounts
2 Replies
Hi All, Pastel Partner currently has 7 characters i.e. 4 characters for main account and 3 for sub account.If I split the main account into 4 separate segments using excel functionality on the…Continue
Started this discussion. Last reply by Ghulaam Jun 17, 2010.
Ghulaam's Page
Latest Activity
Ghulaam replied to Elmi Thietz's discussion BIC Management reports"Hi Elmi
I am based in Cape Town and have written some reports specific to company formats. You can mail me saberonline@telkomsa.net and we can take it from there.
Regards "
Ghulaam replied to Ghulaam's discussion Re: Conversion of reports from Pervasive Sql to Ms Sql"Hi
Thank you for the info and will shout if additional help required.
Regards
Ghulaam
"
Stephen Coull replied to Ghulaam's discussion Re: Conversion of reports from Pervasive Sql to Ms Sql"Ghulaam,
Should you have customized only the Excel portion of the standard reports that ship with Accpac Intelligence, you could create and link your run out report onto the newly imported MS-SQL reports.
Regarding customized reports,…"
Ghulaam posted a discussionRe: Conversion of reports from Pervasive Sql to Ms Sql
Hi My client is upgrading from Accpac pervasive to Msql. I have not looked at permutations but would appreciate any inputs if there is anything specific one should keep in mind i.e. 1) Custormised reports written 2) Impact of db change on the existing reports 3) Client is using the generic Alchemex product Regards GhulaamSee More
Ghulaam replied to Shwu Hua Gan's discussion @Date@ system variable"Question: To modify the above requirement
At run time I would like to save a copy of report to a separate location as per the advanced features.
I would like to also create separate folders for different months and would like as…"
Ghulaam replied to Robbie's discussion Difference between the Excel Genie and Report Designer?"Hi Ruth
Thank you for the inputs, so just to be on the same page:
- Clients with standard Pastel BIC will have report manager.
Quest: I assume it will include the standard management pack plus the standard sales, inventory, purchases and sales…"
Ghulaam replied to Robbie's discussion Difference between the Excel Genie and Report Designer?"Just some further clarification:
- So Excel Genie will replace Report writer from version 11 of Pastel?
- Clients who have not updated to Version 11, will they have to acquire it as an add-on or does it work in as per resolve?
- Lastly clients who…"
Ghulaam posted a discussionAudit trail report
Hi I need to extract the data as shown in the audit trail report in Partner i.e. GL >> Transactions >> audit trail. Apart from being able to print to one note any suggestions how to extract as a BIC report.Looking at other permutations as well but I feel the easiest will be to extract as a reportThanksSee More
Ghulaam replied to Ghulaam's discussion Pastel Partner Invoice"thanks will attempt and respond accordingly"
Fred replied to Ghulaam's discussion Pastel Partner Invoice"I would use History Header & History Lines.
The join would be something like this
"HistoryHeader"
LEFT JOIN "HistoryLines"
ON "HistoryHeader"."DocumentNumber" =…"
Ghulaam posted a discussionPastel Invoice
I need to to create a invoice with information going across as opposed to row by row.As there is very little additional required I need help with:Which container will I use to extract the standard partner invoice data to sheet 1.ThanksSee More
Ghulaam replied to Ghulaam's discussion Segmenting Pastel Partner General Ledger Accounts"THANKS FRED"
Profile Information
- Alchemex Powers the Following BI Solution, Pick Yours
- Pastel BIC
- How long have you been using the above solution?
- 4 years
- Where did you hear about us?
- Invitation
Follow Alchemex on twitter
Like Alchemex on facebook
© 2012 Created by Admin.
