Ultimate POS - Best Advanced Stock Management, Point of Sale & Invoicing application

Ultimate POS - Best Advanced Stock Management, Point of Sale & Invoicing application v6.6 – Untouched

No permission to download

hellboy9211

Well-known member
Null Master
Trusted Uploader
Apr 11, 2021
300
425
63
Hell
Thanks for your reply, but it doesn't appear in the sale returns
Yes that's true.. Even if u make sales return the amount doesn't get added back into clients funds.. Even their is no option for credit note..
 

Lexharden_01

New member
Jul 12, 2022
12
3
3
I had the script working successfully in a saas way.
But I have a user who uses it for electronic equipment repair and has 5 locations.
But I was seeing that a lot of information was generated in my database. I was seeing that this information is more than anything for the profit and loss reports. Do you know if it's normal?
It has more than 24 million rows and almost 2.5 GB
It takes me a long time to load and consumes a lot of CPU.
Help please! :(
1664950792963.png
 

hellboy9211

Well-known member
Null Master
Trusted Uploader
Apr 11, 2021
300
425
63
Hell
I had the script working successfully in a saas way.
But I have a user who uses it for electronic equipment repair and has 5 locations.
But I was seeing that a lot of information was generated in my database. I was seeing that this information is more than anything for the profit and loss reports. Do you know if it's normal?
It has more than 24 million rows and almost 2.5 GB
It takes me a long time to load and consumes a lot of CPU.
Help please! :(
1664950792963.png
nope for few other users and me..its far too low .. can u tell e how many transactions have you made .. total sales and purchases.. bills n invoices
 

jocani19

Active member
Jun 4, 2022
117
63
28
I had the script working successfully in a saas way.
But I have a user who uses it for electronic equipment repair and has 5 locations.
But I was seeing that a lot of information was generated in my database. I was seeing that this information is more than anything for the profit and loss reports. Do you know if it's normal?
It has more than 24 million rows and almost 2.5 GB
It takes me a long time to load and consumes a lot of CPU.
Help please! :(
1664950792963.png
Hi, i had the same problem look the image.... I dont know why suddenly in one purchase the app begin to insert rows in transaction_sell_lines_purchases_lines... It was strange

I had to stop and try to identified the real data betwween transaction & transaction_sell_lines_purchases_lines


If you can see the image there was a jump in the table...

In my case the only problem it was a PC very slow with internet.... I formatted this PC ... But it was strange... Until know i dont have the cause root... :(
1665001559864.png
 

tang_mag

Active member
Sep 9, 2019
112
74
28
Hi, i had the same problem look the image.... I dont know why suddenly in one purchase the app begin to insert rows in transaction_sell_lines_purchases_lines... It was strange

I had to stop and try to identified the real data betwween transaction & transaction_sell_lines_purchases_lines


If you can see the image there was a jump in the table...

In my case the only problem it was a PC very slow with internet.... I formatted this PC ... But it was strange... Until know i dont have the cause root... :(
1665001559864.png
that's strange, looks like a bad query
 

jocani19

Active member
Jun 4, 2022
117
63
28
that's strange, looks like a bad query
I am not sure...
The only that i know is that it was in one purchase ... I seems like a loop in the thread in the connection to internet...
But every day i check the database size ... (Specialy both tables)
 

Lexharden_01

New member
Jul 12, 2022
12
3
3
nope for few other users and me..its far too low .. can u tell e how many transactions have you made .. total sales and purchases.. bills n invoices
With all the users I have, approximately 20 - 25k sales have been made.
I found this in the script comments.
it is worth mentioning that i have it in the cloud with Digital ocean and I am using it as SaaS
I understand that in the patch the "TransactionUtil.php" is updated, which is the one that normally makes these queries
1665025226058.png
 
Last edited:

About us

  • Our community has been around for many years and pride ourselves on offering unbiased, critical discussion among people of all different backgrounds. We are working every day to make sure our community is one of the best.

Quick Navigation

User Menu