negative inventory although not allowed

[johnhugh]

Hi, I'm using Accpac 6.

I've set negative inventory to be not allowed.
However when I run the Item valuation report as of 31/12/2014 I find an item which has a negative inventory.

We run day end processing when posting and not as a seperate day end.
Tried to sort the transactions in the database by transaction date, post date or audit date, but it still comes down to negative inventory.

What am I missing? Any pointers anyone?
Very strange.

 

[Jay Converse]

That's always been a terrible report. Check your cutoff dates, and use Location Detail Costs.

 

[johnhugh]

I thought its the dates as well, but it isn't.
Looked at all the transactions in ICHIST for the item in that location and arrive at the same result as the report.

What else could it be?

 

[ettienne]

Print the transaction history report for that item and analyze the results.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[johnhugh]

Thanks. That report adds up to negative inventory as well.
I wonder whether it might be a bug in Accpac?

 

[Jay Converse]

Maybe. Have you had your local consultant look at the data?

 

[johnhugh]

I think I found it.
Exported the transactions from the database again and sorted it by Audit Date.
I have internal issues processed in January but posted into December.
Accpac reports seem to calculate it by posting date thus the report shows negative quantity when there wasn't.

I guess running day end would take care of this, but then again that would only help if running it as little as possible (once a week).
Running day end daily would still have the same results as we see now with running dayend after posting?

 

[Jay Converse]

Dunno. You're the only one having this problem, you'll have to experiment.

 

[johnhugh]

I'm the only one having identified the problem. Actually our auditors have.
The underlying issue seems to be that Accpac allows you to post and internal usage in previous periods but ignores the stock on hand of that period and looks at the curretn stock on hand instead.

For example:

I have 3 qty in December.
I receipt 5 qty in January.
I issue 8 qty in January, but post into December.
Accpac should tell me it only has 3 qty for December, instead it issues all 8, leaving me with -5 qty as of December and 0 qty as of January.

 

[ettienne]

Day end processing has no effect on that. transactions are assigned a day end sequence number and are processed in that sequence.
Don't confuse the date order and the actual order in which transactions were entered/posted. Users can back date or post date transactions and that can scew the report results if sorted in date order.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[Jay Converse]

Oh well. That's why I tell my clients not to trust that report. You'll have to send a change request to Sage, that report hasn't changed in a decade.

 

[ettienne]

If you look in the ICHIST table you will see DAYENDSEQ, ENTRYSEQ and LINENO - these will give the chronological order in which transactions were posted.

Sage 300 ERP Certified Consultant

http://www.adssglobal.net

 

[johnhugh]

True. Good point also.