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

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.
Related topics