Agency Credit Memos (v6.0)

Modified on Wed, 20 Sep, 2023 at 9:49 AM

Agency Credit Memos

Purpose of this document

An Agency Credit Memo should be used when the intention is to create a financial credit to the Agency Account to reverse Agency Fees on an Order. Agency Return Order functionality overlaps, but those are more typically utilized when Items and Quantity are being returned. A financial credit is automatically created and posted as part of the Return Order process (if applicable).

Ceres Object release 6.00.00 is required for the functionality described in this document.

TABLE OF CONTENTS

Setup Options
Creating Agency Credit Memos

Setup Options

Ceres has configurable options available that will affect both Agency Credit Memos and Agency Return Orders. The two options available allow the ability to configure Ceres to disallow the entry of items on Agency Credit Memos, forcing product returns to be handled through the Agency Return Order process. In addition Ceres can be configured to allow new pallets to be created on product returns instead of returning the product to the pallet it was shipped from. Both options can be found on the General Tab of the Agency & Receivables Setup page.

Agency & Receivable Setup page can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “agencies” in “Tell me what you want to do” then selecting “Agencies & Receivables Setup” from the results in the Go to Pages and Tasks section OR by selecting the “Agencies & Receivables Setup” menu action (if present) from your Role Center home page.

A complete explanation of the fields on this page may be found elsewhere in related documents, but the two fields important to both Agency Return Orders and Agency Credit Memos are documented here.

Exclude Item from CM – Toggle on this box to configure Ceres to prevent the entry of items on Agency Credit Memos. To return items to inventory from Agency Orders, the user must use Agency Return Orders. An attempt to place items on an Agency Credit memo with this field checked will result in the following error.
Allow Pallet No. Change CM/RTO – toggle on this field to configure Ceres to allow creation of a new pallet when returning product or to allow the user to return the product to another pallet of the same item. If a new pallet is created, the pallet will inherit all properties of the original pallet, including lot number and FBC & UNC codes. If the user attempts to return the item to another existing pallet, it will only be allowed if the coding of the FBC & UNC codes matches exactly the coding of the original pallet the item was shipped from. If no existing pallets have the same coding as the original pallet, the user will be forced to create a new pallet. With this option checked, the user still has the ability to return the product to the original pallet it was shipped from.

Graphical user interface, text, application

Description automatically generated

Creating Agency Credit Memos

Agency Credit Memos page can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “agency credit” in “Tell me what you want to do” then selecting “Agency Credit Memos” from the results in the Go to Pages and Tasks section OR by selecting the “Agency Credit Memos” menu action (if present) from your Role Center home page.

If you are using batches, select your batch from the batch list; otherwise you will see the listing of open Agency Credit Memos that exist within Ceres. Select one from the list to Edit it or click New to create a new Credit Memo.

Agency Credit Memo Header

Click New to create a new Agency Credit Memo. The Document window will open:

Graphical user interface, application

Description automatically generated

Press the Enter key to have Ceres automatically assign the next document number in the No. field. This will also fill in the Posting Date and Document Date by using the current Work Date.

In the Agency No. field, enter Agency No. or use the lookup to select the Agency from the list. The Agency’s name, address, contact, Branch Code and Fund No. will flow from the Agency Card.
If required, fill in the Responsible Person field. This is the person who is creating the credit memo.

If applicable, select the Shopper who placed the original order that you are correcting or crediting (if you have checked “Exclude Item from CM” in A & R Setup, then you will likely not need to select a Shopper as you can only enter G/L lines on the Credit Memo in this scenario).

Agency Credit Memo Lines

Move to the lines of the Agency Credit Memo.

In the Type field select Item if product is being returned. Otherwise select G/L Account to record a credit on their account.
In the No. field, type in the item number or the G/L Account number. You can also use the lookup and select from the list. The Item’s Description, Unit of Measure, and Gross Weight will flow forward to the line. If a G/L Account was selected, the name of the G/L Account will flow.
Enter a Return Reason Code (if required).
In the Location Code field, select the Location where product is being returned to.
1. If a G/L Account is selected, then no Location information is required.
If the Location you specified is set up to require Bins, select a Bin Code. The Bin selected should be the bin where the product is being returned to.
In the quantity field enter the quantity, cases, pounds, etc., that is being returned. If the Account Type is G/L Account then enter 1.
In the Unit Fees column, enter the unit fee or the amount that you are crediting.

Note: If you are not crediting the entire quantity, in order for the Amount Including Tax field to update, the Credit Memo must be released. If the Quantity has to be changed again, you must Reopen the Credit Memo, adjust the Quantity and then Release it again to update the Amount Including Tax field. (When the Credit Memo is reopened, the Amount Including Tax is set to $0.00 on the lines). If you do not Release the CM after changing quantity and before posting, the Amount on each line will not be calculated correctly.

If required, enter any Dimension Codes for posting on the lines.
If Ceres is configured to allow new or changing of pallets, you may enter the pallet number you wish to return the product to. If it is desired to create a new pallet for the returned item, you must ensure that a proper tier and height is entered on the line and that the pallet number field is blanked out. At that point you can create pallets by selecting Actions à Functions à Create Pallets.

Posting the Agency Credit Memo

When the Agency Credit Memo is complete and has been reviewed, you can post the Credit Memo by selecting Post. A hard copy (or .pdf copy) of the Credit Memo can be printed by selecting Post and Send, depending on your default printer settings.

Posted Agency Credit Memo can be accessed by selecting “Search” from the Dynamics 365 Business Central Banner and entering “posted credit” in “Tell me what you want to do” then selecting “Posted Agency Credit Memos” from the results in the Go to Reports and Analysis section OR by selecting the “Posted Agency Credit Memos” menu action (if present) from your Role Center home page.

Using Copy Document

You can use the “Copy Document” routine to copy an existing document to the Credit Memo. This function can be used to copy an un-posted or posted document.

On the Agency Credit Memo, navigate to Prepare à Copy Document.

This will open the Copy Document Window. Select the Document Type you wish to copy from (i.e. Posted Invoice or Invoice) and enter Document No. to copy or select from the drop-down.

Toggle Include Header field on if you want Ceres to copy the information, including dimensions, from the document header you are copying from to the document you are creating. The document lines will be copied regardless of the entry in this field.

Toggle Recalculate Lines field on if you want to recalculate the lines in the document you are creating. The process retains the item numbers and item quantities but recalculates the amounts on the lines based on the agency information on the new document header. In this way, the process accounts for item prices and discounts that are specifically linked to the agency on the new document header.

The information has been copied to the new document. Edit as needed prior to posting.

You can also use the “Get Posted Document Lines to Reverse” function to copy one or more document lines from one document to another. This allows you to select specific lines from multiple documents or the same document if you are not crediting the entire document(s).

The Get Posted Document Lines to Reverse is covered in additional detail in the Agency Return Order Document.

Once all the lines have been entered or copied and a review of the document to verify the information on the lines and the total credit memo has been completed, then the document can be posted.