To access Receiving:
- Menu Bar > Modules > Receiving > Receive by Product
- The Receiving (Receiving In Bulk) screen appears.
- Click on the Find icon in the Task Bar
- The Receiving Query window displays.
- The premise behind this Query window is identical to the optional Product Find Query window
- It allows you to create and save queries
- It also allows you to run a search without specific Query parameters--or you can do a combination of the two.
- To create a new query:
- Click on the Manage saved queries button
- Select Create a new query to save.
- A small window appears, prompting you to name the query
- Key in the name of your new query and click on the OK button.
- The name you just keyed in will display in the "Using saved query" field back in the Query window.
- To select the criteria for the new query. Direct your attention to the fields under the heading Saved query.
-
Select Field: Choose the category you want to define your query by
- e.g. select Vendor.
-
Select Operation: Choose Like, equal to, greater than, less than, greater than or equal to, less than or equal to, or between.
- e.g. select equal to
-
Choose Value: Choose the value or values that define the selection criteria.
- If you select between Select Operations two fields will display under Choose Value.
- In the top field, choose the start value.
- In the bottom field, select the ending value.
- But to continue our example select Ingram
- The query:
- Select Field = Vendor
- Select Operations = Equal To
- Choose Value = Ingram
- Will be run a query for all products not yet received from Ingram.
-
Select Field: Choose the category you want to define your query by
- Once you have set the query fields the way you want
- Click on the Add button
- The query criteria you just set will display in the Selected Ranges box.
For Date categories (such as Order Date), a calendar will display if you click on the down arrow at the right of the Choose Value field(s).
- If you want to blank out the query fields and begin again (prior to clicking on Add)
- Click on the Cancel button.
- The query fields are blanked out.
Repeat the above process as many times as you want to define the criteria for your query.
Each time you establish a new set of criteria and click on the Add button, the new criteria will display in the Selected Ranges box.
The more sets of criteria you select, the more specific the parameters of the query will be.
After creating the criteria for this new query
- Click on the Manage saved queries button
- Select Save the current query.
- At this point, you can run the query immediately, or you can exit the query without running it.
iMerchant Tips: If you want to run the query and add even more layers of specificity define these layers using the top two fields Criteria to find records at the upper left of the query window.
When creating your new query templates, you should make one query that is completely blank and name it All.
Then, if you want to simply run a search using the two basic Find fields in the upper left of the query window Criteria to find records without running it against the parameters established in a specified query, you can.
Manage Saved Queries Options
Let's take a closer look now at the other selections under the Manage saved queries button
Two choices allow you either to view the list of queries saved only by you or the list of queries saved by everyone on the system.
This is user-definable and up to you. You can switch back and forth anytime you like, but the system will always default to the way you left it the last time you were in the Query window.
These two selections have a direct impact on:
Using saved query: Click on the arrow and a dropdown menu displays, listing all of the saved (existing) queries you can choose from.
- When you select one, that query's criteria will display in the window.
- At that point, you can run the query.
Delete the current query: Clicking on this will call up a dialogue box asking you if you want to delete the query that's displayed.
- If you do, Click on Yes.
- The query will be deleted.
Include inactive (deleted) records that meet the selection criteria:
- Checked = records that have been deleted from iMerchant will be included in the search.
- Unchecked = these records will not be included, even if they fall under the query's criteria ranges.
To run the query
- Click on the Submit the query button
- or Click on Exit without searching if you do not wish to run the query
Query Results
Once a query is run, a list of matching products displays back in the lower portion of the Receiving screen.
These are the products you will wish to receive.
Take note of the Status column.
- The status of each product will either be:
- Pending: meaning the product has not yet been received
- Complete: meaning it has been received.
Also take note of the Retail Order and Retail Product columns.
- If the product in any row is still Pending and the Retail Product Price is different from the Retail Order Price
- The price listed under both the Retail Order and Retail Product column will be highlighted in red
To handle the bulk receiving of products with such a price discrepancy use If New Receive price is different from current:
- There is a drop-down menu.
- Select the option you want applied to all products you will receive in bulk that have a price discrepancy.
- The selections here work the same way as they do in the Detail window.
- The only difference is, when you receive such products in bulk, this setting only applies to Pending products
- in the Detail form, both Pending and Complete products can be altered.
Before receiving any products, you can key in the invoice number and invoice date under the Default Receiving Settings
- The date, if left blank, will default to the current day's date.
Discount (optional): If you leave it blank, whatever discount specified on the PO for the product(s) in question will be applied.
- If you enter a value here, at this point, it will override the discount from the PO.
Problem Code: can be assigned to multiple selected products simultaneously (or just one selected product) if there is an issue (i.e., short-shipped, damaged merchandise, etc).
- To assign a Problem Code at this screen:
- Highlight the products for which you want a specific Problem Code to be assigned.
- Check the box to the left of the Problem Code field and select the appropriate Problem Code.
- When you later receive these products in bulk, the Problem Code selected here will be assigned to them.
- If you need to assign a different Problem Code to a different product or group of products
- Repeat the procedure above.
Receive Shipment (optional): either select an existing Receive Shipment record, or, more likely, create a new Receieve Shipment record.
Label printing settings: you determine whether or not you want to batch the labels (or print them now), and you can print the labels here, as well.
- The Update label settings button opens the Settings for printing labels window.
- In Label printing mode
- Click on the arrow at the right of the field.
- Choose Print now or Save to batch.
- In the other field:
- Select the printer you will use to print the labels
- Key in the number of copies
- Select the label stock to use.
- in the Customer Order labels only check-box
- Checked = only Customer Order labels will be created.
- Unchecked = all labels will be created.
- Click on the Apply button to accept the changes
- or Cancel to get out of the window
- In Label printing mode
Whatever you selected in the Label printing mode field will display to the right of Mode on the Receiving screen.
If you chose Save to Batch, the Print batched labels button will call up the Label Printer Selections window.
iMerchant Tip: Make sure you select a default Customer Order label type in Store Maintenance. If you do not, no Customer Order labels will print. Customer Order labels are created for each individual product that is received to fulfill a Customer Order.
The upper left of the Receiving screen contains the Receiving Summary box
- This details data for products received on the invoice you're working on.
- When you first call up a list, the information will generally be all zeroes.
- After receiving items, the applicable data will fill in.
Receive Products
Now, it is time to actually receive the products into your store.
You can receive as many products as you want in bulk, simultaneously.
- Highlight all of the products you want to receive..
- Click on the Receive Selected Task Bar icon at the top of the screen
- The Confirm Receiving window displays, detailing the number of different products you are about to receive along with the total quantity and invoice number and date.
- Click on OKin the Confirm Receiving window.
- Clicking on Cancel backs you out without receiving the products.
- The system will process the received products, the Receive Remaining column on the Receiving screen will be zeroed out for the just-received products
- The Just Received column will fill in with the quantity just received for each applicable product
- The rows for all products just received will turn yellow.
- The Products Received box in the upper left corner will also update.
To print the labels for the products you have received (If you haven't already printed labels in the Label printing settings)
- Click on the Labels Task Bar icon
- The Printer Selections window appears.
- Review the information
- Make any necessary changes.
- When you are ready, click on the Printbutton
- If you want to preview the label before printing it, simply click on the Preview button.
You can also print label batches later:
Select Reports > Print Labels from the Menu Bar
You can also add products to a PO using this screen as a navigation tool :
- Highlight a product from the Receiving screen.
- You can only select one product at a time from the list for this process.
- Click Add to This PO on the Task Bar
- This will call up the properties screen for the PO that includes the just-selected product.
- Whatever discount you have defined from the Receiving screen will carry over to the PO.
- From here, you can change any information on the PO, or you can add a new product to the PO.
- Anything you do here in PO Properties will work the same as usual, except
- when you click on the Receive, Apply to PO, or Add to PO buttons, you will be returned to the Receiving screen
- If you added a new product in PO Properties, it will now be listed on the Receiving screen, along with all of the other products originally called up after you ran your query.
To see more detail and receive a product by itself:
- Highlight (or scan) the product you want to receive
- Click on the Receive Detail toolbar icon at the top of the Receiving screen.
- The Receiving Detail screen opens for the just-highlighted product.
The Receiving Detail screen is divided into two basic sections: a work screen and a grid at the bottom of the screen.
When you access the Receiving Detail screen, the information listed is just for the one product you had highlighted at the Receiving screen.
At the top of the Receiving Detail screen, the PO number, vendor the product was ordered from, and store it was ordered for display.
Just below that, product information displays.
All of this is for your information.
At the bottom of the screen, there is a grid.
Any previous orders for the selected product (including the current order) are listed at the top of the grid.
- These are grayed out (not changeable) and provided for your information.
The work screen (above the grid) is where you actually receive the item.
The cursor defaults to the Quantity field, which automatically fills in with the ordered amount (determined on the PO).
- Generally, you will likely not need to change this amount, but if you do, simply key in the new amount.
Change the Unit Cost, Total Cost, Retail Recvd, and Discount % fields only if necessary.
The price in the Retail Recvd field will fill in automatically based on the value of the PO Retail Price field in the PO you are receiving against.
- You can change this value here, if you wish.
- If you do change the value in the Retail Recvdfield
- When you click on the Receive button, a dialogue box will appear.
- This will ask you which price in the product's inventory file (Product Properties) you want the change to be applied to: both MSRP and Retail price; Retail price only; Buying price only; or Buying price, Retail price, and MSRP.
- There is also a selection that allows you not to have any of the pricing updated in the inventory file.
- Choose the selection you want, and the product will be received in and the appropriate pricing change will be updated on the inventory file.
- This dialogue box will also appear automatically if the price in the Retail Recvd field is different from the retail price for the item in Product Properties.
- If you change the Buyingprice
- the new Buying price will be impacted depending on whether the received item is using the List price or the Net price.
- If you don't explicitly change an item's List or Net Price value to Net Price, it will always default to List Price.
- If you choose List, when you change the retail price in Receiving
- The buying price will be updated with the retail price.
- If you choose Net, then when you change the retail price in Receiving
- The buying price will be updated with the received cost value of the item in question.
- If you choose List, when you change the retail price in Receiving
Please note, if the Unit Cost here in Receiving is different from the item's Buying price in Product Properties
- The price change dialogue box will appear, allowing you to adjust the price.
- If you choose to update the unit cost, the item's Buying price in Product Peoperties will be updated with the unit cost value here in Receiving.
The Problem Code field is used if there is an issue receiving the item.
- For example, if the Unit Cost has changed, you may want to attach a Problem Code.
- Problem Codes are optional unless the Quantityfield has been altered in Receiving.
- If the Quantity received does not match the Quantity ordered (i.e., either shortshipped or overshipped), or if the received Quantity is entered as zero, then you must enter a Problem Code.
To enter a known Problem Code:
- Key in the appropriate Problem Code and press Enter.
- The Problem Code field is filled in.
To enter an unkown Problem Code:
- Click on the binoculars icon at the right of the Problem Code field
- This takes you to the Find Problem Code screen.
- Select the Problem Code you want.
If you have assigned a Problem Code, the Available Date field becomes active
- Enter an appropriate date in this field, if applicable.
- Available Date is grayed out if no Problem Code is assigned
If you have not yet filled in the Invoice Number and Invoice Date back on the Receiving screen:
Key them in now in the applicable fields.
In the Invoice Date you can click on the arrow at the right of the field and choose the date from the mini calendar
To the right of the work screen, there is the Product Pricing box.
- The MSRP, Retail, and Buying prices are listed for the selected product.
- If you need to change any of these prices here, you can.
If the rows in question have already been exported to Accounting, you cannot change them.
The last column in the grid at the bottom of the screen lets you know if the item in question has been exported.
Once everything is in order on the Receiving work screen
- Click on the Receive
- The product is received, and your system inventory records are automatically updated.
Once you receive a product, a new row appears in the grid at the bottom of the Receiving Detail screen.
- This is the Just Received row, it reflects the action you just took.
- The product you just received is listed in this row, and the Quantity column fills in with the Quantity you received in the work screen.
If you need to change something after you have received the item:
- Change what you need to back in the work screen
- Click on the Receive button again.
- The Just Received row will be updated with the changes you made in the work screen.
If you want to Unreceive (cancel) an item after clicking on the Receive button:
- Click on the UnDo Task Bar button
If you have not yet checked the Save Labels to Batch field back on the general Receiving screen
- You can do it here. It is located to the right of the Invoice Date field.
You can print labels here, too.
- Click on the Print Labels
Once you have received the item, close the Receiving Detail screen by clicking on the Close button in the Task Bar
You are returned to the Receiving screen.
The product you just received will now have its Receive Remaining and Just Received columns updated in the selection grid at the bottom of the Receiving Properties screen, and its row will now be yellow.
If, at any time in the process, you need to go back to the Receiving Detail screen for any product on the Receiving screen
- Highlight the product
- Click on the Receive Detail Task Bar button.
- At that point, if needed, you can change information for the product.
Correct / Undo Receiving Error
- Call up the receiving detail screen and click on the incorrect line.
- This will bring the information to the top where it can be edited.
- Change the quantity to zero and apply a problem code saying the item is still coming.
- The receiving line will still be there but received with a zero quantity.