4558 – Negative Stock resulting from Sage transactions

Version Reported In

Sicon Manufacturing v.221.0.47

Detailed Description

There are two known scenarios in Sage that can cause stock items to be in negative stock, despite not allowing negative stock on the Product Group. Although this is a Sage bug, this article aims to note the impact it can have on a Sicon Works Order.

• Scenario 1
  • A stock item is allocated to a Works Order and an internal issue is carried out. In the scenario where there is stock allocated to a Sicon Works Order, Sage allows an internal issue even if it takes the item into negative stock.
  • The stock item was a component line on a Sicon Works Order.
• Scenario 2
  • A stock item is allocated to a Works Order and a stock take is carried out. In the scenario where there is stock allocated to a Sicon Works Order, Sage allows the stock take to be completed even if it takes the item into negative stock.

• • The stock item was a subassembly component line on a Sicon Works Order.

Impact: Low

• Urgency | Ability to work not affected; sufficient workaround available.
• Impact | All users affected.

Workaround

The consequence and workaround of negative stock is the same for each scenario; for both scenarios stock levels will need to be adjusted to remove the stock shortfall.  Please contact your Sage Business Partner if assistance is required for this.

The following is not a workaround but aims to explain the implications negative stock has on the Sicon Works Order in each scenario and the mitigation measures required/in place to ensure negative stock is not impacted further by Sicon Works Order stock movements.

Scenario 1 – the component on the Works Order will need to be unallocated and can only be allocated in full once the stock levels have been adjusted to meet the demand, (e.g. remove negative stock balance).

Scenario 2 – where the component is a subassembly already allocated to the parent, this is treated as a component but will behave slightly different to scenario 1.  At the point of issuing, the works order line will automatically remove the allocation from the Works Order.  The line can only be allocated in full once the stock levels have been adjusted to meet the demand, (e.g. remove negative stock balance).

Alternatively, the subassembly could be created with the parent and therefore automatically pre-allocated as usual:

However, if it the item still in negative stock at the point of booking, the preallocation from the parent will be removed and the user warned of this.  Booked-in stock will instead be used to reduce the stock shortfall.

The line can only be allocated in full once the stock levels have been adjusted to meet the demand, (e.g. remove negative stock balance).

Development Priority Voting

Please let us know your development priority for this Known Issue by providing us with a star rating based on the below;

1. Not causing any problems – not a priority.
2. It’s annoying, but not causing too many problems – not a priority.
3. Would be nice to be fixed, but not essential – not a high priority.
4. It would be helpful to have this fixed – fairly high priority.
5. Really needs to be fixed as soon as possible – high priority.