Cash application by invoice line item

Bloxham

We have a client who needs to apply cash to sales invoices by invoice line item. Some invoices have over 100 lines and the customer does not always pay for all of them. The line items not paid for must be left open on the invoice so they can be reconciled and rebilled. Has anyone seen a mod, add-on or other method that allows for this? TIA
Robert

Dave_Cox

Why not use the Standard Ship and Invoice Create a Invoice Based On the Shipped Quantities.

When you receive the Rmmittance from the Customer have a Reconciled flag on the line which sets the Qty. to Invoice.

For Management Accounting use the Shipped not Invoiced Report then the Reccuring Journal to post in Values for reporting.

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

Dave_Cox

How about adding a boolean field to the Customer "Manual Reconcile"

Three to the "Sales Line", "Sales Invoice Line"
Reconciled, "Reconciled Amount" and "Reconciled Amt. (LCY)"
Add new Key or SumIndexFields for the "Cust. Ledger" FlowField

In the Sales Line C/AL Code
If the customer is not flagged as or "Manual Reconcile" the Reconciled Amounts = Invoiced Amounts

Sales Lines
Manual flagging populates the "Reconciled Amount" fields if only if the Outstanding Qty = 0

Sales Invoice Lines (New Form for "Sales Invoice Line")
Manual flagging populates the "Reconciled Amount" fields with the Invoiced Amounts

"Cust. Ledger Entry" two flowfields based on Invoiced Lines Reconcile Amount fields
"Reconciled Amount" and "Reconciled Amt. (LCY)"

In the Application of Customer Ledger Entries CodeUnit if "Document type"::Invoice

Calcfields for the new flowfields then the Application Amount would be:
"Reconciled Amount" -(Amount - Remaining Amount);

Then apply the same in the "G/L Post Line" Customer Application
so the Applied Amount would be:
"Reconciled Amount" -(Amount - Remaining Amount);

Think this may be better than my first Answer but it is late!

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk

[This message has been edited by Dave Cox (edited 30-06-2000).]

[This message has been edited by Dave Cox (edited 30-06-2000).]

Bloxham

Thanks for responding. Your answer was plenty timely. We are only now quoting on the project, but other customers of ours would benefit from this mod. Thanks again.
Robert Bloxham
rbloxham@vertexsoftware.com

Dave_Cox

I would point out that this is just My analysis of your question.
Of course you will need to consider a lot more the way this would work in practice.

Please let me know if you develop this solution, if you need any further help let me know!

---

MindSource (UK) Limited
Navision Service Partner

david@mindsource.co.uk
info@mindsource.co.uk