PATI

The PATI (Purchase Order Analysis Transaction Items) REPORTS screen is used to track and report all transactions that have occurred to a PO or return PO. This includes item receipts (manual and via ASN) but also Vendor Order Adjustments and Vendor Changeovers. A vendor changeover is a type of vendor order adjustment where a part is being replaced by another part. The information reported includes the date the item was received, Purchase Order reference number and various quantities including the number received and cost.

 

Menu Path: Purchasing, PATI, PATI REPORTS screen

Menu Path: Reports, LISA Part Ranking, LISA PART RANKING REPORT screen, 'ASK PATI' button

Menu Path: Reports, LISA Transactions Report, LISA TRANSACTIONS REPORT screen, 'PATI' button

Menu Path: Reports, Part Ledger, PART LEDGER REPORT screen, 'ASK PATI' button.

 

Quick Reporting Options

Select the desired report:

 

TRANSACTION REPORT

Displays the 'Report Criteria' section that is used to search, preview, and print items received on a purchase order.

 

PO POST SUMMARY

Displays the 'Report Criteria' section that is used to search, preview, and print items that have been posted from a purchase order, in summary form.

 

Non-Returnable Parts

Displays the 'Report Criteria' section that is used to search, preview, and print items that are non-returnable.

Report Criteria

The following fields are used to filter the report by the selected fields and values to limit the data output. 
 

LOCATION

Filters by the selected store location. Report transactions from a different location or multiple locations by entering the store location number(s). Click the button to display the 'BROWSE LOCATION' window to select locations. 

 

VENDOR

Filters by the Vendor code(s). Click the button to display the 'SELECT VENDOR' window to select vendor(s).
 

LINE CODE

Filters by a line code. Click the button to display the 'BROWSE LINE CODES' window to allow selection of a line code(s) in order to search for purchase orders by a specific manufacturer.

 

PO SOURCE

Filters by a PO source type. Click the drop-down to select purchase order source type. Displays all sources when blank. Click the button to display the 'SELECT PO SOURCE' window to select multiple or all PO Sources.  

 

Options include:

 

• 'AUTOSRC - AUTORECEIVED SOURCED ORDERS'
• 'DEAL - DEAL ORDERS' (Available only if the 'USE DEAL ORDERS' enterprise control is enabled.)
• 'FORCE' - A purchase order created by Corporate on behalf of the store. Can be for orders from Corporate or orders from a 3rd party vendor.
• 'NID - NEW ITEM (DISTRIBUTION)'
• 'SHELF - DC SHELF REPLENISHMENT'
• 'SHELFSRC - SHELF SOURCED ORDERS'
• 'SOURCED - SOURCED ORDERS'
• 'XFER - INTERSTORE TRANSFER'

 

START PART NO

Specifies the Start Part Number to report data for a range of part numbers within a specific line. When only one match is found for the entered part number, the part number is loaded. When multiple matches are found, the 'FIND PART' window displays with all matches. Click the button to display the 'FIND PART' window to search for a specific part number.

 

The field is enabled only when one 'LINE CODE' is selected. When no 'LINE CODE' or multiple 'LINE CODES' are selected, the 'START PART NO' field is disabled.

 

END PART NO

Specifies the End Part Number to report data for a range of part numbers within a specific line. When only one match is found for the entered part number, the part number is loaded. When multiple matches are found, the 'FIND PART' window displays with all matches. Click the button to display the 'FIND PART' window to search for a specific part number.

 

The field is enabled only when one 'LINE CODE' is selected. When no 'LINE CODE' or multiple 'LINE CODES' are selected, the 'END PART NO' field is disabled.

 

PO TYPE

Filters by purchase order type:

 

Options are:

 

• 'ALL'
• 'BUY' - When selected, the 'PO SOURCE' drop-down and pop-up only display 'BUY' type purchase order sources.
• 'RETURN' - When selected, the 'PO SOURCE' drop-down and pop-up only display 'RETURN' type purchase order sources.

 

PO TRANSACTION DATE

 

START DATE

Specifies the start date/time to report data. Click the small down arrow to display a calendar. Click the desired date to select. Use the small left and right arrows to display previous/next months. Transactions created or submitted within the date range display. Enter a check mark in the field to report sales for a certain period. Displays all transactions, when unchecked. Defaults to current date.

Note: Since the PATI Report is a list of various types of transactions that happen to a purchase order (including vendor order adjustments and VCOs as well as receipt of purchase order items), a PO could have transactions across multiple dates. Therefore, to see all transactions that happened to a PO, it is recommended to either uncheck the 'START DATE' field and filter by ASN or PO number, or be sure the date range is early enough to include all transactions the user wants to see for the particular purchase order(s) being reported.

 

END DATE

Specifies the end date/time to report data. Click the small down arrow to display a calendar. Click the desired date to select. Use the small left and right arrows to display previous/next months. Transactions created or submitted within the date range display. Enter a check mark in the field to report transactions for a certain period. Displays all transactions, when unchecked. Defaults to current date.

 

PO NUMBER

Filters by a specific PO number.

 

ASN NUMBER

Filters by a specific ASN number.

 

TIMES POSTED

Filters by the number of times that PO has been transferred to stock. Searches all occurrences when field is blank.

 

OVER/SHORT/DAMAGED

Determines whether the Over/Short/Damaged Report that includes over/short/damaged quantities and battery serial numbers prints. 

 

Options are: 

 

• 'INCLUDE' - Reports the OVER/SHORT/DAMAGED REPORT after the requested PATI REPORT. (Default)
• 'EXCLUDE' - Reports the requested PATI REPORT without the OVER/SHORT/DAMAGED REPORT.
• 'ONLY' - Reports the OVER/SHORT/DAMAGED REPORT without the PATI REPORT.

 

ADJUST/STANDING ORDERS

Determines whether the VENDOR ORDER ADJUSTMENT REPORT prints. 

 

Options are: 

 

• 'INCLUDE' - Reports the VENDOR ORDER ADJUSTMENT REPORT after the requested PATI REPORT. (Default)
• 'EXCLUDE' - Reports the requested PATI REPORT without the VENDOR ORDER ADJUSTMENT REPORT.   
• 'ONLY' - Reports the VENDOR ORDER ADJUSTMENT REPORT without the PATI REPORT.

 

ZERO POSTED QTY

Determines whether the transactions with received quantity amounts of zero at the time of receipt are reported. 

 

Options are: 

 

• 'INCLUDE' - Shows all parts that were on the PO at the time of receipt. (Default)
• 'EXCLUDE' - Excludes transactions that have a received quantity amount of zero (0). Shows only transactions that had a received 'QTY'.  
• 'ONLY' - Reports only transactions with received quantity amount of zero (0).

Report Style

ASN

Generates the ASN PATI REPORT, when checked and available. An enterprise switch controls the display of this field.

 

PO

Generates the PATI REPORT, when checked and available. An enterprise switch controls the display of this field.

 

DISPLAY

Displays the 'Purchase Order Analysis Transaction Items' grid with the items that meet the report criteria with the option to 'PRINT' the report or go 'BACK' to the PATI REPORTS screen.

Display Screen

Right-click on any of the rows to bring up the right-click menu. Most of the right-click options allow the posted POs or ASNs to be opened in other screens, such as the Part Ledger Report screen or the LISA Transactions report screen.

The other three options, 'Re-Create Order', 'Reverse Order', and 'Undo Order' are used to "undo" orders in PartsWatch that have been posted.

After any of these options are selected, an “Are you sure?” prompt displays with 'Yes' and 'No' buttons. Click on the 'Yes' button and the process chosen continues.

If the 'Undo Order' option is selected, three different processing steps are performed, and three processing pop-ups are displayed in sequence; first a 'Reversing the order' pop-up, then a 'Posting the order' pop-up, and finally a 'Re-creating the order' pop-up.

Note: On the first two pop-ups, if the steps were taking too long to process, click the 'Close Without Waiting' button and the steps will occur in the background.

If the 'Re-Create Order' option is selected, only a 'Re-creating the order' pop-up displays and the process must complete.

If the 'Reverse Order' option is selected, only a 'Reversing the order' pop-up displays.

Undo PO Post Glossary

 
Original Order
The purchase order or return order that was posted in error.

Reverse Order
If you are reversing a purchase order, the reverse order is a return order.

If you are reversing a return order, the reverse order is a purchase order.

The primary purpose of a reverse order is to “reverse” (increment or decrement) the inventory stock quantities posted in error for all parts in the original order. 

Re-created Order
The primary purpose of a re-created order is to create a new order (purchase or return) that looks like the original order using most of the same criteria, options, and defaults used when creating the original order. 

Undo
A process that creates a reverse order followed by a re-created order.

 

Re-Create Order

1. Typically, a "re-created order" is only created as a third step within the 'Undo Order' option. 

2. However, it is possible to choose to create a "re-created order" by itself. A "re-created order" typically looks like the "original order" but both the 'REF #' and the 'PO #' will always be different.

3. In effect, it is possible to choose to manually perform the entire "undo"/"unpost" process yourself: first selecting the 'Reverse Order' option, then manually finalizing and posting/closing the "reverse order", then selecting the 'Re-Create Order' option, and finally manually finalizing the "re-created order".

4. The following field values are new for the "re-created order":

   1. The 'Ref' and 'Number'

   2. The 'Buyer'

   3. The 'Status' is always 'New' for a "re-created order" whether you perform a 'Re-Create Order' option by itself, or whether the "re-created order" is created as a step within performing the 'Undo Order' option.

   4. The option 'Create Order Below Min' is set to checked (TRUE) to ensure that the "re-created order" is created. 

   5. The 'Note' will use the same 'Note' as the "original order", but will add a reference to the "original order".
      
      
      

5. The following fields use the same values from the "original order":

   1. 'Source'

   2. 'Method'

   3. 'Profile ID'

   4. Part and Core cost levels

   5. 'Exchange Rate'

   6. 'Supplier Minimum Thresholds'

   7. The 'Use Buy Qty Rule'

   8. List of stores for a multi-store distributed order.

6. When the 'Re-Create Order' option is selected by itself, or if a "re-created order" is created as a step within the 'Undo Order' option, after the process completes of creating the "re-created order", the Purchase Order screen is opened and the new "re-created order" is displayed.

   1. If the row selected on the PATI Reports 'Display' screen had a 'Times Posted' value of one, and the "original order" was a Purchase Order, the new order will be similar to the "original order" when its status was 'Ord' before it was received into stock for the first time. 

   2. However, if the row selected on the PATI Reports 'Display' screen had a 'Times Posted' value greater than one, and the "original order" was a Purchase Order, the new order will be similar to the "original order" when its status was 'BKO' after the previous post occurrences.

Reverse Order

1. Typically, a "reverse order" is only created as a first step within the 'Undo Order' option. 

2. However, it is possible to create a "reverse order" by itself. 

3. In effect, you may choose to manually perform the entire "undo"/"unpost" process yourself: first selecting the 'Reverse Order' option, then manually finalizing and posting/closing the "reverse order", then selecting the 'Re-Create Order' option, and finally manually finalizing the "re-created order".

4. The following field values are new for the "reverse order":

   1. The 'Ref' and 'Number' 

   2. The 'Buyer'

   3. The 'Status' is always 'New' when only performing a 'Reverse Order' option. You must manually finalize and post/close the "reverse order". However, when performing an 'Undo Order', the system will finalize, post, and close the "reverse order".

   4. The 'Source' is set to 'Ovrstk' if the "reverse order" is a Return Order and set to 'Shelf' if the "reverse order" is a Purchase Order.

   5. The 'Method' is set to 'Write-In.'

   6. The option 'Create Order Below Min' is set to checked (TRUE) to ensure that the "reverse order" is created. 

   7. The 'Note' will use the same 'Note' as the "original order", but will add a reference to the "original order".

5. The following fields use the same values from the "original order":

   1. 'Profile ID'

   2. Part and Core cost levels

   3. 'Exchange Rate'

   4. 'Supplier Minimum Thresholds'

   5. The 'Use Buy Qty Rule' 

6. When you select the 'Reverse Order' option by itself (and a "reverse order" is not created as a step within the 'Undo Order' option), after the process completes of creating the "reverse order", the Purchase Order screen is opened and the new "reverse order" is displayed.

Undo Order

1. The purpose of the "undo" function is to reverse an order post occurrence. Note: The order may have been received multiple times but the specific post occurrence must be selected to be "undone". Typically, this is the last post occurrence.

2. When selecting the 'Undo Order' option, the other two options are performed: first a 'Reverse Order' and then a 'Re-Create Order'.

3. There are no system messages recorded for any of the "undo" steps performed.

4. The 'Undo Order' option will reverse each part's Receive Quantity on the specific order post occurrence that you selected.

5. If multiple parts were contained on the order, right-click on any of the part rows for the order post occurrence to be "undone".

6. Note that the data grid list in the 'Display' screen image above contains 10 parts that are contained within 3 different purchase orders (e.g. PO #s 'R0001-25480', 'R0001-25481', and 'R0001-25482'). 

7. Both PO # 'R0001-25481' or 'R0001-25482' contain two parts each, and these two orders were each posted only once.

8. Verify the posts by horizontally scrolling the grid to the right most column where the column 'Times Posted' is displayed. The value for this column would be one for both parts on both orders because one is the value for any first order post occurrence. 

9. See the sample screen below where the value of the 'Times Posted' column is circled in red for both orders:
   
   
   

10. Note in the sample screen that the two parts in PO # 'R0001-25481' have order quantities ('On Order' column) of 2 and 5, and post quantities ('Posted Qty' column) of 2 and 5 because these two parts were both received "in full". 

11. Note, however, that the two parts in PO # 'R0001-25482' have order quantities ('On Order') of 3 and 5 but post quantities ('Posted Qty') of 2 and 4, because this order's post occurrence was a partial fulfillment. Note: the quantities to be reversed are always the 'Posted Qty' and not the 'On Order' quantity.

12. Note, finally, that PO # 'R0001-25480' which also contains two parts, was posted three times. Therefore, depending upon which part row selected, determines which order post occurrence can be "undone": the first, second, or third. While you typically would want to "undo" the last order post, any order post can be "undone" in any sequence. 

13. Below is described the three steps of the 'Undo Order' option using an example with PO # 'R0001-25482' that was received in error.

14. In this purchase order's only post occurrence, two parts were posted. After the posting, the 'WIX 42015' had its stock quantity incremented by 2 and the 'WIX 51515' had its stock quantity incremented by 4. 

15. Since this order is a purchase order, the first of three steps is "Reversing the order", which will create a new return order. See the section for 'Reverse Orders'.

16. The second of three steps is "Posting this order", which will receive the newly created return order (the reverse order) in full, and close the return order. Note: After the posting and closure of the return order, view the return order on the PATI Reports screen. See sample below.
    
    
    

    1. Note there is a new RO# 'R0001-25454' (the display text for return orders is red) and the same two parts that were posted in the purchase order (the "original order") were posted in the return order (the "reverse order").

    2. Note the 'Posted Qty' values for the two parts; the 'WIX 42015' had its stock quantity decremented by 2 and the 'WIX 51515" had its stock quantity decremented by 4.

17. The third and final step is "Re-creating the order"; which will create a new purchase order using a new 'Ref #', and using the same parts as the first two steps. See the section for 'Re-Create Orders'. Regarding the recreated purchase order number used:

    1. If the original purchase order is closed, and there is no other open purchase order using that same purchase order number, then the new purchase order will reuse the same purchase order number as the original purchase order. 

    2. If the original purchase order is still open (in 'BKO' or 'ASN' status), or if another open purchase order is using the same purchase order number as the original, a new purchase number will be used.

    3. Note: When the 'Re-Create Order' option is selected, without being a part of an 'Undo Order' option, a new purchase order number will always be used.

18. After the third and final step is performed, the Purchase Order screen is opened, displaying the new re-created order.

19. In the example, after the creation of the new purchase order, view the new PO # 'R0001-25495' on the PURCHASE ORDER screen in the sample below:
    
    
    

    1. Note that the 'Ord Qty' values for the two parts (on the "re-created order") matches the 'Posted Qty' values from the return order (the "reverse order"). The 'WIX 42015' order quantity is 2 and the 'WIX 51515' order quantity is 4.

    2. Note that a new purchase order number was used ('Number' displayed is PO # 'R0001-25495') because the purchase order (the "original order") was in a closed status.

20. The new purchase order (the "re-created order") 'Status' is always set to 'New'.

21. Note: After the completion of the three "undo" steps, manually finalize the new purchase order (the "re-created order"). After this manual step is performed, the entire "undo" process is complete, and the original purchase order is "undone". (This step is MANDATORY).

22. If the original order to be "undone" had been a return order, then the three steps would have instead created a new purchase order (the "reverse order"), posted that purchase order, and then created a new return order (the "re-created order").

23. If there is an error during the processing of any of the three steps, the entire process is stopped and an error message prompt is displayed. Therefore, depending upon when the error occurs, some new orders may have been created.

Preview/Print the PATI Report

To preview/print a PATI Report with items that have been received on a purchase order, follow the steps below:

 

1. From the Menu, select Purchasing, PATI. The PATI REPORTS screen displays with the focus on the 'TRANSACTION REPORT' button. The current store location displays.

2. Enter the Vendor information in the 'VENDOR' field, as applicable. The Vendor information displays.

3. Enter the manufacturer's line code in the 'LINE CODE' field, as applicable. The Line Code text displays.

4. Complete the remaining 'Report Criteria', as desired, to narrow the search criteria.

5. Select the desired report from the 'Report Style' section. 

6. Click 'PREVIEW' ('Ctrl' + 'W') or 'PRINT' ('Ctrl' + 'P'). 'PREVIEW' displays the results on screen. 'PRINT' sends the report directly to the printer.

Purchase Order Transaction Items Report - ASN Style

The following is an example of the ASN PATI - PURCHASE ORDER TRANSACTION ITEMS REPORT.

 

When a VCO is applied, the PATI Report displays the old and new item on separate rows.

 

 

 
ASN #
Reports the 'ASN #', when available.

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included in the search options.

PRODUCT #
Reports the 'PRODUCT #', 'SKU', or 'UPC' as set up in the PART UPC ENTRY screen, and determined by the 'ASN RECEIVE PRODUCT' system control. Defaults to 'PRODUCT SKU'.

PO ADJ / RCV DATE
Reports the date of the PO was either received or adjusted via a Vendor Order Adjustment, whichever pertains to the transaction row being reported.

EMP
Reports the employee. Populates on PO receipt transaction rows (unless the PO was autoreceived by the system then the field is blank) and if the employee deletes the PO.

Vendor Order Adjustment rows are blank since these are applied automatically by the system and not by an employee.
 
RCPT COST $
Reports the part cost of a single item. Will be blank for adjustment transactions.

CORE COST $
Reports the core cost of a single item. Will be blank for adjustment transactions.

RCPT COST EXT $
Reports the 'RCPT COST $' multiplied by the 'RCVD QTY' for the item. Will be blank for adjustment transactions.

CORE COST EXT $
Reports the 'CORE COST $' multiplied by the 'RCVD QTY' for the item. Will be blank for adjustment transactions.

ON ORD QTY
Reports the on order value of that part number before the transaction for that occurred.

RCVD QTY
Reports the number of items received on the transaction being reported. On the row (not a total quantity of that item received so far against the PO).

ADJ QTY
Reports positive (+) and negative (-) Vendor Order Adjustments.
 
When a negative Vendor Order Adjustment is applied that equals the entire remaining on order or back order quantity, the order quantity is changed to zero and the items no longer report on the PO detail screen.

CANCEL QTY
Reports the number of ASN cancels, manual deletes and shortages. (Excludes Vendor Order Adjustments, which are reported in the ADJ QTY column.)

BKO QTY
Reports the value of the back order quantity after the transaction for the row occurred.
 
Calculation: Back Order Quantity = On Order Quantity – Received Quantity (+ or -) Adjust Quantity - Cancel Quantity

TRANS INSTANCE
Reports the number of times a transaction has occurred against the part on the PO. Includes PO receipts and Vendor Order Adjustments.

DEAL #
Reports the Deal number of the PO, if applicable, that indicates that the parts were added to a Deal PO from an xml communication.

PO SUBTOTAL
Reports subtotals for the 'COST EXT $', 'CORE COST EXT $', 'ADJ QTY', 'RCVD QTY', and 'CANCEL QTY' columns, per PO.
 
GRAND TOTAL
Reports the total of all POs reported.

Over / Short / Damaged Report

Reports the over, short and damaged quantities as well as the battery serial numbers received from POs.

 

 
VEN
Reports the vendor name for the corresponding purchase order.

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included in the search options.

LOC
Reports the location number.

PRODUCT #
Reports the 'PRODUCT #', 'SKU', or 'UPC' as set up in the PART UPC ENTRY screen, and determined by the 'ASN RECEIVE PRODUCT' system control. Defaults to 'PRODUCT SKU'.
 
PO RCVD DATE
Reports the date of the purchase order was received.

PART COST $
Reports the cost of the part number on the purchase order.

CORE COST $
Reports the cost of the core on the purchase order.

INBOUND
Reports the in bound quantity amount.

RCVD QTY
Reports the number received on that purchase order.

OVER QTY
Reports the over quantity or zero (0) if none.

SHORT QTY
Reports the short quantity or zero (0) if none.

DAMAGED QTY
Reports the damaged quantity or zero (0) if none.

CHNL
Reports the Channel. Options are 'D', 'E', or blank. 

BATTERY SERIAL #
Reports the battery serial number captured during PO receipt. Each user-entered 'Battery Serial #' is prefaced with an 'O' if the part is from an overage and a 'D' if the part is damaged. If two or more 'Battery Serial #s' are captured for a part, each 'Battery Serial #' is reported on a separate row.

The 'TRACK BATTERY SERIAL NUMBERS' flag in the SYSTEM PURCHASING SETUP screen must be checked in order to capture and track battery serial numbers. If unchecked, the 'SERIAL #' field will be blank.
 
ASN #
Reports the ASN number. Report is sorted by 'ASN #' and then by each PO # in the ASN. Each PO is then subtotaled.

PO <po #> SUBTOTAL
Reports a subtotal of the 'RCVD QTY', 'ON ORD QTY', 'BKO QTY', and 'ADJ QTY'.

Purchase Order Transaction Items Report - PO Style

The following is an example of the PATI - PURCHASE ORDER TRANSACTION ITEMS REPORT (PO report style).

 

When a VCO is applied, the PATI Report displays the old and new item on separate rows.
 

 

 
VENDOR
Reports the Vendor Code. This can be the supplier code or the selling store's store number in the case of a transfer.

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included in the search options.

LOC
Reports the location number.

PURCHASE ORDER
Reports the purchase order number.

PO RCVD DATE
Reports the date of the PO was either received or adjusted via a Vendor Order Adjustment, whichever pertains to the transaction row being reported.

PO CREATE DATE
Reports the date the purchase order was created.

PART COST $
Reports the part cost of a single item. Will be blank for adjustment transactions.

CORE COST $
Reports the core cost of a single item. Will be blank for adjustment transactions.

FREIGHT COST $
Reports the freight cost of a single item. Will be blank for adjustment transactions.

DUTY COST $
Reports the duty cost of a single item. Will be blank for adjustment transactions.

RCVD QTY
Reports the number of items received on the transaction being reported. On the row (not a total quantity of that item received so far against the PO).

ON ORDER QTY
Reports the on order value of that part number before the transaction for that occurred.

BKO QTY
Reports the value of the back order quantity after the transaction for the row occurred. 

Calculation: Back Order Quantity = On Order Quantity – Received Quantity (+ or -) Adjust Quantity - Cancel Quantity

CANCEL QTY
Reports the number of ASN cancels, manual deletes, and shortages.

TIMES RCVD
Reports the number of times the PO has been received.

DEAL #
Reports the Deal number of the PO, if applicable, that indicates that the parts were added to a Deal PO from an xml communication.

PO SUBTOTAL
Reports subtotals for the 'RCVD QTY', 'ON ORD QTY', 'BKO QTY', 'CANCEL QTY', and 'TIMES RCVD' columns, per PO.

Over/Short/Damaged Report

Reports the over, short and damaged quantities as well as the battery serial numbers received from POs.

 

 
VEN
Reports the vendor name for the corresponding purchase order.

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included in the search options.

LOC
Reports the location number.

PRODUCT #
Reports the 'PRODUCT #', 'SKU', or 'UPC' as set up in the PART UPC ENTRY screen, and determined by the 'ASN RECEIVE PRODUCT' system control. Defaults to 'PRODUCT SKU'.

PO RCVD DATE
Reports the date of the purchase order was received.

PART COST $
Reports the cost of the part number on the purchase order.

CORE COST $
Reports the cost of the core on the purchase order.

INBOUND
Reports the in bound quantity amount.

RCVD QTY
Reports the number received on that purchase order.

OVER QTY
Reports the over quantity or zero (0) if none.

SHORT QTY
Reports the short quantity or zero (0) if none.

DAMAGED QTY
Reports the damaged quantity or zero (0) if none.

CHNL
Reports the Channel. Options are 'D', 'E', or blank.
 
BATTERY SERIAL #
Reports the battery serial number captured during PO receipt. Each user-entered 'Battery Serial #' is prefaced with an 'O' if the part is from an overage and a 'D' if the part is damaged. If two or more 'Battery Serial #s' are captured for a part, each 'Battery Serial #' is reported on a separate row.

The 'TRACK BATTERY SERIAL NUMBERS' flag in the SYSTEM PURCHASING SETUP screen must be checked in order to capture and track battery serial numbers. If unchecked, the 'SERIAL #' field will be blank.

ASN #
Reports the ASN number. Report is sorted by 'ASN #' and then by each PO # in the ASN. Each PO is then subtotaled.

PO <po #> SUBTOTAL
Reports a subtotal of the 'RCVD QTY', 'ON ORD QTY', 'BKO QTY', and 'ADJ QTY'.

Adjust/Back Order Report

When more than one adjustment is sent on the ASN for the same part on the same PO, the PATI REPORT displays each 'ADJ QTY' / 'ADJ CODE' on a separate row. Only the 'LINE' and 'PART NUMBER' print for all rows. 

 

 
VEN
Reports the vendor name for the corresponding purchase order.

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included in the search options.

LOC
Reports the location number.

PRODUCT #
Reports the 'PRODUCT #', 'SKU', or 'UPC' as set up in the PART UPC ENTRY screen and determined by the 'ASN RECEIVE PRODUCT' system control. Defaults to 'PRODUCT SKU'.
 
PO RCVD DATE
Reports the date of the purchase order was received.

PO CREATE DATE
Reports the date of the purchase order was created.

PART COST $
Reports the cost of the part number on the purchase order.

CORE COST $
Reports the cost of the core on the purchase order.

RCVD QTY
Reports the number received on the purchase order.

ON ORD QTY
Reports the on order value of that part number before the transaction for that occurred.

BKO QTY
Reports the number of back orders on the purchase order.

ADJ QTY
Reports the number of adjustments on the purchase order. 

REASON
Reports the reason for the adjustment/back order.

EXP ARRIVE DATE
Reports the expected arrival date.
 
GHOST ORDER
Indicates if the order is a "ghost" order based on the expected arrival date sent on the ASN. Note: The 'N' number of days, which defaults to '30', is stored in an enterprise table and is not user-definable from the application.

Options are:

 - 'Y' - Indicates 'YES', the part has not been received with in the 'N' number of days after the expected date of arrival.
 - 'Blank' - Indicates 'NO', the part has been received.

Vendor Order Adjustment Report

The following is an example of the VENDOR ORDER ADJUSTMENT REPORT.

 

When more than one Vendor Order Adjustment is sent on the ASN for the same part on the same PO, the PATI REPORT displays each 'ADJ QTY' / 'ADJ CODE' on a separate row.
 

 

Note: A Vendor Change Over is a type of Vendor Order Adjustment where the part that was originally ordered is being replaced by a new part. These transactions will always report two rows on the Vendor Order Adjustment Report; one row with a negative 'ADJ QTY' for the old part, and another row with a positive 'ADJ QTY' for the new part.

 

 
PO
Reports the purchase order number(s).

LINE
Reports the vendor line code.

PART NUMBER
Reports the part #(s) included.

PRODUCT #
Reports the 'PRODUCT #', 'SKU', or 'UPC' as set up in the PART UPC ENTRY screen and determined by the 'ASN RECEIVE PRODUCT' system control. Defaults to 'PRODUCT SKU'.
 
Note: Product # is redirected to the replacement part and removed from the old part via Vendor Change Over (VCO) process. 

PO ADJUST DATE
Reports the date of the Vendor Order Adjustment. 

PO CREATE DATE
Reports the date the purchase order was created.

PO COST$
Reports the cost of the part number on the purchase order. 

CORE COST $
Reports the cost of the core on the purchase order. 

PO COST EXT $
Reports the 'PO COST $' multiplied by the 'ADJ QTY' for the item.
 
CORE COST EXT $
Reports the 'CORE COST $' multiplied by the 'ADJ QTY' for the item.
 
ON ORD QTY
Reports the value of the On Order as it was before the Vendor Order Adjustment occurred. Note: If multiple transactions have occurred for the part, this is not necessarily the very beginning original order quantity; it is the "before the transaction" quantity.
 
When a Vendor Change Over (VCO) is applied to a PO, the old part reports the original order quantity (the order quantity just before the VCO applied, not necessarily the original order quantity at the time the order was initially transmitted) and the new part reports zero (0).

ADJ QTY
Reports both negative and positive Vendor Order Adjustments.

When a Vendor Change Over (VCO) is applied to a PO, the old part reports the negative value of the original quantity. For example, if the 'ON ORD QTY' was 11, 'ADJ QTY' is -11. The new part reports the positive value of the original order quantity.

REASON
Reports the reason for the vendor Order Adjustment.

When a Vendor Change Over (VCO) is applied to a PO, reports as VCO.

DESCRIPTION
Reports the Vendor Order Adjustment Reason Code Description.

When a Vendor Change Over (VCO) is applied to a PO, reports as 'VENDOR CHANGE OVER'.
 
SUBTOTAL Row

VEN
Reports the Vendor (Supplier) Code or the selling store's store number in the case of a transfer.

DEAL #
Reports the Deal number that indicates that the parts were added to a Deal PO from an ASN communication.

PO <po #>SUBTOTAL
Reports a subtotal of the 'PO COST EXT $', 'CORE COST EXT $', and 'ADJ QTY'.

GRAND TOTAL
Reports the total of all POs reported.

Non-Returnable Parts Report

Prints a report that outputs information on non-returnable parts, parts that cannot be returned to the vendor.

 

 

 
Loc
Displays the location the part was ordered to.

Vendor
Displays the vendor the part was ordered from.

Return Order, Number #
Displays the return order number from the system.

Return Order Create Date
Displays the date the return order was created in the system.

Line
Displays the line of the non-returnable part.

Part Number
Displays the part number of the non-returnable part.

Part Description
Displays the description 1 value of the non-returnable part.

Order, Qty
Displays the quantity of parts that were ordered that are non-returnable.

Denial Date
Displays the date the vendor denied the part to be returned.

Denial Reason
Displays the reason the vendor denied the part to be returned.