Jiwa

Hi,

With regards to the negative stock plugin, what is the purpose of the stored procedure usp_Negative_Stock_Sales_SalesTransfers?

I can't find it getting used anywhere.

Cheers

DannyC wrote:Hi,

With regards to the negative stock plugin, what is the purpose of the stored procedure usp_Negative_Stock_Sales_SalesTransfers?

I can't find it getting used anywhere.

Cheers

By looking at the signature, it is intended for a report as it follows a menu report convention for parameter naming:

Code: Select all

CREATE PROCEDURE usp_Negative_Stock_Sales_SalesTransfers @SP_StartInvoiceNo VARCHAR(50) = NULL, @SP_EndInvoiceNo VARCHAR(50) = NULL,
             @SP_StartInvoiceDate DATETIME = NULL, @SP_EndInvoiceDate DATETIME = NULL,
             @SP_StartDebtorAccountNo VARCHAR(50) = NULL, @SP_EndDebtorAccountNo VARCHAR(50) = NULL

We don't have a report which uses it - I'm assuming at some point it was wanted then someone changed their mind.

OK. Thx for the clarification.