Steps to reproduce:

1. Go to Add Assembly
2. Leave Description empty.
3. Define valid Individual Items (Parts)
4. Click on Save (Refer screenshot-1)
5. Error is shown as in screenshot-2.
6. But Assembly with blank Description is added to list as shown in screenshot-3
7. Further it is not possible to either update this Assembly or delete the assembly.

Screenshot-1:

Screenshot-2:

Screenshot-3:

Hi,
I've get login issue after the pull of this new version ?
Is there a regression ?
Regards

Hey there - been searching through the code to figure out how things work.

I have a payroll deduction table with rates per pay. First X dollars are taxed at %1, next Y dollars are taxes at %2 etc.

I've noted that the deduction calculator sorts and stops when pay is between above and below.

To add the previous amounts I have put their values in the amount column - the problem is that it does not take pay frequency into account like the rest of the table.

Here is my change

gopokyo-colinn@2059714

Question: Do we need encrypted backups for GDPR compliance?

We have a new branch that contains (for the moment) the following addition the the main branch:

• quick calculation in sales quotations, orders and invoices

The editor has to support UTF-8, templates have to be read and written in UTF-8 when they are processed.

I have not yet been able to determine the cause, but documents are not attaching to payroll transactions properly.

When I "list documents" I can see the descriptions of the files and that they are attached to the payroll transaction, but folder and filename are empty. When I click on the document description I am sent to a page where I can modify the folder an filename but not attempt to upload the pdf again

things I will check into:
Files upload have spaces them - issue?

documents are attaching to AP transactions

A customer reported empty amount fields and wrong rvc and dcn in the remittance vouchers he attaches to reminders sent by e-mail.

The login screen displays too much information and allows to spy out the system.

I tried testing Sql-ledger from the docker installation. When I try to create a dataset, I get this error.

error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and accepting connections on that socket?

I went with the manual approach and got the same error. What am I doing wrong?

On mobile devices, the scale of the screens is too small.

To be change bk.iban, bk,qriban, bk.bic,
bk.iban, bk**.**qriban, bk.bic,

Regards

Requests from browser have to be decoded. At first sight, just a few changes in Form->new are required, but we will see.

I have a problem with a POS printer (see sql-ledger forum)
In fact, printing an invoice txt file pos_invoice.txt or invoice.txt on the POS printer or Laser Printer gives an Error!
| lpr -PPrinter : Permission denied (it is not a permission problem : both printers print correctly Postscript in sql-ledger and txt files with command)

The new fact : I have 2 test versions of sql-ledger (Tekki and DWS) on another new computer SuSE 15.2 : txt printing is OK on the DWS version and not on the Tekki (but Tekki works with Unicode utf8 !)

In the next version it will be possible to reduce the VAT reports so they only show the totals and subtotals without the individual transactions.

This feature is sponsored by one of our customers.

It would be nice to have lists of recently used objects.

It would be nice to have templates for customers and vendors:

• customer/vendor number starts with 'TPL'
• they are only editable for the admin
• they only have a button Save as New for all the other users

I successfully manage to call the api when I send the invoice id. But when I try with only the waybill or the invnumber, it does not work.

With invnumber, I get:

Login data for SQL-Ledger
Can't use an undefined value as a HASH reference at add_payment.pl line 42.

I get an error with waybill. What did I do wrong. I thought all 4 would have worked. DCN is empty so I never tried it.

#! /usr/bin/env perl
use Mojo::Base -strict;
use open ':std', ':encoding(utf8)';

use Mojo::UserAgent;
use Print::Colored ':all';

my $sl_url = 'http://localhost/sql-ledger';

say 'Login data for SQL-Ledger';

my $sl_username = 'admin@datasetname';

my $sl_password = 'sql-ledger';

my $ua        = Mojo::UserAgent->new;
my %sl_params = (login => $sl_username, path => 'bin/mozilla',);
my %search_params;

my $res = $ua->post(
    "$sl_url/login.pl",
    form => {action => 'login', password => $sl_password, %sl_params}
  )->result;



my %payment_params = (
  amount         => 100,
  #id             => 10080,
  #dcn            => 2,
  invnumber       => 5,
  #waybill         => 11,
  datepaid       => "02-02-2022",
  paymentaccount => "1060--Checking Account",
);

$res = $ua->post(
    "$sl_url/api.pl",
    form => {action => 'add_payment', %payment_params, %sl_params}
  )->result;

if ($res->json->{result} eq 'success') {
  say_ok 'Payment added.';
} else {
  say_error 'Error, payment not added!';
}

Non-UTF-8 translations have to be filtered out, files need a use uf8 header.

I have created 1 part and 2 assemblies with following correlation:

Assembly1 uses Part1
Assembly2 uses Assembly1

Part is purchased by AP - Vendor Invoice and quantity is stocked to inventory.

After this, when I try to Stock Assembly by selecting the Check Inventory checkbox, no parts/assemblies are displayed, even when parts/assemblies are in sufficient quantity.

cc @Tekki

The image below is a representation of multiple assemblies whose inventories are tracked. Notice the duplicates that are automatically created when the previously posted invoices are edited. For example, M3 - Coir, M4 - Coir Bales 4.5 kg.

The following steps would demonstrate how these assemblies are being duplicated. Notice that in the above screenshot, M5 - Coir Bales 5 kg is listed only once and had been linked with M3 - Coir while creating the assembly.

Now, let's edit the invoice and update any field.
Consider invoice number S20210017 , update the internal note or any other field. Notice that the item invoiced is M5 - Coir Bales 5 kg (assembly that had no duplicate). Post the updated invoice.

Invoice S20210017

Once the invoice is re-posted, a duplicate assembly is generated automatically. The image below is the list of assemblies that are present after updating a posted invoice. A new ID is generated for the assembly M5 and has 2 entries.

Notice 2 entries for M5 that did not exist previously

This is causing issues for further invoicing where the users are prompted with multiple products with the same code and names. Would be great if you could explain the behavior and propose any solutions to this.

@Tekki

The SQL-Ledger What's New page lists v3.0.5 (May 24, 2013) as the latest release, but the master branch only holds v3.0.3 (June 5, 2012).

System--Defaults loses the information for part and project number.

Starting with the next version, all account statements will show for each transaction its description, if available, and the contra accounts.

This feature is sponsored by one of our customers.

How to reproduce:

• Log out
• Click back button in the browser
• Continue working

Users complain that it is possible to navigate away from a changed document or to close the whole browser without a warning.

For several reasons, we can't just use the onbeforunload handler to solve this.

DBD::Pg::st execute failed: ERREUR: la colonne bk.qriban n'existe pas
LINE 8: bk.name AS bankname, bk.iban, bk.qriban, bk....
^
HINT: Peut-être que vous souhaitiez référencer la colonne « bk.iban ». at SL/CT.pm line 63.
Error!
SELECT ct.,
ad.id AS addressid, ad.address1, ad.address2, ad.city,
ad.state, ad.zipcode, ad.country,
b.description AS business, b.id AS business_id, s.,
e.name AS employee, e.id AS employee_id,
g.pricegroup, g.id AS pricegroup_id,
m.description AS paymentmethod, m.id AS paymentmethod_id,
bk.name AS bankname, bk.iban, bk.qriban, bk.bic,
bk.membernumber, bk.clearingnumber,
ad1.address1 AS bankaddress1,
ad1.address2 AS bankaddress2,
ad1.city AS bankcity,
ad1.state AS bankstate,
ad1.zipcode AS bankzipcode,
ad1.country AS bankcountry,
ct.curr
FROM customer ct
JOIN address ad ON (ct.id = ad.trans_id)
LEFT JOIN business b ON (ct.business_id = b.id)
LEFT JOIN shipto s ON (ct.id = s.trans_id)
LEFT JOIN employee e ON (ct.employee_id = e.id)
LEFT JOIN pricegroup g ON (g.id = ct.pricegroup_id)
LEFT JOIN paymentmethod m ON (m.id = ct.paymentmethod_id)
LEFT JOIN bank bk ON (bk.id = ct.id)
LEFT JOIN address ad1 ON (bk.address_id = ad1.id)
WHERE ct.id = 23094
ERREUR: la colonne bk.qriban n'existe pas
LINE 8: bk.name AS bankname, bk.iban, bk.qriban, bk....
^
HINT: Peut-être que vous souhaitiez référencer la colonne « bk.iban ».

To reproduce:

• create test project
• add 2 time cards
• go to Projects--Generate--Sales Orders
• select the test project, Detail, Continue
• deselect one time card, Generate Sales Orders

Search for the new sales order. It contains 2 rows instead of 1.

The screen to add and edit time cards could be improved:

• dropdown shows project description (postponed)
• focus on the part number if missing, otherwise on the description

After saving a card:

• the same employee selected as before
• the same project selected
• date is the same as before

Hi. Everybody probably agrees that getting rid of 10km long HTML <select> elements is good for the user experience.

@Tekki have you perhaps researched integrating any of the user friendly select controls into SL, such as https://select2.org

Wondering if there are any significant roadblocks, or perhaps it could be relatively plug n play.

Getting this at login:

Upgrading to Version 3.2.9 ... sql/Tekki-upgrade-011-015.sql:1 - ERROR: syntax error at or near "NOT"
LINE 1: ALTER TABLE bank ADD COLUMN IF NOT EXISTS qriban varchar(34)
^

https://stackoverflow.com/a/60311756/35946 seems to indicate it's not valid syntax, at least for 9.5?

I've soleved by adding at line 2060 in SL/AM.pm

utf8::encode $fields;

Regards

No cuckoo packages!
Package names should match path names, for example the package of SL/AA.pm should be SL::AA, not AA. Locale inside 'Form.pm' should be called SL::Locale and reside in a separate file.

First step: Let DBD::Pg handle the connection details. We remove all the parameters (besides AutoCommit) and look what happens.

If I want to create a new table for Folio. By my current understanding, recording data into this additional table should not have any impact on all the other operations. Would it be a bad idea to use the monitor panel to programmatically create entries into the Folio?

Hi. I want to understand how much effort it takes to write the the different methods in /bin/mozilla/api.pl?
We wanted to cover all the functionality through APIs. Many thanks.

to f.ex. add a payment (of an existing invoice) ?

The next version will add a button to the trial balance that allows to display all account statements on one page.

This feature is sponsored by one of our customers.

I can help, there are interest in add some markdown documentation?

... Starting with a basic "install guide"

Since beginning of December 2021 users report that WLprinter is no longer able to find any printers on Windows.

Output to browser has to be encoded to UTF-8. Because of the thousands of print statements we have to use something like use open ':std' => ':utf8';. The scope of this directive may not be what we expect, there will be unwanted side effects.

India follows a different 'Number Format'. Request to support the same.
https://en.wikipedia.org/wiki/Indian_numbering_system

Examples:
1,000.00
10,000.00
1,00,000.00
10,00,000.00
1,00,00,000.00
So on...

The next version will add 3 simple Markdown styles that are processed in LaTeX templates.

*this is italic*
**this is bold**
[Github](https://github.com)

In DBD::Pg > 3.2.1 binary strings are in some cases converted to UTF-8. There is an open issue on RT since 2015: https://rt.cpan.org/Public/Bug/Display.html?id=103137
It seems this will never be solved in DBD::Pg, so the solution can only be to modify SQL-Ledger to make it work consistently with Unicode, as described in http://perldoc.perl.org/perlunicode.html.

ping @lkraav

We need pod entries at least for the names of the subroutines.