Purchase Orders and Invoices with Grants (v6.0)

Modified on Wed, 15 Nov, 2023 at 9:27 AM

Purchase Orders and Invoices with Grants

Purpose of this document

Purchase orders are used to process inventory orders from vendors that involve a dollar value. A purchase order in Ceres allows you to create the initial order, receive product, and finish by posting an invoice. Alternately for a non-inventory purchase, you may start with a purchase Invoice directly.

Sometimes food banks will also have grant funds that are available to use for purchasing inventory or covering other types of purchases. This document will address how to assign grant funds to a purchase order for inventory purchases, and purchase invoice for other types of purchases.

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

TABLE OF CONTENTS

Creating Purchase Orders
Creating Purchase Invoices

Creating Purchase Orders

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

If you are using batches, select your batch from the batch list; otherwise click Cancel.

A list of open purchase orders that exist within Ceres will be displayed. Select one from the list to edit or create a new order.

To create a new purchase order, select New.

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 Document Date by using the Work Date.

In the Buy-from Vendor No. field, enter the Vendor No. or use the lookup to select the vendor from the list. The vendor’s name, address, and Fund No. will flow from the Vendor Card.

Lookup on the FBC Product Source field to select a product source. This mandatory field provides information to the Quarterly Poundage Report. The UNC Product Source field will update based on the FBC Product Source selected.

Lookup on the FBC Product Category field. This mandatory field provides information to the Quarterly Poundage Report. It is imperative that FBC Product Source and Product Category codes are linked to valid UNC Codes from Feeding America. See FA Reporting and UNC Coding (QPRs-Blue Receipts) Procedure document for additional information.

For Orders that are covered by Grants, this would typically be GRANTPURCH (or similar). Make sure that your FBC Product Category is linked to the UNC Product Category of GRANTPURCH by clicking on the down arrow in the FBC Product Category field and selecting Advanced to see the linkage.

Enter the Grant No. on the Purchase Order Header or use the down arrow to select from a list of purchase grants.

Note: Only grants that have an Apply To type of Purchases or Agencies/Purchases will display here.

Move to the lines of the purchase order. Here you specify which items you would like to purchase, along with the quantity and any costing information.

In the Type field, select Item.

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, and Direct Unit Cost will flow forward to the line.

In the Location Code field, select the Location where the Item will be received.

If the Location you specified is set up to require Bins, select a Bin on the Bin Code field.

In the Quantity field, specify the amount of quantity ordered. The quantity is in reference to the Unit of Measure field.

Note: If Lot Nos. has been specified on the Item Card, a Lot No. will be generated at this time. If the item is purchased on more than one lot, you will need to create an additional line.

If applicable, fill in the Lot Expiration Date and Lot Consume By date fields.

Note: These fields may have already been pre-generated by the calculation formulas set on the Item Card. In this case, you may review and adjust these dates on the order, as necessary.

Select the dimension values that apply to the item for this order. If you require a Department, you will need to specify the Department Code on the lines and on the Invoice Details FastTab.

The Grant No. selected in the Purchase Order Header will display in the lines and if there are grant funds available, the Grant Amount will populate.

Note: Depending on how the grant is set up and the amount of funds available, the Grant Amount may not be the same as the Line Amount.

If the Grant Amount is not calculated, it may because.

There are not enough funds available on the Grant.
The Grant is not Released.
The Posting Date on the Purchase Order is beofer the Effective Date on the Grant.
The Expiration Date on the Grant has been passed.
Other.

It is possible to reduce the funds covered by the grant by typing the new value in the Grant Amount field.

If the user tries to enter more than the amount on the line, they will receive an error like this one.

Repeat the steps above for each additional item that will be purchased on the order.

Refer to the Purchase Order Overview Procedure document for additional steps on how to process a purchase order.

Creating Purchase Invoices

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

If you are using batches, select your batch from the batch list; otherwise click Cancel.

A list of open purchase invoices that exist within Ceres will be displayed. Select one from the list, edit or create a new order.

To create a new purchase invoice, select Home à New.

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 Document Date by using the Work Date.

Enter the information as you would for a purchase order and select/enter the Grant No. to be applied to the Invoice in the Invoice Header.

Be sure to fill in the FBC Product Source and FBC Product Category as described earlier in this document.

In the Lines section, enter the Type for your purchase. Often this is a G/L Account but may be a Fixed Asset or other.

Select/Enter the appropriate corresponding No. and enter the quantity (usually this is 1).

Enter the Direct Unit Cost. The Line Amount will populate based upon the Quantity x the Direct Unit Cost.

Select the dimension values that apply to the item for this order. If you require a Department, you will need to specify the Department Code on the lines and on the Invoice Details FastTab.

The Grant No. from the header should display on the line and if funds are available on the grant, they should calculate and display.

If the Grant Amount is not calculated properly or at all, be sure to check the reason why above.

You may also reduce the Grant Amount calculated, but you may not increase it more than the amount on the line.

Refer to the Purchase Invoice Overview Procedure document for additional steps on how to process a purchase invoice.