Search options (Page 186 of 200)

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

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

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

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

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 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

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

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

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

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

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