PO0000 Purchase Order and Receiving Overview 3

Receivings Processing

Various types of receipts are handled by the Receivings Processing application.  It is not necessary, for instance, to use different procedures for purchased materials and expense items (supplies).

Material arriving at the receiving area is normally accompanied by a packing slip, invoice, advice note or similar document indicating the original purchase order number, the item number and the quantity shipped.  If this documentation is missing or erroneous, the Receivings Processing application provides a means of identifying the purchase order number and the numbers of the items that were delivered.  For instance, if you only know the vendor number and vendor's item number, you have the option when entering the purchase order number or pressing a function key that brings up a screen upon which you enter the number of the vendor and the item.  The program then lists on the screen all purchase orders upon which this item was ordered from this vendor, enabling you to choose the appropriate one.  The application is designed to make it as easy for you as possible to match the receiving with the correct purchase order and item.

 For routine shipments and shipments which fill the purchase order there is a function available that allows for very rapid entry of the receiving.  This feature automatically displays successive lines on the purchase order and allows the entry of the quantity received, disregarding entries for other fields.  Most shipments would be eligible for this type of entry so using it can make the entry of receiving a very quick and simple operation.

 The package will compare the receipt date with the request date and display a warning if the receipt date is earlier than the request date by a margin larger than company policy allows.  Over‑shipments are handled in the same way.  In each case the message advises the operator to notify the person responsible for authorizing such shipments before continuing with the entry.

Batch vs. On-line Receivings Processing

 Receivings Processing has the flexibility to run two different ways.  It can record receivings in batches which are posted in a separate step.  This allows for distributions to multiple G/L accounts.  It can also update the necessary files immediately (on-line) when transactions are entered.  This capability keeps your Inventory records as up‑to‑date as possible while still providing you with an audit trail of each receiving.

 The flag that determines if you are using batch or on-line processing is in the P/O Setup application.  There is a similar flag in the I/M Setup application that controls how transactions are handled in that package.  These two flags should be set for the same type of processing to avoid errors in distributions.

    Receivings Accrual Account

 If batch processing is being used, you must enter a Receivings Accrual Account number in the P/O Setup application.  This account is used to hold the value of received inventory until the invoice is entered in Accounts Payable.  The account is "global" in the sense that it is not tied to individual purchase order line items.  All received inventory is held in one account.

 When distributions are created in batch receivings processing, the accrual account will be credited and the inventory asset or expense account will be debited.  When an invoice is entered in A/P Transaction Processing, the accrual account will be debited and the A/P account credited.  For more information on batch and on-line receivings, see the Receivings Processing section of this manual.

 The following T-Accounts illustrate the debits and credits described above.  When batch receivings are posted, the following accounts are affected:

 

Receivings Accrual Account

 

Receivings Asset Account

Debit

Credit

 

Debit

Credit

 

100

 

100

 

 

 

 

 

 

 

 

 

 

 

 

When invoices are entered in A/P Transaction Processing, the following accounts are affected:

 

A/P Account

 

Receivings Accrual Account

Debit

Credit

 

Debit

Credit

 

100

 

100

 

 

 

 

 

 

 

 

 

 

 

 

 

If you are not validating account numbers from Elliott's G/L package, make sure you define the accrual account number in both the I/M Account File and the A/P Account File.

 During posting in the Post Receivings Transactions application, G/L entries for the inventory asset or expense and accrual accounts will be created in the I/M Distribution File.

Item/Vendor Relationships

 Many vendors can be suppliers of the same item.  Conversely, a single vendor can be the supplier of many items.  When you order material from a vendor they normally require you to use their item number, not your own, to identify the purchase.  The Purchase Order Processing application allows you to specify the items that a vendor supplies by both your item number and the vendor's item number.  This information automatically updates the Item Vendor File Maintenance application and is available to many of the applications in the package.  For instance, you may identify the line on a purchase order to which a receiving corresponds by using either your item number or the vendor's item number.  Since documents that accompany the shipment seldom reference your item number, this feature makes the receiving process easier and faster. 

Ship‑To Addresses

 Even small companies can have more than one shipping address.  The Purchase Order and Receiving package allows as many shipping addresses to be stored on file as you would ever want.  Each shipping address is accessed by a 4‑character code.

 There may be several inventory locations at each shipping address.  The package allows you to set up Ship‑to codes for each inventory location at each shipping address.  When you specify the shipping address for a purchase order you are consequently specifying the inventory location for which the material is intended.  

Purchase Order Inquiry

 Once a purchase order has been entered, printed and sent to the vendor, there are several means by which a buyer, purchasing agent, department manager, shop foreman or other interested party can observe the progress of receiving against the order.  The most convenient way to do this is through the purchase order inquiry.

 This program allows access to every purchase order on file and displays general order information such as the shipping address, terms, shipping method and order date.  Following the display of this data the screen shows detail of each purchase order line, including such information as the quantities ordered, received, rejected and invoiced.

Purchase Order History

 The inquiry program is useful for keeping track of active purchase orders. Once a purchase order has served its purpose it is closed, then deleted. Historical information is kept for orders that have been deleted. This information includes the purchase order number, the vendor number and detail for each of the lines on the order.  The line data includes the date the item should have been delivered, the date it actually was delivered, how much was ordered, received, rejected and canceled, and the expected and actual prices for the item.

 This information, which is available on reports, is designed to assist you in evaluating the performances of vendors, as well as the performance of specific buyers and the overall performance of your purchasing department.  

Vendor Analysis

 Another, more specific means of evaluating vendors is available.  The Vendor Performance Analysis Report bases its evaluation upon statistics stored in the Vendor file in the Accounts Payable package.  Relevant statistics include the value of purchase orders year‑to‑date and last year, the total number of purchase order lines and the number of lines that the vendor had late deliveries for, the extent to which the vendor has billed the items at a cost different from the price specified on the purchase order and the vendor's rejection rate.

Cash Requirements Projections

 Cash required for the payment of a vendor can be calculated as soon as the purchase order has been printed.  The package knows how much was ordered, at what price and when to expect the bill (at about the same time as the receiving).  The package also knows the vendor's terms so it knows when the invoice will be due.  With this data to hand it is a simple matter to anticipate when the cash payments must occur and how large they will be.

 The Cash Requirements Projection Report calculates the amounts that must be paid to each vendor over four periods (which you define).  These amounts are derived from unreceived purchase order lines, unbilled receiving and unpaid invoices in the Accounts Payable Open Item file.  For each vendor, the report shows the cash requirements for purchase orders and for accounts payable separately.  The report then shows the total aged cash requirements from both sources.

 Since both purchase order and accounts payable sources are utilized, the report can give a very accurate projection of your case requirements over the next few weeks or months.  How long a period of time the projection will be useful for depends upon the frequency with which purchase orders turn over in your company.

Serialized Items

 Serial numbers for items are supported by the Inventory Management, Purchase Order and Receiving, and Customer Order Processing packages. The user has the flexibility of stocking serial numbers for items or only assigning serial numbers to the item when it is sold or issued.

 A further explanation on implementation of serialized inventory is contained under Receiving Processing in P/O and Inventory Transaction Processing and Serial/Lot Processing in I/M.

Lot Number Items

 Lots are supported by the Inventory Management, Purchase Order and Receiving, and Customer Order Processing packages. Unlimited lots may be maintained for each item. Each lot contains quantity on hand, quantity allocated and expiration date by month and year.

 A further explanation on implementation of Lot Tracking is contained under Receiving Processing in P/O and Inventory Transaction Processing and Serial/Lot Processing in I/M.

Interface to Inventory Management

 Files within the Inventory Management package are accessed for a variety of reasons throughout the Purchase Order and Receiving package.  For instance, during the entry of a line on the purchase order, the program must check the validity of the inventory item which is being ordered.  If the item is categorized as a manufactured item, the program will warn the operator that the item is not normally purchased and ask if the entry is OK.

 During entry of receiving, the operator can specify the unit of measure in which the material is being counted.  If the unit of measure is not one of those allowed for the item, the program will force entry of a unit of measure that is acceptable.

 When a purchase order is entered, the quantity on‑order for each of the  items on the order is updated.  When material is received against the order, the quantity on‑order for the affected items is reduced.  Receiving also update the quantity on‑hand for the item at the appropriate inventory location.  

Interface to Accounts Payable

Accounts Payable personnel attempt to match the vendor's invoice with the receiving that corroborate receipt of the merchandise.  They require access to Purchase Order files for this purpose.  When they process the invoice for payment, each purchase order line that is billed has its quantity‑invoiced updated.  The Purchase Order and Receiving package considers a purchase order to be closed when all of its lines have been fully received and fully invoiced, so this billing information is important to those who monitor the status of purchase orders.

 If the item received has a item price variance account assigned through I/M, when the purchase order is invoiced through A/P, you will be asked if you wish to create a cost variance entry if the P/O received unit cost is not equal to the billed unit cost in A/P.  For more information on price variances, see the P/O Setup section of this manual.

 


Purchase Order

  1. Why Receiving Non-Inventory Items in PO Will Cause General Ledger Inventory Account Out of Balance?
  2. Order Has Been Printed But Not Posted
  3. When does the Purchase Line History data get updated?
  4. Can I Edit the Ship Date Field in PO Line Item Screen?
  5. Getting PO Lock File Problem During PO Printing
  6. Feature - Notes Tracking from PO Warehouse Receiving to Inventory Transfer Management to Inventory Transaction
  7. Feature - Prevent MM Item from Purchasing
  8. Feature - Include Or Exclude UDC in Buyer's Desk
  9. Feature - Item Number Verification After Serial Number Scan
  10. PO05S1 Purchase Order and Receiving Receivings Audit Trail Report
  11. PO05S2 Purchase Order and Receiving Drop Shipment Receivings Report
  12. PO0104 Purchase Order and Receiving Release Blanket Orders
  13. PO0105 Purchase Order and Receiving Purge Closed Purchase Orders
  14. PO0200 Purchase Order and Receiving Print Purchase Orders
  15. PO0300 Purchase Order and Receiving Purchase Order Inquiry
  16. PO0400 Purchase Order and Receiving Scheduled Receipts Reports
  17. PO0600 Purchase Order and Receiving Purchase Line History Report
  18. PO0700 Purchase Order and Receiving Cash Requirements Projection Report
  19. PO0800 Purchase Order and Receiving Commodity Code Vendor Report
  20. PO0900M Purchase Order and Receiving Vendor Performance Analysis Report
  21. PO1000 Purchase Order and Receiving P/O Setup
  22. PO1101 Purchase Order and Receiving Buyer Code File Maintenance
  23. PO1201 Purchase Order and Receiving Comment Code File Maintenance
  24. PO1301 Purchase Order and Receiving Reject Reason Code File Maintenance
  25. PO1401 Purchase Order and Receiving Ship-To File Maintenance
  26. PO1501 Purchase Order and Receiving Item Vendor File Maintenance
  27. PO1502 Purchase Order and Receiving Purge Item Vendor File Maintenance
  28. PO1601 Purchase Order and Receiving Vendor Service Address
  29. PO1700 Purchase Order and Receiving Clear Year-to-Date Statistics
  30. PO1800 Purchase Order and Receiving Open Purchase Orders Reports
  31. POCLSMNU Purchase Order and Receiving PO Close Processing
  32. POIMPMNU Purchase Order and Receiving Purchase Order Import
  33. POINVMNU Purchase Order and Receiving Invoice Processing
  34. POORDEXS Purchase Order and Receiving Purchase Order Export
  35. POEQMNT Purchase Order and Receiving Purchase Order Requisition
  36. POEQPST Purchase Order and Receiving Post Requisitions
  37. PORSTSCN Purchase Order and Receiving Reset P/O Rec/Inv Qty
  38. POUPDSTA Purchase Order and Receiving Update Vendor Statistics
  39. POWHRMNT Purchase Order and Receiving Warehouse Recovery Process
  40. POWRIMNT Purchase Order and Receiving Warehouse Receiving Import
  41. Feature -- PO Ship-to File Maintenance Determine Drop Ship Location by State/Zip Code Tables
  42. Feature - Warehouse Receiving Serial Number Validation
  43. Feature - Buyer's Desk Inventory Class Selection Criteria
  44. Feature - PO Ship-To File Received to Transit Location
  45. Purchase Order Line Item Add or Change Event
  46. PO0000 Purchase Order and Receiving Overview 1
  47. PO0000 Purchase Order and Receiving Overview 2
  48. PO0000 Purchase Order and Receiving Overview 3
  49. PO0000 Purchase Order and Receiving Overview 4
  50. PO0000 Purchase Order and Receiving Overview 5
  51. PO0000 Purchase Order and Receiving Overview : Index
  52. PO0100 P/O and Receiving Purchase Order Processing 1
  53. PO0100 P/O and Receiving Purchase Order Processing 2
  54. PO0100 P/O and Receiving Purchase Order Processing 3
  55. PO0100 P/O and Receiving Purchase Order Processing 4
  56. PO0100 P/O and Receiving Purchase Order Processing 5
  57. PO0100 P/O and Receiving Purchase Order Processing: Index
  58. PO2000 P/O and Receiving Receivings Processing 1
  59. PO2000 P/O and Receiving Receivings Processing 2
  60. PO2000 P/O and Receiving Receivings Processing 3
  61. PO2000 P/O and Receiving Receivings Processing 4
  62. PO2000 P/O and Receiving Receivings Processing 5
  63. PO2000 P/O and Receiving Receivings Processing 6
  64. PO2000 P/O and Receiving Receivings Processing 7
  65. PO2000 P/O and Receiving Receivings Processing 8
  66. PO2000 P/O and Receiving Receivings Processing 9
  67. PO2000 P/O and Receiving Receivings Processing: Index
  68. POFRMMNT P/O and Receiving P/O Form Setup 1
  69. POFRMMNT P/O and Receiving P/O Form Setup 2
  70. POFRMMNT P/O and Receiving P/O Form Setup 3
  71. POFRMMNT P/O and Receiving P/O Form Setup 4
  72. POFRMMNT P/O and Receiving P/O Form Setup 5
  73. POFRMMNT P/O and Receiving P/O Form Setup: Index
  74. PORCNMNU P/O and Receiving P/O Reconciliation Process 1
  75. PORCNMNU P/O and Receiving P/O Reconciliation Process 2
  76. PORCNMNU P/O and Receiving P/O Reconciliation Process 3
  77. PORCNMNU P/O and Receiving P/O Reconciliation Process: Index
  78. How to Retrieve Open Purchase Orders Through SQL SELECT Statement
  79. Feature - Receivings Processing Mass Receiving Changes
  80. Feature - Warehouse Receiving Mass Receiving

Feedback and Knowledge Base