Hello,
I am using sambapos V5, with default installation and settings. I have installed SQL Server Management studio and would like to run and insert some queries into the sambapos database.
I don’t know the credentials (username & password ) & what to write in the server name.
Thank you in advance,
I was able to connect to it with the following settings:
It brings me to my next main issue, we need to create a trigger on your invoice table in which you are storing details of invoice mainly total amount, GST , Invoice number and invoice date. What is the invoice table name in sambapos DB?
By invoice you mean ticket?
Total amount and tax are in separate tables.
Maybe if you explain what you end goal is we can suggest a better solution and direct SQL manipulation is not reconmended…
I need the names of all the tables in sambspos which store the following information:
I have created another table which shall collect only all the above information and provide it in a automatic report for taxation purposes.
So I’ll ask the SAME question, WHAT DO YOU MEAN BY INVOICE?
There is nothing in samba by default called invoice…
I guess you mean TICKETS.
Also you didn’t really answer my question, why are you creating a new table with duplicate information?
All of that information would be very easy to report and export using the reports in samba, do not understand why you want to manual pull from database and make new table when samba already has reports/export which would give you those 4 sets of info for tickets in a one line report…
All of that information can be pulled and put in a report using the built in custom report feature of Sambapos. There is no need to alter the database.
The information shall be retrieved automatically by the tax authorities automatically. Basically they will connect to the new table created and retrieve the information required and have it in there own database. This way we don’t have to file for tax as they will have it automatically. This is a government requirement in our country.
Yes the information is in Tickets, how ever, i cant give them access to our POS and come everyday to view the reports in Sambapos. From a Database perspective everything is in tables hence why i used the word tables and not Tickets 
You can have it automatically email the report to them. Or use GQL to post it to a webpage or something else. There are many options other than altering the database. Anyway that information is found in the dbo.Tickets table and GST is stored as Transactions dbo.Transactions
You will need to use SQL to match the keys and derive the data you need. Not everything is stored as its own table. Again it would be better to use Custom reports and send it to them.
Have you try this string yet?
(localdb)MSSQLLocalDB
I used this string to solve one of the machine that I have problem connecting using many suggestions from the forum before.
Plus I also DL and installed the latest SSMS which I believe is either 17.4 or 17.5
Just about 2 months, the SSMS I DL cannot install in the machine I was talking about.