Menu
▾
▴
sql-ledger-users
|
From: Robert A. M. I. <rma...@tw...> - 2001-07-14 14:10:00
|
Is there a way to edit the "on hand" quantity of an inventory part in the edit part screen? Or, a way to set the current "on hand" quanitity when using the "add part" page for a new inventory part? Is there a different page to set the "on hand" quantity for an inventory part? I am using SQL-Ledger v1.4.8 on RH7.1 and it runs excellent. Thanks for the help, Bob Mathison Mathison Supply Co, Inc 31535 Ford Rd Garden City, MI 48135 734.422.3858 rma...@tw... |
|
From: Dieter S. <dsi...@sq...> - 2001-07-14 17:11:11
|
OnHand quantity in inventory is controlled by "Customer Invoice" and "Vendor Invoice" When you sell and purchase the part the quantity is updated. The "Add Part" function is only to setup the part in inventory, how it is linked, selling price, etc. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sat, 14 Jul 2001, Robert A. Mathison II wrote: > Is there a way to edit the "on hand" quantity of an inventory part in > the edit part screen? Or, a way to set the current "on hand" quanitity > when using the "add part" page for a new inventory part? Is there a > different page to set the "on hand" quantity for an inventory part? > > I am using SQL-Ledger v1.4.8 on RH7.1 and it runs excellent. > > Thanks for the help, > > Bob Mathison > Mathison Supply Co, Inc > 31535 Ford Rd > Garden City, MI 48135 > 734.422.3858 > rma...@tw... > > > > > |
|
From: Michael B. <Mi...@di...> - 2001-07-16 00:56:51
|
Hey Everyone: My company uses SQL-Ledger for billing consulting time and we like to include details of what work was performed. We have implemented a request tracking system called Request Tracker (great program! http://www.fsck.com/projects/rt/features.html The new version supports PostgreSQL). Any way... we have noticed that if you paste anything into the Description field, such as a paragraph and the paragraph has a carriage return in them, only the first line of the paragraph is pasted. If you removed the carriage returns, it will paste fine. Kind of a pain when you have 6-8 pages of transactions to invoice out and each transaction has a paragraph of text. Any recommendation on how to overcome this issue short writing a Perl script to remove carriage returns. Dieter might want to consider an interface with Request Tracker for importing data ;-). Regards, Mike Bush -- Digital Minds International http://www.DigitalMinds.net Tel: 615-661-7900 Fax: 615-661-7949 |
|
From: Dieter S. <dsi...@sq...> - 2001-07-16 16:53:11
|
The prevent the lines after the carriage return from disappearing change the description field to a textarea. Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Sun, 15 Jul 2001, Michael Bush wrote: > Hey Everyone: > > My company uses SQL-Ledger for billing consulting time and we like to > include details of what work was performed. We have implemented a request > tracking system called Request Tracker (great program! > http://www.fsck.com/projects/rt/features.html The new version supports > PostgreSQL). Any way... we have noticed that if you paste anything into the > Description field, such as a paragraph and the paragraph has a carriage > return in them, only the first line of the paragraph is pasted. If you > removed the carriage returns, it will paste fine. Kind of a pain when you > have 6-8 pages of transactions to invoice out and each transaction has a > paragraph of text. > > Any recommendation on how to overcome this issue short writing a Perl > script to remove carriage returns. Dieter might want to consider an > interface with Request Tracker for importing data ;-). > > Regards, > > Mike Bush > |
|
From: Michael B. <Mi...@di...> - 2001-07-17 02:49:20
|
Hey Dieter: When posting receipts today, we got the following error message: Error! ERROR: parser: parse error at or near ")" UPDATE acc_trans SET chart_id = (SELECT id FROM chart WHERE accno = 1061), amount = -73.17, transdate = '04/29/2001' WHERE trans_id = 10338 AND chart_id = (SELECT id FROM chart WHERE accno = ) Any idea on how to correct this? Regards, Mike Bush -- Digital Minds International http://www.DigitalMinds.net Tel: 615-661-7900 Fax: 615-661-7949 |
|
From: Dieter S. <dsi...@sq...> - 2001-07-17 03:12:45
|
Yes, you have the wrong version. I announced this a few days ago. I accidentally tarred up 1.5 Install version 1.4.12 Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Mon, 16 Jul 2001, Michael Bush wrote: > Hey Dieter: > > When posting receipts today, we got the following error message: > > Error! > ERROR: parser: parse error at or near ")" UPDATE acc_trans SET chart_id = > (SELECT id FROM chart WHERE accno = 1061), amount = -73.17, transdate > = '04/29/2001' WHERE trans_id = 10338 AND chart_id = (SELECT id FROM chart > WHERE accno = ) > > Any idea on how to correct this? > > Regards, > > Mike Bush > |
|
From: Michael B. <Mi...@di...> - 2001-07-23 02:58:59
|
Hi Dieter: What are the downsides of changing the Description field from text to textarea? If ok, how would you recommend making the change? Regards, Mike Bush -- Digital Minds International http://www.DigitalMinds.net Tel: 615-661-7900 Fax: 615-661-7949 > The prevent the lines after the carriage return from disappearing > change the description field to a textarea. > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sun, 15 Jul 2001, Michael Bush wrote: > >> Hey Everyone: >> >> My company uses SQL-Ledger for billing consulting time and we like to >> include details of what work was performed. We have implemented a >> request tracking system called Request Tracker (great program! >> http://www.fsck.com/projects/rt/features.html The new version >> supports PostgreSQL). Any way... we have noticed that if you paste >> anything into the >> Description field, such as a paragraph and the paragraph has a >> carriage >> return in them, only the first line of the paragraph is pasted. If >> you removed the carriage returns, it will paste fine. Kind of a pain >> when you have 6-8 pages of transactions to invoice out and each >> transaction has a paragraph of text. >> >> Any recommendation on how to overcome this issue short writing a Perl >> script to remove carriage returns. Dieter might want to consider an >> interface with Request Tracker for importing data ;-). >> >> Regards, >> >> Mike Bush >> |
|
From: Dieter S. <dsi...@sq...> - 2001-07-23 15:27:45
|
Hi Mike!
Instead of
<input name="description_$i" value=$form->{"description_$i"} size=35>
you use
<textarea name="description_$i" rows=2 cols=35 nowrap>
$form->{"description_$i"}
</textarea>
You can use any html tags in the text to control how it will look like on
the invoice.
I would also adjust the rows to the number of lines the text will take up
in a 35 character column space and expand and shrink the field
dynamically.
The description field is a text field and can hold about 8k of data.
Dieter Simader http://www.sql-ledger.org (780) 472-8161
DWS Systems Inc. Accounting Software Fax: 478-5281
=========== On a clear disk you can seek forever ===========
On Sun, 22 Jul 2001, Michael Bush wrote:
> Hi Dieter:
>
> What are the downsides of changing the Description field from text to
> textarea? If ok, how would you recommend making the change?
>
> Regards,
>
> Mike Bush
>
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X