|
for all your web site needs ... customised website designers, developers & programmers on Sydney's northern beaches |
|
|||
|
Tnet - timber yard softwareTnet - an invoicing and ordering system for the timber industry. This system handles lineal metre stock and has stock control. It can interface with MYOB to export finished invoices into MYOB. The system has extensive reporting and is very powerful. Click here for a copy of the downloadable demo ...
Broad Specification: Tnet is written in Microsoft .net. It's main purpose is to handle all timber in and out of the yard. Tnet will capture customer quote, order and invoice data, orders from suppliers and handle the associated stock levels. Full details will be stored in XML files and summary data will be saved into MYOB export files. The system will use enhanced MYOB customer data (originally exported from MYOB), will lookup product data from timber and hardware XML files, calculate GST, totals, allow a discount and enable price changes of line items before saving the details in XML. The system will also capture payment details against individual invoices and print statements for a selected period (usually a month). As part of the statement payment process, the system will generate credit notes for the calculated discount available to account customers. Payments against the statement invoices will be stored against each invoice as payment details, together with the discount amount which represents the credit note. The system will store the following data:
The system will have security and will have user groups of administrators and users. The administrators will have full access to the system, and users will have limited access. Additional users can be allocated by administrators. The system will support 3 printers – a laser jet, dot matrix and docket printer. The system will also use 2 bar code scanners (for customer cards and hardware items) and a cash drawer. The system will be menu driven starting with a main menu from which selections can be made. The options available will be:
Under the Report’s Menu are these items:
Under the Administrator’s Menu are these items:
Customer Quotes, Orders, Invoices and Receipts – description of program flow: Select the transaction type: Quote, order or invoice. Then select the customer (from list or by scanning a customer number bar code). Then select whether it’s new or existing. If it’s new, the customer name and address is then displayed together with the next transaction number and today’s date. If it’s existing, select the transaction number from the list. Customer details for the transaction are displayed on the left of the screen and include customer name and address, transaction number, date, purchase order number, terms and details. If doing an order or invoice for delivery, the operator can click the delivery button (pickup is the default) and delivery address and instructions can be entered. A nominal delivery charge of $15 is added. The operator can select a delivery fee based on area or suburb (this is stored in the delivery fee list). Since the majority of products will be timber, the default for the product list will be timber. The timber product list can be selected by description or stock code. Hardware items will be selected by typing in the full stock code or by clicking on the barcode field and using the scanner against the barcode. Another method of selecting a product is via a separate screen where the operator can select by keyword or step through the categories. Once a product has been nominated, it is added to the transaction screen and the operator can proceed with the transaction details. Also, special items may be added by typing in the stock code. These items don’t have to belong to the stock list, so the operator can provide the quantity and cost. When a product item is selected, a window will open allowing the operator to type the quantities. Most will have the quantities in the form of No. of pieces and Length, but some items will have just the number of pieces entered (eg Sets, Sheets, Doors, Bundles, etc.). Many items with different number of pieces and different lengths for the same product can be added to the quantity box. If the pieces is 1, then the operator may click on the lineal check box to indicate lineal metres have been purchased rather than a certain number of pieces. This will show as lm on the invoice. When the operator clicks the add button, these line items will be added to the transaction and the quantities are calculated then multiplied by the rate, giving the line item totals. The transaction total and GST are automatically calculated as line items are added. An optional discount percentage or discount dollar value can be applied to the invoice total. The discount percentage will only be applied to those line items which have discount allowed. Additionally a final total figure can be entered which can be used as a rounding adjustment or special discount. For example, if the total with GST amounts to $224.45 and the operator would like to round the figure to $220, the program adjusts the total to $220 and applies the rounding difference as a special discount dollar value, recalculating the GST in the process. Orders/Invoices can be paid for in part or full at the time of purchase by clicking the receipts button. The operator may enter the date paid, amount, method of payment, payer, card number and expiry date. Many payment lines can be added for one invoice. The total payment figure is added to the bottom of the invoice and a balance is displayed. A docket invoice may be printed, showing the amount paid. Quotes can be converted to orders/invoices and orders can be converted to invoices. This avoids the need to retype all the transaction details and provides a basic transaction which can be modified. Quotes and orders can be modified and saved many times, but invoices cannot be altered once they are posted Existing transaction data can be reprinted at any time. The transaction can be printed in full on the dot matrix printer, as a docket with receipt details on the docket printer, as a delivery/pickup docket or as a picking slip. See the list of reports for further options. The system also stores a timber stock item history to keep track of the various suppliers from whom the item was purchased and the respective prices. The fields stored are date, supplier, stock code, purchase order number, cost and quantity. See the list of reports for printing options. Summary In summary the system will generate a detailed transaction with product line items, print it, then save the summary invoice data into an XML file. Invoice data will decrement the stock file and supplier orders will increment the stock file. Any time that a transaction needs to be reprinted, it can be done from the XML file details. The transaction data will be posted to MYOB periodically in a batch format.Cost The basic cost of the system is $3,500. The system would need to be customised with your logo and company details. This starts at $500, depending on the level of customisation. |
|
||||||||||||||||
Email to Friend