Inventory Control

Inventory Control


Contents


Choose from the following categories for lists of frequently asked questions:

[TOP]


Costing and Pricing

[TOC]


Item Valuation Report

[TOC]


Fractional Quantities

If we turn on the Allow Fractional Quantities option, how long does it take for the program to set all quantities to fractions in our I/C database?

There is no conversion process when the option is turned on, therefore you do not need to allow for conversion time. Quantities are set to fractions only when you add them as fractions. No fractional amounts are added to the quantities already in your IC database at the time you turn on the Allow Fractional Quantities option.

[TOC]


Adding Items to Locations

I added a new item and used the Edit Item List For Locations function to add the item to all locations, but when I try to order this item through O/E, I get the error message "Item not active at this location" in O/E and I cannot place this item on order. What's wrong?

To place a new item on an order, you must either post a transaction (receipt or adjustment) against the item in Inventory Control to activate it, or install the Order Entry PTF 940830 (or later) update disk.

[TOC]


Transaction History

When is the Transaction History report updated?

The Transaction History report is updated only after outstanding Shipment, Receipt, Adjustment, Invoice, and Credit Note Audit Lists are printed to a printer or file, then cleared (purged). Audit list information does not appear on the Transaction History report until after the audit list is cleared.

[TOC]


How can I cost my Inventory Control out to three decimal places?

Inventory Control uses costing units of measure to provide the degree of accuracy you require. For example, to get the type of costing information you need for an item that costs .067 each, set up the stocking unit of measure or an alternative unit of measure that is 100 units of the item.

When you use the standard cost or a user-specified cost for an item, Inventory Control uses the unit cost to calculate costs of goods sold and item values for the Item Valuation report. All other costing methods use total cost (or total cost per receipt for FIFO and LIFO).

[TOC]


I created my Inventory Control data with three decimal places because I needed pricing and costing out to three decimal places. Now my GL, AR, and AP also use three decimal places. How can I get my GL, AR, and AP to display only two decimal places?

You cannot. If you set up Inventory Control with a currency that uses three decimal places, you must set up your entire integrated ACCPAC Plus database with three decimal places, so that all screens, documents, and reports in the integrated programs show amounts to three decimal places.

[TOC]


I recently posted Quantity and Cost adjustments for an item in my IC and now the cost is too low for that item. What is wrong?

When making a cost adjustment through the Enter Adjustments function, you must make the cost adjustment for the total cost, rather than the cost per item. For example, if you are adjusting a quantity of 5 at 1.25 each, your cost adjustment is 6.25 (5 x 1.25).

[TOC]


I want my markup-based-on-cost Pricing Policy to mark up from the Most Recent Cost. I have an amount in the Most Recent Cost field in item records, but the program uses the amount in the Standard Cost field. How can I get the program to use the Most Recent Cost field?

For the program to calculate based on the Most Recent Cost field, you must set your Standard Cost field to 0.00 in the Add/Modify/Delete Items function. The system will then use the Most Recent Cost field to calculate the markup price.

[TOC]


How can I cost my items using Most Recent Cost?

  1. Set up a control account set that uses Standard Costing as the costing method.
  2. In the Add/Modify/Delete Items function, select the control account set that uses the Standard Costing method.
  3. Enter 0.00 in the Standard Cost field for the item, and enter the most recent cost in the Most Recent Cost field.

The item will be costed using the most recent cost when it is sold.

[TOC]


I need to print my Item Valuation report for the first quarter, but the current date is May 1st. Although I signed on to Inventory Control with the March 31st date, the figures are all wrong when I print my Item Valuation report. What can I do?

The Item Valuation Report is not date sensitive. It reports all information that has been posted. To print this report and show only information up to a certain date you would have to temporarily restore your data files back to that date.

[TOC]


The following message is printed at the bottom of my Item Valuation report: "Residual cost for items with zero quantity," and the report lists a residual cost amount. What is residual cost and how can I remove it?

Residual cost is any cost (positive or negative) that is associated with an item that has a zero quantity. Residual costs are usually absorbed by your next receipt for the item, or cleared by future shipments of the item.

To clear a residual cost manually, enter an adjustment for the item and amount, selecting either Cost Increase or Cost Decrease (as appropriate) as the adjustment type.

Residual costs are generally caused by:

  1. Quantity Only adjustments that reduce an item's quantity to zero but do not adjust costs. To prevent this situation, enter both quantity and cost adjustments for the item at the same time.
  2. If you use the Allow Inventory Levels To Be Less Than Zero option, residual costs may occur when item quantities are negative. No adjustments should be made to remove residual costs in this case.

For example, assume item EFG has a quantity of 1 on hand, a cost of 9.00, and a most recent cost of 8.00. If you post a shipment for 2 units of the item, the program costs the first unit at 9.00 and the second unit at the most recent cost of 8.00 (because the program does not know what the cost of the unit will be, since you have not yet received it). The item record now shows a quantity on hand of -1 at a cost of -8.00.

If you then post a receipt for the item, showing a quantity of 1 at 9.50, the program records 0 (zero) as the quantity on hand at a cost of 1.50 (-8.00 + 9.50). If you were to print an Item Valuation report for the item, it would show a residual cost of 1.50 because the quantity on hand is zero and there is a cost of 1.50 posted to the item.

Top of Page

ic960905.exe corrects the following problems which can arise in the released version of Inventory Control 6.1B:

COPY A:\ICASP\CONV\ICCCHK.LD4 C:\ICASP

to copy the conversion program to the \ICASP directory on your hard disk.

General Instructions

After downloading the ACCPAC Plus PTF, copy the self-extracting file to a floppy disk, then run the self-extracting file from the floppy disk using the following syntax:

[filename]

The extracted files are now on the floppy disk.

Installing the PTF:

  1. Start ACCPAC Plus. When the Start list appears, press F3 to display the System Manager Menu.
  2. Press I, or use the Up or Down Arrow key to highlight Install Programs, then press Enter.
  3. Insert the PTF diskette in your diskette drive.
  4. Follow the instructions on the screen.

This will place the files in the appropriate directories.

Top of Page

If you have any suggestions about how we can improve our web page please email us.

Business Partners | Training | Internet| Services| Contact Us
Pricing| Client Area| About Us

S.B. Accounting Serives
Last revised: October 04, 2007