Page 2 of 2 < 1 2
Topic Options
#8744 - 03/23/07 01:43 PM Re: Cost Variance [Re: Retired_Guy]
Anonymous
Unregistered


yes it does but as I stated it was correct, there was a large cost variance.

mp

Top
#8747 - 03/23/07 02:33 PM Re: Cost Variance [Re: Retired_Guy]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11616
Loc: Vancouver, BC Canada
Hi Mauricio,

I tried a test with Adagio Inventory (80B-2006.11.02) and Adagio OrderEntry (80A-2006.08.25) where I created an item that uses Standard Costing method and both Most Recent Cost and Standard Cost as 5.20. Base Price is 10.00 and made sure that the item is allowed at all locations.

I started by creating an order/invoice for qty 2300 in OrderEntry and posted and ran Day End. I then created a receipt in IC for the same location and qty 2300. At this point, all quantities and costs were 0.00 when inquiring on this item. I then created and posted and Day Ended a 2nd order/invoice for the same item and qty 2300. OE Day End did not calculate any cost variance as expected because the Most Recent Cost and Standard Cost were both still equal at 5.20. The amounts updating the IC Control Account and Cost of Sale account were both the same as well.

So I was unable to re-create the problem you reported with the versions of IC and OE I mentioned (which happen to be both one release after what you are using). Assuming that the costs you posted are coming from the IC Transaction history report, this means that you have printed and purged the Invoice Audit List report in OE - so we can't check there to see what information is recorded there. If you have a printed hard-copy of the OE Invoice Audit List, perhaps check to see what cost values are there.
------
You mentioned at the beginning that you entered orders with Adagio OE but invoiced with Accpac Plus OE. How do you do Day End Processing? This is key as Day End is what determines the costs for IC items.
-----
On your posted information, I see that the Cost of Goods GL account was different. Did you change this information (either the item's Category code, or the GL account on the Category code) between the Day Ending of the first and second OE invoice? It was account 5532 and now it is 5005.

Also, the amount going to your Inventory Control GL account 1205 is significantly different (27,496,000) than what it was the first time (-11,960.00). I think this is the key to determining the issue, rather than this being a Cost Variance problem (which is likely correctly calculating a difference but just between two values that shouldn't be different).

It is Day End in OrderEntry that is determining the costs. Wherever you are doing Day End (either with Adagio or Accpac Plus) then I believe this is the cause of the problem.
_________________________
Regards,
Softrak Tech Support

Top
#8772 - 03/26/07 01:04 PM Re: Cost Variance [Re: Retired_Guy]
Brian Stief Offline
Waterloo Guy

Registered: 04/04/06
Posts: 1741
Loc: Waterloo, Ontario, Canada
Hi,
Purchase Orders for Adagio updates the defined cost fields being possibly most recent cost, or standard, or Cost 1 or Cost2, at the time of creating a Purchase Order, if the recent cost was zero at the time of creating a PO. We do this to ensure that any items being shipped prior to receipting or being processed by End of Day processing in OE, have proper costs inside of Order Entry, General Ledger, and Sales Analysis. This also ensures proper costing for new items added to inventory.

By updating the recent cost at the time of creating a PO, gives you the flexibility to process sales orders in any time sequence you desire. A significant improvement over ACCPAC Plus.

Is there a reason why POA is installed but not being used?

Brian
_________________________
Brian Stief,CPA,CA
Stief Group www.stiefgroup.com
Link2 Systems www.link2systems.com
800.540.3164

Top
Page 2 of 2 < 1 2


Moderator:  Christa_Meissner 
Who's Online
2 registered (Samuel Kopstick, 1 invisible), 90 Guests and 3 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
Su M Tu W Th F Sa
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31