(6 replies, posted in Accounts Receivable)

oakstreet1 wrote:

What I did was I modified the invoice report (rep107.php) slightly to include an amount paid and the net amount payable.

That allows you do skip a bunch of steps and just create a direct invoice, apply the customer payment to the invoice, then generate an invoice that shows it is paid or partially paid with a net payable amount.

I can see how that would be helpful. Invoicing for prepayments should run through like Direct Delivery and Direct Invoice; when the amounts are paid of course. That's a good suggestion for FA to adopt.

Is it possible to get the payment terms from company setup moved further up the chain to Quotations?

I feel like I must be doing prepayments wrong.

The Sales Order does not include "Legal Text on Invoice:" from System and General GL Setup, and it is not possible to issue an  on Invoicing Prepayment Orders; this causes an error: "There is no non-invoiced payments for this order. If you want to issue final invoice, select delayed or cash payment terms." Due to these conditions, the client never receives notice of payment terms on prepayment sales because the invoice cannot be generated. It's a catch-22.

Likewise, invoicing paid in advance order generate a Pre-Payment invoice that shows the payment terms. It's a little confusing to appear on a final invoice document.

Do I have this someone complete backward?


Thank you rafat, I did confirm the report date range. The items do not show up. This may be related to a bug mentioned in the other thread, but I do take you are confirming they should have appeared in those locations, which helps explain the purpose.

Thank you

What is the purpose of the "Include in tax register" check box on the Journal Entry page? I have searched and searched...

It does enable the "Tax Register" tab, which calculates the input tax using the Base Amount Description (from quick entry setup) and clicking the "Go" button. What puzzles me is why, since tax payable and expenses were debited, and chequing credited.

I tested a journal entry with and without the tax register and "Tax Inquiry" and General Ledger Reports > General Leger > Tax Report are not affected (this could be related to a bug/issue reported in other threads - http://frontaccounting.com/punbb/viewtopic.php?id=8003 ).

This seems to be the same issue with the English Canadian COA.

Hi apmuthu,

So, if I understand correctly, I have to work within each current fiscal year, and pre-sort my transaction history by date. If I later find an error was made during entry, I can make changes to prior fiscal years (if enabled), but this should be considered a last resort.

Thank you for the reply


I have a small volume of transactions over four years that would be reasonable to re-enter (I am full time parenting and consult on the rare occasion). I don't have bank accounts or bank reconciliation to do (sole proprietorship and shared personal bank account). Can I enter transactions into FA over multiple years? ...can they be entered out of order? ...any problems to avoid?

(Some other year I'll incorporate, and add banking, to another FA database.)