But if all we do is auto-fill the form as a human does that would presumably be ok. Just be a lot faster than copying and pasting which you can't even do properly.
On 25 January 2013 23:36, Jake Markhus <[email protected]> wrote: > 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]> 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. > -- 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.
