Negative Cost of Sales due to Adjust Cost job in Nav 3.70B

mkhululi

One of my customers is running Navision 3.70B there was a time the Inventory adjust cost batch job was not running. When it finally ran sometimes when you run the adjust job the G/L account for COGS for some of the items registers negative cost of sales.

Can anyone help?

Savatage

not sure i understand.

Say your cost was 1.00 and it was posted.
After adjust cost (for whatever reason) the cost should have been 0.99.
the report will post a negative amount to fix the orig amount to it's proper amt.

:-k

mkhululi

If the cost of the item is say 1.00 the costing suddenly on adjusting instead of 1.00 it can come up with strange figures say 2,000 from no where.

Alex_Chow

mkhululi wrote:

If the cost of the item is say 1.00 the costing suddenly on adjusting instead of 1.00 it can come up with strange figures say 2,000 from no where.

Check the item ledger for that item and see if there are any wierd numbers. Once you find those wierd numbers drill down and navigate to the source record to see what the problem is.

No quick solution here, just need to spend some time analyzing.

mkhululi

Have identified some strange figures they are coming from the INVPOST source. The document no is from a Sales order but the sales cost is much much different and smaller.

Alex_Chow

mkhululi wrote:

Have identified some strange figures they are coming from the INVPOST source. The document no is from a Sales order but the sales cost is much much different and smaller.

1. What costing method is your client using?
2. Are they keeping track of cost per item & location? Or just Item?
3. Were there items received not invoiced?

mkhululi

The client uses Average cost, and item for calculation type

Alex_Chow

mkhululi wrote:

The client uses Average cost, and item for calculation type

Are you doing your analyse by Item? Or by location? If you sum up the cost posted to G/L without location filter, are the amounts okay?