Empty ShipToCode/BillToCode?

[#1]

Hello,

I've the following problem:

I try to import orders using a file-adapter. This orders may have addresses that are not in the BP Master Data. This means, we have to empty the ShipToCode and/or BillToCode and write our address to the Address or Address2-field.

Inserting the values to the Address/Address2-fields works perfect, but do not know how to empty the ShipToCode/BillToCode. If the Reciever-Payload does not hold a value for this fields, the system always uses the defaulf value from the BP Master Data.

Best regards,

Thomas

[Former Member]

Hi Marcus,

my template looks similar to yours. My xsl-template doesn't contain a ShipToCode or BillToCode-Tag, but SBO always adds the business partners default BillTo/ShipTo-Code to the document.

Best Regards,

Thomas Kneidl

[marcus_schmalz2]

Hi Thomas,

I now tried my test message from my last reply on a B1 2007 database and there I could reproduce exactly the same behaviour as you described.

So this seems to be a functionality that was changed / fixed in B1 8.8 DI API.

As B1 8.8 is in unrestricted shipment now it would be the best to make an upgrade.

Kind regards,

Marcus

[marcus_schmalz2]

Hi Thomas,

if you use the tags <address> (BillTo) and <address2> (ShipTo) in your receiver payload, then it should work. (I tested it in B1 8.8)

For example the following code would generate a sales order with "Test" as ship to address and complete empty bill to address:

<BOM>
	<BO>
		<AdmInfo>
			<Object>17</Object>
			<Version>2</Version>
		</AdmInfo>
		<Documents>
			<row>
				<DocType>dDocument_Items</DocType>
				<DocDate>20100426</DocDate>
				<DocDueDate>20100426</DocDueDate>
				<CardCode>C20000</CardCode>
				<TaxDate>20100426</TaxDate>
				<Address> </Address>
				<Address2>Test</Address2>
			</row>
		</Documents>
		<Document_Lines>
			<row>
				<ItemCode>A00001</ItemCode>
				<Quantity>1</Quantity>
			</row>
		</Document_Lines>
	</BO>
</BOM>

As soon as you use these fields to owerwrite the default addresses, the corresponding BillToCode / ShipToCode are automatically empty.

Regards,

Marcus

[Former Member]

Hello Maria,

I want to tell SBO to use an empty value for ShipToCode. If my ShipToCode in the Reciever Payload is empty, SBO uses the Default Value instead of an empty value. My problem is, that I do not know, how to tell SBO to use an empty value for ShipToCode instead of the BP's default value.

Best Regards,

Thomas Kneidl

[Eneveux]

Thomas,

SAP Business One, on the Sales Order, requires a Ship To. It cannot be blank. The normal functionality of SAP Business One is to use the default in the Business Partner Master. You either have to use the default or supply a different Ship To. This is normal behavior within Business One. Since B1iSN uses the DI API to connect to SAP Business One, the DI API has the same default behavior as SAP Business One.

Eddy

[Former Member]

Hi Eddy,

but why does SBO enter a value for BillToCode if there is none in my Reciever-Payload?

Best Regards,

Thomas Kneidl

[Former Member]

Hello Maria,

that's my problem: At the beginning, we didn't have the ShipToCode in our Reciever-Payload. After we faced the problem with the default value, we tried to insert a ShipToCode with an empty value (space), but SBO always uses the default ShipToCode.

Best Regards,

Thomas Kneidl

[Trinidad]

Hi,

If you don't want the default value to be used then you will need to enter the value you need. I don't understand what is the problem here, sorry.

Regards

Trinidad.

[Former Member]

Hi Maria,

the scenario is working fine - except of this problem with emptying the ShipToCode. If there is an empty ShipToCode-Tag or one with only a space in my Reciever-Payload, SBO uses the default ShipToCode for the customer.

Best Regards,

Thomas

[Trinidad]

Hi Thomas,

You will need then to remove the ShipToCode tag in the Receiver xml from the xsl file and if it doesn't work and B1 stills use the default then you will need to specificaly set the ShipToCode to the specific value you want it to be.

Regards

Trinidad.

[Trinidad]

Hi Thomas,

You will need to work with the xsl file in order to replace the information in the Sender part when you create the receiver part.

You should have a look to the SDN blog at /people/yatsea.li/blog/2009/10/28/how-to-build-run-a-b12b1-scenario--biub1po2b1so-with-b1isn-2007 showing how to create a B12B1 scenario and showing how to create variables + how to obtain information from other objects in B1 that could contain the information.

Hope it helps

Trinidad.