Purchase Orders

yellowbox

image3

Finally, control over your Purchase Orders, and the accompanying approval process. A/P Purchase Order Entry allows you to enter and track all POs and Quotes submitted to and returned from your vendors. When your purchase order is approved, it transfers directly into A/P Invoice Entry.

The program screen is divided into the following areas: Purchase Order Entry Header, Transaction Details Grid and Special Functions / buttons.

  • The Purchase Order Entry Header occupies the top 1/2 of the screen. This is where the vendor is specified, your purchase order number, a quote number, etc.

  • The Transaction Details are where additional information about the purchase order are entered. These details are essentially the same as the details for A/P invoices. The data keyed in here will also be copied over to the A/P invoice if the PO is approved and completed.

  • The Menu Bar / Toolbar buttons are at the top part of the program screen. You can filter for PO’s in various stages of processing, check to see if the GL expense distribution balances, or even copy the PO into memorized transactions if it is going to be a recurring purchase.

To access Purchase Orders:

From this location Go to

TruckMate Menu and TruckMate Task List

Accounting & Finance > Accounts Payable > Purchase Orders

Also, in TruckMate 2022.x and earlier: Repair & Maintenance > Purchase Orders

Windows Start Menu

TruckMate 20xx > Purchase Orders

Windows Explorer

C:\Program Files (x86) > TruckMate 20xx > ApPo.exe

How Do I?

How do I View all POs and Quotes Entered?

  1. Open the Purchase Order Entry program (APPO.EXE).

  2. Go to the 'Filter' button near the left-hand bottom of the screen and use the pull-down menu to modify the filter choice in order to find the PO/Quote you seek. The choices are: All, Complete, Approved but not complete, Not Approved, and Not Complete. Selecting a filter will allow you to view only the Pos or Quotes relevant to your search.

  3. After ensuring your PO or Quote has been approved, you may want to enter an invoice as your next step.

How do I Create a Purchase Order or Quote?

  1. Open the Purchase Order Entry program (APPO.EXE).

  2. Select the '+' button to add a new record.

  3. Tab through the fields, entering information as you go. When you come to the 'Type' field, use the pull-down menu to select either 'PO' or 'R&M'. If you are making an R&M PO, see below.

  4. Your PO number can be automatically generated or you can manually add a PO number of your choice. An error message will appear after you attempt to save the information if the PO number you chose is already in use.

  5. Once you’ve completed the header part of this program, select the appropriate tabs relevant to your purchase, and enter the information necessary in the fields provided. This is optional- you can move forward in your PO process without completing any of these fields.

  6. If you have approving power, select 'Approve' and move forward with your PO process.

  7. TruckMate assigns 'Complete' status automatically when the invoice is updated through the Accounts Payable Invoice Register program.

  8. If this is a purchase order you will have to re-enter often, select the image4 Memorize Transaction button on the navigation bar in the center of the screen. Then, the next time you need to enter this purchase order, select Recall Memorized Transaction button to save time.

  9. Print a copy of the PO for your records.

  10. Select the 'GL' button to view how the transaction will appear as a journal entry. If needed, print a copy of this for your records as well.

  11. Your next step is to wait for Approval. You can always view all your PO’s and Quotes while awaiting approval to see where they are in the approval process. Once you obtain approval for this PO, open the AP Invoice Entry program, locate this PO number, and create an invoice from this PO.

How does A/P Purchase Order Entry interface with the A/P Invoice Entry program?

In this example you will see how to use Purchase Orders to create Invoices in the A/P Invoice Entry program.

  1. Open the Purchase Order Entry program (APPO.EXE).

  2. Set up a Purchase Order using the above previous How Do I? topic. Check the GL Tab to ensure that the 'Debits' and 'Credits' balance- an amount is required in both of these fields.

  3. Approve the Purchase Order by clicking the ok Approve button on the toolbar, or by using the <CTRL><A> hot key combination.

  4. Open the AP Invoice Entry program (APNE.EXE), click: Start > Programs > TruckMate > Accounting & Finance > Accounts Payable > AP Invoice Entry

  5. Click the image6 Create Invoice from Purchase Order button, or add a new Invoice and enter a Vendor ID, then double-click the 'PO number' field to see available Purchase Orders (only Approved PO’s will appear, not PO’s that have a Complete status). Select the Purchase Order you wish to use.

  6. Save the Invoice by clicking the 'checkmark' button in the TruckMate Navigation bar.

  7. Open the AP Invoice Register program (APNR.EXE), click: Start > Programs > TruckMate > Accounting & Finance > Accounts Payable > AP Invoice Register

  8. Process the Invoice through the Register. For help with Posting Invoices to the Register, click here.

  9. Now, back in the AP Purchase Order Entry program (APPO.EXE), the PO will have a Complete status, meaning it has been properly processed and cannot be added to an Invoice again.

How Do I Use a Purchase Orders in the R&M Work Orders program?

  1. If your Purchase Orders contain Repairs & Maintenance information, you will have to interface them with the R&M Module.

  2. Follow the steps in the above topic "How Do I Enter a Purchase Order or Quote?". Make sure that for the 'Type' field, you select 'R&M'.

  3. Make sure you enter the R&M information for the PO on the R&M Parts Tab.

  4. Open the R&M Work Orders program (RMWO.EXE), click: Start > Programs > TruckMate > Repair & Maintenance > R&M Work Orders

  5. Click the '+' button at the bottom edge of the R&M Work Orders program to create a new Work Order. Fill in the required details in the Header Section.

  6. Click the Vendor Bills Tab. Click the '+' button on the lower part of this Tab to add a new Detail Line.

  7. Double-click in the 'Vendor' field to open a selection form where you will see a list of your Vendors. Select the Vendor that you created the PO for.

  8. Double-click in the 'PO Number' field to open a second selection form, where you will see a list of 'Approved' PO’s for the Vendor you have chosen. Select the PO with the R&M information and it’s details will populate into the Work Order.

  9. 'Complete' the Work Order through the Billing Tab when you are finished, and then update it through the R&M Work Orders Register program to complete the process.

Menu Bar / Toolbar

File Menu

Print Reports

printer Selecting the Print Reports button will bring up the report selection window, common to many TruckMate applications. Here, you will select a report file from those available in your system and a Crystal Report will be generated.

For more information on Report functionality in TruckMate, see the Crystal Reports Reference.

Exit

exit Selecting this option will close the A/P Purchase Order program.

Multi-Company Menu

For more information on the Multi-Company options available from the Menu Bar, see the Multi-Company documentation.

Navigate Menu

The Navigate Menu contains the normal TruckMate Navigation Bar, used to browse through your Database record

Find

find Click this button to open a search form that you can use to find a PO in the system. You have the ability to search for PO Numbers by Date. Select the 'Date' option on the right side of the screen and then enter a date ('yyyy-mm-dd' format) and click the type the <Enter> key on your keyboard. All Purchase Orders with that Date will appear in the search window.

Tools Menu

TruckMate Monitor

monitor Click the down arrow next to this button to access the various functions of the new TruckMate Monitor.

Remember Position / Size

Selecting this option will maintain the program window position and size upon close. When the program is re-opened, it will appear the same.

Memorize Transaction / Recall Memorized Transaction

These two buttons- located to the right of the record navigation bar- allow you to save a copy of the current PO as a memorized transaction. This is useful if you have recurring purchases with the same vendor, such as office supplies.

  • Memorize Transaction

    image11 Clicking on this button opens the Memorize Purchase Order window, where you can apply different options to the memorized transaction.

    • Save Transaction Tab

      The Save Transaction Tab allows you to give the memorized transaction a label to differentiate it from other memorized purchase orders. The Remind / Don’t Remind options let you specify if the purchase orders program should remind you that this memorized transaction is due to be used again. You can of course simply ignore the reminder when it appears. If you do, the program will not remind you again until recall the transaction and the Next Date value is reset.

      image12

      Field Definition

      Name

      This field displays the Vendor Name for which you are creating Memorized Transactions.

      Remind / Don’t Remind

      Select one of the available radio options to toggle reminder functionality on / off.

      Frequency

      The 'Frequency' field lets you select the interval between reminders using a drop-down menu.

      Next Date

      The 'Next Date field', as already mentioned, is set based on the current use, plus the interval. It is reset based on the same calculation the next time you recall the transaction.

      Remaining

      The 'Remaining' field keeps track of how many times you have left to recall the memorized transaction. After the remaining runs out, you will no longer be allowed to recall this transaction.

    • Edit Transaction Tab

      The Edit Transaction Tab allows you to delete or fix memorized transactions. You can change the any of the settings listed in the grid: reminder frequency, if reminders are required, etc.

      image13

  • Recall Transaction

    image4 Click the Recall Transaction button to open a selection window containing all of the Memorized Transactions previously created on this database. Double-click one of these entries to view its details.

Toggle PO Approval

ok Click the 'Approve PO' button after the PO has gone through the approval process, and been approved for purchase. You can also un-approve the PO by clicking on this button if the PO is marked 'Approved'.

View GL Report

picklist Selecting this button will open a Report Preview window that will show whether or not the resulting GL entries will be in balance or not.

Window Menu

Customer & Vendor Profiles

image15 Selecting this option will open an instance of the Customer & Vendor Profiles program.

AP Invoice Entry

image16 Selecting this option will open an instance of the AP Invoice Entry program.

Help Menu

TruckMate Help

help Selecting this button will open the A/P Purchase Order topic in the TruckMate Online Help file (the page you are currently viewing).

Service Portal

browser Selecting this button will open an instance of your default Internet browsing software, with the https://www.tmwcare.com login page displayed.

About

about Selecting this button will open the standard TruckMate About window, which contains important information about the application you are currently using, including its version number (important for support calls).

Toolbar

Filter

Filters POs/Quotes by 'Not Approved', 'Not Complete', 'Approved but Not Complete', 'Complete', and 'All'.

Default Date

This controls what date will be used in new PO’s that are entered. By default the value is 'today'. If you are entering back-dated, or future vendor PO’s, set the date to the previous or future date.

Purchase Order Entry Header

Vendor

Enter a vendor code, or select a vendor from the search form by clicking the search button. Vendor codes are configured in the Customer & Vendor Profiles program. The Vendor name and address details will appear in the fields below.

Currency

The default currency of the invoice is the currency assigned to the vendor in the Customer & Vendor Profiles program but you could change to another currency by clicking on the search button. If you did not assign a currency to the vendor’s profile, enter the currency code or click the search button for a search form. Currencies are configured in the Codes Maintenance program.

Unlike AP Bill Entry and Instant Checks, regardless of whether or not you have set up intercompany (I/C) accounts for each currency in company profiles, the GL displayed in Purchase Orders will still only show a single I/C row per company (in that company’s base currency). The reason is that purchase orders are not posted to the GL (and hence will not have to be reconciled).

Account Payable Control

Select the appropriate General Ledger Account for the item to be purchased and/or that you are receiving a PO or Quote on. The Account Description of the GL Account you select here will populate into the 'Expenses' Tab Grid, so that you can easily tell which GL Account you are working with.

Type

Select either PO (Purchase Order) or Quote.

Purchase Order / Quote Number

Enter the appropriate number from your files, or click on the search button to the right of the field to auto-fill this value with the next available number from the system counter. This number can be up to 20 characters in length.

Amount

Enter the dollar amount of the Purchase Order/Quote.

PO For

Use this drop-down menu to specify if the Purchase Order is intended for the A/P or R&M module.

Department

Enter a Department name, if applicable.

Shop Code

Choose the Shop Code of the Shop conducting the repairs by using the search button.

Memo

Enter any relevant free format notes about the PO or Quote in the Memo field.

Date

Enter the date the Purchase Order/Quote was obtained, unless this populates automatically.

Terms

Enter any agreed upon terms, unless this populates automatically from the Vendor Profile program.

Due Date

Enter the due date for the monetary transaction, unless this populates automatically from the Vendor Profile program.

Discount Date

Enter any appropriate discounts offered, unless this populates automatically from the Vendor Profile program.

Discount %

Enter the discount percentage, unless this populates automatically from the Vendor Profile program.

Approve

Selecting this button will approve the displayed Purchase Order. To be able to approve a PO, the User must have the appropriate security rights in the Security Setup program. When a PO has been approved, the checkbox next to the Approve button will be flagged.

Hold

Set this button if the Purchase Order has been placed on hold. When the 'Hold' button is checked, the PO will still be processed through to Accounts Payable, and the invoice will be updated through the A/P Invoice Register program, but in the A/P Inquiry program the invoice will be flagged as an 'On Hold' invoice. The column called 'Hold' (True or False) would in this instance show as 'True'. When a Purchase Order is set to 'Hold', the check mark next to the 'Hold' button will be flagged.

Complete

Set this button once the PO/Quotes process has been completed. After the 'Complete' button is selected, the checkbox next to the button will be flagged. Simply uncheck this flag in order to reverse a 'Completed' PO, setting it back to 'Not Complete' Status, which allows editing.

Filter Setup

This button is found in many TruckMate applications. Selecting this button opens the SQL Filter window. For details on SQL Filters Click Here.

Transaction Details

Expenses Tab

The Expenses Tab details the expense distribution for the purchase order charges. Enter the Account number, any reference information, the quantity of items required, the rate/per item purchased, the dollar amount, and posting amount. In the Vendor Profiles program, you could input default G/L accounts so that any time you enter an invoice or a PO regarding a particular vendor, it will automatically distribute or post to the G/L account specified. This will automatically distribute expenses, if the Vendor Profile has been set up to do so.

image20

Select the '+' button to add a new record to the Expenses grid.

Account

Enter the relevant Account Number. Double click for a selection form populated with all the GL Accounts currently set up on your system. The charges specified in the 'Amount' field of this grid will be added to the GL Account you select here.

Description

Automatically populates with the Description of the GL Account chosen in the 'Account' field to the left.

Reference

Enter a description of the item that is being charged to this GL Account.

Quantity

Enter the number of expenses of this type that will be charged.

Rate

Enter the individual purchase price of the item.

Amount

This field will automatically populate based on the 'Quantity' field multiplied by the 'Rate' value.

Posting Amount

Behaves exactly as the 'Amount' field, but displays the actual amount that will be posted to the GL Account selected in the 'Account' field. This value will display when the User clicks the 'checkmark' save button. This value cannot be edited.

Description

When you select a GL Account in the 'Account' field, the 'Description' field will populate with the name of the GL Account (as configured in the GL Chart of Accounts program) for the account you have selected. This will help maintain consistency in your Accounting records, as it will be harder to confuse which GL Account the PO belongs to.

Note: The user cannot edit the 'Reference' or 'Resource' columns in the Expenses Tab grid for Inter-Company rows ('Due To' and 'Due From'). The Inter-Company rows are auto-calculated. For example, if you change the check’s amount, the Inter-Company amounts will update. The application changes the amounts by first deleting the Inter-Company rows and then re-adding them with the new amounts. Any data in the 'Reference' or 'Resource' columns will be lost.

Driver Deductions Tab

If the PO is to be expensed against a driver using Driver Pay System deductions, then enter the Driver ID, deduction code, account number, any relevant reference information, the quantity of the item being ordered/quoted, rate, and amount on the Driver Deductions Tab.

image21

Driver ID

Double-click to view a 'Pick Driver ID' search box, or enter the Driver ID.

Deduction Code

Double-click to view a 'Pick Driver Deduction Code' search box, or enter the Driver Deduction Code.

Account

Enter the GL Account Number that is used to track your Driver Deduction totals. Double-click for a selection form.

Reference

Enter a description of the deduction that is being charged to this GL Account.

Quantity

Enter the number of deductions accrued.

Rate

Enter the individual Driver Deduction amount.

Amount

This field will automatically populate based on the 'Quantity' field multiplied by the 'Rate' value.

R&M Parts Tab

If the PO represents parts that are to be expensed against a Shop in the R&M system, enter the 'Part Code', 'TO Code', 'Trans Code', quantity being ordered, rate per item, dollar amount, and any relevant reference information on the R&M Parts Tab.

image22

Part Code

Double-click in the column to bring up the 'Select Part Code' window, or enter the Part Code.

Part Description

Automatically populates with the description of the part selected in the 'Part Code' selection field.

UOM

Enter the Unit of Measurement for the specific part.

To Type

Depending on the 'Part Code' value, the 'To Type' field pull down menu will display available destination options for the part. For example: SH=Shop; PU=Power Unit; TR=Trailer; EQ=Misc. Equipment; OS=Outside.

To Code

Double-click in the column to bring up the 'Select Shop Code' window, or manually enter the destination Shop Code.

Trans Code

Double-click in the column to bring up the 'Select Transaction Code' window, or manually enter the Transaction Code.

Quantity

Enter the number of parts.

Rate

Enter the purchase rate for each individual part.

Cost

This field will automatically populate based on the 'Quantity' field multiplied by the 'Rate' value.

Tax Rate1

Enter a Tax Rate value (integer) that will represent the first tax added to the 'Cost' field.

Tax 1

This field will populate with a value once the 'Cost' field and 'Tax Rate 1' fields have data in them. The 'Tax Rate 1' integer value is multiplied against the 'Cost' value to determine the monetary amount of the first tax.

If the R&M Part Code selected has had the 'Tax 1 Exempt' flag checked in the R&M Configuration program > Part Codes Tab, this value will default to '0'.

Tax Rate 2

If needed, enter a second Tax Rate value (integer) that will also be added to the 'Cost' field.

If the R&M Part Code selected has had the 'Tax 2 Exempt' flag checked in the R&M Configuration program > Part Codes Tab, this value will default to '0'.

Tax 2

This field will populate with a value once the 'Cost' field and 'Tax Rate 2' fields have data in them. The 'Tax Rate 2' integer value is multiplied against the 'Cost' value to determine the monetary amount of the first tax.

Total Amount

Automatically populated as you add values to the other fields in this section. If there are values in the 'Tax 1' and 'Tax 2' fields, they will be added to the 'Total Amount' field as well.

Received

This field automatically populates with data based on data in the Stock Receipts program. The values in the 'Received' field will change depending on the amount of stock received against the amount of stock ordered.

Reference

Enter any descriptive information for these R&M Parts.

Sum Amount Button

Clicking the 'Sum Amount' button will add all charges and taxes from all the parts listed, and populate the total amount in the 'Amount' field of the main Purchase Order program window.

Parts PO Button

Clicking the 'Parts PO' button will generate a Purchase Order for any parts your company may need. The system will query the R&M Configuration program, and will balance your 'Max Stock' values against your 'Min stock' value. The program will then generate an order that will bring your inventory back to it’s maximum capacity.

The re-ordering process will take into account the 'Tax 1 Exempt' and 'Tax 2 Exempt' flags in the R&M Configuration program > Part Codes Tab for any parts that have these values flagged.

Context Menu

Create Part Code

Clicking on this item on the context menu opens up the Add New Part window where you can enter information about a new part code. This window allows functionality similar to that found in the R&M Configuration program.

image23

Code

Enter the text string that will become the new product’s 'Code' value.

Description

Enter the part description. This description will populate whenever a TruckMate program grid contains a 'Description' field.

Tax 1 / Tax 2 Exempt

These two flags designate the tax exemptions available for a specific part in your inventory. Both the 'Tax 1' and 'Tax 2' amounts are defined in the Tax Calculation Configuration program. By selecting one (or both) of these fields, you can exempt the selected part from taxation.

These fields can be defaulted for all newly created Part Codes by using the 'Tax 1 / Tax 2 Exempt Parts' options in the Application Configurator program > RMCONFIG.EXE section.

Class

Use the search button to select the Class to which your new part will belong.

Group

Use the search button to select the Group to which your new part will belong.

Component

Specify what component your newly created part will work with.

Unit of Measure

Use the search button to select your new part’s unit of measurement.

Make / Model

Enter the make and/or model information for your new part.

Retail Price

Enter the retail price for your new code.

Track Warranty

Enable this checkbox to allow warranty tracking.

Warranty Length

Specify the length of the warranty, in months, for use by the 'Track Warranty' button above.

Disposal Fee

Enter a disposal fee (if applicable) for your newly created part.

Notes Sub-Tab

The notes tab allows you to enter notes in two areas. The first is a general notes area, the second a notes area for install issues or instructions.

Shop Information Sub-Tab

The 'Shop Information' tab lets you specify who carries your products, and what the access permission are for each.

Shop Code

Click the '+' button and then double click the 'Shop Code' field to select a shop from a generated list.

Bin #

Enter the product’s Bin Number location.

Min Stock

Enter the minimum amount of stock at this shop.

Default Bin

Automatically set to 'True' upon entering a Bin #. If the Bin # you entered is not the default, you may change this value by typing in 'False'.

Max Stock

Enter the maximum stock amount at this shop.

Auto Calc Min

Set to 'True' upon creation of a shop. Set this value to 'False' if you would not like the program to automatically adjust the 'Minimum' amount when stock is depleted.

Auto Reorder

If set to 'True', will automatically reorder parts based on availability.

Auto Vendor Bump

If set to 'True', will change the Default Vendor value depending on which Vendor has the cheapest merchandise. This function takes data from the R&M Configuration 'Part Codes' section.

Default Vendor

Double click to select a Default vendor.

Secondary Vendor

Double click to select a Secondary vendor.

Alternate Vendor

Double click to select an Alternate vendor.

Vendor Parts Sub-Tab

The Vendor Parts tab lets you specify parts that are Vendor specific.

Vendor Code

Once the '+' button has been clicked, you may manually enter a Vendor Name here, or double click to select a Vendor from your Vendor list.

Vendor Part Code

Enter the Vendor Part code.

User Defined Sub-Tab

This tab allows several options for user created fields within the Purchase Order module.

Shipping Address Tab

Use the Shipping Address Tab to enter an alternate shipping address if the items on the PO are to be sent to an address other than the one your company provides by default. This information is now available for any reports generated which require this information.

image24

Notes Tab

Enter relevant shipping information in the free-form text field provided.

Other Tab

The Other Tab offers a few additional options.

image25

Trip Number

Displays the trip number, from the Dispatch program, on which the freight bill was carried.

Client Reference

Enter your client name here or select the search button to search for your client by name or ID.

Payment Method

Enter the accepted payment method.

AP Bill #

Enter the Accounts Payable Bill Number.

R&M Stock #

Enter the Repairs & Maintenance Stock number.

R&M Work Order

Enter the Repairs & Maintenance Work Order number.

Audit Tab

The Audit Tab is a read only section that details the user information for whomever has last modified the file.

Created By

Pre-populated with the User’s name and date of creation.

Last Modified By

Pre-populated with the name of the user who last modified the Purchase Order, and date of modification.

Approved By

This is the date the PO was approved, and date of approval.