sl-community / rmac Goto Github PK

Hi Axel,

The P+L and balance sheet is not working on Colonia50. I get the following error message:

Any ideas?

Regards

Suppose you are a developer who is willing to collaborate on this project.
You git-clone the stuff. And then?

• No README file on top level
• No INSTALL file on top level

The content in the doc/ folder is 6 years old. But lets try the instructions in doc/README...
The mentioned setup.pl is just a bad joke (try it).

To make it short: There is no reasonable way to quickly achieve a working instance for developing. Another GitHub project gives an Ansible-based installer. But for this you
would need a VM, and you cannot simply use your favourite dev-tools.

So what we really need is some Docker support so that any developer with a Docker
environment (which means every developer – we're living in 2019) can
simply start a Docker-container with a fully-functional rmac-instance for
developing puposes.

SQL Ledger is based on plain old CGI technology (and it doesn't use the CGI module at all).
So programmers are forced to produce really bad code (no separation of interface and implementation is only one of the well-known drawbacks).
Is it possible to integrate a "modern" Perl web framework like Mojolicious so that it can coexist with the legacy code?
Otherwise it will not be possible to excite any young programmers with this project...

Hello everyone,

Sebastian invited me to join this organisation and I am very excited to work with you in the future.

I am a small business owner providing services in the IT-Industry mostly with Linux and I am using the original SQL Ledger version from DWS Systems.

in my small business I switched pretty much to have documents like invoices (mobile phone etc.) sent to me in PDF-form and I just love the feature in the original SQL Ledger to attach them to bookkeeping entries (Buchungssatz).

It is very nice that I just need to look inside my SQL Ledger program and find everything in there. Also PDFs are being backed up with the data base.

As far as backups are concerned I have the impressing that the digital PDF files are backed up in the SQL dump as binary blobs.

So my question is: Would it be possible to integrate this into the "rmac" Version? Maybe Dieter's code can be used as well.

I appreciate all your efforts into this direction and please let me know should you require further information.

It should be possible to create a preliminary VAT return document (German: "Umsatzsteuer-Voranmeldung").
Since this is very country-specific, let's focus on Germany for the moment. Perhaps it is possible
to choose a general approach, so that code could be reused in case of interest in other countries.

And remove all useless links to runmyaccounts webpages.

Hi Axel,

We have an issue with the GoBD-Export. I was contacted by an auditor from the German tax authorities who informed me that the journal.csv column "Buchungstext" does not have the correct content. Instead the column "Buchungstext" currently shows the account name (Kontenbezeichnung).

Could you please adjust the 'Export--GoBD' feature, so that

a.) the content currently exported into the column "Buchungstext" is placed in a new column to the right of the column "Kontonummer" with the header "Kontenbezeichung" and

b.) the column "Buchungstext" is filled with the respective SQL-Ledger database (AR, AP or GL) field "description" instead.

Regards

We want to begin from scratch again...

Until now, only local Docker-Containers for development purposes can be created. It shoud be possible to build "production" containers, too.

$ ./setup/docker/ledgerctl up
ERROR: .FileNotFoundError: [Errno 2] No such file or directory: './web.local.yml'

SQL -Ledger is hard to install. Nobody knows what Perl module or system executables are
needed (until the moment the app crashes due to a missing module).
Therefore we need some kind of setup check, ideally CGI/web-based, to quickly get an overview
of all missing and fulfilled system requirements.

If a GoBD-Export lasts very long, there could be issues with web timeouts (especially when SQL-Ledger is running in a reverse-proxy-setup). We probably need some kind of page updates to avoid long idle periods on the wire.

Hi Axel,

First of all; Thank you for your excellent support and all your contributions helping us move this beautiful free SQL-Ledger accounting software project to its next level.

I really like and admire the way you have added a Mojolicious layer creating a new well structured and clean base for contributing ancillary code to the project.

In regard to the new date picker in 'Export--GoBD' and 'Export--Preliminary VAT Return' I would simply like to ask you to make some minor adjustments so that they look, feel and work the same way as all other previous date pickers available in SQL-Ledger

a.) Please adjust the years currently offered in "%= include '_partial/date_interval_picker', offer_years =>" to be defined by the actual years for which there is accounting data available in the database acc_trans table.

b.) Kindly remove the expendable text "...or..." between the fields where you have the option to enter the date manually or use the date picker:

c.) And please change the wording from "Until now" to "Current":

Regards

It should be possible to export GoDB-compliant data (a German standard). See:

• https://de.wikipedia.org/wiki/Grunds%C3%A4tze_zur_ordnungsm%C3%A4%C3%9Figen_F%C3%BChrung_und_Aufbewahrung_von_B%C3%BCchern,_Aufzeichnungen_und_Unterlagen_in_elektronischer_Form_sowie_zum_Datenzugriff
• http://support.audicon.net/index.php/idea/idea-aktuelle-downloads/doc_details/28-gdpdu-beschreibungsstandard.html