BACHFRQ must be default for Sales Entry transactions. Using GP 2013. Here is the code for both Sales Entry and Invoice Entry:
DECLARE @RC int
DECLARE @I_vBACHNUMB char(15)
DECLARE @I_vBCHCOMNT char(60)
DECLARE @I_vSERIES int
DECLARE @I_vGLPOSTDT datetime
DECLARE @I_vBCHSOURC char(15)
DECLARE @I_vDOCAMT numeric(19,5)
DECLARE @I_vORIGIN int
DECLARE @I_vNUMOFTRX int
DECLARE @I_vCHEKBKID char(15)
DECLARE @I_vCNTRLTOT numeric(19,5)
DECLARE @I_vCNTRLTRX int
DECLARE @I_vPOSTTOGL smallint
DECLARE @I_vPmtMethod smallint
DECLARE @I_vEFTFileFormat smallint
DECLARE @I_vRequesterTrx smallint
DECLARE @I_vBRKDNALL tinyint
DECLARE @I_vUSERID char(15)
DECLARE @I_vBACHFREQ tinyint
DECLARE @I_vRECPSTGS smallint
DECLARE @I_vMSCBDINC smallint
DECLARE @I_vAPPROVL tinyint
DECLARE @I_vAPPRVLDT datetime
DECLARE @I_vAPRVLUSERID char(15)
DECLARE @I_vTRXSOURC char(25)
DECLARE @I_vUSRDEFND1 char(50)
DECLARE @I_vUSRDEFND2 char(50)
DECLARE @I_vUSRDEFND3 char(50)
DECLARE @I_vUSRDEFND4 varchar(8000)
DECLARE @I_vUSRDEFND5 varchar(8000)
DECLARE @O_iErrorState int
DECLARE @oErrString varchar(255)
SET @I_vBACHNUMB = 'IMAGINARY SALES'
SET @I_vBCHSOURC = 'Sales Entry '
--SET @I_vBACHNUMB = 'IMAGINE INVOICE'
--SET @I_vBCHSOURC = 'Invoice Entry '
SET @I_vBCHCOMNT = 'Imaginary Sales has been updated 2'
SET @I_vSERIES = 3
SET @I_vGLPOSTDT = ''
SET @I_vDOCAMT = 0
SET @I_vORIGIN = 1
SET @I_vNUMOFTRX = 0
SET @I_vCHEKBKID = ''
SET @I_vCNTRLTOT = 0.00000
SET @I_vCNTRLTRX = 0
SET @I_vPOSTTOGL = 0
SET @I_vPmtMethod = 0
SET @I_vEFTFileFormat = 0
SET @I_vRequesterTrx = 0
SET @I_vBRKDNALL = 0
SET @I_vUSERID = 'pdoucette'
--SET @I_vBACHFREQ = 1 --Must be default for Sales Entry. Un-comment for invoice batches
SET @I_vRECPSTGS = 0
SET @I_vMSCBDINC = 0
SET @I_vAPPROVL = 0
SET @I_vAPPRVLDT = ''
SET @I_vAPRVLUSERID = ''
SET @I_vTRXSOURC = ''
SET @I_vUSRDEFND1 = ''
SET @I_vUSRDEFND2 = ''
SET @I_vUSRDEFND3 = ''
SET @I_vUSRDEFND4 = ''
SET @I_vUSRDEFND5 = ''
EXECUTE @RC = [dbo].[taCreateUpdateBatchHeaderRcd]
@I_vBACHNUMB
,@I_vBCHCOMNT
,@I_vSERIES
,@I_vGLPOSTDT
,@I_vBCHSOURC
,@I_vDOCAMT
,@I_vORIGIN
,@I_vNUMOFTRX
,@I_vCHEKBKID
,@I_vCNTRLTOT
,@I_vCNTRLTRX
,@I_vPOSTTOGL
,@I_vPmtMethod
,@I_vEFTFileFormat
,@I_vRequesterTrx
,@I_vBRKDNALL
,@I_vUSERID
,@I_vBACHFREQ
,@I_vRECPSTGS
,@I_vMSCBDINC
,@I_vAPPROVL
,@I_vAPPRVLDT
,@I_vAPRVLUSERID
,@I_vTRXSOURC
,@I_vUSRDEFND1
,@I_vUSRDEFND2
,@I_vUSRDEFND3
,@I_vUSRDEFND4
,@I_vUSRDEFND5
,@O_iErrorState OUTPUT
,@oErrString OUTPUT
Select @RC, @O_iErrorState, @oErrString
--5385 Recurring batches are not allowed for the Batch Source type
Share
Report
110
All responses (
Answers (
