4,626 Reply by joe

(3 replies, posted in Items and Inventory)

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

Go to forum: Items and Inventory

4,627 Reply by joe

(1 replies, posted in Report Bugs here)

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

Go to forum: Report Bugs here

4,628 Reply by joe

(1 replies, posted in Wish List)

And this is why we have the dimensions for helping us with that. Se under Forum dimensions how to use them.

/Joe

Go to forum: Wish List

4,629 Reply by joe

(2 replies, posted in Wish List)

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

Go to forum: Wish List

4,630 Reply by joe

(1 replies, posted in Wish List)

Ah, I answered a similar topic just before this. Look here please.

/Joe

Go to forum: Wish List

4,631 Reply by joe

(31 replies, posted in Wish List)

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

Go to forum: Wish List

4,632 Reply by joe

(5 replies, posted in Items and Inventory)

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

Go to forum: Items and Inventory

4,633 Reply by joe

(31 replies, posted in Wish List)

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

Go to forum: Wish List

4,634 Reply by joe

(4 replies, posted in Setup)

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

Go to forum: Setup

4,635 Reply by joe

(4 replies, posted in Wish List)

Hello,

This has been added in file /admin/void_tranaction.php. Can be downloaded from the CVS repository (MAIN).

/Joe

Go to forum: Wish List

4,636 Reply by joe

(1 replies, posted in Modules Add-on's)

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

Go to forum: Modules Add-on's

4,637 Reply by joe

(1 replies, posted in Wish List)

Sounds like an interesting idea. We will consider.

/Joe

Go to forum: Wish List

4,638 Reply by joe

(31 replies, posted in Wish List)

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

Go to forum: Wish List

4,639 Reply by joe

(1 replies, posted in Accounts Payable)

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

Go to forum: Accounts Payable

4,640 Reply by joe

(15 replies, posted in Setup)

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

Go to forum: Setup

4,641 Reply by joe

(15 replies, posted in Setup)

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

Go to forum: Setup

4,642 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,643 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,644 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,645 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,646 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,647 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,648 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,649 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,650 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