Skip to Content

Bin Location In Stock Transfer

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 07, 2015 at 08:56 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Vibin Varghese

      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