SAGE X3: POSTED NON STOCK SALES INVOICE - STOCK STILL ALLOCATED TO INVOICE

Question

Hi All, 
 Hope someone can assist guide on this. 
 
 A sales invoice was generated using a stock managed product. 
 The STOCK TRANSACTION flag on sales invoice was flagged to NO - so no stock transactions are triggered. 
 Looking at the tables (SINVOICE and SINVOICED) the stock management flags are set to no. 
 No stock journals generated when the invoices posted, perfect. 
 However, when running stock inquiries, the stock has been allocated to the sales invoice which was posted. The stock is being held by the sales invoice. 
 How do we de-allocate the stock from the sales invoice to sell?
 
 the stock is allocated on STOALL table but no transactions on STOJOU

I have run various utilities and it does not seem to deallocate the stock from the sales invoice. 
 Troubleshooting attempted: 
 
 FUNSTOR - Stock resync and control 
 FINSTOWIPW - Quantities entered and resync 
 FINLOCS - Location resync 
 FUNSYNCW - WIP resync 
 FUNDESALL - Deallocations

Phil K · Answer

Hi Stacey, 
 In the situation whereby the document references in a STOALL record do not exist in the STOCK or STOJOU tables, you have an orphan record and you can access and delete the record manually using the In Lines (GMAINT) function. This should be a rare condition due to a possible network interruption and/or power outage. 
 However, there is also a utility that you can launch from the Run Processes function as UTIVEN03, a purge allocation process. Try this first before the back end approach.

Sage X3

SAGE X3: POSTED NON STOCK SALES INVOICE - STOCK STILL ALLOCATED TO INVOICE

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING