I just noticed that a bank account is displayed on sales order entry screen in the V 2.4 demo.

Does this mean that V 2.4 will support accepting deposits at the time of accepting a sales order?

This remains a major omission from FA at present as I am sure there are many business that take a full or partial deposit at the time of order. It would be great if there was a payment entry section on the order entry screen that allowed a deposit to be entered and allocated against this customer transaction.

Being able to add an unallocated payment at time of taking an order is not really the best approach as there is no link at th etime of invoiceing that the credit exists on the customer's account.

I think this feature is a worthy addition to the Wishlist on the Wiki.

52

(20 replies, posted in Accounts Receivable)

ed10 wrote:

Thanks, RodW:

You can do the short naming automatically from a shopping cart?

Ed

Sorry, not been here for a few days. I can't see why you could not come up with an automated process to construct the short name from the full name once you establish the rules for your system. I think you'd have to check if the name already exists and increment the number if it does.

I'd like to raise this issue again as I spent some time last quarter reconciling all of this against the GL. Now I know FA gets the maths right!

This bit on the Wiki makes sense and is how it should be done.

7. So per 01/31/2010 we would enter a JE where we empty the Tax Accounts and counter book them on the Accrued Tax Account.
8. Now, when you pay the Tax via Bank Payment, you debit this Accrued Tax Account and your bank account is credited.

However, the system seems to get out of step as if you raise a journal entry against the tax accounts as it adds a tax transaction for the journal in the back end. If there is a journal, it is either a clearing entry as described above or it is to fix an error.

After my reconciliation, I think journal entries against the tax accounts should be exempted from reporting on the tax report or there is a flag provided to enable this. I should be able to do my final tax check after the balance is sitting in the Accrued tax Account and there is no balances in the tax accounts and this amount should agree with the tax report. Then I know I have done the complete job correctly.

If it is an error, (eg. may be I posted a sale as tax exempt when it was taxable and I am obligated to remit a portion of my sales), I would be manually recording details on the reports to demonstrate why the error needed to be corrected to support the journal entry. This scenario may mean there is a case to add an entry to the tax report if one side of the JE is against a sales account, but that may be a bit more complicated to implement.

If there is such a feature to enable excluding JE's from tax reports , please let me know as it would make life easier for me.

Rod

54

(20 replies, posted in Accounts Receivable)

Having experience some with Identifying people in large systems, I think the key to solving this problem is to enforce strong customer short name coding standards. Staff easily pick this up.

This may imply one more tick in Company setup that says search on short name.

I have used a couple of variants over the years depending on the short name field length. For example, lets use a 5,4 standard which would work as follows.
Rodney Smith - SMITHRODN
Roderick Smith - SMITHRODE
Roderrick Smith - SMITHRODE1

Where you get a duplicate short name, you just add a number to the end in order the conflicts occur.

In Company Names you end up with
Vehicle Modifications Network = VEHICMODI
Vehicle Modifications Nursery = VEHICMODI1

Some companies like to end all Companies with PL

Currently, I am using this standard for business shortnames and
for customers Smith, Rodney

You'll be surprised how few duplicates arise from your Smiths with this standard and it could be extended to a 6,4 or larger within the field length but remember to retain at last the last 2 characters of the field  for the number codes at the end.

55

(4 replies, posted in Accounts Receivable)

Just a tip for you here. I ave added a period to some of my default groups so the sort to the top of the list. More for Customer groups. eg. I use ".Retail" not "Retail"

I can confirm. Did it myself today and there were no dramas. Just copied new source to the facc folder

Mesjoggah, can you expand on what you to achieve?

I am keen on this as well and hope to eventually have full integration between a Joomla Virtuemart store. Replicating users from Joomla to FA would be part of this process so I might be able to assist in some way.

I will add to this post. Having used FA for a while now, I think there was some buggy stuff in earlier versions (Or did I stuff it up while I was learning how to do things?).

Anyway, for me, there are a number of problems with allocations in my DB  so that some supplier accounts incorrectly show that they have a balance outstanding or they have some payments recorded that have nothing to allocate against. I would like to clean this up so they don't report or print statements.

I also have some customers with stuff I can't clear out in a similar manner too.

If the supplier part  could be answered, it would be appreciated. I am happy to clean up in the back end and leave the customer side for another post.

Rod

59

(9 replies, posted in Setup)

I looked at doing this today too. I found a link somewhere that suggested it be done in the .htaccess file in the /facc folder by adding this code:

RewriteEngine On 
RewriteCond %{SERVER_PORT} 80 
RewriteCond %{REQUEST_URI} facc 
RewriteRule ^(.*)$ https://www.domain.com/facc/$1 [R,L]

This worked for me and took all of 2 minutes to do but if somebody could outline the pros and cons of using .htaccess v's the other approaches shown, I'd appreciate it.

Rod

You Probably have read only premissions on your server on the file you are updating. Change it to read/Write, do your edits, than revert it to read only again. Happens to me all the time...

Kinda good really, Makes you realise somebody at FA actually cares about security smile

61

(7 replies, posted in Wish List)

CraigP wrote:

Yes, all HP JetDirect cards support FTP and it is enabled by default (Can be disabled, but most don't)  Brother printers support FTP as well, but only of PS documents.

Would it be possible to allow a command to be run to post-process the PDF output?  Most Linux distributions include ghostscript by default which includes PDF2PS (lowercase) which is easily called as pdf2ps input.pdf output.ps to output a file or pdf2ps input.pdf and the output is returned to standard out.

Thanks,

Craig.

Craig, You are on to me! You have found the tool I spoke of that is part of XPDF which lives here:
http://www.foolabs.com/xpdf/
The syntax of this command can be found here:
http://linux.about.com/library/cmd/blcmdl1_pdftops.htm

I have seen the open source XPDF tool bundled into high end graphics conversion software so it is pretty robust.

I think your Brother is running a buggy third party emulation of Postscript which does not support native PDF rasterising so it is failing. Best postscript support comes from the genuine Adobe PS3 Raster Image Processor (RIP), but RIP offerings from Harlequin and Jaws are also excellent. Look to see if PCL can be disabled on the Brother as it is possible the Auto sensing gets it wrong and trys using PCL incorrectly.

I would recommend output is created using the -level2 switch which will generate Postscript Level 2 code that is more likley to be parsed on a wider variety of output devices.

I can't see why pdf could not be spooled to disk by FA using the and then the resulting PS file sent to a printer.

I would suggest that the PDF to PS conversion  and PS job submission be separated from FA and be activated by a separate monitored "hot folder" processing system. That way, all that  FA needs to do is to write a PDF file to a folder and not display it on screen and this external system takes over. If you have a dig on some of the PDF communities like PlanetPDF, you will probably find a tool that does this for you.

POSTSCRIPT smile
Postscript was the precursor of PDF but was an interpreted language so it needed to run the whole program before you could see the output. Adobe saw the need for robust portable document format and responded by developing the object oriented PDF specification. The great advantage of this is that everything in the document is treated as an object and the tail of the PDF includes an index to the page objects which in turn have pointers to the objects on the page. This allows post processing of and navigating through PDF files very efficiently. I would not call PDF a wrapper around Postscript but because of the common heritage, Postscript can be converted to PDF very efficiently. Acrobat Distiller is basically a POstscript RIP that outputs PDF files rather than raster images for printing.

62

(7 replies, posted in Wish List)

I think you will find the reason why HP accepts PDF and Brother does not is that most HP printers support Postscript and PCL while the Brother may just print PCL.

Postscript Level3 (which has been around for a few years now) natively supports printing a PDF file. If your Brother is actually a Postscript printer, it may only support Level 2 and hence have no PDF support.

You may be able to use Ghostscript to emulate  postscript printer on a non postscript device but it is a long time since I played with it at all.

I am not up with Unix, but also have a look at the XPDF suite  (also available for Windows). It includes a command line tool that converts PDF to PS. Perhaps you could modify your script to convert the PDF file to PS then send the PS to a Postscript Level 2 printer.

Good luck!

63

(6 replies, posted in Accounts Payable)

And here is the 2.2 bug report. with updated files
Issue #215: http://mantis.frontaccounting.com/view.php?id=215
Has there been a regression? I have not revisited this to check it still works.

64

(6 replies, posted in Accounts Payable)

ed10

I found my earlier post about this bug
https://frontaccounting.com/punbb/viewtopic.php?id=1190

I did edit this report to print the shipping address and a bug was acknowledged so it will be interesting to see if my PO still prints the delivery address when I next raise a PO

An interesting discussion, but it seems to me the example with the pallet is mixing Retail/Wholesale pricing with volume discounts.

Maybe the addition of volume discounts should be put on the agenda. Maybe a product/sales group pair has another table(s) with entries like:
qty 0-100  $120
qty 101-500 $100
qty 501-1000 $90
qty 1000-99999 $80

Of course the existing functionality around % or $ could still apply.

66

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

Tomand I have done a bit more work on this and it is looking good for a 2.3 version with GST/VAT support for tax inclusive pricing.

We need to check out the impact of different customer records in 2.3. Eg Customer/Branch/Contact and neither of us has looked at that yet. Any pointers will be appreciated. The earlier 2.2 version only went Customer/Branch

67

(6 replies, posted in Accounts Payable)

What version?
There was a bug at one time (2.2.6 I think) that did not print the shipping address. I modified the report to fix but I think the dev team resolved the bug another way.

Once I ifxed it, I could enter customer's address in Shipipng address and supplier drop shipped for me no problems.

68

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

hi guys

I have used this before in the earlier version.

I am trying to get this working in FA 2.3 RC3 and am running into troubles. It is getting as far as creating the new data table but then it never finds the table again so the Update MySql Button is never displayed.

I have narrowed it down to this bit of code which sets $found = 1 if it appears in the show tables list returned by SHOW TABLES.

$sql = "SHOW TABLES";
$result = db_query($sql, "could not show tables");
$found = 0;
while (($row = db_fetch_row($result))) {
    if ($row[0] == TB_PREF."oscommerce") $found = 1;
}

I have confirmed it is not formatting the table name correctly in a multi company situation as if I ask it to look for a hard coded "0_oscommerce", it works.

So how do you return a string with the company number prepended to the table name?

Hi Guys, just catching up on the latest FA developments and this sounds interesting. I am pretty sure (witout reading the UK Links) that if you fix this for Cash Accounting of VAT, it will also satisfy the Cash accounting requirements for Australian GST.

I resigned myself to running my GST in an Accrual basis so I think this will be a good extension

70

(5 replies, posted in Installation)

Thought I'd keep adding to this thread. I want to upgrade from 2.2.6 to 2.2.7

Is the Wiki still correct? It seems to be referring to an earlier version upgrade.

A couple ofquick pointers would be appreciated.

itronics wrote:

Yes, contacts table for customer/supplier relationships is definitely good idea.
Rod, could you add this idea  to future development wiki page for later discussion/refinement?
Janusz

Sorry, it has taken me a while to get to this as I was away for a week or so but I have done as you asked.

72

(3 replies, posted in FA Modifications)

pierre wrote:

Hi all

I need to change the word INVOICE in the right top corner of a Invoice to Tax Invoice can any-one please help me and tell me where I can find this in the php pages. the only file I can find is ...reporting/rep107.php

Kind Regards
Pierre

Pierre, If you are doing this becasue you live in Australia, the Australian language I created does this and a whole lot more!

73

(9 replies, posted in Accounts Payable)

I think this would be a good idea. There is quite a bit of unnecessary wok in FA where you have to make supplier payments and customer receiptsand then subsequently allocate the transaction.

While you are at it, could you also consider being able to allocate a receipt (deposit) to a sales order for customer transactions. It sucks having to wait until an order s delivered and invoiced before a customer deposit can be allocated against the transaction. That process is very similar to what is proposed for PO's above, just on the other side of the ledger.

I have a lot more deposits on sales orders than prepaid purchase orders.

Good idea Tom. Even better would be the ability to add a list of contacts for a company in another table and select one of these to be the Sales contact and another to be the Accounts contact. You would then need to be able to select the contact to email when sending the purchase order.

I had noticed that that there was no way to add additional contatcts/emails to the suppliers which I thought was a weakness.

In a previous situation we synced our front office system with Goldmine. the front office was the master.
1. Customers added to the master system appeared in Goldmine
2. Quotes done in Master system apeared as Opportunities in Goldmine
3. When Quotes were converted to jobs, the opportunity was marked as won in Goldmine
4. When Quotes were marked as lost in the master system, the Opportunity was marked as lost in Goldmine

All opportuinty followup was done in Goldmine. All marketing campaings/follow up letters done in Goldmine.

Anyway, something like that would fairly closely define minimal interface betwen FA and a CRM system like Sugar.

Perosnally, I have found Sugar to be terribly slow and unresponsive to use when compared with FA whose speed in the interface is first class.

The CSV import features of Sugar are very comprehensive so perhaps even creating import files in FA would be a good start.