• RELEVANCY SCORE 4.51

    DB:4.51:How Can I Upload Multiple Customer Invoice Request Xml At One Time p1





    HI,

    My company always deal with textile company so ultimately i have multiple customer request at a time .

    i had generated customer invoice XML each every time for multiple document id and upload one by one .

    Can i edit in XML and made one XML for upload.

    how can i upload multiple customer invoice request XML at one time.

    please help us.

  • RELEVANCY SCORE 4.26

    DB:4.26:How To Upload Bulk Customer Invoices In File Input dj





    Hi

    Currently i am working on uploading customer invoice request xml file in File Input under Application and user management workcenter and its successfully creates Invoice request in Customer Invoicing--Invoice request. But the issue is its only allows me to create uppermost Invoice entry from xml. When i process one xml with one customer invoice request then it works fine but when i add multiple customer invoice requests nodes then it creates invoice of very first node. How can i create multiple invoice requests in one go using single xml file.

    DB:4.26:How To Upload Bulk Customer Invoices In File Input dj


    Hi Kornelia,

    Thanks you, My requirement is like i have xml file and that i upload to unprocessed file under Application and user management--file input. But here i upload single file at a time. But i haven't used file input from SDK. And for processing multiple files i have mapped web dav to my local machine and i also checked from there if i add multiple xml file then it process them one by one. but it gives error while connecting sometime.

    I think you are talking about file input from SDK.

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Get Customer Invoice Creation Data To Approve 1f





    Hi all

    i am creating customer invoice through t-code FB70.

    Generally we will get Document Number at last through transaction level.

    i want to approve invoice based on amount , So please guide me how to get customer invoice details into workflow. and the initiator park the invoice.

    The multiple approvers are approved based on amount.

    Regards

    Mahesh

    DB:3.09:How To Get Customer Invoice Creation Data To Approve 1f


    Hello,

    Make sure the event trace (SWEL) is turned on (via SWELS) then create the invoice and see if any events are created. If so, you can use them to start a workflow and pass values to them. Inside the workflow you can direct the workflow depending on the amount.

    If no event is created you will have to find a user exit where you can call fm SAP_WAPI_CREATE_EVENT, or you can try changing the settings in SWEC to cause an event to be created.

    regards

    Rick Bakker / hanabi technology

  • RELEVANCY SCORE 3.08

    DB:3.08:Send Invoice (Copies) To Multiple Email Address fj



    Hi,

    Is it possible to send invoice(copies) to multiple email address? how?

    Understand that we can maintain multiple email add for a customer. Example if 5 email add has been maintained for customer A, let say if I need to email 1 original invoice to email add 1 and email the other 2 copies invoice to email add 2 amp; 3 , how do I select the email add 1, 2 amp; 3 from the customer under the OUTPUT of change invoice (VF02) when we only input the customer code under Partner?

    Appreciate your inputs on the above.

    DB:3.08:Send Invoice (Copies) To Multiple Email Address fj


    Hi Sarosh,

    Thanks for your response.

    The email is to be sent to multiple email ids maintained in Customer Master.

    Regards

    Kiran

  • RELEVANCY SCORE 3.04

    DB:3.04:Etl On Normalized Structure f9


    Hello,

    Greetings! It is an interesting forum and I got interesting answers to my postings. I like to thank every body.

    We are using OWB 9.2.0.2.8. We are in a situation to build ETL from denormalized (relational tables) source to normalized target (relational tables). It is not a data warehouse situation. It could be a reverse of data warehouse. As given below

    Customer ---------- Invoice--------------Invoice Items

    We are using separate sequence number for Customer, Invoice and Invoice Items. The sequences will be surrogate keys such as
    Customer ( Custseq(PK)), Invoice (Custseq||Invseq (PK)) and Invoice Items (Custseq||Invseq||InvItemseq (PK))

    Did any body face such situation? What is the best way to create a mapping (single map or multiple map with processflow sequence) for this situation?

    Let me know the steps exercised in OWB for this situation.

    Thanks in advance

    Ram

    DB:3.04:Etl On Normalized Structure f9

    Hi Nikolai,

    Greetings! Thanks for your reply. I was able to do mapping. I will be testing with process flow. Let you know the situation.

    I sent you an email about XML, 10g and OWB. Did you receive it?

    I appreciate your help.

    Regards

    Ram

  • RELEVANCY SCORE 2.99

    DB:2.99:Creating Multiple Spools 1k


    Hi All,One Spool is generated for multiple customers in F.27How to split the spool request per customer so that i can generate separate PDF for each customer.

    DB:2.99:Creating Multiple Spools 1k

    Sanity check - - Used BTE 2310. Importing:I_BKORM (like BKORM)Changing C_ITCPO (like ITCPO)Code:FUNCTION ZSAMPLE_PROCESS_00002310.*"----""Local interface:*" IMPORTING*" REFERENCE(I_BKORM) LIKE BKORM STRUCTURE BKORM*" CHANGING*" REFERENCE(C_ITCPO) LIKE ITCPO STRUCTURE ITCPO*"----*This process will create separate spool requests for each vendor which is submitted for processing.In this case, separate spools are requested only for one company code.IF i_bkorm-bukrs = 'XXXX'.c_itcpo-tdnewid = 'X'.ENDIF.ENDFUNCTION.

  • RELEVANCY SCORE 2.98

    DB:2.98:Single Billing Item Requiring More Than One Billing Accounting Document fz



    Hello All,

    We have the need to create more than one customer invoice (billing accounting document) for a single billing line item.

    Require the following:

    Customer Invoice for the product

    Customer Invoice for the VAT (on product)

    On the billing document the billing line item will include the VAT on the product, but require a Product invoice in USD currency and VAT (on product) invoice in GBP currency.

    As have these different invoice currency requirements therefore need separate customer invoices (billing accounting documents) for these elements.

    I'm guessing I'll need some development within the SD-FI accounting interface to get this split of a single billing item into multiple customer invoices (billing accounting documents).

    Can any of you please help?. I cannot find any information anywhere else to help with this issue.

    Thanks very much in advance,

    Michael

    DB:2.98:Single Billing Item Requiring More Than One Billing Accounting Document fz


    We have a requirement where we want to post to finance to the customer's account two entries, one for the net value of the invoice and a separate entry for the VAT amount. The reason is that the customer splits the payments and this would help with the matching of the incoming payments.

    Wht would be the best/standard way to do this.

    Regards

  • RELEVANCY SCORE 2.95

    DB:2.95:Invoice Correction Request px



    Whats this invoice correction request (RK)??....

    DB:2.95:Invoice Correction Request px


    Hi Santosh,

    Take it easy. I have seen people posting job openings at SDN forums. Let us 'honestly" welcome new members.

    This was a general open-ended question and I quoted (better way to say copied) SAP to give an answer. I can not explain better then SAP.

    Comming back to the topic, Invoice Correction Request is "unique" to SAP and is quite useful but I have not seen it in use. Normally I have seen people using a combination of Credit memo request, Debit Memo request, Sales Return and New Sales order to achieve what can be done by this single document. So if some body shows interest in it, it interests me.

    In a sequence to General Question - General Answer often there are specific questions and answer.

    Morale of the story : "Take it Easy".

    Cheers.

    Ashish

  • RELEVANCY SCORE 2.94

    DB:2.94:Customer Invoice fs



    Hi All,

    What is a customer invoice? and do FI people create the customer invoice? and in which scenario?

    Regards,

    Danny.

    DB:2.94:Customer Invoice fs


    Hi Danny,

    As you know, the usual sales cycle starts from sales order, delivery and billing. During Billing you create an invoice for the customer for the goods delivered by you. In SD ,transaction VF01 is used to create an invoice.

    As soon as the invoice is created an accounting document is generated where the amount will hit the G/L accounts created by FI personnel.

    90 % of the invoices are created by FI personnel.

    Transaction FB70 is used by FI ppl to create invoice.

    In short,

    VF01 = SD Billing.

    FB70 = FI Billing.

  • RELEVANCY SCORE 2.93

    DB:2.93:Changing Of Field Data For Customer Invoice c8



    Hi sap guru's

    I need to change terms of payment field in the customer invoice, which already been posted.

    through change document can post but need to change bulk invoices.

    is there any possiblility to mass upload the terms of payment on to the invoices

    if there, how?

    Thanks in advance

    venu

    DB:2.93:Changing Of Field Data For Customer Invoice c8


    Hi,

    Check this -

    Go to FD10N - Customer Line item display

    Select all the documents for which payment terms has to be updated

    Goto Environment Mass Change New Values

    Give the payment terms

    I couldn't try and confirm. Pls. assign points, if useful

    Regards,

    Sridevi

    Message was edited by:

    Sridevi

  • RELEVANCY SCORE 2.90

    DB:2.90:Account Type/Account For Invoice Refrence Does Not Match Item sm



    Hi all,

    I am trying to fix a problem for a customer.

    They have created an invoice, and based on that invoice they have created a debit memo request and subsiquently a manual invoice.

    The sold-to/payer are different on the original invoice and on the debit memo request.

    Is that why I am getting the error when i try to release the manual invoice to accounting?

    What do i do to rectify the problem now that the manual invoice has already been sent out?

    Thx

    RM

    DB:2.90:Account Type/Account For Invoice Refrence Does Not Match Item sm


    Dear RM,

    I'm glad you found the solution. Since I'm dealing with the same error here, I'd really like to know what you have done to solve the problem. Can you help me out?

    Thanks in advance.

    Adriano Cardoso

  • RELEVANCY SCORE 2.87

    DB:2.87:Convert Multiple Delivery Into Single Invoice 8d



    Hi all,

    Kindly give solution to the below scenerio:

    The delivery is created each time the material is being send to the customer, But the customer requires a single invoice for all the delivery at the end of each month. How to address the scenerio.

    With regards,

    Afzal

    DB:2.87:Convert Multiple Delivery Into Single Invoice 8d


    Hai Afzal.

    Adding to the replies given, you may also consider invoice list.

    Here you create the invoice at the time of delivery and at the end of the month create an invoice list, which is a consolidation of the required individual invoices.

    In the billing node of customizing you will find the invoice list customization.

    Regards,

    Tajudeen S.

  • RELEVANCY SCORE 2.85

    DB:2.85:Invoice With Multiple Payment Options kz



    I have tried but it appears I cannot create an invoice with multiple payment options. I offer different subscription levels and have the need to send an invoice that gives the customer the option of selecting just one. Is there any way to do this. If not this would be something to work on.

    DB:2.85:Invoice With Multiple Payment Options kz


    Unfortunately with the standard invoice using Payments Standard, there are no features or options available to do what you have in mind.

    You may be able to do what you have in mind using a web page but, not thru the standard invoice.

    Another way to submit suggestions or changes is to use the Site Feedback link from within your PayPay Account. The link is on every page. There's a survey question to answer and text box below. Use the text box to submit your suggestion or change. Seems they do have folks that look at the submissions verses posting via the community forum. With the exception the the moderators, everyone here is a non paid volunteer.

  • RELEVANCY SCORE 2.84

    DB:2.84:How To Print Multiple Invoices In Smartform pz



    How to print multiple customer invoices on different pages in smartform, Invoice range is given by selection screen of driver program,

    In my case i have to go back and press print preview button to display next invoice.

    My requirement is next invoice will display on next page by pressing next page button.

    DB:2.84:How To Print Multiple Invoices In Smartform pz


    Hi Mandar ,

    I guess you can do this by using Standard Tcode VF31.

    Give a try to it.

  • RELEVANCY SCORE 2.83

    DB:2.83:Upload Multiple Files px


    Hello !

    Is there any possibility to upload multiple files (let's say
    a FileReferenceList) to a server making a single request ?
    I am asking this because I do not want to use
    FileReference.upload(request) method, as it can only be applied to
    a single file at once, and multiple calls will result in multiple
    requests.

    Thank you in advance !

    DB:2.83:Upload Multiple Files px

    Hello !

    Is there any possibility to upload multiple files (let's say
    a FileReferenceList) to a server making a single request ?
    I am asking this because I do not want to use
    FileReference.upload(request) method, as it can only be applied to
    a single file at once, and multiple calls will result in multiple
    requests.

    Thank you in advance !

  • RELEVANCY SCORE 2.82

    DB:2.82:Single Payment Receipts Against Multipule Customer Invoices 1x



    Hi All,

    I need your help to slove this business senario, here i have one payment receipts i need to clear against multiple customer invoice, how to clear the single payment receipt for multiple customer invocies,

    But customer will not infore which invoice should be clear first. system will pick automatically and clear invoices as per First in first out method.

    how i process this soultion.

    thanks

    Kiran

    DB:2.82:Single Payment Receipts Against Multipule Customer Invoices 1x


    Hi Akash,

    Can you explain me what are the seps and how can i proced with that.

    thanks

    Kiran

  • RELEVANCY SCORE 2.81

    DB:2.81:Issue Request fp


    Hello,
    I have a request and I have just met a problem.
    In my concrete case I have to post the amount of an invoice.
    Only this amount has to be the one of the last invoice of the customer.
    Is it possible thanks to a request to find the last invoice of the customer?

    DB:2.81:Issue Request fp


    Hi Pookiz,

    I suggest you to take use of Row_Number function to retrieve the data group by customer and descending sort the data inner group,
    please refer to the T-sql below:

    select
    * from

    (SELECT
    ROW_NUMBER()
    OVER (PARTITION
    BY C.NumClient
    ORDER BY ECS.DateFacturation
    DESC)
    AS ID,C.NumClient,ECS.DateFacturation,ECS.PrixUnitaire

    FROM
    Ecriture_CA_Sage AS ECS
    INNER JOIN

    Propositions_Commerciales AS PC
    INNER JOIN

    Clients AS C INNER
    JOIN

    Factures_Clients_Lignes AS FCL
    INNER JOIN

    Abonnements_Lignes AS AL
    ON FCL.NumLigne = AL.NumLigne
    ON C.NumClient
    = AL.NumClient ON PC.NomClient
    = C.NomClient
    ON

    ECS.Numfacture = FCL.NumFacture

    )as result

    where ID=1

    Thanks,

    Bill Lu
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

  • RELEVANCY SCORE 2.78

    DB:2.78:Manual Bank Reconsilation az



    Dear Experts,

    I am doing manual bank reconsilation and have following questions:

    1. I want to clear incoming payments by customer as mentioned in bank statement directly with customer open item as recorded at time of billing. How to enable this direct clearing happen?

    2. What algorithm/clearing i should use so that correct clearing should happen. Example: Their may be multiple invoice of same amount say 10000 euro. And now if bank statement has 10000 euro, it should clear with correct bill. What creterion of clearing can be used for this? and what algorithm of sap?

    Request Revert. Thanks....

    DB:2.78:Manual Bank Reconsilation az


    Dear Experts,

    I am doing manual bank reconsilation and have following questions:

    1. I want to clear incoming payments by customer as mentioned in bank statement directly with customer open item as recorded at time of billing. How to enable this direct clearing happen?

    2. What algorithm/clearing i should use so that correct clearing should happen. Example: Their may be multiple invoice of same amount say 10000 euro. And now if bank statement has 10000 euro, it should clear with correct bill. What creterion of clearing can be used for this? and what algorithm of sap?

    Request Revert. Thanks....

  • RELEVANCY SCORE 2.78

    DB:2.78:Reabte Accruals 7p



    Hello,

    in a rebate scenario, when we raise an invoice, the rebate conditons are included in the invoice. so if the invoice value is Rs 100, the customer rebate for example is Rs 2 in the invoice.

    so the accounting entry generated will be to debit the customer by Rs 100 and credit to customer accrual account by Rs 2/-

    when we settle the rebates, the credit memo request is issued and then a credit memo. through credit memo the customer account is credit by Rs 2 and the customer accural account is reversed.

    my question is, in case of manual accruals, why the system is issuing a credit memo request and then a credit memo. becasue by issueing a credit memo, we are giving a credit to customer account (not accrual account) whereas in actual we are just doing an accrual like we are doing accurals when we are raising the invoice

    regards

    sachin

    DB:2.78:Reabte Accruals 7p


    Hello,

    in a rebate scenario, when we raise an invoice, the rebate conditons are included in the invoice. so if the invoice value is Rs 100, the customer rebate for example is Rs 2 in the invoice.

    so the accounting entry generated will be to debit the customer by Rs 100 and credit to customer accrual account by Rs 2/-

    when we settle the rebates, the credit memo request is issued and then a credit memo. through credit memo the customer account is credit by Rs 2 and the customer accural account is reversed.

    my question is, in case of manual accruals, why the system is issuing a credit memo request and then a credit memo. becasue by issueing a credit memo, we are giving a credit to customer account (not accrual account) whereas in actual we are just doing an accrual like we are doing accurals when we are raising the invoice

    regards

    sachin

  • RELEVANCY SCORE 2.78

    DB:2.78:Missing Ordered Qty In Ar Invoice s8


    Hi allWith reference to SAP Support Message 306166, Qty Ordered is always blank in AR Invoice transaction when a single AR Invoice is copied from two Delivery Orders whether or not there is partial delivery. Please help to feedback to your development team for this poor limitation as we observed there is no such limitation when multiple Sales Order is copied to Delivery Order. This information is important when Customer Print AR Invoice together as Delivery Orders on Pre-printed Forms that combine AR Invoice and Delivery Order with carbon copies to block price information.Kedalene Chong

    DB:2.78:Missing Ordered Qty In Ar Invoice s8

    u can try out this querySELECT T0.Quantity FROM [dbo].[RDR1] T0, [dbo].[DLN1] T1 WHERE T1.BaseEntry = T0.DocEntry and T1.DocEntry = $[$38.45]Sagar

  • RELEVANCY SCORE 2.78

    DB:2.78:Update Field In Subform2 Based On Checkbox In Subform1 fz


    I have a main form frmCollections
    It displays Customer Name, Customer ID and Customer COmments,
    Subform 1 displays all the invoices attached to customer.
    subform 2 displays invoice comments and collections info per invoice
    I need to copy comments from one invoice to other invoices under the same customer.
    Say I called customer and spoked to them about invoice 2, 4, 6, I want to write a comment in 2 and copy it to 4 and 6

    subform 1 has checkbox with each invoice, I want to copy the comments in the subform to the invoies with a true checkbox
    how do i do this... I have tried multiple ways and fail.. this is the only thing holding back being finished

    Thanks for any help
    Rascal

    DB:2.78:Update Field In Subform2 Based On Checkbox In Subform1 fz

    You didn't show us what you have tried. Sounds like you might be having trouble referring to the Subforms. Have a look at...
    http://access.mvps.org/access/forms/frm0031.htm

  • RELEVANCY SCORE 2.78

    DB:2.78:Upload Excise Duties ?? c1


    Dear All, I want to upload excise for depot. As we have to pass on duties to customer as per the incoming excise invoice. Please tell me how can I upload initial incoming excise details (base value, mother challan number, duty value) Thanks in advance.

    DB:2.78:Upload Excise Duties ?? c1

    refer this alsohttp://help.sap.com/bp_bblibrary/470/Documentation/J33_BPP_32_CHEM_EN_IN.doc

  • RELEVANCY SCORE 2.78

    DB:2.78:Customer Invoice In Crm To Vendor Invoice In Ecc. 9s



    HI ,

    I have question we have in our business scenario, customer performs service activity say repairing a Lap top, customer uses his own service person (labor) to perform that repair work for that Lap top and raises invoice on company .

    Here customer acts as Business partner to company in CRM .(Sold to Party)

    Here my question is how this customer invoice replicates in ECC as Vendor invoice.

    Is it possible to replicate Customer invoice in CRM to vendor invoice in ECC ?

    We need this as vendor invoice in ECC , so that finance person can pay him as Account payable in ECC.

    Is there any customization required for this to post as vendor invoice in ECC.

    I request you to help me in this regard. Many thanks in advance.

    Kind Regards,

    Sankar Reddy

    DB:2.78:Customer Invoice In Crm To Vendor Invoice In Ecc. 9s


    HI ,

    I have question we have in our business scenario, customer performs service activity say repairing a Lap top, customer uses his own service person (labor) to perform that repair work for that Lap top and raises invoice on company .

    Here customer acts as Business partner to company in CRM .(Sold to Party)

    Here my question is how this customer invoice replicates in ECC as Vendor invoice.

    Is it possible to replicate Customer invoice in CRM to vendor invoice in ECC ?

    We need this as vendor invoice in ECC , so that finance person can pay him as Account payable in ECC.

    Is there any customization required for this to post as vendor invoice in ECC.

    I request you to help me in this regard. Many thanks in advance.

    Kind Regards,

    Sankar Reddy

  • RELEVANCY SCORE 2.77

    DB:2.77:Vf31 Print Invoices In Multiple Spool 7s



    Hello, Experts!

    I have a problem in spool when executing the Tcode VF31.

    I found that when Edit-Printer default- 'Print immediately' is ticked, It is creating multiple spool request for multiple invoices.

    And when the attribute is unticked, the invoices will in one spool request.

    In my requirement, one spool request should be created for one invoice without print immediately. Please help me in this!?

    Many thanks!

    Regards,

    May.

    DB:2.77:Vf31 Print Invoices In Multiple Spool 7s


    Thanks for all your reply. The problem was solved.

    The enhancement need to be added into Processing Program of Output Type as below screenshot.

    1. Find out the processing program. (T-code: NACE or Table: TNAPR)

    2. Add implicit enhancement at the end of processing

    program RLB_INVOICE-FORM SET_PRINT_PARAM

    IF (condition)

    cs_composer_param-tddest = ls_constant-zz_con_value." Output Device cs_composer_param-tdnewid = lc_x. " New Spool Request cs_composer_param-tdimmed = space. " Print immediately cannot be set cs_composer_param-tddelete = lc_x. " Delete after print cs_composer_param-tdcopies = space. " Number of copies|single.

    ENDIF.

  • RELEVANCY SCORE 2.76

    DB:2.76:Xml/Bi Publisher - Invoice Total In Multiple Page Multiple Invoice Document pp


    Hi Gurus,

    Requirement is
    1. Single PDF file having multiple invoices for a customer
    2. Any invoice within above document can be multiple page invoice.
    3. I need to show Total of every invoice at the end of invoice (not document, as document can have multiple invoice).

    Can you please help.

    Thanks in advance for your time.
    Sunil

    Edited by: user12165963 on Oct 7, 2012 5:36 AM

    DB:2.76:Xml/Bi Publisher - Invoice Total In Multiple Page Multiple Invoice Document pp

    Under for-each-group: use sum(current-group()/XML_TAG) to get the invoice total per supplier.

    Cheers,
    ND
    Use the "helpful" or "correct" buttons to award points to replies / Mark the thread as answered, if your question is answered.

  • RELEVANCY SCORE 2.76

    DB:2.76:Customer Invoice Upload Tool - Can't Get Extension Fields To Populate xx



    In the documentation for the customer invoice upload documentation, it says to get the tag for your extension field in the Customer Invoice XML Output. No issues there. But when I add the extension field to the XML for the Customer Invoice Request Service Interface, the field never populates in the generated invoice request. Note that I cannot create a new XML Upload Service interface as a workaround because this is a 3.5 customer system

    The extension fields are in a different namespace from the Request Service Interface, so I've tried the two methods below to populate my Advertiser extension field. I've had no luck with either. Here's some sample XML from the beginning of the file. The files are also attached. Any help is appreciated.

    [ I also posted on the SCN where I attached the test files.|http://scn.sap.com/thread/3237936]

    Method 1

    ?xml version="1.0"?

    CustomerInvoiceRequestRequest

    MessageHeader

    CreationDateTime/

    /MessageHeader

    CustomerInvoiceRequest actionCode="04" reconciliationPeriodCounterValue="1"

    BaseBusinessTransactionDocumentIDEXT_100001_TALINV/BaseBusinessTransactionDocumentID

    BaseBusinessTransactionDocumentTypeCode29/BaseBusinessTransactionDocumentTypeCode

    ProposedInvoiceDate2012-09-16/ProposedInvoiceDate

    Namehhhc/Name

    ReferenceBusinessTransactionDocumentID100001/ReferenceBusinessTransactionDocumentID

    Advertiser xmlns="http://sap.com/xi/AP/CustomerExtension/BYD/A03DP"

    EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002JUDSON/EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002

    /Advertiser

    BusinessProcessVariantType

    BusinessProcessVariantTypeCode1/BusinessProcessVariantTypeCode

    MainIndicatortrue/MainIndicator

    /BusinessProcessVariantType

    Method 2

    ?xml version="1.0"?

    CustomerInvoiceRequestRequest

    MessageHeader

    CreationDateTime/

    /MessageHeader

    CustomerInvoiceRequest actionCode="04" reconciliationPeriodCounterValue="1"

    BaseBusinessTransactionDocumentIDEXT_100002_TALINV/BaseBusinessTransactionDocumentID

    BaseBusinessTransactionDocumentTypeCode29/BaseBusinessTransactionDocumentTypeCode

    ProposedInvoiceDate2012-09-16/ProposedInvoiceDate

    Namehhhc/Name

    ReferenceBusinessTransactionDocumentID100002/ReferenceBusinessTransactionDocumentID

    n1:EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002 xmlns:n1="http://sap.com/xi/AP/CustomerExtension/BYD/A03DP"JUDSON/n1:EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002

    BusinessProcessVariantType

    BusinessProcessVariantTypeCode1/BusinessProcessVariantTypeCode

    MainIndicatortrue/MainIndicator

    /BusinessProcessVariantType

    DB:2.76:Customer Invoice Upload Tool - Can't Get Extension Fields To Populate xx


    In the documentation for the customer invoice upload documentation, it says to get the tag for your extension field in the Customer Invoice XML Output. No issues there. But when I add the extension field to the XML for the Customer Invoice Request Service Interface, the field never populates in the generated invoice request. Note that I cannot create a new XML Upload Service interface as a workaround because this is a 3.5 customer system

    The extension fields are in a different namespace from the Request Service Interface, so I've tried the two methods below to populate my Advertiser extension field. I've had no luck with either. Here's some sample XML from the beginning of the file. The files are also attached. Any help is appreciated.

    [ I also posted on the SCN where I attached the test files.|http://scn.sap.com/thread/3237936]

    Method 1

    ?xml version="1.0"?

    CustomerInvoiceRequestRequest

    MessageHeader

    CreationDateTime/

    /MessageHeader

    CustomerInvoiceRequest actionCode="04" reconciliationPeriodCounterValue="1"

    BaseBusinessTransactionDocumentIDEXT_100001_TALINV/BaseBusinessTransactionDocumentID

    BaseBusinessTransactionDocumentTypeCode29/BaseBusinessTransactionDocumentTypeCode

    ProposedInvoiceDate2012-09-16/ProposedInvoiceDate

    Namehhhc/Name

    ReferenceBusinessTransactionDocumentID100001/ReferenceBusinessTransactionDocumentID

    Advertiser xmlns="http://sap.com/xi/AP/CustomerExtension/BYD/A03DP"

    EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002JUDSON/EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002

    /Advertiser

    BusinessProcessVariantType

    BusinessProcessVariantTypeCode1/BusinessProcessVariantTypeCode

    MainIndicatortrue/MainIndicator

    /BusinessProcessVariantType

    Method 2

    ?xml version="1.0"?

    CustomerInvoiceRequestRequest

    MessageHeader

    CreationDateTime/

    /MessageHeader

    CustomerInvoiceRequest actionCode="04" reconciliationPeriodCounterValue="1"

    BaseBusinessTransactionDocumentIDEXT_100002_TALINV/BaseBusinessTransactionDocumentID

    BaseBusinessTransactionDocumentTypeCode29/BaseBusinessTransactionDocumentTypeCode

    ProposedInvoiceDate2012-09-16/ProposedInvoiceDate

    Namehhhc/Name

    ReferenceBusinessTransactionDocumentID100002/ReferenceBusinessTransactionDocumentID

    n1:EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002 xmlns:n1="http://sap.com/xi/AP/CustomerExtension/BYD/A03DP"JUDSON/n1:EXTAdvertiser00163E027E021ED1BFDF09124EFF4876_002

    BusinessProcessVariantType

    BusinessProcessVariantTypeCode1/BusinessProcessVariantTypeCode

    MainIndicatortrue/MainIndicator

    /BusinessProcessVariantType

  • RELEVANCY SCORE 2.76

    DB:2.76:Problem Raising An Invoice 1z



    I've been trying to request a small amount of money from a customer.

    I keep getting "Money request - Group".

    is there a problem at the moment?

    (It turns out the customer gave me an incorrect email address!)

    DB:2.76:Problem Raising An Invoice 1z


    I've been trying to request a small amount of money from a customer.

    I keep getting "Money request - Group".

    is there a problem at the moment?

    (It turns out the customer gave me an incorrect email address!)

  • RELEVANCY SCORE 2.76

    DB:2.76:Crystal Xi R2 Export To .Csv ac



    I have written a Crystal XI R2 SP6 report that looks like this when previewed or printed:

    Invoice # Invoice Amount Partner 1 Partner 1 %

    Invoice # Partner 2 Partner 2 %

    Invoice # Partner 3 Partner 3 %

    Invoice # Partner 4 Partner 4 %

    Invoice # Invoice Amount Partner 1 Partner 1 %

    Invoice # Partner 2 Partner 2 %

    etc, with a maximum of 4 partners per invoice, each on a separate detail line and suppressed if the Partner code is empty using a formula but not actually ticking the Suppress box. The incoming record is the invoice broken into separate G/L accounts, so multiple records per invoice, and then joined to the customer table, where the partnership information comes from. I reduce this to one record selected per invoice in the same formula with if Invoice = Previous(Invoice).

    When I export to a .csv file it looks like this:

    Invoice# Invoice Amount Partner 1 Partner 1 % Partner 2 Partner 2 % Partner 3 Partner 3 % Partner 4 Partner 4 % (This is all on one line although it may not appear that way here)

    How can I have the .csv export look like the printed or previewed report? I do realise that I can export it as an .xls file and then save it as a .csv file using Excel, which works perfectly but is not a long term solution for a daily operation in a business.

    Thanks for any help you can offer.

    DB:2.76:Crystal Xi R2 Export To .Csv ac


    p.p.s. sorry but i noticed that you are currently using xi r2...this is a feature in cr2008 and above.

    however, if you want to try it out you can download a copy of cr 2013 as a trial from here.

    if you want to attach your report to this discussion (save it as .txt instead of .rpt first) then i can have a look at it to see if the xslt works for the format you want.

    apologies,

    jamie

  • RELEVANCY SCORE 2.75

    DB:2.75:Quote Process x8



    How does a customer pay by credit card an invoice that was converted from a request for quote? We need to allow someone to submit a quote, then business process it into an invoice, then send it back to the customer for recurring payment.

    DB:2.75:Quote Process x8


    I believe that this article will be of help to you http://kb.worldsecuresystems.com/180/bc_1806.html#main_Modifying_Invoice_Email_to_pass_val ues_to_your_online_payment_form

  • RELEVANCY SCORE 2.75

    DB:2.75:Invoice z1



    HI

    I have a customer who had ordered for an item and on his request the order is sent to his preferred Customer

    Now i need to raise invoice against the ordered customer. I have done a delivery to the reffed customer.Now if i raise and invoice against the ordered customer than my instock is getting affected which it shud not.

    DB:2.75:Invoice z1


    Hi jeyakanthan,

    i tried exactly as what you suggested, but when i make ainvoice, do i select the ordered customer or the preferred/???? coz when i updated th bpi.e. by going to accounting tab delivery consolidation bp, if i select this bp, then it doesnt show any delivery when i use the copy from option!! can you please tell me wht am i doin wrong??

    thanks

  • RELEVANCY SCORE 2.75

    DB:2.75:Multiple Invoices For A Delivery x1


    Hi, I need to generate multiple invoices for a delivery, once for the customer and one for the inter-company invoice and one for the vendor (we get a commission for every sale). Can you invoice a delivery document more than once? Thanks,Ken

    DB:2.75:Multiple Invoices For A Delivery x1

    The following SAP Help link can clearly answer you query and can be helpful for your understanding/reference :- Working with Intercompany BillingRegards, JP.

  • RELEVANCY SCORE 2.75

    DB:2.75:Add Or Import Multiple Customer Details To Invoice Add Contacts cp



    can you import new contacts from excel ?

    DB:2.75:Add Or Import Multiple Customer Details To Invoice Add Contacts cp


    Hello captec,

    Welcome to the Forums.

    Unfortunately there is not a way to import customer details andadd contacts even though that would be a great feature, I can certainly put a feature request in for you.

    Misty

  • RELEVANCY SCORE 2.75

    DB:2.75:Correspondence Printing - Language Problem jp



    Hi all,

    I am using the following Tcodes to generate customer invoice:

    *FB12 - Request

    F.64 - Maintain*

    The problem is my invoice generated is in German language.

    What I want is invoice in English ...

    Now problem can be solved when I went to change the customer general data communication language to English.

    The question is, is it the right way to change the general data level communication tab language section to english, as this customer might deal with other company code which the language that want to generate invoice in language not in english.

    KIndly advise.

    DB:2.75:Correspondence Printing - Language Problem jp


    Hi all,

    I am using the following Tcodes to generate customer invoice:

    *FB12 - Request

    F.64 - Maintain*

    The problem is my invoice generated is in German language.

    What I want is invoice in English ...

    Now problem can be solved when I went to change the customer general data communication language to English.

    The question is, is it the right way to change the general data level communication tab language section to english, as this customer might deal with other company code which the language that want to generate invoice in language not in english.

    KIndly advise.

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Group Multiple Sales Orders Into Single Invoice Using Auto Invoice? p1


    Hi,

    I have a requirement, say, multiple sales orders belong to same customer with same PO, should be grouped to create a single invoice for all SOs. Appreciate your quick help on this?

    Thanks in advance.

    Regards,
    Ram

    DB:2.74:How To Group Multiple Sales Orders Into Single Invoice Using Auto Invoice? p1

    You may use Auto invoice grouping rule and accordingly run your auto invoice program with customer name and other required parameters.

    Hope this will help you.
    Regards

    Edited by: saroj.dash on Dec 21, 2012 2:15 AM

  • RELEVANCY SCORE 2.74

    DB:2.74:Automatic Clearing Of Customer Invoice zs


    how to configure automatic clearing of customer invoice against payments received.

    DB:2.74:Automatic Clearing Of Customer Invoice zs

    Hello,Create a rule in the OB74, whether you want to clear the customer invoice based on XFER (Reference) or ZUONR (Assignment). Then on a periodic basis, like monthly once you can run the transaction F.13 to clear the customer invoices against the payment automatically.Can you see the test run result and the run it in live mode.Hope this will help your requirment.Raja.A

  • RELEVANCY SCORE 2.74

    DB:2.74:Invoice 97



    Hi,

    Does anyone know how can i attach multiple invoices to a Customer?

    thanks

    DB:2.74:Invoice 97


    VF04 - Maintain Billing due list, In this transaction

    first screen you can specify customer.

    When you execute this transaction it will list all the

    documents due for billing. You can select the multiple lines and using collective billing document button, You

    can create one invoice for multiple documents. Hope this helps.

    thanks,

    vamshi tallada

  • RELEVANCY SCORE 2.73

    DB:2.73:Create Multiple Invoice Templates With Different Logos? zf



    i have two invoice templates.

    the logo on invoice template #1 also appears on invoice template #2

    if i then upload a different logo to invoice template #2, then the new logo now also appears on invoice template #1

    can i have two different logos for the two different templates?

    it's annoying to have to change the logo every time i want to send an invoice using template #2.

    DB:2.73:Create Multiple Invoice Templates With Different Logos? zf


    i have two invoice templates.

    the logo on invoice template #1 also appears on invoice template #2

    if i then upload a different logo to invoice template #2, then the new logo now also appears on invoice template #1

    can i have two different logos for the two different templates?

    it's annoying to have to change the logo every time i want to send an invoice using template #2.

  • RELEVANCY SCORE 2.73

    DB:2.73:Excise Invoice Printing For Rate Difference ap



    Ref : CIN

    Business Scenario :-

    We are have to Prepare the Excise invoice for the price difference (rate difference) we are have to charge the Excise duty Tax to the customer.

    Here we are preparing the debit memo request then preparing the Invoice with reference to Debit memo. But here we are unable to prepare the Excise Invoice through J1iin as delivery is not involved it. Therefore for updating the excise records we are a entering through J1IH.

    But due to this we are unable to print the excise invoice on the preprinted Excise invoice stationary Our customer requires the Excise Invoice.

    Also the document flow is not been generated user are facing lot of problem.

    This is business critical scenario for us we have to charge the price difference to the customer.

    You are requested to give the solution to the above scenario.

    Transaction code used

    VA01 VF01 J1IH

    Regards

    Umesh Bagul

    DB:2.73:Excise Invoice Printing For Rate Difference ap


    Hi,

    I understand ur scenario and same we too also the requirement. But in SAP system will not support to create Excise Invoice other than the billing catory M U. In those price differece scenarios, create ur own order related billing type with billing category as M and maintain copy controls in CIN wilth delivery type as blank and billing type as ur new billing type. If u do these settings system allow to create the EI or if you want to create EI through standard debit note functionality then you require to change the source code.

    Regards

    Goutham

  • RELEVANCY SCORE 2.73

    DB:2.73:Interest On Customer Item Excluding Service Tax 8k



    Hi,

    When i run customer interest calculation(FINT) system calculates interest on invoice + service tax amount but i want to calculate interest on only invoice amount excluding service tax.

    Request immediate help.

    Thanks in advance.

    DB:2.73:Interest On Customer Item Excluding Service Tax 8k


    Hi,

    When i run customer interest calculation(FINT) system calculates interest on invoice + service tax amount but i want to calculate interest on only invoice amount excluding service tax.

    Request immediate help.

    Thanks in advance.

  • RELEVANCY SCORE 2.72

    DB:2.72:Multiple Delivered-To-Party For A Single Invoice-To-Party 8c


    Is there a option to have multiple delivered-to-party for a single invoice-to-party in customer account

    DB:2.72:Multiple Delivered-To-Party For A Single Invoice-To-Party 8c

    Hi Tharaka,In general, the Customer Master will be :For a Given Sold to Party, we can have1. Multiple Bill to Parties2. Multiple Payers3. Multiple Ship to Parties.You can maintain these in Customer master using XD02/VD02 (Just enter the partner type and enter the new partner number, like that you can do any number of chip to bill to or payers)In the above scenario, Sold to Party is the main customer and he can ask to send Bill to any of his other organizations, and can ask us to collect payment from any of his other offices and also can send material to his customers (Ship to parties)When you create a Sales Order, when you enter the sold to party, if multiple payer/bill to party/ship to parties are there, then it will ask you to choose the appropriate one for this sales order.All the above scenario is for multiple partners for one Sold to party (In SAP Sold to party is the main customer).If you want this option at Bill to party level, then need to write a custom development in Sales order user exit and then pick the relevant ship to parties for one bill to party. Please reemeber, this code is not so easy, as the Bill to party can be changed at any point of time in the sales order.Hope this clarieis.RegardsRaju

  • RELEVANCY SCORE 2.72

    DB:2.72:Create Item Ar Invoice To Service Ar Credit Memo k3


    Hi Expert,Customer is running 2007A PL30. We understanding that it is impossible to copy Item AR Invoice to service AR credit memo. It is customer business practice to issue same AR invoice to all customer for same item and later issue service AR credit memo to customer. Customer wants the item information to be copied to service AR credit memo rather than keying multiple rows to indicate discount given on which items. It is not possible to include discount at original AR invoice.Any workaround or solution to solve this problem?RegardsThomas

    DB:2.72:Create Item Ar Invoice To Service Ar Credit Memo k3

    Hi Eshvanth,Thanks for your reply. I can only select One Service Type Invoice on the Document Draw Wizard after checking on Customization. However, the intention is to Copy From more than One Service Type A/R Invoices. Understand that if it is Item Type A/R Invoices, I am able to perform that but not in Service Type.Unless there is a limitation from Singapore Localization Set-up. Hope you are able to advise me from here. Thanks.Regards,Vincent Chew

  • RELEVANCY SCORE 2.71

    DB:2.71:Send Invoice To Multiple User Via Email. jj


    Hi,We are using the output type external send. But the standard PO process will send email to only 1 recipient. The email will be taken from the customer master where email is flagged as Standard.Is there any other way (or any user exit) to send invoice to a multiple recipient (TO and COPY-TO) maintained in customer master? Appreciate your input.Thanks

    DB:2.71:Send Invoice To Multiple User Via Email. jj

    Dear Kiran,if want to send E-mail you need email server.because our sap send within sap login people but not send outof sap users.if you maintaine email server and that server you assign sap system mean when you maintain condition select there email and like PO MN04.then this server automatically will direct the emails to recevershope this will helps youPrem

  • RELEVANCY SCORE 2.71

    DB:2.71:Restrict Multiple Proforma Invoice From Order z7



    Hello All,

    Our customer wants to restrict multiple proforma invoice from sales order.I have written a logic in copy requirement routine.Its working when there is already created invoice from order .But if i try to create invoice first time from order then system doesn't allow me to create invoice and giving message "No billing document were generated ".

    Could anybody help.

    Regards,

    Sachin

    DB:2.71:Restrict Multiple Proforma Invoice From Order z7


    Hi,

    Restrict multiple Proforma invoices

    Thanks regards.

  • RELEVANCY SCORE 2.71

    DB:2.71:Help Creating One Invoice For Deliveries From Multiple Plants z1



    HI I have a customer needing one invoice. The sales order is created in one plant, but delivered via multiple plants. The salesorder triggers an intercompany invoice from the mothercompany to the selling company. This intercomapny invoice is a multiple invoice created from the delivering plants. Based on the above information, how do i create one invoice to the end customer? Br Jakob

    DB:2.71:Help Creating One Invoice For Deliveries From Multiple Plants z1


    Hi Jakob,

    use same payer/bill to party for such cases, system can create a single invoice for the customer (whether ship to party is diffrent as seems in your case)

    thanks

    Sandeep Singh

  • RELEVANCY SCORE 2.71

    DB:2.71:Single Invoice From Multiple Orders And Deliveries f1



    HI Experts !!!!

    Is there any possibility to create single invoice from

    multiple orders and deliveries also for the same customer .

    is there any standard configurations existed......

    If so plz guide me in the above scenario

    Regards,

    Balu

    DB:2.71:Single Invoice From Multiple Orders And Deliveries f1


    Search the forum. You will get ton of inputs from there. This topic was discussed many times.

    thanks

    G. Lakshmipathi

  • RELEVANCY SCORE 2.71

    DB:2.71:Is Any One Know Which Invoicing Software Or App Will Work With Mac I Do Have Must Haves On The Invoice xk


    INVOICE software MUST HAVES for me. I need to have an option that on end of the INVOICE MY CUSTOMERS WILL SEE ADGING RECORD (I HAVE SOME CUSTOMERS WHO pays once in 3 month, but want me to bill them regularly)Subtotal balances for each Invoice (if the customer has multiple jobs/Invoices with my company) I need to have something like different folders per customer/company, that they will have continues Invoice numbers throughout the year that belongs Only to them (to make it easy to track for both parties) I have to have Date collumn to indicate when job was completed (I need to put multiply dates and projects on one invoice)Unpaid balance report / sheets per customer.Can I apply different Discounts per Item in one invoice - but my customer will see all the numbers?

    DB:2.71:Is Any One Know Which Invoicing Software Or App Will Work With Mac I Do Have Must Haves On The Invoice xk

    INVOICE software MUST HAVES for me. I need to have an option that on end of the INVOICE MY CUSTOMERS WILL SEE ADGING RECORD (I HAVE SOME CUSTOMERS WHO pays once in 3 month, but want me to bill them regularly)Subtotal balances for each Invoice (if the customer has multiple jobs/Invoices with my company) I need to have something like different folders per customer/company, that they will have continues Invoice numbers throughout the year that belongs Only to them (to make it easy to track for both parties) I have to have Date collumn to indicate when job was completed (I need to put multiply dates and projects on one invoice)Unpaid balance report / sheets per customer.Can I apply different Discounts per Item in one invoice - but my customer will see all the numbers?

  • RELEVANCY SCORE 2.71

    DB:2.71:How To Upload More Than One Email Id Record For A Customer In Lsmw kx



    Hi

    I have to upload more than one e mail id record for a customer and there are many such cases.

    The issue is after the upload is done it shows only the last email id record for a given customer.

    Like if i have uploaded email id no. 1, 2, 3 4 for a customer it shows only the last one ie email id no. 4 in the customer master.

    How can i upload multiple email ID records for a customer.

    Kindly help.

    Regards

    Atul

    DB:2.71:How To Upload More Than One Email Id Record For A Customer In Lsmw kx


    Tried with adding multiple email id in recording and it is working fine.

    Thank you guyz.

  • RELEVANCY SCORE 2.71

    DB:2.71:Execution Of Script Failed. Reload Old Data ?? 1z



    Get this error when trying to load multiple years data from QVD. Have ensured only one column unique between tables and it creates Syn Keys.

    Script is

    LOAD %AccountKey, Account_Active_, Account_Code, [Account Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Account.qvd](qvd);

    LOAD %CCKey, CostCenter_Active_, Cost_Center, [Cost Center Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\CostCenters.qvd](qvd);

    LOAD %CustomerKey, Customer, Bill_TO, [customer class], [Credit Hold], [Credit Limit], [Credit Terms], [Customer Region], [Customer Remarks], Cust_Site, Sales_person, Taxable, [Customer Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Customer.qvd](qvd);

    LOAD %EntityKey, Entity_, Entity_DescriptionFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Entity.qvd](qvd);

    LOAD [Location Name], [GL Account Code], %AccountKey, [Transaction Amount], %CCKey, [Transaction Description], [GL Document], [GL Document Type], [GL Effective Date], [Invoice Month], [Invoice Year], %EntityKey, [GL Transaction Line], [GL Project Code], [GL Reference], %SubAccountKey, [GL Transaction Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\GL_Trans.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Invoice Comment Index], [Invoice Comment], [Invoice Discount Percentage], [Invoice Discount Account], [Invoice Discount Project], [Invoice Discount SubAccount], [Invoice Due Date], Invoice_Number, [Invoice Line], [Invoice Sales Order], %ItemKey, [Invoice Partial OK], [Invoice Performance Date], [Invoice Pick Date], [Invoice Unit Price], [Invoice Product Line], %ProdLineKey, [Invoice Project Code], [Invoice Promise Date], [Invoice Quantity Invoiced], [Invoice Quantity Ordered], [Invoice Quantity Pending], [Invoice Performance Qty], [Invoice Quantity Pick], [Invoice Quantity Quoted], [Invoice Quantity Shipped], [Invoice Request Date], [Invoice Serial Number], [Invoice Ship To], %SiteKey, %SalespersonKey, [Invoice Status], %SubAccountKey, [Invoice Line Taxable], [Invoice Line Type], [Invoice Line Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Details.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Invoice Comment Index], [Invoice Comment], [Invoice Discount Percentage], [Invoice Discount Account], [Invoice Discount Project], [Invoice Discount SubAccount], [Invoice Due Date], Invoice_Number, [Invoice Line], [Invoice Sales Order], %ItemKey, [Invoice Partial OK], [Invoice Performance Date], [Invoice Pick Date], [Invoice Unit Price], [Invoice Product Line], %ProdLineKey, [Invoice Project Code], [Invoice Promise Date], [Invoice Quantity Invoiced], [Invoice Quantity Ordered], [Invoice Quantity Pending], [Invoice Performance Qty], [Invoice Quantity Pick], [Invoice Quantity Quoted], [Invoice Quantity Shipped], [Invoice Request Date], [Invoice Serial Number], [Invoice Ship To], %SiteKey, %SalespersonKey, [Invoice Status], %SubAccountKey, [Invoice Line Taxable], [Invoice Line Type], [Invoice Line Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Detailslimtd.qvd](qvd);

    LOAD [Location Name], [Invoice Bill To], [Invoice Header Channel], [Invoice Header Comment Index], [Invoice Header Credit Terms], %CustomerKey, [Invoice Header Due Date], [Invoice Date], [Invoice Month], [Invoice Year], Invoice_Number, [Invoice Header Sales Order], [Invoice Header Ordered Date], [Invoice Header Partial OK], [Invoice Header Purchase Order], [Invoice Header Project Code], [Invoice Header Sales Quote], [Invoice Header Request Date], [Invoice Header Remarks], [Invoice Header Ship Date], %SiteKey, %SalespersonKey, [Invoice Taxable], [Invoice Trailer1 Amount], [Invoice Trailer1], [Invoice Trailer2 Amount], [Invoice Trailer2], [Invoice Trailer3 Amount], [Invoice Trailer3], [Invoice Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Headerlimtd.qvd](qvd);

    LOAD %ItemKey, [ABC Code], [BOM Code], [Item Description1], [Item Description2], [Item Group], Item_, [Item Type], [Item Price], Item_Product_Line, [Item Site_], [Item Status], [Item Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Items.qvd](qvd);

    LOAD %ProdLineKey, Product_Line, [ProductLine Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Prod_Line.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Sales Detail Comment Index], [Sales Detail Comment], [Sales Detail Confirmed], [Sales Detail Item Description], [Sales Detail Discount Account], [Sales Detail Discount CostCenter], [Sales Detail Discount Project], [Sales Detail Discount SubAccount], [Sales Detail Due Date], [Sales Detail Expire Date], [Sales Detail Invoice Number], [Sales Detail Order Line], [Sales Detail List Price], [Sales Detail Modified Date], Sales_Order, %ItemKey, [Sales Detail Partial], [Sales Detail Performance Date], [Sales Detail Pick date], [SOD Price List], [Sales Detail Unit Price], [Sales Detail Product_Line], %ProdLineKey, [Sales Detail Project_Code], [Sales Detail Promise Date], [Sales Detail Qty Allocated], [Sales Detail Qty To Ship], [Sales Detail Qty Invoiced], [Sales Detail Qty Ordered], [Sales Detail Qty Shipped], [Sales Detail Ship To], %SiteKey, %SalesPersonKey, [Sales Detail Cost], %SubAccountKey, [Sales Detail Ship Type], [Sales Unit Of Measure], [Sales Detail Ext Price]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_Details.qvd](qvd);

    LOAD [Location Name], [Sales Order Bill TO], [Sales Order Channel], [Sales Head Comment Index], %CustomerKey, [Sales Order Due Date], [Sales Order Invoice Date], [Sales Order Invoice Number], [Sales Order Invoiced], Sales_Order, [Sales Order Order date], [Order Year], [Order Month], [Sales Order Partial OK], [SO Purchase Order], [SO Price List], [Sales Order Project], [Sales Quote], [Sales Order Request Date], [Sales Order Revision], [Sales Order Remarks], [Sales Header Ship To], [Sales Order Ship Date], %SiteKey, %SalesPersonKey, [Sales Trailer 1], [Sales Trailer 1 Amount], [Sales Trailer 2 Amount], [Sales Trailer 2], [Sales Trailer 3 Amount], [Sales Trailer 3], TypeFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_Header.qvd](qvd);

    LOAD %SalesPersonKey, Sales_Person, [Sales Person Name]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_persons.qvd](qvd);

    LOAD %SiteKey, [Site Description], Site_FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sites.qvd](qvd);

    LOAD %SubAccountKey, [Sub_Account Description], Sub_AccountFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sub_Accounts.qvd](qvd);

    Appreciate any input on what is wrong with the above script

    DB:2.71:Execution Of Script Failed. Reload Old Data ?? 1z


    Get this error when trying to load multiple years data from QVD. Have ensured only one column unique between tables and it creates Syn Keys.

    Script is

    LOAD %AccountKey, Account_Active_, Account_Code, [Account Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Account.qvd](qvd);

    LOAD %CCKey, CostCenter_Active_, Cost_Center, [Cost Center Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\CostCenters.qvd](qvd);

    LOAD %CustomerKey, Customer, Bill_TO, [customer class], [Credit Hold], [Credit Limit], [Credit Terms], [Customer Region], [Customer Remarks], Cust_Site, Sales_person, Taxable, [Customer Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Customer.qvd](qvd);

    LOAD %EntityKey, Entity_, Entity_DescriptionFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Entity.qvd](qvd);

    LOAD [Location Name], [GL Account Code], %AccountKey, [Transaction Amount], %CCKey, [Transaction Description], [GL Document], [GL Document Type], [GL Effective Date], [Invoice Month], [Invoice Year], %EntityKey, [GL Transaction Line], [GL Project Code], [GL Reference], %SubAccountKey, [GL Transaction Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\GL_Trans.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Invoice Comment Index], [Invoice Comment], [Invoice Discount Percentage], [Invoice Discount Account], [Invoice Discount Project], [Invoice Discount SubAccount], [Invoice Due Date], Invoice_Number, [Invoice Line], [Invoice Sales Order], %ItemKey, [Invoice Partial OK], [Invoice Performance Date], [Invoice Pick Date], [Invoice Unit Price], [Invoice Product Line], %ProdLineKey, [Invoice Project Code], [Invoice Promise Date], [Invoice Quantity Invoiced], [Invoice Quantity Ordered], [Invoice Quantity Pending], [Invoice Performance Qty], [Invoice Quantity Pick], [Invoice Quantity Quoted], [Invoice Quantity Shipped], [Invoice Request Date], [Invoice Serial Number], [Invoice Ship To], %SiteKey, %SalespersonKey, [Invoice Status], %SubAccountKey, [Invoice Line Taxable], [Invoice Line Type], [Invoice Line Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Details.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Invoice Comment Index], [Invoice Comment], [Invoice Discount Percentage], [Invoice Discount Account], [Invoice Discount Project], [Invoice Discount SubAccount], [Invoice Due Date], Invoice_Number, [Invoice Line], [Invoice Sales Order], %ItemKey, [Invoice Partial OK], [Invoice Performance Date], [Invoice Pick Date], [Invoice Unit Price], [Invoice Product Line], %ProdLineKey, [Invoice Project Code], [Invoice Promise Date], [Invoice Quantity Invoiced], [Invoice Quantity Ordered], [Invoice Quantity Pending], [Invoice Performance Qty], [Invoice Quantity Pick], [Invoice Quantity Quoted], [Invoice Quantity Shipped], [Invoice Request Date], [Invoice Serial Number], [Invoice Ship To], %SiteKey, %SalespersonKey, [Invoice Status], %SubAccountKey, [Invoice Line Taxable], [Invoice Line Type], [Invoice Line Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Detailslimtd.qvd](qvd);

    LOAD [Location Name], [Invoice Bill To], [Invoice Header Channel], [Invoice Header Comment Index], [Invoice Header Credit Terms], %CustomerKey, [Invoice Header Due Date], [Invoice Date], [Invoice Month], [Invoice Year], Invoice_Number, [Invoice Header Sales Order], [Invoice Header Ordered Date], [Invoice Header Partial OK], [Invoice Header Purchase Order], [Invoice Header Project Code], [Invoice Header Sales Quote], [Invoice Header Request Date], [Invoice Header Remarks], [Invoice Header Ship Date], %SiteKey, %SalespersonKey, [Invoice Taxable], [Invoice Trailer1 Amount], [Invoice Trailer1], [Invoice Trailer2 Amount], [Invoice Trailer2], [Invoice Trailer3 Amount], [Invoice Trailer3], [Invoice Type]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Invoice_Headerlimtd.qvd](qvd);

    LOAD %ItemKey, [ABC Code], [BOM Code], [Item Description1], [Item Description2], [Item Group], Item_, [Item Type], [Item Price], Item_Product_Line, [Item Site_], [Item Status], [Item Unit Of Measure]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Items.qvd](qvd);

    LOAD %ProdLineKey, Product_Line, [ProductLine Description]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Prod_Line.qvd](qvd);

    LOAD [Location Name], %AccountKey, %CCKey, [Sales Detail Comment Index], [Sales Detail Comment], [Sales Detail Confirmed], [Sales Detail Item Description], [Sales Detail Discount Account], [Sales Detail Discount CostCenter], [Sales Detail Discount Project], [Sales Detail Discount SubAccount], [Sales Detail Due Date], [Sales Detail Expire Date], [Sales Detail Invoice Number], [Sales Detail Order Line], [Sales Detail List Price], [Sales Detail Modified Date], Sales_Order, %ItemKey, [Sales Detail Partial], [Sales Detail Performance Date], [Sales Detail Pick date], [SOD Price List], [Sales Detail Unit Price], [Sales Detail Product_Line], %ProdLineKey, [Sales Detail Project_Code], [Sales Detail Promise Date], [Sales Detail Qty Allocated], [Sales Detail Qty To Ship], [Sales Detail Qty Invoiced], [Sales Detail Qty Ordered], [Sales Detail Qty Shipped], [Sales Detail Ship To], %SiteKey, %SalesPersonKey, [Sales Detail Cost], %SubAccountKey, [Sales Detail Ship Type], [Sales Unit Of Measure], [Sales Detail Ext Price]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_Details.qvd](qvd);

    LOAD [Location Name], [Sales Order Bill TO], [Sales Order Channel], [Sales Head Comment Index], %CustomerKey, [Sales Order Due Date], [Sales Order Invoice Date], [Sales Order Invoice Number], [Sales Order Invoiced], Sales_Order, [Sales Order Order date], [Order Year], [Order Month], [Sales Order Partial OK], [SO Purchase Order], [SO Price List], [Sales Order Project], [Sales Quote], [Sales Order Request Date], [Sales Order Revision], [Sales Order Remarks], [Sales Header Ship To], [Sales Order Ship Date], %SiteKey, %SalesPersonKey, [Sales Trailer 1], [Sales Trailer 1 Amount], [Sales Trailer 2 Amount], [Sales Trailer 2], [Sales Trailer 3 Amount], [Sales Trailer 3], TypeFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_Header.qvd](qvd);

    LOAD %SalesPersonKey, Sales_Person, [Sales Person Name]FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sales_persons.qvd](qvd);

    LOAD %SiteKey, [Site Description], Site_FROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sites.qvd](qvd);

    LOAD %SubAccountKey, [Sub_Account Description], Sub_AccountFROM[C:\Users\QV\Data\Bolingbrook\Dimensional\Sub_Accounts.qvd](qvd);

    Appreciate any input on what is wrong with the above script

  • RELEVANCY SCORE 2.70

    DB:2.70:Multiple Invoice Dates In One Query pm


    Hello Forum Members:

    I would like to get some help here.
    I have multiple invoice dates such as "Invoice Date", "Invoice Date2", "Invoice Date3", "Invoice Date4" and "Invoice Date5" in a table.

    DB:2.70:Multiple Invoice Dates In One Query pm

    Try changing the WHERE clause to:

    WHERE [UnitsOrdered]-NZ([UnitsReceived_INV],0)0 AND [Purchase Orders].OrderDate) BETWEEN #1/1/2011# AND #12/31/2012#;

    Nulls propagate in arithmetical operations, so if UnitsReceived_INV is Null the expression would evaluate to Null, neither True nor False. With columns of quantitative values like this it's usually best to make them Required and give them a DefaultValue property
    of zero in the table design. This will avoid any problems with Nulls.

    Also I don't think you'll actually need a LEFT JOIN as you are restricting the query on a column in Purchase Orders, which will in effect turn it into an INNER JOIN.

  • RELEVANCY SCORE 2.69

    DB:2.69:Dtw - Upload Of Reserve Invoice jc



    I am looking to upload several reserve invoice throught the DTW. I upload them through the oInvoice but where I tell it is a Reserve Invoice?

    DB:2.69:Dtw - Upload Of Reserve Invoice jc


    how is it exposed in SBO2007 ? I am using SBO 2007 PL41 and do not see it in DTW

    Edited by: Hector Santos on Oct 11, 2008 7:08 PM

    Edited by: Rui Pereira on Dec 4, 2008 1:15 PM

  • RELEVANCY SCORE 2.69

    DB:2.69:Ar: Applying Multiple Deposits To A Single Invoice 9f


    Hi,

    we are on Receivables R12.1.2. The user wants to apply 2 (or more) deposits to a single Invoice, the system does not allow.

    In our business scenario the Customer pays in advance (Deposits) and multiple times and a single invoice is raised at the end of the month sometimes longer.

    Oracle Support says it is an ER. What could be a workaround?

    TIA

    DB:2.69:Ar: Applying Multiple Deposits To A Single Invoice 9f

    Hi,

    A way i can think of, is that, you enter standard receipts against the customers, apply the receipts "On Account". At the month end enter a single customer transaction, unapply the receipts that were earlier applied "On Account" and apply them to the Customer Transaction. GL account assigned to "On Account" should be advance/deposit from customers I hope this will help.

    Regards,
    Tasweer

  • RELEVANCY SCORE 2.69

    DB:2.69:Customer Prepayment Process cc



    Hello Experts,

    Our client has a requirement of customer prepayment for contract or order value. Here are the following steps in FI:

    1. Down payment request - automatic posting down payment request while creation of proforma prepayment invoice.

    2. Down payment posting - posting down payment in APP (Transaction F110) by clearing down payment request

    3. Clearing sales invoice with down payment - how to clear the sales invoices (multiple invoice) with down payment posting in one step.

    Do some one has any feasible solution of above scenario.

    Regards

    KP

    DB:2.69:Customer Prepayment Process cc


    Hi KP,

    1. Discuss with SD consultant to implement billing planing scenario to apply prepayment against customer via proforma invoice.

    Regards

    Mani Kumar

  • RELEVANCY SCORE 2.69

    DB:2.69:Bill Of Exchange Invoice Reference fp



    Hello,

    When using F110 for Customer Bill of Exchange payment requests, I am trying to get the invoice number onto the Bill of Exchange document in the reference field (BKPF-ZBLNR) of the payment request document.

    I have set the single payment for each invoice flag, but I am getting no joy.

    Does anyone have a solution on how to do this as I am running out of ideas?

    Thanks

    Daniel.

    DB:2.69:Bill Of Exchange Invoice Reference fp


    Hello,

    When using F110 for Customer Bill of Exchange payment requests, I am trying to get the invoice number onto the Bill of Exchange document in the reference field (BKPF-ZBLNR) of the payment request document.

    I have set the single payment for each invoice flag, but I am getting no joy.

    Does anyone have a solution on how to do this as I am running out of ideas?

    Thanks

    Daniel.

  • RELEVANCY SCORE 2.69

    DB:2.69:Request Money / Create Invoice Process Not Working... ad



    Hi there,

    Is there currently a problem with the Request Money and Create Invoice processes in Paypal?

    Every time I go in I'm getting the following message:

    Sorry, an error occurred after you clicked the last link

    Trying to create an invoice for a customer but can't do anything at the moment /

    DB:2.69:Request Money / Create Invoice Process Not Working... ad


    I have been getting the same thing. Sometimes when I am super persisten and keep trying to "Manage Invoice", it'll finally let me through, but no luck right now...a bad glitch to have (IMHO).

  • RELEVANCY SCORE 2.69

    DB:2.69:Invoice 9x



    What is meant by customer invoice and vendor invoice in FI context?

    DB:2.69:Invoice 9x


    Customer Invoice :

    Basically, it is raised as to receive the money from your customer(Sales Invoice) for the goods delivered to him.

    Vendor Invoice :

    Basically, it is raised by the vendor from whom you procured service/goods. It is purchase invoice and after verification of the goods and invoice, the vendor is paid.

  • RELEVANCY SCORE 2.69

    DB:2.69:Multiple External Partners Linked To Same Sap Customer 38


    1. Same customer code 123 2. Place an order to multiple sales org A and B. 3. They provided one external partner for each sales org. 4. Request invoice EDI with send back the correct External partner code. Currently we maintained 2 record in the table EDPAR Customer = 12372 Ext.Function = SP External partner = 1000380 and 1281020 Int.no = 12372 So , Idoc send incorrect vender code ( LIFNR ) back to the customer. E1EDKA1 AG ( LIFNR ) , invoice rejected. As no field sales org code in the table EDPAR, so how to setup for Idoc to send the correct external partner code back to the customer. ( key combination Sales org/ Sold-to/ Please advise.

    DB:2.69:Multiple External Partners Linked To Same Sap Customer 38

    If no other way . I will go with user-exit to read "external partner code" from the table EDSDC with key combination Sale-org/Sold-to.

  • RELEVANCY SCORE 2.68

    DB:2.68:Valuated Project Stock Not Allowed With Customer Stock f9



    Hi Gurus,

    While creating credit memo request wrt Invoice am getting the following error

    "Valuated project stock not allowed with customer stock"

    Scenario is:

    Invoice created with reference to project delivery.

    The material items that were used while invoicing were reserved against Project stock.

    Thanks

    Regards,

    DDP

    DB:2.68:Valuated Project Stock Not Allowed With Customer Stock f9


    This system behavior is correct. For a project process, GI is done via PS not via SD, SD is used for billing via a debit memo.

    Discuss the process with a PS colleague. You will be able to pass a value credit in SD, for the rest discuss with PS.

  • RELEVANCY SCORE 2.68

    DB:2.68:What Is The Difference Between Request A Payment And Invoice? 9j



    If I create an invoice and send it, my customer can pay through it when I send the email so if I did 'request payment' what is the difference? That is also sent via email where the customer can also pay, right? I'm new to paypal and i'm trying to figure all this out. Also if someone wanted to send my a personal payment how does that work and how could i request a personal payment? Hope this makes sense.

    DB:2.68:What Is The Difference Between Request A Payment And Invoice? 9j


    If I create an invoice and send it, my customer can pay through it when I send the email so if I did 'request payment' what is the difference? That is also sent via email where the customer can also pay, right? I'm new to paypal and i'm trying to figure all this out. Also if someone wanted to send my a personal payment how does that work and how could i request a personal payment? Hope this makes sense.

  • RELEVANCY SCORE 2.68

    DB:2.68:Invoice Split- Urgent fs



    Hi all,

    I have got a situation where one invoice contains more than 999 items, which exceeds the SAP standard aloowed items.

    This invoice is worth 20 lacs and customer wants it to like this anyway.

    I have been suggested to split this invoice or billing doc. into two so that the nos. can be distributed

    Is there any way to split one invoice to two or multiple invoices.

    It is urgent.

    tahnx in advance,

    Sourav.

    DB:2.68:Invoice Split- Urgent fs


    Hi Sourav,

    Even of you go through IMG -- SD -- Billing Billing documentcountry -specific features-- maintain maximum no.of billing items it will give you max 999 only I hope,

    so. As per my thinking you can get that specification through the copying routine.

    Go to transaction VTFL there you go item detail screen there is feild called Data VBRK/VBRP, this the field will control the invoice split, Standard is 001, but you can copy that one and change logic with the help of ABAPer (T.Code VOFM) then assign that new routine in the same transaction for you Delvery type and Billing type.

    I hope it will help you

    Thanks,

    Murali.

  • RELEVANCY SCORE 2.68

    DB:2.68:Ap Workflow Invoice Processing - Multiple Down Payments jf



    Hi,

    I request some assistance with respect to AP Workflow Invoice Processing.

    Our business would like to inquire if it is possible to monitor multiple payments to a particular vendor while approving through Workflow?

    for e.g. the total payment to Vendor B is $250,000 but 5 payment of $50,000 are made each month how can the approvers monitor these multiple payments?

    Thanks

    DB:2.68:Ap Workflow Invoice Processing - Multiple Down Payments jf


    Hi,

    I request some assistance with respect to AP Workflow Invoice Processing.

    Our business would like to inquire if it is possible to monitor multiple payments to a particular vendor while approving through Workflow?

    for e.g. the total payment to Vendor B is $250,000 but 5 payment of $50,000 are made each month how can the approvers monitor these multiple payments?

    Thanks

  • RELEVANCY SCORE 2.67

    DB:2.67:Flb2- Payment Applied To Incorrect Customer 7s



    Hi,

    During FLB2 upload, the payment is applied to incorrect customer B than what it should apply based on customer A's bank details. Upon investigation, it was known that the lockbox file contains wrong invoice # which accidently belongs to customer B. Moreover, there is NO bank details maintained for customer B.

    Now, my question is-

    1) Does the Invoice # supercede the bank details of customer during FLB2 upload?

    2) What if in above case, I maintain the bank details for customer B. Will it then go "On Account" to Customer A coz it had not found the correct invoice #, or it will still try to apply to customer B?

    Thanks in advance for your help,

    Nirav

    DB:2.67:Flb2- Payment Applied To Incorrect Customer 7s


    Hi,

    During FLB2 upload, the payment is applied to incorrect customer B than what it should apply based on customer A's bank details. Upon investigation, it was known that the lockbox file contains wrong invoice # which accidently belongs to customer B. Moreover, there is NO bank details maintained for customer B.

    Now, my question is-

    1) Does the Invoice # supercede the bank details of customer during FLB2 upload?

    2) What if in above case, I maintain the bank details for customer B. Will it then go "On Account" to Customer A coz it had not found the correct invoice #, or it will still try to apply to customer B?

    Thanks in advance for your help,

    Nirav

  • RELEVANCY SCORE 2.67

    DB:2.67:Rebate Accruals s7



    Hello,

    in a rebate scenario, when we raise an invoice, the rebate conditons are included in the invoice. so if the invoice value is Rs 100, the customer rebate for example is Rs 2 in the invoice.

    so the accounting entry generated will be to debit the customer by Rs 100 and credit to customer accrual account by Rs 2/-

    when we settle the rebates, the credit memo request is issued and then a credit memo. through credit memo the customer account is credit by Rs 2 and the customer accural account is reversed.

    my question is, in case of manual accruals, why the system is issuing a credit memo request and then a credit memo. becasue by issueing a credit memo, we are giving a credit to customer account (not accrual account) whereas in actual we are just doing an accrual like we are doing accurals when we are raising the invoice

    regards

    sachin

    DB:2.67:Rebate Accruals s7


    the process is as such, when you try for manual accruals (accrual adjustments) it is through Request document followed by billing document. This is for only adjusting the accruals and will not be sent to customer as credit memo.

    When you try settling, then the credit memo comes into the process.

  • RELEVANCY SCORE 2.67

    DB:2.67:Multiple Spool Request When Executing Vf31 9k



    Hello All,

    I have a problem in spool when executing the Tcode VF31 using the SAP webgui(SAP net weaver). It is creating multiple spool request for multiple invoice. My requirement is to have only one spool request for multiple invoices. We are using Adobe form to print the invoice.

    It is working fine, when I try to execute using the background job by changing the spool request attributes and also when executing the VF31 in SAP GUI, it creates only one spool request for multiple invoice.

    Please help me in this regards.

    Thx,

    Jagan

    DB:2.67:Multiple Spool Request When Executing Vf31 9k


    It's not an SD question, you might want to ask a local Basis admin or an ABAPer. If they're not available then at least request moderators to move this to Basis forum. You might also want to search there for any printing issues related to web GUI. We don't have it, so unfortunately I can't be of much help.

  • RELEVANCY SCORE 2.67

    DB:2.67:Invoice Request dk


    Hi, is it possible to request an invoice online?

    DB:2.67:Invoice Request dk

    Thank you. Actually I am helping a friend, she bought an iPhone in the USA, and took it to Brazil. Now, in order to make the insurance in the phone she needs the invoice, which she doesn't have! So I guess the easiest would be calling them!Regards.

  • RELEVANCY SCORE 2.67

    DB:2.67:[Help]New Record In A/R Invoice km



    Good day experts,

    I'm developing new add-ons in SAP. By this time I want to know if it is possible to create new record in AR Invoice using the file upload using excel file. I have concern about this. They have 100 records in excel. They want to upload them in AR Invoice.

    Example :

    Customer Item

    123 HP Printer 'This will be No. 1

    234 Mouse 'This will be No. 2

    This time, when I press the button upload the program will create two records. Do you have any examples regarding this?

    DB:2.67:[Help]New Record In A/R Invoice km


    Thank you for the suggestion about DTW, but they want me to create add-on.

  • RELEVANCY SCORE 2.67

    DB:2.67:Uploading Extended Fields Of Customer Invoice Request jm



    Hello,

    We do have a service integration which SAP already provided for Customer Invoice Request.

    We have to extend the CustomerInvoiceRequestBO based on the business requirements and then those extended fields are needed to be uploaded along with the standard ones.

    I have tried the uploading data by filling in the standard XML(Template downloaded through this business center) and all the standard data fields got uploaded successfully.

    Now, my question is what are the possible ways to upload Invoice Data along with the Extended Fields ?

    - Can we extend the service integration(provided by SAP) to create a proper mapping for the extended fields?

    - Do we need to create a new service integration for CustomerInvoiceRequestBO(thourgh PDI)? *the technical field for DocumentID says tat it is read-only and not allowin to Tick while creating new service intergration :(*

    I have already reviewed the pdf doc available in My Workspace -- Downloads -- FileInput Examples -- How-to-Guide Invoice Request FileInput but had no luck

    regards,

    vatsav

    DB:2.67:Uploading Extended Fields Of Customer Invoice Request jm


    Hi Vatsav,

    My understadning as per your thread:

    : You want to extend the CustomerInvoiceRequestBO(CIR) and iuse the XML file input mapped mechanism, mapping the schema in MS XL to uplaod CIR''s to ByDesign.

    Steps to do:

    1) I would create an XBO with the requried extensions (small range of possible data types to create extension elements)

    2) Once you save and activate the XBO, create a new XML file Input asset , a dotpid file. Here you select in the wizard the CIR BO in the nsmae space AP.CustomerInvoicing.Global.

    3) You should be able to see your extionsione lements here.

    4) Then follw the steps inthe Scalable Addon documentation.

    Hope this helps.

    Regards,

    Nitesh Pai

    Partner Competence Center @ByD

  • RELEVANCY SCORE 2.66

    DB:2.66:Printing Customer Invoice (F.61) jd



    Hi Gurus,

    We need to print multiple customer invoices from multiple company codes.

    How effectively we can use F.61 for this? If in future we again need any invoice, can we again use F.61 for the same invoice no.?

    Please explain me the use of F.62 and F.64 as well.

    Thank You

    DB:2.66:Printing Customer Invoice (F.61) jd


    I am giving five document no. but system is creating 8 requests which includes 3 requests for single invoice and 2 request for other invoice and single requests for remaining 3 invoices.

    Please help me in solving this issue.

    Thank You

  • RELEVANCY SCORE 2.66

    DB:2.66:Web Adi Concurrent Prorgams pf


    Hi

    Is it possible to launch multiple concurrent programs after a successful Web ADI upload?

    We are trying to import invoice data and run "Paybles Open Interface Import" and "Invoice Validation" concurrent programs at the end of upload process. I know that one concurrent program can be defined to run, but not sure about multiple ones.

    Thanks,
    Amjad.

    DB:2.66:Web Adi Concurrent Prorgams pf

    Oracle E-Business Suite Desktop Integration Framework Developer's Guide

  • RELEVANCY SCORE 2.66

    DB:2.66:Duplicating The Same Date In Multiple Facts zs


    I have a design question.

    We are following star schema model. The problem is explained in the example.

    Lets say there are two facts 'Invoice Fact' and 'Invoice Failures Fact' where

    a) Invoice Fact contains information about invoice date, invoice amount and is joined to customer dimension.

    b) Invoice Failure fact could possibly contain information for all invoices which were not honored by customers. Lets also assume that there is a need to keep this information in two different facts.

    Invoice fact joins to date dimension and records the date when the invoice was created. Invoice Failures Fact joins to date dimension and records the date when teh invoice was returned by the customer.

    If the requirement is to find all invoices created in a particular month which were returned, we have two options

    first option: Join the two facts through customer dimension
    - Select count(*) from Invoice_Failures_fact iff, Customer_dimension CD, Invoice_fact IF, Date_Dimension dd
    where iff.invoice_date_key = dd.dimension_key
    and iff.customer_dimension_key = cd.dimension_key
    and IF.customer_dimension_key = cd.dimension_key
    and dd.day between '01-Jan-2007' to '31-Jan-2007'

    second option
    - denormalize Invoice Failure Fact to include the Invoice Date (date when Invoice was created)

    Would second option violate any kimbal model or star schema architecture in general?

    DB:2.66:Duplicating The Same Date In Multiple Facts zs

    No, it is ok.

    But actually you don't need two fact tables. You can have one invoice info fact with two time dimensions: issue date and failure date; keeping failure date null or infinite for non failed invoices. If for performance reasons you want to create a separate fact for failed invoices then the design is ok.

  • RELEVANCY SCORE 2.66

    DB:2.66:Need A Prog Which Will Upload Scanned Documents 7d



    Dear All,

    Scenario: We have a customer invoice with an invoice number.

    We need to develop a program in which the user will enter the invoice number on the screen and in the next field will give the path of the scanned document of the same customer invoice.

    This docuement needs to be stored in SAP agaisnt this invoce number and later can also be retrieved from another program or we can use the same by giving the invoice number.

    Regards,

    Fawaz

    DB:2.66:Need A Prog Which Will Upload Scanned Documents 7d


    Ok, you can make a program that automatically inserts your image files into SAP system without going to se78 manually.

    Check this commented example:

    0 - Data declaration

    TYPE-POOLS: sbdst.
    DATA: bds_object TYPE REF TO cl_bds_document_set,
    bds_components TYPE sbdst_components,
    wa_bds_components TYPE LINE OF sbdst_components,
    bds_signature TYPE sbdst_signature,
    wa_bds_signature TYPE LINE OF sbdst_signature,
    bds_properties TYPE sbdst_properties,
    wa_bds_properties TYPE LINE OF sbdst_properties,
    wa_stxbitmaps TYPE stxbitmaps,
    BEGIN OF bitmap OCCURS 0,
    l(64) TYPE x,
    END OF bitmap,
    bytecount TYPE i,
    dpi TYPE stxbitmaps-resolution,
    bds_bytecount TYPE i,
    width_tw TYPE stxbitmaps-widthtw,
    height_tw TYPE stxbitmaps-heighttw,
    width_pix TYPE stxbitmaps-widthpix,
    height_pix TYPE stxbitmaps-heightpix,
    bds_content TYPE sbdst_content,
    docid TYPE stxbitmaps-docid.

  • RELEVANCY SCORE 2.65

    DB:2.65:Invoice d3



    Hello Guru,

    Our CSR created three down payment orders with three separate POs numbers. Now when down payment request invoice ran in batch overnight, it grouped all three orders into one invoice. We need to look into why the system grouped three separate orders into one invoice even though its was for the same customer. We want to make sure on our cash advance order this does not happen . We want separate invoice for each order.

    Please advise ASAP

    Thank you in advance

    DB:2.65:Invoice d3


    Hello Guru,

    Our CSR created three down payment orders with three separate POs numbers. Now when down payment request invoice ran in batch overnight, it grouped all three orders into one invoice. We need to look into why the system grouped three separate orders into one invoice even though its was for the same customer. We want to make sure on our cash advance order this does not happen . We want separate invoice for each order.

    Please advise ASAP

    Thank you in advance

  • RELEVANCY SCORE 2.65

    DB:2.65:Sharepoint Document Library And Attachment? 78


    Hello,
    I get a request from my customer.
    he is using document library to upload lots of invoice pdf files. then he use SharePoint out of box approval workflow to get managers to approve those invoice.
    everything is good so far. but some managers think it would be better to allow them to put attachment when they approve the invoice?
    anyone has idea how to make that happen?

    DB:2.65:Sharepoint Document Library And Attachment? 78

    Document sets can be approved as a whole but i have heard some people have difficulty with them. You will need to turn the feature on before you can use them. Good luck!
    -SharePointNinja

  • RELEVANCY SCORE 2.65

    DB:2.65:Upload Invoices Electronically p1



    Hi

    I am new to SAP.

    I would like to know how to upload customer invoices electronically.

    I need to put information for different customers on one upload. I need to be able to allocate invoice numbers per line item in the upload sheet.

    What transaction will be used?

    Thank you for your help

    DB:2.65:Upload Invoices Electronically p1


    Hi

    I am new to SAP.

    I would like to know how to upload customer invoices electronically.

    I need to put information for different customers on one upload. I need to be able to allocate invoice numbers per line item in the upload sheet.

    What transaction will be used?

    Thank you for your help

  • RELEVANCY SCORE 2.65

    DB:2.65:Email Invoices To Customer As A Pdf Attachment pa



    Hi,

    I have a requirement as follows:-

    SAP will get multiple invoice numbers from an external system. I need to send all the invoices(for a given customer) in one pdf and email it to the customer as an attachment.

    Please provide your expert and detailed advice.

    Thanks,

    Ani

    DB:2.65:Email Invoices To Customer As A Pdf Attachment pa


    Here is the code to send the Smartform to mail as PDF attachment.

    ----

    * Report ZTEST_PDF_MAIL

    *

    ----

    REPORT ZTEST_PDF_MAIL.

    Internal Table declarations

    DATA: I_OTF TYPE ITCOO OCCURS 0 WITH HEADER LINE,

    I_TLINE TYPE TABLE OF TLINE WITH HEADER LINE,

    I_RECEIVERS TYPE TABLE OF SOMLRECI1 WITH HEADER LINE,

    I_RECORD LIKE SOLISTI1 OCCURS 0 WITH HEADER LINE,

    Objects to send mail.

    I_OBJPACK LIKE SOPCKLSTI1 OCCURS 0 WITH HEADER LINE,

    I_OBJTXT LIKE SOLISTI1 OCCURS 0 WITH HEADER LINE,

    I_OBJBIN LIKE SOLISTI1 OCCURS 0 WITH HEADER LINE,

    I_RECLIST LIKE SOMLRECI1 OCCURS 0 WITH HEADER LINE,

    Work Area declarations

    WA_OBJHEAD TYPE SOLI_TAB,

    W_CTRLOP TYPE SSFCTRLOP,

    W_COMPOP TYPE SSFCOMPOP,

    W_RETURN TYPE SSFCRESCL,

    WA_DOC_CHNG TYPE SODOCCHGI1,

    W_DATA TYPE SODOCCHGI1,

    WA_BUFFER TYPE STRING, "To convert from 132 to 255

    Variables declarations

    V_FORM_NAME TYPE RS38L_FNAM,

    V_LEN_IN LIKE SOOD-OBJLEN,

    V_LEN_OUT LIKE SOOD-OBJLEN,

    V_LEN_OUTN TYPE I,

    V_LINES_TXT TYPE I,

    V_LINES_BIN TYPE I.

    CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME'

    EXPORTING

    FORMNAME = 'ZTEST'

    IMPORTING

    FM_NAME = V_FORM_NAME

    EXCEPTIONS

    NO_FORM = 1

    NO_FUNCTION_MODULE = 2

    OTHERS = 3.

    IF SY-SUBRC 0.

    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    W_CTRLOP-GETOTF = 'X'.

    W_CTRLOP-NO_DIALOG = 'X'.

    W_COMPOP-TDNOPREV = 'X'.

    CALL FUNCTION V_FORM_NAME

    EXPORTING

    CONTROL_PARAMETERS = W_CTRLOP

    OUTPUT_OPTIONS = W_COMPOP

    USER_SETTINGS = 'X'

    IMPORTING

    JOB_OUTPUT_INFO = W_RETURN

    EXCEPTIONS

    FORMATTING_ERROR = 1

    INTERNAL_ERROR = 2

    SEND_ERROR = 3

    USER_CANCELED = 4

    OTHERS = 5.

    IF SY-SUBRC 0.

    MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    I_OTF[] = W_RETURN-OTFDATA[].

    CALL FUNCTION 'CONVERT_OTF'

    EXPORTING

    FORMAT = 'PDF'

    MAX_LINEWIDTH = 132

    IMPORTING

    BIN_FILESIZE = V_LEN_IN

    TABLES

    OTF = I_OTF

    LINES = I_TLINE

    EXCEPTIONS

    ERR_MAX_LINEWIDTH = 1

    ERR_FORMAT = 2

    ERR_CONV_NOT_POSSIBLE = 3

    OTHERS = 4.

    IF SY-SUBRC 0.

    ENDIF.

    LOOP AT I_TLINE.

    TRANSLATE I_TLINE USING '~'.

    CONCATENATE WA_BUFFER I_TLINE INTO WA_BUFFER.

    ENDLOOP.

    TRANSLATE WA_BUFFER USING '~'.

    DO.

    I_RECORD = WA_BUFFER.

    APPEND I_RECORD.

    SHIFT WA_BUFFER LEFT BY 255 PLACES.

    IF WA_BUFFER IS INITIAL.

    EXIT.

    ENDIF.

    ENDDO.

    Attachment

    REFRESH: I_RECLIST,

    I_OBJTXT,

    I_OBJBIN,

    I_OBJPACK.

    CLEAR WA_OBJHEAD.

    I_OBJBIN[] = I_RECORD[].

    Create Message Body Title and Description

    I_OBJTXT = 'test with pdf-Attachment!'.

    APPEND I_OBJTXT.

    DESCRIBE TABLE I_OBJTXT LINES V_LINES_TXT.

    READ TABLE I_OBJTXT INDEX V_LINES_TXT.

    WA_DOC_CHNG-OBJ_NAME = 'smartform'.

    WA_DOC_CHNG-EXPIRY_DAT = SY-DATUM + 10.

    WA_DOC_CHNG-OBJ_DESCR = 'smartform'.

    WA_DOC_CHNG-SENSITIVTY = 'F'.

    WA_DOC_CHNG-DOC_SIZE = V_LINES_TXT * 255.

    Main Text

    CLEAR I_OBJPACK-TRANSF_BIN.

    I_OBJPACK-HEAD_START = 1.

    I_OBJPACK-HEAD_NUM = 0.

    I_OBJPACK-BODY_START = 1.

    I_OBJPACK-BODY_NUM = V_LINES_TXT.

    I_OBJPACK-DOC_TYPE = 'RAW'.

    APPEND I_OBJPACK.

    Attachment (pdf-Attachment)

    I_OBJPACK-TRANSF_BIN = 'X'.

    I_OBJPACK-HEAD_START = 1.

    I_OBJPACK-HEAD_NUM = 0.

    I_OBJPACK-BODY_START = 1.

    DESCRIBE TABLE I_OBJBIN LINES V_LINES_BIN.

    READ TABLE I_OBJBIN INDEX V_LINES_BIN.

    I_OBJPACK-DOC_SIZE = V_LINES_BIN * 255 .

    I_OBJPACK-BODY_NUM = V_LINES_BIN.

    I_OBJPACK-DOC_TYPE = 'PDF'.

    I_OBJPACK-OBJ_NAME = 'smart'.

    I_OBJPACK-OBJ_DESCR = 'test'.

    APPEND I_OBJPACK.

    CLEAR I_RECLIST.

    I_RECLIST-RECEIVER = 'nareshreddy.k@gmail.com'.

    I_RECLIST-REC_TYPE = 'U'.

    APPEND I_RECLIST.

    CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

    EXPORTING

    DOCUMENT_DATA = WA_DOC_CHNG

    PUT_IN_OUTBOX = 'X'

    COMMIT_WORK = 'X'

    TABLES

    PACKING_LIST = I_OBJPACK

    OBJECT_HEADER = WA_OBJHEAD

    CONTENTS_BIN = I_OBJBIN

    CONTENTS_TXT = I_OBJTXT

    RECEIVERS = I_RECLIST

    EXCEPTIONS

    TOO_MANY_RECEIVERS = 1

    DOCUMENT_NOT_SENT = 2

    DOCUMENT_TYPE_NOT_EXIST = 3

    OPERATION_NO_AUTHORIZATION = 4

    PARAMETER_ERROR = 5

    X_ERROR = 6

    ENQUEUE_ERROR = 7

    OTHERS = 8.

    IF SY-SUBRC 0.

    WRITE:/ 'Error When Sending the File', SY-SUBRC.

    ELSE.

    WRITE:/ 'Mail sent'.

    ENDIF.

    If you want to send some text as Body of the Mail then follow this once

    when u r callin the FM'SO_NEW_DOCUMENT_ATT_SEND_API1'.. points to remember

    1.u have to pass the body of content in table CONTENTS_TXT(ia m using I_OBJBIN) (each line a record) then. suppose i have appended 11 records to the table CONTENTS_TXT .

    2.PACKING_LIST(iam usign I_OBJPACK) table u ahve to append a redord as follows

    I_OBJPACK-TRANSF_BIN = ' '.

    I_OBJPACK-HEAD_START = 000000000000001.

    I_OBJPACK-HEAD_NUM = 000000000000001.

    I_OBJPACK-BODY_START = 000000000000002

    I_OBJPACK-BODY_NUM = 000000000000010.

    I_OBJPACK-DOC_TYPE = 'RAW'.

    append I_OBJPACK-.

    by the above code system treat the first line in table I_OBJBIN as header and the 2nd line to 10 lines tread as body.

    CALL FUNCTION 'SO_NEW_DOCUMENT_ATT_SEND_API1'

    EXPORTING

    DOCUMENT_DATA = WA_DOC_CHNG

    PUT_IN_OUTBOX = 'X'

    TABLES

    PACKING_LIST = I_OBJPACK

    OBJECT_HEADER = WA_OBJHEAD

    CONTENTS_BIN = I_OBJBIN

    CONTENTS_TXT = I_OBJTXT

    RECEIVERS = I_RECLIST

    EXCEPTIONS

    TOO_MANY_RECEIVERS = 1

    DOCUMENT_NOT_SENT = 2

    DOCUMENT_TYPE_NOT_EXIST = 3

    OPERATION_NO_AUTHORIZATION = 4

    PARAMETER_ERROR = 5

    X_ERROR = 6

    ENQUEUE_ERROR = 7

    OTHERS = 8.

    regards,

    srinivas

    b*reward for useful answers*/b

  • RELEVANCY SCORE 2.64

    DB:2.64:Sd_Salesdocument_Create Pricing Query ac



    Hi friends,

    I have developed a program to create credit memo request.

    Program creates the credit memo request with reference to Original invoice.

    But, suppose in invoice if the customer was given the Discount of 0% (ZDD1 condition), and today it the discount is changed, lets say 20% in vk12.

    if I am creating the credit memo request today with reference to original invoice, i should get the discount of 0% (which was in original invoice)

    but i am getting it as 20%.

    How to achieve this?

    Please help.

    Regards-

    Makarand

    DB:2.64:Sd_Salesdocument_Create Pricing Query ac


    Hi friends,

    I have developed a program to create credit memo request.

    Program creates the credit memo request with reference to Original invoice.

    But, suppose in invoice if the customer was given the Discount of 0% (ZDD1 condition), and today it the discount is changed, lets say 20% in vk12.

    if I am creating the credit memo request today with reference to original invoice, i should get the discount of 0% (which was in original invoice)

    but i am getting it as 20%.

    How to achieve this?

    Please help.

    Regards-

    Makarand

  • RELEVANCY SCORE 2.64

    DB:2.64:Compressed Cubes Cannot Be Selected In Psa Infopackage 39



    We have manually selected a number of Invoice Lines using the 2LIS_01_S262 data source directly from R3.

    We have made a full upload to PSA.

    We have edited the data in the PSA in order to make some adjustments to some key figures.

    We have made a full upload from PSA to a test cube (multiple Item No's so multiple Request IDs).

    We intend to replicate this full update from PSA to our production cubes in order to rely on the existing update rules, and the compressed cubes cannot be selected in the infopackage.

    The request id of the packages in the PSA are lower than the last compressed package request id.

    Is there any way that we can get around this and load the packages from the PSA in to the compressed cubes?

    Yours hopefully.

    Sally

    DB:2.64:Compressed Cubes Cannot Be Selected In Psa Infopackage 39


    hi,

    if the data has been loaded to the cube and compressed then you need to again reload the data from the source,

    regards,

    Arvind,

  • RELEVANCY SCORE 2.64

    DB:2.64:How To Make The Concurrent Request Set Run Only Once xm


    Hi Team,

    Ijust have a requirement.

    At a time only single concurrent request set should be running and the remaining submitted request sets should be in pending status.

    I mean to say : i have a concurrent request set : "Invoice Req Set"

    If user submits the request set multiple times: Invoice Req Set once

    the second one should not be running until the first request set : "Invoice Req Set" completes.

    Any suggestions ??

    -Sridhar

    DB:2.64:How To Make The Concurrent Request Set Run Only Once xm

    Hi;

    Please check below which could be helpful for your issue:
    how to prevent multiple request of one conc program

    Regard
    Helios

  • RELEVANCY SCORE 2.64

    DB:2.64:Invoice Correction Request - Rk aj



    I created an invoice correction request with reference to an invoice. Changed the quantity on it from 3 to 1. So the customer will need to pay less than what they were supposed to pay.

    No amount has yet been received from the customer.

    Now where do I see if a credit memo or a debit memo has been created or not ?

    When I go to VA01 to create a Credit memo request (CR), with reference to the invoice, it tells me that a credit memo request already exists for that invoice.

    When I do get in the order, the no. of items is the same - 3.

    Solution anyone?

    Cheers

    DB:2.64:Invoice Correction Request - Rk aj


    Hi there,

    Basing on your issue, you create a invoice correction request RK or a credit memo request CR. Not both.

    If you create an invoice correction request, then it will have a credit memo by default. RK will have a billing block sothat authorized person can validate the RK order type. Once the billing block is removed manually, we can create credit memo G2 invoice in VF01.

    In practise, credit memo request is created for returns. If you happen to know that you have billed the customer with a wrong price or quantity we create a invoice correction request.

    Hope this helps.

    Regards,

    Sivanand

  • RELEVANCY SCORE 2.64

    DB:2.64:Amend Gst Code In Sales Invoice After Posting 8a



    Hi

    Our client has a request to correct GST Code for specific Item Row in Sales Invoice after it has been posted when there are multiple Item rows with different GST Codes and rates.

    Kedalene Chong

    DB:2.64:Amend Gst Code In Sales Invoice After Posting 8a


    Hi,

    Correction of GST code (or VAT code) on posted invoice would not be compliant with regulations in many countries. We need to ensure that B1 legal compliance is maintained and any results generated from B1 are recognized by local authorities. By allowing this, we might face serious difficulties.

    Please investigate whether this is legally compliant in the country of the customer.

    Thank you for the suggestion.

    Regards,

    Peter Dominik

    B1 Product Definition

  • RELEVANCY SCORE 2.64

    DB:2.64:Invoice Generation Request Failing 1z


    Hi All,

    I am running the PRC:generate Draft Invoice for a range of Projects from a custom program as a concurrent program from the database. The request is failing showing Unable to Initialize and giving the following error
    ...connected to database
    ...Setting project id
    ...Setting bill_through date to sysdate
    ...Setting bill_through date to invoice date
    ...Setting invoice invoice generation option :
    EXCLUDE_RETN_INVOICES
    ...Setting invoice process :
    GENERATE
    ...No invoice number specified
    ...No start project number specified
    ...No end project number specified
    ...No write off amount specified
    ...No resubmission interval specified
    ...No resubmission time specified
    ...No resubmission end-date specified
    ...No request to adjust date specified
    ...No project type specified
    ...No project org specified
    ...No customer specified
    ...Setting LOC customer
    ...Setting agreement
    ...Multi currency projects only requested
    ...Exclude addl transactions not requested
    ...Delete only unapproved invoices not specified
    ...Credit level (only for WRITE-OFF/CONCESSION) not specified
    ...Retrieved user_id
    ...Retrieved request_id
    ...Retrieved program_app_id
    ...Retrieved program_id
    ...Setting Sets Of Books
    Entering paisob()Current system time is 06-JAN-2009 13:17:15
    ORACLE error during DRAFT INVOICE GENERATION (cursor=10 code=1403: ORA-01403: no data found
    )
    PAI_ORACLE_ERROR
    ERROR
    cursor=10 code=1403: ORA-01403: no data found

    Leaving paisob()Error during Draft Invoice Generation. Module paisob returned failure
    PA_IGEN_ERROR
    MODULE
    paisob
    Error during Draft Invoice Generation. Module paiiig returned failure
    PA_IGEN_ERROR
    MODULE
    paiiig

    However when I am running the request directly from the Submit Request window its working properly.DO anyone have any suggestion?

    Thanks in Advance

    DB:2.64:Invoice Generation Request Failing 1z

    Hi

    I guess the error may be related to the responsibility used on your custom program. It may not get the right initialization, and the system cannot get the operating unit and set of books.

    Dina

  • RELEVANCY SCORE 2.64

    DB:2.64:Is This Newb On The Right Track In Creating My First Wcf App ca


     
    Let's say that I want to create an invoicing WCF app.  On the Services side I have the following data contracts.
     
    Customer
    Invoice
    InvoiceLines
    Inventory
     
    My Service provides for 4 operations.
     
    CreateInvoice
    RetrieveInvoice
    UpdateInvoice
    DeleteInvoice
     
    On the client side to display the info in my Wcf app, I have the following classes.
     
    InvoiceUI which holds the Customer object for that invoice, the invoicelines object and the inventory object for each line.
     
    When the UI makes a request to view an invoice, I call the RetrieveInvoice operation, which on the server side fetches the invoice from the Invoice table in SQL Server and then fetches the customer, the Invoicelines and the inventory information for each invoiceline.  The server then passes the Whole Invoice object back to the client and the client displays the invoice object including detail lines and customer information.
     
    When the UI wants to create a new invoice, I create a new InvoiceUI object, the information is filled in on the screen and then I call CreateInvoice which passes the InvoiceUI object back to the server and then an operation on the server pulls out the invoice information and the detail lines and inserts them into the invoice table and the invoicelines table. It also updates the inventory quanities and updates the customer account.
     
    Am I going in the right direction?
     
    Thanks for your help
    Bill
     

    DB:2.64:Is This Newb On The Right Track In Creating My First Wcf App ca

    Hi Bill tahts pretty good so far,
     
    I would avoid CRUD paterns , though things will be CRUD like Its better to have
     
    CreateInvoice
    AlteerInvoice (allows delete)
    RetrieveInvoices  ( note plural)  
     
    and CRUD would also have
    CreateInvoiceLIne
    DeleteInvoiceLine
     
    etc.
     
     
    The real problem comes in the sub objects there shouid be no operations for invoice lines which you have correctly followed.  These should be performed by the above methods.
     
     
    One tip dont use paramters use DataContracts as your messages ..
     
    eg
     
    RetrieveInvoice
     
    will become

    RetrieveInvoiceByID
    RetrieveInvoices etc
     
    instead
    RetrieveInvoiceResult RetrieveInvoice ( InvoiceRequest)
     
    RetrieveInvoice contains an array ( even if you return 1 )
    InvoiceRequest will have all your search criteria
     
    This way if you add a new serach criteria ( a fairly common requirement)
    - All existing applications will continue to work
    - You dont need to version the service contract by adding a new operation
    - The server only requires a new paramter on the InvoiceRequest object and everything else stays the same eg the retrieval code,
     
    If you really want to get keen dont send the orderID and LienItemId , they should not be needed by the client have a look at
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2065917SiteID=1
     
     
    Regards,
     
    Ben
     
     
     
     
     
     
     
     
     
     
     
     
     
    Regards,
     
    Ben
     
     

  • RELEVANCY SCORE 2.63

    DB:2.63:Upload Multiple Files ca


    Hi,
    I want to upload multiple files to php server in one request.
    I used FileReference class to upload file, but it can only upload
    one file at time.So to upload multiple file i created an array of
    FileReference and upload them one by one using loop, but it make
    request to php server for each file. I want to do this thing with
    only one request....
    To upload file, i took the material from below link:

    http://livedocs.adobe.com/flex/3/html/help.html?content=17_Networking_and_communications_7 .html

    DB:2.63:Upload Multiple Files ca

    Hi,
    I want to upload multiple files to php server in one request.
    I used FileReference class to upload file, but it can only upload
    one file at time.So to upload multiple file i created an array of
    FileReference and upload them one by one using loop, but it make
    request to php server for each file. I want to do this thing with
    only one request....
    To upload file, i took the material from below link:

    http://livedocs.adobe.com/flex/3/html/help.html?content=17_Networking_and_communications_7 .html

  • RELEVANCY SCORE 2.63

    DB:2.63:Crystal Reports Multiple Tables C# Wpf Linq pf


    I am creating an invoice from multiple tables. One table contains the header details like invoice no, date, customer name etc, and the other table has multiple detail records. Is there any way we can link these two tables and set the report source to this.
    I am using LINQ in my project

    DB:2.63:Crystal Reports Multiple Tables C# Wpf Linq pf

    I am creating an invoice from multiple tables. One table contains the header details like invoice no, date, customer name etc, and the other table has multiple detail records. Is there any way we can link these two tables and set the report source to this.
    I am using LINQ in my project

  • RELEVANCY SCORE 2.63

    DB:2.63:Need To Print On Pages 2 And Following Of Each Invoice zp


    On the second and following pages of invoices, the customer name is to be printed about where the customer address is printed on the first page.  This works well for single invoices, but when multiple invoices are printed concurrently, only the first invoice shows the first page as desired.Extremely rough example of required format:Invoice    Page 1CustomerAddressTable of Invoice DataPage footerInvoice Page 2Customer NameTable of Invoice DataPage footerThanks,Bob Griffin

    DB:2.63:Need To Print On Pages 2 And Following Of Each Invoice zp

    Hi Griffin,
     
    Could you elaborate how you created the report? Reporting service version, 2005 or 2008? Data region,matrix or table or…? And other that you can post out.
     
    Thanks,
    Jerry

  • RELEVANCY SCORE 2.62

    DB:2.62:Reg: Lsmw To Upload Unlaoding Points To Customer Master sd



    Dear Gurus,

    I have created an LSMW program to upload "Unloading Points" into Customer Master Record.

    It is working fine with single Unloading Point.

    There are multiple Unloading Points need to be maintained for every Customer.

    Can anyone provide me the logic to maintain multiple unloading points in Customer Master?

    XD02-ABLAD = XD02_S-ABLAD.

    Here the "ABLAD" is the Unloading Point.

    Regards,

    RK

  • RELEVANCY SCORE 2.62

    DB:2.62:Sales Order Issue 3d



    hi all

    i I have created down payment request amount received from customer and I have create another sales order against existing sales order and created invoice in new sales order and I want to clear invoice against existing sales order downpayment request, how to perform remains balance how to settle.

    thanks

    DB:2.62:Sales Order Issue 3d


    Hi Gunasekar,

    ' MoazzaM ' is absolutely right.

    This is purely FI related problem and it can be done through F-32 which is called residual clearing for customer.

    Please take help of FI guy and resolve your issue.

    Regards

    Eugene

  • RELEVANCY SCORE 2.62

    DB:2.62:Pbas Feature Request: Multiple Invoice Templates zz





    Hi,

    In the past weve created Feature Requests through the Parallels support ticket system. However the latest version of the ticket submission page no longer gives this option. If theres a better place to raise these, please let me know.

    Wed like the option to be able define multiple invoice templates, with a specific template chosen as the Default for automatically created invoices. When manually creating an invoice we should be able to choose from the available templates weve created.

    Regards,
    Sean

    DB:2.62:Pbas Feature Request: Multiple Invoice Templates zz




    yeah its very irritating and very common problem as well but if you are thinking about changing it i will recommend you to visit http://www.fetchflow.com/invoice-templates .You will find here lots of unique templates with lots of features and also it gives a unique authority to create your own templates.You can also send multiple type of invoices with same time without any problem

  • RELEVANCY SCORE 2.62

    DB:2.62:Transaction Posting Between Two Company Codes 33



    Hi All

    Request your help for below scenario:

    We have multiple company codes in SAP 4.7 version. Of which, we have requirment such that, one compay code is customer and vendor relation to other company code.

    Some Sales order invoices of C.Code 0001 will be Purchanse order invoices in company code 0002.

    At present users manually posting the invoice as vendor invoices at FB60 in 0002 company code.

    We want this process to be automated bewteen company codes.

    Request your inputs for same.

    Thanks in advance for all your inptus.

    DB:2.62:Transaction Posting Between Two Company Codes 33


    Problem solved with self investigations and other help from SDN. not though this post.

  • RELEVANCY SCORE 2.61

    DB:2.61:Select Issue 3c


    Hello, I have a select statement that returns 2 or more rows. The column list is: Customer, Product and Invoice Number. There are multiple invoice numbers per product and customer. What I need to display is the unique customer and product with all associated invoice numbers separated by ' | '. The below example shows the customer 'John' with 3 separate invoices for the product 'MS Word'. So instead of displaying multiple rows, I need this in one row... Customer :John, Product :MS Word Invoice Number : 1234|4567|0987 Any help would be appreciated... Thanks, DaveDave SQL Developer

    DB:2.61:Select Issue 3c

    Haha, thank you for the code :)Dave SQL Developer

  • RELEVANCY SCORE 2.61

    DB:2.61:Automatic Clearing Of Net Of Credit Memo And Customer Invoice sj



    Hello Experts,

    So, basically I have a situation wherein we have a customer open invoice and a credit memo (both belonging to the same customer). The credit memo has a reference to the invoice mentioned in the invoice reference field. My question is when I will do the lockbox upload, will the system clear the net of these two documents.Given that the lockbox file has invoice reference number in it?

    Please suggest!

    Regards

    Ravish

    DB:2.61:Automatic Clearing Of Net Of Credit Memo And Customer Invoice sj


    Hello Experts,

    So, basically I have a situation wherein we have a customer open invoice and a credit memo (both belonging to the same customer). The credit memo has a reference to the invoice mentioned in the invoice reference field. My question is when I will do the lockbox upload, will the system clear the net of these two documents.Given that the lockbox file has invoice reference number in it?

    Please suggest!

    Regards

    Ravish

  • RELEVANCY SCORE 2.61

    DB:2.61:Sd Invoice Cancellation za



    Hello all,

    I have got a problem with a canceled invoice.

    Document flow Flow : Sales order debit memo request Invoice 58xxxxxxx Canceled invoice 63xxxxxxx (Posting Status : Not posted in FI)

    What I want to to : canceling the canceled invoice or posting to FI

    As you can see above, the invoice was canceled. But just before the cancellation, the customer accepted to pay just a part of the invoice amount and not the whole amount invoice.

    Partial payment

    Also, when I want to post the canceled invoice, I have got an error message because of the partial payment made on the invoice 58xxxxxxx ( and then I can not post the whole amount of the canceled invoice)

    I tried to cancel the canceled invoice but it is not possible (it is impossible to complete the cancel invoice too only possible for the proforma invoice)

    I suggest to cancel the FI payment, then post the canceled invoice 63xxxxxxxx, and then I will be able to make another invoice.

    What do you think about this solution ?

    Best regards

    Vincent Jayet

  • RELEVANCY SCORE 2.61

    DB:2.61:Multiple Bp Currency And Payments zj



    Hi All,

    The scenario is we have a BP to whom we do the sales billings in multiple currency eg. USD EUR and system currency or local currency is SGD.

    Have created a BP master with multiple currency and it looks fine as far as sale invoice is concern. Now we have reaceived an advance payment from the customer in EUR 1000, when we process the same through Incoming payment screen by selecting Payment On Account system considers it as SGD ie. Local Currency and not in Foreign Currency ie. EUR.

    We have two bank accounts one is for USD and another one is for EUR. We will be debiting the respective GL accounts while posting incoming payment.

    Request help from all experts to extend a solution for the same.

    Regards

    N.Narayana Swamy

    DB:2.61:Multiple Bp Currency And Payments zj


    Hi N.Narayana Swamy,

    you can display the actual LC balance transactions of an MC BP in any currency you have defined, yet all dealings with this type of BP are done in LC. Thus, any bank account involved with this BP should either be LC or MC, it cannot be FC.

    In the set-up you describe, the only solution I see for you is to use an MC interim account then manually transfer the funds to the FC cash account. Please see this note for an example on how to do that:

    Note [1260658|https://service.sap.com/sap/support/notes/1260658] - Transfer monies between different monocurrency accounts

    All the best,

    Kerstin

  • RELEVANCY SCORE 2.61

    DB:2.61:Invoice By E-Mail To Multiple Mail Ids k3



    Hi,

    I have a requirement to send the sales invoice by e-mail to multiple mail id's.

    Mail ids will be maintained in the customer master record -- General Data -- Contact Person TAB.

    Please help me inconfiguring this scenario in detail.

    Thanks

    Parveen

    DB:2.61:Invoice By E-Mail To Multiple Mail Ids k3


    Hi Torben,

    We have maintained multiple mail ids in the contact person tab and no mail id's in the address of the customer master record.

    Thanks

    Parveen

  • RELEVANCY SCORE 2.61

    DB:2.61:Multiple Line Items In Customer Invoice j7



    Hi

    We are using the Correspondence type : SAP19 and Program : RKKORD50 to print the Customer Invoice.

    For Example :

    We have posted the below Customer invoice with multiple line items ( different GL Accounts )

    Customer Account DR 9000

    Sales Revenue1 CR 2000

    Sales Revenue2 CR 3000

    Sales Revenue3 CR 4000

    While printing of customer invoice for that docment it is showing 9000 RS (one line item ) for total document amount but we want the output for all the GL Account aganist the amount

    Please help me to get the output for line item wise for customer invoices.

    Thank

    Risha

    DB:2.61:Multiple Line Items In Customer Invoice j7


    hi, Risha:

    Oh, i think you should check the customizing for Print-out...(Sorry, also, not very familiar with this.) ..About this problem, I think it is better that you post it to the more SD or FI module-professional forum,such as

    SD:SAP ERP Sales and Distribution (SAP SD)

    FI:SAP ERP Financials

    I think maybe there are experts there can give you some precious solution..Good luck.

    Best wishes.

  • RELEVANCY SCORE 2.61

    DB:2.61:Cmr Pricing Issue 71



    During Credit Memo request creation

    - with reference to F2 customer invoice -

    - VA01 transaction

    should be pricing copied from original invoice into CM request without changes.

    This is set up in copy control customizing (spro - TVAF transaction).

    But credit memo request is created with new pricing which is not the same as in the F2 invoice.

    Could you advise where is root cause of new pricing?

    DB:2.61:Cmr Pricing Issue 71


    Hi,

    Please check the Condition record for Condition type being used in the Credit Memo request.If the Prices have been changed, then the system will consider the new pricing.

    Please check let me know.

    Regards,

    MP

  • RELEVANCY SCORE 2.61

    DB:2.61:Posting Customer Returns/Credit fj



    Hi,

    One of our customer has returned the following products and quantities purchased over time on multiple orders:

    Product 1* 10 ea

    Product 2* 12 ea

    Product 3* 18ea

    We need to process returns/customer credit with reference to invoice/billing document. Is it acceptable to process returns of multiple products and quantities, which were charged on multiple invoices against one invoice which does not contain products being returned and /or less quantities? Also, is it acceptable to change quantities?

    For eg, is it acceptable to process customer returns for the customer against Invoice XXXXXX that has the following products with fewer quantities than those returned and a product which is not on the Invoice at all?

    Appreciate quick response.

    Many Thanks//

    DB:2.61:Posting Customer Returns/Credit fj


    Dear Shilpa Baby,

    What i need to point out it that returns will not be happening on a large no of invoices.

    Hence it is always better to advise the Business that the requirement is not a standard practice and to take the return order individually for those respective invoices.

    Thanks Regards,

    Hegal K Charles

  • RELEVANCY SCORE 2.61

    DB:2.61:Generate Multiple Copies Of Same Invoice Using Xml Publisher 9f


    Hello All

    I have a requirement wherein the existing XML report Output should print the same Invoice twice one orginal and one a Customer Copy.

    i.e say Earlier the Invoice was INVOICE-ABC Customer and ran into 3 pages with Page 1 of 3, Page 2 of 3, Page 3 of 3.

    Then now the requirement is to print same once more with a new Heading Invoice Copy- ABC Customer Page 1 of 3, Page 2 of 3 Page 3 of 3.

    Has any one of you faced a similar requirment.

    Suggestions/Inputs would help a lot.

    Thanks!!

    DB:2.61:Generate Multiple Copies Of Same Invoice Using Xml Publisher 9f

    as idea
    create main concurrent and run INVOICE-ABC Customer and Invoice Copy- ABC Customer by
    fnd_request.submit_requestso if you want to use one template and changing Heading for 'COPY' then you can add parameter for invoice concurrent for identify type (copy or not)
    so in parameter not 'COPY' then Heading is 'INVOICE-ABC Customer' else 'Invoice Copy- ABC Customer'

    if you can't change template then copy and change Heading and in main run two concurrents

  • RELEVANCY SCORE 2.61

    DB:2.61:Oracle Bulk Invoice Upload Alongwith Dff And India Locatisation m9


    Hi,

    Would request someone to kindly guide as to how do we upload Bulk Invoices ie. Few hundreds Lines invoices received from a single Vendor, in a excel soft copy in Oracle alongwith DFF information + tagging of India Localisation Information.

    The scenario faced are
    1. Single Vendor, Single Invoice having few hundreds Lines of Information in the distribution.
    2. Single Vendor, Multiple Invoices having Few line of information in the distribution.

    Would appreciate an early response.

    Vicks.

    DB:2.61:Oracle Bulk Invoice Upload Alongwith Dff And India Locatisation m9

    Hi,

    I just like to suggest you that we can use the Dataloader tool.

    "If you have hundreds of records, then DataLoad Classic is a good way of loading the records that you need; if you have thousands of records then DataLoad Professional is the tool to use." - Oracle Metalink Note 421885.1

    for more information: http://www.dataload.com

    Sekar

  • RELEVANCY SCORE 2.61

    DB:2.61:Delivery Related Billing - Multiple Inv Cyc And Ic Billing js



    Hi,

    We are on SAP IS-OG and would like to use invoice cycles to create

    multiple customer billing documents and the corresponding Intercompany

    billing documents with reference to a delivery document.

    We are currently using two invoice cycles and would like to use couple

    more of the available 9 invoice cycles.

    We have a requirement to have few conditions active only on intercompany document for the second intercompany invoice ( Intercompany invoice for the Invoice cycle 2) .

    Here is what we are currently

    doing to create intercompany billing documents for invoice cycle 2

    1) With reference to delivery document- Customer billing document

    F2 ( Invoice cycle 1) is created

    2) With reference to delivery document- Intercompany billing

    document IV is created.

    3) With reference to delivery document- Quality invoice ZQ

    (Invoice cycle 2) is created.

    4) Using output determination and program RVIVAUFT an intercompany

    sales order is created. This sales order is invoiced to create

    intercompany billing document ZIQ (Invoice cycle 2).

    My questions are,

    1) Can Intercompany billing document for invoice cycle 2 be created

    directly with reference to the delivery document as done in the case of

    invoice cycle 1? That is..

    Step 1: Delivery1- Customer Invoice F2- Invoice Cycle 1

    Step 2: Delivery1- Intercompany invoice IV

    Step 3: Delivery1- Customer Invoice ZQ- Invoice Cycle 2

    Step 4: Delivery1- Intercompany Invoice ZIQ

    I am able to run through first 3 steps without any issues but when I try to execute step 4 i get the error message " Delivey is already invoiced".

    2) Are invoice cycles applicable for intercompany documents? If not,

    then is SAP proposing to create one intercompany billing document for

    all the invoice cycles?

    Any help is appreciated.

    Thanks,

    Raj

    DB:2.61:Delivery Related Billing - Multiple Inv Cyc And Ic Billing js


    Hi,

    We are on SAP IS-OG and would like to use invoice cycles to create

    multiple customer billing documents and the corresponding Intercompany

    billing documents with reference to a delivery document.

    We are currently using two invoice cycles and would like to use couple

    more of the available 9 invoice cycles.

    We have a requirement to have few conditions active only on intercompany document for the second intercompany invoice ( Intercompany invoice for the Invoice cycle 2) .

    Here is what we are currently

    doing to create intercompany billing documents for invoice cycle 2

    1) With reference to delivery document- Customer billing document

    F2 ( Invoice cycle 1) is created

    2) With reference to delivery document- Intercompany billing

    document IV is created.

    3) With reference to delivery document- Quality invoice ZQ

    (Invoice cycle 2) is created.

    4) Using output determination and program RVIVAUFT an intercompany

    sales order is created. This sales order is invoiced to create

    intercompany billing document ZIQ (Invoice cycle 2).

    My questions are,

    1) Can Intercompany billing document for invoice cycle 2 be created

    directly with reference to the delivery document as done in the case of

    invoice cycle 1? That is..

    Step 1: Delivery1- Customer Invoice F2- Invoice Cycle 1

    Step 2: Delivery1- Intercompany invoice IV

    Step 3: Delivery1- Customer Invoice ZQ- Invoice Cycle 2

    Step 4: Delivery1- Intercompany Invoice ZIQ

    I am able to run through first 3 steps without any issues but when I try to execute step 4 i get the error message " Delivey is already invoiced".

    2) Are invoice cycles applicable for intercompany documents? If not,

    then is SAP proposing to create one intercompany billing document for

    all the invoice cycles?

    Any help is appreciated.

    Thanks,

    Raj

  • RELEVANCY SCORE 2.61

    DB:2.61:Default Text In Customer Invoice 8z



    Dear All,

    Anybody knows how to save a default text to be shown automatically during Customer Invoice Request creation???

    We've tried with adapt, Personalize, customizing, but we haven't found any option to sabe a default text.

    The only option is save the text in customer notes, but, doesnt' work if you want to create a manual customer invoice instead of a customer invoice based on sales order.

    Thanks in advance!!!!

    DB:2.61:Default Text In Customer Invoice 8z


    Hi Wolfang!!!

    thanks for your answer... Recurring invoice is not a valid solution for our issue, because of customers and dates are differents... so, we can't use a recurring invoice

    Regards,

  • RELEVANCY SCORE 2.60

    DB:2.60:Ap - Validating Multiple Invoice Batches 1d


    Hi,

    Is there a way to validate multiple invoice batches at the same time? The customer currently uses a custom Invoice Validation program that mirrors the seeded program except that it makes Invoice Batch Name a required field. Seeing that the seeded Invoice Validation program doesn't require a batch name, I believe this would validate all batches if left blank.

    Aside from validating all batches, is there a way to select multiple invoice batches to be validated?

    Thanks,
    Chris

    DB:2.60:Ap - Validating Multiple Invoice Batches 1d

    Hi Chris,

    standard functionality of oracle does not allow you to do that ....
    You either validate Invoice batches one by one .... or you execute the Invoice Validation program for all Invoice Batches ....

    However i can suggest an workaround if your are not making use of the Pay Group feature ...
    Pay group is a value that we configure in advance and assign it to the Invoices or the Invoice Batches ....you can see this value as one of the parameter in the Invoice Validation program .....
    This is how the workaround works ...
    1) You create a dummy value for a Paygroup ..
    2) You assign this dummy value to the Invoice Batches that you want to validate ...
    3) Run the Invoice Validation program leaving the Invoice batch name parameter value blank and select the dummy value in the Paygroup field .....
    4) Verify the results ....

    Regards,
    Ivruksha