It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Posts by serviciosac101
Pages 1
Any update about if the Import module is working, I tried to use today, It happens as was describe at the first comment?. I tried and tried formatting in every way posible but nothing happens and also it isn't showing any error message. I need to import around 300 invoices every month and this function will be great.
Thanks you
Hello!
I'm doing payment in foreign currency in the Payment bank option and then I put in AR settle amount the right amount, so here everything is okay I have my register at the bank and I canceled my AR account. however, when I look at the journal I didn't see the right operation because in this transaction I must have an exchange difference amount.
Example:
Customer NC for $10 rate 35x$1
Sales disc. 350
AR 350
NC Bank Payment for $10 36x$1 (This must be the right journal)
AR 350
Exchange 10
Bank 360
However we have a journal with:
AR 360
Bank 360
Remaining -10 in my AR account in the Balance Sheet. How could I solved This?
Thank you.
But I mean in the "Customer Payment" or Payment to Supplier Option.
Regards
Hello!
It would be a possibility that I can add two kinds of bank charges, in my case we had the commission for the transaction and some kind of taxes so I need to divide the bank charges in each payment that I received.
That's would be possible?
Regards
Hello!
I change the discount account for sales, so I made the change in the setup option but when a made an Invoice the journal make an entry in the previous account, I reviewed the sys_prefs table and the default_sales_discount_act is correct I mean with the new account, so I need update in another place?
Regards
Hello!
I Use the import Journal option and everything is fine. But I noted that if I make an Import journal, the next journal overput in the imported journal.
For now I only created a new journal with 0.01 cent for update the change and then I can make new journal normally.
How can I do for avoid this?
Hello!
How can I create a calculated field in profit and loss report like "Calculated Return". I need to show my owner the estimated revenue tax that we will pay. I know that is it different for each country or company. So if you can help I have some kind of knowledge in programming so I can make it for my personal use, but I need that you help me what can I change without damage the system core.
Thanks for your time.
You're a rock star
Hello!
I use two references in the credit notes, I already create in "transaction references " option but i have to change manually the reference typing each reference.
Could you make a combo box like in the Direct invoice option?
Invoice
https://drive.google.com/file/d/1yhfVMKmfGdSmnxDgzfGUpj_QcXU4zWbK/view?usp=sharing
Credit note
https://drive.google.com/file/d/10W5RJCTPq79oBMhuP56yMOkdCMfRoDdG/view?usp=sharing
Hello!
I have some problem with the currency exchange, I don't know if is a bug or my error on some procedures, the point is the next:
I have a customer with following statement in the transaction inquiry:
Invoice U$120
Payment U$118
JE U$-2 (an adjustment, i can't do credit note)
Total = U$ 0.00
BUT, when I make the revaluation currency account, it's always made me journal for this customer and it's balance is zero!
Researching and reviewing the function "get_cust_account_curr_balances" and trying to understand I reach that:
The journal entry in the debtor_trans is in negative so when the sql statement do the function sum 118 + (-2) = 116 minus the invoice, result 4 and this multiply by the currency exchange give me the amount that the system do in the exchange currency journal entry.
Actually, to resolve this I only made a Journal entry but I don't know if this situation is correct.
Great Work ! Bless you
I don't know if someone have the same problem but with the extensions for import multiple journal, I have a problem.
When I already import the journal and I need to do another journal for other reason, after I had create the new journal and go to inquiry, I see that result that the previous journal (the imported) and the new Journal are mixed both in everything reference, account, memo, etc.
First I thought that it was because the reference, but not, even though I change the reference it always mixed the journal (only if the first one is imported and the second manually).
I found alternative solution for this, after I imported the journal, create a new journal with whatever account only with 0.01 cents in debit and credit, always they will mixed, but only I have to delete the account with 0.01 cents and save, after that, I can make new journal without mixed with the import journal.
If your customer it's account is USD, then is Ok, because the customer always be USD100.00, for international standard you must change the balance or customer or vendor to local currency at the date of presentation.
Now where did change balance of your customer, in report or in General Ledger?
Ready! I reply the error in the lastest version
Attach send the step by step that how show me the mistake
https://drive.google.com/file/d/1z6MOJTnJJUU1IwhhHGP3NoPLJhfu_sqW/view?usp=sharing
I will post in the Mantis bugtracker too.
Yes, I understand but the problem is the converting is made two times, the amount is USD380 X 35 = 13300 first time.
13300 x 35 = 465500 2nd time
In the other think is that de journal are out of balance.
Hi, all transaction we made are in foreign currency (USD) the order, the payment and the customer is assigned with USD Currency
Hello appreciable people,
I have been making a prepaid invoice, so when I made the delivery, the accounting to General Ledger show me a difference in the debit and credit. I try to understand what happen and I saw that the delivery transaction is in another currency that is not my company currency, so in the accounting in deferred Income it multiply the amount in my local currency like it was a foreign currency and this made the difference in my accounting.(USD 380 x 35(exchange) = COR13000 x 35 (again) = COR465,500 (This show in the journal entry)
attach send image:
Dispatch Note: https://drive.google.com/file/d/1iJ2x1nI66klIKkRsPEdTBuA8xMYQ_3Yo/view?usp=sharing
Prepaid Delivery: https://drive.google.com/file/d/1wMGa82JKbqPiSkdbg3kbVibVlquc7Y1s/view?usp=sharing
Invoice: https://drive.google.com/file/d/11iVeYiXNnU2jfFnHNRphVT9xTusosXRh/view?usp=sharing
Deferred Account: https://drive.google.com/file/d/1k4TwUw4nBwE3j6AScPucRynQIlQ06nzL/view?usp=sharing
PD: This Kind of topic I can put here or I have to make in mantis bugtracker?
Thanks Pocho,
I changed the orientation but I have more sheets.
Download as Excel it's a good option but I work more 
I can adjust columns widths, but still it's put on another text (I resolved with this)
I can't adjust font sizes i need a little help for that
Hello!
When I see the List of Journal Report, the customer name is put as a debit value, so we can't see the amount. What can I do to avoid this?
https://drive.google.com/file/d/1OVoMqihiAoYhCfPs1pNC0X2nLLVU4I-_/view?usp=sharing
FM
It made a compesation for supplier deductions and customer deductions and if in favor of the authorities I have to make a payments in the otherwise I kept to my favor until the closing year when i deduct it from final Tax reports.
Now I had make a Credit Note for the Retention of my costumer. I mean the invoice is for $100 I received a Pay for $98 and make a credit note for $2, but seem complicate in operations.
Thanks, Apmuthu.
I made something like that, the point is the costumer invoice i need the tax retention make a deduction and the costumer pay only the diference.
Ex: Invoice $100 - $2 (tax reduction ) = $ 98 <-- My invoice will be posted with this amount and when I received the pay only view the net of Invoice.
In the sales invoice the tax don't let put a negative amount.
In the accounting I made exactly your propose.
Hello
In my country we have a tax retention on invoice either supplier invoice or costumer invoice. Now then with supplier invoice a put a negative tax, so that I resolve the problem(I don´t know if I did it good) but in costumer invoice don't left me put a negative tax.
So my wish is a tax that make a dedution on invoice either in supplier and Costumer invoice.
Good Job!
Regards
Only change $update_no = -1 to $update_no = 1
Hello, I don´t Know how it happened, but, I reviewed the file fixed_assets/includes/fixed_assets_db.inc and I saw the code $update_no = -1
Now, I made the Process
Thanks for your answer
$sql = "UPDATE ".TB_PREF."stock_master SET
depreciation_date='".date2sql($cart->tran_date)."',
material_cost=".db_escape($new_cost)."
WHERE stock_id=".db_escape($stock_id);
db_query($sql,"The depreciation start date could not be updated");
$update_no = -1;
add_audit_trail(ST_JOURNAL, $update_no, $date_);
commit_transaction();
return $trans_no;I've enter to debugging mode and get the following message, maybe because it, I can´t run the process:
ERROR DE BASE DE DATOS : Cannot add audit info
error code : 1264
error message : Out of range value for column 'trans_no' at row 1
sql that failed was : INSERT INTO audit_trail (type, trans_no, user, gl_date, description, stamp) VALUES('0', '-1',1,'2019-11-26','', CURRENT_TIMESTAMP)
https://photos.app.goo.gl/NCtQBrP4dH2aRLmL7
Thanks for your answer,
I have the same account because I was testing. But I've changed the account and I had the same result.
Details Fixed Assets
https://photos.app.goo.gl/cT3zkR8aeEsSqsLF7
Process Depreciation
https://photos.app.goo.gl/w8pRCkBErYsfuBT29
Result
https://photos.app.goo.gl/SjaLGxAUhSuWynPUA
For more Information I give you the database and config.php
https://drive.google.com/open?id=1XOICJGBCBBZYHyraC3nYs0_ItYDHGdr_
https://drive.google.com/open?id=1nWlnfzAYGJXAOzDyVELQPjLPsLCG4tWI
https://drive.google.com/open?id=1xeHJPWXw-3CN-NQnd-UVXiTM9nKCQOz_
Hello,
I made de Process Depreciation but nothing happens, I configure it like said in wiki and everything ok.
Doesn´t show any message so I don't know what should be the error.
https://photos.app.goo.gl/7P2d8FCoP6gd4u4cA
https://photos.app.goo.gl/Xti9mKaCrr32C6GX7
Thanks
Regards from Nicaragua
Pages 1
FrontAccounting forum → Posts by serviciosac101
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.