Search options (Page 1 of 2)

Hi

when I re-evaluate at the end of period, the banks get change based on the exchange rate that I record in FA.

but about AR and AP it doesn't happened. it looks FA found a new Rate from some where or calculate new rate.

it make a big amount of Exchange variance in my Trial Balance. is there any solution for it.

Regards

Hi

is it possible to remove GL account used to include transaction?

I removed all transaction but when I want to remove them FA says: "Cannot delete this account because transactions have been created using this account"

Hi

There is some SQL code in the green field on the footer of web version like:

<div id='footer_debug'><div class='note_msg'><pre>SELECT name, value FROM 0_sys_prefs</pre>

<div id='footer_debug'><div class='note_msg'><pre>SELECT COUNT(*) FROM (SELECT IFNULL(a.gl_seq,0) as gl_seq,
                                gl.tran_date,
                                gl.type,
                                gl.type_no,
                                refs.reference,
                                SUM(IF(gl.amount>0, gl.amount,0)) as amount,
                                com.memo_,
                                IF(ISNULL(u.user_id),'',u.user_id) as user_id
                                FROM 0_gl_trans as gl
                                LEFT JOIN 0_audit_trail as a ON
                                                (gl.type=a.type AND gl.type_no=a.trans_no)
                                LEFT JOIN 0_comments as com ON
                                                (gl.type=com.type AND gl.type_no=com.id)
                                LEFT JOIN 0_refs as refs ON
                                                (gl.type=refs.type AND gl.type_no=refs.id)
                                LEFT JOIN 0_users as u ON
                                                a.user=u.id
                                WHERE gl.tran_date >= '2018-04-06'
                                AND gl.tran_date <= '2018-05-06'
                                AND gl.amount!=0 AND gl_seq=0 GROUP BY gl.tran_date, a.gl_seq, gl.type, gl.type_no) tmp_count</pre>

No difference where I am, they are everywhere, on the web, in the reports.

I don't know how they get there. Please tell me how can I fix it.

thank you so much.

Hi all

I've Issued a Purchase order and half of that received, now I have half of this Order Open in " Outstanding Purchase Orders Maintenance ". is it possible to cancel that part which is not received? or setting up after fiscal year it canceled automatically?

thanks

even there's no answer. :-)

Hi

I entered a Supplier invoice, later I change the quantities and Prices basically - I mean, I void Supplier Invoice and PO delivery note and "Decrease" item in PO level - finally FA issued 3 "Cost Update" transactions - repetitive - between Warehouse (debit) C.O.G.S (credit) in same amounts, while it happened in first starting balance in FA that include Bank, Supplier, Customer Balance and some Supplier Invoices with out any Sales Invoice.

I also updated the cost by Standard Costs, but nothing has changed.

as it's obvious these 3 transaction " Cost Update" are increasing inventory amount. Right?

What should I do?