1 Topic by gshedlock352

(1 replies, posted in Dimensions)

I have a property management company that has a number of properties. Each property is described in Dimension 1 (ex. 123 main st). Each type of income or expense is described in Dimension 2 (ex. Rent, Utilities, Repairs, etc).

Then when I have an expense for a given property, I use the Dimension1 item for that property and use the Dimension 2 item to define the type of expense (utilities, repairs, etc.). Similarly when I have rent come in for a given property, I use Dimension 1 for that property and use Dimension 2 to call it Rent.

I am looking for a report that will list all of the transactions related to each property in summary form.
For example:
    123 Main st
        Rent        $.00
        Utilities    $.00
    456 Water St
        Rent        $.00
        Utilities    $.00

Does such a report exist in FA? If not, where to start the research to create my own?

Go to forum: Dimensions

2 Reply by gshedlock352

(11 replies, posted in Accounts Receivable)

For clarification I have the following:
Customer has dimension 1 defined
Item has dimension 1 defined the same as customer
Proceed to Sales Order Entry where there is an Item number, but no way to override the dimension tags
Go to Sales order Inquiry and set the order as a template
Go to Recurrent Invoices and set the days, monthly, start and end dates, etc
Print an invoice
Go to Balance sheet and drill down to the sales account and the transaction is there, but no dimension
I look at the accounts receivable account, but again the transaction is there but no dimension

I am posting this hoping that someone will see something that I am doing wrong. If not I will start digging thru the relevant scripts to see what I can find.

Thanks for any help.

Go to forum: Accounts Receivable

3 Topic by gshedlock352

(11 replies, posted in Accounts Receivable)

I have set up dimensions wherever I can find them, but when I generate a recurring invoice, the dimensions are not carried thru to the gl_trans file.

Go to forum: Accounts Receivable

4 Reply by gshedlock352

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

I am working on a 2.4.8 version of FA. I have downloaded and copied the directory in Post 131 into modules/import_transactions. When I try to import a set of journal entries, I get the all green messages:
( Person: 2, Reference: 5 )
2:10200
Added to table 'bank_trans': 8, 1, 5 , 11/23/19, 1500, 0, 2 (line 2 in import file 'FrontAccounting - 2020_05_11 - Rental Income test journal import.csv')
Added to table 'gl_trans' Debit bank account: 8, 11/23/19, 10200, 12, 0, 1500, ( Person: 2, Reference: 5 ) , 0, 2 (line 2 in import file 'FrontAccounting - 2020_05_11 - Rental Income test journal import.csv')
Yet I see no entries in the relevant accounts with or without the trial run indicator set.
Looking for somewhere to start looking for the problem.

Go to forum: Modules Add-on's

5 Topic by gshedlock352

(1 replies, posted in Banking and General Ledger)

Has anyone put together a workable chart of accounts for a real estate investor? I have seen many questions asked about this, but no real answers (unless I missed it).

Go to forum: Banking and General Ledger