Feature Request/Lengthly Ramblings/Request for Comments

[David R. <dr...@su...>]

Now that we've been using sql-ledger more heavily, I noticed some quirks in 
user-behavior (yes PEOPLE are the idiots - not the program) and I thought 
others might have the same interests...

Before I go off on too much of a tangent making unnecessary software 
modifications, I thought I might solicit other folks thoughts on these 
ideas.... there might be easier solutions ;)

1. DECIMAL PLACE DEPTH - I have a number of items that are sold in fractional 
cents, 5000 pcs @ $0.0022 etc. I changed the sprintf %.2d to %.4d in the 
format_amount function, but I have noticed that I get different totals when I 
print out a form - v.s. the total indicated at the bottom of the invoice 
screen, I don't have that one figured out yet. But anyway, it might be useful 
to others to have in the setup screen an option for number of decimals.

Some folks have suggested in the past to change units to a larger unit (i.e. 
pack/100), however since I manufacture a product, I have to keep UOM=1 since 
the item is purchased and consumed in that unit.

2. MAKE MODEL LOOKUPS to locate part numbers. With the current (great) design 
a part number can have associated makemodel rows with it, such that:
	TOPLEVEL PART NUMBER
		ACCEPTABLE PART 1
		ACCEPTABLE PART 2
When entering an invoice, I need a point in the right direction so that I can 
either enter the toplevel part number into a sales order/invoice/bill of 
materials, OR one of the acceptable parts and have it relate to the toplevel 
part number automatically.

This of course opens a whole can of worms - on a Purchase Order for example 
it might be beneficial to display the specific vendor's part number rather 
than MY part number because they may be very different. Example:
I have a part I call PLCC84-SN-NL which is an 84 pin PLCC socket, with tin 
plated contacts, and no locating pegs..

One manufacturer (Amphenol) Calls it an 822281-1
Another (Berg) Calls it PLCC84P-T-SMT

When I purchase the part, my PO needs to say 822281-1 when I buy it from AMP, 
and PLCC84P-T-SMT when purchasing from BERG

But, when we receive the item into stock we need to somehow know that its a 
PLCC84-SN-NL. This might not be an issue if the "Merchandise Received" screen 
also translates the vendor part numbers.

Of course when a pick list is printed, it needs to show our part number.

3. LOGICAL FIELDS TO INDICATE "PRINTED" OR "EMAILED" For any form - Vendor 
invoice, purchase order, sales order, etc. It might be nice to have a logical 
database field for "Printed" or "Emailed" -- this comes from entering a PO or 
such and saving it, (and later my cheeze brain can't remember If I ever sent 
it to the vendor ;) WHOOPS!

This could also be used in the event that you sent an invoice, quote, etc via 
email.. then for some reason updated and saved the quote. The system could 
check to see that it has been previously sent via email and ask if an updated 
copy should be transmitted as well. 

4. AUTOMATIC SAVE ON PRINT/EMAIL Also related to printing/emailing 
invoices... what if printing or emailing invoices/etc also automatically 
saved the record.... to prevent forgetting to post a customer invoice for 
example when writing up their pick ticket.

=================
Any thoughts/tips on how to accomplish such would be appreciated
If anyone is interested when I am done, I can post or submit for inclusion in 
another release.

Thanks,
David Ratte
Superior Circuit Technologies, Inc.
dr...@su...
321-254-4201 x 204