Hi Richard,
If you are calling the stored procedures directly, you still need to follow the same order of the XML and the parameters still follows the same rules as the help CHM file.
taPMTransactionTaxInsert
taPMDistribution
taPMTransactionInsert
After you run your inserts the data should be in the PM00400, PM10000, and PM10100, unless the stored procedure returned an error. Here is an example of running it directly in SQL, you can tweak it as needed for your integration. If you need more in depth assistance on any of the fields or have further issues it may be best to address this through a support case so we can work with you directly.
SET NOCOUNT ON
BEGIN TRANSACTION
DECLARE @O_iErrorState INT,
@oErrString VARCHAR(255),
@oRptString VARCHAR(255)
/**taPMDistribution Debit**/
SET @O_iErrorState=0 -- Reset Errors
SET @oErrString=''
EXEC taPMDistribution
@I_vDOCTYPE='1',
@I_vVCHRNMBR='00000000000001001',
@I_vVENDORID='BEAUMONT0001',
@I_vDSTSQNUM='16384',
@I_vDISTTYPE='6',
@I_vCRDTAMNT='0',
@I_vDEBITAMT='500.00',
@I_vACTNUMST='000-1100-00',--or you can use ACTINDX
@O_iErrorState=@O_iErrorState OUT, @oErrString=@oErrString OUT
SELECT @oRptString = 'SELECT ErrorCode, SourceProc, ErrorDesc FROM DYN18C..taErrorCode WHERE ErrorCode IN (' + REPLACE(RTRIM('0'+@oErrString),CHAR(32), ',') + ')'
EXEC(@oRptString)
/**/
/**taPMDistribution Credit**/
SET @O_iErrorState=0 -- Reset Errors
SET @oErrString=''
EXEC taPMDistribution
@I_vDOCTYPE='1',
@I_vVCHRNMBR='00000000000001001',
@I_vVENDORID='BEAUMONT0001',
@I_vDSTSQNUM='32768',
@I_vDISTTYPE='2',
@I_vCRDTAMNT='500.00',
@I_vDEBITAMT='0.00',
@I_vACTNUMST='000-1101-00',--or you can use ACTINDX
@O_iErrorState=@O_iErrorState OUT, @oErrString=@oErrString OUT
SELECT @oRptString = 'SELECT ErrorCode, SourceProc, ErrorDesc FROM DYN18C..taErrorCode WHERE ErrorCode IN (' + REPLACE(RTRIM('0'+@oErrString),CHAR(32), ',') + ')'
EXEC(@oRptString)
/**/
---- taPMTransactionInsert
--====================================================================
/**/
SET @O_iErrorState=0 -- Reset Errors
SET @oErrString=''
EXEC taPMTransactionInsert
@I_vBACHNUMB='BATCHID', --new or existing
@I_vVCHNUMWK='00000000000001001',
@I_vVENDORID='BEAUMONT0001',
@I_vDOCNUMBR='TESTDOCNUMBER',
@I_vDOCTYPE='1',
@I_vDOCAMNT='500.00',
@I_vPYMTRMID= '',
@I_vDOCDATE='2017-02-10',
@I_vPSTGDATE='2017-02-10',
@I_vVADDCDPR='PRIMARY',
@I_vDUEDATE='2017-02-20',
@I_vPRCHAMNT='500.00',
@I_vCHRGAMNT='500.00',
@I_vTRXDSCRN='test',
@I_vSHIPMTHD='MAIL',
@I_vMDFUSRID='sa',
@I_vPOSTEDDT='2017-02-15',
@I_vPTDUSRID='sa',
@I_vCREATEDIST= 0,--must be 0 if you are passing in your own distributions
@O_iErrorState=@O_iErrorState OUT, @oErrString=@oErrString OUT
SELECT @oRptString = 'SELECT ErrorCode, SourceProc, ErrorDesc FROM DYN18C..taErrorCode WHERE ErrorCode IN (' + REPLACE(RTRIM('0'+@oErrString),CHAR(32), ',') + ')'
EXEC(@oRptString)
/**/
IF @O_iErrorState = 0
COMMIT TRANSACTION
ELSE
ROLLBACK TRANSACTION -- Simplifies re-testing
Thanks,
Isaac Olson
