This topic explains how to set up the options and security for the Advanced Receiving application. It also explains how to set up the Append to RV field in Vendor File Maintenance (MVR).
The following system option must be enabled on your system.
Windows Advanced Receiving on System (ID# 8628)
In Options Configuration, verify that this option is set to Yes. In the Options Configuration window, click ID, enter the ID number of the option, and press Enter. If this option is set to No, contact Epicor Direct at 800-538-8597.
Review and set up the options that apply to Advanced Receiving.
Click ID. Using the list below, enter the ID number of the option, and click OK. Click in the Current Value column, select the desired setting for the displayed option, and click Change. Repeat this process for all options listed.
ID #102 Cost Used In Calculations–
ID #106 Distribute Landed Cost to AP/MDE– You only need to set up this option if option 105 "Use Landed Cost" is set to W, X, Y, or Z. If this is the case, select Y or N in option106.
Y = Prorate Freight, Other, and Variance charges to the purchases expense account in A/P.
N = Pass off Freight to the Freight account in A/P. The sum of Other and Variance charges are passed off to the Miscellaneous account in A/P.
If you enter Y, the amount that is distributed to your A/P purchase expense account(s) is based on the equation Landed Cost x Quantity Received. Because this is the same equation that is used to update the Department File (MDE) with cost of purchases, A/P purchases will be consistent with MDE purchases, and therefore Epicor recommends you enter a Y. If you enter N, the amount distributed to A/P purchase expense is not based on the same equation as MDE cost of purchases, but instead is based on the equation Replacement Cost x Quantity Received.
ID #107 Create A/P Vouchers?– Enter T (Temporary) in this option. All vouchers will be created as Temporary.
ID #400 Create Adv Rec Vouchers for Current Period?–This option should be set to Yes. If set to No, any change to an Advanced Receiving record creates the passoff vouchers with a voucher date of the original receipt date. You can change prior period data in the General Ledger and also change how RIV compares to GL, financial statements, etc.
ID# 403 Prompt to delete both Voucher and RV Document?-When this option is set to Yes, when deleting a receiving document in Modify Receiving Documents (MRV), the system asks if you want to delete the corresponding temporary voucher from New AP Transactions (ATMU). In addition, when you delete a temporary voucher in ATMU, the system asks if you want to delete the corresponding document from MRV. Answering yes to this question deletes the corresponding receiving document from MRV when deleting a temporary voucher if it is not accrued. Answering Yes to the question when deleting a receiving document only deletes the receiving document.
ID# 1188 Advanced Receiving Activated– WARNING: This option should only be set to Yes when your business is ready to begin collecting and passing off Advanced Receiving data.
ID #8411 (ITR users only) Post RRV and RRP COGS adjustments via ITR– When this option to Yes, the cost of goods sold (COGS) adjustments on the Advanced Receiving Documents report (RRV) and the Receiving Report (RRP) will be routed through ITR. The benefit of setting this option to Yes is to create an audit trail for these COGS adjustments.
ID #8412 Require MRV's AP Voucher entry before processing Adv. Receiving document–
ID #8413 Allow sessions in WinMRV?– Set this option to Yes to enable the "Create new invoice session" function in Windows MRV (Modify Receiving Documents). Invoicing Sessions allow you to receive more than one invoice for a single purchase order, and split a single receiving document and pass off each invoice separately to A/P. However, most vendors send a single invoice for a given purchase order; if this is the case for most vendors in your business, set this option to No. Regardless of this option's setting, you can always make changes to existing invoice session documents. This option does not affect legacy MRV.
ID# 8472 to 8475 WinMRV other charges vendor 2,3,4,5 default?– Enter the vendor code that you want to display as the default value for “Other Charges Vendor 2, 3, 4, 5.” The additional charges can be entered via the Update Header function.
ID# 8491 to 8495 WinMRV other charges description 1,2,3,4,5 default?–Enter an informational description that will display in Windows MRV’s Update Header function for “Other Charges 1.”
Option 9400 Create MRV records for transfers at the to-store - Allows to consider completed transfers in average cost calculations in Advanced Receiving. When a transfer is received in a store from another store between the time a PO was received to when a PO is modified and/or invoiced in Advanced Receiving, the received quantity and cost of the transfer is considered when the average cost is recalculated at the time RRV with option F is ran.
Other charges follow option 105 "Use landed cost in receiving" to determine if the other charge is landed or not landed in item costs received.
The following security bits are relevant to the Advanced Receiving application.
Bit 318 "View previously received purchase orders" – This bit allows you to access Modify Receiving Documents (MRV).
Bit 319 "Add/Change previously received purchase orders" – This bit allows you to use Change and Save Order keys to change detail lines in Modify Receiving Documents (MRV).
Bit 321 "Allow previously received purchase order report" – This bit allows you to access the Receiving Documents Report (RRV).
Bit 324 "Allow finalizing of RRP and RRV Reports"– This bit allows you access to the option to Update Cost in RRP & RRV (Update Prices Option C).
Bit 792 "Allow change of header fields in WinMRV" – This bit allows you to use the Change button in the header area of Modify Receiving Documents (MRV). You must also enable bit 319 (see above) for this bit to work.
Bit 793 "Allow update of AP Voucher fields in WinMRV" – This bit, in conjunction with bit 319, allows you to make updates to AP Voucher fields in Modify Receiving Documents (MRV). You must also enable bit 319 (see above) for this bit to work.
Bit 794 Allow delete of RV documents in WinMRV" – This bit, in conuunction with bit 319, allows you to delete RV documents in Modify Receiving Documents (MRV). You must also enable bit 319 (see above) for this bit to work.
Bit 795 "Allow access to report RRA Advanced Receiving Audit Report" – This bit allows you to access RRA.
If desired, you can set the field “Append to RV” on the Accounts Payable tab of Vendor Maintenance (MVR) to Yes in which case finalizing a subsequent receipt of a PO (RRP- F) for a vendor appends the newly received lines to the already-existing receiving document for that PO.
If the new receipt is on a line#/SKU that already exists in MRV for that PO, and if that existing line has the same cost and has not previously had changes entered for quantity or cost, then the system adds the newly received quantity to the Last Rcvd Qty already on that line item.
If the cost does not match, or if the existing line has had modifications, the system looks through the items received for that PO for another match for that SKU and cost which has not been modified in MRV. If not found, the system adds a new line to the receiving document.
When “Append to RV’ is set to Yes, if the already-existing receiving document has sessions or an invoice number, it cannot be appended to; instead, the system creates a new receiving document.