yes, you are right, but i think we need to find a work around this...
> As one who works with URA on the implementation of eTax for banks, I will > tell you the excel sheets > are no go areas. We (independent developers) even talked to them about > their > releasing spec for the > final data so that we could provide it ourselves but they said no. These > guys bought a solution from Tata > > That actually relies on another external app (the excel workbook) to > function. > > When you do the filling in, there are certain calculational > inconsistencies > they require since they are never > consistent as to where to round off or merely drop decimal places. We > talk > to the URA guys on twitter so > maybe we can push for an API so they can maintain their bs standard and > yet > allow us upload our data online. > > > > From: [email protected] [mailto:[email protected]] On Behalf > Of > [email protected] > Sent: Friday, 25 January 2013 23:17 > To: Uganda Linux User Group > Subject: Re: [LUG] Ugandan FLOSS projects > > > > 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] > <mailto:[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] >> <mailto:[email protected]> > <[email protected] <mailto:[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] > <mailto:[email protected]> > wrote: >>> >>>> Until they randomly issue a new doc >>>> On Jan 11, 2013 8:26 PM, "[email protected] > <mailto:[email protected]> " <[email protected] > <mailto:[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] > <mailto:[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] > <mailto:[email protected]> > wrote: >>>>>> > >>>>>> >> Please be. Always looking for inspired people to join in. >>>>>> >> >>>>>> >> >>>>>> >> On 10 January 2013 12:57, Kamya isaac lubwama <[email protected] > <mailto:[email protected]> > >>>>>> wrote: >>>>>> >> >>>>>> >>> thanks Simon >>>>>> >>> am inspired >>>>>> >>> >>>>>> >>> Kind Regards >>>>>> >>> Isaac Kamya >>>>>> >>> 0774452610 >>>>>> >>> On Jan 10, 2013 12:11 PM, "Reinier Battenberg" < >>>>>> >>> [email protected] > <mailto:[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 <http://www.mountbatten.net> >>>>>> >>>> tel: +256 758 801749 <tel:%2B256%20758%20801749> >>>>>> >>>> twitter: @batje >>>>>> >>>> _______________________________________________ >>>>>> >>>> The Uganda Linux User Group: http://linux.or.ug >>>>>> >>>> >>>>>> >>>> Send messages to this mailing list by addressing e-mails to: >>>>>> >>>> [email protected] <mailto:[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] <mailto:[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 <tel:%2B256%20%280%29%20312260620> >>>>>> >> Email: [email protected] <mailto:[email protected]> >>>>>> >> >>>>>> >> >>>>>> > >>>>>> > >>>>>> > -- >>>>>> > Simon Vass >>>>>> > Managing Director >>>>>> > E-Tech Uganda Ltd >>>>>> > http://www.etech.ug >>>>>> > Tel: +256 (0) 312260620 <tel:%2B256%20%280%29%20312260620> >>>>>> > Email: [email protected] <mailto:[email protected]> >>>>>> > _______________________________________________ >>>>>> > The Uganda Linux User Group: http://linux.or.ug >>>>>> > >>>>>> > Send messages to this mailing list by addressing e-mails to: >>>>>> > [email protected] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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] <mailto:[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 <tel:%2B256%20%280%29%20312260620> >> Email: [email protected] <mailto:[email protected]> >> _______________________________________________ >> The Uganda Linux User Group: http://linux.or.ug >> >> Send messages to this mailing list by addressing e-mails to: >> [email protected] <mailto:[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] > <mailto:[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.
