1 Reply by tomhallman

(21 replies, posted in Reporting)

Ahhh now I understand.  Full disclosure: I actually didn't write that code - a coworker of mine was the mastermind behind the reporting code changes (over 3 years ago!)  Our copy of FA is still pretty old though, so we don't have a good development environment set up right now.  I'm afraid I won't be able to help with this one... sorry sad

In other news, we're still regularly using FA and even incorporated some auto-importing code recently so that there's seamless integration between some of our systems.  We do intend to get caught up with the latest version of FA, but I can't give a time estimate at the moment.

Go to forum: Reporting

2 Reply by tomhallman

(21 replies, posted in Reporting)

Hi all. I saw Chris's email and figured I'd stop in to say hello! Honestly I haven't done FA development in a while now... could you point me to where I could find the code for that extension?  I tried looking all over the website but couldn't find it.  If I could take a look at it I may be able to figure it out.

Tom

Go to forum: Reporting

3 Reply by tomhallman

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

e-prast wrote:

OK I've edited so it looks like this:
$memo = "$percent% from transactions of account: $acct_source_code for period $start_date to $end_date";

and the output is:
2.5% from transactions of account: 41001000 for period 01/07/2010 to 31/07/2010

but my desired output is :
2.5% from transactions of account: 41001000 Sales Item-1 for period 01/07/2010 to 31/07/2010

how do I can get the account name not just the account code?

thx

Sorry again for the slow reply.  Try using get_gl_account_name($code).

That is:

$acct_name = get_gl_account_name($acct_source_code);
$memo = "$percent% from transactions of account: $acct_name for period $start_date to $end_date";

I haven't tested that, but I think that'll do what you want.

Tom

Go to forum: Modules Add-on's

4 Reply by tomhallman

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

e-prast,

  Sure.  Would you like it to say something like, "5% from transactions to: 41001000"?  If so, you can just edit line 149 of the run tool to look more like the commented out line 148.  For example:

  $memo = "$percent% from transactions to: $acct_source_code";

  That might be a quick fix for you!

Tom

Go to forum: Modules Add-on's

5 Reply by tomhallman

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

e-prast,

  Hey, I think you might be right!  I just skimmed over the code, and I think there may indeed be a bug if there's no dim to credit.  I'll delve into that more soon to see what can be done and I'll submit a patch.

  In the meantime, I'm glad you found a workaround!  Thanks for asking about the bug!

Tom

Go to forum: Modules Add-on's

6 Reply by tomhallman

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

Hello e-prast,

  Okay, so if I understand this correctly, you have two "type 1" dimensions and no type 2 dimensions.  Is that right?

  What happens if you run those last two SELECT statements directly in phpMyAdmin?  Does anything show up?

Tom

Go to forum: Modules Add-on's

7 Reply by tomhallman

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

Hello all,

  Sorry for the delay - just got back from vacation.

  Briefly, the Account Percentages Run tool does the following when run:
  * For each account percentage entry (as specified in the APT Editor)
    * For each combination of dimensions 1 & 2 (including the "no dimension")
      * Sum all journal entries to the source account over the specified time period, broken up by dimensions
      * Get the specified percentage for that sum
      * Add a credit journal entry to the specified credit account/dimensions with the given percentage
      * Add a debit journal entry to the specified debit account (and source dimensions) with the given percentage
  * Redirect to a journal entry page with all these journal entries already loaded in

  e-prast, to see the SQL that otherwise disappears too fast after running the tool, you can open this file:
  <FA root>/modules/acct_percent_tool/acct_percent_run.php and comment out the line that says "meta_forward(...)", about line 161.  Then see what SQL is there.

  Joe & Janusz, this module has only been tested against a code base from January 25.  (We have it in mind to get caught up soon!)  Have there been changes to the code that handles the retrieving of dimensions or accounts since then?  I wonder if that could be part of the problem...?

Tom

Go to forum: Modules Add-on's

8 Reply by tomhallman

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

Hello e-prast,

Thanks for sending that.  I was thinking more of the config option "show_sql" rather than the sql trail.  That way you'll see the SQL right on the account percentages module page.

Still, if I'm reading the sql trail correctly, it looks like there's a number of errors with the SQL queries.  Lots of "can't update and can't retrieve" stuff.  (See entries 61-68 and 74-83)

When you use the Account Percentages Editor (not the "Run" part), does it save your changes between page loads?  That is, save the values in the editor, leave the page, and then come back to the editor.

Joe/Janusz, do those errors make sense to you?  Any thoughts?  It doesn't seem to be limited to the account percentages tool to me...

Tom

Go to forum: Modules Add-on's

9 Reply by tomhallman

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

Hi again - I found a couple minutes here so I thought I'd take a look.

The tool *should* be able to be run on any date range whatsoever, so what e-prast is doing should be fine.

e-prast, could you turn on SQL debugging to see what SQL is being executed when you run the Account Percentages Tool?  That would be helpful in determining why data is not being returned.  (As a bonus step, you could try running that same SQL in phpMyAdmin to see if there IS any data or if something is wrong with the tool itself.)

Let me know what you find and I'll take a look as soon as I can.

Tom

Go to forum: Modules Add-on's

10 Reply by tomhallman

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

Hi guys!  I'm about to leave on a trip in just a few minutes.  I'd be happy to take a look at this if it can wait for a day or so.  I'll look at it at my first opportunity.

Tom

Go to forum: Modules Add-on's

11 Reply by tomhallman

(11 replies, posted in Reporting)

molyko,

  Perhaps you could send us a screenshot of what you're seeing?  I'm not sure if these forums support images, so you can send it to developers@lists.frontaccounting.eu.

Tom

Go to forum: Reporting

12 Reply by tomhallman

(4 replies, posted in Reporting)

Hi Alvin,

  I'm not totally sure I follow.  Could you clarify your needs?

Tom

Go to forum: Reporting

13 Reply by tomhallman

(9 replies, posted in FA Modifications)

Hi Chaitanya,

  Good observation!  We actually haven't released any reports that utilize tags yet.  But... it is now available for use in a future version.

  In the meantime, my organization has begun using them in custom reports, and that works great.

  Stay tuned!

~Tom

Go to forum: FA Modifications

14 Reply by tomhallman

(9 replies, posted in FA Modifications)

Hi chaitanya,

  This extension can't do that, but I actually have another extension about ready which will do this easily.  I should be able to get to packing this within the next few days.

~Tom

Go to forum: FA Modifications

15 Reply by tomhallman

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

Hello freddygl,

  Thanks for your feedback on the import modules.

  It is possible that I missed something when putting together the deposit/payment import, and I'd love to get it working if so. 

  Could you give a step-by-step description of what you do that normally works with Deposits/Payments, and then a step-by-step description of how the importing of deposits/payments doesn't work?

  I'd be happy to tackle that problem asap!

  Thanks again!

~Tom

Go to forum: Modules Add-on's

16 Reply by tomhallman

(9 replies, posted in FA Modifications)

Hello Pete,

  Sorry for the delay in response.  It's been a busy week!

  I really appreciate your thoughts and concerns in your post.  Let me see if I can help clear things up.

  It sounds like your main concern has to do with report integrity.  I'm totally on board with that! smile  However, isn't it quite normal in accounting reports to list only one side of a journal entry in some reports?  For example, the "GL Account Transactions" report allows me to select a given account and view only certain transactions.  The report doesn't balance, but it's not supposed to.

  So, I'm not suggesting that all reports would necessarily utilize tags, but only ones for which it makes sense.  For example, when you generate your "List of Journal Entries" report, it will still show all accounts whether or not they're tagged, since that's what makes sense.

  I'm merely suggesting that we make more report possibilities available without having to generate custom reports (which are more error prone as accounts or dimensions were added/modified).  For example, we would use tagging for the "GL Account Transactions" report.  The built-in reporting doesn't allow you to select arbitrary accounts or dimensions.  If you want more than one account or dimension, it has to be in sequential order.  But if we added tagging ability to this report, things are much more flexible!

  A use case of tagging on accounts and dimensions for the "GL Account Transactions" report would be viewing all HR-associated expenses for all cost centers located within the Northeast United States.  To do this, we'd create tags for "HR-associated expenses" (accounts) and "Cost centers in Northeast US" (dimensions).  If we get a new cost center in Boston OR add a new HR-related account to our chart of accounts, we just tag it appropriately and our report will pick it up next time.  No need to write new reports or update old ones!

  Does that make sense?

~Tom

Go to forum: FA Modifications

17 Reply by tomhallman

(5 replies, posted in Banking and General Ledger)

Fantastic!  Thanks Joe.

Go to forum: Banking and General Ledger

18 Reply by tomhallman

(5 replies, posted in Banking and General Ledger)

Hi Janusz,

  That's a good thought.  I know one area that we use it for is when a "fix" is made in another part of our financial software stack.  So, that other piece of software could export a deposit with a negative amount if a check bounced or something.  So if it IS a bug in FA, it's a useful one for us!  The only thing that would help is if the total had the correct sign.

  Hope that helps smile

~Tom

Go to forum: Banking and General Ledger

19 Topic by tomhallman

(1 replies, posted in Dimensions)

Hi again guys,

  I'm full of questions today smile

  It doesn't appear possible to re-open a closed dimension.  However, if a bill comes in after we close a dimension, there's currently no way to add that expense. 

  Is this something that could be added?

  Thanks!

~Tom

Go to forum: Dimensions

20 Topic by tomhallman

(5 replies, posted in Banking and General Ledger)

Hi folks,

  I noticed that when entering deposits and payments, if I have two items like this:

Item 1: $500
Item 2: -$750

  the total will say, $250 rather than -$250.  It seems to always be positive when I don't think it should be. 

  It appears that it gets entered correctly into the journal and the reports are correct, but that total is confusing in the interface.

  Is this a bug or am I misunderstanding?

~Tom

Go to forum: Banking and General Ledger

21 Reply by tomhallman

(9 replies, posted in FA Modifications)

Joe & Janusz,

  Hi guys!  I know you have a lot going on right now, but I was wondering if you got to talk about this "tags" feature?

  If so, what have you decided?  If not, do you know when you'll get to decide?

  I'd love to have this feature available soon, and I'd be happy to work on it myself (with your help) if you like.

  Thanks!

~Tom

Go to forum: FA Modifications

22 Reply by tomhallman

(9 replies, posted in FA Modifications)

Joe & all,

  I've put together an import module for journal entries/deposits/payments that I'd love for you to look at.  This one works a little differently than the items/customer import modules in that it doesn't automatically import everything, but rather stores the imported data in the $_SESSION variable and then loads the journal entry/deposit/payment entry screen.  This way the information can be reviewed and date/reference/memo data can be filled in before making the entry.  This fits with the needs of my organization, and hopefully will help others too!

  I also went ahead and created a budget entry import module as well, and this one does work more like the items/customer import modules.  (It just reloads the page and tells you how many entries were imported.)

  I'd be happy to share both of these (in zip format) with you to review.  How should I get them to you?

~Tom

Go to forum: FA Modifications

23 Reply by tomhallman

(4 replies, posted in Reporting)

Hi Alvin,

  I'm a little rusty on my joins and I don't particularly use the Items and Inventory module, but is this something like what you're looking for?  (I'm assuming those Xs are actually referring to different values, that is, X and Y.)

select distinct codes.stock_id, codes.description
  from 0_item_codes as codes
       left join 0_loc_stock as stock on (codes.stock_id = stock.stock_id)
       left join 0_purch_data as purch on (stock.stock_id = purch.stock_id)
       left join 0_stock_moves as moves on (purch.stock_id = moves.stock_id)
where stock.loc_code LIKE 'X' and
       purch.supplier_id = Y and
       stock.reorder_level >= moves.qty;

~Tom

Go to forum: Reporting

24 Reply by tomhallman

(9 replies, posted in FA Modifications)

Well look at that smile  I'd missed the item/customer import stuff.  Very nice!  I'll use those as models and get to work on this right away.

Thanks Joe!

Go to forum: FA Modifications

25 Topic by tomhallman

(9 replies, posted in FA Modifications)

Hi guys,

  My organization regularly receives deposit / journal entry information via CSV files, which we'd formerly been importing automatically into our old accounting package.

  I know that FrontAccounting has an import module available, but it's more complicated than our users need.  Here's the type of thing I'm thinking of:

1) Under Banking and General Ledger > Transactions have two more links: "Import Deposit" and "Import Journal Entry".
2) Both of these links would contain a simple file selection dialog.
3) After pressing the submit button, these (CSV) files would be parsed and placed into a Deposit or Journal Entry dialog.
4) The user would confirm that the information is correct, making any necessary changes, and then process the deposit/journal entry.

  This would save a lot of manual reentry, and I'm thinking that this wouldn't be difficult to implement.  I'd be happy to do it myself, though I want to see what you guys thought first.

  Thanks for your excellent work and for any feedback!

~Tom

Go to forum: FA Modifications