Seeking assistance from the A5 gurus.
I have a POS software that I've been developing over the past 5 years, and I still can't find a method of adding new records to my invoices without a noticeable delay.
for much of this time, I thought the delay was related to the querying of the desired product after scanning. Now, I realize that the query is run fast enough to be considered acceptable. The real delay is, the time it takes to add a new record to the "Invoice Items" table and post the data to it from the "Products" table. Below is the code I'm using:
Invoice form is based on a set comprising of:
"Invoice Header" table
"Invoice Items" table
other tables like: Company, Customers, etc.
Form name: POS
Invoice Items browse: Invoice_items_b
:POS:Invoice_items_b.new_record()
:POS:Product_id.value = eval("products->Product_Id")
:POS:Item_num.value = eval("products->Item_Num")
:POS:Price.value = eval("products->Un_Price")
:POS:Pricewithtax.value = eval("products->T_Price")
:POS:QUANTITY.Value = eval("If(Var->vReturnMode = .F., 1, -1)")
:POS:Qty_before.value = eval("products->Qty_Onhand")
:POS:Invoiceitems_dept_id.value = eval("products->Dept_Id")
:POS:Invoiceitems_department.value = eval("products->Department")
:POS:Invoiceitems_shift_id.value = eval("Var->Current_Shift")
:POS:Invoiceitems_cashier_id.value = eval("user_name()")
:POS:SOLD_FROM.Value = "Shelf"
:POS:Invoiceitems_date.value = eval("date()")
:POS:Invoiceitems_time.value = eval("Now()")
:POS:Invoiceitems_status.value = eval("'Open'")
:POS:Invoiceitems_company_id.value = eval("'0'")
Basically, each time a product is scanned, or manually entered by the cashier, the "Product_Lookup" form query the desired product, once found, a new record is added to the invoice and the above info is added to this new record before the software waits for further instructions from the cashier.
The time it takes to complete the process is always longer than the time it takes the cashier to put the product down, pick up the next product and scan it. When I go to other stores, I see their softwares move faster than the cahier, but, my cashier is always waiting on my software to complete.
Help please!!!!!
I have a POS software that I've been developing over the past 5 years, and I still can't find a method of adding new records to my invoices without a noticeable delay.
for much of this time, I thought the delay was related to the querying of the desired product after scanning. Now, I realize that the query is run fast enough to be considered acceptable. The real delay is, the time it takes to add a new record to the "Invoice Items" table and post the data to it from the "Products" table. Below is the code I'm using:
Invoice form is based on a set comprising of:
"Invoice Header" table
"Invoice Items" table
other tables like: Company, Customers, etc.
Form name: POS
Invoice Items browse: Invoice_items_b
:POS:Invoice_items_b.new_record()
:POS:Product_id.value = eval("products->Product_Id")
:POS:Item_num.value = eval("products->Item_Num")
:POS:Price.value = eval("products->Un_Price")
:POS:Pricewithtax.value = eval("products->T_Price")
:POS:QUANTITY.Value = eval("If(Var->vReturnMode = .F., 1, -1)")
:POS:Qty_before.value = eval("products->Qty_Onhand")
:POS:Invoiceitems_dept_id.value = eval("products->Dept_Id")
:POS:Invoiceitems_department.value = eval("products->Department")
:POS:Invoiceitems_shift_id.value = eval("Var->Current_Shift")
:POS:Invoiceitems_cashier_id.value = eval("user_name()")
:POS:SOLD_FROM.Value = "Shelf"
:POS:Invoiceitems_date.value = eval("date()")
:POS:Invoiceitems_time.value = eval("Now()")
:POS:Invoiceitems_status.value = eval("'Open'")
:POS:Invoiceitems_company_id.value = eval("'0'")
Basically, each time a product is scanned, or manually entered by the cashier, the "Product_Lookup" form query the desired product, once found, a new record is added to the invoice and the above info is added to this new record before the software waits for further instructions from the cashier.
The time it takes to complete the process is always longer than the time it takes the cashier to put the product down, pick up the next product and scan it. When I go to other stores, I see their softwares move faster than the cahier, but, my cashier is always waiting on my software to complete.
Help please!!!!!
Comment