Customization CR1017 Write Off Small Balances

Customization CR1017

Write Off Small Balances

Description of Need:

ACME would like to automate the process of small document write offs for the following documents:

  • Invoices with the amount remaining of $15.00 or less, unless:
  1. The document is on a Scheduled Payment Plan.
  2. The original document amount is $15.00 or less.
  • All outstanding Late Fees if the original invoice amount is paid in full.
  • All outstanding Finance Charges if the original invoice amount is paid in full.

Description of Solution:

The user will continue to use the Write Off Documents window to perform the write off process.

Navigation: Routines>>Sales>>Write Off Documents

A screenshot of a computer Description automatically generated

The enhancement requires the user select the Writeoff Type = Underpayments and the Create One Writeoff per = Document, but all other entries and selections, including the Customers filters can be used to further restrict documents.

To activate the enhanced functionality, click Additional >> Write Off Small Balances. When the enhancement is active, the window title bar will be updated to read: Write Off Documents ~ Small Balance Enhancement.

NOTE: The below functionality will only occur if the enhancement is active.

When the PROCESS or PREVIEW buttons are selected, the enhancement will use the user entered filters in addition to the enhancements requested to only return the following documents:

SALES / INVOICES where:

Amount remaining less than or equal to the value entered into the Writeoff Limit Field ($15.00)

AND

The invoice is not on a Scheduled Payment Plan.

AND

The original invoice amount was equal to or less than the value entered into the Writeoff Limit Field ($15.00)

DEBIT MEMOS where:

The Customer PO field is “LATE FEE”

AND

The original invoice was paid in full. The original invoice number is stored in the transaction Description field.

AND

The late fee is not on a Scheduled Payment Plan.

FINANCE CHARGES where:

The Customer PO field is “FINANCE CHARGE”

AND

The original invoice was paid in full. The original invoice number is stored in the transaction Description field.

AND

The finance charge is not on a Scheduled Payment Plan.

All other documents that might normally be included by GP will be ignored.

The user can click PREVIEW to review the documents that will be written off.

Click the PROCESS button to execute the GP Write off process for the entered documents. As part of the custom processing, the enhancement will add the following to the Credit Memo description, depending on the document type of the written off debit:

SALES/INVOICES- “Write-Off Small Balances

LATE FEE or FINANCE CHARGE- “Interest & Late Fees”

Assumptions/Requirements:

  1. The functionality described above is intended for the GP Desktop client.
  2. Unless otherwise noted in this document, reporting is not included in this estimate.
  3. Unless otherwise noted in this document, the enhancement will not integrate with 3rd party products. Some examples of 3rd party products would be:
  • An ISV plug-in product including WilloWare products
  • A dexterity customization designed by another developer
  • Dynamics GP Modules including, but not limited to:
  • Project Accounting
  • MDA
  • Analytical Accounting
  • Copy functionality found in SOP, POP and Inventory
  • Field Service
  • Extended Pricing
  • Manufacturing

For information about this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/