GL Inventory vs Stock Status

[Maz61]

I was wondering what other people do to balance their GL Inventory with the Stock Status. Our Stock Status is off considerably with our GL Inventory. I pretty much deduced that most of the problem is due to inventory items going into the negative. When processing receipts against these items, the new average cost is not calculated correctly. Does anyone else run into these issues and how do you correct your Stock Status value? Do you do anything to prevent negative inventory amounts? Thanks in advance for any input.

Running Progression 7.6.400 on SQL2000 SP4.

 

[dgillz]

Switch to Standard Cost. Average costing is hosed when you go negative. This is a long standing issue.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[dgillz]

I also have a checklist of situations that can CREATE an out of balance on my downloads page:

http://www.gainfocus.biz/downloads.html

Included in the is the corrective action to take when you have gone negative, which is to manually change the cost in Item Location maintenance.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[Maz61]

Thanks Don. I'll check it out.

 

[leishad]

I have created a Crystal Report that is run after orders are selected for billing but before they are posted. This report shows me whether the qty on hand will be negative as a result of any sales invoicing. Then we unselect and investigate. (I also include fields to check for any $0 costs on line items, for $0 sales, for variance between oecost and inventory cost at time of billing...all of these areas have assisted the bookkeeping dept)