b1if add deposit service

[former_member542085]

Good morning experts,

I'm trying to add a deposit via Integration Framework, using XMLs, however there is no information on the parameter template.

What value can I use for Identifier

The keys values of the example are 123, should I use the same?

The documentation just shows the following message

[HuanYang]

Please try to use Deposit

[former_member542085]

I changed the inbound

And the processing atom

But the error remains the same

[HuanYang]

Could you please config the debug mode and specify what exact error you meet and in which phase？

[former_member542085]

Thanks for the reply, when I click debug message it shows me the following

[HuanYang]

Hello,

Please check the setting to 2 - Switch on Full Debugging and then try again.

Thanks & best regards

Huan Yang

[former_member542085]

I changed the debug mode to full

I click on the Debug, it takes me to a new window I choose the first one on the list since it is the XML that I tried to process.

It takes me to a new window..not to sure how to interpret it.

[former_member542085]

I'm uploading them again

Error

Inbound

Processing

[former_member390407]

Hi Alfredo,

1) To generate an XML template you can specify service identifier and service method and press "Generate Schema" button in your B1 service CALL atom. It generates the template inside your predecessor atom.

For Deposits template is the following:

<xsl:template name="B1if.schema.Deposit">
    <Deposit>
        <!--DB Table Name: -->
        <DepositNumber>long</DepositNumber>
        <AbsEntry>long</AbsEntry>
        <DepositType>string (dtChecks, dtCredit, dtCash, dtBOE)</DepositType>
        <DepositDate>date</DepositDate>
        <DepositCurrency>string</DepositCurrency>
        <DepositAccount>string</DepositAccount>
        <DepositorName>string</DepositorName>
        <Bank>string</Bank>
        <BankAccountNum>string</BankAccountNum>
        <BankBranch>string</BankBranch>
        <BankReference>string</BankReference>
        <JournalRemarks>string</JournalRemarks>
        <TotalLC>double</TotalLC>
        <TotalFC>double</TotalFC>
        <TotalSC>double</TotalSC>
        <AllocationAccount>string</AllocationAccount>
        <DocRate>double</DocRate>
        <TaxAccount>string</TaxAccount>
        <TaxAmount>double</TaxAmount>
        <CommissionAccount>string</CommissionAccount>
        <Commission>double</Commission>
        <CommissionDate>date</CommissionDate>
        <TaxCode>string</TaxCode>
        <DepositAccountType>string (datBankAccount, datBusinessPartner)</DepositAccountType>
        <ReconcileAfterDeposit>string (tNO, tYES)</ReconcileAfterDeposit>
        <VoucherAccount>string</VoucherAccount>
        <Series>long</Series>
        <Project>string</Project>
        <DistributionRule>string</DistributionRule>
        <DistributionRule2>string</DistributionRule2>
        <DistributionRule3>string</DistributionRule3>
        <DistributionRule4>string</DistributionRule4>
        <DistributionRule5>string</DistributionRule5>
        <CommissionCurrency>string</CommissionCurrency>
        <CommissionSC>double</CommissionSC>
        <CommissionFC>double</CommissionFC>
        <TaxAmountSC>double</TaxAmountSC>
        <TaxAmountFC>double</TaxAmountFC>
        <BPLID>long</BPLID>
        <CheckDepositType>string (cdtCashChecks, cdtPostdatedChecks)</CheckDepositType>
        <CheckLines>
            <CheckLine>
                <!--multiple such elements are allowed-->
                <CheckKey>long</CheckKey>
                <CheckNumber>long</CheckNumber>
                <Bank>string</Bank>
                <Branch>string</Branch>
                <CashCheck>string</CashCheck>
                <CheckDate>date</CheckDate>
                <Customer>string</Customer>
                <CheckAmount>double</CheckAmount>
                <Deposited>string (dtNo, dcAsCash, dtAsPostdated)</Deposited>
                <Transferred>string (tNO, tYES)</Transferred>
                <AccountNumber>string</AccountNumber>
                <CheckCurrency>string</CheckCurrency>
            </CheckLine>
        </CheckLines>
        <CreditLines>
            <CreditLine>
                <!--multiple such elements are allowed-->
                <AbsId>long</AbsId>
                <CreditCard>long</CreditCard>
                <VoucherNumber>string</VoucherNumber>
                <PaymentMethodCode>long</PaymentMethodCode>
                <PayDate>date</PayDate>
                <Deposited>string (tNO, tYES)</Deposited>
                <NumOfPayments>long</NumOfPayments>
                <Customer>string</Customer>
                <Reference>string</Reference>
                <Transferred>string (tNO, tYES)</Transferred>
                <Total>double</Total>
                <CreditCurrency>string</CreditCurrency>
            </CreditLine>
        </CreditLines>
        <BOELines>
            <BOELine>
                <!--multiple such elements are allowed-->
                <BOEKey>long</BOEKey>
                <BOENumber>long</BOENumber>
                <DueDate>date</DueDate>
                <Bank>string</Bank>
                <Branch>string</Branch>
                <AccountNumber>string</AccountNumber>
                <Amount>double</Amount>
                <BOEStatus>string (boes_Created, boes_Sent, boes_Deposited, boes_Paid, boes_Cancelled, boes_Closed, boes_Failed)</BOEStatus>
                <Transferred>string (tNO, tYES)</Transferred>
            </BOELine>
        </BOELines>
    </Deposit>
</xsl:template>

2) For your inbound channel "Flat File" and Identification method "B1 Logic" you don't need to input any identifiers (actually even can't). B1 Logic means that B1IF will scan the files and check if they have a valid DI Object or service XML inside. You need to specify an identifier when, for example, you have your Identification method "File name". Then you need to specify the name according to your FILO pattern.

From documentation:

> B1 Logic

> Incoming XML file, following the syntax of SAP Business One XML

3) You need to specify a request value in case if you need to retrieve, update or delete an object. For addition you can leave it blank.

From documentation:

>Key Values

>Enter the value of the request key field for which you want to get, update or delete data. For the add method leave the field empty, or enter #x.

[former_member542085]

Hi, thanks for the reply.

1. I generated successfully the XML template.

2. I tried with your recommended settings, but it seems that for the Inbound, it's necessary to specify the identifier.

I tried the following options:

• #
• #x
• 25 (since 25 represents a deposit on the SDK)

But I get the following error.

3. Just # gives an error, so I'm using #x

[former_member390407]

Hi Alfredo,

I can't see any pictures( Looks like you haven't attached the files.

[former_member542085]

I uploaded the images again

[former_member390407]

Hi Alfredo,

I guess points 1 and 3 are solved, let me know if you have any other questions regarding to them.

About point 2. Sorry for misleading below is the suitable part of documentation:

Identification Method = B1 Logic
The scenario step subscribes to the incoming file, if the file has XML format and follows the
/BOM/BO structure of the SAP Business One XML interface and the value of the element
/BOM/BO/AdmInfo/Object is equal to the string in the Identifier field. 

That looks like it fits for DI Objects and I am not sure if you can use it with XMLs for services. I would suggest to use identification method = RootTag or xPath instead, that is much more transparent I believe.