Billing Code Stored Procedures to Modify

When creating a custom billing code method, these are the stored procedures that may be modified, depending on the type of SRO transaction you are using.

Stored Procedure	Contents
Material	exec @Severity = SSSFSCustomMatlRateSp @InTransType, @InSroNum, @InSroLine, @InSroOper, @InItem, @InCustNum, @InTransDate, @InQty, @InCurrCode, @InPricecode, @InBillCode, @InCost, @OutUnitPrice, OUTPUT, @Infobar OUTPUT
Labor	exec @Severity = SSSFSCustLaborRateSp @iTransType, @iSroNUm, @iSroLine, @iSroOper, @iBillCode, @iTransDate, @iPartnerId, @iWorkCode, @iUnitCost, @iHrsWorked, @iHrsBilled, @tUnitPrice OUTPUT, @Infobar OUTPUT
Miscellaneous	exec @Severity = SSSFSCustMiscRateSp @iTransType, @iSroNum, @iSroLine, @iSroOper, @iBillCode, @iTransDate, @iPartner, @iMiscCode, @iUnitCost, @iQty, @tUnitPrice OUTPUT, @Infobar OUTPUT

Stored Procedure

Contents

Material

exec @Severity = SSSFSCustomMatlRateSp 
@InTransType, 
@InSroNum, 
@InSroLine, 
@InSroOper, 
@InItem, 
@InCustNum, 
@InTransDate, 
@InQty, 
@InCurrCode, 
@InPricecode, 
@InBillCode, 
@InCost, 
@OutUnitPrice, OUTPUT, 
@Infobar OUTPUT

Labor

exec @Severity = SSSFSCustLaborRateSp 
@iTransType, 
@iSroNUm, 
@iSroLine,
@iSroOper, 
@iBillCode, 
@iTransDate, 
@iPartnerId, 
@iWorkCode, 
@iUnitCost, 
@iHrsWorked, 
@iHrsBilled, 
@tUnitPrice OUTPUT, 
@Infobar OUTPUT

Miscellaneous

exec @Severity = SSSFSCustMiscRateSp 
@iTransType, 
@iSroNum, 
@iSroLine, 
@iSroOper, 
@iBillCode, 
@iTransDate, 
@iPartner, 
@iMiscCode, 
@iUnitCost, 
@iQty, 
@tUnitPrice OUTPUT, 
@Infobar OUTPUT

When customizing the stored procedures, consider these notes:

A working knowledge of SQL is strongly recommended before you perform any modification of this type.
The stored procedure must exist or errors will occur.
To display an error message from the stored procedure, return a non-zero value as well as an error message in @Infobar.
Return a 0 from the stored procedure if the process completed successfully.