Bin Location In Stock Transfer

[former_member458725]

Hi,

I have to set the bin location for From Whs and To Whs in B1if

<StockTransfer_Lines>

                        <xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role=&apos;C&apos; and ./@id=&apos;atom1&apos;]/jdbc:ResultSet/jdbc:Row">

                            <row>       

                                <ItemCode>

                                    <xsl:value-of select="jdbc:ITEMCODE/text()"></xsl:value-of>

                                </ItemCode>

                                <ItemDescription>

                                    <xsl:value-of select="jdbc:DESCRIPTION/text()"></xsl:value-of>

                                </ItemDescription>

                                <Quantity>

                                    <xsl:value-of select="jdbc:QUANTITY/text()"></xsl:value-of>

                                </Quantity>

                               <WarehouseCode>

                                    <xsl:value-of select="jdbc:TOWHSCODE/text()"></xsl:value-of>

                                </WarehouseCode>

                                <FromWarehouseCode>

                                    <xsl:value-of select="jdbc:FILLER/text()"></xsl:value-of>

                                </FromWarehouseCode>                               

                                <MeasureUnit>

                                Kgs

                                </MeasureUnit>

                            </row>

                        </xsl:for-each>

                    </StockTransfer_Lines>

This is the XML I generated for adding StockTransfer Line . But I dont have any idea about the Bin Location, How to set it. Please help.

Thank You.

[Former Member]

Hi Vibin

Check this thread:

In short: open any Call B1 object atom to edit. Once you have 'Edit ...' window opened click on 'Help' button; in new window click 'Object List' button; find your object on list and click 'Object template'.

Kind regards,

Radek

[former_member458725]

Hi,

Thank you for your reply. But in my help of B1 object Help > Object Template button is disabled. I dont know why. Can you please give me the exact <tag> for setting bin location for two Whs, It will be very help full.

Thank You

[Former Member]

Hi

Here the schema for Stock Transfer:

<?xml version="1.0" encoding="utf-8" ?>
<BOM>
  <!-- DB Table Name: OWTR  -->
  <BO>
    <!-- multiple such elements are allowed  -->
    <AdmInfo>
      <Object>long</Object>
      <Version>long</Version>
    </AdmInfo>
    <QueryParams>
      <DocEntry>string (db: DocEntry, Numeric(11))</DocEntry>
    </QueryParams>
    <StockTransfer>
      <row>
        <!-- multiple such elements are allowed  -->
        <Series>long (db: Series, Numeric(6))</Series>
        <Printed>string (db: Printed, Alpha(1))</Printed>
        <DocDate>string (db: DocDate, Date(8))</DocDate>
        <DueDate>string</DueDate>
        <CardCode>string (db: CardCode, Alpha(15))</CardCode>
        <CardName>string (db: CardName, Alpha(100))</CardName>
        <Address>string (db: Address, Alpha(254))</Address>
        <Reference1>string (db: Ref1, Alpha(11))</Reference1>
        <Reference2>string (db: Ref2, Alpha(11))</Reference2>
        <Comments>string (db: Comments, Alpha(254))</Comments>
        <JournalMemo>string (db: JrnlMemo, Alpha(50))</JournalMemo>
        <PriceList>long (db: GroupNum, Numeric(6))</PriceList>
        <SalesPersonCode>long (db: SlpCode, Numeric(6))</SalesPersonCode>
        <FromWarehouse>string (db: Filler, Alpha(8))</FromWarehouse>
        <ToWarehouse>string</ToWarehouse>
        <TaxDate>string (db: TaxDate, Date(8))</TaxDate>
        <ContactPerson>long (db: CntctCode, Numeric(11))</ContactPerson>
        <FolioPrefixString>string (db: FolioPref, Alpha(2))</FolioPrefixString>
        <FolioNumber>long (db: FolioNum, Numeric(11))</FolioNumber>
        <DocObjectCode>string (db: ObjType, Alpha(20))</DocObjectCode>
        <AuthorizationCode>string</AuthorizationCode>
        <StartDeliveryDate>string</StartDeliveryDate>
        <StartDeliveryTime>long</StartDeliveryTime>
        <EndDeliveryDate>string</EndDeliveryDate>
        <EndDeliveryTime>long</EndDeliveryTime>
        <VehiclePlate>string</VehiclePlate>
        <ATDocumentType>string</ATDocumentType>
        <EDocExportFormat>long</EDocExportFormat>
        <ElecCommStatus>string</ElecCommStatus>
      </row>
    </StockTransfer>
    <StockTransfer_ApprovalRequests>
      <row>
        <!-- multiple such elements are allowed  -->
        <Remarks>string</Remarks>
      </row>
    </StockTransfer_ApprovalRequests>
    <StockTransfer_Lines>
      <row>
        <!-- multiple such elements are allowed  -->
        <LineNum>long</LineNum>
        <ItemCode>string</ItemCode>
        <ItemDescription>string</ItemDescription>
        <Quantity>double</Quantity>
        <Price>double</Price>
        <Currency>string</Currency>
        <Rate>double</Rate>
        <DiscountPercent>double</DiscountPercent>
        <VendorNum>string</VendorNum>
        <SerialNumber>string</SerialNumber>
        <WarehouseCode>string</WarehouseCode>
        <FromWarehouseCode>string</FromWarehouseCode>
        <ProjectCode>string</ProjectCode>
        <Factor>double</Factor>
        <Factor2>double</Factor2>
        <Factor3>double</Factor3>
        <Factor4>double</Factor4>
        <DistributionRule>string</DistributionRule>
        <DistributionRule2>string</DistributionRule2>
        <DistributionRule3>string</DistributionRule3>
        <DistributionRule4>string</DistributionRule4>
        <DistributionRule5>string</DistributionRule5>
        <UseBaseUnits>string</UseBaseUnits>
        <MeasureUnit>string</MeasureUnit>
        <UnitsOfMeasurment>double</UnitsOfMeasurment>
        <BaseType>long</BaseType>
        <BaseLine>long</BaseLine>
        <BaseEntry>long</BaseEntry>
        <UnitPrice>double</UnitPrice>
        <UoMEntry>long</UoMEntry>
        <InventoryQuantity>double</InventoryQuantity>
      </row>
    </StockTransfer_Lines>
    <SerialNumbers>
      <row>
        <!-- multiple such elements are allowed  -->
        <ManufacturerSerialNumber>string</ManufacturerSerialNumber>
        <InternalSerialNumber>string</InternalSerialNumber>
        <ExpiryDate>string</ExpiryDate>
        <ManufactureDate>string</ManufactureDate>
        <ReceptionDate>string</ReceptionDate>
        <WarrantyStart>string</WarrantyStart>
        <WarrantyEnd>string</WarrantyEnd>
        <Location>string</Location>
        <Notes>string</Notes>
        <BatchID>string</BatchID>
        <SystemSerialNumber>long</SystemSerialNumber>
        <BaseLineNumber>long</BaseLineNumber>
        <Quantity>double</Quantity>
      </row>
    </SerialNumbers>
    <BatchNumbers>
      <row>
        <!-- multiple such elements are allowed  -->
        <BatchNumber>string</BatchNumber>
        <ManufacturerSerialNumber>string</ManufacturerSerialNumber>
        <InternalSerialNumber>string</InternalSerialNumber>
        <ExpiryDate>string</ExpiryDate>
        <ManufacturingDate>string</ManufacturingDate>
        <AddmisionDate>string</AddmisionDate>
        <Location>string</Location>
        <Notes>string</Notes>
        <Quantity>double</Quantity>
        <BaseLineNumber>long</BaseLineNumber>
      </row>
    </BatchNumbers>
    <StockTransferLinesBinAllocations>
      <row>
        <!-- multiple such elements are allowed  -->
        <BinAbsEntry>long</BinAbsEntry>
        <Quantity>double</Quantity>
        <AllowNegativeQuantity>string</AllowNegativeQuantity>
        <SerialAndBatchNumbersBaseLine>long</SerialAndBatchNumbersBaseLine>
        <BinActionType>long</BinActionType>
        <BaseLineNumber>long</BaseLineNumber>
      </row>
    </StockTransferLinesBinAllocations>
    <StockTransfer_TaxExtension>
      <row>
        <!-- multiple such elements are allowed  -->
        <SupportVAT>string</SupportVAT>
        <FormNumber>string</FormNumber>
        <TransactionCategory>string</TransactionCategory>
      </row>
    </StockTransfer_TaxExtension>
  </BO>
</BOM>

Kind regards,

Radek