Purchase Order Workflow: An Overview
Previous Topic  Next Topic 

Once you create an unissued order from the FF&E Worksheet (see next major topic) or create one manually, this system can cover every step from editing items prior to issuing orders, to tracking vendor payments, to tracking shipping status, and invoicing your clients. These status "milestones" are controlled by a logic that helps prevent errors from occurring.

Not every possible function will be used by every user (especially if you simply generate orders for others to manage or invoice your clients based on a fixed fee), however you should know the general order in which FF&EZ expects things to occur and the way it handles the inevitable exceptions to that.

Assumptions

The process shown in the table below is based on one primary assumption: 

Specific steps occur when the information needed for them (quantities and costs) can be verified. 

That is the assumption—of course, reality does not always cooperate, but the system can handle revisions and unexpected changes. Here is our main assumption expanded to the typical steps of processing orders (the actual steps are included later):

  1. The single most important prerequisite before creating orders is to verify that shipping addresses have been set on the Specifications List screen for products that are being shipped to a non-project address (i.e., another vendor or a staging address (e.g., warehouse) set up as a "vendor"). This prevents items with different shipping addresses from being included on the same order (unless this is your intent—see shipping addresses).
  2. Orders are created from the FF&E Worksheet, using its Order... button, but normally after the Worksheet  quantities and costs are confirmed (changes can still be entered on the orders). Created orders do not have to be issued immediately. 
  3. Best practices: If you are tracking payments to vendors (both deposits and any final payments through the Enter/Reconcile Vendor Final Invoices steps), always update any estimated or quoted freight amounts in the "Freight Quote" field on the Orders screen. This ensures that "estimated remaining" totals are as accurate as possible on the vendor payment reports. It also streamlines the entry of deposit requirements (see next). Do the same for tax estimates if they apply to the order and would appear on the vendor's invoice.

    Exception: If an order has already been reconciled and a vendor invoices unexpected extra freight or tax amounts, these are simply entered as special items.
  4. Vendor deposit requirements and vendor deposit payment status should be entered as soon as they are known. This is a prerequisite if you wish to issue deposit check requests or report on vendor payment status (i.e., to a purchasing management client). Note that there are right-click shortcuts to make entering deposit amounts easy.
  5. If you need to pre-invoice your client on a specific order (for a partial deposit or full amount owed to you), you can do so by 1) setting up the pre-payment in the Client Deposit Requirements section on the Order screen, then 2) issuing a Client Deposit Invoice. This is typical if a financial source needs a detailed list of what a client's funding draw covers.

    Note that FF&EZ's item-based approach to invoicing may not be needed if you are invoicing based on a "percentage of completion" basis—that can be done from within your accounting system.
  6. Orders should be issued before any further vendor-related processing occurs other than that related to deposits.
  7. Actual "Shipped" status and quantity should always be entered or confirmed., This makes it easier to accurately process or reconcile vendor "final" invoices and to issue accurate payment-related documents. A 100% deposit invoice is later treated as the "final" invoice if no changes occurred to the order. 

    The shipped quantity is the "actual" quantity that is compared to vendor invoices. Entering "actual" quantities, not assumed quantities, can be critical to having FF&EZ catch vendor errors (or worse). For orders without any unexpected quantity changes, the Expediting screen's Update Order Status command updates the entire order quickly.
  8. Vendor deposit payments must be recorded prior to processing vendor final  invoices (per #3 above) with Enter/Reconcile Vendor Final Invoices. The deposit is applied to order items during this reconciliation step to calculate a true final balance.
  9. Best practice: Order items should normally be marked with at least "shipped" status as soon as this is verified (confirming the quantities). This allows you to use a filter when generating payment-related documents where you want the quantities to be accurate.
  10. In order to calculate a verified balance for some or all items on an order, you must process a final vendor invoice for those items (for 100% deposit invoices see next step). You can then issue (or merely record) a balance check request documenting what is owed to the vendor. 
  11. For orders pre-paid with an exact 100% deposit, you must still process a "final" vendor invoice (by using the original deposit invoice ID) to confirm they had no changes (there is a button for this). This process marks the order items as having been reconciled to the original order and either paid or having a balance.
  12. Freight charges will not be added to a client invoice (to pay you) unless Processing> Enter/Reconcile Vendor Final Invoices has been used to enter actual freight charges or a "special item" for additional freight has been added to the order with a vendor invoice number. 

The system is designed to streamline these steps as much as possible, especially for most orders where you can confirm (or trust) that the entire order was shipped without any shipping splits or other variances. For some product types (or vendors) you should never simply accept original quantities as the shipped quantity.

The shipping and payment status of any order item depends on your entries on the Expediting screen and in the Processing commands. All status milestone points can be reversed, although this may require reversing the status for more than one item (for instance, if multiple items have appeared on an invoice or a check request). Alternatively, you can simply add adjusting line items to the order and process them normally. See Reversing Status Milestones for more information.

Tracking Quantities is Important

FF&EZ tracks four kinds of quantities in processing orders: 

  1. The original order quantity, which can be revised until an item is noted as "shipped"  (or has been invoiced on a final (not deposit) invoice). After that, the original quantity becomes the basis for calculating any variances. This number appears on the Item screen and the Orders screen's item list.
  2. The "shipped" quantity, which is then used for calculations of cost instead of the original quantity and is entered (or simply confirmed) on the Expediting screen. If the shipped quantity represents a partial shipment, FF&EZ creates a "split" for that item and transfers the unshipped quantity as the quantity for a new sub-item split. The shipped quantity (and variance) can be changed until the vendor's final linvoice is reconciled or the item appears on a balance request or a client invoice. This number also appears in the Orders screen's item list.
  3. A "variance" quantity is recorded when the "shipped" quantity is more or less than the original and this is a change in the final quantity. The variance is included in the  net "shipped" quantity.
  4. The "received" quantity, which should match the "shipped" quantity.

Quantities can be changed until a processing step (such as appearing on a balance request or a client invoice) locks them from further changes. At that point, a change requires that you either 1) void the document(s) that caused this lock, or 2) add an adjusting line item to the order and process it normally. Adjusting items are usually linked to a vendor invoice (or other document) that is separate from any previous ones.

Deposits on "Expected" Numbers vs. Final Balances

If you are tracking vendor payments, it is important to understand how FF&EZ splits this process into two distinct phases: 

  1. What is proposed to be ordered along with the expected cost, tax, freight and required deposit, and... 
  2. What was actually shipped and the total amounts the vendor actually invoiced to which any deposit will be applied. 

FF&EZ tracks all these numbers, however it relies on you to confirm any final quantities and amounts prior to applying deposits. 

Processing Steps

The flow of work for processing orders breaks down into the following major functions. Some are prerequisites to the steps that follow them and some can be done in parallel as needed (see assumptions above). This short list is detailed in the table that follows:

  1. Create orders as needed from the FF&E Worksheet contents. At this point, you can use Processing> Issue Orders to preview and print "draft" orders for review. This includes saving to a PDF file with an option on the Preview screen. 
  2. Where they apply to an order, record tax quotes (if a specific tax rate can't be used) and freight quotes. Be sure to enter a tax rate if it applies to the sell price and you plan to invoice from FF&EZ. Normally, tax rates can flow from the specification rate (originally set on the project screen), but there are situations where you can prevent this so taxes can be entered from vendor quotes.
  3. (Optional) You can enter your own client deposit requirements on the Orders List screen, then use Processing> Print Client Deposit Invoices to invoice your client for a deposit to cover your own vendor payments. When a deposit is received, record the amount. Deposit requirements and payments are entered in the Order List screen's Client Deposit Requirements section. You can also record deposit payments with Processing> Enter Client Deposit Payments if a check applies to more than one deposit invoice. 

    As an alternative, you can use the FF&E Worksheet's "Quote/Contract" report format to specify a total required client pre-payment. The report's options include the ability to add a required deposit. If you use this method, it should be easier to manage and apply the deposit within your own accounting system. 
  4. As soon as possible: Enter any deposit requirements and pro forma invoice information from the vendor. Requirements are entered manually on the Orders screen's Vendor Deposit Requirements section. Although you can enter "Pro forma" as an invoice number, we recommend you create a unique ID, such as a PO # + a date string, in case you want to search for it later. An ID generated by the vendor is always best.

    You can record these as simple status updates, but you can also issue official "deposit check requests" (Processing> Issue Vendor Deposit Requests). Optional: use deposit check requests for documents to your accounts payable or to your purchasing management client. Exporting them as transactions is an option (contact us). 
  5. Record any vendor deposit payments as soon as they are confirmed (this can happen during the next few steps, but must be done prior to using Enter/Reconcile Vendor Final Invoices. Deposit payments can be recorded directly on the Orders screen or using Processing> Enter Deposits to Vendors. This information appears on the "Vendor Payment" and "Deposit" status reports.
  6. Issue the orders. We recommend using the [>PDF] option button to create record copies of your orders. 
  7. On the Expediting screen, update order shipping dates and quantities. This can be done for single items (Update Item Status) or for the entire order if no line item changes occurred (Update Order Status). You can also mix these methods to process exceptions first. Update "received" dates and quantities if you want to fully use the item status tracking features. "Expediting Status" reports show the progress of shipments you've updated. 
  8. When a pre-paid order is complete or when you receive any balance invoices from the vendor, use Processing> Enter/Reconcile Vendor Final Invoices to reconcile the expected order quantities and amounts to the actual invoiced amounts. This step applies vendor deposits to verified numbers, so be sure to process all orders with this command, even pre-paid orders. Pre-paid orders have shortcuts described in the  section Processing Pre-Paid Orders.
  9. Use Processing> Issue Vendor Balance Requests to record the milestone of requesting payment to a vendor of verified balance amounts. If a physical document is not needed, you can use the command's Record (only) option.
  10. Record any final payments to vendors with Processing> Enter Vendor Balance Payments (this keys to the balance requests created in the last step. This also appears on the "Vendor Payment" reports. 
  11. Use Processing> Print Client Balance Invoices to invoice your client if you are charging on a item-by-item basis. Note: many FF&EZ users invoice out of their own accounting systems, using the FF&EZ invoice's "Invoicing Detail" format option for the backup detail to a  simpler official invoice. This makes sense if you specify a project deposit using the Worksheet's "Quote/Contract" format instead of issuing Client Deposit Invoices (see #3 above). 
  12. Record payments on your invoices. Again, if you are invoicing from your own accounting system, this is optional.

Here are the above steps for issuing, expediting and reconciling orders, with notes and order of work. As we have mentioned, some steps are not required to be in the exact order shown, but this is noted. 

Step

Description

Notes

Final preparations before issuing orders

Orders screen: Final preparation prior to issuing

Final changes to items. Entry of a shipping note that applies to the whole order or individual notes on each item. Confirming the shipping address (if not to the project).

If you wish to change an item description in both the specification and the order item, do it on the specification, then use the Refresh option on the Item screen for the matching item.

Shipping addresses should be assigned on the specifications screen instead of waiting until they have been converted to orders. When spec shipping addresses are different, FF&EZ will create separate orders to avoid confusing the vendor.

In addition to making any edits to item descriptions, you can adjust order quantities if a case quantity overrides the original one. The system can also handle quantity variances later if needed.

Orders screen: Record freight quotes and tax quotes (if applicable).

These typically come  from a vendor's pro forma invoice. If the order has a tax rate, it will calculate the total estimated tax for you (but see notes). Otherwise you can enter a tax quote.

Unless a VAT type of tax is enabled (Project screen), only purchasing management projects will have a tax rate associated with the order costs.

A tax rate on a billing type 1 (cost/sell) project will appear but only applies to your "sales" invoices to your client.

Freight and tax amounts appear on vendor payment status reports to help estimate the expected costs to you or your client.

If freight and/or taxes apply to an order and you don't enter them but enter a 100% vendor deposit requirement that includes them, vendor payment reports may  appear to show too much deposit paid.


The next three sections do not have to be done in the order shown, but are arranged to make you aware of the options you have as you get to the point of officially issuing orders.

Client Deposits Paid to You

When reselling to a client (billing type 1), you may need to invoice your client for the required deposits owed to your firm before issuing an order. These steps 1) can occur at any time as long as they are completed before you use Process> Print Client Balance Invoices.

Entering client deposits into FF&EZ is optional, especially if you are billing your client based on "percent of completion" from your accounting system (the "Total required deposit" option on the FF&E Worksheet's "Quote/Contract" reports may be all you need). However, using this feature will help track deposits needed to cover individual orders and is especially useful when you must provide item details to a financial institution before they will release funds.

Note: This section does not involve deposits owed to a vendor. That is covered in the next section.

STEP

ACTION

COMMENTS

Orders screen: Record client deposit requirements

Once you determine that a client deposit is needed to cover your cost for an order, enter it on the Orders List screen under "Client Deposit Requirements".

The "Client Deposit Requirements" section is displayed using an option at the bottom of the screen.

Be sure to read about the shortcuts that speed up data entry for client deposits (in the section linked to the left).

Process: Print Client Deposit Invoices

This step generates a numbered invoice that can be sent to a client or to a financial institution.

If you are billing your client from a separate accounting system, you can use the Invoicing backup format option when you print. This creates a detailed backup to a simpler official invoice from your system, using the basic invoice layout.

Record deposit payments you receive

Enter the amount paid to you as a deposit. There are two ways to do this:

  1. Using the Processing> Enter Client Deposit Payments command

    or
  2. Use the Edit command on the Orders screen to enter the information directly on that screen.

Entering the payment information directly with Edit is easier unless the payment covers multiple orders for which Deposit Check Invoices have been issued. The Processing command lets you split a payment.


Deposits Paid to Vendors

The following steps for processing vendor deposit requirements can occur at any time as long as they are completed before you use Process> Enter/Reconcile Vendor Final Invoices to either 1) enter a vendor's balance invoice for an order or 2) to confirm the final numbers for a 100% pre-paid order.

Orders screen: Record vendor deposit requirements

Once you receive either a pro forma or numbered deposit invoice, enter this information to set up the next steps.

The "Vendor Deposit Requirements" section is displayed by default in the lower right corner of the Orders List screen. You can enter multiple vendor deposit invoices if needed, using the Multiple option.

When a vendor requires 100% pre-payment before shipping, treat it as a 100% deposit—at this point, the final order totals cannot be confirmed. See "Deposits on 'Expected' Numbers vs. Final Balances" in the previous section.

For unnumbered vendor invoices, you can use "Pro forma" as an invoice number, however we recommend you create a unique ID using a consistent pattern.

E.g., PO # + a YYYYMMDD date string, or simply PO# + a shorter code like a letter. This lets you search for vendor invoices more easily when they don't supply their own ID.

Deposit information and payments must be entered prior to using Enter/Reconcile Vendor Final Invoices.

Be sure to note the shortcuts that will calculate the deposit amounts for you (single invoices only).

Process: Issue deposit check requests

This step generates a document that can be used to request a deposit payment to a vendor.

If you are acting as an "agent" and paying invoices from a client account, you can generate these as a status update without printing the document (more in the "Notes" column).

Printing deposit requests is optional if no request document is needed (see next step).

If  you only wish to print a list of Check Requests as a cover sheet for a group of invoices being sent for processing (that is, instead of sending separate check requests), you can use the Record (Only) button instead of the Print or PDF options when issuing deposit check requests.

Record deposit payments to vendors

Enter the amount paid to the vendor as a deposit. There are two ways to do this:

  1. Using the Processing> Enter Deposits to Vendors command

    or
  2. Use the Edit command on the Orders screen to enter the information directly on that screen.

Entering the payment information directly with Edit is easier unless the payment covers multiple orders for which Deposit Check Requests have been issued.

You must currently use method #2 for any order where you have entered multiple vendor deposit invoices, since you need to specify the invoice to which the payment applies.

Issuing Orders

Before issuing orders, you can use the Prevew/Draft option under the Issue Orders function to print orders for review. These are clearly marked as "Drafts."

Process: Issue orders

Use this command to create the "official" order. There are two basic formats, one with a short boilerplate above the signature line and one that adds a separate "terms and conditions" page you set up as needed.

You can issue orders at any time after the "final preparation" step above, however if you wish to also see tax and freight on the order (if either applies), you must enter these rates or quotes on the Orders screen by this point.

The document date used when an order is issued can be set to something other than the current date. It can't be changed after that.

Once an order issued, the automatic revision tracking system is in effect.

Orders screen: Revisions

Once issued, any changes in original order information (that are relevant to the vendor) are automatically noted as a "revision note" with a user and date stamp. You can add your own additional note that that time.

A separate general note for the order allows you make internal notes about the order. This also appears on the Expediting screen.

You can change original quantities, costs or prices until an item is marked as being shipped or appears on a vendor final invoice (below) that you enter into the system.

Use Processing> Reprint Orders to print revised versions of orders. You can include or suppress the automatic revision notes when you reprint an order, using options that appear for this function.

Expediting: Shipment tracking

On the Expediting screen, use either Update Order Status or Update Item Status to enter the vendor's acknowledgement ID, "will ship" date, the quantity confirmed to have shipped and (when available) quantity received.

If the quantity shipped is less than the original, FF&EZ will offer to create either a shipping split for the remainder or record a final variance from the original amount.

Higher quantities are always treated as a variance, unless you edit the order item before you enter the "shipped" quantity.

Use Update Order Status when all items have shipped with their expected quantities or after using Update Item Status to record exceptions, which are protected from changes. This has the same shortcuts that invoke the "editing" mode on other screens.

Until an item is processed on a balance request or a client invoice, you can use Update Item Status to change your entries if needed.

Reconciling Vendor Final Invoices, Final Vendor Payments

Although the vendor invoice reconciliation process and the client invoicing process are technically independent of each other, both work better if you update the "shipped" status of items you want to process with them. This is done on the Expediting screen (see "Expediting: Shipment tracking" above).

Process: Enter/Reconcile Vendor Final Invoices

This is a reconciliation process. When you enter a purchase order number, FF&EZ will produce what it expects to see on the invoice. Important: You then override these numbers with the actual numbers on the invoice (if they are different).

If you have already confirmed the shipped quantities and/or created shipping splits for delayed or split shipments, this process is usually easy.

The ful "how to"l discussion of this function is found at Entering Vendor Final Invoices.

This is a required step for all orders even those with 100% deposits (but see below).

This function updates or confirms the final quantities and amounts for the order (or part of an order). Just as important, it will then apply any deposit balance to these confirmed numbers. In turn, this allows it to generate an accurate work-in-process balance payment amount.

A special button on this command streamlines this for pre-paid orders with a 100% deposit and no changes. It is available when an order with confirmed quantities, freight, taxes and deposits produces a zero balance.

Process: Issue Balance Check Request.

This step generates a document that can be used to request a balance payment to a vendor.

If a partial order was processed with Enter/Reconcile Vendor Final Invoices, the check request will only include  that balance (after the deposit is applied).

To process the remainder of a partially processed order, use Enter/Reconcile Vendor Final Invoices again when the next invoice is received. Be sure to enter any payments sent to the vendor (next step) to ensure accurate reports.

Process: Enter Vendor Balance Payments

This is used to apply a check to one or more balance check requests.

This is not required for orders that were paid in full by a deposit.

Final Invoices to Clients

if you use FF&EZ for invoicing, you can issue item-based invoices to your clients as early as immediately after issuing an order, however we recommend avoiding this until actual shipped quantities are confirmed. Issuing invoices too early may be harder to correct if other processing has occurred, leaving you with adding adjustment line items as the only option.

Process: Print Client Invoices

Prints your firm's item-based charges to your clients.

On billing type 1 projects, you have options to list "no charge" items whose sell price is rolled into the primary product line.

Not used if you are billing your client from a separate accounting system, unless you are using the Invoicing backup format to create detailed backup to a simpler official invoice from your system.

By default, invoices only include items that have been marked as "shipped"—however this can be overridden when using the command to select all "issued" invoices or only "delivered" items.

Process: Enter Client Invoice Payments

Used to enter payments and payment data for one or more client invoices.

This is typically handled within your own accounting system, but is included for completeness.




As mentioned above, these steps can be canceled or voided in roughly the reverse order in which they are listed. See Reversing Status Milestones for more information.