• RELEVANCY SCORE 3.59

    DB:3.59:Billing Document p9





    How to split one Invoice into Multiple ( Step by Step)?

    DB:3.59:Billing Document p9


    Go to VF01-select "Selection list" and select only those items for which you require to perform invoice.

    This will solve you purpose.

  • RELEVANCY SCORE 3.38

    DB:3.38:Multiple Delivery Into One Invoice 8z





    Dear All

    Issue regarding multiple delivery into one invoice

    1 When i am creating multiple delivery doc into one invoice, its possible for domestic[local sales] but when i am creating multiple delivery doc into one invoice for export it is not possible.

    I have checked with the threads and tried it out with copy control with VBRK/VBRP [001/003/004]

    Is there any specific customization for exports?

    Regards

    Sandeep Bhowmick

  • RELEVANCY SCORE 3.36

    DB:3.36:Multiple Payments Via Oe_Payments_Iface_All sp




    I am unable to load data into the oe_payments_iface_all table with multiple payments for one invoice. I know multiple payments is a new feature, but did Oracle forget to allow the interface tables to process multiple payments? Any docs, advice or information would be greatly appreciated.

    Thanks,
    Chris

    DB:3.36:Multiple Payments Via Oe_Payments_Iface_All sp

    Hi,

    Multiple payments feature is at the order header/line level. For instance, it takes care of down payments that are made at the time of booking the order. Can you please explain at what point/state are you trying to create the payment records?

    Regards,
    Swapna.

  • RELEVANCY SCORE 3.35

    DB:3.35:Invoice 9m



    Hello All ,

    Can any one tell me what will be criteria to club multiple deliveries to One invoice or and having one Delivery one Invoice?? Where can we configure this???

    Thanks

    Sundu

    DB:3.35:Invoice 9m


    hi

    if you want to club multiple deliveries into one bill doc,,,some criteria has to be the same like

    the payer

    billing date

    payment terms

    etc

    when they are the same then you will have no problem in combining multiple del doc into 1 bill doc

    controls will be obviously in the copy controls

    regards

    ravi

  • RELEVANCY SCORE 3.24

    DB:3.24:Ssrs 2005 + Display Multiple Invoices 9x


    Hi,
    I use the following link http://jesborland.wordpress.com/2010/11/17/
    to create SSRS 2005 Invoice report. It is used for only 1 invoice. I used same to show multiple invoices.
    This is how I did:
    The query I used returns the data as:

    InvoiceID

    Invoice Heading

    User

    Desc

    Category

    AccountID

    Amount

    1

    Invoice Changes1

    Robert

    Invoice at JPM

    Personal

    1

    1.00

    1

    Invoice Changes1

    Robert

    Invoice at JPM

    Personal

    2

    2.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    1

    3.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    3

    4.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    4

    5.00

    The above result set contain both invoice header and details.
    I want a report like this:
    Page1:

    Invoice Changes1 (page header)
    User:Robert
    InvoiceID: 1
    Description: Invoice at JPM
    Category:Personal
    Accounts:

    Account

    Amount

    1

    $1.00

    2

    $2.00

    Audit Details:
    Creation Date:
    Created By

    Page footer Here


    Page2:
    Invoice Changes2 (page header)
    User:Robert
    InvoiceID: 2
    Description: Invoice as Check
    Category:Savings
    Accounts:

    Account

    Amount

    1

    $3.00

    3

    $4.00

    4

    $5/-

    Audit Details:
    Creation Date:
    Created By

    Page footer Here


    In other words, each invoice should be displayed in one page. I tried it this way.
    I added list control to the report and placed everything in list. For accounts I added table and dragged account fields on to the table. So table is with in List control. I right clicked on List control -Properties-editGroup Details - General
    tab. I told to group on ‘Invoice ID’ and check the check box for ‘Page break at end’.
    When I run report, the above is shown in 2 pages. But, in second page only account table data is changing. Rest of invoice deails like user, desc etc is remaining same as page 1. So not sure what is happening.
    I appreciate your help.

    DB:3.24:Ssrs 2005 + Display Multiple Invoices 9x

    I was able to fix the issue. In List properties, in addition to the above settings, I set
    On General Tab:
    set datasetname, check the boxes for 'Insert a page break after the list' and 'Fit this list on one page if

    possible'.
    On Edit Details group:
    set group on Expression and Parent group to same field and check checkbox for 'Page break end'.
    This made it work. each invoice on each page and all invoices showed up.

  • RELEVANCY SCORE 3.17

    DB:3.17:Invoice With Combined Deliveries aa



    Hi Experts,

    I am facing one problem while creating invoice with multiple deliveries. System is accepting only one delivery when i save invoice with 2 deliveries.

    even though the sales order is having same PY, Payement terms and billing date.

    can anyone explain the root cause of this.....

    Thanks in advance.

    venkat

    DB:3.17:Invoice With Combined Deliveries aa


    Hi

    Please check whether the Ship to party and chipping point are same for all deliveries.

    Chandru

  • RELEVANCY SCORE 3.12

    DB:3.12:Excise Invoice sp



    Hi

    I want to creat one proforma invoice for multiple deliveries. and with that proforma invoice trying to create single excise invoice.

    But i am facing problem in creating proforma with multiple deliveries because of DIFFERENT NUMBER RANGE IN HEADER (delivery)AT FOREIGN TRADE --- UNDER ORGANIZATION --- NUMBER OF FOREIGN TRADE DATA - ( which is internally assigned by the system)

    If i can get where this number is assign my problem is solved

    Rao

    DB:3.12:Excise Invoice sp


    Hi

    In Copy control Del to billing (VTFL) do setting in the feild "Determ.export data" , use A or B.

    I hope it solves u r problem, Reward if it helps.

    Rajendra

  • RELEVANCY SCORE 3.09

    DB:3.09:Spool Request 31



    Dear all,

    I want to create only one spool request for multiple invoice print from VF31. when i excute the vf31 it generates one spool request for each invoice , i required to generate only one spool request for multiple invoice. How i can generate?Is there any setting for the same.

    Thanks Regards,

    PM

  • RELEVANCY SCORE 3.09

    DB:3.09:Multiple Invoice Against One Gr Should Be Block 18


    hello gurusir i receipt all quantity against po and after that i invoice all material but when user go for invoice against same po the system get allowed again create an invoice.for this i want to block multiple invoice against one gr after completion of po quantity.so,for this what configuration i have to do or mistake in configuration from my side.with regardsrahul

    DB:3.09:Multiple Invoice Against One Gr Should Be Block 18

    Hi,The way is to change all of your Vendor's Master Data:From Vendor MAster Data Payment Transactions Accountingview:The following checkbox must be checked.Chk double inv. (Check Flag for Double Invoices or Credit Memos) (LFB1-REPRF) If they are not checked You can do it with Mass Maintenance VendorsXK99Choose from Tables PartVendor Master (Company Code)LFB1line and from fields tabChk double inv.LFB1-REPRF linethen run it fill in the all vendors you want to changeandput all of them thick.And also while creating new vendors your responsible should pay attention from now on.This is the explanation of the checkbox:Indicator which means that incoming invoices and credit memos are checked for double entries at the time of entry.UseChecking Logistics documentsFirstly, the system checks whether the invoice documents have already been entered in the Logistics invoice verification; the system checks invoices that are incorrect, or invoices that were entered for invoice verification in the background.Hope it helpsBest Regards

  • RELEVANCY SCORE 3.02

    DB:3.02:How To Restrict Posting Of An Invoice Against Po If Invoicing Is Already Done ks



    Hi,

    The scenario is The invoice creation is and parking is being handled via Interface where vendor details , PO Number and invoice amount (Header) is passed.

    I am using bapi_incominginvoice_park to park the invoice.

    For the invoice line items amount and quantity , the calculation is being handled through PO history table : EKBE.

    The Issue is , if the same PO is passed through Interface twice , the Invoice takes into account the amount and quantity again.

    How can i restrict taking into account the quantity and amount already invoiced?

    As i have a workflow attached which is linked with Invoice Park Event : (BUS2081 - Parked) So as soon as an invoice is parked a workflow is triggered and if the balance is within tolerance the invoice gets posted automatically through post bapi..

    Issue is : Multiple invoice can be posted for the same PO which may lead to paying vendor for same PO more than one.

    Would be grateful if someone could guide on how can this situation be avoided.

    DB:3.02:How To Restrict Posting Of An Invoice Against Po If Invoicing Is Already Done ks


    Hi,

    Using BAPI BAPI_PO_GETDETAIL1 you can get the totals of the PO item history (in tables parameter POHISTORY_TOTALS). This contains the total invoiced and delivered quantity and value for a po and for each item. This way you can see if 100% has already been invoiced or not.

    You can also calculate the values yourself, using table EKBE.

    Regards,

    Freek

  • RELEVANCY SCORE 2.99

    DB:2.99:Invoice Multiple Recipients fx



    I would like to send an invoice to multiple recipients, but as far as I can tell it can only go to one email address. Is there a way to send to multiple recipients?

    DB:2.99:Invoice Multiple Recipients fx


    Not that I ahve been able to accomplish. If anyone has a answer, it would be apprecoated.

  • RELEVANCY SCORE 2.98

    DB:2.98:Contract c1



    Hi All

    System is generating different contract Invoice for each Contract sales doc whereas it should create only one Contract Invoice for multiple Contract sales doc

    DB:2.98:Contract c1


    Hi Amol,

    While executing the billing due list please look at the split analysis, this will give you why the invoice are getting split. One of the cases may be because of different partners in the header data of the contract.

    Regards

    raj

  • RELEVANCY SCORE 2.98

    DB:2.98:In Dynamics, Can I Create Multiple Fixed Assets From One Invoice? ca


    In Dynamics, can I create multiple fixed assets from one invoice?

    DB:2.98:In Dynamics, Can I Create Multiple Fixed Assets From One Invoice? ca

    Unfortunately your post is off topic here, in the TechNet Site Feedback forum, because it is not Feedback about the TechNet Website or Subscription.
    You may want to try asking your question at
    http://answers.microsoft.com.

    For more information about where to post your question please see this thread:http://social.technet.microsoft.com/Forums/en-US/tnfeedback/thread/24ee65e4-0f35-403c-9bf7-41333cd13cb5
    Moving to off topic.

    Thanks, MikeMSDN and TechNet Subscriptions Support
    Read the Subscriptions Blog!

  • RELEVANCY SCORE 2.97

    DB:2.97:Printing Multiple Deliveries In One Invoice 8c



    Hi All,

    Could anyone let me know the SAP functionality to print multiple deliveries in one invoice.

    Will award points.

    Thanks

    Stephen

    DB:2.97:Printing Multiple Deliveries In One Invoice 8c


    Hi All,

    Could anyone let me know the SAP functionality to print multiple deliveries in one invoice.

    Will award points.

    Thanks

    Stephen

  • RELEVANCY SCORE 2.97

    DB:2.97:Summarization Of Gl Account (Freight Clearing Account) While Invoice Post ap



    Hi,

    We are creating invoice document for Delivery costs through MIRA and MRBP.

    Reference is Bill of Lading. we having Multiple BOL for same Vendor invoice.

    So once the document is posted. Freight clearing account is coming multiple times.

    we want to Summaries this GL account (one entry req for Freight clearing account)

    we have more no of BOL for one vendor invoice.

    How to achieve this summarization of GL account in invoice processing?

    Best regards,

    Rami Reddy.B

    DB:2.97:Summarization Of Gl Account (Freight Clearing Account) While Invoice Post ap


    hi

    why dont u try to create the MIRa doc with ref of PO or DELIVERY NOTE

    and keep the BOL no in text

    regards

    kunal

  • RELEVANCY SCORE 2.96

    DB:2.96: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 2.96

    DB:2.96:Excise Invoice From Multiple Grpo xm



    Hi,

    How can we create a singe incoming excise invoice from multiple GRPOs? While creating one, when we use the copy from button, it allows to select only one GRPO and not multiple unlike A/P Invoice which can be created from multiple GRPOs.

    Thanks,

    Amol.

    DB:2.96:Excise Invoice From Multiple Grpo xm


    Why do u want to create a singe incoming excise invoice from multiple GRPOs ?

  • RELEVANCY SCORE 2.93

    DB:2.93:Vendor Invoice Note 3c



    When printing an invoice using F.62 sending the invoice to spool, I ma not able to displaymultiple line of the invoice note using document texts. it only displays the first line.

    Can some one clarify me if there is away to print multiple lines on the bottom of the invoice as a note to the vendor on the invoice.

    Any clarifications will be appreciated

    Thank you

    Krishna

  • RELEVANCY SCORE 2.92

    DB:2.92:Gn_Invoice_Create 1m



    Hi All,

    Could anyone tell me if I culd use 'GN_INVOICE_CREATE' Function Module to Create Invoice for Multiple Sales Order ? Or is this FM Only for Invoice Creation for one sales Order ?

    Is there any FM for single invoice creation for multiple sales order ..?

    I will definetly reward points for helpful answers.

    Thanks.

    DB:2.92:Gn_Invoice_Create 1m


    Hi All,

    Could anyone tell me if I culd use 'GN_INVOICE_CREATE' Function Module to Create Invoice for Multiple Sales Order ? Or is this FM Only for Invoice Creation for one sales Order ?

    Is there any FM for single invoice creation for multiple sales order ..?

    I will definetly reward points for helpful answers.

    Thanks.

  • RELEVANCY SCORE 2.92

    DB:2.92:Multiple So Merged Into Do But Only Want 1 Invoice 7k



    Hi guys,

    Currently without much configuration, when we merge 2 SO into 2 Delivery, this is possible through VL10A. However, when I bill, the invoice will be split into 2 as there was 2 SO but we only used in 1 DO.

    Is there any way to force the system to use 1 invoice only regardless how many SO was merged into 1 DO? Any help is much appreciated.

    DB:2.92:Multiple So Merged Into Do But Only Want 1 Invoice 7k


    Hi,

    As for my Understanding multiple SO can we merge and do the delivery through VL10A, VL10C

    Coming to the Billing for Invoice Split

    Kindly Check the Following Link

    http://help.sap.com/saphelp_46c/helpdata/en/dd/560f63545a11d1a7020000e829fd11/content.htm

    Invoice Splitting Criteria

    Question about split invoice

    Regards,

    Prasanna

    Edited by: prasanna_sap on Aug 12, 2011 10:29 AM

  • RELEVANCY SCORE 2.91

    DB:2.91:Link Between Migo And Miro Documents s7



    Hi,

    My client posts one invoice for every goods receipt. However, there are multiple goods receipts for one PO. Now, I need to relate an invoice to goods receipt meaning, I want to be able to find the GR document with reference to the invoice document. Which table and field enable this link?

    Muru

    DB:2.91:Link Between Migo And Miro Documents s7


    Yes, in table EKBE if you put in PO HIstory Category (BEWTP) = Q you can see all your posted Invoices. If you have your POs set to GR-Bsd IV then the Reference field (LFBNR) will populate with the GR number.

  • RELEVANCY SCORE 2.90

    DB:2.90:Smartforms: Dual Page Layout sz



    Hi! All,

    Need help with a smartform issue. We developed custom print program and smartform for printing invoices and one requirement was to print a report at the end of the invoice. Actual invoice is in portrait format but the report needs to be output in landscape. This report could span into multiple pages.

    Creating a new page in landscape format, triggering it at the end of the invoice print and calling it subsequenly doesn't work since the main window has to have the same width on all pages.

    I cannot rename the main window on this page to a different name since a form cannot have multiple main windows.

    How do I go about in doing this?

    If I do call a separate smartform just for the report, can I have the complete data, invoice and the report in one spool request and if so is this the only solution?

    TIA

    Sreedhar Chelamkuri

    DB:2.90:Smartforms: Dual Page Layout sz


    Hi! All,

    Need help with a smartform issue. We developed custom print program and smartform for printing invoices and one requirement was to print a report at the end of the invoice. Actual invoice is in portrait format but the report needs to be output in landscape. This report could span into multiple pages.

    Creating a new page in landscape format, triggering it at the end of the invoice print and calling it subsequenly doesn't work since the main window has to have the same width on all pages.

    I cannot rename the main window on this page to a different name since a form cannot have multiple main windows.

    How do I go about in doing this?

    If I do call a separate smartform just for the report, can I have the complete data, invoice and the report in one spool request and if so is this the only solution?

    TIA

    Sreedhar Chelamkuri

  • RELEVANCY SCORE 2.88

    DB:2.88:Adding Total Per Invoice- Some Have Multiple Lines za


    I am looking for a formula to give the total amount per invoice.
    Some invoices have more than one line.
    Column A invoice #
    Column B Invoice amount
    Column C Total per invoice

    Invoice #

    Billing

    Total

    602

    50.00

    50.00

    159

    75.00

    75.00

    847

    100.00

    847

    100.00

    847

    100.00

    300.00

    510

    80.00

    80.00

    987

    100.00

    100.00

  • RELEVANCY SCORE 2.88

    DB:2.88:Terms And Condition Need To Print Between Pages.. m7


    Hello Folks,

    I am printing invoice for my customers based on customer number.

    Based one customer number, I will print multiple invoices.

    I need to add contract information for each invoice, so I was put the contract information in the trailer page. So the contract information printing after all the invoice printed.
    But I want to print the contract information for each invoice, so pls advice me.

    Ex :-(I dont want to print like this)

    INVOICE 1
    INVOICE 2
    INVOICE 3
    CONTRACT INFORMATION (TERMS AND CONDITION)

    Ex :-(I want to print like this)

    INVOICE 1
    CONTRACT INFORMATION (TERMS AND CONDITION)
    INVOICE 2
    CONTRACT INFORMATION (TERMS AND CONDITION)
    INVOICE 3
    CONTRACT INFORMATION (TERMS AND CONDITION)

    Thanks, Kannan.K

    DB:2.88:Terms And Condition Need To Print Between Pages.. m7

    You have had your solution, add the contact info. after each invoice (frame I guess):

    INVOICE 1
    CONTRACT INFORMATION (TERMS AND CONDITION)
    INVOICE 2
    CONTRACT INFORMATION (TERMS AND CONDITION)
    INVOICE 3
    CONTRACT INFORMATION (TERMS AND CONDITION)

  • RELEVANCY SCORE 2.87

    DB:2.87:Multiple Deliveries Getting Combined Into One Invoice Automatically By Job pa



    Hello All,

    I'm facing issue, multiple deliveries are getting combined in one invoice automatically. The invoices are created by background jobs. It should not combine the multiple deliveries into one invoice ideally as it is being created by background jobs. Could any one please share what might be the cause of it.

    Thanks in advance.

    Regards,

    Sumit

    DB:2.87:Multiple Deliveries Getting Combined Into One Invoice Automatically By Job pa


    Hi

    When you run the dialog or batch billing job the prgram SDBILLDL is triggered.

    It simply reads the billing due index (VKDFS) and retrieves all due documents

    for processing (internal table V60P_INPUT_VKDFIF)

    The program in the standard processes 1000 entries at a time as required

    and if each entry processed passes the split criteria (outlined in note 11162)

    The system could in theory create one invoice for all 1000 entries picked up.

    You see this processing here:

    CALL FUNCTION 'SD_COLLECTIVE_RUN_EXECUTE'

    ...

    LOOP AT V60P_INPUT_VKDFIF WHERE SELKZ NE SPACE.

    ON CHANGE OF V60P_INPUT_VKDFIF-KUNNR OR

    V60P_INPUT_VKDFIF-VKORG OR

    V60P_INPUT_VKDFIF-V_FKART.

    IF COUNTER 0.

    CLEAR SY-CALLD.

    DELETE ADJACENT DUPLICATES FROM XKOMFK.

    PERFORM RV_INVOICE_CREATE

    As you see above, the system tries to bill all entries together

    where the customer, sales org and billing type are the same.

    It will do this 1000 times before it forces a split.

    (you will also notice user exits here which can be used to change this

    outcome)

    Check note 11162 for the details of what header fields will cause a split.

    As outlined previously you could use an item data transfer routine and the field

    ZUKRI to force a split on your own terms.

    Hope this helps explain the system behaviour

    Kind regards

    PERFORM RV_INVOICE_CREATE

  • RELEVANCY SCORE 2.87

    DB:2.87:File Adapter: Multiple Records, Multiple Types To Multiple Db Tables zm


    Hi there,

    I have a proof-of-concept scenario which I am trying to model in ESB:

    I have a single flat file with one invoice header record and multiple invoice lines.
    I want to read this file via the File Adapter, and insert the different records into different database tables: the invoice header in an invoice table, and the invoice lines into a line item table.

    If I tackle the lines in isolation no problem (i.e. single file with only invoice lines in to the invoice lines table). Things break down when I add the invoice header into the mix.

    Does anyone have an example of this or something similar?
    Would I need to use seperate database adapters for the two tables, or is this achievable with a single database adapter?

    Thanks in advance!

    DB:2.87:File Adapter: Multiple Records, Multiple Types To Multiple Db Tables zm

    Thanks for that Abhi.

    I actually tried that, but I'd find that I would only get the header record added properly; the multiple invoice lines would not get written to the invoice line table properly.

    I found that I would either get the same invoice line added many times, or I would get null values.
    I played around with the for-each statement, and I even tried creating my own xsd for the data file (instead of using the native format tool).

    Any ideas what the issue might be?

    Thanks,
    Richard

  • RELEVANCY SCORE 2.87

    DB:2.87:One Performa Invoice From Multiple Performa Invoice(Export Sceanrio) xk



    dear sir,

    in case of export after doing pickup we create performa invoice and after that while creating issue time i want to create single performa invoice from mutiple performa invoice and then single invoice from that performa invoice and should be able to update the pricing so that it will upadte all the documents at that exchange rate.?

    Thanks and regards,

    Debesh Tripathy

    DB:2.87:One Performa Invoice From Multiple Performa Invoice(Export Sceanrio) xk


    Hi

    If you want to restrict the creation of proforma to only once from multiple deliveries try with these settings

    At VTFL under your header del type to proforma type maintain copying requirements 311

    At your item level VBRK/VBRP fields maintain as 001

    at item Copying requrements 010

    single commercial billing document The combination criteria for single billing from multiple deliveries

    1.Payer

    2.Payment terms

    3.Destination country

    4.Actual GI date

    5.Incoterms

    6.Billing date and billing due date

    7.Billing doc type

    All these have to be same

    Only one setting you have to do

    Go to VTFL choose your del type and billing type and go to item category and its details in the data

    VBRK/VBRP fields ensure that 001 is maintained

    If these are ensured create two or three deliveries and bill them via VF04 in a single bill or in VF01 also you have give all the three deliveries manually and create single billing doc

    Try with these settings and post back if any problem

    Regards

    Raja

  • RELEVANCY SCORE 2.86

    DB:2.86:Add Mutliple Records In A Field On A Form pd


    Hello,
    I have an access database which contain a form for user to input the records. For example i have three fields called Invoice No, Request date and Requestor name. Incase if i have only one date and name for one invoice
    then i dont have any problem. But i have multiple records for single invoice number in that case how i can add it to a table .
    If i have multiple records then how it will add it into table as different records for each date and name or do i need to create another table to input these records.
    Kindly help me to solve this issue.

    VinWin06

    DB:2.86:Add Mutliple Records In A Field On A Form pd

    Sorry, I have no idea.Regards, Hans Vogelaar (http://www.eileenslounge.com)

  • RELEVANCY SCORE 2.86

    DB:2.86: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:2.86: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 2.86

    DB:2.86:Single Invoice For Multiple Deliveries a1



    Hi Gurus,

    Can anybody help me in solving issues ,

    That client need only one invoice for Multiple Delivery for a single order.

    thanks and Regards,

    Sunil

    DB:2.86:Single Invoice For Multiple Deliveries a1


    Hello,

    You can do this.

    Enter delivery note number one by one in MIRO

    Take ref of del note

    Press right hand yellow arrow

    there you can enter multiple del note at a time

    You have already mentioned that purchase order is same for all deliveries.

    Hope it helps

    Regards

    Kedar Kulkarni

  • RELEVANCY SCORE 2.85

    DB:2.85:Header Discount xz



    Hi,

    Need advice on how header discount should behave from one Sales Order (one Item) to Multiple Billing of the same Line ltem.

    Currently if SO header has 100Gbp as Header Discount with only line item on the SO and this is split into Multiple Invoice, Header discount of 100GBP is applied to all Invoices, which is Incorrect. Any advice on this is appreciated.

    Thanks

    Veena

    DB:2.85:Header Discount xz


    Hi praveen,

    as mentioned earlier, this value is maintained in PO and get copied to SO header.

    Thanks

    Veena

  • RELEVANCY SCORE 2.85

    DB:2.85:One Invoice For Multiple Deliveries 91



    Hi Gurus,

    Can any one tell how can i create one invoice for multiple deliveries.

    Regards,

    Vinod

    DB:2.85:One Invoice For Multiple Deliveries 91


    Hi Vinod,

    Collective Billing document can be created using the T-code VF04.

    To combine multilpe deliveries in One Invoice,individual delieveries should have the same,

    1)The Billing Date

    2)Bill- to Party.

    3)Payment terms.

    Thanks,

    Umesh.

  • RELEVANCY SCORE 2.84

    DB:2.84:Printing Multiple Copies Of Invoice, Po Etc. s9



    Hi,

    We are not able to print multiple copies of Invoice, PO etc. from SAP.

    e.g. When we print invoice using vf02-issue output, we are setting number of copies to be printed as 5, still only one copy gets printed. Hence, we need to execute the vf02 five times to get five copies of the invoice. Same is the case for PO printing.

    Kindly help.

    With Best Regards,

    Rajkumar

    DB:2.84:Printing Multiple Copies Of Invoice, Po Etc. s9


    No, we are not using front end printing (F/G). When we click on "issue output to" (vf02-Billing Document)), we select the print button and the standard printer dialog for selecting Printer and other settings appears. In this dialog there is option call "Number of Copies". We set it to 5 and after clicking on "OK", only single print gets printed.

    Check if

    Note 3748 - Multiple print does not work everywhere

    helps.

    Markus

  • RELEVANCY SCORE 2.84

    DB:2.84:How To Creat And Post Multiple Excise Invoice. a7



    Dear all,

    we are having excise invoice and commercial invoice creation at single step but we want it to do separately

    what are the steps required for it.

    The second one is we want to create multiple excise invoice at one time.

    so is it possible ???

    Regards

    Subrat

    DB:2.84:How To Creat And Post Multiple Excise Invoice. a7


    Hi Subu sd,

    go to logistics generaltax on goods movementindiabasic settingsMaintain Excise groupsselect your excise groupclick on show detailremove the tick mark from "Excise Inv during Billing"

    this particular tick mark enables your excise invoice creation siumultaneously while you create commercial invoice, once u remove this and save it, system shall not create excise incoice simultaneously while you save a commercial invoice.For bulk creation of excise invoice you can use J1I3 t.code.

    regards,

    US

  • RELEVANCY SCORE 2.82

    DB:2.82:For Using Visual Basic To Write An Excel Spreadsheet da


    Now I face a problem to add the balnk row after one loop is finished.  I want to export multiple invoice. There are many items in each invoice. So i want to add one new row after each invoice.

    DB:2.82:For Using Visual Basic To Write An Excel Spreadsheet da

    It would help to see your code so that we can determine how to implement the Insert. The below code is an example, but you would probably need to adapt it for your code:
    Rows(1:1).Select
    Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
    Paul ~~~~ Microsoft MVP (Visual Basic)

  • RELEVANCY SCORE 2.81

    DB:2.81:Combine Multiple Order In One Delivery jp



    Hi Friends

    Can any one send me solutions for this queries

    1.How to combine multiple order in one Delivery( Step by Step)?

    2.How to Combile multiple delivary into one Billing( Step by Step)?

    3.How to Split one delivery into many( Step by Step)?

    4.How to combine multiple billing into one RV document( Step by

    Step)?

    5.How to split one Invoice into Multiple( Step by Step)?

    Thanks in advance

    DB:2.81:Combine Multiple Order In One Delivery jp


    This is quite possible, combining multiple orders into a single dely. But SAP checks for the following parameters in the order before combining the orders into a single dely:

    Shipping point

    Ship-to party

    Incoterms

    Sales organization.

    The next setting that needs to be taken care is: The customer master - sales area data - Shipping tab page - select the order combination as ticked. This is possible only when the customer agrees for it.

    The third thing is: check the routine assigned to the Combination requirement in Copy control for order to delivery.

    Once all the above is taken care, the system will automatically combine multiple orders into a single dely as long as those orders has a sched.line due for delivery.

    VL04 is deprecated from 4.6, you should use VL10A, VL10B,.... VL10E.

    If you want to split the schedule lines use VL10E.

    You can create one invoice for multiple sales order. However the following fields must be the same across the sales order documents

    1) Billing Date

    2) Payment Terms

    3) Payer

    4) Destination Country

    To choose the fields based on which the invoice can be split go to [VTFA] - select your order and biling document type - select your item category - use the field Data VBRK/VBRP.

  • RELEVANCY SCORE 2.80

    DB:2.80:Combine Items ma


    HI!
    I was wondering if there was anyway to combine multiple wins from the same bidder into one invoice.
    Thanks,
    Rob

    DB:2.80:Combine Items ma

    HI!
    I was wondering if there was anyway to combine multiple wins from the same bidder into one invoice.
    Thanks,
    Rob

  • RELEVANCY SCORE 2.80

    DB:2.80:Adding Multiple Vendor Invoice At Time Miro Transaction 8f



    Dear Experts,

    I am facing a problem whereby the users want to to add hundreds of Vendor Invoices and there corressponding date when at the time of MIRO transaction.

    Currently in standard there is only one field for the Vendor Invoice No and Vendor Invoice Date.

    Please advice as if how to give the provisions to user so that they can enter multiple(20 or 30) vendor invoice no and corresponding vendor Invoice dates at time of creation MIRO Invoice.(T-Code : MIRO)

    Many Thanks In Advance.

    NINAN

    DB:2.80:Adding Multiple Vendor Invoice At Time Miro Transaction 8f


    At MIRO transaction you can post only one invoice. Posting multiple invoices is not possible. SAP did not give that option.

    Try with LSMW or BDC with help of ABAPer

  • RELEVANCY SCORE 2.80

    DB:2.80:How To From More Than One Delivery Note - Conversion Into One Invoice ps



    Dear Experts,

    How to from more than one delivery note - conversion into one invoice?

    Thanks and best regards,

    Wilson Hong

  • RELEVANCY SCORE 2.80

    DB:2.80:How Do You Combine Multiple Auctions Into 1 Invoic... pa


    As multiple items are sold to the same buyer, it seems to take SM forever to combine all auctions for the one buyer. Is there any quicker way to get a combined record # to calculate total shipping price and send 1 invoice? Any help greatly appreciated ........ Ken

    DB:2.80:How Do You Combine Multiple Auctions Into 1 Invoic... pa

    I just invoice them from my sold list. It is very easy, I don't have experience with SM.




  • RELEVANCY SCORE 2.80

    DB:2.80:Single Invoice For Multiple Deliveries mp


    hi friends,its a case of multiple deliveries in single inoice. split analysis shows split due to defferent header data , number of foreign trade data . As far as I know every delivery is bound to have a unique foreign trade data. How can I combine deliveries into one single invoice.My customer, material , order type , delivery type are all the same.Pl. help.regards,rahul

  • RELEVANCY SCORE 2.79

    DB:2.79:Delivery Creation 9d



    Dear Experts

    Our client is into IMC bussiness.

    we are creating sales order with sales BOM and delivering the same item with reference to sales order.

    invoicing the same along with excise invoice.

    the problem is for example in sales BOM he has \

    main item as SPRAY DRYER

    and bom items as CYCLONE, CHAMBER,SHARP ETC.

    to manufacture cyclone there are n number of raw materials.

    while delivering the CYCLONE we are attaching the annexure which contains raw materials to manufacture cyclone.

    The problem comes when the raw materials which he is sending with invoice of chamber along with the annexure which contains raw material.

    he is not able to send the material in one single lorry.

    he has to send in 2 or 3 lorries for which we need to send along with proper invoice and excise invoice.

    since in system we could do delivery for only one item cyclone and billing with excise invoice we can send these documents only with one lorry.

    for other lorries how to send the documents.

    client doesnt want to maintain all those items it BOM.

    even if i create multiple invoice for single delivery system is not allowing to make excise invoice.

    pl give your valuable suggestion

    regards

    AJITH

  • RELEVANCY SCORE 2.78

    DB:2.78:Obia Implementation cj


    Hello :

    Currently working on a OBIA Implementation. Wanted to know how is the data loaded into the W_AR_XACT_F table. I know that all invoices would be part of this table but not sure whether the table should store one record per invoice OR multiple records per invoice.

    Please suggest.

    Thanks
    Satya

    DB:2.78:Obia Implementation cj

    For purposes of this example, records are extracted and loaded into a fact staging table W_AR_XACT_FS. Foreign keys corresponding to the dimension tables are then added to the records, and the transformed records are then loaded into fact table W_AR_XACT_F.

    For this example, the fact table is assumed to have 8 associated dimension tables whose foreign keys are to be inserted into the records in the fact staging table prior to the records being loaded into the fact table. According to the processing depicted in FIG. 2, the dimension tables are sorted based upon the number of records in the tables. Table A shown below depicts the dimension tables sorted in ascending order based upon the number of records (in thousands) in the tables.

    TABLE A

    Sorted Dimension Tables
    Dimension table No of records (000)

    W_ORG_D 15
    W_SUPPLIER_D 35
    W_SUPPLIER_ACCOUNT_D 50
    W_PRODUCT_D 115
    W_SALES_PRODUCT_D 150
    W_INVENTORY_PRODUCT_D 450
    W_GL_ACCOUNT_D 2000
    W_CUSTOMER_LOC_D 5000

    After iteratively outer joining dimension tables with the fact staging table, starting with one with the smallest number of records according to the processing depicted in FIG. 2, it is determined that the first six tables are suitable for outer joins with the fact staging table while the last two tables are not suitable. Lookup transformations may be used to add foreign keys for the last two dimension tables. The final SQL query for joining the fact staging table W_AR_XACT_FS with the first six dimension tables is as follows:

    SELECT /* USE_HASH(W_ORG_D
    W_SUPPLIER_D
    W_SUPPLIER_ACCOUNT_D
    W_PRODUCT_D
    W_SALES_PRODUCT_D
    W_INVENTORY_PRODUCT_D
    W_AR_XACT_FS) */
    W_ORG_D.ROW_WID,
    W_SUPPLIER_D.ROW_WID,
    W_SUPPLIER_ACCOUNT_D.ROW_WID,
    W_PRODUCT_D.ROW_WID,
    W_SALES_PRODUCT_D.ROW_WID,
    W_INVENTORY_PRODUCT_D.ROW_WID,
    W_AR_XACT_FS.GL_ACCOUNT_ID,
    W_AR_XACT_FS.GL_ACCOUNT_ID,
    W_AR_XACT_FS.BUDGT_ORG_ID,
    W_AR_XACT_FS.CUSTOMER_FIN_PROFL_ID1,
    W_AR_XACT_FS.CUSTOMER_FIN_PROFL_ID2,
    W_AR_XACT_FS.TERRITORY_ID,
    W_AR_XACT_FS.SALES_GROUP_ORG_ID,
    W_AR_XACT_FS.CUSTOMER_CONTACT_ID,
    W_AR_XACT_FS.CUSTOMER_SOLD_TO_LOC_ID,
    W_AR_XACT_FS.CUSTOMER_SHIP_TO_LOC_ID,
    W_AR_XACT_FS.CUSTOMER_BILL_TO_LOC_ID,
    W_AR_XACT_FS.CUSTOMER_PAYER_LOC_ID,
    W_AR_XACT_FS.SALES_REP_ID,
    W_AR_XACT_FS.SERVICE_REP_ID,
    W_AR_XACT_FS.ACCOUNT_REP_ID,
    W_AR_XACT_FS.PURCH_REP_ID,
    W_AR_XACT_FS.SUPPLIER_PRODUCT_ID,
    W_AR_XACT_FS.COMPANY_LOC_ID,
    W_AR_XACT_FS.PLANT_LOC_ID,
    W_AR_XACT_FS.AUX3_CHANGED_ON_DT,
    W_AR_XACT_FS.AUX4_CHANGED_ON_DT,
    W_AR_XACT_FS.DATASOURCE_NUM_ID,
    W_AR_XACT_FS.INTEGRATION_ID,
    W_AR_XACT_FS.TENANT_ID,
    W_AR_XACT_FS.X_CUSTOM
    FROM W_AR_XACT_FS
    LEFT OUTER JOIN W_ORG_D
    ON W_AR_XACT_FS.CUSTOMER_ID = W_ORG_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM_ID = W_ORG_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_ORG_D.EFFECTIVE_FROM_DT
    AND W_AR_XACT_FS.POSTED_ON_DT W_ORG_D.EFFECTIVE_TO_DT
    LEFT OUTER JOIN W_SUPPLIER_D
    ON W_AR_XACT_FS.SUPPLIER_ID = W_SUPPLIER_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM ID = W_SUPPLIER_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_SUPPLIER_D.EFFECTIVE_FROM_DT
    AND W_AR_XACT_FS.POSTED_ON_DT W_SUPPLIER_D.EFFECTIVE_TO_DT
    LEFT OUTER JOIN W_SUPPLIER_ACCOUNT_D
    ON W_AR_XACT_FS.SUPPLIER_ACCOUNT_ID = W_SUPPLIER_ACCOUNT_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM_ID = W_SUPPLIER_ACCOUNT_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_SUPPLIER_ACCOUNT_D.EFFECTIVE_FROM_DT
    AND W_AR_XACT_FS.POSTED_ON_DT W_SUPPLIER_ACCOUNT_D.EFFECTIVE_TO_DT
    LEFT OUTER JOIN W_PRODUCT_D
    ON W_AR_XACT_FS.PRODUCT_ID = W_PRODUCT_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM_ID = W_PRODUCT_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_PRODUCT_D.EFFECTIVE_FROM_DT
    AND W_AR_XACT_FS.POSTED_ON_DT W_PRODUCT_D.EFFECTIVE_TO_DT
    LEFT OUTER JOIN W_SALES_PRODUCT_D
    ON W_AR_XACT_FS.SALES_PRODUCT_ID = W_SALES_PRODUCT_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM_ID = W_SALES_PRODUCT_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_SALES_PRODUCT_D.EFFECTIVE_FROM_DT
    AND W_AR_XACT_FS.POSTED_ON_DT W_SALES_PRODUCT_D.EFFECTIVE_TO_DT
    LEFT OUTER JOIN W_INVENTORY_PRODUCT_D
    ON W_AR_XACT_FS.INVENTORY_PRODUCT_ID = W_INVENTORY_PRODUCT_D.INTEGRATION_ID
    AND W_AR_XACT_FS.DATASOURCE_NUM_ID = W_INVENTORY_PRODUCT_D.DATASOURCE_NUM_ID
    AND W_AR_XACT_FS.POSTED_ON_DT = W_INVENTORY_PRODUCT_D.EFFECTIVE_FROM_DT
    ANDW_AR_XACT_FS.POSTED_ON_DT W_INVENTORY_PRODUCT_D.EFFECTIVE_TO_DT

    As can be seen from the above query, the fact staging table W_AR_XACT_FS is outer joined (using LEFT OUTER JOIN) with six dimension tables, namely, W_ORG_D, W_SUPPLIER_D, W_SUPPLIER_ACCOUNT_D, W_PRODUCT_D, W_SALES_PRODUCT_D, and W_INVENTORY_PRODUCT_D.

    The plan for the final query is shown below in Table B. As can be seen from Table B, a hash join is used to implement the outer joins.

    TABLE B

    Execution Plan
    Id Operation Name Rows Bytes TempSpc Cost (% CPU) Time

    0 SELECT STATEMENT 15M 11G 2410K (1) 09:22:24
    * 1 HASH JOIN RIGHT OUTER 15M 11G 2410K (1) 09:22:24
    2 TABLE ACCESS FULL W_PRODUCT_D 10020 420K 81 (3) 00:00:02
    * 3 HASH JOIN RIGHT OUTER 15M 11G 127M2410K (1) 09:22:21
    4 TABLE ACCESS FULL W_INVENTORY_PRODUCT_D 2618K 97M 13724 (2) 00:03:13
    * 5 HASH JOIN RIGHT OUTER 15M 10G 127M1920K (1) 07:28:06
    6 TABLE ACCESS FULL W_SALES_PRODUCT_D 2617K 97M 11408 (2) 00:02:40
    * 7 HASH JOIN RIGHT OUTER 15M 10G 23M 1456K (1) 05:39:56
    8 TABLE ACCESS FULL W_SUPPLIER_ACCOUNT_D 493K 17M 2187 (2) 00:00:31
    * 9 HASH JOIN RIGHT OUTER 15M 9757M 23M 1029K (1) 04:00:14
    10 TABLE ACCESS FULL W_SUPPLIER_D 493K 17M 2700 (2) 00:00:38
    * 11 HASH JOIN RIGHT OUTER 15M 9227M 76M 624K (1) 02:25:41
    12 TABLE ACCESS FULL W_ORG_D 1715K 57M 24909 (3) 00:05:49
    13 TABLE ACCESS FULL W_AR_XACT_FS 15M 8727M 216K (2) 00:50:25

    FIG. 3 is a simplified block diagram of a processing system 300 that may be used to practice an embodiment of the present invention. System 300 may be part of an ETL tier or may also be part of a data warehouse system and may be used to execute SQL queries and lookup transformations. As shown in FIG. 3, system 300 includes a processor 302 that communicates with a number of peripheral devices via a bus subsystem 304 . These peripheral devices may include a memory subsystem 306 , input devices 308 , output devices 310 , and a network interface subsystem 312 . Bus subsystem 304 provides a mechanism for letting the various components and subsystems of system 300 communicate with each other as intended. Although bus subsystem 304 is shown schematically as a single bus, alternative embodiments of the bus subsystem may utilize multiple busses.

    Processor 302 is configured to perform processing performed by system 300 . For example, processor 302 may be configured to execute programs, code, or instructions to perform transformation and load operations according to an embodiment of the present invention. Processor 302 may also control other subsystems or devices.

    Input devices 308 enable a user such as a data warehouse administrator or an ETL process operator to interact with and provide information to system 300 . Input devices 308 may include wired or wireless devices such as a keyboard, pointing devices such as a mouse, trackball, touchpad, or graphics tablet, a scanner, a touchscreen incorporated into the display, audio input devices such as voice recognition systems, microphones, and other types of input devices. In general, an input device may refer to any device or mechanism that may be used for inputting information to system 300 . Input devices 308 typically allow a user to select objects, icons, text and the like that appear on a monitor via a command such as a click of a button or the like.

    Output devices 310 may include wired or wireless devices such as a display subsystem, a printer, a fax machine, or non-visual displays such as audio output devices, etc. Examples of a display subsystem include a cathode ray tube (CRT), a flat-panel device such as a liquid crystal display (LCD), a projection device, etc. In general, an output device may refer to any device or mechanism for outputting information from system 300 . For example, the trace files may be viewed by a user using an output device.

    Network interface subsystem 312 provides an interface to other computer systems, and networks. Network interface subsystem 312 serves as an interface for receiving data from other sources and for transmitting data to other sources from system 300 . Embodiments of network interface subsystem 312 include an Ethernet card, a modem (telephone, satellite, cable, ISDN, etc.), (asynchronous) digital subscriber line (DSL) units, FireWire interface, USB interface, and the like. For example, subsystem 312 may be coupled to a computer network, to a FireWire bus, or the like. In other embodiments, network interface subsystem 312 may be physically integrated on the motherboard of system 300 , and may be a software program, such as soft DSL, or the like.

    Memory subsystem 306 may be configured to store the basic programming and data constructs that provide the functionality of the present invention. For example, a computer program or software code modules (or instructions) implementing the functionality of the present invention may be stored in memory 306 . These software modules may be executed by processor(s) 302 . Memory 306 may also provide a repository for storing data used in accordance with the present invention. For example, memory 306 may store a fact staging table and or a data warehouse.

    Memory 306 may include a number of memories including a main random access memory (RAM) for storage of instructions and data during program execution and a read only memory (ROM) in which fixed instructions are stored. RAM is generally semiconductor-based memory that can be read and written by processor 302 . The storage locations can be accessed in any order. RAM is generally understood to refer to volatile memory that can be written to as well as read. For example, the hash tables used for the outer join operation corresponding to data from a dimension table may be stored in a RAM. There are various different types of RAM.

    Memory 306 may also comprise subsystems that provide persistent (non-volatile) storage and caching for program and data files, and may include a hard disk drive, a floppy disk drive along with associated removable media, a Compact Disk Read Only Memory (CD-ROM) drive, an optical drive such as a DVD, removable media cartridges, flash memory, and other like storage media.

    Processing system 300 can be of various types including a personal computer, a portable computer, a workstation, a network computer, a mainframe, a kiosk, or any other data processing system. Due to the ever-changing nature of computers and networks, the description of system 300 depicted in FIG. 3 is intended only as a specific example for purposes of illustrating the preferred embodiment of a processing system. Many other configurations having more or fewer components than the system depicted in FIG. 3 are possible. For example, the processing system may be a desktop computer, portable computer, rack-mounted or tablet configuration. Additionally, the processing system may be a series of networked computers. Further, the use of different micro processors is contemplated, such as Pentium or Itanium microprocessors; Opteron or AthlonXP microprocessors from Advanced Micro Devices, Inc., and the like. Further, use of different types of operating systems is contemplated, such as Windows, WindowsXP, WindowsNT, or the like from Microsoft Corporation, Solaris from Sun Microsystems, LINUX, UNIX, and the like.

    Although specific embodiments of the invention have been described, various modifications, alterations, alternative constructions, and equivalents are also encompassed within the scope of the invention. Embodiments of the present invention are not restricted to operation within certain specific data processing environments, but are free to operate within a plurality of data processing environments. Additionally, although embodiments of the present invention has been described using a particular series of transactions and steps, it should be apparent to those skilled in the art that the scope of the present invention is not limited to the described series of transactions and steps.

    Further, while embodiments of the present invention has been described using a particular combination of hardware and software, it should be recognized that other combinations of hardware and software are also within the scope of the present invention. Embodiments of the present invention may be implemented only in hardware, or only in software, or using combinations thereof.

    The specification and drawings are, accordingly, to be regarded in an illustrative rather than a restrictive sense. It will, however, be evident that additions, subtractions, deletions, and other modifications and changes may be made thereunto without departing from the broader spirit and scope as set forth in the claims.

  • RELEVANCY SCORE 2.78

    DB:2.78:Is There Any Bapi/Fm To Create Invoice With Multiple Delivery Order? s9


    hi,we have a requirement to combine multiple delivery order into one invoice. please advise is there any Bapi or function available to to do this?thanks.

    DB:2.78:Is There Any Bapi/Fm To Create Invoice With Multiple Delivery Order? s9

    may be i should try this one first .BAPI_BILLINGDOC_CREATEMULTIPLE

  • RELEVANCY SCORE 2.78

    DB:2.78:How Do I Combine Multiple Ebay Auctions To One Buyer On One Invoice? mz


  • RELEVANCY SCORE 2.78

    DB:2.78:Multiple Invoice Is Generating Againest Single Obd c3



    Multiple invoice is generating againest single obd

    DB:2.78:Multiple Invoice Is Generating Againest Single Obd c3


    Hello Manjunath

    Please note the description from the Overview for this SCN Space:

    Official SAP Help Portal Community. Find comments on SAP product documentation (such as SAP Application Help, also known as SAP Library), and read best practices shared by the community.

    Based do the above, I believe you posted your query into the incorrect SCN Space. Please use the Forum Finder for the New SCN document to find your product and post into that SCN Space.

    Also seeing as you did not provide any product information, I would also highly recommend reading the SCN Rules of Engagement.

    With best regards,

    - Ludek

    SCN Moderator

  • RELEVANCY SCORE 2.78

    DB:2.78:Raxinv_Batch cs


    Hi,

    I had converted the AR invoice batch report to xml,and it works great when ordering by transaction number, but when I order by the customer, it would combine multiple invoices under one invoice number and group by the customer. Then I used the template named Inv_pageTot_lastPage.rtf from one of Tim Dexter's articles with my data and got the same results. Has anyone else used this report and run into the same problem and how did you fix it?

    Thanks in advance.
    Thu Nguyen

    DB:2.78:Raxinv_Batch cs

    Hi Cj,

    Thanks for your reply. I've been away the last week. I would appreciate it if you could send me instructions on how you created sub-templates for the different order by. My email is nguyent@metro.net.

    Thanks much.

    Thu

  • RELEVANCY SCORE 2.78

    DB:2.78:Creation Of One Excise Invoice From Multiple Commercial Invoice 3c



    Hi

    Can it possible to create one excise invoice from multiple commercial invoice

    regards,

    K.S.Rao

  • RELEVANCY SCORE 2.77

    DB:2.77:Invoicing Individual Line Items On One Order 7z


    Does anybody know a way to create an order with multiple line items but then just invoice some of them, create another invoice that will pass across just another one item, then another on a third invoice?
     
    At the moment, the create invoice just invoices everything.
     
    Any help would be very useful.
     
    Thanks
    Dave

    DB:2.77:Invoicing Individual Line Items On One Order 7z

    I'm sure that it would be with some custom programming via the SDK.
     
    You would probably want to add some kind of custom attribute to the sales order product to indicate which ones had been invoiced
     

  • RELEVANCY SCORE 2.77

    DB:2.77:How To Find The Invoice Available For Purchase Orders 1a



    Hi friends,

    How to find the Invoice available for PO. Please give me the tcodes also.

    Is one PO can have multiple Invoice, then what is the relation between those PO and Invoices.

    Thanks,

    Veerendra.

    DB:2.77:How To Find The Invoice Available For Purchase Orders 1a


    Goto table EKBE - PO history table. Here you will find all the goods receipts and invoice for a PO. Field VGABE determines the document type. For invoice, VGABE should be 2. Once you display/retrieve a record for your PO, then field BELNR gives you the invoice document number. Now you can equate this BELNR to RBKP-BELNR to get the invoice details.

  • RELEVANCY SCORE 2.77

    DB:2.77:Multiple Incoming Payments For The Same Invoice 8m



    My client has an unusual situation. They are running SAP B1 version 8.8. They receive multiple incoming checks for payment against the same invoice. They receive them each month, so this is not a situation where they receive installments against the same invoice. They want to enter the multiple checks into one Payment Means document, but when they start a new row, the Due Date increments to the next month. This will cause them to change the date on all but the first row in the Payment Means form. Is there a way to prevent the Due Date from incrementing to the next month?

    DB:2.77:Multiple Incoming Payments For The Same Invoice 8m


    Gordon,

    Thank you for your suggestion. It worked just like I wanted.

    Bill

  • RELEVANCY SCORE 2.77

    DB:2.77:Smartform For Combined Invoice px


    Hi,I have to develop a smart form for Combined invoice(Multiple orders into one Invoice).I have already developed a smartform for Invoice(One order,One Invoice) by copying the LB_BIL_INVOICE smartform and RLB_INVOICE program.Is the same things will work for combined Invoice also?or Is there any other way to develop this? If any body done the same..Please guide me..Thanks,Omkaram.

    DB:2.77:Smartform For Combined Invoice px

    Hi,Normally you'd use invoice lists to combine multiple invoices on a single invoice. I don't think there is a standard Smartform for invoice lists, I've copied the Sapscript program RVADIL01 and the invoice smartform in the past to achieve this.Darren

  • RELEVANCY SCORE 2.76

    DB:2.76:Missing Functionality.Draw Document Wizard - Delete/Add Rows And Copy/Paste d9



    Scenario:

    My customer is using 2007 SP0 PL47 and would like the ability to change the sequence of the rows of the draw document wizard and delete/add multiple rows (i.e. when you create an AR Invoice copied from several deliveries).

    This customer requires the sequence of items on the AR invoice to be consistent with the sequence on the original sales order including text lines and subtotals. Currently we cannot achieve this when there are multiple deliveries.

    Steps to reproduce scenario:

    1.Create a Sales order with several items and use text lines, regular and subtotals.

    2.Create more than one delivery based on the sales order and deliver in a different sequence than appears on the sales order.

    3.Open an AR Invoice and u2018Copy fromu2019 Deliveries. Choose multiple deliveries. Choose u2018Customizeu2019.

    4.Look at the sequence of items on the Invoice. How can the items and subtotals and headings be moved around so they appear in the same sequence as on the sales order?

    Current Behaviour:

    In SAP B1 itu2019s not possible to delete or add more than one row at a time on the AR Invoice or Draw Document Wizard.

    Itu2019s not possible to copy/paste a row on the AR Invoice or Draw Document Wizard.

    Itu2019s not possible to change the sequence of the rows using the Draw Document Wizard.

    Business Impact: This customer is currently spending a lot of time trying to organize the AR invoice into a presentable format. They have to go through the invoice and delete the inapplicable rows one by one (because SAP B1 does not have the ability to delete multiple lines at a time) and also has to manually delete re-add rows to make it follow the same sequence as the sales order.

    Proposals:

    Enable users to delete or add more than one row at a time on the AR Invoice or Draw Document Wizard.

    Enable users to copy/paste rows on the AR Invoice or Draw Document Wizard.

    DB:2.76:Missing Functionality.Draw Document Wizard - Delete/Add Rows And Copy/Paste d9


    Scenario:

    My customer is using 2007 SP0 PL47 and would like the ability to change the sequence of the rows of the draw document wizard and delete/add multiple rows (i.e. when you create an AR Invoice copied from several deliveries).

    This customer requires the sequence of items on the AR invoice to be consistent with the sequence on the original sales order including text lines and subtotals. Currently we cannot achieve this when there are multiple deliveries.

    Steps to reproduce scenario:

    1.Create a Sales order with several items and use text lines, regular and subtotals.

    2.Create more than one delivery based on the sales order and deliver in a different sequence than appears on the sales order.

    3.Open an AR Invoice and u2018Copy fromu2019 Deliveries. Choose multiple deliveries. Choose u2018Customizeu2019.

    4.Look at the sequence of items on the Invoice. How can the items and subtotals and headings be moved around so they appear in the same sequence as on the sales order?

    Current Behaviour:

    In SAP B1 itu2019s not possible to delete or add more than one row at a time on the AR Invoice or Draw Document Wizard.

    Itu2019s not possible to copy/paste a row on the AR Invoice or Draw Document Wizard.

    Itu2019s not possible to change the sequence of the rows using the Draw Document Wizard.

    Business Impact: This customer is currently spending a lot of time trying to organize the AR invoice into a presentable format. They have to go through the invoice and delete the inapplicable rows one by one (because SAP B1 does not have the ability to delete multiple lines at a time) and also has to manually delete re-add rows to make it follow the same sequence as the sales order.

    Proposals:

    Enable users to delete or add more than one row at a time on the AR Invoice or Draw Document Wizard.

    Enable users to copy/paste rows on the AR Invoice or Draw Document Wizard.

  • RELEVANCY SCORE 2.76

    DB:2.76:Tolerance Limits: Multiple Invoices For Single Pos, Single Invoices For Multiple Pos dx



    Hi,

    I'm currently looking at tolerance limit configurations, primarily the DQ (Quantity) and PP (Price) tolerance keys and had a couple of questions where you have the scenario of multiple invoices or multiple POs.

    1. If I had multiple invoices for a single PO, collectively they match the quantity and price on the PO; When I enter the first invoice into SAP it will be well below the lower price and quantity limit of the PO as it is one of multiple invoices to be entered. My question is what happens to the invoices in SAP, do you still post them despite the error message and they are just blocked until collectively the invoices match the quantity/price of the PO?

    2. If I had an invoice that related to multiple POs, when entering the invoice can I link this to multiple POs?

    DB:2.76:Tolerance Limits: Multiple Invoices For Single Pos, Single Invoices For Multiple Pos dx


    Hi,

    I'm currently looking at tolerance limit configurations, primarily the DQ (Quantity) and PP (Price) tolerance keys and had a couple of questions where you have the scenario of multiple invoices or multiple POs.

    1. If I had multiple invoices for a single PO, collectively they match the quantity and price on the PO; When I enter the first invoice into SAP it will be well below the lower price and quantity limit of the PO as it is one of multiple invoices to be entered. My question is what happens to the invoices in SAP, do you still post them despite the error message and they are just blocked until collectively the invoices match the quantity/price of the PO?

    2. If I had an invoice that related to multiple POs, when entering the invoice can I link this to multiple POs?

  • RELEVANCY SCORE 2.76

    DB:2.76:Excise Invoice z7



    Dear Gurus,

    In one of my case there will be one excise invoice and multiple goods receipt. For that i set Multiple Goods Receipt Single Credit. When i am refering the same excise invoice following error coming

    All items in the excise invoice NALCO14 29.10.2007 of vendor 84 has been received

    Message no. 8I474

    Diagnosis

    The total challan quantity in this excise invoice has been received

    against GR's. Further GR with reference to this challan is not possible.

    Procedure

    Provide a different excise invoice

    Please suggest a solution.

    Regards,

    Rohan

    DB:2.76:Excise Invoice z7


    Dear Gurus,

    In one of my case there will be one excise invoice and multiple goods receipt. For that i set Multiple Goods Receipt Single Credit. When i am refering the same excise invoice following error coming

    All items in the excise invoice NALCO14 29.10.2007 of vendor 84 has been received

    Message no. 8I474

    Diagnosis

    The total challan quantity in this excise invoice has been received

    against GR's. Further GR with reference to this challan is not possible.

    Procedure

    Provide a different excise invoice

    Please suggest a solution.

    Regards,

    Rohan

  • RELEVANCY SCORE 2.76

    DB:2.76:App Error ss



    Hi,

    In F110 automatic payment run, 5 document or Invoices are taken for proposal run for the total amount SGD 300650.69.

    Among the 5 invoice, one invoice is SGD82268.62( doc no 10000001).

    The issue is this particular document 10000001or invoice is splitting by mistakenly into 6 lines in the proposal.Rest of the four document is proposing in thr proper format

    Actual Invoice contains only two line items. Expense and Vendor.

    But In proposal its split like below

    25934.4025997.6523674.024194.402295.154173
    _____________________
    Total 86268.82
    ________________

    Document is splitting into multiple but the total of the proposal is matching with the invoice amt.

    Can anybody sort my problem.

    DB:2.76:App Error ss


    Hi Madhusudanan,

    Check Vendor Master "Individual Payment" is checked or not. You can uncheck this option and try again.

    Assign point if helpful.

    Thanks,

    Mir

  • RELEVANCY SCORE 2.76

    DB:2.76:Multiple Freight Items From Scd To Customer Invoice xz



    Dear Experts,

    I'm currently setting up a new shipment cost / freight invoicing process for my client, and I have wonder how I can integrate several freight items into one customer invoice.

    I followed the SAP Standard Customizing, creating the same condition type in the Shipment Cost Pricing Procedure and the sales pricing procedure.

    This works fine as long as my SCD has only one Item Category, but for shipments with multiple stages I have more than one.

    In this case, SAP will only pull one rate into the customer invoice.

    Is there a way to have SAP pull the sum of all my items of the SCD?

    Many thanks for your help,

    best regards

    Oliver

    DB:2.76:Multiple Freight Items From Scd To Customer Invoice xz


    Hi,

    that's what I thought I need to do, that will be quite some rework then, but ok.

    Thanks for your help,

    Oliver

  • RELEVANCY SCORE 2.76

    DB:2.76:Delivery And Invoice f3



    Dear Experts

    Our client is into IMC bussiness.

    we are creating sales order with sales BOM and delivering the same item with reference to sales order.

    invoicing the same along with excise invoice.

    the problem is for example in sales BOM he has \

    main item as SPRAY DRYER

    and bom items as CYCLONE, CHAMBER,SHARP ETC.

    to manufacture cyclone there are n number of raw materials.

    while delivering the CYCLONE we are attaching the annexure which contains raw materials to manufacture cyclone.

    The problem comes when the raw materials which he is sending with invoice of chamber along with the annexure which contains raw material.

    he is not able to send the material in one single lorry.

    he has to send in 2 or 3 lorries for which we need to send along with proper invoice and excise invoice.

    since in system we could do delivery for only one item cyclone and billing with excise invoice we can send these documents only with one lorry.

    for other lorries how to send the documents.

    client doesnt want to maintain all those items it BOM.

    even if i create multiple invoice for single delivery system is not allowing to make excise invoice.

    pl give your valuable suggestion

    regards

    DB:2.76:Delivery And Invoice f3


    Dear Experts

    Our client is into IMC bussiness.

    we are creating sales order with sales BOM and delivering the same item with reference to sales order.

    invoicing the same along with excise invoice.

    the problem is for example in sales BOM he has \

    main item as SPRAY DRYER

    and bom items as CYCLONE, CHAMBER,SHARP ETC.

    to manufacture cyclone there are n number of raw materials.

    while delivering the CYCLONE we are attaching the annexure which contains raw materials to manufacture cyclone.

    The problem comes when the raw materials which he is sending with invoice of chamber along with the annexure which contains raw material.

    he is not able to send the material in one single lorry.

    he has to send in 2 or 3 lorries for which we need to send along with proper invoice and excise invoice.

    since in system we could do delivery for only one item cyclone and billing with excise invoice we can send these documents only with one lorry.

    for other lorries how to send the documents.

    client doesnt want to maintain all those items it BOM.

    even if i create multiple invoice for single delivery system is not allowing to make excise invoice.

    pl give your valuable suggestion

    regards

  • RELEVANCY SCORE 2.76

    DB:2.76:How To Process Multiple Grn Against One Excise Invoice df



    Hi All,

    My client receiving one excise invoice against multiple GRNs.

    How to post one excise invoice against all GRNs by Tcode J1IEX.

    Please provide the soluation ASAP.

    Thanks in advance

    sai

    DB:2.76:How To Process Multiple Grn Against One Excise Invoice df


    Hi All,

    My client receiving one excise invoice against multiple GRNs.

    How to post one excise invoice against all GRNs by Tcode J1IEX.

    Please provide the soluation ASAP.

    Thanks in advance

    sai

  • RELEVANCY SCORE 2.75

    DB:2.75:Concat Of 1 Field And Multiple Link j3



    i have table as following:
    CLIENT INVOICE112341432113321245642414521235

    I want to concat fiel Invoice in one field, and when i click, i can open a hyper link of each Invoice , like this

    CLIENT concat(INVOICE)11234; 4321; 332124564; 4145; 1235

    How to do

    DB:2.75:Concat Of 1 Field And Multiple Link j3


    Great. Have you managed to solve the issue? If yes, please can you close this thread by marking answers and/or helpful answer?

    Thanks,

    DV

    www.QlikShare.com

  • RELEVANCY SCORE 2.75

    DB:2.75:Two Invoice Created Against One Delivery T-Code Vf01 j7



    Hi,

    I got strange scenario that against one delivery containing multiple line items two different invoice created during normal sales process , First invoice with some line item and another invoice contains rest of the item.

    Both the invoices is of same billing type.

    We want one invoice against the delivery.

    Help to resolve the problem

    Thanks in advance for your valuable time and effort

    Regards

    Praveen

    DB:2.75:Two Invoice Created Against One Delivery T-Code Vf01 j7


    In your items any of the business items(payment terms,inco terms) differ due to which the invoice can split.

    regards

  • RELEVANCY SCORE 2.75

    DB:2.75:How To Select Multiple Incoming Excise Invoices When I Making Outgoing Excise Invoice. kf



    Hi Experts,

    I want to select Multiple incoming excise invoices at a time when i making Outgoing Excise invoice.

    in short i want to clear all the incoming excise invoices with payment of only one Outgoing Excise Invoice.

    Please Help Me Regarding this...

    THANKS

  • RELEVANCY SCORE 2.74

    DB:2.74:Creating Sql Stored Procedure For Muliple Line Items And Single Header Sending By Biztalk c3


    Hi,
    I have a requirement like this
    My input schema is
    Header
    Invoice ID
    Client Name
    /Header
    LineItems
    LineItems1
    LineItems2
    /LineItems

    single invoice have multiple line items and the procedure insert the data into tables for one invoice and have collection of line items .
    my question is how to create stored procedure for this

    DB:2.74:Creating Sql Stored Procedure For Muliple Line Items And Single Header Sending By Biztalk c3

    You can create an object that represents the entire message. Pass this object (Serialize the message in BizTalk into an object) into your SP where you use the same class definiton to run through the various lineitems and insert. The whole SP will be executed
    within the transaction scope but the logic of using the object and calling multiple inserts will be the responsibility of the SP. The SP will have to work in the transaction scope created by BizTalk.
    OR
    Create multiple SP (one for the Header one for lineitems) and call them within the orchestration enclosed within a transaction scope with appropriate exception/error handling.
    Regards.

  • RELEVANCY SCORE 2.74

    DB:2.74:How To Process Multiple Grn Against One Excise Invoice pp



    Hi All,

    My client receiving one excise invoice against multiple GRNs.

    How to post one excise invoice against all GRNs by Tcode J1IEX.

    Please provide the soluation ASAP.

    Thanks in advance

    sai

  • RELEVANCY SCORE 2.74

    DB:2.74:Multiple Pages In Smartform For Invoice With Header Item Details ps



    Hi All,

    I have two internal tables which are exported to Smartform

    1. Header details of invoice

    2. Item details of invoice with EXNUM as link with Header Table

    Now, I have created multiple secondary windows templates for Header data, One Main window with Table for Item data in my Smart form.

    I am not able to print all Invoice data in multiple pages at a a time. Only first Invoice is printing.

    My requirement:

    I want to print Multiple Invoices in one print.

    That means, after execution I am able to see one Invoice only, even though I have multiple invoice numbers in my header item tables.

    My smart form current data.

    Page1

    secondary window1(Header Internal Table )

    Template with read index increment

    secondary window2(Header Internal Table )

    Template

    secondary window3(Header Internal Table )

    Template

    Main Window

    TABLE (with Loop on Item Internal Table key field is EXNUM)

    DB:2.74:Multiple Pages In Smartform For Invoice With Header Item Details ps


    Hi All,

    I have two internal tables which are exported to Smartform

    1. Header details of invoice

    2. Item details of invoice with EXNUM as link with Header Table

    Now, I have created multiple secondary windows templates for Header data, One Main window with Table for Item data in my Smart form.

    I am not able to print all Invoice data in multiple pages at a a time. Only first Invoice is printing.

    My requirement:

    I want to print Multiple Invoices in one print.

    That means, after execution I am able to see one Invoice only, even though I have multiple invoice numbers in my header item tables.

    My smart form current data.

    Page1

    secondary window1(Header Internal Table )

    Template with read index increment

    secondary window2(Header Internal Table )

    Template

    secondary window3(Header Internal Table )

    Template

    Main Window

    TABLE (with Loop on Item Internal Table key field is EXNUM)

  • RELEVANCY SCORE 2.74

    DB:2.74:Breaking A Single Spool Request Into Multiple Spool Requests cz



    Hi All,

    I have a single spool request which contains sap-script output of 100 invoices (One Invoice on one page , therefore, total 100 pages). I need to create 100 spools (One spool for each invoice). Can u please advise how can I read the sap-script output of the spool request which contains 100 invoices into an internal table and then loop at that internal table to create separate spool for each invoice .

    Please help me out .

    DB:2.74:Breaking A Single Spool Request Into Multiple Spool Requests cz


    Hi Manish,

    You can make use of these FMs RSPO_RETURN_ABAP_SPOOLJOB or RSPO_RETURN_ABAP_SPOOLJOB_RW .

    They are helpful in splitting the spools. It splits the spool document wise.

    Hope it helps.

    Thanks,

    Daya

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

    DB:2.73:Mails Are Still In Approval's Inbox After Approving The Invoice p1



    Hi All,

    I have created one invoice. It has gone to approver's inbox for approval. Approver approved the invoice. Invoice is still in approver's in box after approving the invoice.

    Please look into this issue.

    Thanks and regards,

    Ravi Vruddhula

    DB:2.73:Mails Are Still In Approval's Inbox After Approving The Invoice p1


    Hi,

    Please check the document status and Workitem-ID in transaction BBP_PD.

    Copy the Workitem-ID in transaction SWI1. You can see the workflow log. Is there any error ?

    Regards,

    Masa

  • RELEVANCY SCORE 2.73

    DB:2.73:Freight Posting In Miro Based Upon Multiple Goods Receipt. jp



    Hi

    In one of the companies they are requesting the freight charge to be broken into multiple lines (based upon multiple goods receipt) instead of one consolidated balances in the invoice (MIRO). Right now each time we do a MIGO against the same PO the system creates a seperate material document and the entry is (and that is correct) :

    Inventory - XXXX

    GR/IR (Cost)- XXXX

    GR/IR (Freight) XXXX

    PPV XXXX

    for example if migo is done 3 times against the same PO the system posts 3 seperate material document and everything is correct.

    When we do a MIRO the system generates 3 seperate lines for GR/IR (Cost) but it consolidates GR/IR(freight) and posts the entire value in one line.

    Requirement is : We want the system to break freight cost into 3 seperate in the invoice.

    Did anyone come across this issue before.

    Thanks

    Joseph

    DB:2.73:Freight Posting In Miro Based Upon Multiple Goods Receipt. jp


    Hi Joseph,

    I guess you can use MIRO 3 times, and post separated delivery costs into 3 freight invoices.

    During each time, you can choose only 1 line to carry out the posting.

    Thanks and regards,

    Polly

  • RELEVANCY SCORE 2.73

    DB:2.73:Multiple Credit Memo For An Ar Invoice zm



    Questions:

    1.) Is it possible for an AR Invoice to have more than one AR Credit Memo?

    2.) Is it possible for a "PAID" AR Invoice to still have a AR Credit Memo?

    3.) Lastly, is it possible for an AR Invoice to reduce its amount "PER ITEM" by AR Credit Memo?

    Thanks,

    DB:2.73:Multiple Credit Memo For An Ar Invoice zm


    Hi Joel,

    For Question no. 1 and 3 If you meant reversal of an A/R Invoice without reverasl of stock then it's not possible in SAP B1. The A/R credit memo reverses both stock and amount.

    For Question no. 1 can you give me more details about the scenario ...I will see what I can do.

    Nagesh.

  • RELEVANCY SCORE 2.73

    DB:2.73:Vendor Payment Term m3



    Hi All,

    How to configure the following Vendor Payment term?

    Business requirement:

    We require vendor payment term with multiple cash discount days option. Standard SAP provides 2 discount days option, but we require more than 20 discount options within one payment term.

    Following is the example of a payment term, which requires multiple discount options as shown.

    Payment Date Baseline = Vendor Invoice Date

    1% 10 days Net 30 days from date of invoice

    0.95% 11 days Net 30 days from date of invoice

    0.90% 12 days Net 30 days from date of invoice

    0.85% 13 days Net 30 days from date of invoice

    0.80% 14 days Net 30 days from date of invoice

    0.75% 15 days Net 30 days from date of invoice

    0.70% 16 days Net 30 days from date of invoice

    0.65% 17 days Net 30 days from date of invoice

    0.60% 18 days Net 30 days from date of invoice

    0.55% 19 days Net 30 days from date of invoice

    0.50% 20 days Net 30 days from date of invoice

    0.45% 21 days Net 30 days from date of invoice

    0.40% 22 days Net 30 days from date of invoice

    0.35% 23 days Net 30 days from date of invoice

    0.30% 24 days Net 30 days from date of invoice

    0.25% 25 days Net 30 days from date of invoice

    0.20% 26 days Net 30 days from date of invoice

    0.15% 27 days Net 30 days from date of invoice

    0.10% 28 days Net 30 days from date of invoice

    0.05% 29 days Net 30 days from date of invoice

    Net 30 days from date of invoice

    Best Regards,

    Siva

    DB:2.73:Vendor Payment Term m3


    Hi,

    This is one single payment term.

    Example: Material "ABCD" - Qty 1 EA @ USD100 is ordered and received from vendor. In the PO, this payment term is mentioned. Hence the discount offered by the vendor is based on when the payment is made.

    If payment is made on the 30th day from the date of invoice, it is due net. For each day prior to 30, the discount increases. Hence the earlier the payment is made the higher the discount.

    If the invoice date is 01-Sep-07, the following table shows the discount based on payment date:

    Discount %Payment DateDiscount Amount

    1.00 % 10Days from Invoice date10-Sep-07 1.00

    0.95 % 11Days from Invoice date11-Sep-07 0.95

    0.90 % 12Days from Invoice date12-Sep-07 0.90

    0.85 % 13Days from Invoice date13-Sep-07 0.85

    0.80 % 14Days from Invoice date14-Sep-07 0.80

    0.75 % 15Days from Invoice date15-Sep-07 0.75

    0.70 % 16Days from Invoice date16-Sep-07 0.70

    0.65 % 17Days from Invoice date17-Sep-07 0.65

    0.60 % 18Days from Invoice date18-Sep-07 0.60

    0.55 % 19Days from Invoice date19-Sep-07 0.55

    0.50 % 20Days from Invoice date20-Sep-07 0.50

    0.45 % 21Days from Invoice date21-Sep-07 0.45

    0.40 % 22Days from Invoice date22-Sep-07 0.40

    0.35 % 23Days from Invoice date23-Sep-07 0.35

    0.30 % 24Days from Invoice date24-Sep-07 0.30

    0.25 % 25Days from Invoice date25-Sep-07 0.25

    0.20 % 26Days from Invoice date26-Sep-07 0.20

    0.15 % 27Days from Invoice date27-Sep-07 0.15

    0.10 % 28Days from Invoice date28-Sep-07 0.10

    0.05 % 29Days from Invoice date29-Sep-07 0.05

    (0.00) % 30Days from Invoice date30-Sep-07 (0.00)

    Best Regards,

    Siva

  • RELEVANCY SCORE 2.73

    DB:2.73:Multiple Residuals For One Invoice sa



    HI

    Is it possible to either split a residual into multiple residuals, or create more than one residual against one invoice?

    Thanks for your help

    T

    DB:2.73:Multiple Residuals For One Invoice sa


    Not sure whether you have already tried this. Use the distribute difference function to split a residual to multiple residual lines.

    Using the difference distribute screen you can enter different line amounts and once posted the original will be cleared and the new line(s) will be created as open item.

  • RELEVANCY SCORE 2.72

    DB:2.72:One Proforma With Multiple Deliveries sz



    hi

    what is the T.code for creating one proforma invoice with multiple deliveries

    k.s.rao

    DB:2.72:One Proforma With Multiple Deliveries sz


    Hi,

    go to vf01 and give the delivery numbers. note, the standard billing type used for pro-forma invoices is F8.

    cheers,

    anil.

  • RELEVANCY SCORE 2.72

    DB:2.72:Multiple Prompt Options On One Report? 8z



    Post Author: Cathy

    CA Forum: WebIntelligence Reporting

    I want to define two sets of prompts and have the user choose one set to use. For example:

    I want the user to either fill in : Invoice Prefix and Invoice Number OR Invoice Date.

    I can default Invoice Prefix and Number to wildcards, but this doesn't work with a date.

    Can I do this?

    DB:2.72:Multiple Prompt Options On One Report? 8z


    Post Author: masifhafeez

    CA Forum: WebIntelligence Reporting

    Same problem here;

    In my report there are two prompts; Date and Time Range. I want the user to enter either one value: Date or Time.

    If I give Date only for example then the OK button get disabled.

    Please help us out.

  • RELEVANCY SCORE 2.72

    DB:2.72:Multiple Accounts 7j



    if you have more than one account how do you go from account to account so you can see each invoice

    DB:2.72:Multiple Accounts 7j


    Good evening,

    The information you are looking for is here:

    Linking Accounts in My Account

    Cheers

    Jeff

  • RELEVANCY SCORE 2.72

    DB:2.72:Enter Multiple Invoice Number c7



    Hi all,

    On screen FB60, users want to enter multiple invoice numbers (amount should be entered as a lump sum on Field Amount). Actually, we are using the field Reference to input one single invoice number. How can I capture multiple invoice numbers in one transaction/step only?

    Thanks for your help.

    Nas

    DB:2.72:Enter Multiple Invoice Number c7


    Please note this is not what this transaction is for. A single invoice should have a single reference.

    Can you provide the reason why you want a single accounting document to have many invoices?

    You could use t code FB01, and have many vendor line item postings, and use the allocation field at line item level to store the invoice number.

  • RELEVANCY SCORE 2.72

    DB:2.72:Incoming Excise Invoice::Whats The Meaning Of Multiple Gr Multiple Credits? f7



    Hello CIN Experts ,

    Pls clarify with an eg if possible of multiple GR multiple credits in case of incoming excise invoices .

    Does that mean that i can have the same invoice no. in more than one GR ??

    If so ..... whenever i try to post the second GR with the same vendor excise invoice number .. the system says " an excise invoice already exists for the same vendor."

    What is the functionality of the so called multiple GR multiple credits

    Rgds

    Anis

    DB:2.72:Incoming Excise Invoice::Whats The Meaning Of Multiple Gr Multiple Credits? f7


    hi

    goods receipts can be done in multiples and you can have multiple credit for the same purchase order.

  • RELEVANCY SCORE 2.71

    DB:2.71:Parent Entity: Pulling Values Into Other Fields As A Given Lookup Is Populated (Javascript In Crm 2011) mc


    Hello,
    I
    posted this question in the wrong forum (it is really a CRM dev question) and I no longer can delete the original post, so my apoligies for posting it twice.

    I created a custom entity with a N:1 parent relationship with invoice, and I would like to pull values from the parent (invoice) automatically with javascript. Here is the background:
    I created an entity called Instalment. Invoices can have multiple instalments.
    One of the fields for instalment is Invoice ID (a lookup), which allow users to select the invoice record with which the instalment will relate to.
    I would also would like to add a Client ID (a lookup pointing to account or contact), and a Opportunity Id (pointing to anopportunity). The idea is to have both Client Id and Opportunity Id to be pulled from the related Invoice. as soon as the Invoice
    Id is populated. Here is an example:

    I have a client calledACME I have an opportunity registered for client ACME calledRed Balloons
    I open the Red Ballons opportunity and I create an invoice Now I select Instalment from under sales in the navigation pane and I click on New Instalment
    The form for creating the new instalment appears I click on theParent Invoicelookup field and I select the invoice I created on point 3
    As soon as I select theParent Invoice, the lookup fieldsOpportunity IdandClient Idare automatically populated with the values fetched from the related invoice record

    Does this make sense? The idea is for theOpportunity IdandClient Idin the Instalment main form to be read-only fields. They can only be populated automatically by selecting the Parent Invoice. However
    I have no idea how to pull values like this. :(
    thanks in advance for the help!
    P.

    DB:2.71:Parent Entity: Pulling Values Into Other Fields As A Given Lookup Is Populated (Javascript In Crm 2011) mc

    Hi,
    please follow this link: http://xrmxtensibles.wordpress.com/dynamics-rm/
    MSCRM 4.0 for Filtered Lookups:
    Filtered Lookup is to display the related entities information when you click the Lookup button on the form, you can achieve this in different methods in MS CRM. Filtered Lookups are available in Ms CRM 5.0/2011

    Using JS Code
    http://advantageworks.blogspot.com/2008/02/pseudo-filtered-lookup-dialog-in.html

    Change lookupsingle.aspx page
    http://crm.georged.id.au/post/2008/02/16/Filtering-lookup-data-in-CRM-4.aspx

    Writing plugin.
    http://mscrmfilteredlookup.codeplex.com/
    Hope the first link Using JS Code helps you. Please - - If this post answers your question, please click Mark As Answer on the post and Mark as Helpful. For More Information, please feel free to visit our website- http://xrmxtensibles.wordpress.com/
    Thanks, - Israel Pradeep, - Software Engineer & PMP & B.I - Entrepreneur. - I am glad I could help!!! - If this post answers your question, please click “Mark as Answer” on the post and “Mark as Helpful”. For More Information, please feel free to visit
    our website- http://xrmxtensibles.wordpress.com/

  • RELEVANCY SCORE 2.71

    DB:2.71:Ar Invoice With Multiple Lines zz


    Hello,
    I'm loading AR invoice using Autoinvoice Import Program. This works fine for invoices with single lines. When I have invoices with more than one row it errors out. The Autoinvoice program completes with Error. For loading multiple lines to the invoice I'm loading with the same TRX_NUMBER. Am I missing something here?

    This is a part of the log file.

    AR_TAPI_ECB_BILLING_DATE_REQD
    Current system time is 27-DEC-2007 11:49:46
    APP-AR-11526: ORA-28115: policy with check option violation

    insert into RA_INTERFACE_ERRORS (INTERFACE_LINE_ID,MESSAGE_TEXT,INVALI
    APP-AR-11526: 5949503/ar/lib/raavhi.lpc 1960
    Error calling raavhi()
    Error calling raapic()

    Any help ??

    Thanks
    GM

    DB:2.71:Ar Invoice With Multiple Lines zz

    seems to error
    APP-AR-11526
    ORA-28115

    seems the security policy is implemented at your database leval and check which ID you are using to insert the record.Check with your DBA, for security to resolve first for ORA-28115.

    Disabled in case if you have any custom triggers defined on RA_CUSTOMER_TRX_ALL.

    Few Documentation for ORA-28115
    ORA-28115 with EXEMPT ACCESS POLICY privilege

    A user USER1 has been granted select, insert, update, delete on all
    tables of an application schema (USER2) that uses row-level security.
    The RLS policies cover select, insert, update, and delete, and have check option enabled. USER1 has also been granted EXEMPT ACCESS POLICY system privilege.

    Each table in the USER2 schema has a trigger that causes insertion of
    a row into an audit table whenever DML is performed. When USER1 performs DML on a USER2 table, the operation fails with

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

    DB:2.71:Help:Merging External File (Jpg/Pdf) Into Xdp/Xml Merged Pdf On Client dx



    I need some serious help pointing me in the right direction.

    What I have...and is working:

    I have an Invoice Template/PDF/Form created by LiveCycle with form fields. When requested by the user, in real-time I send XML from my server that is merged with the PDF template to create a single PDF file with multiple pages of invoices. Each invoice fits on one page. Works great...technically I think this is called or used XDP to merge the two on the client computer with a PDF and XML being supplied by the server.

    The server is just a generic Unix/PHP/MySQL environment...no Adobe products are installed (or can be installed on that machine). I rely entirely on the client's computer to assemble and create the finished PDF.

    What I NEED:

    So the client is now asking that I be able to insert receipts into the invoice PDF stream. So in order words you would still have the invoices above, but if we happen to have scanned receipts for a given invoice, they want those embedded into the PDF. A finished product would look like:

    Page 1 - Invoice 00001Page 2 - Receipt #1 for Invoice 0001

    Page 3 - Receipt #2 for Invoice 0001

    Page 4 - Invoice 00002

    Page 5 - Invoice 00003

    Page 6 - Receipt #1 for Invoice 0003

    etc.

    Can someone point me in the right direction to make this happen?

    Perfect world, I would like to have the invoices be actual images of the receipts (assume we need to have a JPG or PDF scan of the receipt)

    Okay world, I guess we could just attach the actual document so if it is XLS, DOC, PDF...etc...I don't need to convert...just attach.

    Last choice, I could just include hyperlinks back to our server for the client to click on and open the receipt document as we store it.

    DB:2.71:Help:Merging External File (Jpg/Pdf) Into Xdp/Xml Merged Pdf On Client dx


    I need some serious help pointing me in the right direction.

    What I have...and is working:

    I have an Invoice Template/PDF/Form created by LiveCycle with form fields. When requested by the user, in real-time I send XML from my server that is merged with the PDF template to create a single PDF file with multiple pages of invoices. Each invoice fits on one page. Works great...technically I think this is called or used XDP to merge the two on the client computer with a PDF and XML being supplied by the server.

    The server is just a generic Unix/PHP/MySQL environment...no Adobe products are installed (or can be installed on that machine). I rely entirely on the client's computer to assemble and create the finished PDF.

    What I NEED:

    So the client is now asking that I be able to insert receipts into the invoice PDF stream. So in order words you would still have the invoices above, but if we happen to have scanned receipts for a given invoice, they want those embedded into the PDF. A finished product would look like:

    Page 1 - Invoice 00001Page 2 - Receipt #1 for Invoice 0001

    Page 3 - Receipt #2 for Invoice 0001

    Page 4 - Invoice 00002

    Page 5 - Invoice 00003

    Page 6 - Receipt #1 for Invoice 0003

    etc.

    Can someone point me in the right direction to make this happen?

    Perfect world, I would like to have the invoices be actual images of the receipts (assume we need to have a JPG or PDF scan of the receipt)

    Okay world, I guess we could just attach the actual document so if it is XLS, DOC, PDF...etc...I don't need to convert...just attach.

    Last choice, I could just include hyperlinks back to our server for the client to click on and open the receipt document as we store it.

  • RELEVANCY SCORE 2.71

    DB:2.71:Consolidate Accounting Doc Created In Sd Into One Accounting Doc And Clear xx



    I am working on one extension in SD.and wrting functional design.I need some help on writing Fuctional Design for ABAPprogram to consolidate multiple accounting documents created daily in the Sales Distribution Billing activity in to one Accounting Document for each Invoice.

    Please guide me how to describe SAP process.

    thanks

    saeed

    DB:2.71:Consolidate Accounting Doc Created In Sd Into One Accounting Doc And Clear xx


    You may want to look at the summarization in FI for this. You can select the fields to summarize postings on in FI through the view V_TTYPV. Try refence procedure BKPF and put in the BSEG fields to group on.

    pls assign points if helpful as a way to say thanks.

  • RELEVANCY SCORE 2.71

    DB:2.71: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.71: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.71

    DB:2.71:Distinguish Purchase Invoice / Sales Invoice / Purchase Invoice Credit/ Sales Invoice Credit 8a



    Hello Every One,

    Knows some how can i distinguish the following documents in SAP ?

    - purchase invoice - sales invoice - purchase invoice credit - sales invoice credit .

    With other words, there is a way to distinguish those documents as following:

    0 -- sales invoice

    1 -- purchase invoice

    2 -- sales invoice Credit

    3 -- purchase invoice Credit

    My used tables are the following: BKPF, BSET, T001, T005. And my first select is:

    SELECT bukrs belnr gjahr budat bldat blart waers FROM bkpf INTO CORRESPONDING FIELDS OF TABLE it_bkpf WHERE bukrs = p_bukrs AND belnr IN p_belnr AND budat IN p_budat AND budat IN p_budat AND gjahr IN p_gjahr AND monat IN p_monat AND blart IN p_blart.

    Please don't hesitate to gave me an answer if you any Idea.

    Thanks u,

    Ouail.

    DB:2.71:Distinguish Purchase Invoice / Sales Invoice / Purchase Invoice Credit/ Sales Invoice Credit 8a


    Hi,

    I suppose you want to determine which accounting document is for what document.

    The field BLART and XBLNR will give you the details for the same.

    Like

    RV : Billing Document you will find Billing doc no in XBLNR

    RE : Vendor Invoice against PO

    You will need to drill a little with functional to find out more if Z types are created and hos the XBLNR is configured for update.

    Regards

  • RELEVANCY SCORE 2.71

    DB:2.71:Combining Items For Same Buyer 1d


    Normally when I have one buyer for multiple items, opening the 'Edit Sales Record' for any one of them gives me the option of combining the records for that buyer into a single invoice. I have one buyer for 7 items but when I open the Sales Records the option is not showing - anyone know why..?

    Thanks

    Rick

    DB:2.71:Combining Items For Same Buyer 1d

    Additionally, if you want to combine first then figure shipping insurance, FORGET IT! Even if you uncheck the "Send email" boxes, eBay sends them anyway, with the s/h ins from the first item only. GRRRRrrrr eBay. I've had to ask for more money for s/h ins from buyers who have already paid.

  • RELEVANCY SCORE 2.70

    DB:2.70:Creating Reports With Multiple Groups 3m


    I am
    working on a Point Of Sale System and am using VFP 9.0 reports to
    create an invoice with a list of parts sold to the customer and a
    separate list of labor sold to the customer. These are both grouped
    according to the current invoice number. When viewing/printing the
    report, I would like to have one section or group list all of the
    parts for the current invoice and another section listing all of the
    labor items for the current invoice. The number of parts and labor
    items could, and most likely will, be different so they cannot be
    placed in the same group (to my knowledge). Unfortunately I cannot find
    a way to separate these into two separate groups using VFP9's report
    builder, I can only create nested groups and that is not what I want.Any help would be very much appreciated.Thank You

    DB:2.70:Creating Reports With Multiple Groups 3m

    I figured out that I can store all the values I need to display in a two dimensional array. Essentially performing the UNION on my own in code. I do not understand however, how to display this array in a report. My array is named 'items_array' and I need to display the data in each row in the array. I am assuming there is an easy way to accomplish this using the report groups/details.I have tried however right now I am getting an error saying:File 'items_array.prg' does not existso I am probably accessing the array wrong or something.Any help is MUCH appreciated.Thanks

  • RELEVANCY SCORE 2.70

    DB:2.70:Multiple Payment Documents For One Single Invoice 37


    How can print multiple checks for each line item on my invoice. I tried using individual payment in vendor master and company code and single payment for marked invoice in FBZP. I tried with both the options as well as combination of options.Please let me know how this can be possible..

  • RELEVANCY SCORE 2.70

    DB:2.70:Sending Multiple Work Tickets On A Single Invoice jf



    Wellogix vendors that send EDI receipts and invoices for services to Marathon need to have the option of sending multiple work tickets on a single invoice. Currently they can only send one ticket per invoice. To accommodate this, changes similar to the following need to be made to the EDI programs.

    Z_IDOC_INPUT_INVOIC_MRM_PARK function module:

    If the EDI invoice IDOC (810) is for services and it contains multiple (or some other identifier that we agree on) in the work ticket segment (E1EDK02 BELNR when QUALF = 050) then the invoice will have multiple work tickets. Normally we match the work ticket number from the invoice to the service entry Reference segment (within the specific PO/PO Line). But if the work ticket segment on the 810 invoice contains the multiple identifier, the program will need to be changed to take the invoice number from the 810 invoice IDOC instead of work ticket and match it to all service entries where the Reference segment of the service entry is equal to the invoice number from the 810 invoice (within the same PO/PO Line). All matched service entries would then be used to create the invoice. The invoice will need to be created with one invoice line per work ticket. So if there were four tickets, there would be four invoice lines.

    DB:2.70:Sending Multiple Work Tickets On A Single Invoice jf


    Wellogix vendors that send EDI receipts and invoices for services to Marathon need to have the option of sending multiple work tickets on a single invoice. Currently they can only send one ticket per invoice. To accommodate this, changes similar to the following need to be made to the EDI programs.

    Z_IDOC_INPUT_INVOIC_MRM_PARK function module:

    If the EDI invoice IDOC (810) is for services and it contains multiple (or some other identifier that we agree on) in the work ticket segment (E1EDK02 BELNR when QUALF = 050) then the invoice will have multiple work tickets. Normally we match the work ticket number from the invoice to the service entry Reference segment (within the specific PO/PO Line). But if the work ticket segment on the 810 invoice contains the multiple identifier, the program will need to be changed to take the invoice number from the 810 invoice IDOC instead of work ticket and match it to all service entries where the Reference segment of the service entry is equal to the invoice number from the 810 invoice (within the same PO/PO Line). All matched service entries would then be used to create the invoice. The invoice will need to be created with one invoice line per work ticket. So if there were four tickets, there would be four invoice lines.

  • RELEVANCY SCORE 2.69

    DB:2.69:Invoice Split 3s



    I want to be able to split my invoice if a customer has different PO numbers. i should not combine this into one invoice:- how can i do that?

    DB:2.69:Invoice Split 3s


    Sorry, that should be option A(Purchase order), not C

  • RELEVANCY SCORE 2.69

    DB:2.69:Parking Several Po Into One Invoice a7



    Hi,

    Is it possible to park several PO into one invoice. Using MIR7 allows me to park 1 PO per Invoice only.

    Thanks.

    Kath

    DB:2.69:Parking Several Po Into One Invoice a7


    Hi,

    It is possible.

    First enter MIR7 t-code, Enter required detail for invoice verification.

    Then enter purchase order number in the field of Reference document category and press enter.

    So system take all detail from purchase order, then enter number of purchase order as requirement.

    Regards,

    Mahesh Wagh.

  • RELEVANCY SCORE 2.69

    DB:2.69: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.69: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.69

    DB:2.69:Fetchxml Custom Invoice Report - Getting Selected Invoices On Multiple Pages pz


    Hi,
    I have a custom FetchXML Invoice report currently setup with a Parent and Sub Report.
    I am looking to select multiple entities of Payments and run this report and expect 1 invoice per page. Currrently only 1 page and 1 invoice is generated even though filtering is turned on and Filter on selected records is selected.
    The baseline Invoice reports is what we are looking to resemble where you can generate multiple invoiced in one batch run. But am using FetchXML.
    Any suggestions would be greatly appreciated.
    Thanks
    Ian

    DB:2.69:Fetchxml Custom Invoice Report - Getting Selected Invoices On Multiple Pages pz

    Hi Ian,
    In the parent report:
    Create a table
    Associate the table with the dataset you are using to retrieve yourfiltered IDs
    Insert the sub report into the table
    Pass the parameters to the sub report as fields only (e.g. new_paymentid.Value and not First(new_paymentid.Value, Dataset X)
    Jeff JBM

  • RELEVANCY SCORE 2.69

    DB:2.69:Invoice Priting Only Once d7


    Hi Experts, I were developed Z report to print invoice. and It's working fine. Now, I want to restrict user to print one invoice multiple times. Is it possible without developing/updating Z tables?Thank you in Advance.Regards,Denish Patel.

  • RELEVANCY SCORE 2.69

    DB:2.69:Auto Invoice Thru Back Ground Job 11



    Problem that we have is..it is also automatically combine few deliveries into 1 invoice in which we only want 1 to 1.. 1 Delivery - 1 Invoice.

    S

    Please advise on how we can achieve 1 Delivery - 1 Invoice in our Auto Invoice job.

    Please advise how to have one dleivery one Invoice whre billing has to happen Thru Jobs

    DB:2.69:Auto Invoice Thru Back Ground Job 11


    Hi Anand

    We also need only one delivery thru jobs, please also tell the settings for this.

    Thanks

  • RELEVANCY SCORE 2.69

    DB:2.69:Multiple Invoice Creation 3c



    Hi All,

    I want to create Multiple Invoice Creation through BAPI or FM. For this invoice PO is the Reference.

    As per requirement i have multiple PO in container, at one shot i want to create invoice realted PO as the reference.

    Thanks

    Amit

    DB:2.69:Multiple Invoice Creation 3c


    Hi All,

    I want to create Multiple Invoice Creation through BAPI or FM. For this invoice PO is the Reference.

    As per requirement i have multiple PO in container, at one shot i want to create invoice realted PO as the reference.

    Thanks

    Amit

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Make Multiple Account Assingment In The Invoice? 3c



    Hello,

    Can you please tell me How to make multiple account assignment at the time of Invoice.?

    I mean In the PO where we mention as one cost cnetre and one G/L account assignment, But During invoice we need to post to different accounts

    Best Regards,

    Sridhar.k

    DB:2.69:How To Make Multiple Account Assingment In The Invoice? 3c


    In addition to Charlie's suggestion, please make sure that the account assignment category is set so it can be changed upon invoice receipt. You can do this by following this menu path in IMG: Purchasing Maintain Account Assignment Categories. In account assignment detail config, make sure the IR Changeable field is checked.

    This is also the place where you can set the account assignment so it allows multiple account assignments.

  • RELEVANCY SCORE 2.69

    DB:2.69:Can Any One See This fs



    i have a problem when i am creating invoice list,

    in every billing document i am using different pricing procedures,

    payer is same,

    so multiple documents i need one invoice list to send payer,

    problem is different pricing procedures in invoice list i am getting one line item with one invoice price,

    i need to get different line items with different invoice price in one invoice list.

    suggest me the process.

    Thanks Best regards,

    krishna.

    DB:2.69:Can Any One See This fs


    This thread was in SCN Support, which is the support space for SAP Community Network and not SAP products. in the future, please select an appropriate space where topic experts will see and reply to it: SCN Site Index

    In the meantime, I've moved it to SAP ERP Financials

  • RELEVANCY SCORE 2.69

    DB:2.69:Didn't Accept Multiple Tax Codes In A/R Invoice 7z



    Hi,

    In A/R Invoice they are using many tax codes. But now onwards they need to maintain only one type of tax code using in single A/R invoice. But end users are take multiple tax codes in one invoice. Is there any stored procedure to block this type of scenario. If they are using multiple tax code the A/R invoice should may rise one error ie., multiple tax code not accepted. Kindly provide stored procedure for this scenario.

    Thanks Regards,

    Kishore.

  • RELEVANCY SCORE 2.69

    DB:2.69:Multiple Del Into One Invoice 7f



    Dear Experts

    Regarding this requirement i have already referred to the posts by the experts but i am not able to solve it.

    The scenario is that we need single invoice for multiple delv.i have checked the copy controls VTFL.In that the det export data is blank and in the item category data vbrk/vbrp is 001.But when i try to do collective billing thru VF04 the system shows the split analysis as "split due to diff header data" field name $000000001 , $000000002 and below that there are delivery no.s of the 2 deliveries for which i wish to combine.i.e.

    Split analy.

    Split due to different header data

    Fld Name $000000001 $000000002

    Assignment number 0080224170 0080224291

    Kindly advise the solution to it.

    DB:2.69:Multiple Del Into One Invoice 7f


    Dear Sanjeev,

    It is clear from System - Log, that for 2-deliveries, System is generation 2-Asignment Nos., as a result, 2-Invoices are getting created,

    I suggest to re-try the Processing of Invoice, with following maintenance, in Transaction: VTFL (at header level)

    Copying requirements 003 Header/dlv.-related

    Determ.export data B

    Assignment Number E

    Reference number B

    Best Regards,

    Amit

    Note: Apart from the above settings, Please ensure the following are same for both the deliveries:

    1) Payer

    2) Inco term

    3) Payment term

    4) Actual GI Date from Delivery

    5) Shipping Condition

    6) Account Assignment Group

    7) Exchange rate (in case of export sale order)

    P.S. Refer OSS Note: 11162 and 36864

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Return Multiple Values For A Unique Id Into One Field In Ms Access f1


    Hello! I need to take multiple items and return them in one data field separated by a comma. For Instance. Denials on an invoice. Denials are stored in one table and invoices in another. Common element is invoice number. Each
    denial is a unique record with it own values but I want to be able to take one element, the denial codes that exist on one invoice id and return them into one field.

    Example: invoice 12345 had 3 denials on it: D1, D99, D13. I need to see one line per invoice and not three!
    What I want to see:
    INV # LAST DENIAL DATE # OF DENIALS DENIAL CODES
    12345 6/1/2012 3 D1, D13, D99

    What I see now :
    INV # LAST DENIAL DATE # OF DENIALS DENIAL CODES
    12345 6/1/2012 3D1
    12345 6/1/20123 D13
    12345 6/1/2012 3D99

    I hope the above make sense! Thank you for any help you can provide,

    Rich

    DB:2.69:How To Return Multiple Values For A Unique Id Into One Field In Ms Access f1

    You'll find a demo file, which includes a number of methods of concatenating values, as Concat.zip in my public databases folder at:

    https://skydrive.live.com/?cid=44CC60D7FEA42912id=44CC60D7FEA42912!169

  • RELEVANCY SCORE 2.69

    DB:2.69: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.69: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.69

    DB:2.69:I Need To Get Multiple Fields From Single Field(Fkdat) Of Table Vbrk?How We Can Get All Those? sx



    hi guru's

    how to get this field(FKDAT) information as a multiple fields in EDIT SCRIPT from VBRK table?

    exp:

    Field is FKDAT from VBRK table

    need split informtion like this,

    Invoice Month,

    Invoice Date,

    Invoice Year,

    Invoice Quarter,

    Invoice Day,

    Invoice Week,

    Invoice WeekDay,

    Invoice Monthyear,

    YearMonth,

    LogicalMonthYear

    all those fields i need to get only "FKDAT from VBRK table"

    pls let me kow any one

    rgds

    DB:2.69:I Need To Get Multiple Fields From Single Field(Fkdat) Of Table Vbrk?How We Can Get All Those? sx


    VBRK_BillingDocument_Header:

    Load

    Date(FKDAT,'MMddyyyy') AS [Invoice Date_FKDAT],

    Date(FKDAT,'MM') AS [Invoice Month_FKDAT],

    Date(FKDAT,'yyyy') AS [Invoice Year_FKDAT],

    KUNRG AS [Payer_KUNRG],

    //FKDAT AS [Billing Date_FKDAT],

    //WAERK AS [Document Currency_WAERK],

    VBELN AS [VBELN],

    FKART AS [Billing Type_FKART],

    VKORG AS [Billing Sales Org._VKORG],

    BUKRS AS [Compnay Code._BUKRS],

    WAERK AS [Billing Doc.currency_WAERK],

    VTWEG AS [Billing Distribution Channel_VTWEG];

    SQL SELECT FKDAT KUNRG VBELN FKART VKORG BUKRS WAERK VTWEG FROM VBRK;

    rgds

    Shiva