Easier way of making an Invoice Form (screen)

[EzLogic]

Hi Everyone. I don't have a problem, rather it is a queston on refining my form.

I have designed a POS application about a year ago. It is now being used over 40 locations nationwide and it is all going very very well.

In the POS, I have desgined an Invoice Entry Screen.
The Invoice Screen is designed as such:

I use a ListBox with a TextBox for the SKU. The reason I do that is:
My Inventory is serialized. Meaning, a user, can either sell 'regular' items or skus. Or scan the serial of the sku. (2 different tables). Also, I have many conditions before accepting the sku in the listbox, such as price, minimum price, wholesale price, etc..etc.. depending on the account number, agent number, or cash/walk-in account.

So, in the listbox I have the click event to change QTY/Price. And in the Update Button, i have to check the Input price vs. the Minimum price allowed, etc..etc.. etc..

Well, I see many people have their invoices in a grid format. I tried to do it in a Grid, but, there are many many conditions, that I cannot seem to fit in a grid. Like Removing an Item, Updating Prices (based on criteria), Updating or Freezing the QTY depending on if it is a serilized item or not. etc.. etc..

What are you thoughts. How did you do your Invoice screen. Is it as complicated as mine?

thanks for all your feedbacks.


Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[ramani]

HI

I dont know how it is done by you using a listbox, because I am unable to visualise how you accept data.

I am doing invoices screen, using grid to have.. itemcode picked up from yet another search grid if required, accept qty.. can be boxes, pieces, sets whatever (each item can have these types of units.. say.. Coke.. by CTNS, pieces, carry-bags whatever), based on unit type prices.. prices can be per piece, per ctn or the pack unit, prices can vary in cash counter or at desk where credit sales for wholesale, discounts at varing rates.. by line item or at the bottom of invoice.. can be discount % or as bulk to adjust by rounding.. can be group sales.. buy five get one free types.. and such complications.

There are cases where invoice done from HO and issues from store1 or store2 or a combination of such locations.

I use grid comfortably and provide color codes of light red for invalid entries and red for unacceptable price/qty as the entry proceeds. Then validation I do before processing and accepting the invoice.



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[EzLogic]

Ramani, thanks for the reply.

I have a text box, and in the Keypress event. I do most of the validation and then if all is clear, I use the AddItem, or AddListItem event to add to the list.

here's how my invoice screen looks like.

http://www.boxingaddicts.com/inv.jpg

Please let me know what you think



Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan

 

[EzLogic]

Ramani, how do you manage the Grid? by a cursor? or is it directly tied to a table?

Ali Koumaiha
TeknoSoft Inc
Farmington Hills, Michigan