4,626 Reply by joe

(27 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

4,627 Reply by joe

(15 replies, posted in Setup)

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

Go to forum: Setup

4,628 Reply by joe

(1 replies, posted in Wish List)

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

Go to forum: Wish List

4,629 Reply by joe

(2 replies, posted in Wish List)

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

Go to forum: Wish List

4,630 Reply by joe

(5 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

4,631 Reply by joe

(3 replies, posted in Banking and General Ledger)

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

Go to forum: Banking and General Ledger

4,632 Reply by joe

(5 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

4,633 Topic by joe

(27 replies, posted in Accounts Receivable)

This is only for version up to 2.0.X. From 2.1 you DON'T set the AR account to a bank account, but you simply select Cash invoice in the selector Delayed / Cash in the Direct Invoice.

If you use cash sale invoices in your business, here are the guidelines for doing that (from release 2.0).

1. If you do not already have a cash account in your Bank Accounts, please create one (Banking and General Ledger tab).
2. If you do not already have a Payment Term that is set to Cash Only, please create one (Setup tab).
3. Create a Cash customer. Call him f.i. Cash Sales, select Retail sales and Cash Only in Payment terms. Leave other fields empty.
4. At the time create a customer branch. Also Cash Sales.
5. Enter relevant information.
6. Set the Accounts Receivable to your new cash Bank Account.
7. Leave the address fields empty or have a one liner info text.

Now you are ready to use your new Cash Sale.

1. Enter 'Direct Invoice' in Sales tab.
2. Select the Cash Sales customer. It will automatically choose the same branch.
3. Enter your item lines. You can use the address lines to enter your cash client info if you want to.
4. Process the Invoice.
5. Print out the invoice and give it to your client as a receipt.

What happens internally?
Instead of posting the GL to the normal Accounts Receivable account it would be debited to the cash account.
If this AR account is a bank account, the allocation will be set to the full amount, indicating the invoice as been settled. So it will never show upp in the allocation screens.

/Joe

BTW, You can do the same thing if this is a Cash Credit Note

Go to forum: Accounts Receivable

4,634 Topic by joe

(6 replies, posted in Banking and General Ledger)

I just came across a free eLearning course at SmallBizU eLearning University.
The course is called Accounting 101: The fundamentals.
It can be accessed through:

http://smallhomebusiness.suite101.com/a … ion_online.

Press the link: SBA
Press the link: Introduction to Accounting.

You will have to enter some personal information, but enter what you like and continue.

Now you can start the eLearning.
I found it very good for a novice to get a habit of the accounting.

If you have other free or cheap sources to learn accounting, please let us know.

/Joe

Go to forum: Banking and General Ledger

4,635 Reply by joe

(5 replies, posted in Banking and General Ledger)

Alvin illustrates what is going on in the accountancy in a fantastic way.
Bank Deposits. If you enter a liability account with an amount and process the payment,it will be shown exactly as alvin illustrates.

Joe

Go to forum: Banking and General Ledger

4,636 Reply by joe

(5 replies, posted in Accounts Payable)

Some of the demo chart of accounts as well as new chart of accounts do not contain specific accounts for long term assets that are depreciateable. In case there are no such accounts you must create these accounts yourself.

Then it is quite easy to use the supplier invoice to enter it by using the GL Items for this account and don't forget the ingoing tax as well.

So as you see, you can use supplier invoices for both stock items (GRNs) as well as other costs/long term assets.

/Joe

Go to forum: Accounts Payable

4,637 Reply by joe

(5 replies, posted in Accounts Payable)

Hello,
I guess you ran into a bug in FrontAccounting. Voiding a supplier invoice/credit note with GL Items creates a database error. This bug has been fixed in the CVS repository at Sourceforge.net.
Waiting for the next minor release, you can make a supplier credit note to revert the transactions.
The tax is done automatically when entering GRNs, but if you enter GL Items you have to enter the tax items yourself.
Thanks for finding this bug smile

/Joe

Go to forum: Accounts Payable

4,638 Reply by joe

(2 replies, posted in Accounts Payable)

If you want to import journal entries, you have to write an import module yourself. The database is documented in two different ways. Look in Download, Documentation on our Website.
You don't have to worry about periods, they are non-existing in FrontAccounting. You define the periods yourself when reporting. You only have to make sure, there are fiscal years covering your imports.
There are no account dumps when closing a fiscal year. You do that yourself according to accounting rules.

/Joe

Go to forum: Accounts Payable

4,639 Reply by joe

(14 replies, posted in Accounts Payable)

I'm sorry Baffin. We have to stop here, because otherwise it gets too complicated. Of course it would be possible to maximize the items to 50, but if there are 200 items on the supplier invoice, you will need the rest to go into that invoice.

/Joe

Go to forum: Accounts Payable

4,640 Reply by joe

(12 replies, posted in Installation)

If you have created a bill of material for the manufacture and done any assembling, you must disassemble the manufacture. Remove the items from the bill of material.
Now you can use a utility program, phpMyAdmin, for accessing the database. Go into the table 0_stock_master (table-prefix 0_ used for the client). Look up you article and replace the mb_flag M with a D and save.
It is now a service item.
But it is important to follow the first sequences, if you have created bill of material and assembling. If not you can go direct into phpMyAdmin and do the replacement.

/Joe

Go to forum: Installation

4,641 Reply by joe

(12 replies, posted in Installation)

If you haven't used it yet, you can just delete the item and create it again, but now with service instead of manufacturing.

/Joe

Go to forum: Installation

4,642 Reply by joe

(5 replies, posted in Report Bugs here)

We only have the possibility to record one currency rate a day.
The variance is calculated when the payment allocation is done. At the moment I can't see how we can come closer on this.

/Joe

Go to forum: Report Bugs here

4,643 Reply by joe

(1 replies, posted in Wish List)

We do have a poll on our website regardingthis recurring invoices. Have a look.

/Joe

Go to forum: Wish List

4,644 Reply by joe

(8 replies, posted in Wish List)

Well, you could try a couple of things in the Training Co. Set 'Allow negative sock' in System setup.
Create a new item as Service, but Manufacturing. Don't set up any purchase price for this item.
Create a BOM that could be with several services. And make a workorder for this.
While the purchase price is 0, there will never be created any stock GL items. It could be a way out.
Also know that you can categorize your services, but this is only for statistics.

/Joe

Go to forum: Wish List

4,645 Reply by joe

(4 replies, posted in Installation)

Thanks for giving us this warning smile

Go to forum: Installation

4,646 Reply by joe

(14 replies, posted in Accounts Payable)

Hello again, FYI baffin, it is now possible to select all items in one sweep. Check out the following files from CVS repository at sourceforge.
There are also improvements to the layout.
Files: /purchasing/supplier_invoice.php, /purchasing/supplier_credit.php and /purchasing/includes/ui/invoice_ui.inc .

If you want to, you can edit the rows before submitting the 'Add All Items' . Should there be lines with errors, they will not be added, and you can edit them (you get errormsg for every line that fails). Then again you can either take them one by one or all by 'Add All Items'. Pretty cool, ha?

/Joe

Go to forum: Accounts Payable

4,647 Reply by joe

(4 replies, posted in Installation)

I haven't heard of this problem before. It seems that your index.php placed in your /fa/ folder is corrupted. Please replace it with the one from the package. This index.php does have several instructions, not just a redirect.

/Joe

Go to forum: Installation

4,648 Reply by joe

(14 replies, posted in Accounts Payable)

Release 2.0.4 now has this new supplier invoice/credit note design. The adding of lines should be done in memory, but there might still be a smaller delay.
I hope you like this new approach.
Release 2.1 unstable has an Ajax Loader, so you can see it is working.

/Joe

Go to forum: Accounts Payable

4,649 Reply by joe

(14 replies, posted in Accounts Payable)

I understand your wish. You want to have all the entries in one window instead of popping forth and back.
I have to discuss this with my co-developers.
One possible way would be to start with the GRN rows. All the PO receivable rows could be here, editable in the qty/price fields, with an 'Add Item' button. For admins there should also be a Removal button to completely wipe the PO receivable out.
Only those rows that have been added are gone to the invoice.
After the GRN rows there could be similar rows as in Bank Payment for eventually GL postings. The entries could be horizontal instead to better follow the pattern.

The document form would be somewhat higher, but you avoid popping forth and back. And you only have to press the 'Add Item' Button for those rows that are ok (without editing them).

What do you think about that? Comments from other?

/Joe

Go to forum: Accounts Payable

4,650 Reply by joe

(14 replies, posted in Accounts Payable)

No, you have to take them one by one, because there could be quantity and/or price change.

/Joe

Go to forum: Accounts Payable