Print Page | Close Window

Syntax error 3144, how to solve?

Printed From: Almyta Systems
Category: Almyta Control System (ACS) and ABC Inventory
Forum Name: Inventory Control
Forum Discription: Inventory operations
URL: http://www.almyta.com/forum/forum_posts.asp?TID=67
Printed Date: 27 Oct 2020 at 11:25pm
Software Version: Web Wiz Forums 10 - http://www.webwizforums.com


Topic: Syntax error 3144, how to solve?
Posted By: Marciunas
Subject: Syntax error 3144, how to solve?
Date Posted: 30 Nov 2011 at 6:38am
Hello,

i cannot recalculate cost in currencies tab, when I try message pops out:

Syntax error in UPDATE statement. Error code 3144.

any ideas how to deal with it?

Thanks.



Replies:
Posted By: BillD
Date Posted: 30 Nov 2011 at 8:09am
This problem has been fixed. Use Help/Download Updates to install latest software. v. 3.12.24 or later.


Posted By: Marciunas
Date Posted: 02 Dec 2011 at 10:17am
Thank you BillD.

Another thing. I'm ussing currencies conversions. And when creating order in defoult  currency, deffoult currency total is calculated ok, but if choosing alternative currencie i getting #div/0!

Where is my mistake?


Posted By: BillD
Date Posted: 02 Dec 2011 at 10:48am
Open the System/Company Locations/Countries and Currencies screen.
 
Make sure there are no zeros in the Conversion column for the selected (USE is ON) currencies.
 
See this post on how to configure this screen.
 
http://almyta.com/forum/forum_posts.asp?TID=52&PID=177#177" rel="nofollow - http://almyta.com/forum/forum_posts.asp?TID=52&PID=177#177


Posted By: Marciunas
Date Posted: 08 Dec 2011 at 9:46am
That's a thing there are no zero's in currencie conversions screen, and I use only two currencies.

Could it be something else?


Posted By: BillD
Date Posted: 08 Dec 2011 at 6:42pm
It is a purchase order or sales order?


Posted By: Marciunas
Date Posted: 09 Dec 2011 at 3:40am
Ye, it is purchase order and it looks like this:




Posted By: BillD
Date Posted: 12 Dec 2011 at 12:14pm
this is an issue with your number formats 0,00. Thank you for reporting it. It will be adjusted in a day or two. Check for new updates in the Help menu. It will be version 3.12.25


Posted By: rahattrading
Date Posted: 06 May 2016 at 2:11pm
when i open sale point and enter my item id and hit the enter button gove me the error syntex 3144 update statment i has also checked the updates tell your software already up to date.

please help if delet the softwate and reinstall so i will pay again because i has already paid 49$ for sbs.


Posted By: Debra
Date Posted: 09 May 2016 at 11:56am

There is no need to reinstall anything. If you paid for the license, you cannot lose it. We will even give you the keys if you misplace them.

1) does it happen for this specific Item or for any one?

2) If for all, did you import your Inventory Items?  




Print Page | Close Window

Forum Software by Web Wiz Forums® version 10 - http://www.webwizforums.com
Copyright ©2001-2011 Web Wiz Ltd. - http://www.webwiz.co.uk