How to start MySQL from the Mac OS-X Yosemite Terminal

Symptom: Gestix is working before the computer is shut down however. Once the computer is restarted, Gestix stops with the following message.

Gestix complains about the database system
Gestix complains about the database system
(It seems there is a problem with the database server. 
If the program was just working and you don’t know why this is happening, try reloading the page in a couple minutes. If the problem persists ask your system’s administrator attention to the problem.)

Although the MySQL Startup item seems to no longer work on OS-X 10.10, it’s possible to start it from the command line.

1. Open Finder | Applications | Utilities | Terminal

2. Paste this command and press Enter

sudo /usr/local/mysql/support-files/mysql.server start

3. Close the Terminal application.

If the problem persists there may be need for a remote technical intervention to the server by MySQL system specialists. Order technical support here.

Order processing: dealing with product assemblies

In some situations it can be handy to sell a set of items as an assembly instead of as discrete items. For example, a set including one table and six chairs would be defined as a unique product, having two items as its components: 1 x table and 6 x chair. In Gestix this is accomplished by defining the article type as a Kit/Package.

The price of the Kit/Package will be the sum of the components prices times their quantities. That prices can be predefined or left blank to make them being calculated at the order level and eventually select each item’s price from price list preferences for the involved customer or vendor.

erp-kit-package-assembly

Advantages compared to articles type Manufactured as Product:

  • Save operator time, inserting the kit/package into an order is similar to entering each and all of the components
  • Enable items to be sold both individually and as components of one or more aggregating items
  • Enable components to follow special price rules when used as part of a special product.

To add a new item as a kit/package proceed as follows.

Open the Articles menu, tap New Article.

Set manufactured as Kit/Package to define an assembly

Set Manufactured as Kit/Package.

kit-package-2

Enter description, and optional bar codes, prices and other relevant info.

kit-package-3

Press Save.

kit-package-4

Notice the link New Product Model – tap it to edit the item list. Open it and add the items to be included.

kit-package-composition

(In Gestix version 5.1.4 a small issue prevents the software from displaying the correct items list. Instead of using the Articles button, enter the exact item code to include the components from stock. This problem will be fixed in the next release of the software.)

kit-package-composition-finished

Unit prices can be defined in template or later on entering orders. Add each one of the components, editing unit prices or leaving them blank (zero) to assume order level pricing.

kit-package-composition-finished2

In this case the product model defines the prices to be used in this assembly.

Now, using this assembly item on a new order.

order-assembly-three-sets

Select our article from the list, and say we selling 3 sets, so enter 3 in the quantity field instead of 1.

order-assembly-three-sets2

Notice that the component quantities were multiplied by three because we said we were selling 3 sets.

In version 5.1.4, if the user edits lines of the components just after adding them to the order, they can get later be displayed in a different order. To circumvent this issue, save the order as Draft and then Modify it before editing lines involving the Kit/Package components. A fix will be released soon.

Check out gestix.com/go/support for downloads and cloud solutions

Can’t remember my Gestix password – how to recover it?

If you are using Gestix Cloud or Gestix SaaS, over the Internet, then you just have to contact the technical support by email and make your request (http://gestix.com/go/contact)

Recover password on a Gestix Download installation.

Since the software is installed on your computer, the recovery has to be performed from the operating system command line.

Open Finder / Applications / Terminal and issue the following command:

/usr/local/mysql/bin/mysql -u gestix gnet_db --execute="Insert into sys_users (usr_name,usr_code,usr_pw,usr_disabled,usr_priv) VALUES ('temporario','temporario','[ana[',0,1);"

Then enter in Gestix using the following information:

Login: temporario
Password: civic

Then you should go to the Admin | Users menu and change your password. Delete the temporario user account when done.

For personal support from our engineers please check our help desk service http://gestix.pt/go/suporte/on-demand

Yosemite beta program: read before trying it…

Updating the operating system on computers running as Gestix servers can cause problems to the Gestix system, which depends on MySQL and on Mac OS-X’s built-in webserver (usually Apache) to operate correctly.

Most important, make sure you have a fresh backup copy made at Gestix Admin menu, just in case you have to install Gestix from scratch.

You may have to install the last version of MySQL compatible with the version of the operating system. Check the MySQL site for information about any issue you may find.
When MySQL is working correctly and in the same conditions as before (same users/passwords) then reinstall Gestix – instructions in http://gestix.com/go/software-update.
Check details about the Mac OS-X version you are dealing with. Check if the built-in Apache webserver support has changed and configure it manually reproducing the previous configuration:
AddHandler cgi-script .cgi

Alias /gnet "/var/lib/gestix/www"

<Directory "/var/lib/gestix/www">
 Options None
 AllowOverride None
 Order allow,deny
 Allow from all
</Directory>

#ScriptAlias /gnet/cgi-bin "/var/lib/gestix/www/cgi-bin/"

<Directory /var/lib/gestix/www/cgi-bin>
 Options ExecCGI Includes FollowSymLinks
 AllowOverride None
 Order allow,deny
 Allow from all
</Directory>
When both MySQL and the webserver Apache are operational, install Gestix again, following the instruction for installing a Gestix software update (http://gestix.com/en/software-update or http://gestix.com/pt/software-update). Open Gestix from the menu and press Cmd+R to reload the page if needed.
Generally this will fix the configuration of both MySQL and Apache, however many factors may interfere.
 mac-osx-yosemite-is-beta-use-this
For personal assistance from an engineer you may activate a support ticket with your technical support provider (check available options at http://gestix.com/go/support/on-demand when needed).
macosx-yosemite

Billing for phone houses: tracking the cellphone number and IMEI

With Gestix Enterprise, you can enter the mobile phone number, IMEI, and other information, and perform any search on these details, to instantly access the customer record, invoice details, and all related information.

First we set Gestix up to input the IMEI along with the equipment Serial No, when entering a sale. On the menu Admin, Settings option Format of Numbers ensure IMEI/SIM CARD ID is selected.

Then you can tell Gestix to check user input according to one of the following options:

Behavior regarding duplicate serial numbers and serial numbers not in stock

Lower in the Gestix | Admin | Settings page, you can tell Gestix to behave in one of several ways regarding duplicate serial numbers and serial number that are not in stock.

Choose

No duplicates to make Gestix reject duplicated serial numbers, and to ensure the serial number is in stock when selling.

Duplicates to make Gestix allow duplicated serial numbers, yet ensuring the serial number is in stock when selling.

Relaxed/No duplicates to enable selling serial numbers that have not been previously entered into the system but still disallowing duplicated serial numbers.

Relaxed to enable selling serial numbers that have not been previously entered into the system, allowing duplicated serial numbers.

In our example we are using the Relaxed/No duplicates behavior so we can just enter the S/N and IMEI at the point of sale.

Tap Save at the bottom of the Settings page when done. Then, tap Back on the Admin menu to return to the main application menu. Open the Articles menu and open the iPhone XP product (or any other suitable product).

Select Serial Number option on the Product Traceability drop down menu.

Let’s try a sale.

Create a new invoice, choose the sample article and enter S/NO and IMEI
The sales ticket identifies the product to the customer, yet it can be personalized

Add a comment below for any questions or suggestions.

You enjoy working with the Gestix software and have some spare time? Join us abroad!

Do you utilize or have utilized Gestix?

Do you find it different and special?

Do you have experience and skills that could help others improve their usage of technology in their businesses or non-profits?

Do you have some spare time to work with us through our cloud infrastructure, from your home or business place?

We’re looking for people like you to join our international support team and help new Gestix users in exploring the software.

You’ll find that your knowledge is valuable to others, be it about business processes and procedures for those who are exploring the software, be it about computing skills to help those installing and setting up particular configurations.

So easy and comfortable on the cloud as it is on premises: Gestix ERP CRM applications.
So easy and comfortable on the cloud as it is on premises: Gestix ERP CRM applications.

Send your resume to jobs@gestix.com, and tell us some words about your experience and skills. We’ll get back to you immediately on a follow up.

Thank you.

Gestix Software

 

Sales Filter: define which logistical documents count as sales

Normally, Gestix considers all sales documents as sales. To select which documents are considered as sales and which document are not, on the Customers menu tap the Sales Filter button.

Tap the Sales Filter button to open the selection window
Tap the Sales Filter button to open the selection window

You are then able to specify which documents to consider by selecting/deselecting their series on this screen.

(Leave all blank to let Gestix automatically select the pertaining documents)
(Leave all blank to let Gestix automatically select the pertaining documents)

Either place a check mark in every document to be considered or leave all unchecked for enabling Gestix to select automatically all the sales documents.

(The same principle applies to suppliers/vendors accounts in Gestix, but concerning purchase documents instead of sales documents.)

News about the new release, Gestix 5.1.03

The new release of Gestix software, version 5.1.03, has several new features and improvements to dozens of others. These enhancements further enrich the new Gestix 2014 editions, being immediately available depending on the product. Older editions also benefit from correcting problems and some improvements in this version.

GTM-2622
Enable searching documents from dashboard by series, number, reference, etc

GTM-2624
Faster Consistency Check function

GTM-2620
Improved signed documents checker function

GTM-2614
Faster operation through optimized user session management

GTM-2547
Enable the user to choose which print layout to use on purchase orders

GTM-2542
Hierarchical selection of budget lines and billing purchases

GTM-2568
in batch printing menu is now possible to print the original, the duplicated or the triplicated of the document each one independently.

GTM-2621
Product traceability: RMA serial numbers were available for new sales

GTM-2597
When there is a receipt without a previous document when testing the saft file shows a warning similar to:

2. Payments [RCB 5] Related Document not available in text line with amount
4. Payments [RCB 5] Total amount must be positive

GTM-2596

New Gestix logos

GTM-2580
Editable Cost Estimates even after being printed

GTM-2573
Project costing report corrected regarding delivery memos and bills of works

GTM-2571
Monthly contract billing on specific day of the month

Planned for release on 2014-08-05.

Novidades da próxima release Gestix 5.1.03

A nova release do software Gestix, a versão 5.1.03, apresenta várias funcionalidades novas e melhoramentos em dezenas de outras. Estas melhorias enriquecem ainda mais as novas edições Gestix 2014, ficando de imediato disponíveis consoante o produto. As edições mais antigas também beneficiam da correção de problemas e de vários melhoramentos nesta versão.

Resumo

GTM-2622
Pesquisa de documentos no dashboard por série e número, referência, etc
GTM-2624
Verificação de Consistência mais rápida
GTM-2620
Improved signed documents checker function
GTM-2614
Faster operation through optimized user session management
GTM-2547
Permitir escolha do layout em encomendas de fornecedor
GTM-2542
Seleção hierárquica das rubricas orçamentais em faturação e compras
GTM-2568
Em impressão em lote para além de ser possivel imprimir varios documentos de uma so vez é possivel imprimir o Original, Duplicado ou Triplicado em separado.
GTM-2621
Rastreio de produtos: os números de série em RMA apareciam disponíveis em novas vendas
GTM-2597
Quando houver recibo sem documento associado ao testar o saft da um aviso informando este caso Ex:
2. Payments [RCB 5] Related Document not available in text line with amount 4. Payments [RCB 5] Total amount must be positive
GTM-2596
Novos logótipos Gestix
GTM-2580
Orçamentos editáveis, mesmo após impressão
GTM-2573
Relatório de Situação de Projeto corrigido quanto ao tratamento de guias e folhas de obra
GTM-2571
Faturação mensal de contratos em dia específico do mês

 

A libertação da versão Gestix 5.1.03 está planeada para 5 de Agosto de 2014.