FrontAccounting forum — Dimensions and gl_trans table

Re: Dimensions and gl_trans table

null@example.com (panchovilla) — Fri, 06 Jan 2017 22:37:33 +0000

Hi,

I have a doubt regarding this.

I have an item with a dimension X. When I buy this item for 100 usd, a transaction is added to the "Inventory GL account" so this Inventory account is increased in 100 usd for the dimension X. But when I sell this product for 150 usd, a transaction is made for the same account but the dimension is now 0 and not X, so it does not discount the Inventory for the dimension X.

I would like to have a Balance sheets for every dimension so I need to have all the accounts separated by dimension. And the sum of all the dimension balances should do the total balance..

Not sure if this is possible according to the comment that dimensions only uses the profit / loss accounts..

Thank you for your help.

FA v.2.3.25

Re: Dimensions and gl_trans table

null@example.com (joe) — Wed, 07 Jan 2015 23:23:43 +0000

No, otherwise it is working just fine!

/Joe

Re: Dimensions and gl_trans table

null@example.com (apmuthu) — Wed, 07 Jan 2015 20:46:54 +0000

I already wiki-ed it. I wanted to know if there are any more caveats to it's use that needs to be documented.

Re: Dimensions and gl_trans table

null@example.com (joe) — Wed, 07 Jan 2015 20:00:16 +0000

Please go ahead. I am busy right now.

Joe

Re: Dimensions and gl_trans table

null@example.com (apmuthu) — Wed, 07 Jan 2015 18:45:59 +0000

Please elaborate it on the Wiki where this has been listed.

Re: Dimensions and gl_trans table

null@example.com (joe) — Wed, 07 Jan 2015 17:25:20 +0000

Yes, the dimensions only uses the profit / loss accounts. Otherwise the results will be biased.

Joe

Dimensions and gl_trans table

null@example.com (chenlit) — Wed, 07 Jan 2015 15:50:37 +0000

Hello

I have a bit of a problem understanding the gl postings when I use dimensions. I am not sure if it's a bug.

My setup is like this:
Frontaccounting v. 2.3.21
Dimension type :1
Dimension name: Project 1

I create a supplier invoice (Tabsheet Purchases > Supplier invoices). I select a GL account (costs) and select "project 1" under Dimension. I click on "Create Invoice". The GL journal entry that is generated would look like this:

Code Account Name Dimension Debit Credit Memo
1600 Creditors 10,00
4499 Sales costs Project 1 10,00

The dimension is missing in the first line of the journal entry, which is a bit of a problem: when I check the balance sheet and filter on dimension "project 1" the numbers are inconsistent.

So I am not sure if I am missing something here. Or should the dimensions only be visible in the profit & loss sheets?