• From: Egypt, Cairo
  • Registered: 12/30/2019
  • Posts: 4

Topic: Dimensions GL Sales and Supplier Invoices

While checking supplier and customer invoices GL, the GL entries have the dimension in the P&L accounts only while other accounts like tax account etc. are recorded without dimension.

I confirm saw that in the wiki (that dimensions are only support on the P&L accounts) (only the sales accounts and purchase accounts are stamped with the dimension in GL for the line values) https://frontaccounting.com/fawiki/index.php?n=Help.Dimensions

But the question here why? I could not figure out why only sales and supplier accounts are supported.

1- You may have a scenario where we need to filter taxes per dimension (as a project)
2- You may have a scenario where we need to filter customer account per dimension (as a project)

While you are able to assign the dimensions if you do the transaction using Journal Entry, not the modules (Sales or Purchase)

Would anyone please explain!!

Thanks

  • From: USA
  • Registered: 07/16/2017
  • Posts: 276

Re: Dimensions GL Sales and Supplier Invoices

Thats a good question and it looks like the decision has been made to add dimensions to A/R and A/P in FA in 2.4.8.     In my fork, all G/L entries including A/R, A/P, taxes, discounts, etc all have dimensions if the invoice is assigned a dimension.  Its the only way to get an accurate P/L by dimension.

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,085

Re: Dimensions GL Sales and Supplier Invoices

You can download the latest snapshot from the repo here. This contains the dimension booking on AR and AP and bank.

/joe

  • From: Egypt, Cairo
  • Registered: 12/30/2019
  • Posts: 4

Re: Dimensions GL Sales and Supplier Invoices

Thanks all

at least it makes sense now.

  • From: Egypt, Cairo
  • Registered: 12/30/2019
  • Posts: 4

Re: Dimensions GL Sales and Supplier Invoices

Update: now after we implemented all the Dimensions to be included in all GL accounts, the dimension balance had been messed up (Wrong Value).

Yes: it is useful when you extract a report for GL Account with a dimension, but the Dimension Balance becomes not usable as it accumulates the Debt and Credit on the same cost centre or dimension.

What do you think from the logical point, should we remove the dimensions from GL account and stick to the old method of adding it to P&L accounts only. Or filter the Dimensions Report and enquiries screens to exclude the non P&L Account?

Let me know what do you think.

  • From: Egypt, Cairo
  • Registered: 12/30/2019
  • Posts: 4

Re: Dimensions GL Sales and Supplier Invoices

Update: We had modified the Dimension enquiry and it reports SQL query to include only P&L accounts, that solve the problem and Dimension balance is correct.