Product in Sage 50c shows a negative allocation even though no sales orders have been allocated, can't amend.

SUGGESTED

I have been setting up products and bill of materials etc, I have sales orders entered but not allocated any stock yet.  I had tried to allocate products but had all products set as nonstock so could not produce shortfall reports etc.

I edit all products and changed to stock, now one item has a negative allocation, I have run 'clear stock transactions' but got the message that there were no stock transactions, I have reindexed stock transactions, neither worked.

I have tried amend allocations, adjustments in and out but none of them will even let me even get a line item come up.

I have tried to delete the product as last resort but I can't as Sage is convinced it has an allocation.  There is no activity shown in the product record.

This dataset is for a client who is trying to set up production scheduling so I need to get this sorted.

Help!!

Parents
  • 0

    Hi Pamela,

    Thanks for using Sage City.

    There could be a few things which may be affecting this. If you go to file > maintenance > check data, are there any errors, warnings and comments relating to products and/or allocations?

    You can also try the recalculate stock and recalculate order allocations option within recovery tools, if you haven't already done so. 

    Kind regards,

    Sean,
    Sage UKI

Reply
  • 0

    Hi Pamela,

    Thanks for using Sage City.

    There could be a few things which may be affecting this. If you go to file > maintenance > check data, are there any errors, warnings and comments relating to products and/or allocations?

    You can also try the recalculate stock and recalculate order allocations option within recovery tools, if you haven't already done so. 

    Kind regards,

    Sean,
    Sage UKI

Children