Registered: 05/08/12
Posts: 18
Loc: Lac du Bonnet, Mb.
I am VERY new to Adagio. I came over from Accpac Plus so the menu's are very familiar and so far the adjustment has not been dramatic. Obviosly Gridview is new to me, but I can see the huge potential in using this program. I have created a file to extract info from the IC Items(1) list described in the IC Data dictionary. My problem is that the search data does not retreive the correct "Qty on hand" that IC shows. It seems to me that it is not picking up the receipts that were entered into IC since our conversion. Can anyone give me some direction?
You need a calculated column to get the same number that is displayed in Inventory and OrderEntry as the quantity curently available for sale. Use this formula for the calculation:
Code:
{Qty on Hand 1} +
{Qty on Hand 2} +
{Qty on Hand 3} +
{Qty on Hand 4} +
{Qty on Hand 5} -
{Qty Shipped not Cost}
Registered: 05/08/12
Posts: 18
Loc: Lac du Bonnet, Mb.
This is great, or so I thought.
Gives me the results that OE and IC show available, but when I view the costs tab in IC and total the receipts the quanitity is out by the same value of "Qty Shipped not Cost"
{Qty Shipped not Cost}(ed) is the total quantity of the item in OrderEntry that have not yet been processed by Day end (and costed). You should run a data integrity in Inventory and OrderEntry to check to make sure the number is accurate. The costing tab in Inventory includes this number in the Quantity on hand, will display a different number in the FIFO/LIFO buckets if day end has not yet been run in OrderEntry. This screen shot is from the Adagio sample data:
Previous Topic
Index