ExternalBalance to Extend Commerce Backend

Description

This integration is used to update the product balance by the external system. The specification is illustrated as the number 5 below.

The integration supports comparison of two different type of balance.

The default is physical balance comparison. Physical balance in external warehouse is compared to physical balance in Extend Commerce Backend. This works well when the warehouse does not have any other order sources affecting the available balance, or if balance is synchronized on a night schedule where no open orders are allowed to exist over night (which might be hard to guarantee)

If the warehouse receives orders from other systems, or by manual orders, excel files or a like, it might be better to compare available balance.

The available balance in Extend Commerce Backend is calculated as physical balance - the balance reserved against the warehouse currently being compared. Incoming orders (not yet reserved) are not affecting the available balance in this scenario, since the external warehouse does not yet know about these orders, and as a result they are not yet affecting the available balance in the external warehouse. 

Specification

Balance, LXIRExternalBalance

XMLstructure

LxirEnvelope \Header(1)

Element       

Code

Mand.

Explanation

FromPartner
YFrom system
FromPartnerUser
YUser from system / Client
ToPartner
YTo system
ToPartnerUser
YUser of from system / Client
DocumentName
YDocument name
DocumentVersion
NVersion of a document
DocumentNumber
NDocument number
DateTime
NDocument create date (YY-MM-DD hh:mm)

 

LxirEnvelope \Body\ItemBalance (1-999)

Element       

Code

Mand.

Explanation

ProductNumber
NProduct number handled in Extend Commerce Backend
Warehouse
YWarehouse short name
Balance
YNew balance
Note
NNotes 
LogDate
NDate of update balance
CustomerProductNumber
N

Customer Product Number.

Can be used when external warehouse does not share the
same product identifier as the product 
number in Extend Commerce Backend.

BalanceType

Supported values:
PhysicalBalance

AvailableBalance


Default if element BalanceType
is left out completely is PhysicalBalance 


XSD files


Example

 <?xml version="1.0encoding="utf-8"?>

<LxirEnvelope>

  <Header FromPartner="anySimpleType" FromPartnerUser="anySimpleType" ToPartner="anySimpleType" ToPartnerUser="anySimpleType" DocumentName="LxirExternalBalance" DocumentVersion="DocumentVersion1" DocumentNumber="DocumentNumber1" DateTime="DateTime1" />

  <Body>

    <ItemBalance>

      <ProductNumber> 1511857</ProductNumber>

      <Warehouse> 2008200</Warehouse>

      <Balance>20</Balance>

      <Note>Note1</Note>

      <LogDate> 2016-08-08T12:12:12</LogDate>

     <CustomerProductNumber> 1511857</CustomerProductNumber>

     <BalanceType> PhysicalBalance</BalanceType>

    </ItemBalance>

    <ItemBalance>

      <ProductNumber> 1511858</ProductNumber>

      <Warehouse> 2008200</Warehouse>

      <Balance>25</Balance>

      <Note>Note1</Note>

      <LogDate> 2016-08-08T12:12:12</LogDate>

     <CustomerProductNumber> 1511857</CustomerProductNumber>

     <BalanceType> PhysicalBalance</BalanceType>

    </ItemBalance>

  </Body>

</LxirEnvelope>

Document version history

Version

Date

Author/change

Commenct

A

2016-09-19

Muhammad Jawad

Integration specification for LxirExternalBalance

1.02016-10-03Martin Fransson
1.12017-08-14Muhammad JawadChanged ProductNumber to non mandatory and also added the CustomerProductNumber field
 1.22020-06-02 Martin Hagman Added information on BalanceType