Well your on the right track, make sure nothing like that has been done before at http://apps.openerp.com but sounds good. I had someone this week ask me about the same thing.
On 25 January 2013 23:46, Bagaka Manko <[email protected]> wrote: > Have been looking around for openERP customisation for hotel establishment > complete with guest reservation for rooms and POS for bar and restaurant. > > Any ideas? > On Jan 25, 2013 11:17 PM, "[email protected]" <[email protected]> > wrote: > >> My thinking was to build a module inside OpenERP, which would produce a >> filled in version of the VAT Template Form. I know I can fill in an Excel >> Template either using code or Kettle ETL, I don't want to generate the file >> upload file because then if the format changes it'll be more work to >> maintain. >> >> The VAT Form is an Excel Spreadsheet with Macro's. The Macro's do things >> like autofill bank branches and also check that the math on the form is >> right or URA right at least ;-) >> >> The form sheets do not change much, but the back end code does from time >> to time as banks change. >> >> Producing the various invoice lines would be possible >> using analytically accounts. A similar module exists for the UK VAT system, >> which works on this principle. >> >> Something similar could be done for the PAYE and NSSF Reports also. >> >> Simon >> >> On 25 January 2013 12:59, <[email protected]> wrote: >> >>> Hi, haven't had time to look into this: but the form you provided seems >>> to >>> look like: >>> >>> struct vassJakeForm{ >>> struct SectionA *firstSection >>> struct SectionB *secondSection, etc >>> >>> } >>> >>> or >>> >>> >>> public class vassJakeForm{ >>> >>> /*Form Constructor*/ >>> public vassJakeForm(SectionA firstSection, SectionB secondSection, >>> SectionC thirdSection, SectionD forthSection, SectionE fifthSection, >>> etc){ >>> } >>> >>> } >>> >>> the model may have to map to a database given the form consists of drop >>> downs whose interface we may have no access to. >>> >>> As for the view, do you want a human interface to the above controller or >>> a parser interface between your monthly VAT report file generated by the >>> ERP system(ie the controller reads the file and parses it into the format >>> desired by ura system, sends ura system an email and copies you) or both >>> interfaces. >>> >>> >>> Given its enterprise, then probably a web interface, but the form seems >>> to >>> be big for a transactional commit or persist (need look further into >>> that...) Will give it a shot as we make resources available for it. >>> >>> >>> Then you talked of pre-populating the view (does that mean keeping >>> multiple copies of the model which you can update as you please?) >>> >>> Thanks. >>> >>> >>> >>> > Plus the path to download the source doc seems to be the same >>> > >>> http://www.ura.go.ug/eServices/howToDownload.jsp?path=Tin_Individual_Sample.xls >>> > >>> > >>> > On 11 January 2013 21:22, [email protected] <[email protected]> >>> wrote: >>> > >>> >> That is why you'll need to have the ability to store more than one >>> >> source >>> >> e-tax doc, and the final upload file. >>> >> >>> >> >>> >> >>> >> On 11 January 2013 21:20, Kyle Spencer <[email protected]> wrote: >>> >> >>> >>> Until they randomly issue a new doc >>> >>> On Jan 11, 2013 8:26 PM, "[email protected]" <[email protected]> >>> >>> wrote: >>> >>> >>> >>>> No, we would need to build a module which takes a blank form and >>> using >>> >>>> some presets fills it in. From what I understand the URA does not >>> have >>> >>>> or >>> >>>> want an API for the e-tax system due to the potential for security >>> >>>> issues. >>> >>>> So the plan is to build a module to make it simple using the >>> existing >>> >>>> system. >>> >>>> >>> >>>> >>> >>>> >>> >>>> On 11 January 2013 19:48, <[email protected]> >>> >>>> wrote: >>> >>>> >>> >>>>> Hi, is your erp system already auto integrated with the ura system? >>> >>>>> >>> >>>>> Perhaps you could also have some API info on how to integrate with >>> >>>>> the >>> >>>>> local payment gateways; Reinier hinted on it per the ura system, >>> but >>> >>>>> not >>> >>>>> sure if that API can also be accessed via other systems? >>> >>>>> >>> >>>>> >>> >>>>> > The next module I want to create is the Uganda VAT module. I hate >>> >>>>> doing >>> >>>>> > VAT, I know it is relatively simple to fill in the e-tax form but >>> >>>>> the >>> >>>>> > macros and lack of a proper copy-paste function makes me want to >>> >>>>> scream. >>> >>>>> > >>> >>>>> > Want to create a module that can fill in the whole thing at the >>> >>>>> click >>> >>>>> of a >>> >>>>> > button. Very doable. >>> >>>>> > >>> >>>>> > Simon >>> >>>>> > >>> >>>>> > On 10 January 2013 12:59, Simon Vass <[email protected]> wrote: >>> >>>>> > >>> >>>>> >> Please be. Always looking for inspired people to join in. >>> >>>>> >> >>> >>>>> >> >>> >>>>> >> On 10 January 2013 12:57, Kamya isaac lubwama < >>> [email protected]> >>> >>>>> wrote: >>> >>>>> >> >>> >>>>> >>> thanks Simon >>> >>>>> >>> am inspired >>> >>>>> >>> >>> >>>>> >>> Kind Regards >>> >>>>> >>> Isaac Kamya >>> >>>>> >>> 0774452610 >>> >>>>> >>> On Jan 10, 2013 12:11 PM, "Reinier Battenberg" < >>> >>>>> >>> [email protected]> wrote: >>> >>>>> >>> >>> >>>>> >>>> Hi, >>> >>>>> >>>> >>> >>>>> >>>> In yesterdays email i forgot to ask for links to Ugandan FlOSS >>> >>>>> >>>> projects. >>> >>>>> >>>> I >>> >>>>> >>>> found one: >>> >>>>> >>>> >>> >>>>> >>>> https://github.com/etechuganda/l10n_ug >>> >>>>> >>>> >>> >>>>> >>>> its an OpenERP module for Uganda specific information. >>> >>>>> >>>> >>> >>>>> >>>> Do other people know of more projects like this? >>> >>>>> >>>> >>> >>>>> >>>> (and credits to Simon & his clients who paid for this) >>> >>>>> >>>> >>> >>>>> >>>> -- >>> >>>>> >>>> rgds, >>> >>>>> >>>> >>> >>>>> >>>> Reinier Battenberg >>> >>>>> >>>> Director >>> >>>>> >>>> Mountbatten Ltd. >>> >>>>> >>>> www.mountbatten.net >>> >>>>> >>>> tel: +256 758 801749 >>> >>>>> >>>> twitter: @batje >>> >>>>> >>>> _______________________________________________ >>> >>>>> >>>> The Uganda Linux User Group: http://linux.or.ug >>> >>>>> >>>> >>> >>>>> >>>> Send messages to this mailing list by addressing e-mails to: >>> >>>>> >>>> [email protected] >>> >>>>> >>>> Mailing list archives: >>> >>>>> http://www.mail-archive.com/[email protected]/ >>> >>>>> >>>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>>>> >>>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>>>> >>>> >>> >>>>> >>>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>>>> >>>> http://www.infocom.co.ug/ >>> >>>>> >>>> >>> >>>>> >>>> The above comments and data are owned by whoever posted them >>> >>>>> >>>> (including >>> >>>>> >>>> attachments if any). The mailing list host is not responsible >>> >>>>> for >>> >>>>> them >>> >>>>> >>>> in >>> >>>>> >>>> any way. >>> >>>>> >>>> >>> >>>>> >>> >>> >>>>> >>> _______________________________________________ >>> >>>>> >>> The Uganda Linux User Group: http://linux.or.ug >>> >>>>> >>> >>> >>>>> >>> Send messages to this mailing list by addressing e-mails to: >>> >>>>> >>> [email protected] >>> >>>>> >>> Mailing list archives: >>> >>>>> http://www.mail-archive.com/[email protected]/ >>> >>>>> >>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>>>> >>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>>>> >>> >>> >>>>> >>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>>>> >>> http://www.infocom.co.ug/ >>> >>>>> >>> >>> >>>>> >>> The above comments and data are owned by whoever posted them >>> >>>>> (including >>> >>>>> >>> attachments if any). The mailing list host is not responsible >>> for >>> >>>>> them >>> >>>>> >>> in >>> >>>>> >>> any way. >>> >>>>> >>> >>> >>>>> >> >>> >>>>> >> >>> >>>>> >> >>> >>>>> >> -- >>> >>>>> >> Simon Vass >>> >>>>> >> Managing Director >>> >>>>> >> E-Tech Uganda Ltd >>> >>>>> >> http://www.etech.ug >>> >>>>> >> Tel: +256 (0) 312260620 >>> >>>>> >> Email: [email protected] >>> >>>>> >> >>> >>>>> >> >>> >>>>> > >>> >>>>> > >>> >>>>> > -- >>> >>>>> > Simon Vass >>> >>>>> > Managing Director >>> >>>>> > E-Tech Uganda Ltd >>> >>>>> > http://www.etech.ug >>> >>>>> > Tel: +256 (0) 312260620 >>> >>>>> > Email: [email protected] >>> >>>>> > _______________________________________________ >>> >>>>> > The Uganda Linux User Group: http://linux.or.ug >>> >>>>> > >>> >>>>> > Send messages to this mailing list by addressing e-mails to: >>> >>>>> > [email protected] >>> >>>>> > Mailing list archives: >>> http://www.mail-archive.com/[email protected]/ >>> >>>>> > Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>>>> > To unsubscribe: http://kym.net/mailman/options/lug >>> >>>>> > >>> >>>>> > The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>>>> > http://www.infocom.co.ug/ >>> >>>>> > >>> >>>>> > The above comments and data are owned by whoever posted them >>> >>>>> (including >>> >>>>> > attachments if any). The mailing list host is not responsible for >>> >>>>> them in >>> >>>>> > any way. >>> >>>>> >>> >>>>> >>> >>>>> _______________________________________________ >>> >>>>> The Uganda Linux User Group: http://linux.or.ug >>> >>>>> >>> >>>>> Send messages to this mailing list by addressing e-mails to: >>> >>>>> [email protected] >>> >>>>> Mailing list archives: >>> http://www.mail-archive.com/[email protected]/ >>> >>>>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>>>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>>>> >>> >>>>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>>>> http://www.infocom.co.ug/ >>> >>>>> >>> >>>>> The above comments and data are owned by whoever posted them >>> >>>>> (including >>> >>>>> attachments if any). The mailing list host is not responsible for >>> >>>>> them in >>> >>>>> any way. >>> >>>>> >>> >>>> >>> >>>> >>> >>>> >>> >>>> -- >>> >>>> Simon Vass >>> >>>> >>> >>>> _______________________________________________ >>> >>>> The Uganda Linux User Group: http://linux.or.ug >>> >>>> >>> >>>> Send messages to this mailing list by addressing e-mails to: >>> >>>> [email protected] >>> >>>> Mailing list archives: http://www.mail-archive.com/[email protected]/ >>> >>>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>>> >>> >>>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>>> http://www.infocom.co.ug/ >>> >>>> >>> >>>> The above comments and data are owned by whoever posted them >>> >>>> (including >>> >>>> attachments if any). The mailing list host is not responsible for >>> them >>> >>>> in >>> >>>> any way. >>> >>>> >>> >>> >>> >>> _______________________________________________ >>> >>> The Uganda Linux User Group: http://linux.or.ug >>> >>> >>> >>> Send messages to this mailing list by addressing e-mails to: >>> >>> [email protected] >>> >>> Mailing list archives: http://www.mail-archive.com/[email protected]/ >>> >>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>> >>> >>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >>> http://www.infocom.co.ug/ >>> >>> >>> >>> The above comments and data are owned by whoever posted them >>> (including >>> >>> attachments if any). The mailing list host is not responsible for >>> them >>> >>> in >>> >>> any way. >>> >>> >>> >> >>> >> >>> >> >>> >> -- >>> >> Simon Vass >>> >> >>> >> _______________________________________________ >>> >> The Uganda Linux User Group: http://linux.or.ug >>> >> >>> >> Send messages to this mailing list by addressing e-mails to: >>> >> [email protected] >>> >> Mailing list archives: http://www.mail-archive.com/[email protected]/ >>> >> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> >> To unsubscribe: http://kym.net/mailman/options/lug >>> >> >>> >> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> >> http://www.infocom.co.ug/ >>> >> >>> >> The above comments and data are owned by whoever posted them >>> (including >>> >> attachments if any). The mailing list host is not responsible for them >>> >> in >>> >> any way. >>> >> >>> > >>> > >>> > >>> > -- >>> > Simon Vass >>> > Managing Director >>> > E-Tech Uganda Ltd >>> > http://www.etech.ug >>> > Tel: +256 (0) 312260620 >>> > Email: [email protected] >>> > _______________________________________________ >>> > The Uganda Linux User Group: http://linux.or.ug >>> > >>> > Send messages to this mailing list by addressing e-mails to: >>> > [email protected] >>> > Mailing list archives: http://www.mail-archive.com/[email protected]/ >>> > Mailing list settings: http://kym.net/mailman/listinfo/lug >>> > To unsubscribe: http://kym.net/mailman/options/lug >>> > >>> > The Uganda LUG mailing list is generously hosted by INFOCOM: >>> > http://www.infocom.co.ug/ >>> > >>> > The above comments and data are owned by whoever posted them (including >>> > attachments if any). The mailing list host is not responsible for them >>> in >>> > any way. >>> >>> >>> _______________________________________________ >>> The Uganda Linux User Group: http://linux.or.ug >>> >>> Send messages to this mailing list by addressing e-mails to: >>> [email protected] >>> Mailing list archives: http://www.mail-archive.com/[email protected]/ >>> Mailing list settings: http://kym.net/mailman/listinfo/lug >>> To unsubscribe: http://kym.net/mailman/options/lug >>> >>> The Uganda LUG mailing list is generously hosted by INFOCOM: >>> http://www.infocom.co.ug/ >>> >>> The above comments and data are owned by whoever posted them (including >>> attachments if any). The mailing list host is not responsible for them in >>> any way. >>> >> >> >> >> -- >> Simon Vass >> >> _______________________________________________ >> The Uganda Linux User Group: http://linux.or.ug >> >> Send messages to this mailing list by addressing e-mails to: >> [email protected] >> Mailing list archives: http://www.mail-archive.com/[email protected]/ >> Mailing list settings: http://kym.net/mailman/listinfo/lug >> To unsubscribe: http://kym.net/mailman/options/lug >> >> The Uganda LUG mailing list is generously hosted by INFOCOM: >> http://www.infocom.co.ug/ >> >> The above comments and data are owned by whoever posted them (including >> attachments if any). The mailing list host is not responsible for them in >> any way. >> > > _______________________________________________ > The Uganda Linux User Group: http://linux.or.ug > > Send messages to this mailing list by addressing e-mails to: > [email protected] > Mailing list archives: http://www.mail-archive.com/[email protected]/ > Mailing list settings: http://kym.net/mailman/listinfo/lug > To unsubscribe: http://kym.net/mailman/options/lug > > The Uganda LUG mailing list is generously hosted by INFOCOM: > http://www.infocom.co.ug/ > > The above comments and data are owned by whoever posted them (including > attachments if any). The mailing list host is not responsible for them in > any way. > -- Simon Vass
_______________________________________________ The Uganda Linux User Group: http://linux.or.ug Send messages to this mailing list by addressing e-mails to: [email protected] Mailing list archives: http://www.mail-archive.com/[email protected]/ Mailing list settings: http://kym.net/mailman/listinfo/lug To unsubscribe: http://kym.net/mailman/options/lug The Uganda LUG mailing list is generously hosted by INFOCOM: http://www.infocom.co.ug/ The above comments and data are owned by whoever posted them (including attachments if any). The mailing list host is not responsible for them in any way.
