Enhanced SQL-Ledger by Ledger123.com
ledger123 / ledger123-2.8.30 Goto Github PK
View Code? Open in Web Editor NEWEnhanced SQL-Ledger by Ledger123.com
License: GNU General Public License v2.0
Enhanced SQL-Ledger by Ledger123.com
License: GNU General Public License v2.0
Sometimes users have to delete an order due to typing mistakes or other mistakes. However, order deletion has been disabled. It is my understanding that this was done to ensure that inventory figures and COGS don't get wrong.
However, if an order is for services only OR it is for (stock) parts but nothing has been received yet then I don't see any harm in deleting the order.
Develop new backup and restore function that enables the backup and restoring of:
a.) database
b.) users
c.) templates
This is how our DATEV Export script currently works:
1.) Read all rows of the first SQL-Ledger transaction for the chosen period to be exported to DATEV format.
2.) Create two groups; one with all the negative values and one with all the positive values and sort them according to the size of each value.
3.) Next compare the negative values with the positive values and if it finds values that are equal in amount, it should remove these values from the first transaction and write them into a new "DATEV-Export" file.
4.) Repeat 3.) until there are no more equal amounts left in the negative and positive group.
The problem we are having now is related to equal amounts, so I will stop here. What do you think about adding some tests between 3.) and 4.) that do the following:
a.) When values are equal in amount, check if the account is the same in debit and credit.
b.) If the account is the same in debit and credit, check if there is another equal value in the opposite group that is booked on a different account.
c.) If so, remove these values from the transaction and write them into the "DATEV-Export" file and goto 3.)
d.) If not, remove the values with equal amounts and same account in debit and credit from the transaction and write them into the "DATEV-Export" file, flag "ERROR" in the error column next to this transaction and goto 3.)
Move 'description' and 'project' fileds in AR and AP modules 'Add transaction' to second row.
On Thu, May 8, 2014 at 10:22 AM, Sebastian Weitmann
[email protected] wrote:
a.) Income Statement / GIFI errors in total income
I have attached a dump of two databases (sql-vlnt and sql-zbiv). If you
install these on a local machine and check out the sql-vlnt one, you
will see the following strange thing; If you run an Income Statement as
show in attached screen shot 001.png for the period January to March
2014 (Quarter) for the Department "Bielefeld EBIV" you will see a total
income of 58.792,18 (see screen shot 002.png).
Now, if you run the same Income Statement but choose GIFI instead of
standard you will see a different result, namely 59.293,82 (see screen
shot 003.png). The difference being 501,64.
If you then take note of the total amount on GIFI 805 (13.577,89) and
click on it to see the different amounts behind that amount, you will
now see that the total has changed from 13.577,89 to 13.076,25. The
difference being 501,64.
Do you have any idea what is going wrong here and why? I have invested
quite some time to try to figure it out, but can't find any solid
explanation myself. So, I would really appreciate your help to figure
this one out because the customer is requesting an explanation or
solution.
If I print invoices using 'Batch--Print--Sales Invoices', afterwards they are still displayed in 'Batch--Print--Sales Invoices' as if they had not been printed yet.
enhance README with some links or explanations
I have entered some bookings in app.sql-ledger-network.com to replicate the issue.
You will can see the problem (bug) there if you do the following:
a.) Run 'Cash--Reconciliation' and select the account "1205--Bank Foreign Currency Account"
b.) Click "Continue" and note the "Beginning Balance" (0,81)
c.) Now go back and select the period "April 2015" and click "Continue" again.
d.) This time note the correct "Beginning Balance" (0,00)
Conclusion: Unless a period is selected, the report has a problem with "FX Adjustment" bookings (GL-12)
In the RMA version of SQL-Ledger you can see both Company Name & Contact Person for each Customer/Vendor that appears in the AP/AR module drop down menus.
As it is now the list in the drop down menu is sorted by Company Name, but not subsequently by Contact Person. Could you please adjust this, so that it sorts by Company Name and subsequently by Contact Person?
Regards
Heya
Just wondering if the upstream update process is falling off here? It's been convenient to pull ๐
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.