1 Topic by bmontenegro

(1 replies, posted in Report Bugs here)

Hello. I apologize if this is not the correct place to ask this, but why are my SQL queries being saved inside X_SQL_TRAIL tables with the single quotes represented as ' For example:

INSERT INTO 2_sales_orders (order_no, type, debtor_no, trans_type, branch_code, customer_ref, reference, comments, ord_date,
        order_type, ship_via, deliver_to, delivery_address, contact_phone,
        freight_cost, from_stk_loc, delivery_date, payment_terms, total)
        VALUES ('50','0','2', '30','3', '','auto','','2013-11-19', '1', '1','Ventas Al Contado','Km. 15.5 Carretera a Masaya.', '55555555', '0', 'DEF', '2013-11-19','5','2300')

This is very annoying. Is there anyway to fix this? Thank you. I am using version 2.3.18.

Bosco

Go to forum: Report Bugs here

2 Reply by bmontenegro

(7 replies, posted in Accounts Receivable)

joe wrote:

Today you simply setup a cash account in the Pos setup, Setup tab.

This wasn't possible back in 2008.

Joe

Thank you Joe, that is correct.

Go to forum: Accounts Receivable

3 Reply by bmontenegro

(7 replies, posted in Accounts Receivable)

Ok, solved the problem. The problem was precisely that I had the cash account as a bank account so trying to set up the "Account Receivable Account" as a cash account wasn't available for me. Thanks anyways. smile

Go to forum: Accounts Receivable

4 Reply by bmontenegro

(7 replies, posted in Accounts Receivable)

Hello. I also have this problem. I tried setting the "Account Receivable Account" to the cash account but the list filters out the cash account I want. The cash account is registered a cash account in Setup > Bank Accounts. What am I doing wrong? Please help. Thank you.

Go to forum: Accounts Receivable

5 Reply by bmontenegro

(3 replies, posted in Accounts Receivable)

I had a problem like that with my taxes, but I unchecked the the "Tax Included" check option in the Sales Types (Retail) and it started working correctly. Now the taxes are correct inside my invoices and general ledger accounts.

Go to forum: Accounts Receivable

6 Reply by bmontenegro

(7 replies, posted in Setup)

Maybe you can  Void a Transaction in Setup / Maintenance. You select the transaction type, query and delete.

Go to forum: Setup

7 Reply by bmontenegro

(5 replies, posted in Misc. Charts of Accounts)

For Colombia you should use this as a reference  when making your COA & database scripts.  See the COA for colombia here http://puc.com.co/

Go to forum: Misc. Charts of Accounts