Skip to forum content
FrontAccounting forum
It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
Active topics Unanswered topics
Search options (Page 82 of 97)
Topics by itronics User defined search
Posts found: 2,026 to 2,050 of 2,419
Currently our development team is about to improve GL journal maintenance area. We have found that 'Reverse transaction' option in Journal Entry is somewhat strange and inconsistent with data flow rules used in other parts of FrontAccounting source.
When reverse transaction option is selected there are in fact two journal entries added during processing, first one with the data entered by user, the other with changed posting side (sign), and dated on first day of next month.
We are about to remove the option in FA v.2.2, but if this functionality is crucial for some current FA users, we are open for discussion.
Janusz
After the fix mailing invoices works right. To use it you should have sendmail (or compatible) installed on your FA server. See php.net mail() function manual. Google is also your friend.
Janusz
Yes, you are right. The Direct invoice generate those 4 transactions. I don't know what 'demand' value you mean, but anyway after voiding all should be as before (excluding changed next transaction numbers).
Janusz
Direct invoice feature is simply shortcut for issue of three documents: sales order, delivery note and sales invoice, so if you want to reverse it you have to edit or void all of them in reverse order. Or you can issue credit note against the invoice.
Janusz
Thank you, bharatthakkar . This extension is very specific, so we will not include it in core source for now, but I'll store it in case somebody else would be interested in this.
What FA version was choosen as a base for your changes?
Janusz
This is only matter of proper configuration of tax system. The selected tax rates set is intersection of customer's tax group and item tax type. This will work when your prices are set excl. tax, but this is obvious if you wish to use various local taxes (price excl. tax is ususally the same for all customers regardless their location).
So, item tax type for the items sold to some states should contain all needed taxes for all those locations. Then you define as many tax groups as you have target markets, each group containing only related state taxes. When you select customer with given state tax group, only taxes for those state will be selected on invoice.
Using additional tax selector on invoice/sales order would make FA vulnerable to user mistakes. I guess you do not want to tax your customer in Anchorage with Miami taxes every now and then ? 
Janusz
Look into items.php code. Here you can find how to update some elements of items page on different events. For example in line 36-41 you will find update of details and control areas after stock_id selector change. All available ajax functions you will find in Ajax class in file ajax.inc. You can call them in any place on the page accessing global $Ajax object. See into another php files to learn how it is can be used.
Janusz
Only primary keys as used as foreign keys, so if you wish you can translate any unique key which is not primary. But translated text have to be unique of course.
The double auto_increment clause is MySQL dump issue, you can delete one of the two if you wish.
Janusz
The currency is not noted on ECB page, so it cannot be retrieved automatically. Insert it into db according to the message.
Regarding recent issue you have missed something. FA never issues credit automatically without user intervention.
Janusz
I'm not sure what do you exactly want, but FA has category/item description ajax search already implemented. If you want to use ajax search feature check 'Search Item List' in company setup. Then when you enter part of description/item name in item code box on slaes order page, the item list is filled with result of search on items table.
Janusz
Which unique keys do you want to translate?
JAnusz
Why not? But you should also use the same translated value in other table, if it is used as foreign key.
Janusz
This is right. You can look in to get_price function in sales_db.inc to find how auto price calculations works.
Janusz
This is tax group applicable to shipping charges placed on sales invoice.
Janusz
Look into Inventory Planning Report in Inventory rRports.
Janusz
Oh, yes, you mean Purchase Transactions Inquiry, not Customer Transactions?
Outstanding Purchase Order Maintenance is in no way related to Customer Transactions.
Janusz
I don't know. Set go_debug=1 in config.php. Look into your apache log file, maybe you will find some reason here? The only nonstandard change in FA 2.1 source was adding .htaccess file., which NB was fixed in release 2.1.1.
Janusz
Yes, some selection of database script during install would be usefull.
Janusz
item_code table stores both internal and foreign codes. The items list selector gets data from this table, so to have stock items in the list you have to put stock_id code here.
Janusz
When you issue credit note against invoice, sales order does not come into outstanding orders, because delivered item quantities does not change. The items are delivered and then optionally returned during crediting.
How have you credited the invoice?
Janusz
Broken database setup. Enter users setup, select POS for every user and update account.
Janusz
Set base pricelist in company settings to enable automatic price calculations and check if company/x/js_cache folder is writable.
Janusz
In gl_trans type and type_no together are key to document for which the gl post was created. The same relation is for stock_moves trans_no and type fields.
Janusz
Mostly this list is correct.
Quantity on hand is calculated from stock_moves. Stock_moves records are added during delivery/receiving of inventory items. To add prices you need first have defined sales types (price lists).
You will find current ERD diagram with all relations here.
Janusz
Yes, the module was written for version 2.0. The item_codes table is new in 2.1, so it need some corrections in the code.
Janusz
Posts found: 2,026 to 2,050 of 2,419
