PO Processing

PPurchase order processing is optimized for manufacturing company requirements. POs are generated by MRP, reviewed and sent to suppliers, received, and matched with supplier invoices.

PO Setup

Suppliers - Suppliers are maintained in the Suppliers screen. The Supplier Name is the main ID for the supplier and the Trading Name is the name that prints on forms. If the supplier is identified in your outside accounting system with a different ID code, you can enter that code in the X-Ref Code field, which is the code used when you transfer AP vouchers to your accounting system. If the supplier requires customized forms, you can specify a custom forms layout for the quote or purchase order. You can maintain multiple contacts, add up to six user-defined fields, and link documents and other files to the supplier.

Item Sources - Item sources are specified in the Stock Items screen. Each item's allowable suppliers are designated on the Item Sources tab. One supplier is designated as the default supplier used by MRP for PO generation. You can enter the supplier's part number, description, unit of measure, and purchase price. If the supplier's unit of measure is different than your stocking unit of measure, a conversion multiplier converts your quantity into the supplier's quantity on the purchase order. You can specify a default Manufacturer and Manufacturer Part No and you can list alternative manufacturer part numbers.

Taxation - DBA includes its own taxation system for tax calculation and reporting. If you use USA style taxation, the supplier is assigned to a non-taxable or taxable tax code associated with a tax jurisdiction, which flows through here to the purchase order header. This determines the tax rate for the purchase order as a whole, which for most manufacturing purposes will be non-taxable. If you use international style taxation, your default VAT or GST Tax Code flows through to the purchase order header and determines the default tax rate for your line items. At the line item level, tax code exceptions defined in advance against selected items override the header tax code in situations where a different tax code and/or tax rate is to be applied.

Decimal Places - The number of decimal places needed for purchase order costing is established in the Inventory Defaults screen. You can specify the number of decimal places you need for costing. Manufacturing companies tend to need more decimal places on purchase orders, especially when it comes to buying small parts like washers, o-rings, springs, and fasteners.

PO Processing

PO Header - After purchase orders are generated by MRP, they should be reviewed in the Purchase Orders screen and edited, if needed, then sent to suppliers. In the Header tab, the supplier address, contact details, and tax code are populated by default from the supplier record. Your address is the default delivery address. When a purchase order is initially created, it is given a status of 'Opened'. After the PO is printed or Emailed to the supplier, the status changes to 'Printed'. After all the PO lines have been matched in the PO Invoices screen, the status changes to 'Closed'. POs can be Emailed to the supplier or printed out. Like all DBA forms, the PO can be customized either system-wide or for particular suppliers.

PO Details - PO line items are reviewed and edited on the Details tab of the Purchase Orders screen. Your quantity, unit cost, and tax amount is displayed in the upper grid. If the line is for a subcontract service, the linked job number and routing sequence are displayed. The lower panel displays the supplier's quantity, unit of measure, conversion multiplier, supplier price, and, if applicable, the manufacturer and manufacturer part number. All of this information prints on the purchase order so that the supplier is given meaningful values. If a supplier price record does not exist, the item's last cost is used as the unit cost, to which the conversion multiplier is applied to establish the supplier price.

PO Receipts - POs are received in the PO Receipts screen. In many cases, the pre-fill capability enables all line items to be received in a single batch process. If the item requires lot or serial number control, lot and serial numbers are entered or generated in the lower panel. Items are received to stock immediately at PO cost so that there is no delay in issuing the item to jobs or sales orders. Item labels can be generated as needed directly from receipt transactions and can optionally include PO header information.

PO Invoices - Received purchased orders are matched with supplier invoices in the PO Invoices screen. In the header you enter the invoice number, invoice date, and shipping charges. Supplier prices are matched in the grid. The matching process confirms that you were billed properly and closes fully received PO lines. If the price differs from the PO price, the difference is posted to a variance account and you are prompted to update the item's last cost and purchase price. When all the lines in a PO are closed, the purchase order status changes to 'Closed'.

Tracking & Reporting

PO Schedule - Late purchase orders can be tracked in the PO Schedule screen. You can see PO lines that are late relative to their due dates. If you wish to contact the supplier, you can drill down on the supplier for contact information.

Data Views - Data views help you to track and report on open and closed purchase orders a variety of ways, with the ability to create a library of your own custom data views. Data views are available for PO Lines Summary, PO Receipts, and PO Invoices.

Reports - A variety of reports enable you to track open POs, POs received not invoiced, and to display purchase history by item or supplier.

Data Import

Data Import - The data import utility can be used to import the following purchasing related tables - suppliers, supplier contacts, item suppliers, manufacturers, and manufacturer part numbers.