e-Invoice Reports

An Advanced Shipping Notice (ASN) feed is a method in which ASN data, also known as e-Invoice data, is copied from an external database into the PartsWatch database. Items from an ASN are received in containers, also known as totes. Often, there is more than one container per ASN. 

 

This feed of ASN data from the client-provided file to the PartsWatch ASN file is performed on a regular basis. The file is placed on an FTP site by the client and picked up and fed into PartsWatch. The e-Invoice Reports enable the user to print this captured data.

 

The e-Invoice Reports screen is used to preview and print the e-Invoice Summary Report' and 'e-Invoice Detail Report', both of which are generated from the feed of raw e-Invoice (ASN) data from the client's system to PartsWatch. This file includes both e-Invoices and e-Returns.  

 

Menu Path: Reports, e-Invoice Reports, e-Invoice Reports screen

 

Quick Reporting Options

e-Invoice Summary

Displays the 'e-Invoice Summary Report' that reports a list of invoices with invoice header information only. Displays no part detail. 

e-Invoice Detail
Displays 'e-Invoice Detail Report' that reports part detail and other information that would be on an invoice. The report resembles an invoice.

 

Containerized Report

Displays the 'Containerized Report' that reports part information per container.

Report Criteria

Location
Filters by a specific store location. Click the button to display the 'Browse Locations' window to search for a specific location. Defaults to the store that the system is currently logged in to.

Line Code
Filters by a line code. Click the button to display the 'Browse Line Codes' window. Displays the word 'Multiple' when multiple line codes are selected. Available for the 'e-Invoice Detail Report' only.

Part Number
Filters by a part number to report within a specific line. Click the button to display the 'Find Part' window. Displays grayed out when no line code is entered. Available for the 'e-Invoice Detail Report' only. 

Start Date
Indicates the start date and time for the search for reporting purposes. 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.

Automatically populates with the appropriate date when a 'Calendar' or 'Fiscal' option is selected. 

When saving as a profile, using the relative date option is recommended rather than selecting dates from the pop-up calendar. If the profile is saved with a fixed date range, then whenever the report is run using the saved profile, the report’s output always contains the same information for that fixed date range only. If the profile is saved with a relative date range, the dates are adjusted based on when the report is run.

End Date
Indicates the end date and time for the search for reporting purposes. 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.

Automatically populates with the appropriate date when a 'Calendar' or 'Fiscal' option is selected. 

When saving as a profile, using the relative date option is recommended rather than selecting dates from the pop-up calendar. If the profile is saved with a fixed date range, then whenever the report is run using the saved profile, the report’s output always contains the same information for that fixed date range only. If the profile is saved with a relative date range, the dates are adjusted based on when the report is run.

Calendar
Uses Relative Calendar dates, when selected. Works in conjunction with the 'Start Date' and 'End Date' fields.

Fiscal
Uses Relative Fiscal dates, when selected. Works in conjunction with the 'Start Date' and 'End Date' fields. 

Note: Fiscal Periods refer to the most recently completed (closed) instance. 

Warehouse Invoice #
Filters by a warehouse invoice number. Value is 0 - 9999999. 

Vendor
Filters by a specific vendor.

e-Invoice Summary Report

The 'e-Invoice Summary Report' displays a list of accounts. 

The following is an example of an 'e-Invoice Summary Report, Include: None':

 

The following is an example of an 'e-Invoice Summary Report, Include: List of POS':

 

The following is an example of an 'e-Invoice Summary Report, Include: List of Order Numbers':

 

The following is an example of an 'e-Invoice Summary Report, Include: List of Containers':

 

 

 
Date Range
Reports the reporting date range specified. 

Location
Reports the reporting location.

Include
Reports the 'Include' option selected. 

FOE jobber
Reports the jobber number at vendor.

Packslip File
Reports the pack slip file number.

Vendor
Reports the primary vendor number. Note: Also refers to the warehouse location. Typically, '1' displays if there is only one warehouse.

Packslip Date
Reports the date transmitted to jobber (WHSE) or date received from warehouse.

Date Posted
Reports the date posted. 

Vendor #
Reports the primary vendor number. Note: Also refers to the warehouse location. Typically, '1' displays if there is only one warehouse.  

Whse#
Reports the Location Number - Location ID.

Warehouse Invoice #
Reports the warehouse invoice number. The letters indicate the type of transaction, such as DB for debit invoice. 

Invoice Date
Reports the invoice date. 

Pack Slip
Reports that there is a pack slip.

Transaction
Reports the transaction name.

Terms
Reports the terms text.

Total Amounts
Reports the line total. 

Grand Totals
Reports the calculated total sum of the column.

e-Invoice Detail Report

The 'e-Invoice Detail Report' reports part detail and other information that would be on an invoice. The report resembles an invoice.

The following is an example of an 'e-Invoice Detail Report (Debit)'.

 

 

 
Warehouse Invoice #
Reports the warehouse invoice number. The letters indicates the type of transaction, such as Db for debit invoice and Cr for credit invoice.

Bill To
Reports the bill to name and address.

Ship To
Reports the ship to name and address. 

Ship Via
Reports the shipper name.

Terms
Reports the terms text.

Invoice Date
Reports the invoice date.

Date Shipped
Reports the shipped date.

Date Ordered
Reports the date ordered. 

Customer Order Number
Reports the PO number.  

Sales #
Reports the salesman number.  

Cust #
Reports the customer number at the warehouse.

Container #
Reports the container code. 

Order #
Reports the order number. 

PO #
Reports the JCON purchase order number.

Ref #
Reports a system-generated item number. 

Line
Reports the line code.

Part Number
Reports the part number.

Pack Code
Reports the pack code.

Ord Qty
Reports the total quantity ordered. Displays as a positive number for both debits and credits.

Back Order
Reports the order status. Options are 'B' (Back Order), 'C' (Cancel), or blank.

Ship Qty
Reports the total quantity shipped. Displays as a negative number on credits. Displays an 'M' if part was split across multiple containers.

Unit Cost $
Reports the unit price (price before discount).

Net Price $
Reports the net price (price after discount).

Net Core $
Reports the net core price.

Ext Amt $
Reports the calculated 'Ship Qty' total (Net + Core). Prints as a negative amount on a credit invoice. 

Invoice Total 
Reports the total invoice amount.

Cash Disc
Reports the cash discount when paid.

Core
Reports the core total amount.

Taxes
Reports the sales tax amount.

Freight
Reports the freight amount.

Handlg Chg
Reports the handling charge amount.

Total Extended Unit Price $
Reports the total of 'Qty Ship' x 'Unit Price'. Prints as negative amounts on a credit invoice.

Total Discounts Earned $
Reports the total of ('Qty Ship' x 'Unit Price') - ('Qty Ship' x 'Net Price') for each part summed together for all parts. Prints as negative amounts on a credit invoice.

Total Net Invoice $
Reports the total net invoice amount. Prints as negative amounts on a credit invoice.

Invoice Discount $
Reports the calculated discount percentage ('Total Discounts Earned' / 'Total Extended Unit Price') X 100).

Container Count
Reports the system-generated count of containers represented by the invoice.

Containerized Report

 

 
Container
Reports the container that the parts were shipped in.

Line
Reports the line code of the parts.

Part Number
Reports the part number of the parts.

Part Desc
Reports the ‘Description 1’ value of the part.

Qty Ordr
Reports the quantity that was ordered for each part.

Qty Rcv
Reports the quantity actually received for each part. 

Qty BKO
Reports the quantity on backorder for each part.

Warehouse Invoice #
Reports the warehouse invoice number. The letters indicates the type of transaction, such as Db for debit invoice and Cr for credit invoice.

Whse#
Reports the Location Number - Location ID.

Order #
Reports the order number. 

PO #
Reports the purchase order number.

PO Ref
Reports the PO Reference number assigned by the system.