26 Reply by myhandgunpursedotcom

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

myhandgunpursedotcom wrote:

Hey I am trying to use this module and having an issue with importing transactions.  The issue I am having has to do with my COA numbers I have created.  my account numbers are formatted like this: 5-00-000-01-01.  The import module won't recognize that kind of COA number, but if I put in a 4 digit COA number everything imports properly.

Can someone tell me how to make it work so my COA numbers will work properly?  Thanks.

Also, here is what I get when I run the trail run on my cvs file:
Skipped header. (line 1 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 2 ------------------------------------------------------------------------------------------
Error: Account code 5-00-000-01-01 does not exist
--------------------------------------------------------------------------------------------Line 3 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 15, 11/11/2016, JL25, 5700, 0, 0, -411.88 (line 3 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 15, 11/11/2016, 5700, 0, 0, 411.88, General Retail (line 3 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -411.88 (line 3 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 15, 11/11/2016, 1060, 0, 0, -411.88, General Retail (line 3 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 4 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 16, 11/12/2016, JL26, 5100, 0, 0, -272.45 (line 4 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 16, 11/12/2016, 5100, 0, 0, 272.45, Fuel/Auto (line 4 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -272.45 (line 4 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 16, 11/12/2016, 1060, 0, 0, -272.45, Fuel/Auto (line 4 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 5 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 17, 11/13/2016, JL27, 5100, 0, 0, -12.26 (line 5 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 17, 11/13/2016, 5100, 0, 0, 12.26, Fuel/Auto (line 5 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -12.26 (line 5 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 17, 11/13/2016, 1060, 0, 0, -12.26, Fuel/Auto (line 5 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 6 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 18, 11/14/2016, JL28, 5100, 0, 0, -357.98 (line 6 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 18, 11/14/2016, 5100, 0, 0, 357.98, Fuel/Auto (line 6 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -357.98 (line 6 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 18, 11/14/2016, 1060, 0, 0, -357.98, Fuel/Auto (line 6 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 7 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 19, 11/15/2016, JL29, 5700, 0, 0, -1000 (line 7 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 19, 11/15/2016, 5700, 0, 0, 1000, Transportation (line 7 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -1000 (line 7 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 19, 11/15/2016, 1060, 0, 0, -1000, Transportation (line 7 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 8 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 20, 11/16/2016, JL30, 5100, 0, 0, -14 (line 8 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 20, 11/16/2016, 5100, 0, 0, 14, Loading/Unloading (line 8 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -14 (line 8 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 20, 11/16/2016, 1060, 0, 0, -14, Loading/Unloading (line 8 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 9 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 21, 11/17/2016, JL31, 5700, 0, 0, -50 (line 9 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 21, 11/17/2016, 5700, 0, 0, 50, General Retail (line 9 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -50 (line 9 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 21, 11/17/2016, 1060, 0, 0, -50, General Retail (line 9 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 10 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 22, 11/18/2016, JL32, 5020, 0, 0, -89.06 (line 10 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 22, 11/18/2016, 5020, 0, 0, 89.06, Reefer Fuel (line 10 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -89.06 (line 10 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 22, 11/18/2016, 1060, 0, 0, -89.06, Reefer Fuel (line 10 in import file 'CSV_484074944.csv')
--------------------------------------------------------------------------------------------Line 11 ------------------------------------------------------------------------------------------
Added to table 'bank_trans': 23, 11/19/2016, JL33, 5100, 0, 0, -491.68 (line 11 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Debit: 23, 11/19/2016, 5100, 0, 0, 491.68, Fuel/Auto (line 11 in import file 'CSV_484074944.csv')
Added to table 'supp_trans' Debit: Supplier paid -491.68 (line 11 in import file 'CSV_484074944.csv')
Added to table 'gl_trans' Credit bank account: 23, 11/19/2016, 1060, 0, 0, -491.68, Fuel/Auto (line 11 in import file 'CSV_484074944.csv')
1 error(s) detected. Correct before importing.

When you Look at what it pulls up below all that, it shows the correct account number and account name.  I know FA doesn't like account numbers bigger than like 8 digits and I had to already make other modifications to the core to make my longer account numbers work in the program.

Go to forum: Modules Add-on's

27 Reply by myhandgunpursedotcom

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

Hey I am trying to use this module and having an issue with importing transactions.  The issue I am having has to do with my COA numbers I have created.  my account numbers are formatted like this: 5-00-000-01-01.  The import module won't recognize that kind of COA number, but if I put in a 4 digit COA number everything imports properly.

Can someone tell me how to make it work so my COA numbers will work properly?  Thanks.

Go to forum: Modules Add-on's

28 Reply by myhandgunpursedotcom

(5 replies, posted in Banking and General Ledger)

Ok, well I thought I had it figured out but I don't think I do.  I tried running a couple tests with the way I described above and I think it just made a bigger mess of things.  So apmuthu, if you could explain to me what the entry process would be in FA to make it track correctly I would greatly appreciate it.

Go to forum: Banking and General Ledger

29 Reply by myhandgunpursedotcom

(5 replies, posted in Banking and General Ledger)

Nevermind, I think I just answered my own question.  I just need to set the cogs account for that item as my revenue clearing account that I use to put the revenue from the settlement statements in and make the payments for expenses or deductions from the settlement statements before I show the account transfer in FA to show what the real number was that was direct deposited into the bank account.

Go to forum: Banking and General Ledger

30 Reply by myhandgunpursedotcom

(5 replies, posted in Banking and General Ledger)

apmuthu wrote:

Entry as "Loans provided" with appropriate journal entries when an earning is credited.

Can you explain with a little more detail?  Right the way I was entering it was under supplier invoices and created an Item called advances, but that put it into an expense category which I now realized was wrong.  But how would I make entering the advance easy so it does't take him multiple steps once I finish setting him up on the program?

I guess a little more clarification would help, he runs a trucking company where he receives a weekly settlement statement from the carrier he is contracted with.  It shows all of the revenue for loads he ran that week in one section and then shows all of the deductions like fuel, advances, insurance, etc. in a deductions section.  That's why I really didn't think anything of it while I as entering his statements in the other night and then the next morning I realized that the P&L statement didn't look right and that's when I realized I messed up on his advances.

Go to forum: Banking and General Ledger

31 Topic by myhandgunpursedotcom

(5 replies, posted in Banking and General Ledger)

Ok, here is my question.  I have a client who takes out cash advances every week.  How do I enter them into FA?  Right now the way it is on his settlement statements that he gets they are shown as a deduction with the rest of his expenses.

When I enter the settlement statements into FA I just was creating an item called advances in the expense category but now that I think about it I need to set it up differently because it isn't an expense it's a draw on future earnings.  Thanks for all your help in figuring out how to set this up correctly in FA.

Go to forum: Banking and General Ledger

32 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

All I was wondering is if there is a way to make it open up gmail directly just like the html mailto function.

Go to forum: Accounts Receivable

33 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

Bump, any response to last question?

Go to forum: Accounts Receivable

34 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

apmuthu wrote:

Alternatively, you can send the email out to your gmail address from FA and then manipulate it in gmail and forward to who you want.

If you are using Mercury Mail in Windows XAMPP then you can configure your mail client to approve all outgoing mail before being sent.

That's kind of counter productive sending it my gmail account first because then it'll show that I forwarded the email to who it needs to go to.

Is there no way to get it to call up gmail?  I know when I got  my company setup and click on the link next to my email address it pulls up gmail right from there with my address already pre-populated.

Thanks

Go to forum: Accounts Receivable

35 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

apmuthu wrote:

First decide where you will have your pdfs to be attached and what naming convention you would use so that the "id" of the invoice is part of the file name. When creating links, the invoice number will be available to the script which can be used to construct the desired link for the file. Check out the code where the invoice is attached and add a similar line for your file.

Please note that this kind of change should be attempted by PHP programmers and is not meant for the faint of heart. Sufficient debugging will be needed as well besides checks for file presence, content and permissions need to be taken care of.

Ok, how about an easier task than?  How can I get it to just open up gmail and attach the invoice but not send the message right away, that way I can edit the email and add other supporting documents?  Thanks.

Go to forum: Accounts Receivable

36 Reply by myhandgunpursedotcom

(3 replies, posted in Reporting)

apmuthu wrote:

Checkout the reporting/includes/doctext.inc and reporting/includes/header2.inc files.

Thanks for the reply.  What is the php coding I would use to call that information into those files?  I am not a programmer but ones I know how to call something I can figure out how to insert it into the .inc files.  Thanks

Go to forum: Reporting

37 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

apmuthu wrote:

All email in FA are sent using the class email which is in reporting/includes/class.mail.inc.

Search for the text "new email" in the FA code and all such places that use it will emerge and in FA it will be:

reporting/includes/inventory_db.inc => function send_reorder_email()
reporting/includes/pdf_report.inc => function FrontReport::End()

Since it is inside functions, search  recursively for each function call in the codebase.

I have no clue what you are talking about here.  I am not a programmer at all.  Can you explain in plain english please.  Thanks

Go to forum: Accounts Receivable

38 Topic by myhandgunpursedotcom

(3 replies, posted in Reporting)

Hey, can someone tell me how to get the shipping company name and address to show up on the sales order and invoice pdf's.  I want it to show up to the left of the Charge to and Delivered to.  I just need to know what files to edit and what lines of code to add.  I have figured out how to edit the layouts already.  Thanks

Go to forum: Reporting

39 Reply by myhandgunpursedotcom

(16 replies, posted in Accounts Receivable)

tomle wrote:

Thanks apmuthu.  I got it.  I changed the code and it works now.

tm,

I am a programer, and yes, it is very obvious of the process/procedure/logic.  It is however not obvious to know which class hold the code to make the change for newbie  to FA.  And yes, if you spent enough time comb through the code, you will eventually find it, and I did find it. 

But i thought the purpose of the forum is to quickly point out thing that other already had been through to speed up the process.  And yes, sometimes people asked the questions that already had been asked in the forum, which can be easily point to by users that are more familiar with the code.

My question is which class i need to make changes to, which I was hoping some senior users, eg. not age, but more FA code experience, can point me to.  Since I am a newbie to this FA, I just make changes to the class that help me solve my need, and git them so next upgrade I know where to make the change.

Thanks for info anyway.

For those of use that aren't programmers can't you help walk me through how to make this same change?

Thanks

Go to forum: Accounts Receivable

40 Reply by myhandgunpursedotcom

(14 replies, posted in Setup)

I just tried what you suggested and it is not working for me at all.  It either rounds the unit price to 2 decimal places if I have the display setup settings to 2 for price/amounts or if I set it to 3 and then click add item it keeps that the line total at 3 decimal places and the amount total at 3 decimal places when I need both of them to do the calculations and then round up to 2 decimal places.

What am I missing on getting this to work?  Thanks

Go to forum: Setup

41 Reply by myhandgunpursedotcom

(3 replies, posted in Installation)

apmuthu wrote:

Create the FA installs locally in each POS machine with the same SQL as in the online one. Then change the Reference Nos to be an unique prefix in each Setup->Forms Setup.

Now arrange to export the local db changes to the remote one filtered for the local prefix. This can be done with a php script linked to a "single click button" on the local POS install. This ofcourse assumes that there are no file uploads / documents in the local install that may have been changed.

Apmuthu,

Can you explain more about your solution here?  I am trying to do the same thing as vcrashed has asked about.  I want to have a local install of FA on my computer that I can use in an offline setting while at a trade show as my POS and have it sync with the online FA version once I get an internet connection again.

From your post it sounds like this is possible, but I want to make sure.  Also, I am not a coder so I wouldn't know how to create a "single click button".  Can you help me create this or point me in the right direction?

Thank you,

MyHandgunPurseDotCom

Go to forum: Installation

42 Reply by myhandgunpursedotcom

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

Hey JacobusB,

Not sure if you are still interested in this or not, but I have been using the FrontAccounting/OpenCart integration module for the past month now and love it!  It saves me hours of data entry and has reduced errors to almost zero!  If you are still looking for a solution, I strongly recommend the integration module from carbooks http://www.cartbooks.com/store/opencart

Good luck,

MyHandgunPurseDotCom

Go to forum: Modules Add-on's

43 Reply by myhandgunpursedotcom

(5 replies, posted in Setup)

itronics wrote:

The time displayed in bottom bar is server time. If your customers are in Iraq and you want displaye tehir local time, you should set timezone to Asia/Baghdad.
Janusz

Where do you make this change at?  I am in USA central time zone, would the timezone be America/Chicago?

Go to forum: Setup

44 Reply by myhandgunpursedotcom

(3 replies, posted in Items and Inventory)

joe wrote:

The reorder level is a warning about purchasibg new items. There is some list you can print out. Also if there is an email address on the location, an email is sent to that address when reaching this reorder level.

Joe

Joe,

Thank you for the quick reply.  That helps me understand it better now.

Thank you,

James
www.myhandgunpurse.com

Go to forum: Items and Inventory

45 Topic by myhandgunpursedotcom

(3 replies, posted in Items and Inventory)

Hey everyone, newbie here and loving the program.  Switching my company from QuickBooks and Vend HQ to FrontAccounting and Open Source POS this week using the integration software I found listed in this forum.  Can't wait to use it at our first show this weekend.

Anyways, I have been trying to understand what the reorder level does in frontaccounting but can't find anything written about it in the forum or wiki.  Could someone please explain to me how it works?

Thank you so much!

James
www.myhandgunpurse.com

Go to forum: Items and Inventory