BIC Solutions Ltd
  • Quatre Bornes
  • Mauritius
Online Now
Share on Facebook
Share Twitter

BIC Solutions Ltd's Friends

  • Stephen Coull
  • Brynn Furmidge
  • Bron Dorrofield

BIC Solutions Ltd's Groups

BIC Solutions Ltd's Discussions

Filter by Reconciled transactions in Report

Hi All,I am doing a Report in BIC based on the table "_bvGLTransactionsFull" and I would like to have only Reconciled transactions in the report.can anyone help me which filtering should be used and…Continue

Started 4 hours ago

Excel File saved in Text Format(Tab Delimited)
6 Replies

Hi All,I would like to save an excel sheet in Text Format (Tab Delimited) without using the File...Save As.Can anyone help me with the macro to insert to save the excel file?ThanksBenazeerContinue

Started this discussion. Last reply by BIC Solutions Ltd Mar 7.

Setting SMTP Server In Sage Pastel Payroll BIC
1 Reply

Hi All,I am using Sage Pastel Payroll BIC and i am having the following issue on emailing report. I am getting the following error message when running the report which was setup for emailing using…Continue

Started this discussion. Last reply by BIC Solutions Ltd Mar 29.

 

BIC Solutions Ltd's Page

Latest Activity

BIC Solutions Ltd posted a discussion

Filter by Reconciled transactions in Report

Hi All,I am doing a Report in BIC based on the table "_bvGLTransactionsFull" and I would like to have only Reconciled transactions in the report.can anyone help me which filtering should be used and what values for filtering should i input.ThanksBenazeerSee More
4 hours ago
0 Comments
BIC Solutions Ltd replied to BIC Solutions Ltd's discussion Setting SMTP Server In Sage Pastel Payroll BIC
"Hi All, I have posted an issue since 23 February 2012. 25 People had viewed this post and I have not got one single answer to my query. Please find the Print Screen of the issue below: I am asking myself if this Add-ins in BIC actually…"
Mar 29
BIC Solutions Ltd replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"Thank you very much. The Excel file is saved as text file including date as per my requirement. Thanks Benazeer"
Mar 7
Brynn Furmidge replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"yourdate = Format(RunDate, "yyyymmdd") should be yourdate = Format(ReportRunDate, "yyyymmdd")"
Mar 7
BIC Solutions Ltd replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"Hi Brynn Thank you for the above Macro. The thing is that the file generated does not take today's date, for e.g. the file name should be "Test07032012.txt". Also, is it possible for the macro not to prompt for the folder, instead to…"
Mar 7
Brynn Furmidge replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"Hi Benazeer You can use the following in your macro: ' get the date the report was run onReportRunDate = Range("Sheet2!D2")      ' Alchemex populates the report run time and date here' formats the…"
Mar 7
BIC Solutions Ltd replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"Thank you Brynn. It worked and the report is in text format. Moreover, the report is scheduled daily, so for the file name can you tell me how to put it a macro to take the date it is running. Thanks Benazeer"
Mar 6
Brynn Furmidge replied to BIC Solutions Ltd's discussion Excel File saved in Text Format(Tab Delimited)
"You can use the following in your macro: ActiveWorkbook.SaveAs Filename:=myFile, FileFormat:=xlText, CreateBackup:=False where myFile is the file path and name."
Mar 6
BIC Solutions Ltd posted a discussion

Excel File saved in Text Format(Tab Delimited)

Hi All,I would like to save an excel sheet in Text Format (Tab Delimited) without using the File...Save As.Can anyone help me with the macro to insert to save the excel file?ThanksBenazeerSee More
Mar 6
6 Comments
BIC Solutions Ltd posted a discussion

Setting SMTP Server In Sage Pastel Payroll BIC

Hi All,I am using Sage Pastel Payroll BIC and i am having the following issue on emailing report. I am getting the following error message when running the report which was setup for emailing using Add-ins.In the SMTP Server, I have put: smtp.gmail.com but its not working. I also tried other smtp mail but getting the following error message."An Error occurred while attempting to run the macro [PLPLUGA.E.MailSMTP(smtp.gmail.com,support@bicsolutionsltd.com,subject Here)]. The Error was [The…See More
Feb 23
1 Comment
BIC Solutions Ltd joined Bron Dorrofield's group
Thumbnail

Excel on Steroids

Feb 14
12 Comments
BIC Solutions Ltd joined Admin's group
Thumbnail

Free Report Templates Group

To get your Free Report Templates, be sure to join this Group in the BI Community.If you have Free Report Templates feel free to share them here.See More
Feb 14
0 Comments
BIC Solutions Ltd joined Ruth Gray's group
Thumbnail

Pastel Evolution Business Intelligence Centre (BIC)

Feb 14
3 Comments
BIC Solutions Ltd joined Ruth Gray's group
Thumbnail

Report Designer

Feb 14
10 Comments
BIC Solutions Ltd joined Admin's group
Thumbnail

The BI Community Notice Board

Because every real community has a notice board, we have created one for you. Welcome to The BI Community Notice Board.  Please not there are strict anti-spamming rules.See More
Feb 14
BIC Solutions Ltd updated their profile
Nov 22, 2011

Profile Information

Alchemex Powers the Following BI Solution, Pick Yours
Pastel BIC, Pastel Payroll BIC, Excel On Steroids
Website
http://www.bicsolutionsltd.com
About Me:
B.I.C Solutions Ltd,
Authorized reseller of Sage PASTEL products in Mauritius, is a private company that provides a superior IT and consulting service. Being a Silver Business Partner of Sage PASTEL, we concentrate on your business and recommend the perfect selection that suits your needs with respect to Accounting, Enterprise Resource Planning (ERP) and Business Software solutions while serving both domestic and International sectors. We also act as a consultancy service thereby providing solutions to assist the management and expansion of your business.
Our foremost goal is to exceed the expectations of every client by offering an undeniably outstanding customer service and support, increased flexibility, and greater value, thus optimizing system functionality and improving operation efficiency. Our company is distinguished by its functional and technical expertise combined with their hands-on-experience, thereby ensuring that our clients receive the most effective and professional service.
B.I.C Solutions Ltd possesses a wide range of knowledge that allows you to manage all aspects of your business, from simple customer invoices, payments and statements to more complex integrated ERP software solutions, management tool providing complete functionality and add-on modules.
As expert in Sage PASTEL software, B.I.C Solutions Ltd, attend the client’s needs at each and every stage form implementation to completion offering functional and technical support. Our extensive skills encompass all aspects of implementation and operation to fit specific client needs. Typically, we are on-site at the client’s locations, providing functional training and support on Sage PASTEL products.
We pride ourselves on our proven track record for effectively administering multiple implementations. This is the result of effectively directing team members to ensure that all business requirements are being met within budget restraints and time schedules. In addition, B.I.C Solutions Ltd has an experience with large companies, having been responsible for the successful implementations.
At B.I.C Solutions Ltd, we are continually expanding upon our knowledge and services to assist clients with successfully implementation of Systems in different domain.
B.I.C Solutions Ltd
Corner Ave Des Tulipes & Trianon No.1, Quatre Bornes, Mauritius
Tel: (230) 465 5373, 465 8011, 466 6099
Fax: (230) 465 5620
Email: info@bicsolutionsltd.com
How long have you been using the above solution?
More than 6 months
Where did you hear about us?
Alchemex Site

Comment Wall

You need to be a member of The BI Community - Powered by Alchemex to add comments!

Join The BI Community - Powered by Alchemex

  • No comments yet!
 
 
 

Follow Alchemex on twitter

Like Alchemex on facebook

This Weeks Top Content 

1 Problem - Grouping by Custom Account Groups

Problem - Grouping by Custom Account Groups
2 Picklist for Accpac SQL databases

Picklist for Accpac SQL databases
3 Possible to Rename DB name in Pervasive SQL DB Name Manager?

Possible to Rename DB name in Pervasive SQL DB Name Manager?
4 ODBC Driver selection when entering data connection details

ODBC Driver selection when entering data connection details
5 Combining Accounts in SMI financials

Combining Accounts in SMI financials

Alchemex Integrates with:


© 2012   Created by Admin.

Badges  |  Report an Issue  |  Terms of Service

Sign in to chat!