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 5.00.00 & 5.00.51 are required for the functionality described in this document  

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

Accessing the Agency Order

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

Note:  Agency Orders can be edited by highlighting an order from the list, then right clicking and selecting Edit (or 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, that will help them identify documents related to this agency order

Note: This field will be auto-filled if a Web Order and cannot be overwritten.
 

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 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 setup 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.
    
     

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. 

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

Calculate Grants        

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:

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.

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 do not allocate, 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 setup 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.