turbocash 4

[Ettienne Du Plessis]

hi guys

 

I have managed to compile Peter's code.

Phillip have you managed to get the latest code.

 

The problems I had

   I am using Indy 10 and there was some issues(over came all of them)

   I am using fast report professional had to comment out some code because of free report.

   I had to disable the barcode print for quick report couldn't compile it at all.

   fedittext  on the twwgrid 

  SendEmailReport unit has a TCEmail had to comment it out

  NetSetUp unit had to comment out ftpcli

 

My suggestions in order - short term

  1. Start using the Indy components for ftp and mail. This will get rid of extra components we have to install

  2. Write out the Freereport and use report writer.The units that use it are DEBTOR,BatchEntry,BatchEntryBank,OpenLink,InvoiceEntryGrid,PosEntry,Main,

      Freereportsunit,PrintDocuments. We should standardise on one report writer. I have worked with reportman and it will satisfy all our needs.

  3. Move the barcode printing to reportman.  

  4. Change all our ftp and email components to Indy. This will give us less components to install 

  5. VCLZIp to be replaced with abbrevia

  6. Create a client only install - This will not install a database but it will point to the server ip address. True client server

  7. Use automatic dialup when the system needs to go to the internet. I use ASync pro for this.   

  8. Dynamic menu structures so that people writing add-ons can have their add on fit into the TC menus EG a point of sale system replaces the TC Point of sales.  

 

 

My suggestions in order - long term

  1. Write out Tww components. For the grid we should use jvcl. I know there is a problem with the globus unit we do not need it.

      I use their components quite extensively and they are stable.

     The only components needed for us is JVCoreD7D,JVCustomD7D,JVDBD7D,JVStdCtrlsD7D and JvCtrlsD7D. This also overcomes the Globus issues.

     We should make our own Package for this installation.

2.  Quick Reports. This is a bit of a nightmare but after a lot of thought we could solve all our repoting problems with reportman.

     We must have 2 different report types Dynamic and Static. Dynamic Reports gets written outside TC in the reportwriter itself and Static will be compiled into TC.

     Static reports will be reports like Invoices, statements etc and dynamic should listings like debtors, Sales by salesman, these reports will be the reports that anybody can copy from

    to create a new report.

    The only thing that can change on a static report is its layout. I have an idea that we can dynamically add another dataset to the static report through the report designer.This have to

    tested. If this is the case the sky is the limit because we are not bound by a release to add to our data selections.I will let you know.

3. Have TC Connect to firebird or Mysql. Unfortunately is goes against the thin client model. We have to compete whith other accounting systems out there if we want to make this work.

    and not many of pastels,quickbooks etc have alternate database connections. This will also attract internet programmers.

 

 The short term changes should be our first release. That should take about 6-8 weeks including testing.

 The long term changes should take 4-6 months including testing.

 I think Phillip was right this project should be called something else and not turbocash4 someting like Communicate powered by Turbocash. 

There will definitely be a change in some areas which will not look like the TC3. Remember this is a new product based on TC3. 

 I also thing Turbocash 3 should stay for the older customers that do not want to move. Eventually it will just die. 

 

I am going to write a multiwarehouse system for TC. I will be starting tomorrow.

this is my outline any suggestions are welcome as it will given back to the community.It will be compiled into the source and not as a add on

This will not be done for TC3.

 

Regards
Ettienne Du Plessis

 

PDSol Consulting
TurboCash Specialists
(The FREE accounting package)
Cell     :073 002 5877
E-mail :e...@pds.za.net
Web : http://www.pds.za.net

 

 

 

 

 

 

   

 

 

  

 

[Jan Verlaan]

Hi Ettienne,

When developing the multi warehouse solution, did you think also about Lot-control and Serialized items?
I think this is a must to have when creating a multi warehouse solution, especially when it is coming into the base source.
At least the solution should be prepared to add Lot-control and Serialized items at a later stage.

Do you have a technical and functional design how we should implement this solution? Are we able to think with you about that solution so we can make the best of  it?
As it is the first real new functionality in TC4, I strongly suggest to use the storage procedures from the firebird database instead of programming storage logic into the application.
1. to keep data consistency
2. Make it for plug-ins easier to make database changes
Did you think about that?

Thanks in advance,
Jan (certified CPIM ;-) ) http://www.apics.org/Certification/CPIM/

[Ettienne Du Plessis]

Hi Jan

 

My requirement does not need lot control and serialized items but that does not mean we should not think of it.

I have a project that has allready been planned and it will be over the 6-8 weeks.

I do have about 4 days of design coming up any ideas about the Lot-control and Serialized items that will not impact on my project to much i will consider. We also do not have to do this

right away.

 

I would like to steer clear of database functionality at the moment as i would like the current source base to talk to Mysql aswell. This however is another Topic Completetly.

I believe that we can use the different stored procedures in both the databases.

 

I am a great believer of interbase/firebird and have written many applications in it, Unfotunately the internet community has gone with MYSql which is what TC should be looking at. If we are very

clever we could write middleware that communicates to both databases and still use the power of the database. triggers,Stored procedures. I have also written sql script updater for firebird which can easily be written into the middleware. But for now i am going the firebird route for multiwarehousing

 

thanks for you comments

regards

ettienne

 

 

----- Original Message -----