ledger123 / runmyaccounts

SQL-Ledger Customizations by Run My Accounts
GNU General Public License v2.0
16 stars 9 forks source link

Article Qty displayed from count instead of onhand #582

Open sweitmann opened 3 weeks ago

sweitmann commented 3 weeks ago

Hi Armaghan,

In the Ledger123 version of SQL-Ledger we currently have two methods for determining the individual Qty for each article.

a.) By calculating "qty" for selected article in "inventory" table and b.) by displaying "onhand" amount in "parts" table for selected article.

The amounts displayed in 'Warehouses--Reports--Onhand' according to method a.) are exact and correct. Bildschirmfoto vom 2024-11-01 11-40-10

The amounts displayed according to method b.) when I enter "%" in article line in the following modules unfortunately not: 1.) 'AR--Sales Invoice' 2.) 'AR--Credit Invoice' 3.) 'Order Entry--Sales Order' 4.) 'Quotations--Quotation' 5.) 'AP--Vendor Invoice' 6.) 'AP--Debit Invoice' 7.) 'Order Entry--Purchase Order' 8.) 'Quotations--RFQ' Bildschirmfoto vom 2024-11-01 12-00-52

We also have the same problem in 9.) 'Goods & Services--Reports--Requirements'

Would it be possible to display the individual Qty for each article in the mentioned modules according to method a.) instead of b.), so that they are also shown correctly?

Regards