A/R Collection Reporting Tool

[lxnow]

Tool to allow sales partners / sales people (essentially non-accounting users) to submit their collections via an online form, restricted to customers they are assigned to.

So instead of creating separate JV entries, this tool would be a more straightforward to report collections and matched with invoices. It would be the flip side of the existing Payment recon tool, but instead of selecting multiple payments to match an invoice, it would be selecting multiple invoices to match with a payment.

The tool should be heavily restricted in the information it conveys,e.g. no bank balances are shown. The required information to show are:

• Customer (restrictable by user properties)
• Outstanding invoice amount and details of Customer (restrictable by user properties, e.g. by sales partner)

---

Fields to show:

• Customer
• Invoice No.
• All invoice details and can be user trimmed or customized by system manager, except the tables like item details and tax tables. By all, I am also including custom fields
• Outstanding amount (may be different from Invoice Grand Total): this field should be pulled from database, but then also editable (similar to how it is now done in JV).
• Voucher Type: based on JV voucher types, such as bank voucher, cash voucher, credit note, etc. But ideally can be customized. But this Voucher Type will carry on into the JV entry (see workflow below)
• Voucher Reference: check number, payment reference number, credit note reference doc, etc.
• Total Amount of Voucher to be submitted
• Read only fields that calculates the difference of Voucher amount and the Sales Invoices
• Posting Date
• Submit or Update button

Workflow

1. Sales Partner fills out collection form by entering payment reference and payment amount (or credit note reference / credit amount)
2. Sales Partner select customer
3. Sales Partner fills out by line item the invoices to match against
4. When complete and difference = 0, Sales Partner hits the Update/Submit button, which locks the form. The form is then printable and has a Make JV button. Also has email option to alert accounting dept.
5. Accounting can then open the submitted form and hit Make JV if the offline paperwork is in order and confirmed.
6. A new pre-populated JV is then created based on the above information. The only lacking field would be the debit account which should be left blank, to be filled by accounting user

[rmehta]

We can call it "Payment Notification" ?

Estimate: 2-3 days