After running 'AR/AP--Transactions' report for 'Open' transactions, it should be possible to sort the report by 'paid' column. The report should then show the highest overpaid transactions first, followed by underpaid and undpaid invoices.

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

Add a 'History' button in the Edit Customer/Vendor screens that links to 'AR/AP--Transactions' reports including 'Due' in report

It should be possible to select a template in 'Batch--Email--...

...Sales invoices' etc.

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.

The customer number should be included by default in
a.) 'AR--Reports--Transactions'
b.) 'AR--Reports--Outstanding'

The Department Income Statement report should not have any department selected by default. Instead there could be an option to 'select all' if necessary.

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.

Print and Post - Button currently only works with printer or printing to queue, not when printing to screen.

The following items should be added to 'System--Defaults' settings:

1.) Customer Terms

2.) Customer Payment

3.) AR account

The taxes report in rel3 needs a summary of all listed accounts at the top of the report, like in 2.8:

ledger123/runmyaccounts#78

Hitting the enter key in 'General Ledger-Add Transaction' should focus cursor on list of accounts, not on debit column.

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 👍

It should also be possible to link a Customer/Vendor to a certain department.