adding sales history

I have started working with qsrules in the vb.net enviroment. I am trying to load sales history from another pos system. I found this code on this site and started working with it. It seems to write to the batch tbl but can not seem to get it to work on the transaction tbls. How do i go about tendering this? what is missing? thanks

Dim sess As New QSRules.SessionClass Dim cnn As New QSRules.ConnectionInfoClass cnn.RegisterNumber = 1 cnn.Provider = "SQLOLEDB.1" cnn.UserID = "uid" cnn.Password = "pwd" cnn.InitialCatalog = "s301" cnn.DataSource = "server" cnn.ConnectTimeout = 30 sess.Database.OpenConnection(cnn, False)

Dim r As QSRules.StatusCategoryEnum = sess.Build(1, True) sess.License.MarkAsRegistered()

Dim currBatch As QSRules.Batch = sess.Register.Batch currBatch.MakeNewBatch(False, 0) sess.InitializeTransaction() sess.Transaction.SetCustomer(12, False) sess.Transaction.Entries.Add(1, "01Z97", 5.0, 5.0, False, 0.0)

sess.Transaction.Post(3250, Now(), False)

sess.Database.UpdateRegister(1, True, currBatch.BatchNumber) sess.Database.CloseBatch(currBatch.BatchNumber)

Reply to
MarkD
Loading thread data ...

Reply to
MarkD

good luck ^_^

the tender process .. With sess.Transaction .Tenders(1).AmountIn = [value] End With

I'm not sure of this code.. Please get documentation about tender entry..

You have another bug into your code.. you must call Login method for set transaction cashier..

bye bye antonio

Reply to
Antonio Mazzeo

Reply to
MarkD

In the past I tried to write a custom-software that get transaction from two italian software into RMS. The process to post data into RMS is simple, the problem is to reproduce all discounts method unsupported from RMS (and the round off! ^_^).

bye antonio

Reply to
Antonio Mazzeo

Well I finally got them to post to the database. I had to disable the print receipt in Register properties, I was running from a workstation and did not have the proper drivers. I think now its just a matter of mapping the fields between the two systems(hopefully). thank you for your help.

"Ant> MarkD wrote:

Reply to
MarkD

Today I'm in train... tomorrow morning If nobody reply to your question..

bye antonio

Reply to
Antonio Mazzeo

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.