Customization DS1330: Transfer Credits from National Accounts Child to Parent

Customization DS1330

Transfer Credits from National Acct Child to Parent

Problem Definition:

ACME uses the National Accounts functionality in Dynamics GP. The Parent Account gets invoiced for Child orders. However, the Child receives rebates (which are Credit Memos in GP). Currently, to move a credit from the Child level to the Parent, ACME is manually creating a Debit Memo and applying it to the Child account, then creating a new Credit Memo on the Parent Account. This process is time consuming and loses track of where the credits came from.

ACME would like a more automated way to transfer credits from the Child to the Parent in a National Account relationship, and keep track of the rebate history (i.e. so a credit at the Parent level can be traced to the Child from which it was transferred).

ACME does not use Multi-currency.

Solution Overview:

WilloWare will create a Child Credit Transfer window that shows the total amount of unapplied Credit Memos on Child Accounts in a National Accounts relationship. The user will be able to easily transfer all credits from a Child to a Parent from this window. History of the transfer will be retained so that when viewing a credit at the Child or Parent level it will be easy to see where it went (child to parent).

Design Features:

Child Credit Transfer:

Navigation: Transactions>>Sales>>Child Credit Transfer

Table Description automatically generated

Field Function
Transfer Credits See process description below. The Transfer Credits process moves credits from children to the national account parent
Mark All Mark All customers shown in the window
Unmark All Unmark All customers shown in the window

The Child Credit Transfer window shows Customers that are the Child in a National Accounts relationship which have unapplied Credit Memos (partially or completely unapplied). It does not show other sources of credits, such as Sales Returns. The expansion button will open a window showing a Customer’s Credit Memos that have an unapplied amount.

Table Description automatically generated

The Expansion button on the Unapplied Credit Memos window will open the selected document in the Receivables Transaction Inquiry Zoom window:

Table Description automatically generated

For each Credit Memo on a Child Customer, the utility will:

  1. Create a Debit Memo for the unapplied amount (“Current Transaction Amount”)
    1. The Credit Memo Document Number will be put into the Description field of the Debit Memo.

Graphical user interface, table Description automatically generated

b.

  1. Post the Debit Memo
  2. Apply the Debit Memo to the Credit Memo
  3. Create a Credit Memo for the Parent Customer.
    1. The original Child Credit Memo Document Number will be put into the Description field of the Parent Credit Memo.
  4. Post the Credit Memo

NOTE: putting the “source” Credit Memo number into the Description field of the related “credit transfer” documents is intended to provide some linking between the documents so that, if needed, it will be possible to trace a CM on a National Account Parent to the child’s original document. No inquiry window or reporting is provided in this estimate that ties all of the documents together.

Assumptions/Requirements:

  1. The functionality described above will not work with eConnect, any software that uses eConnect, or any software that directly writes to, updates, or deletes from SQL tables.
  2. The functionality described above is intended for the GP Desktop client.
  3. Advanced Distribution functionality is NOT used.
  4. Unless otherwise noted in this document, reporting is not included in this estimate.
  5. Unless otherwise noted in this document, Word Template functionality is not addressed.
  6. 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 on this design, or any other WilloWare customization or product, please contact us:

www.willoware.com/contact-me/