The Manage Item Receipts function is used as a control to ensure Items are received prior to payment being issued for them. This function applies to Items marked in the system as Inventoried Items.
A shipment of (6) new Drivers and (48) sleeves of balls just arrived at the club. To ensure the Inventory records are updated properly, and the Invoice can be processed, the Pro Shop wants to ensure the items are received into Inventory.
Watch this video to learn how to receive an Inventoried Item in the Clubessential Office product.
Note: Sections of the videos have been referenced below with corresponding times in the video for ease of access
|Total Video (Length)||4:35|
|Navigation||0:08||Item Cost Variance||3:10|
|Create New Receipt||0:25||Print/Export Item Receipt Report||3:36|
|Quick Add Item Received||1:56||Item Receipt Memos||4:09|
To Receive an Item Into Inventory:
Click on “Accounts Payable”
Click on “Manage Item Receipts”
Then, click, “New.”
Manage Item Receipts screen will launch.
Enter Vendor goods are being received from. Use the Lookup Value screen to help locate Vendor, and then select Vendor name to populate field.
Note: If utilizing the Purchase Order System, select the appropriate Purchase Order from the list.
System will automatically assign an Item Receipt Number, and will populate screen heading with details from the Vendor Masterfile as well as Items from the Purchase Order, if utilized.
Add Items Received
To add an Item to receive, select “Item” from the drop-down “Type” field.
Next, select the appropriate Item in the Name field.
Note: If receiving Item for the first time and Item does not yet exist in the Item file, use the “Quick Add” feature to launch the Item Setup screen.
Click, “Quick Add.”
Then, complete Item Set-up as appropriate.
Once Item exists, and has been selected in the Name field, Description field will auto-populate. This field may be edited if desired. For instance, Description could be overridden to indicate these balls were ordered as part of the Spring Shipment.
Next, select appropriate sales area if more than one Inventoried Area exists for the Club.
Then, enter the appropriate received quantity and unit amount. Total field auto-calculates.
Line will automatically turn yellow if entered amount is outside of the system set variance, and will turn yellow for all new items.
Note: The Cost Variance Percent setting can be adjusted in System Settings.
Select, “System”, “System Settings.”
Choose “Accounts Payable.” Then, within the Inventory section, adjust Cost Variance Percent to desired level.
More Items may be added to the receipt as needed.
When all Items are added, and shipping costs need to be allocated to the Items, click the “Allocate Shipping” button. Then, enter total amount of shipping, and click, “OK.”
If system cannot divide shipping cost evenly across number of items, warning message will appear. Click, “Yes” to continue.
Adjust quantity of a received item down by one unit. For example, originally, 48 sleeves of ProV1’s were received. Change quantity on original line to 47 by clicking on the Received amount and editing.
After tabbing through the Received amount, Total cost will recalculate based on the revised quantity.
Then, add the Item back at the adjusted cost of the Original Price plus the Shipping Difference ($9.35 + $.14 = $9.49.) Total Quantity of sleeves remains 48, and shipping is fully allocated.
Populate the Memo field (if desired) with additional reference information, such as the Invoice number, or a special note.
Save, Close, Print
When complete, click, Save and Close.
Upon the “Save and Close” function, if cost variance still exists (yellow lines), system will provide warning. Click, “Yes” to continue, or investigate and edit as required.
Print Inventory labels if desired.
Upon save, new Item receipt appears at the top of the Item Receipt grid.
Print Item receipt report by clicking on the Item Receipt, and then clicking the “Print” button.
If desired, print, or export report to Word, Excel, or pdf format.
Q. How do I adjust the variance amount that triggers the Yellow Highlighted (Item) lines?
A. Go into System, System Settings, Accounts Payable Option, Inventory Section, and change the "Cost Variance Percent" field to desired percentage. Item line will turn yellow when variance exceeds this amount.