Wednesday, July 20, 2011

Insert XML examples in a blog

When I wrote the previous blog, I encountered a small problem. How to insert an example of my XML file in the blog. I'm using the Notepad function Edit-Replace. First I've replaced the symbol < on &lt;




Then, I've replaced the symbol > on &gt;.




After that, I've copy pasted the new text in my blog.

Tuesday, July 19, 2011

HTTPS in Google Application Engine

Now I'm playing with Google Application Engine.GAE is a terrific tool for learning requires. If you want to work with your application via HTTPS simple add the next lines to web.xml:
<security-constraint>
<web-resource-collection>
<web-resource-name>all</web-resource-name>
<url-pattern>/*</url-pattern>
</web-resource-collection>
<user-data-constraint>
<transport-guarantee>CONFIDENTIAL</transport-guarantee>
</user-data-constraint>
</security-constraint>

You do not need to buy a certificate and not need to configure anything.

Sunday, April 10, 2011

MySQL and ADO

I am getting this error message in VB6 with MySQL

-2147217864 Row cannot be located for updating. Some values may have been changed since it was last read.
I've opened recordset and change some fields . Then I tried to update recordset and had the error message
Set rsCt = New Recordset
rsCt.CursorLocation = adUseClient
rsCt.open SQLstring, mConn, adOpenStatic, adLockOptimistic
rsCt!OrderNumber = pbOrderNumber
rsCt!CustomerID = custID
rsCt.Update

I spent several hours searching for a solution. Changed primary keys in my tables,used different options in rsCt.Open . And eventually found a small message on forum.mysql.com


Open properties fo your DNS (Windows XP: Control Panel->Administrative Tools->Data Sources) and find option Return Matching Rows (turn it on).

Also, you can do this under connection string specity parameter OPTION=2.

This should work...

Osman :D

I added to my connection string option=2

ConnectionString = "driver={MySQL ODBC 5.1 Driver};option=2,server=" & mySqlIP & ";uid=" & usr_id & ";pwd=" & pass & ";database=" & Database

Finally the problem is solved. Thanks Osman!!!

Friday, January 28, 2011

Barcode inventory system

It is not so difficult to do for your business an inventory system with bar codes. Golden Inventory is a barcode inventory system.The inventory accounting system can help you to improve the manageability of your warehouses and the company.See an example of designing inventory system and create own system for your business. You can make a warehouse inventory system either a point of sales and inventory system .

Your own online inventory system.

You can create a modern own online inventory system using .net inventory source code You get complete ASP.NET source code of the system for a relatively small fee. You can adapt the inventory system for your business and gain maximum effect with small investments.You read more about online inventory system and make the right decision.

Thursday, January 20, 2011

What do we want from inventory software?

It's a typical request from my client about inventory software
It seems that your basic inventory program will provide all the information needed by my business but the methods of performing all the tasks is beyond my intuitive capacity. My business needs a rather simple point of sale program that would maintain an inventory.

Primary need for business management:

  • Create Sales Receipt
  • Create Sales Receipt with Labor being a variable amount.
  • Create Sales Receipt with taxable and non taxable items. ie. Labor, resale exempt
    Create Sales Receipt for a Special Customer Order of a inventory or non inventory items showing the customer’s deposit and balance.
  • Create Special Order Receipt with customers name and phone number and be able to retain, recall and update the infromation when item is delivered
  • Create Sales Receipt for items that are not in inventory on the fly.
  • Create Sales Receipt and automacally adjust inventory quantity.
  • Create Sales Receipt with several terms of sale printed on it. "3 Day Retutn"
  • Create Sales Receipt and add a special note or instructions.
    Ability to search and review special orders or open sales receipts by customer or invoice number.
  • Allow for inventory anjustment, quantity and pricing.
  • Maintain a list of manufacturers or supplies.
  • Maintain a list of customer information for some, not all sales.
  • Would like a daily and monthly sales reconcilliation.

I have been working with your inventory software as downloaded and find many things quite easy. The inventory and sale of inventoried items seem just fine. I have had trouble understanding or finding how to preform the following:

Making items taxable or not on a given sale receipt.

How can I make up a labor ticket which allows for non taxable labor and taxable parts?

How can I make up a labor ticket that retains the customer name and phone number and allows for updating with the addition of parts utilized and then provide a sales receipt?

How do I take a deposit on a special order of an inventory or non inventory item, then then update the transaction when the items is picked up and provide a sales receipt?

How do I set up a group of special terms of sale to appear on all sales receipts?
We usually answered that our inventory software can make all these functions and clarify how it works.

You can use our Golden Inventory system. You can use Invoices and
Sales Receipts
for tracking you sales. If you sell items for cash you
use sales receipts if you want to track customer payments and balances
you should use invoices. Sales receipts don't change customers
balance.

You can add in the items list inventory and non-inventory part for
labor.Set the option "Non stock" for labor. You can set the option Tax
Invoice for any item.

Create a new invoice and select a cusomer in the drop down list. If
it's the new customer enter his name in the field customer. Click the
button Items and select inventory parts and labor. Click the button
Enter and close the items list. You can change quantity for any item
and change the Taxable. If you don't have any item in the item list
you can enter it in the invoice detail section and program will add
it to the items list after saving your invoice. You can use the button
"Paid" for entering a customers deposit.

The inventory system keeps all customers in the special table.
You can view it in the left menu Lists the Items ,Customers and
Vendors lists. The program has the Adjustment and Report functions.
Golden inventory decrease quantity on hand for items when you create
invoice or sales receipts.


You can use Sales Orders for your labor tickets. Than, you'll be able
to create a new sales receipt or invoice and download all information
from this Sales Order. Use the small button near the field Sales
Order No.

You can use the field Status in invoices and sales receipts. The
inventor system calculates only approved documents.
All documents has the field Group below the field Comments.

Monday, January 3, 2011

Free Excel Invoice template

If you are just starting your business and do not have enough spare cash to buy any inventory system, you can use free utilities. For example, the free invoice template for MS Excel.Download the free Excel invoice template. Open the invoice template in Microsoft Excel.Unprotect the Invoice worksheet. The Invoice worksheet is protected to avoid accidental damage formulas and fixed cells. To unprotect it, in Excel 2000/XP/2003 click Excel menu Tools -> Protection -> Unprotect Sheet, or in Excel 2007/2010 click Review tab -> Changes group -> Unprotect Sheet. Enter your company name and address. Then protect the sheet again. After that, you'll be able to fill out your invoices and print them for your customers. Excel will automatically calculate line totals,taxes and grand total for each your invoice.