on 04-07-2016 6:19 AM
Background:
Our MDM system send BusinessPartners with BPAddresses to B1 via EDI and I do mapping in the xsl style sheet in B1iSN.
And I also need to map “FederalTaxID”(MDM system sends this element under the BusinessPartners) to <BPFiscalTaxID>/<TaxId0>.
Question1:
I checked the note 1145532 - How to import tax information under BP Master Data,
I found that there is always an extra address line(Address Name is empty and Address Type=’B’) in the CRD7 table and seems only the Ship-To address have the value of TaxId0, do you know why?
Question2:
My intension is that, to copy all information we needs for <BPFiscalTaxID> from BPAddress and add a dummy line into <BPFiscalTaxID> which align with the CRD7 table.
And only map the TaxId0 to all “Ship-To” address. I am not sure if this approach is correct or not.
Hi Jim,
Are you trying to Add a BP Master record using DI API ???
Regards,
Ravi.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
More Input:
SAP Business One 9.1 PL08
First, let me show you a query result which comes from CRD1 and CRD7 table after I created a new BP with P.A.N. No.(TaxId0) on the B1 screen at the first time.
Question 1, I don’t why but there is always an additional line with empty “Address” on the top of the CRD7 table. what is it used for?
Issue, It works when I insert a new BP at the first time by this way, however, the problem now is that it doesn’t work if I update (add a new address) on an existing BP by using the xml interface of B1 this way. As a result, B1iSN got DI Error: (-223) Deleting rows not supported for object Fiscal IDs for BP Master Data
The out put after the XSLT like this below(DI API, using xml interface of B1)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
unfortunately I have tried everything, but nothing's worked. B1iSN still get below response error if you intend to add an address for a business partner with existing addresses(Add New Data and Update Existing Data)
"com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.bizprocessor.BizProcException: BPE001 Nested exception: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: com.sap.b1i.xcellerator.XcelleratorException: XCE001 Nested exception: java.lang.RuntimeException: DI Error: (-223) Deleting rows not supported for object Fiscal IDs for BP Master Data"
Seems it is a bug of DI API, Anybody know about this, Shall I post a message to SAP?
I haven't received any feedback from SCN yet, now body knows about this?
let's make my question easy to understand,
according to the query result from the CRD7 table after I created a new BP with TaxId0 on the B1 screen , there is always an additional line with empty address name in the top of the CRD7 table, so my question is that, do I need to prepare a dummy line accordingly in the DTW template? and what is the top line in the CRD7 table it used for?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.