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 joe
In the item tab, you can enter some supplier specific info in the Purchase Pricing. You have a conversion factor where you can set 24 and regulate the internal price accordingly.
While this doesn't work fully in 2.0.x, it will be better supported in 2.1 that are under development. These fields will automatically be updated in 2.1 when creating PO receivals/invoices.
/Joe
Hello guys,
Thanks for your contributions. Yes, the information for the Supplier is quite modest. We will extend the info in the next release 2.1, that we are working on at present. The field Bank Account is just for what you have guessed. We will change the label to Bank name/account. It is an info field.
Regarding the list search feature enabled. You use a '*' and tab key to fill the combobox. Or you can search for partly strings. This is handy if you have a bunch of customers/suppliers and/or items.
We have internal been discussing the extra fields. We have decided to stall these implementations at present and concentrate on the accountancy flow through all the sections in FrontAccounting. The transactions are huge and with currency rates/discounts and taxes with a lot of decimals we must first secure that the flow works all around. This is the main task for us.
/Joe
Hello Qaiser,
Thank you for your kind words. It really warms. I am glad that you want to share your work with others.
You can send it to:
joe dot hunt dot consulting at gmail dot com. Please replace (dot) with a (.) and (at) with the (@) sign. Sorry for the cryptical email address, but this is due to spam harvesting of email addresses.
You can also use the Contact Us page on the Website, but you have to first contact us because you can not attach files in the contact form.
I will then put it on our website, under downloads.
Thanks.
/Joe
Strange, I can not reproduce this error. There seems to be no id value. I have tried and tried but cannot reproduce this. Maybe there are some inconsistencies in the database. If you have access to phpMyAdmin, look at the table 1_debtor_trans_details. The debtor_trans_type should be 11 and the debtor_trans_no should be the same as the credit note #. Check if there are records with no id values.
/Joe
And this is why we have the dimensions for helping us with that. Se under Forum dimensions how to use them.
/Joe
Hello Dave,
Thanks for your tip, but we have already implemented this feature in release 2.1 unstable. It works just as simple as this, but is, however, a lot more sophisticated. Take a look yourself at: http://fa2.iron.from.pl . User: demouser Password: password and select Banking and General Ledger. In the Maintenance section there is a menu choice: Quick Entries. And you can select GL Journal Entry and up right you can select a Quick Entry, Transfer, input an amount and press Go. Thats it. Ah, you have to press Process Journal before updating, but you have a chance to eventually change something, should it be needed.
This release is not the latest one, but it has recurrent invoices. The release is updated from our CVS repository now and then when new things are implemented, so you can look in here frequently.
We are at present preparing the POS and Barcode/SKU for items.
/Joe
Ah, I answered a similar topic just before this. Look here please.
/Joe
Hello Dave,
Well Rasmus exdplained the new License type excellent.
As I see it, and if you do not change the source, there should be no problem linking back to us for downloading the source for those, I guess rare, situations where your clients want the source. Those clients will also have to accept the license.
I can guarantee you that we will focus on the accounting, and you can look forward to release 2.1, where we have a lot of new features.
You can go to the CVS repository at Sourceforge.net and look at the ChANGELOG.txt for the unstable release.
I can just give you a few new features:
Quick Entries in Bank Deposits / Payments and Journal Entry. Can also be used to make automatic codings in GL Journal Entries.
Recurring Invoices based on a single customer or a group (new in 2.1) of customers/branches.
Input of dimensions in documents. Paging of table lists. Tax Inquiry. POS. Print direct to printers. Hotkeys in many places. Option to have the links in lists be graphics. More fail-safe upgrading of database. Attachment of scanned document or other documents belonging to a posting and links to this feature after it has been posted. And much more.
/Joe
Hello,
function get_qoh_on_date is in the file /includes/db/inventory_db.inc and the table for doing the inventory is X_stock_movements which you will se in the function.
/Joe
Hello again Rasmus,
I have now talked to our partners and my co-developer and we have decided to change the License to AGPL instead of GPL. This change will be in effect when we ship the 2.1 release in a while.
/Joe
There are 2 files for these texts. One for domestic customers and one for foreign customers. They are called doctext.inc and doctext2.inc. Be careful to use the exact variables. They are case sensitive.
/Joe
Hello,
This has been added in file /admin/void_tranaction.php. Can be downloaded from the CVS repository (MAIN).
/Joe
Download and have a look at the simple modules like import_items or similar.
In the documentation downloads you can download an ER scheme and a database description. There are also an API documentation.
Best regards
Joe
Sounds like an interesting idea. We will consider.
/Joe
I can see the idea behind this. Under the traditional GPL, someone can change the software and/or use this modification as software on demand without letting the end users get a hand of the source. As I understand this is not possible under AGPL.
I will talk to my co-developer as well as our partners about this and get their opinion of the topic.
/Joe
Hello Travis,
You are an observant user. You are partly right. The items can have several tax exempts. Therefore this was done, however, just these sections were done before we took over the project.
We are going to check these items before next release.
Thanks for your contribution.
/Joe
A Tax Inquiry, based partly on the above script has been added to release 2.1 unstable. It is placed in the Banking and General Ledger tab.
Committed to CVS 2.1 unstable.
Thanks for the contribution.
/Joe
There is something similar at the end of the existing Tax Report. Maybe it should be replaced by your algorithm. I will have a closer look at it.
In release 2.1, the tax_code on account is changed from tax_type to tax_group to better handle the eventually multiple tax_types on an account.
You should also be glad waiting for this new release. You will be able to put dimension(s) on delivery notes, sales invoices and credit notes, so you can keep track of COGS and Sales for your dimensions.
/Joe
There are some discussions around in this forum about how to handle the year end closure.
There must be something else wrong if your balance sheet is empty.
When bringing a profit forwards to the retained earnings you only need to involve this balance account.
You can do this in 2 ways. Either close all the non-balance account one by one and counter post on retained earnings (debit / credit).
Or you can create a new account, maybe the last one, and call it Year result. Debit this account with the result (or credit if loss),
credit Retained earnings (or debit if loss).
I prefer the second method. This way you have the following benefits:
You can still get multiyear results for dimensions. The transactions for earlier years are still there, but remember, when selecting trial balances or other reports where income/cost accounts are included these Opening balances is taken from the beginning of the fiscal year.
Opening Balances for balance accounts are always taken from the start of the accounting.
But by selecting a period over more than the current fiscal year, you will still have a possibility to get income statements for dimensions and this is extremely powerful for multiyear dimensions like projects.
/Joei
At the end of the Tax Report, there is an accumulation of the GL Lines where the different taxes have been posted.
Regarding projects (dimensions) on the invoice etc., we are developing an option to select dimension(s) on the Sales Delivery and Sales Invoice/credit note pages. We do not need it on the Supplier side, because this side only affect the stock/inventory postings. Non items for the supplier can be entered under GL items and you can select dimensions here as well.
First when a delivery note is created the COGS accounts are involved. And ev. selected dimension(s) will go with these COGS lines.
When the invoice or a credit note is created adn dimension(s) are selected, the Sales accounts will include these dimension(s).
These selected dimension(s) will steer over ev. set dimension(s) on the item/cust.branch.
What I mean with the (s) in the dimensions is that you can set the company to have 0, 1 or 2 levels of dimensions. Se in dimension forum how this works.
If you have any opinion about this, please let us know.
/Joe
Yes, I know that this is the normal handling for foreign suppliers, however, I think we have to enhance the quick entries a bit.
Instead of using the automatic coding for tax on the account, we should probably use multiple lines and also include dimensions on the line and a checkmark for if this is % or amount. This way we have to enter all the lines needed to execute the transaction.
In this case we are are very close to what one could call 'Automatic Codings'. We can then create entries for almost every situation.
And it could also be used in GL entry (depreciations, periodic contribution etc.)
But we have to make this as simple as possible, so we are still considering.
/Joe
Hello Rasmus,
In 2.1 unstable we have implemented a Quick Entry in Bank Payments /Deposits. Have a look at http://fa2.iron.from.pl (demouser / password).
Here you will also see the new Ajax pager in Sales, Sales Order Inquiry.
/Joe
To get it right, you should enter the stock one by one and location by location in Inventory Adjustments. To get the correct average price calculated, you should enter the values/purchase price by item.
When you are ready the GL Inventory ends up with an accumulated amount and the same amout is credited to a consumable account. This account should then be debited for the same amount and the credit post should be put into an equity account (your company owns this stock). You should have an opening balance from your earlier accounting to compare with, otherwise talk to somebody with accountancy knowledge.
There might be other ways of doing this. Please someone advise us then.
/Joe
To use the simple audit trail in FrontAccounting you should first change a variable line in the file config.php. $use_audit_trail, line 57. Set the value to 1 instead of 0.
Now all the GL transactions are stamped with the username in the field, memo. If this memo field is used for other things, the username will be samped in front of that.
While most of the critical transactions from AR, AP and Stock modules end up in GL Postings, we found this to be sufficient enough. The trail can be found backwards, when you know the GL transaction number.
/Joe
Hello,
You should enter the currency rate against the USD. 1 Rupiah = ? USD or 1 / 9800. Due to the small amount 0.0001xxxxx you should probably increase th currency rate decimals in display setup. Then everything is ok.
/Joe
FrontAccounting forum → Posts by joe
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.