Agency Orders with Grants

Purpose of this document

Agency Orders are used to process orders from Agencies for product. These can be either “Shopping Orders” completed when an Agency is checking out, or a Pre-Order of product for pickup or delivery. An Agency Order in Ceres allows you to create the initial order, ship product, and finish by posting an invoice.

Agency orders can be created manually or via a more automated means such as the Agency Express 3.0 web ordering system. The Agency Order Overview document has detailed information about handling Agency Orders. This document provides supplemental information on Agency Orders where Grants apply to offset Agency Fees. See Related Topics section for many related documents regarding Agency Ordering.

Agencies that are qualified for Grant funds will see their fees reduced by the Grant Funds available to apply to some or all of their order. This document will discuss how Grants may be applied on an Agency Order as well as how to troubleshoot if the Grant does not apply.

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

TABLE OF CONTENTS

• Accessing the Agency Order
• Creating Agency Orders
  • Calculate Delivery Charge Functions
  • Calculate Grants

Accessing the Agency Order

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

2. If you are using batches, select your batch from the batch list; otherwise you will be taken directly to the list of open orders.

3. You will see the listing of open Agency Orders that exist within the system. Select one from the list to edit it or click New to create a new Order.  
    

Creating Agency Orders

1. Click New to create a new Agency Order.

Note: Agency Orders can be edited by double-clicking on the Order number.

2. 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, Order Date, and Shipment Date by using the Work Date.

3. In the Sell-to Agency No. field, enter the Agency No. or use the lookup to select the Agency from the list. The Agency’s name, address, branch code and Fund No. will flow from the Agency card. If the Agency has any invoicing information, shipping information or delivery information it will flow to the appropriate tab of the Agency Order. This includes location, delivery zone, payment terms, etc.

4. Fill in the Shopper field. This is the person who placed the order.

5. Fill in the Your Reference field with an Agency supplied document number, such as a purchase order number, which will help them identify documents related to this agency order.

Note: This field will be auto filled (and cannot be overwritten) if the Order is a Web Order.

6. Move to the lines of the Agency Order. Here you specify which items the agency is ordering, along with the quantity and any fees. Depending on the setup of the warehouse location, you may need to enter additional information here, regarding pallets, lots or bin locations. This will be discussed in detail in the Creating and Processing Agency Orders document section titled Agency Order Shipping Options.

7. In the Type field, select Item.

8. In the No. field, type in the Item Number or use the lookup to select the Item from the List. The Item’s Description, Unit of Measure, Available Quantity, and Agency Fee will flow forward to the line.

Note: Availability of items is subject to numerous factors including location, agency qualifiers and item qualifiers.

9. If you wish to change the Location for this line, in the Location Code field, select the Location where the Item will be shipped from.

10. If the Location you specified is not utilizing warehouse picks, then you must enter the Bin Code, Lot No. and Pallet No. The Pallet No. is only required for items that are set up as palletized items.

11. Select the Dimension Values that apply to the item for this order. If you require a Department and/or Projects, you will need to specify the Codes on the lines and on the Invoicing FastTab. If you enter the Department and Project on the Invoice Details FastTab, all lines entered will default to the same Department and Project automatically. You may change them on the lines if necessary.

12. In the Quantity field, specify the amount of quantity ordered.

13. Repeat the steps above for each additional item that will be ordered.

Calculate Delivery Charge Functions

Ceres provides the ability to calculate and charge the Agency for the delivery of product on the Agency Order. This is accomplished through the delivery zones and fees process which is explained in detail in the Delivery Zones and Delivery Fees document.

1. To calculate the delivery charge on an Agency Order, select Actions à Functions à Calculate Delivery Charge. This only applies to orders with a Shipment Method Code of DELIVER and there is a Delivery Zone on the order that has associated Delivery Fees.

2. Ceres will calculate the appropriate charge and insert a delivery charge line on the agency order (The G/L Account entered on the line is based upon the Delivery Charge (Account) No. assigned in Agencies & Receivables Setup).

Note: Delivery charges are only calculated if a Delivery Zone is defined on the order.

Calculate Grants

1. Ceres provides the ability to calculate and allocate qualified grant money to the Agency Orders. Grants should automatically calculate on the Agency Order lines if they apply. Ceres will automatically calculate grant applications for an Agency Order line anytime a line is created or an existing line is modified. This is true when the Agency Order line is manually created or modified by a user as well as for Agency Order lines that are modified or created by Ceres during the release process (for Shipment Option 1 and/or Shopping Zone orders) and posting of an Inventory Pick or Warehouse Shipment. During the posting of these warehouse documents Ceres will “explode” warehouse information back to their related Agency Order. In some cases this would result in the update of an Agency Order line, if it existed prior to the warehouse document’s creation. In other cases, Ceres will create new Agency Order lines to synchronize inventory usage information with the warehouse documents. Regardless of whether Ceres modifies an existing Agency Order line or creates a new one during this synchronization, grant calculation will occur for the Agency order line.

There are several types of qualifiers associated with Grants, explained as follows, that determine whether there will be a Grant Allocation Amount on the order line.

Agency/Grant Qualifier (aka Grant/Agency): For the Grant to apply on an Agency order, both the Grant & the Agency Cards must have the same qualifier assigned. All items on the order will qualify for the Grant funds if the Agency has the same qualifier as the Grant.

Item / Grant: For the Grant to apply on an Agency Order, the qualifier must be on both the Item Card and the Grant. Any Item that has the same qualifier as the Grant will be funded by the Grant if there are available grant monies.

Item / Grant / Agency: For the Grant to apply the qualifier must be on the Item, Grant and Agency Card. County qualifiers may also apply. See the Grants Receiving-Usage & Reporting document for more information. If Grant funds apply, the Grant Allocation Amount should be populated when the Qty. x Fees are calculated:

2. To see what Grant (or Grants) were used on the order line, click in the Grant Allocation Amount field and then on the ellipses to the right, and the Grants and amounts applied will display:

3. If more than one Grant applies, you will see all Grants applied in this window.
4. If the Grant funds are not automatically allocated on the lines where Grants should apply, to calculate the grant allocation on an agency order, select Actions à Functions à Calculate Grants.

5. If Grant funds are allocated to a line and you would like to remove the Grant Allocation for that specific line, select Line à Functions à Apply/Unapply Grant.

The Grant Allocation Amount will be removed and the “Grant Unapplied” box will be checked (it may be necessary to show the “Grant Unapplied” field via “Choose Columns”).

If you would like to restore the Grant Allocation, select Line Actions à Line à Apply/Unapply Grant and the Grant Allocation Amount will be restored and the “Grant Unapplied” box will be unchecked.

6. If the Grant funds still are not allocated, then you will need to troubleshoot why they were not applied. See below for suggestions for what to look for:

1. Are the appropriate qualifiers assigned to the Item, Agency and/or Grant?
2. Is the Grant released?
3. Is the Posting Date on the order AFTER the released date on the Grant?
4. Are there enough funds on the Grant to cover the amount on the line?
5. Is the Grant funded for specific Agencies only and does that Agency have a remaining balance to use for that Grant?
6. Please see the Grants Receiving-Usage & Reporting document for more information on Grant Setup, Grant Usage and Grant Reports.

Note: Grants cards may be set up with dimensions and funds. If dimensions and/or fund are specified at the grant card level, those value will be used when posting grant related general ledger entries for the agency order. If the dimensions and/or fund are not specified at the grant card level, then any dimensions and/or fund specified on the agency order line will be inherited on the grant related general ledger entries created by posting the agency order. Dimensions and fund specified on the grant card are a higher priority to the dimensions and fund specified on the agency order.