Artisan’s “Receiving Report” makes it easy to see detailed information about the items you’ve entered into Artisan. Select your date range, see all items or specific ones, and search by description, vendor, keyword, category, price range, and more.
Accessing the Report
There are two ways you can access this report. From the top of the screen, click on “Reports,” “Receiving Reports,” and “Receiving Report.”
Or, from the “Main Menu,” click on “Reports.”
Select “Receiving Reports.”
Click on “Receiving Report.”
Either way, you’ll end up at the following screen.
Report Fields
View the report examples for more detail.
Select Receiving Date Range From: Any receiving made between these dates will show here. Use the drop-down calendar, enter a date manually, or leave the date as-is.
Sites: If you have multiple locations, you can choose to view all sites, or just a specific site.
Group By: This is how Artisan will pull data for your report.
Receive Date: This lists each day items were received into Artisan. For example: November 7th, 2022, November 8th, 2022, etc. If you have Ite
Category: This lists the items you received alphabetically by category, including subcategories (nested categories). For example: Clothes, Womens, Womens Shirts.
Vendor: This lists vendors you received items from alphabetically. For example: ABC, Brownstown Clothes, Cynthia Peterson.
Receive Date/Time: Similar to the “Receive Date” report, but also includes timestamps. This report first sorts by date, then time stamp. For example: November 7th, 2022 at 9:18 AM EST, November 7th, 2022 9:21 AM EST, November 8th, 2022 1:38 PM, EST.
Sub-Group By Purchase Order?: Includes each individual purchase order (including PO number) with each receive date, category, or other method you chose to group the report by. For example: November 7th, receive w/o PO, November 8th PO #203, etc.
Show Stock Unit Detail?: Includes Item Codes, bolded and to the left of the report for easy viewing.
Include Quantities Added Without Receive?: Includes any item quantities that were added into Artisan in the Item Record’s QOH field, not in the receiving screen. We highly recommend using the receiving screen to add inventory to Artisan as there is a better understanding of where this quantity came from (usually a Purchase Order but not always).
Show ONLY Receive w/o PO?: This will show all items received into Artisan that weren’t received with a Purchase Order (ex. Using the “Receive No PO” button, selecting a vendor, and entering product quantities that way).
PO Number Range From: If you want to narrow down your scope to only show purchase orders with this number range (ex. PO #200 – 203).
Receiving Clerk: Leave this set to “All” if you want to display items received by all employees. Or, select a specific employee from the list.
Like most Artisan reports, you can narrow your results further by filling out other fields. For example, you can include only certain Items on the report by using “Specific Item” and typing in Item Codes separated with a comma, or using the magnifying glass to select from the Inventory Records screen.
The same methods apply to Description, Vendor, and other searchable fields. You can also include or exclude discontinued items, product variants, consignment items, and more, as well as filtering price range and quantity on hand. If necessary, you may save any fields you change for next time by selecting “Save as Defaults.” The next time you open the report, your selections will automatically be filled with the presets you defined. The only data that won’t save are date ranges.
Example Reports
Click images to expand.
Receive Date: The day you received the item(s) into Artisan.
Item Code: The product’s Item Code, found in its Item Record.
Description: The product’s brief definition, found in its Item Record.
Vendor P/N: If you’ve included a vendor part number, it will show here. The Vendor P/N is located in the Item Record.
PO Number: If this item is associated with a Purchase Order, the number of that Purchase Order will show here.
Units: The number (quantity) of each item that was received into Artisan.
Cost: The overall cost of the items received.
Price: The overall price of the items received.
Margin: This calculates how much profit, or sales, you’ll make by selling each item. Subtract the cost from the price, then divide that total by the price. For example, let’s look at the “BL-WHTSM” item. We have a price of $340 for ten shirts. The cost is $200. Subtract $200 from $340, which is $140. 140/340 is 0.41, which is a 41% margin.
Receiving Report by Receive Date
In this report, we sorted by date and included Stock Unit Detail. We can clearly see each item received into Artisan on specific days, including their Item Code, Description, Vendor P/Ns, PO Numbers, Units, Cost, Price, and Margin. Notice how OAS001 and OAS002 do not have PO number. This is because they were received into Artisan without a PO.
Receiving Report by Category
Here, our receiving info is sorted alphabetically by Category Code.
Receiving Report by Vendor
This report lists our receiving data alphabetically by Vendor Code.
Receiving Report by Receive Date / Time
This report includes a time stamp for when each item was received into Artisan.
Show Only Receive W/O PO?
This report option will list any Items received into Artisan without a purchase order.