Versions Compared

Old Version 1

changes.mady.by.user Muhammad.Imran

Saved on

compared with

New Version 2

changes.mady.by.user Martin Hagman

Saved on

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

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

BalanceType
N 

Supported values:
PhysicalBalance

AvailableBalance


Default if element BalanceType
is left out completely is PhysicalBalance 

Panel
titleExample

 <?xml version="1.0" encoding="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