Thank you, but I'm not sure this is the solution.

I was able to void the customer payment, but the allocation of the payment is what remains. I suppose what I need to do is allocate another payment on a test system and see what changes in SQL.

It's strange there is no way to reverse an allocation.

Hello, I seem to have run into a bug, or limits of my understanding of how FA works.

Now I'm attempted to recall my steps, which may be inaccurate.

I entered a customer payment for a prepayment transaction before converting the quotation to a work order.

This prevented me from issuing a delivery against the work order because the payment wasn't allocated (a work order didn't exist).

It seemed the solution was to create a work order and allocate funds to it.

However, it was still not possible to create a delivery against a work order because it did not register the allocation as a prepayment.

Therefore, I decided it best to void the customer payment and follow the correct order of steps.

Unfortunately, the allocation remains, but the payment is gone.

In other words, I can't enter a new payment, nor can I create the work order, invoice, etc. This is a dead end.

How can I remove the allocation?



(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 - ).

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.)