Hey there

Ok, I know this has come up before but I'm now having this problem again. I could never figure out exactly why my inventory valuation reports were a bit off from the inventory Gl Account. I thought I had it licked when I only posted inventory adjustments in Adagio Inventory after all the day ends were done. Well it appears that is still not the case. Since we do continually have data integrity errors in PO's (Wrong po quanities displayed, and The Steif Group is working on this) I thought this maybe part of the problem. Well finally no, it's obvious now it has nothing to do with Purple PO's and I believe it's a glitch in Adagio Inventory or something is wrong at my end, maybe in the settings. Since I have never had any data integrity problems with Any Adagio programs, I honestly don't believe it's my system but you never know. Note however, we lost the use of ACCPAC inventory after the last Adagio updates since they were not compatible with the ACCPAC inventory version we had and we were not going to upgrade ACCPAC Inventory module.

I've seen this question asked before by others in this forum so I really believe that it needs to be looked into again at your end why the inventory item account balance doesn't match the Inventory Gl account. If you have an answer how to fix, I'd appreciate it.

Senerio was this:

I did an adjustment to make an inventory item and costs negitive. Yes our system allows negitives.

Adjustment was made for -900 ea = -679.30 total cost. I posted this adjustment after all the Day ends were done.

The inventory valuation then showed up as -900 ea = -675.00. (calculated the units at the recent unit cost of .75 instead of what I posted) The Transaction history was correct as posted showing -900 = -679.30 and also that is what was posted to the inventory GL account. The Adagio inventory item however displayed at -900 ea with a total cost of -675.00. Yes, I know what you're thinking, and yes inventory item balance was zero to start with, there was not a residual balance in this item. I checked before I posted the adjustment.

So it appears there is a still a problem with adjustments being posted in inventory incorrectly. I sure hope this can be corrected.

If you don't have an immediate answer that is fine, Just as long as it is looked into. Thanks for your help.

ps: While I'm here, I'd also like to know the exact order the Day Ends should be done. I've always done Day ends in OE, Then Inventory, then PO's, did my inventory adjustments in Adagio Inventory, then Day end in inventory again, Retrieve to GL.

Thanks

Hi Treasure S.

Thanks for your detailed analysis of the Adjustment posting in Adagio Inventory 80B. I attempted to duplicate this by creating a new item and then immediately posting a Quantity and Cost Decrease adjustment so that the end result was a negative qty and cost. The adjustment amount was not an extension of qty times most recent cost but something different.

After posting, the amount written to the GL sub-ledger was the same as the amount written to the Item cost as viewed by Item Inquiry - that entered as the Cost adjustment amount. So there may be more to the scenario that you are running into.

1) When you posted the adjustment mentioned in your previous post, was it a Quantity and Cost adjustment or simply Quantity?
2) What is the costing method of this item - FIFO, Standard Cost, etc?
3) At the time of posting the adjustment, what was the total cost and total qty on hand for the item? Both 0.00 or something else? From your post, it appears that both were 0.00 but need to make sure.
4) I assume that there is previous transaction history for this item, prior to posting this adjustment.

We'll need to be able to duplicate the scenario with the specific steps in order to be able to make any changes.

Thanks for using Adagio!

PO Day End should always be done before OE Day End.

I would suggest that you adjust your order of Day End Processing to: Inventory, then PO, then Order Entry. Then do any adjustments in Inventory, run Inventory Day End again, and retrieve to GL.

This method completes any earlier activity in Inventory, updates quantities and costs from receiving, and then allocates the costs of sales.

Thanks for trying that. Here's some additional info

1.Adjustments are qty & costs
2.Moving average
3.what was the total cost and total qty on hand for the item?Total cost was zero
4. Previous transaction attached

Final balance showing is 2nd image.

The final adjustment showing in image one was to get rid of the $675.00 out of that account and get it back to where it belongs at the correct cost. As you can see if you add up the transaction they did not match the total listed in the 2nd image. This is the amount that is should be. The inventory for these 900 units were originally removed to allow a special purchase at a lower sale/cost to go through at the correct cost.









thanks Kate. My dealer had advised to always do adagio d/e's first then po's although depending when my payables dept. is in that's not always possible.

thanks all have a good weekend cya monday

Treasure

Hi again,

Just wondering if you Adagio folks have all the info you need?
If so I'll delete my images from storage. Let me know if you need anything else.

I haven't had any other situation with negative adjustments not being posted properly that I found, but I don't have that many anyway. I have had two more situations with my actual Inventory Valuation has been different from my GL Inventory Acct. I just adjusted, I did not find where it was at and it was not a significant amount to worry about. With my volumne it's not worth looking for a needle in a haystack.

I know you have Day End procedures for AR AP & Gl, I think it would be great if day end procedures would be made up also for the other modules,(OE,INV,IR) since it has been a bit of a frustrating experience especially with the add on of Purple PO's in my case. I think it's important for now that it should be mentioned that the Day End in Inventory should be done before and after all transaction affecting it if posting receipts through Purple PO's.

I'm determined to figure out why there are difference In the item valuation reports and Inventory GL accts and also why there are data intregity errors in PO's (Stief group is also working on this).

If I have more info, I'll let you know.

Have a good night and Thanks for assistance.

Thanks Treasure

Hi

Just wondering if someone got some problem since the update because my item valuation is not equal to my GL account.

I still got some integrity error like item XX is 90.97 but should be 100.00.

I'm posting each day POA first, Counter Sales.

The difference between the Item valuation and the GL seam to be the difference between the quantity integrity that I have the day before the new posting.

I'm testing everyday, it's to only thing that I found.

Monique

Hi

Why I still have Integrity error in IC for quantity:

ACI-SA1045 1 1/2 total quantity on hand is 33.55 but should be 34.00
I have 60 Items error found (application integrity Phase)

I found the problem for item valuation not matching GL account
Ex: 33.55 minus 34.00= .45 x 6.38 Cost= 2.87

Each time that we have an integrity error the item valuation is not balancing with the GL account.

I know that it's possible to rebuild, but here is not the problem I need those quantity like 1.25

Monique

Hi, Monique,

I'm sorry but we really don't have enough information here to know why the costs become incorrect. We are not currently aware of something in Adagio that makes this happen.

What I'd suggest is that you first make a backup and do the Rebuild. That should correct the errors and you can continue knowing that, at that point, the costs were correct.

However, after you'll need to do some more sleuthing to determine when the costs go out again and why. For example, the costs are correct after the Rebuild. What things are being done that affect the costs? Perhaps focus on a few very active items that experienced the problem already. Now, when you do something that can affect the costs (like a day end, posting a purchase order or using your point of sale programs), check and
see if the costs have become incorrect again.

Is integrity clean in the other modules/programs you are using?
This can be a delicate process but is necessary in order to determine what is occurring and why.

Hi
Fisrt I will answer you

Is integrity clean in the other modules/programs you are using?
Yes
Job Tracker 7.0A (update 07 july 2004) ok
Counter Sales 2007.11.20
POA 8.0(08 oct2007)OK
G/L 9.0A(071219) ok (still have to install the serve pack)
and so on for payable, recevable, pay dirt

IC Item....60 errors found

Determine when the costs go out again and why.....
February 21, I found exactly what was the problem.
I don't thing the problem is a costing problem , but maybe a quatity rounding problem...


Item valuation 497773.52$ GL 497780.12 including for example:

CAT (FER) 43719.39(ITEM VAL) GL ACC 43720.49 DIFFERENCE -1.10
(ELE) 153630.60(ITEM VAL) GL ACC 153626.16 DIFFERENCE +2.24

The next day (first thing in the morning) I make sure to only post POA first and do an another check. The difference was the same.
So we proceed with the Counter Sales posting. I was able to note 2 item that was not into to error integrity list but having decimal quantity, so I note the cost , the average cost and so one.

(FER) ACI-SA1045 1 1/4 cost 6.38/feet sold 1.125 feet

(ELE) ELE-T1770 cost .51/inches sold .25 inches

After the posting I check the gl transactions with the transaction history the cost was ok BUT...............

when I reprint the item valuation, redo the check data integrity and reprint it, and checked the GL amount I found that the difference was:


CAT (FER) 42787.88(ITEM VAL) GL ACC 42876.12 DIFFERENCE 1.76:
-1.10(cat difference) + 2.86(NEW ITEM IN THE LISTING INTEGRITY ERROR )
ADD into the integrity check list:
Item ACI-SA1045 1/2 total quantity on hand is 33.55 but should be 34. (.45x6.38=2.87)

same:
(ELE) 153374.05(ITEM VAL) GL ACC 153371.74 DIFFERENCE -.13
2.44 + -.13 (NEW ITEM IN THE LISTING INTEGRITY ERROR )
Item ELE-T1770 total quantity on hand is -29.75 but should be-30.(-.25x.51=-.13)

It seam to me to be a rounding decimal problem not a costing one

I know that those amount are small but before doing the testing I posted a GL transaction to be sure that the GL and the item valuation was balancing (almost 1108.$). After the GL transaction were made I test each day the GL transaction (actif acc, and CGS acc, and transaction history in IC)I found nothing wrong, each amount was matching.

Hope that will help you to find what is my problem with decimal quantity and not my costing problem.

Monique

Hello Monique,

Have you asked Island MicroSystems whether they are aware of any problems posting fractional quantities to Adagio Inventory?

Since you are running both CounterSales and POA, Adagio Inventory isn't actually being used to process receipts (POA) and shipments (CounterSales).

To test that Adagio Inventory correctly processes a fractional shipment for an item, take an item and transaction that caused a problem, and re-enter the shipment directly in Adagio Inventory (you'll need to do this on a copy of your data).

Hopefully, we can help isolate it to the module that has a problem.

Sorry for the inconvenience, and thanks for the thoroughness of your tracking.