Plus Community - for users of ACCPAC & Adagio accounting software

Welcome to the PlusCommunity forums! PlusCommunity is a gathering place for companies running Simply Accounting, ACCPAC Plus, Sage Accpac ERP (ACCPAC Advantage/ACCPAC for Windows), and Adagio Accounting.
New visitors, please click here!

Page 1 of 1 1
Topic Options
#53481 - 03/07/18 04:46 AM Importing «Receipt» data from external...
CNDDN
Member


Registered: 03/06/18
Posts: 2
Loc: Montréal, Canada
We have «Sage 300 ERP AccPac v2014».

We export IBM Notes data in XML to TransAcc module.

I must modify le doctype for actual data, they are considered as «Prepayment», and I must change doctype for «Receipt».

Here the sample of data:
Code:
<?xml version="1.0" encoding="ISO-8859-1"?>
<DataSet>
	<AR0041>
		<DATEBTCH>2018/03/06</DATEBTCH>
		<BATCHDESC>6 mars 2018 #003 (INTERAC)</BATCHDESC>
		<IDBANK>BNC02</IDBANK>
		<CODECURN>CAD</CODECURN>
		<AR0042>
			<CODEPYMTYP>CA</CODEPYMTYP>
			<CNTBTCH>1</CNTBTCH>
			<CNTITEM>1</CNTITEM>
			<IDRMIT>2018-00005</IDRMIT>
			<IDCUST>R18A04140443</IDCUST>
			<DATERMIT>2018-03-06</DATERMIT>
			<TEXTRMITREF>2018-00005</TEXTRMITREF>
			<AMTRMIT>1710</AMTRMIT>
			<CODEPAYM>INTERA</CODEPAYM>
			<RMITTYPE>1</RMITTYPE>
			<DOCTYPE>2</DOCTYPE>
			<IDINVCMTCH>2018-00008/2018-00004</IDINVCMTCH>
			<TEXTPAYOR>France Brien</TEXTPAYOR>
			<SWTXAMTCTL>1</SWTXAMTCTL>
			<AR0044>
				<CODEPAYM>CA</CODEPAYM>
				<CNTBTCH>1</CNTBTCH>
				<CNTITEM>1</CNTITEM>
				<CNTLINE>20</CNTLINE>
				<AMTPAYM>1710</AMTPAYM>
			</AR0044>
		</AR0042>
	</AR0041>
</DataSet>


We try :
Code:
<RMITTYPE>1</RMITTYPE>
<DOCTYPE>8</DOCTYPE>

and have this error :
Quote:
Header/IDINVCMTCH : 2018-00008/2018-00004
Error HRESULT E_FAIL has been returned from a call to a COM component.
Invalid input. Matching Document Number must be blank.


We try :
Code:
<RMITTYPE>1</RMITTYPE>
<DOCTYPE>8</DOCTYPE>
<IDINVCMTCH></IDINVCMTCH>

and have this error :
Quote:
DetailsApplied/AMTPAYM : 1710
Error HRESULT E_FAIL has been returned from a call to a COM component.
Invalid input. Document number cannot be blank.


What I must change?

Top
#53482 - 03/07/18 04:59 AM Re: Importing «Receipt» data from external... [Re: CNDDN]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7684
Loc: Location, Location
Remove <IDINVCMTCH>2018-00008/2018-00004</IDINVCMTCH>
_________________________
Jay Converse
Sage 300 Whisperer

Top
#53483 - 03/07/18 05:07 AM Re: Importing «Receipt» data from external... [Re: Jay Converse]
CNDDN
Member


Registered: 03/06/18
Posts: 2
Loc: Montréal, Canada
Error :
DetailsApplied/AMTPAYM : 1710
Error HRESULT E_FAIL has been returned from a call to a COM component.
Invalid input. Document number cannot be blank.

Top
#53484 - 03/07/18 05:08 AM Re: Importing «Receipt» data from external... [Re: CNDDN]
Jay Converse Administrator
Member


Registered: 07/31/00
Posts: 7684
Loc: Location, Location
Export an existing entry to XML and compare the differences.
_________________________
Jay Converse
Sage 300 Whisperer

Top
Page 1 of 1 1


Moderator:  Jay Converse 
Hop to: