Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...


Panel
titleDescription

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 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. 

Image RemovedImage Added


Panel
titleSpecification

Balance, LXIRExternalBalance

XMLstructure

Panel
titleLxirEnvelope \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)

 


Panel
titleLxirEnvelope \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
Extend product 
number in Extend Commerce Backend.

BalanceType

Supported values:
PhysicalBalance

AvailableBalance


Default if element BalanceType
is left out completely is PhysicalBalance 



XSD files

View file
nameLxirExternalBalance.xsd
height250
View file
nameBasicTypes.xsd
height250
View file
nameLxirEnvelope_1.2.xsd
height250


Panel
titleExample

 <?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>


...

Panel
titleDocument 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 


Include Page
Google Analytics
Google Analytics