The Adjustments to Received Merchandise program allows you to correct errors or make changes to a Receiving that has been posted. It allows you to change the Quantity Received, the Receiving Cost, or the Invoice Number which in turn will correct Quantity on Hand, Warehouse (average) Cost, and Replacement Cost.
If a Voucher is created and is posted or Dated Billing is Calculated, Adjustments to Receiving are not allowed. Adjustments must be done manually or with another Receiving.
If you Received without a vendor invoice, match up the prices from the posted Receiving and make any necessary changes to unit costs.
Changes made in “Adjustments to Received Merchandise” will update a Voucher that has been created when Posting the “Receive Merchandise” (4.1.1). The adjustment time, date, and who made the Adjustment will be recorded. This will print on the Receiving Report.
The Receiving must be posted to be adjusted. To select the last Receiving number, enter a <-> and press <ENTER>. If the last Receiving number was posted it will be displayed. This is convenient when the last Receiving that was posted needs to be corrected.
To Adjust a Part Number type an <A> and press <ENTER>. Type in the Part Number to be adjusted. When using the Lookup (?) feature, only the Part Numbers on the Receiving will be displayed. Then enter in the Correct Quantity Received. Next enter the new Correct Unit Cost for this Part Number and press <ENTER>.
Enter <AA> to add all Part Numbers on the Adjustment to the Received Merchandise. This is useful for adding discount or freight after the Receiving is Posted.
The Adjustments to Received Merchandise has a full screen edit of quantity and cost after <AA> Add All parts has been requested. After entering <AA> to add all, you must enter <A> to do an adjustment. At that point you will go up to the middle of the screen and be able to go through each line and modify the quantity and/or cost.
Posting Adjustments to Inventory will update the Quantity on Hand and Warehouse Cost.
Be careful – If you post the Receiving more than once with a discount or freight, then the discount or freight will be taken more than once.
You may have Back Orders stay on the order.
The New Cost may be recorded in the Vendor file or only in this one Receiving record. If recorded the new cost will be changed in “Inventory Entry” in INVENTORY (5.1.1).
If the "Update All Locations" flag is set to "Y" in "Inventory Setup" in SYSTEM MANAGEMENT (10.2.4.2 field 1), the Replacement Cost is recorded in All locations rather than just the Receiving location.
A problem may exist if more than one location is Receiving at different costs. If this is the case, then ONLY the main receiving location should record the costs when receiving.
When a discount is taken at Receiving, the new Replacement Cost (Price Code 98) will be the cost before the discount. The cost after the discount is used to calculate the new Warehouse (Average) Cost (Price Code 99).
You may enter the Receiving Discount by a Dollar Amount or Percentage. If a Dollar amount is entered, the program will automatically calculate the Discount Percent and enter it into the Discount Percent field. To enter a Dollar amount, you must prefix the dollar sign ($) to the amount.
If you want to Delete a Receiving Order brought over from a Purchase Order, you must first Cancel the Purchase Order. This will automatically delete any unposted receiving attached to the Purchase Order.