• RELEVANCY SCORE 3.51

    DB:3.51:Manipulating Text File 7f




    Hello all =)

    I had a text file which looks like the followings:

    Cluster 1:
    GN-1174464001000-20070221160001-myspace*1
    GN-1174474801000-20070221190001-myspace*0.875351
    Cluster 2:
    Cluster 3:
    Cluster 4:
    Cluster 5:
    Cluster 6:
    GN-1174474801000-20070221190001-studivz*1
    GN-1174485601000-20070221220001-studivz*1
    GN-1174496401000-20070222010001-studivz*0.936119
    Cluster 7:
    Cluster 8:
    GN-1174431601000-20070221070001-secondlife*1
    Cluster 9:
    GN-1174431601000-20070221070001-jetblue*1
    GN-1174453201000-20070221130001-jetblue*0.979874
    GN-1174464001000-20070221160001-jetblue*0.971083
    GN-1174442401000-20070221100001-jetblue*0.94002
    Cluster 10:
    Cluster 11:
    Cluster 12:
    GN-1174420801000-20070221040001-youtube*1
    GN-1174431601000-20070221070001-youtube*0.889167

    I am intending to manipulate the above text file to look like this:
    Cluster 1:
    GN-1174464001000-20070221160001-myspace*1
    GN-1174474801000-20070221190001-myspace*0.875351
    Cluster 2:
    GN-1174474801000-20070221190001-studivz*1
    GN-1174485601000-20070221220001-studivz*1
    GN-1174496401000-20070222010001-studivz*0.936119
    Cluster 3:
    GN-1174431601000-20070221070001-secondlife*1
    Cluster 4:
    GN-1174431601000-20070221070001-jetblue*1
    GN-1174453201000-20070221130001-jetblue*0.979874
    GN-1174464001000-20070221160001-jetblue*0.971083
    GN-1174442401000-20070221100001-jetblue*0.94002
    Cluster 5:
    GN-1174420801000-20070221040001-youtube*1
    GN-1174431601000-20070221070001-youtube*0.889167

    I had tried to write a JAVA program which looks the following (but it failed to help):

    * ...*
    * String inputFileName = "singlepassOutput.txt";*
    * String outputFileName = "modifiedsinglepassOutput.txt";*

    * // Create FileReader Object*
    * FileReader inputFileReader = new FileReader(inputFileName);*
    * FileWriter outputFileReader = new FileWriter(outputFileName);*

    * // Create Buffered/PrintWriter Objects*
    * BufferedReader inputStream = new BufferedReader(inputFileReader);*
    * PrintWriter outputStream = new PrintWriter(outputFileReader);*

    * String inLine = "";*
    * cluster_index = 0;*
    *
    while ((inLine = inputStream.readLine()) != null )*
    * {*
    * if(inLine.startsWith("Cluster") == true status == false)*
    * {*
    * status = true;*
    * outputStream.println("Cluster " + (cluster_index++) + ":");*
    * outputStream.println(inLine);*
    * continue;*
    * }*
    * else*
    * {*
    * status = false;*
    * outputStream.println(inLine);*

    * }*

    * }//end while*

    ...

    I hope somebody can enlighten/help me on how to handle this problem =)

    Thank you,
    redeville

    DB:3.51:Manipulating Text File 7f

    thank you smithberry....

    that is very close .....

    it helped a lot.

    =)

  • RELEVANCY SCORE 3.50

    DB:3.50:Down Payment Not Shown In Final Invoice ka





    Hi Experts,

    If we try to create a final invoice the down payment is not taken in account anymore. Its not shown on the final invoice and the amount already paid by the customer with the down payment is not subtracted as well. However I can see down payment request document has been achieved. My assumption is due to document archived final invoice not taken the down payment, Can you please check and advice how to resolve this issue

    Regards,

    Chandramouli GN

    DB:3.50:Down Payment Not Shown In Final Invoice ka


    Hi Julie,

    Down payment request created from sales order and same archived, while doing the final invoice the down payment amount not showing in final invoice.

    Regards,

    Chandramouli GN

  • RELEVANCY SCORE 3.15

    DB:3.15:Customer Invoice fs





    Hi All,

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

    Regards,

    Danny.

    DB:3.15:Customer Invoice fs


    Hi Danny,

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

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

    90 % of the invoices are created by FI personnel.

    Transaction FB70 is used by FI ppl to create invoice.

    In short,

    VF01 = SD Billing.

    FB70 = FI Billing.

  • RELEVANCY SCORE 3.15

    DB:3.15:Direct Invoice In Ar Without Creating Sales Order 3f


    hi friends,Can I create direct invoice in AR without creating sales order.after created invoice number on base of Invoice Number can I create sales order number.RegardsAshish

    DB:3.15:Direct Invoice In Ar Without Creating Sales Order 3f

    hi 10434318,I created manual Invoice with API after that how match that Invoice Number with Sales Order Number.eg. I create manual invoice that Invoice Number "1" Invoice amount "100" after that I create sales order that number "1" and sales order amount "100"How to match sales order number with Invoice.

  • RELEVANCY SCORE 3.10

    DB:3.10:Function Module Or Bapi To Create An Invoice Through Fb60 fj



    Hi,

    Is there any standard Function Module or a BAPI to Post a FI Invoice (Non-PO Invoice)?

    Thank you,

    Renu

    DB:3.10:Function Module Or Bapi To Create An Invoice Through Fb60 fj


    Hi,

    I will be posting a FI Invoice through FB60. I can't use BAPI_INCOMINGINVOICE_CREATE Invoice Verification: Post Invoice BAPI_INCOMINGINVOICE_PARK.

    If anyone has input values for BAPI_ACC_DOCUMENT_POST or BAPI_ACC_GL_POSTING_POST or

    BAPI_ACC_INVOICE_RECEIPT_POST. then its a great help.

    I'm getting one or the other error. I'm not able to Post the document. I really don't know what I'm missing..:(

    Thank you,

    Renu

  • RELEVANCY SCORE 2.96

    DB:2.96:How Make A Report Showing Only Oldest Dated Information Per Customer? az


    I have a table with 4 fields: Customer name, Invoice Date, Invoice Number and Invoice Amount.I am trying to create a report that shows only the oldest dated invoice for each customer. For each customer I want to display customer name, invoice date, invoice number, and invoice amount for that record with the latest date.

    DB:2.96:How Make A Report Showing Only Oldest Dated Information Per Customer? az

    Hi,Here's how you can do it:1) Create a group on Customer Name2) Right-click the details section and go to Section Expert click on the formula button beside Suppress and use this formula:{Invoice.Invoice_Date} Maximum({Invoice.Invoice_Date},{Customer.Customer Name})3) And, then you can suppress the Group Header and Group Footer sectionsLet me know how this works!-Abhilash

  • RELEVANCY SCORE 2.94

    DB:2.94:Excise Invoice m7



    Hi,

    Can anyone plz tell me, how to create an excise invoice for a debit note?

    Regards.

    amit

  • RELEVANCY SCORE 2.94

    DB:2.94:How To Account A Invoice In Payables ad


    Hi All,

    I have created a invoice matched with PO. then validated the invoice.
    When i am going to account the invoice from Action (B) - Create Accounting (Check box)..
    It's not accounting the invoice.......means in invoice window Accounted status is NO.

    Can someone help me on this......

    Thanks in advance.

    Subhash

    DB:2.94:How To Account A Invoice In Payables ad

    Hello,

    Try to submit the concurrent request "Create Accounting" and search for your invoice number in the report output. You will find error message if ever it fail to create accounting.

    HTH,
    Vik

  • RELEVANCY SCORE 2.93

    DB:2.93:Creation Of Exise Invoice 9j



    hi how can we create exise invoice pls tell little bit clear plz argnt.

    i saved vf01

    adi

    DB:2.93:Creation Of Exise Invoice 9j


    After saving VF01, goto T.code: J1IIN -- Clibl on Billing Document -- Enter Billing Document, Posting Date SubTranscation Type (incase of SubTransacrtion Type only if required) -- Enter (normally Excise group series group will be defaulted. If not, maintain those, maintain time of Removal) -- Save.

    Regards,

    Rajesh Banka

    reward suitable points.

  • RELEVANCY SCORE 2.90

    DB:2.90:How To Create An Invoice From Multiple Sales Doc. aj



    Hi,

    how to create an invoice from multiple sales doc.

    thanx,

    sourav

    DB:2.90:How To Create An Invoice From Multiple Sales Doc. aj


    use VF04 to create single invoice for multiple delivaries.

    give time stamp and ur varinet and execute list of open delivaries will come and select them all and press "collective billing " then system creates single invoice for multiple delivaries.

  • RELEVANCY SCORE 2.88

    DB:2.88:Delivery Against Don't Create Invoice xp



    Hi,

    I have created the delivery but forgot create the invoice.

    How can identify, which delivery against dont create the invoice?

    Useful answers duly rewarded

    Regards,

    Devendra

    DB:2.88:Delivery Against Don't Create Invoice xp


    hi,

    GO TO VF05 AND INPUTS AS PER UR REQUIREMENT AND SELECT RADIO BUTTON OPEN BILLING DOCUMNETS AND EXECUTE.

    REAGRDS,

    KISHORE.

  • RELEVANCY SCORE 2.88

    DB:2.88:Tax Invoice 1k



    i want to create print progarm form for "TAX INVOICE" .

    can anyone please help me.if u have created already for your requrement.

    DB:2.88:Tax Invoice 1k


    Hi

    Copy the Std Invoice form and use it by changing as per your requirement

    INVOICE

    Output type : RD00

    ScriptForm Name : RVINVOICE01

    Driver Program Name : RVADIN01

    smartform name : LB_BIL_INVOICE

    Smartform Driver Pgm: RLB_INVOICE

    Regards

    Anji

  • RELEVANCY SCORE 2.88

    DB:2.88:Excise Invoice zj



    How to create excise invoice?Can u provide step by step?

    in my project CED, Education cess,Secondary and H.E Cess and VATalso

    this invoice is order related invoice with partially billing?

    DB:2.88:Excise Invoice zj


    How to create excise invoice?Can u provide step by step?

    in my project CED, Education cess,Secondary and H.E Cess and VATalso

    this invoice is order related invoice with partially billing?

  • RELEVANCY SCORE 2.83

    DB:2.83:Invoice Making In Smartforms aa



    HI,

    How can make the invoice in mm and explain the steps to create the invoice and forward me one copy of developed invoice.

    thanks

    sujatha

    DB:2.83:Invoice Making In Smartforms aa


    HI,

    How can make the invoice in mm and explain the steps to create the invoice and forward me one copy of developed invoice.

    thanks

    sujatha

  • RELEVANCY SCORE 2.83

    DB:2.83:Sd-Excise Invoice 7c



    After creating commercial invoice (vf01) in usd/euro --and when u create excise invoice how it will get converted into inr automatically

    DB:2.83:Sd-Excise Invoice 7c


    the exchange rate given in billing header tab -is for currency conversion when accounting document is created -- but value in accounting doc in inr (ex. e cess o.29 usd x 40.10000 =11.63 inr

    and value in excise invoice in inr are different.(same here ecess is 11.86 inr)

    why ther is difference in ecess ? is ther any setting wher we maintain exchange rate for excise invoice

  • RELEVANCY SCORE 2.83

    DB:2.83:Error Message While Creating A/P Invoice 3m



    hi experts,

    I try to create AP invoice but system shows following error cannot create standalone AP/AR invoice with excisable item. please explain me the reason to understand.

    DB:2.83:Error Message While Creating A/P Invoice 3m


    Hi,

    Check this thread http://scn.sap.com/thread/2128160

    Thanks Regards,

    Nagarajan

  • RELEVANCY SCORE 2.82

    DB:2.82:Invoice List a1



    Hi,

    What is the invoice list? For what purpose we create invoice list.Why we maintain invoice list in billing document type?

    Regards

    Prabudh

    DB:2.82:Invoice List a1


    hi,

    The invoice list lets you create, at specified time intervals or on specific dates, a list of billing documents (invoices, credit and debit memos) to send to a particular payer.

    The billing documents in the invoice list can be single or collective documents (collective invoices combine items from more than one delivery).

    The standard version of the SAP R/3 System includes two types of invoice lists:

    for invoices and debit memos

    for credit memos

    If you wish, you can process invoices, debit memos, and credit memos at the same time. The system automatically creates a separate invoice list for credit memos.

    A payer may be the head office of a buying group, which pays all the invoices for goods that are shipped to individual members. The group payer takes responsibility for paying the invoice lists and then collecting payment from the individual members. In return for these services, the group payer usually earns a factoring or del credere discount.

    Depending on the tax structure of the payer's country, the payer may be liable to pay taxes on factoring discounts that he earns. In Germany, for example, factoring discounts are taxed at the standard rate of 15%. During invoice list processing, you can reimburse the payer in advance for this tax liability by creating special condition records.

    An invoice list type must be assigned to each billing type that you want to process in invoice lists. The standard version of the SAP R/3 System includes two types of invoice lists: LR for invoices and debit memos, LG for credit memos.

    regards

    sadhu kishore

  • RELEVANCY SCORE 2.81

    DB:2.81:Invvoice xm



    i create a AP invoice for Rs.1000 rupees but after six month the invoice value is 1500 how do i will create this kind of invoice? . it like a arrears.

    DB:2.81:Invvoice xm


    HI

    Are those invoices incur foreign currency transaction?

    so because of exchange rate,you mean to say that the values increases...

  • RELEVANCY SCORE 2.80

    DB:2.80:Deemed Invoice : Not Able To Create Deemed Invoice When The Excise Invoice c8



    Hi guys,

    when i create an excise invoice in background .and try to create ARE-3 in J1IA301.I am getting a error (081091004/2009 excise invoice is meant for normal invoice).

    when i create excise invoice manually and click on goto - utilization . The excise invoice type will be local .If i click on the pencil tab it will change to EXPORT and we can see DEEMED in blue color after this i will save and create ARE-3. ARE-3 gets generated.

    while creating excise invoice in background the EXCISE INVOICE TYPE in J1IIN will be LOCAL and we will not be able to change after this when i try to create ARE - 3 IAM GETTINGTHE ERROR..

    Please help me out of this..

    As my client wants to create the excise invoice in background while billing document is created..

    Regards,

    Shivdeep B

    DB:2.80:Deemed Invoice : Not Able To Create Deemed Invoice When The Excise Invoice c8


    Hi

    Maintain the default excise group and series groups and here select the deemed export and try

    maintain as D in export type as DEEMED

    regards

  • RELEVANCY SCORE 2.79

    DB:2.79:Transport Invoice Smartform 8j



    hi friends,

    I need to create a transport invoice smartform, so is there any standard transport invoice smartforms , please suggest.

    with regards,

    prasad

    DB:2.79:Transport Invoice Smartform 8j


    Hi

    You can use the same SAP given Smartform for the Invoice and modify it and use

    Transport Invoice may be different in few area from the General Invoice such as Doc type etc so you can use the following std one and make changes

    it will serve the purpose

    INVOICE

    Output type : RD00

    ScriptForm Name : RVINVOICE01

    Driver Program Name : RVADIN01

    bsmartform name : LB_BIL_INVOICE

    Smartform Driver Pgm: RLB_INVOICE/b

    Regards

    Anji

  • RELEVANCY SCORE 2.79

    DB:2.79:The Document Is Not Relevant For Invoice Lists Error Vf21 kp



    Hello Experts,

    I am getting error while creating invoice list.

    "The document is not relevant for invoice lists"

    I have done all neccessary settings.

    VN01 Create number range for Invoice Lists : 4....0000 to 4......999

    OY05 Create suitable billing calendar : S1

    VOFA Create or change Billing Types for Invoice Lists : Billing types ZSFX (Export Invoices) to Invoice List (ZEIL)

    V/40 Output Types for Invoice Lists : LR00

    V/42 Output Procedures :V30000

    V/25 Output Determination

    Bill Typ Desc........

    ZEIL Invoice List V30000 Invoice List LR00 Invoice list V30001 Item Output for Invoice List

    V/54 Check or change Output Access Sequences ;Maintained

    V/31 Assign Partner Function PY for Invoice List Type ; Assigned

    Can you please advice me. This is require as we have to send all invoice together with continer to Italy from India.

    Thanks,

    Ashish Gautam

    DB:2.79:The Document Is Not Relevant For Invoice Lists Error Vf21 kp


    Hi Ashish,

    the billing document type of the SD invoice (that should be included in invoice list) must have field 'Invoice list ype' maintained in transaction VOFA.

    The Payer must have a calendar maintained in the field 'InvoicingListDates' in transaction VD02 (Billing view).

    When you change these setting, only the new billing documents will be relevant for invoice list.

    To make exsiting billing document valid for invoice list to, you should run the report attached to SAP note 1078149.

    Best regards,

    Ivano.

  • RELEVANCY SCORE 2.79

    DB:2.79:Invoice Distribution Line Is Reversed And Manually Changed Invoice Amount 7a


    Dear Members,

    I Created Invoice and Run Create Accounting. Later, I reversed Invoice distribution Line and manually Changed Invoice Header Amount. I Run Create Accounting. Reversed Distribution Line is Transfered to GL but Liability account is not balancing because i manually Changed to Zero.

    Is there any way

    Thanks

    DB:2.79:Invoice Distribution Line Is Reversed And Manually Changed Invoice Amount 7a

    Dear Members,

    I Created Invoice and Run Create Accounting. Later, I reversed Invoice distribution Line and manually Changed Invoice Header Amount. I Run Create Accounting. Reversed Distribution Line is Transfered to GL but Liability account is not balancing because i manually Changed to Zero.

    Is there any way

    Thanks

  • RELEVANCY SCORE 2.77

    DB:2.77:Copy Controls Invoice To Invoice c7



    Dear Gurus,

    I have maintained Invoice to invoice copy controls, i am creating invoice with ref to invoice system is allowing to create so many invoices with ref to one invoice, i want ti restrict this to one please provide me solution how to this. it is very urgent.

    Regards

    Sesharao

    DB:2.77:Copy Controls Invoice To Invoice c7


    Dear,

    can you please explain the business requirement.

    Regards

    raj

  • RELEVANCY SCORE 2.77

    DB:2.77:Customer Specific Invoice Texts 3d



    Hi

    Does anyone have any suggestions on where to create customer specific texts for invoice - the client needs texts assigned to a specific customer shown in the invoice.

    Thx

    R

    DB:2.77:Customer Specific Invoice Texts 3d


    Hi Beata,

    I forgot to write that I had solved the issue a while back.

    VOTXN is indeed the answer.

    Since you replied to my question points are awarded

  • RELEVANCY SCORE 2.77

    DB:2.77:How To Create Such 2 Inside Loop Adobe Form ? cs



    Hi all:

    I have a requirement like, print invoice approval form.

    Invoice 1

    Invoice Item 1-1

    Invoice Item 1-2

    Invoice 2

    Invoice Item 2-1

    Invoice Item 2-2

    Invoice Item 2-3

    Suppose there is 2 invoice, and many invoice items inside.

    I want my print form like

    page 1

    Invoice 1 -

    invoice number, details....

    page2

    Invoice 1 Item List

    { invoice number as title

    loop for each invoice item, the invoice item maybe paged }

    Invoice Item 1-1

    Invoice Item 1-2

    page 3

    Invoice 2 -

    invoice number, details....

    page 4

    Invoice 2 Item List

    { invoice number as title

    loop for each invoice item, the invoice item maybe paged }

    Invoice Item 2-1

    Invoice Item 2-2

    Invoice Item 2-3

    ... ... { for more invoice, continue this style}

    Can I contains all such style inside one interactive form ?

    Please help me, its very urgent

    DB:2.77:How To Create Such 2 Inside Loop Adobe Form ? cs


    Thanks a lot. I have resolved it using form script and others

  • RELEVANCY SCORE 2.77

    DB:2.77:Excise Invoice c3



    How to create excise invoice?

    DB:2.77:Excise Invoice c3


    Hi Annad,

    Excise Invoice is create with reference to customer invoice

    for this we need to some setting in Logistic genreal - tax on goods movement - india

    Thanks

    Vasu

  • RELEVANCY SCORE 2.77

    DB:2.77:Creation Of Export Invoice mm


    Dear all. Can anybody tell me at which transaction to create Export invoice?Legacy data is like:They create only TAX Invoice which they send to the excise dept Export invoice is done manually on Exel sheet.I.e TAX invoice is nothing but excise invoice.M lil confused at which transaction to create TAX invoice n export invoice.Shud i go for different no. range for export invoice while creating billing doc?Pls reply at the earliest.Thanks RegardsKishan

    DB:2.77:Creation Of Export Invoice mm

    hiCreation of Export Invoice transaction code : VA01, But we have mainatained the channel is diffrent.and we have maintained for new pricing procedure for export without taxes and excise. only for prices.discount and others for ur reqirement.Rewards point it helps.

  • RELEVANCY SCORE 2.76

    DB:2.76:Ap Invoice Number Issue aa


    Dear Experts,When user enter the Invoice if there is any mistakes in that invoice he use to Cancel the Invoice and user wants to create the same Invoice with correct Information, as per system user can't use the same Invoice Number, But user requirement is he/she has to use the Same Invoice Number, what would be the Solution in this case.Please guide meThanks RegardsBharath

    DB:2.76:Ap Invoice Number Issue aa

    There is issue in AP, work around you can create new invoice with same number but add prefix or postfix "." and future remember add detail in description.

  • RELEVANCY SCORE 2.76

    DB:2.76:Need Idea For A Plugin sc


    I want to create an email activity whenever an Invoice is created. The code is as follows,
    public void Execute(IServiceProvider serviceProvider)
    {
    // throw new NotImplementedException();
    try
    {
    IPluginExecutionContext context = (IPluginExecutionContext)serviceProvider.GetService(typeof(IPluginExecutionContext));
    IOrganizationServiceFactory factory = (IOrganizationServiceFactory)serviceProvider.GetService(typeof(IOrganizationServiceFactory));
    IOrganizationService service = factory.CreateOrganizationService(context.UserId);
    if (context.OutputParameters.Contains(Target) context.OutputParameters[Target] is Entity)
    {

    Entity invoice = (Entity)context.InputParameters[Target];
    if (invoice.LogicalName == invoice)
    {
    Entity email = new Entity(email);
    email[subject]=An invoice has created with invoice name :invoice[name];
    email[description] = hi sir, an invoice has created with following details. Invoice name : invoice[name]
    , Opportunity : invoice[opportunityid] , Account: invoice[customerid].;
    if (context.OutputParameters.Contains(id))
    {
    Guid regardingobjectid = new Guid(context.OutputParameters[id].ToString());
    string regardingobjectidType = invoice;
    email[regardingobjectid] = new EntityReference(regardingobjectidType, regardingobjectid);
    }
    service.Create(email);
    }
    else Console.WriteLine(sorry);
    }
    else Console.WriteLine(sorry);
    }
    catch (Exception ex)
    {
    throw ex;
    }
    }

    When creating an invoice, no activity is created. plugin reg. as per-operation create msg of invoice entity.
    any idea??

  • RELEVANCY SCORE 2.76

    DB:2.76:Create Excise Invoice First - kz



    How to create an excise invoice and what are the pre requisites we need ?

    thanks

    SV Reddy

  • RELEVANCY SCORE 2.74

    DB:2.74:Sales A/R Invoice zf



    Dear Sir,

    can i Create Sales A/R Invoice in negative stock or negative mfg. serial No.

    Please Tell Me...

    DB:2.74:Sales A/R Invoice zf


    Hi Anand,

    You Can make with negative but not advisable .

    Regards

    Kennedy

  • RELEVANCY SCORE 2.74

    DB:2.74:Novalidate 7c


    "Why primary key is not enabled without an index on it. "

    SQL create table list( gn number primary key disable );

    Table created.

    SQL insert into list values(1001);

    1 row created.

    SQL insert into list values(1001);

    1 row created.

    SQL alter table list
    2 enable novalidate primary key;
    alter table list
    *
    ERROR at line 1:
    ORA-02437: cannot validate (JAMES.SYS_C002777) - primary key violated

    SQL create index list_idx on list (gn);

    Index created.

    SQL alter table list
    2 enable novalidate primary key;

    Table altered.

    SQL select * from list;

    GN
    -------
    1001
    1001What is the Index role in Enabling Primary Key with Novalidate ?

    DB:2.74:Novalidate 7c

    CREATE TABLE chris (col1 INTEGER)
    /
    INSERT INTO chris VALUES (1)
    /
    INSERT INTO chris VALUES (2)
    /
    INSERT INTO chris VALUES (3)
    /
    INSERT INTO chris VALUES (4)
    /
    INSERT INTO chris VALUES (4)
    /
    ALTER TABLE chris ADD PRIMARY KEY (col1) NOVALIDATE
    /
    -- fails with error ORA-02437
    ALTER TABLE chris ADD PRIMARY KEY (col1) DISABLE
    /
    -- ok
    ALTER TABLE chris ENABLE NOVALIDATE PRIMARY KEY
    /
    -- again fails with error ORA-02437

    Cause
    This error occurs because it tries to create a unique index for the unique or primary
    key index. The uniqueness is checked during the creation of the unique index.

    Fix
    - First, create a NON-UNIQUE index on the same fields that you want to
    include in the constraint.
    - Then add the unique or primary key constraint.

    Thats is:

    create index idx_chris_col1 on chris(col1);

    After this give:

    ALTER TABLE chris ADD PRIMARY KEY (col1) NOVALIDATE
    /

    OR

    ALTER TABLE chris ENABLE NOVALIDATE PRIMARY KEY
    /

    References
    Bug 544502 - Enabling Novalidate Not Deferrable Unique Constraint Creates Unique Index

  • RELEVANCY SCORE 2.74

    DB:2.74:A/R Invoice 11



    Hi Experts,

    Can we create Dummy A/R Invoice without Stock?

    Plz Suggest if any alternate.

    Regards,

    Ravi

  • RELEVANCY SCORE 2.74

    DB:2.74:Creating A Recurring Invoice ks



    Is there a way to create a Recurring invoice, or a service for a client that will beRecurring for that invoice?

    thx.

    DB:2.74:Creating A Recurring Invoice ks


    Is there a way to create a Recurring invoice, or a service for a client that will beRecurring for that invoice?

    thx.

  • RELEVANCY SCORE 2.74

    DB:2.74:Excise Invoice Before Commercial Invoice sf



    Dear All,

    Export Sale the scenario is as follows.

    Date is creation date.

    Order- 1-12-2011

    Delivery- 1-12-2011

    Excise invoice-1-12-2011

    Commercial invoice-7-12-2011

    How to achieve this since system doesn't allow to create excise invoice earlier to commercial invoice.

    Excise invoice need to be created to update same in ARE-1

    Reg,

    amol

    DB:2.74:Excise Invoice Before Commercial Invoice sf


    Dear Amol Tamhane,

    You can create the excise invoice with out creating billing documnet(commercial invoice).

    One way is create proforma invoice with reference to delivery document and create the excise invoice with reference to proforma invoice.

    Second way is create the excise invoice with reference to delivery document.Go to J1IIN click the excise invoice for delivery.

    Let me know if you have any further clarifications

    ThanksRegards

    Raghu.k

  • RELEVANCY SCORE 2.74

    DB:2.74:View Navigation 8s



    Hi all,

    I should need to create a navigation from method "WDDOMODIFYVIEW" but it dumps... Do anyone know some expedient in order to avoid this problem?

    Thanks

    GN

    DB:2.74:View Navigation 8s


    hi,

    You can go for the following link for View Navigation.

    http://help.sap.com/saphelp_nw04s/helpdata/en/1f/464941db42f423e10000000a155106/frameset.htm

    This might help you.

    Thanx.

  • RELEVANCY SCORE 2.74

    DB:2.74:Closing Of Proforma Invoice ff


    is the only way to close a proforma invoice is to create an actual invoice?

    DB:2.74:Closing Of Proforma Invoice ff

    10x I'll check thatby doing this, will I still be able to generate a report of all invoices and proforma invoices that were generated in a certain period? how? (I hope this action will not delete the history)

  • RELEVANCY SCORE 2.73

    DB:2.73:Multiple Invoice Batches kx


    How do I create multiple invoice batches with
    a single submission of Payables open interface import.

    DB:2.73:Multiple Invoice Batches kx

    How do I create multiple invoice batches with
    a single submission of Payables open interface import.

  • RELEVANCY SCORE 2.72

    DB:2.72:Chunk Clob Code mj


    Francios and All,

    I tested Francios below code. I think there is a bug in this I ran this code from forms6i version. First time I ran it got the data into into LC$Chunk and ran it second and more time in the same session got empty data(nothing) in LC$Chunk .

    Can somebosy help!

    CREATE OR REPLACE PACKAGE Pkg_Clob
    IS
    -- populate the CLOB column --
    FUNCTION select_clob ( PN$id IN NUMBER ) RETURN BOOLEAN ;
    -- Get and return chunks of 4000 bytes --
    FUNCTION Get_Chunk RETURN VARCHAR2 ;
    END ;
    /

    CREATE OR REPLACE PACKAGE BODY Pkg_Clob
    IS

    GL$Clob CLOB ;
    GN$Pos PLS_INTEGER := 1 ;

    FUNCTION select_clob ( PN$id IN NUMBER ) RETURN BOOLEAN
    IS
    BEGIN
    GL$Clob := EMPTY_CLOB(); ---tested with and without this clause
    SELECT TEXT
    INTO GL$Clob
    FROM TEST_CLOB
    WHERE ID = PN$id ;

    RETURN TRUE ;
    EXCEPTION
    WHEN OTHERS THEN
    RETURN FALSE ;
    END select_clob ;

    FUNCTION Get_Chunk RETURN VARCHAR2
    IS
    LC$Chunk VARCHAR2(4000) ;
    LN$pos PLS_INTEGER := 1 ;
    BEGIN
    LC$Chunk := SUBSTR( GL$Clob, GN$Pos, 4000 ) ;
    GN$Pos := GN$Pos + 4000 ;
    RETURN LC$Chunk ;
    EXCEPTION
    WHEN OTHERS THEN
    RETURN NULL ;
    END Get_Chunk ;

    END ;
    /

    And this is the code I use in a Forms program unit :

    PROCEDURE write_file IS
    LC$Chunk Varchar2(4000) (null );--tried with null and without null
    LN$Cpt pls_integer := 0 ;
    BEGIN

    If pkg_clob.select_clob(11) then
    loop
    LC$Chunk := pkg_clob.get_chunk ;
    message('LC$Chunk '||LC$Chunk );
    exit when LC$Chunk is null ;
    ln$Cpt := LN$Cpt + 1 ;
    end loop ;
    End if ;

    message('cpt = ' || ln$cpt ) ;

    END;

    Thanks
    Rebecca

    DB:2.72:Chunk Clob Code mj

    Wow!!!! I shuld have figured it out. No wonder I am getting older.

    Thanks

  • RELEVANCY SCORE 2.72

    DB:2.72:T Code To Create Invoice 8p



    Hi Friends,

    What is the t code to create invoice?

    regards

    DB:2.72:T Code To Create Invoice 8p


    Dear Mr Amit,

    T-Code for FI Invoices:-

    Vendor:- FB60/F-43

    Customer:- FB70

    FI Invoice Verification flowing from MM Module:-MIR7(Parking)/MIRO(Posting)

    Regards,

    Alok

  • RELEVANCY SCORE 2.72

    DB:2.72:Creating An Invoice zf


    How do I create a simple invoice? Is there a step by step guide?

    DB:2.72:Creating An Invoice zf

    Try the following 2 links. The first is very short focused on invoices, the second gives a fuller walkthrough of the wider sales process from opportunity through to invoice:

    http://www.magnetism.co.nz/blog/11-05-11/Adding_Products_to_an_Invoice_in_Dynamics_CRM_2011.aspx
    http://www.dynamicscrmtrickbag.com/2011/04/05/crm2011_opportunity_improvements/

    Paul Dowman, CRM Developer

  • RELEVANCY SCORE 2.72

    DB:2.72:Want To Differentiate Between Cancelled Invoice New Invoice Created md



    Dear consultants,

    When we cancel an invoice then create new invoice for the same order , then the cancelled invoice correct invoice have the same code (F2) and same number range, so here is the problem when we want to print group of invoices from transaction (VF31) i can't differentiate between the correct invoice the cancelled one

    Is There Any Solution For such problem ?

    DB:2.72:Want To Differentiate Between Cancelled Invoice New Invoice Created md


    Yes , here is the problem the only filter that i can use is in the ( Billing Doc. Number) and the user can't differentiate between numbers because cancelled and correct invoice have the same number range.

  • RELEVANCY SCORE 2.72

    DB:2.72:Vendor Invoice Number Range ks



    Dear gurus,

    Where i will create vendor invoice number range for 2007.

    DB:2.72:Vendor Invoice Number Range ks


    IN the Creation of Document types. Go to FBN1 and create/maintain the ranges for documents. GO to the doc type(OBA7) u r using for Invoice posting most probably KR and assing the number range to that .

    Assign points if helpful.

  • RELEVANCY SCORE 2.71

    DB:2.71:Invoice Not Reference Original Doc 3f



    Hi Gurus,

    I am reversal invoice and create new invoice but some time the new invoice has OrigDocNo. (Old invoice), some invoice not has reference OrigDocNo. (Old invoice). please let me know.

    and How I can get the OrigDocNo. (Old invoice) for new invoice.

    Best Regards,

    Supperkorn.

    DB:2.71:Invoice Not Reference Original Doc 3f


    hi

    did u check it from the print document gernerated .it must be there i that i hope .pls have a loot

    kr

    raj

  • RELEVANCY SCORE 2.71

    DB:2.71:Invoice Price 13



    Hi

    how to create invoice price more than grn price.which place settings available,plz help,

    Regards

    mohan

    DB:2.71:Invoice Price 13


    You can post Logistics Invoice with price different from PO price.

    The impact depends on your customising settings.

    If the price difference is with tolerance limits as defined by customising, then you will be allowed to post the invoice.

    Otherwise you will get errors or warnings.

    Price difference account may be hit if you are using standard price.

    Please explain your problem in more detail, preferable with a business example.

    It will help in getting more specific answers.

  • RELEVANCY SCORE 2.71

    DB:2.71:Creation Of Excise Invoice kd



    Hi,

    Can anybody give steps in detail to create an excise invoice.

    chan

    DB:2.71:Creation Of Excise Invoice kd


    Excise Invoice is created based on Proforma Invoice or Invoice (based on configuration, it can also be Delivery). The Process Flow will be as under:

    Process 1:

    Sales Order (VA01 / VA02 / VA03) -- Delivery (VL10A / VL10C / VL01N / VL02N ? VL03N / VL04) -- PGI (VL02N) -- Proforma Invoice (VF01 / VF02 / VF03) -- Excise Invoice (J1IIN)

    Process 2:

    Sales Order (VA01 / VA02 / VA03) -- Delivery (VL10A / VL10C / VL01N / VL02N ? VL03N / VL04) -- PGI (VL02N) -- Invoice (VF01 / VF02 / VF03) -- Excise Invoice (J1IIN)

    Regards,

    Rajesh Banka

    Reward suitable points.

  • RELEVANCY SCORE 2.70

    DB:2.70:Sto Excise Invoice 1a



    Dear all,

    after creating delivery for STO how to create excise invoice from supplying plant

    How to post this excise invoice in receiving plant.

    Thanks,

    rajan

    DB:2.70:Sto Excise Invoice 1a


    Hi,

    After doing post goods issue ...go to me23n enter po ..in item details tab under purchase order history tab ...check the material document number ...copy that mat doc number goto j1is ...post excise invoice...enter the material doc number ...save it

    Recieving plant ...after GR go to j1iex_c T.code capture excise invoice ...goto to j1iex_p post it.

  • RELEVANCY SCORE 2.70

    DB:2.70:Ap Invoice With No Tax zj



    When creating an AP service and item invoice (no PO or GR are linked) the tax components are not included.

    When creating a PO GN AP Invoice the tax component is included automatically.

    Currently on PL39, US / AUS localisation.

    Please assist?

    DB:2.70:Ap Invoice With No Tax zj


    Hi ,

    Please concerne dwith SAP People .

    Rgds,

    Premraj

  • RELEVANCY SCORE 2.70

    DB:2.70:Mbrl Direct Printing cs



    dear all ,

    while i m create a rejection invoice so where i print this rejection invoice

    i want to rejection invoice print direct mbrl

    or print direct some toher tcode

    regards

    pritpal

  • RELEVANCY SCORE 2.70

    DB:2.70:Excise Invoice From Proforma pa



    Hi

    i have created a proforma invoice and with reference to proforma i am trying to create excise invoice

    but in J1iin the excise values are not flowing

    regards

    DB:2.70:Excise Invoice From Proforma pa


    Dear Rithvika

    Some of the areas you need to check are

    - first check is whether the value is flowing in proforma. If not, maintain the delivering plant and click on update button in billing at condition tab

    - if value is flowing in proforma but not in excise invoice, go to IMG path -- Logistics-General -- Tax on Goods Movements -- India -- Account Determination. There check both in Specify Excise Accounts and Specify G/L Accounts tabs whether you have maintained the required datas

    - Go to J1ID, select Material and Chapter ID combination and execute. There ensure that "1" is maintained under the tab "Declared".

    thanks

    G. Lakshmipathi

  • RELEVANCY SCORE 2.70

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

    DB:2.69:Need Help Using Adplus For First Time 19


    I need to diagnose an out-of-memory exception in a .NET 3.0 Winform app occurring in a production environment (can't reproduce on a dev system)...After reading about how to diagnose these types of problem, I think I need to run ADPlus to get a full dump and then use WinDbg (with SOS) to see what objects are on the managed heap...Questions:1) For my purposes, do I only need to perform what ADPlus calls a FullDump? Or do I also need Stack, Stacks and/or LoadedModules (or anything else)? I sure don't want to get into the situation where I've asked the user to run ADPlus and get a dump, only to later learn I need something else! 2) How the @%$! does one configure ADPlus so that it will intercept (only) the out-of-memory exception? I've been experimenting all afternoon and still haven't figured-it out..Here's my ADPlus config file:ADPlus Settings         ProcessName (name of my .exe) /ProcessName         RunMode CRASH /RunMode         OutputDir C:\temp /OutputDir /Settings Exceptions        Option  NoDumpOnFirstChance  /Option        Option  NoDumpOnSecondChance  /Option  Config           Code 0x8007000E /Code       === I assume this is Out-Of-Memory, right???           Actions2FullDump/Actions2           ReturnAction2 QD /ReturnAction2    /Config   /Exceptions/ADPlusAnd below is the ADPlus report file - notice that it says that it read my config file, but then the summary of Current Actions for Exceptions lists a lot of other exceptions, but not mine!And it does seem to be honoring my OutputDir setting, so I don't think it's completely ignoring my config file.But the bottom line: it doesn't dump on the OOM exception (which I artificially induce on my dev system), but instead dumps only when the app shuts down (weird)Thanks for any guidance on this...DTADPlus_report.txt:ADPlus Version: 6.03.006ADPlus Version Date: 12/16/2008OS Version: 5.1OS Build: 2600DateTimeStamp: Date_06-26-2009__Time_15-56-13PMADPlus was run on: NPSINB12Debuggers Installation Directory: C:\Program Files\Debugging Tools for Windows (x86) Command line arguments used were: -c c:\temp\usm.cfg Script engine Version: 5.7.18066   WARNING!  An '_NT_SYMBOL_PATH' environment variable is not set, as a result ADPlus will be forced to use 'export' symbols (if present) to resolve function names in the stack trace information for each thread listed in the log file for the processes being debugged.  To resolve this warning, please copy the appropriate symbols to a directory on the server and then create an environment variable with a name of '_NT_SYMBOL_PATH' and a value containing the path to the proper symbols (i.e. c:\winnt\symbols) before running ADPlus in quick or crash modes again.  NOTE:  After creating the '_NT_SYMBOL_PATH' system environment variable you will need to close the current command shell and open a new one before running ADPlus again.Selected debugger: cdb.exeOutput Directory: C:\temp\Crash_Mode__Date_06-26-2009__Time_15-56-13PM  g_Debug_Log = Trueg_CheckFreeSpace = True  ------ !!! External Configuration File was used: ----    c:\temp\myADPlus.cfg  ------ Current Actions for Exceptions ----  AccessViolation [av]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  InvalidHandle [ch]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  IllegalInstruction [ii]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  IntegerDivide [dz]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  FloatingDivide [c000008e]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  IntegerOverflow [iov]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  InvalidLockSequence [lsq]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  StackOverflow [sov]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  CPlusPlusEH [eh]       return: GN GN      1st chance: Log;Time;Stack      2nd chance: Log;Time;Stack;EventLog  UnknownException [*]       return: GN GN      1st chance: Log;Time;Stack      2nd chance: Log;Time;Stack;EventLog  NET_CLR [clr]       return: GN GN      1st chance: VOID      2nd chance: Log;Time;Stack;EventLog  CONTRL_C_OR_Debug_Break [bpe]       return: Q GN      1st chance: Log;Time;EventLog;Stacks;LoadedModules;MatchingSymbols;MiniDump      2nd chance:   Wake_Debugger [wkd]       return: Q GN      1st chance: Log;Time;EventLog;Stacks;LoadedModules;MatchingSymbols;      2nd chance:   DLL_Load [ld]       return: GN GN      1st chance: Log      2nd chance: Log  DLL_UnLoad [ud]       return: GN GN      1st chance: Log      2nd chance: Log  Process_Shut_Down [epr]       return: VOID VOID      1st chance: Log;Time;EventLog;Stacks;FullDump      2nd chance:   Application_hang [aph]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  Ctl_C_Console_app [cce]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  Data_misaligned [dm]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  Guard_page_violation [gp]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  In_page_IO_error [ip]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  Invalid_system_call [isc]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLog  Stack_buffer_overflow [sbo]       return: GN GN      1st chance: Log;Time;Stack;      2nd chance: Log;Time;Stack;EventLogStarting to attach the debugger to each processAttaching to 4656 - (name of my .exe)

    DB:2.69:Need Help Using Adplus For First Time 19

    Hello,
    Adplus automates the CDB debugger to produce memory dumps and log files that contain debug output from one or more processes.A full user-mode dump is the basic user-mode dump file. It includes the entire memory space of a proces, the program's executable image itself, the handle table, and other information that will be useful to the debugger.
    Hence, to answer you question: 1. It's enough if we have a full-dump file 2. please note that there are general three scenarios for us to use ADPlus: process stops or hangs and process consumes 100 percent CPU.
    For more information on how to use ADPlus, please refer to: http://support.microsoft.com/kb/286350/en-usBest regards,Please remember to mark the replies as answers if they help and unmark them if they provide no help.If you have any feedback, please tell us.
    Welcome to the All-In-One Code Framework!

  • RELEVANCY SCORE 2.69

    DB:2.69:Sap B1- A/R Invoice 7p



    Hi Friends !

    I am trying to create a A/R invoice but when click on Sales - A/R Invoice, it showz the exchange rates screen. Please refer attachment.

    With Regards

    Rekha

    DB:2.69:Sap B1- A/R Invoice 7p


    Hi Rekha,

    1. This is standard system behavior. If you add AR invoice for foreign currency, exchange rate and indexes window appear.

    2. After adding exchange rate in above window, you can AR invoice.

    3. Based on your company, you can set fixed exchange rate for whole month to avoid step 1 and 2.

    Thanks Regards,

    Nagarajan

  • RELEVANCY SCORE 2.69

    DB:2.69:Report On Missing Invoice cz


    Dear All,

    i want to create an report which has all missing invoice no (e.g November invoice posted were from 1000001 to 1000100 how do we check if all the invoices has been entered)

    Table INVOICE_MASTER
    Column NAMe
    Invoice no
    Invoice date
    Invoice Type

    How can i create that report.

    Thanks

    DB:2.69:Report On Missing Invoice cz

    Sample: How to find gaps in a sequence with CTE
    with testdata as (
    select 1000000 + 2*level inv from dual
    connect by level 51
    )
    , r (n, i) as (
    select min(inv) n, 0 inv from testdata
    union all
    select n + 1, inv
    from r, testdata
    where
    r.n+1=inv(+)
    )

    select * from r
    where
    i is null

    NI
    1000003-
    1000005-
    1000007-
    1000009-
    1000011-
    1000013-
    1000015-

  • RELEVANCY SCORE 2.69

    DB:2.69:Sales Order With Reference To The Invoice zs



    How can we create a sales order with reference to the invoice

    DB:2.69:Sales Order With Reference To The Invoice zs


    Its not the sales order, it is called as Return Order.

    For the customer invoice will be generated and once the goods are shipped to customer, if there are any parts that need to be replaced or any part is damaged, he will send the parts back to the client based on the invoice. Here the client will create a return order based on the Invoice.

    In the sales order if there are any Service items, a purchase order shall be created. So based on the customer invoice, Sales order will be fetched and then the corresponding Purchase Order and for the Purchase order a credit/debit memo will be created.

    For the Return Order: BAPI_CUSTOMERRETURN_CREATE

    MIRO Invoice: BAPI_INCOMINGINVOICE_CREATE

    Check the link below:

    [Re: program to create Debit and Credit Memos;

    Regards

    Kannaiah

    Edited by: Kannaiah Kavuri on Jun 24, 2008 11:54 AM

  • RELEVANCY SCORE 2.69

    DB:2.69:Proforma Invoice 3j



    Hi,

    can anybody pls tell me

    How to create Proforma invoice final invoice with the same order type.

    Regards,

    rahul

    DB:2.69:Proforma Invoice 3j


    Hi

    Proforma inv can be created with ref to order and del

    F8 is the proforma inv which is created with ref to del in std SAP

    F5 is the proforma inv which is created with referance to order in std SAP

    Proforma inv is a type of billing doc which is used for export transactions which gives info abt billing but it cant be treated as an actual billing doc or even as a duplicate bill

    No billing doc can be created referring Proforma inv

    You can give as many as Proforma inv to a customer because billing status doesnt get updated

    The final actual billing can differ from the details given inProforma inv

    Data from Proforma inv doesnt get transferred to accounting

    Regards

    Raja

  • RELEVANCY SCORE 2.68

    DB:2.68:Create New Proforma Invoice kc



    Dear Gurus,

    Created Proforma Invoice ZJE1 against delivery, now we would like to create new proforma invoice as there are some correction,

    We are not able to cancel proforma Invoice as the proforma invoice can not be cancelled neither we are able to complete the document by going into VF02

    Guide us how to create new proforma Invoice.

    Regards

    Rajesh T

    DB:2.68:Create New Proforma Invoice kc


    Dear rajesh,

    Goto VOFA and select the billing type ZJE1 , click on details , in cancellation section , check whether you have assigned cancellation billing type as S1 .

    if not assign and complete from VF02 , then go far new performa with the same delivery number .

    saravanan

  • RELEVANCY SCORE 2.68

    DB:2.68:Autogeneration Of Invoice p7



    Dear All,

    Is it possible to create autogenerate invoice with reference to Sales Order

    Thanks Regards,

    PM

    DB:2.68:Autogeneration Of Invoice p7


    Hello,

    Based from experience, if the invoice is only "order-related" you can set auto-invoice generation by the use of order confirmation output type however it will entail ABAP codes.

    However, if SO is "delivery-related" its a good idea if you set auto-invoice generation after the delivery has been "goods-issued".

    Steps:

    1. Create Output Control for Sales Documents using tcode V/30 (for order related) and V/34 .(for delivery related).

    2. In SPRO, under path

    a. order related:

    SDBasic Functions Output Control Sales Documents Maintain Output Determination Procedure.

    b. delivery related:

    Logistics ExecutionShipping Basic Shipping FunctionsOutput Control Output Determination Outbound Deliveries Maintain Output Determination Procedure.

    There is a field allocated for "requirement", you can let your ABAP create a routine / logic that once SO or Delivery is completed, it will auto-create / generate an invoice.

    3. Just make sure that you will maintain that order confirmation output type via VV11 (SO) and VV21 (delivery) so that if will also auto populate SO and Delivery output .

  • RELEVANCY SCORE 2.68

    DB:2.68:Invoice And Foreing Trade 1k



    Hi,

    Create billing document (2 delivery- need 1 invoice)

    split analy.: Split due to differing header data: Number of foreign trade (EIKP-EXNUM)

    how we can create 1 invoice?

    thanks.

    DB:2.68:Invoice And Foreing Trade 1k


    Hi,

    By using T.code VF24 u can process collective/comman invoicing.

  • RELEVANCY SCORE 2.68

    DB:2.68:Documents At The Time Of Invoice Verification 1c



    hi,

    If I want to create the more than 2 MM invoice documents at the time of invoice verification, where should I do the configuration?

    Amit

  • RELEVANCY SCORE 2.68

    DB:2.68:Remove The Default Create Invoice Button js


    does anyone know how to remove the default Create Invoice button in the Sales Order screen?We have created our own ISV page to create the invoice as our business process is very different. is it possible to remove the create invoice button through javascript of customisation?

    DB:2.68:Remove The Default Create Invoice Button js

    You can use IE Developer toolbar to get IDhttp://www.microsoft.com/downloads/details.aspx?FamilyID=E59C3964-672D-4511-BB3E-2D5E1DB91038displaylang=enMahain

  • RELEVANCY SCORE 2.68

    DB:2.68:Creating Invoice List x7


    Hi,Please let me know how to create a invoice list.What settings am I supposed to maintain?Urgent.

    DB:2.68:Creating Invoice List x7

    Hi pinkey,Go through this linkuhttp://help.sap.com/saphelp_erp2005vp/helpdata/en/dd/561129545a11d1a7020000e829fd11/frameset.htm/uHope this will be helpfulReward if helpfulMohan

  • RELEVANCY SCORE 2.68

    DB:2.68:Convert Proforma Invoice To Invoice 78



    Hello,

    We are using Order related Proforma Invoice (F5) with the same number range as Invoice (F2).

    Is there a way we can convert the same F5 Proforma Invoice into actual Invoice (F2) OR do we have to create a separate invoice for Accounting.

    Thanks.

    DB:2.68:Convert Proforma Invoice To Invoice 78


    HI

    As far as i know there is no functionality to convert a proforma invoice to invoice.

    You have to create a F2 invoice inorder to post the values into accounting

    regards

  • RELEVANCY SCORE 2.68

    DB:2.68:Create A/R Invoice + Payment (One Time Customer) = Di 1s



    Dear SDKers ...

    Do you know how to create Create A/R Invoice + Payment (One Time Customer) using DI Object . Because I've tried using seperated process create Invoice First and then Payment but the results appear in A/R Invoice "General" Form. I want to Create A/R Invoice + Payment that appearewd in A/R Invoice + Payment Form . Do you have an idea or work around ?

    Thanks All

    HamdiSy

    DB:2.68:Create A/R Invoice + Payment (One Time Customer) = Di 1s


    Hi Hamdi,

    It is just a flag (IsICT) in OINV that makes the difference - and I think it is really the only difference that causes a record to be shown in the "A/R Invoice + Payment" form instead of the standard "A/R Invoice" form.

    This flag is apparently only set by the application when it saves such an Invoice; it is not accessible through DI's Documents object so that you are not allowed to manipulate it.

    Sorry,

    Frank

  • RELEVANCY SCORE 2.68

    DB:2.68:Cin Settings For Order Releated Invoice km



    Please let me know what settings should be made to create excise inovoice of order releated invoice?

    DB:2.68:Cin Settings For Order Releated Invoice km


    Hi Rohit

    The t code J1IH is a excise JV In that you can determine whatever values you want to post and for whatever materials

    you want to have the excise invocie created for

    this would generate a excise invocie for order related sales order

    Thanks

    Akasha

  • RELEVANCY SCORE 2.68

    DB:2.68:Create Excise Invoice With Diapi 1d



    Dear all,

    Is it possible to create Incomming / Outgoing Excise Invoice through DIAPI.

    Thanks in Advance,

    DB:2.68:Create Excise Invoice With Diapi 1d


    I have not to find any object for create Incomming / Outgoing Excise Invoice through DIAP

  • RELEVANCY SCORE 2.68

    DB:2.68: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.68: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.68

    DB:2.68:Re: Ignore The Cancelled Invoice To Create Accounting ps


    We are in 12.1.3.

    DB:2.68:Re: Ignore The Cancelled Invoice To Create Accounting ps

    do you able to achieve it ???

    If yes then how ?

    We need to avoid the accounting of all unapproved invoices.

    Thanks
    -Shivdeep Singh

  • RELEVANCY SCORE 2.68

    DB:2.68:Ar Auto Invoice + Purchase Order In Ra_Itnerface_Lines_All z1


    Hi,

    Want to know how Auto Invoice would behave if there are different purchase order values in ra_interface_lines_all for same set of mandatory columns. The objective here is for Auto Invoice to create only one invoice.

    In the above scenario, will it end up creating one invoice or more than one invoice.

    Am looking information based on any accepted behavior of Auto Invoice or any URLs or metalink notes.

    Thanks
    SR

    DB:2.68:Ar Auto Invoice + Purchase Order In Ra_Itnerface_Lines_All z1

    Hi

    If PO number is different for the order lines, irrespective of same set of mandatory columns and grouping rule, Auto Invoice will create separate Invoice one per PO

    Let me try to understand from business, why would customer wants one Invoice when they have raised multiple Purchase orders

    Thanks
    krishna

  • RELEVANCY SCORE 2.68

    DB:2.68:Create An Intercompany(Iv) Based On Commercial Invoice(F2) j8



    Dear Experts,

    Understand intercompany invoice can be created againest delivery but Is there any transaction to create intercompany invoice (IV) based on comercial invoice (F2).

    Actulay i want to consolidate muliple invoice(f2) to one IV.

    Regards

    Viswanath.

    DB:2.68:Create An Intercompany(Iv) Based On Commercial Invoice(F2) j8


    Hello Viswanath,

    that functionality does not exist in SAP.

    I'm sorry for the negative answer.

    Best regards,

    Ivano.

  • RELEVANCY SCORE 2.68

    DB:2.68:Adding Invoice + Payment Simultaneously pk



    Dear All,

    How can we add Invoice+payment every time we create a invoice for all the cust n vendors

    Regards

    agranshu

  • RELEVANCY SCORE 2.68

    DB:2.68:Excise Invoice z9


    I created excise invoice for particular invoice .How excise invoice cancelled?Can I create the excise invoice again with same invoice?

    DB:2.68:Excise Invoice z9

    Thanks for ur valuable suggestions

  • RELEVANCY SCORE 2.68

    DB:2.68:Master Data Distribution Possible For Invoic01 ? ja



    Hi all,

    is it possible to send an Invoice document from quality system to development system through Master Data distribution? I would like send an Invoice from quality filling Idoc INVOIC01 automatically in Development system, like I do with Material, Customer, Vendor... but I am not able to find transaction, does anyone know if this is possible?

    thanks

    GN

    Moderator message: subject corrected, please use a more meaningful one next time.

    Edited by: Thomas Zloch on Mar 8, 2010 1:08 PM

    DB:2.68:Master Data Distribution Possible For Invoic01 ? ja


    Hi,

    Invoice data belong from "Transaction data" categoery and for this we have message control settings to distribute data across systems. If you want to distribute invoice data like Material master, Customer Master and Vendor master, try to develop a report like BD10, BD12, and BD14 to generate idoc with invoice data and do the all required ALE settings.

    Thanks,

    Asit Purbey.

  • RELEVANCY SCORE 2.68

    DB:2.68:Ref: Non Po Invoice az



    Hi experts

    what is the non PO vendor invoice how can we create non PO vendor invoice in SAP?

    could you please tell me...

    DB:2.68:Ref: Non Po Invoice az


    Hi,

    Non PO vendor is a payment to vendor with out a PO .FI will directly post the vendor invoice sent with out referencing a PO.You may check at FB60/F-43.

    Regards,

  • RELEVANCY SCORE 2.68

    DB:2.68:Invoice Hold 13


    Need to create custom script which checks Invoice Date and PO Delivery date while matching, if valid then applies HOLD?

    DB:2.68:Invoice Hold 13

    Need to create custom script which checks Invoice Date and PO Delivery date while matching, if valid then applies HOLD?

  • RELEVANCY SCORE 2.68

    DB:2.68:Xml Report f3


    DEAR SIR
    CAN I CREATE XML OUTPUT AS BELOW FROM BI PUBLISHER PLEASE HELP

    INVOICE-HEADER
    INVOICE-PARTICULARS SL-NO="1"
    INVOICE-NUMBER1/INVOICE-NUMBER
    INVOICE-DATE14/09/2011/INVOICE-DATE
    INVOICE-ITEMS
    DESCRIPTION-OF-GOODSPrime Carbon Steel Seamless Pipe/DESCRIPTION-OF-GOODS
    CETSH-NUMBER73049000/CETSH-NUMBER
    QUANTITY-CODEKG/QUANTITY-CODE
    QUANTITY40/QUANTITY
    AMOUNT-OF-DUTY-INVOLVED3699/AMOUNT-OF-DUTY-INVOLVED
    /INVOICE-ITEMS
    /INVOICE-PARTICULARS
    INVOICE-PARTICULARS SL-NO="2"
    INVOICE-NUMBER2/INVOICE-NUMBER
    INVOICE-DATE14/09/2011/INVOICE-DATE
    INVOICE-ITEMS
    DESCRIPTION-OF-GOODSPrime Carbon Steel Seamless Pipe/DESCRIPTION-OF-GOODS
    CETSH-NUMBER73049000/CETSH-NUMBER
    QUANTITY-CODEKG/QUANTITY-CODE
    QUANTITY70/QUANTITY
    AMOUNT-OF-DUTY-INVOLVED6474/AMOUNT-OF-DUTY-INVOLVED
    /INVOICE-ITEMS
    INVOICE-ITEMS
    DESCRIPTION-OF-GOODSPrime Carbon Steel Seamless Pipe/DESCRIPTION-OF-GOODS
    CETSH-NUMBER73049000/CETSH-NUMBER
    QUANTITY-CODEKG/QUANTITY-CODE
    QUANTITY79/QUANTITY
    AMOUNT-OF-DUTY-INVOLVED7306/AMOUNT-OF-DUTY-INVOLVED
    /INVOICE-ITEMS
    /INVOICE-PARTICULARS
    /INVOICE-HEADER

    DB:2.68:Xml Report f3

    The main diffuculty I see is the tag attributes, such as SL-NO="1". To effect tag attributes, you may use XSLT to transform your data. It will be easier if you do not require those little bits of extra information in your XML tags.

  • RELEVANCY SCORE 2.68

    DB:2.68:Function Module For Invoice Posting 13



    Is there any Function Module to create upload session for invoice posting using FB60 or MIRO.

    DB:2.68:Function Module For Invoice Posting 13


    For FB60, you can use standard SAP program RFBIBL00.

    Rob

  • RELEVANCY SCORE 2.68

    DB:2.68:Plant Invoice Detail From Depot Invoice (Only After Easter) am



    I want to get Factory Invoice No. on base of Depot Invoice.

    In depot location

    Migo and

    create Seprate Sales order / Delivery / Invoice.

    How can it trace Factory invoice (Billing Document No.) for creating smartforms for Depot invoice.

    if anyone have logic about the same or smartforms pl. post the solution.

    Edited by: Julius Bussche on Apr 10, 2009 8:38 AM

    Please read the forum rules

  • RELEVANCY SCORE 2.68

    DB:2.68:Required Bapi For Vendor Invoice Creation 7x



    Hi,

    The transaction code for creation a vendor invoice is FB60. Is there any BAPI to create VENDOR INVOICE.

    Regards!

    kannan

  • RELEVANCY SCORE 2.68

    DB:2.68:Invoice Before Delivery. 7x



    Hello all,

    is it possible create Invoice before Delivery?

    in normal case we are using t.code VF01 after delivery.

    T

    DB:2.68:Invoice Before Delivery. 7x


    Hi,

    No,it is not possible to create the billing document before the delivery document if your item category is relevant for delivery.

    But you can create the invoice before PGI.

    Regards,

    Krishna.

  • RELEVANCY SCORE 2.68

    DB:2.68:How Do I Creat An Invoice 8f



    i would like to create an invoice. can anyone tell how to do ?

    DB:2.68:How Do I Creat An Invoice 8f


    Follow this link... it will help you in creating invoice.

    a href="http://web.mit.edu/CAO/www/SB2002/AR/F-22.htm"INVOICE/a

    Close the thread if your question is answered.

    Regards,

    SaiRam

  • RELEVANCY SCORE 2.68

    DB:2.68:How To Know Who Is Wpr (Invoice) Approvaler? 9x



    Dear All,

    I create an invoice on EBP webpage. but How to check who will approval this invoice?

    Thanks.

  • RELEVANCY SCORE 2.68

    DB:2.68:Smart Form kx



    How will u create smart from for invoice pls urgent

    DB:2.68:Smart Form kx


    Hi

    SAP has given some std smartforms for most of the outgoing documents

    INVOICE

    Output type : RD00

    ScriptForm Name : RVINVOICE01

    Driver Program Name : RVADIN01

    smartform name : bLB_BIL_INVOICE/b

    Smartform Driver Pgm: bRLB_INVOICE/b

    see the following smartform LB_BIL_INVOICE and copy it to ZSFORM and do the changes and attach the changed smartform in NACE tcode to the driver program and output type and execute the output from VF02 Tcode

    if you wants to design your own smartform see the following doc and do accordingly

    How to create a New smartfrom, it is having step by step procedure

    http://sap.niraj.tripod.com/id67.html

    step by step good ex link is....

    http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.html

    Here is the procedure

    1. Create a new smartforms

    Transaction code SMARTFORMS

    Create new smartforms call ZSMART

    2. Define looping process for internal table

    Pages and windows

    First Page - Header Window (Cursor at First Page then click Edit - Node - Create)

    Here, you can specify your title and page numbering

    SFSY-PAGE (Page 1) of SFSY-FORMPAGES(Z4.0) (Total Page)

    Main windows - TABLE - DATA

    In the Loop section, tick Internal table and fill in

    ITAB1 (table in ABAP SMARTFORM calling function) INTO ITAB2

    3. Define table in smartforms

    Global settings :

    Form interface

    Variable name Type assignment Reference type

    ITAB1 TYPE Table Structure

    Global definitions

    Variable name Type assignment Reference type

    ITAB2 TYPE Table Structure

    4. To display the data in the form

    Make used of the Table Painter and declare the Line Type in Tabstrips Table

    e.g. HD_GEN for printing header details,

    IT_GEN for printing data details.

    You have to specify the Line Type in your Text elements in the Tabstrips Output options.

    Tick the New Line and specify the Line Type for outputting the data.

    Declare your output fields in Text elements

    Tabstrips - Output Options

    For different fonts use this Style : IDWTCERTSTYLE

    For Quantity or Amout you can used this variable GS_ITAB-AMOUNT(12.2)

    5. Calling SMARTFORMS from your ABAP program

    REPORT ZSMARTFORM.

    Calling SMARTFORMS from your ABAP program.

    Collecting all the table data in your program, and pass once to SMARTFORMS

    SMARTFORMS

    Declare your table type in :-

    Global Settings - Form Interface

    Global Definintions - Global Data

    Main Window - Table - DATA

    Written by : SAP Hints and Tips on Configuration and ABAP/4 Programming

    http://sapr3.tripod.com

    TABLES: MKPF.

    DATA: FM_NAME TYPE RS38L_FNAM.

    DATA: BEGIN OF INT_MKPF OCCURS 0.

    INCLUDE STRUCTURE MKPF.

    DATA: END OF INT_MKPF.

    SELECT-OPTIONS S_MBLNR FOR MKPF-MBLNR MEMORY ID 001.

    SELECT * FROM MKPF WHERE MBLNR IN S_MBLNR.

    MOVE-CORRESPONDING MKPF TO INT_MKPF.

    APPEND INT_MKPF.

    ENDSELECT.

    At the end of your program.

    Passing data to SMARTFORMS

    call function 'SSF_FUNCTION_MODULE_NAME'

    exporting

    formname = 'ZSMARTFORM'

    VARIANT = ' '

    DIRECT_CALL = ' '

    IMPORTING

    FM_NAME = FM_NAME

    EXCEPTIONS

    NO_FORM = 1

    NO_FUNCTION_MODULE = 2

    OTHERS = 3.

    if sy-subrc 0.

    WRITE: / 'ERROR 1'.

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

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

    endif.

    call function FM_NAME

    EXPORTING

    ARCHIVE_INDEX =

    ARCHIVE_INDEX_TAB =

    ARCHIVE_PARAMETERS =

    CONTROL_PARAMETERS =

    MAIL_APPL_OBJ =

    MAIL_RECIPIENT =

    MAIL_SENDER =

    OUTPUT_OPTIONS =

    USER_SETTINGS = 'X'

    IMPORTING

    DOCUMENT_OUTPUT_INFO =

    JOB_OUTPUT_INFO =

    JOB_OUTPUT_OPTIONS =

    TABLES

    GS_MKPF = INT_MKPF

    EXCEPTIONS

    FORMATTING_ERROR = 1

    INTERNAL_ERROR = 2

    SEND_ERROR = 3

    USER_CANCELED = 4

    OTHERS = 5.

    if sy-subrc 0.

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

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

    endif.

    Smartform

    you can check this link here you can see the steps and you can do it the same by looking at it..

    http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.html

    SMARTFORMS STEPS.

    1. In Tcode se11 Create a structure(struct) same like the Internal table that you are going to use in your report.

    2. Create Table type(t_struct) of stracture in se11.

    3. In your program declare Internal table(Itab) type table of structure(struct).

    4. Define work area(wa) like line of internal table.

    5. Open Tcode Smartforms

    6. In form Global setting , forminterface Import parameter define Internal table(Itab) like table type of stracture(t_struct).

    7. In form Global setting , Global definitions , in Global data define Work area(wa) like type stracture(struct).

    8. In form pages and window, create Page node by default Page1 is available.

    9. In page node you can create numbers of secondary window. But in form there is only one Main window.

    10. By right click on page you can create windows or Go to Edit, Node, Create.

    11. After creating the window right click on window create table for displaying the data that you are passing through internal table.

    12. In the table Data parameter, loop internal internal table (Itab) into work area(wa).

    13. In table there are three areas Header, Main Area, Footer.

    14. Right click on the Main area create table line by default line type1 is there select it.

    15. Divide line into cells according to your need then for each cell create Text node.

    16. In text node general attribute. Write down fields of your work area(wa) or write any thing you want to display.

    17. Save form and activate it.

    18. Then go to Environment, function module name, there you get the name of function module copy it.

    19. In your program call the function module that you have copied from your form.

    20. In your program in exporting parameter of function pass the internal table(itab).

    SAP Smart Forms is introduced in SAP Basis Release 4.6C as the tool for creating and maintaining forms.

    SAP Smart Forms allow you to execute simple modifications to the form and in the form logic by using simple graphical tools; in 90% of all cases, this won't include any programming effort. Thus, a power user without any programming knowledge can

    configure forms with data from an SAP System for the relevant business processes.

    To print a form, you need a program for data retrieval and a Smart Form that contains the entire from logic. As data retrieval and form logic are separated, you must only adapt the Smart Form if changes to the form logic are necessary. The application program passes the data via a function module interface to the Smart Form. When activating the Smart Form, the system automatically generates a function module. At runtime, the system processes this function module.

    You can insert static and dynamic tables. This includes line feeds in individual table cells, triggering events for table headings and subtotals, and sorting data before output.

    You can check individual nodes as well as the entire form and find any existing errors in the tree structure. The data flow analysis checks whether all fields (variables) have a defined value at the moment they are displayed.

    SAP Smart Forms allow you to include graphics, which you can display either as part of the form or as background graphics. You use background graphics to copy the layout of an existing (scanned) form or to lend forms a company-specific look. During printout, you can suppress the background graphic, if desired.

    SAP Smart Forms also support postage optimizing.

    Also read SAP Note No. 168368 - Smart Forms: New form tool in Release 4.6C

    What Transaction to start SAP Smart Forms?

    Execute transaction SMARTFORMS to start SAP Smart Forms.

    Key Benefits of SAP Smart Forms:

    SAP Smart Forms allows you to reduce considerably the implementation costs of mySAP.com solutions since forms can be adjusted in minimum time.

    You design a form using the graphical Form Painter and the graphical Table Painter. The form logic is represented by a hierarchy structure (tree structure) that consists of individual nodes, such as nodes for global settings, nodes for texts, nodes for output tables, or nodes for graphics.

    To make changes, use Drag Drop, Copy Paste, and select different attributes.

    These actions do not include writing of coding lines or using a Script language.

    Using your form description maintained in the Form Builder, Smart Forms generates a function module that encapsulates layout, content and form logic. So you do not need a group of function modules to print a form, but only one.

    For Web publishing, the system provides a generated XML output of the processed form.

    Smart Forms provides a data stream called XML for Smart Forms (XSF) to allow the use of 3rd party printing tools. XSF passes form content from R/3 to an external product without passing any layout information about the Smart Form.

    SmartForms System Fields

    Within a form you can use the field string SFSY with its system fields. During form processing the system replaces these fields with the corresponding values. The field values come from the SAP System or are results of the processing.

    System fields of Smart Forms

    SFSY-DATE

    Displays the date. You determine the display format in the user master record.

    SFSY-TIME

    Displays the time of day in the form HH:MM:SS.

    SFSY-PAGE

    Inserts the number of the current print page into the text. You determine the format of the page number (for example, Arabic, numeric) in the page node.

    SFSY-FORMPAGES

    Displays the total number of pages for the currently processed form. This allows you to include texts such as'Page x of y' into your output.

    SFSY-JOBPAGES

    Contains the total page number of all forms in the currently processed print request.

    SFSY-WINDOWNAME

    Contains the name of the current window (string in the Window field)

    SFSY-PAGENAME

    Contains the name of the current page (string in the Page field)

    SFSY-PAGEBREAK

    Is set to 'X' after a page break (either automatic [Page 7] or command-controlled [Page 46])

    SFSY-MAINEND

    Is set as soon as processing of the main window on the current page ends

    SFSY-EXCEPTION

    Contains the name of the raised exception. You must trigger your own exceptions, which you defined in the form interface, using the user_exception macro (syntax: user_exception exception name ).

    Example Forms Available in Standard SAP R/3

    SF_EXAMPLE_01

    Simple example; invoice with table output of flight booking for one customer

    SF_EXAMPLE_02

    Similar to SF_EXAMPLE_01 but with subtotals

    SF_EXAMPLE_03

    Similar to SF_EXAMPLE_02, whereby several customers are selected in the application program; the form is called for each customer and all form outputs are included in an output request

    Advantages of SAP Smart Forms

    SAP Smart Forms have the following advantages:

    1. The adaption of forms is supported to a large extent by graphic tools for layout and logic, so that no programming knowledge is necessary (at least 90% of all adjustments). Therefore, power user forms can also make configurations for your business processes with data from an SAP system. Consultants are only required in special cases.

    2. Displaying table structures (dynamic framing of texts)

    3. Output of background graphics, for form design in particular the use of templates which were scanned.

    4. Colored output of texts

    5. User-friendly and integrated Form Painter for the graphical design of forms

    6. Graphical Table Painter for drawing tables

    7. Reusing Font and paragraph formats in forms (Smart Styles)

    8. Data interface in XML format (XML for Smart Forms, in short XSF)

    9. Form translation is supported by standard translation tools

    10. Flexible reuse of text modules

    11. HTML output of forms (Basis release 6.10)

    12. Interactive Web forms with input fields, pushbuttons, radio buttons, etc. (Basis-Release 6.10)

    for Smartforms material

    http://www.sap-basis-abap.com/sapsf001.htm

    http://www.sap-press.com/downloads/h955_preview.pdf

    http://www.ossincorp.com/Black_Box/Black_Box_2.htm

    http://www.sap-img.com/smartforms/sap-smart-forms.htm

    http://www.sap-img.com/smartforms/smartform-tutorial.htm

    http://www.sapgenie.com/abap/smartforms.htm

    How to trace smartform

    http://help.sap.com/saphelp_47x200/helpdata/en/49/c3d8a4a05b11d5b6ef006094192fe3/frameset.htm

    http://www.help.sap.com/bp_presmartformsv1500/DOCU/OVIEW_EN.PDF

    http://www.sap-img.com/smartforms/smart-006.htm

    http://www.sap-img.com/smartforms/smartforms-faq-part-two.htm

    Re: Need FAQ's

    check most imp link

    http://www.sapbrain.com/ARTICLES/TECHNICAL/SMARTFORMS/smartforms.html

    step by step good ex link is....

    http://smoschid.tripod.com/How_to_do_things_in_SAP/How_To_Build_SMARTFORMS/How_To_Build_SMARTFORMS.html

    Subtotals - Check the link...

    Re: Subtotal with Table Node in smartforms

    bReward points for useful Answers/b

    Regards

    Anji

  • RELEVANCY SCORE 2.68

    DB:2.68:Excise Invoice mz



    Hi gurus,

    when iam trying to create a excise invoice based on commercial invoice,the error reflecting is "customization for company code....missing in table company customization".

    message no:81303.

    DB:2.68:Excise Invoice mz


    Hello,

    Go to IMG Logistics-General Tax on Goods Movements India Basic Settings Maintain Company Code Settings.

    Please relevant company code is assigned or not.

    Also look below given in IMG Logistics-General Tax on Goods Movements India account determination specify excise accounts per excise transaction.

    GRPO Credit CENVAT clearing account

    GRPO Debit CENVAT on hold account

    GRPO Debit PLA AT1 Account

    GRPO Debit RG 23 AED account

    GRPO Debit RG 23 AT1 Account

    GRPO Debit RG 23 BED account

    GRPO Debit RG 23 ECS Account

    GRPO Debit RG 23 SED account

    Check these entries available or not

    Regards

    Mahesh Naik.

  • RELEVANCY SCORE 2.68

    DB:2.68:Reg. Bapi Fm For Creating Invoice am



    Hi Friends

    If any body tell me how to create an invoice with reference number and maintain our external invoice number.

    Advance Thanks

    Krishna

    DB:2.68:Reg. Bapi Fm For Creating Invoice am


    Hi Krishna,

    BAPI_INCOMINGINVOICE_CREATE - Invoice Verification: Create Invoice

    Check this link for sample code:

    http://www.sapnet.ru/viewtopic.php?p=642sid=8d1e7a183449ce3c9f60a0021887a1ff

    Regards,

    Chandra Sekhar

  • RELEVANCY SCORE 2.68

    DB:2.68:Issues With Invoice Layouts In Cr After Upgrade Sap Bo To Pl20. fa



    Dear users,

    There was an update of SAP from 8.8 PL14 to PL20.

    With PL14 everything worked fine.

    Now, after upgrade to PL20, when user tries to print an invoice there is an error message from Crystal Report Windows Forms Viewer "login to database was unsuccessfull".

    When user tires to preview this invoice there is prompt for username for "sa" for this database. This login window shows all the time, even when user types username "sa" and password - credentials are good for sure.

    When the same SAP user connects directly to server (with RDP) everything works fine: user can print invoices, can preview layouts.

    This happens for all users but only within one workstation...

    First I've unistalled and installed again SAP BO client - still the problem occurs.

    Next I've formatted and has installed OS from scratch and there is the same!

    Regards

    GN

    DB:2.68:Issues With Invoice Layouts In Cr After Upgrade Sap Bo To Pl20. fa


    HI,

    is this related to the integration of SAP BusinessOne and Crystal Reports ? If so I would suggest you move this to the SAP BusinessOne Forum.

    regards

    Ingo Hilgefort

  • RELEVANCY SCORE 2.67

    DB:2.67:Is The 861w-Gn Series Supports Ip Multicast Feature ? s3



    Is the 861W-GN series supports IP Multicast feature ?

    In which IOS ?

  • RELEVANCY SCORE 2.67

    DB:2.67:Cancelled Invoice Still Appearing In Vf24(Edit Work List For Invoice Lists) kp



    Hello All,

    I have an issue where in the user cancelled the invoice first before cancelling the invoice list, and then cancelled the invoice list.

    Now, though the invoice is cancelled, it still appears in the Work List for Invoice Lists i.e. transaction VF24 and also allows to create invoice list with reference to the cancelled invoice.

    Can anyone please help me on how can we resolve the issue, such that the cancelled invoice does not appear in VF24.

    Thanks in Advance,

    Surya

    DB:2.67:Cancelled Invoice Still Appearing In Vf24(Edit Work List For Invoice Lists) kp


    Hello All,

    I have an issue where in the user cancelled the invoice first before cancelling the invoice list, and then cancelled the invoice list.

    Now, though the invoice is cancelled, it still appears in the Work List for Invoice Lists i.e. transaction VF24 and also allows to create invoice list with reference to the cancelled invoice.

    Can anyone please help me on how can we resolve the issue, such that the cancelled invoice does not appear in VF24.

    Thanks in Advance,

    Surya

  • RELEVANCY SCORE 2.67

    DB:2.67:Convert Park Invoice Document To Invoice Document With Bapi xz



    Hi all,

    I want to convert Park Invoice Document to the Invoice Document with BAPI. I use BAPI_INCOMINGINVOICE_PARK to create Park Invoice Document. After that if I post this park document from MIRO, Invoice document is created. But I could not create Invoice Document with BAPI.

    How can I do that?

    Best regards,

    Munur

    DB:2.67:Convert Park Invoice Document To Invoice Document With Bapi xz


    Hi Ebcioglu;

    I don't know exactly your process but I think you may need to use one of the tables (ACCOUNTINGDATA, GLACCOUNTDATA, MATERIALDATA, TAXDATA, WITHTAXDATA, VENDORITEMSPLITDATA)

    I think your filled field/fields of structure/tables, different or blank/empty from originals tcodes scenario.

    Maybe help you below links.

    Best regards.

    Regarding BAPI_INCOMINGINVOICE_PARK

    Re: BAPI to Park the Invoice Document

    http://www.se80.co.uk/sapfms/b/bapi/bapi_incominginvoice_park.htm

  • RELEVANCY SCORE 2.67

    DB:2.67:Xquery: Can We Populate 10 Records With Sequence Based On One Record 9k


    i had a requirment in which i wil get a single GN Range Record and corresponding i need to create one GN Range Record and 10 GN item (Subtraction of RangeFrom and RangeTop) Records. For better understanding i am giving the payload.
    Input Payload

    ns0:InitDisconnectGNWorkflowRequest
    DisconnectionDetails
    GNGN_1/GN
    RangeFROM1/RangeFROM
    RangeTO10/RangeTO
    disconnecttypedisconnecttype_1/disconnecttype
    CUGnameCUGname_1/CUGname
    /DisconnectionDetails
    /ns0:InitDisconnectGNWorkflowRequest

    and the ouput should be

    ns0:createDisconnectionServiceRequest xmlns:ns0="http://vodafone.gr/esb/bpm/servicedelivery/CustomerInitiatedDisconnectionProcess/1.0"
    serviceRequest
    asset
    orderItem
    voiceItem
    gNRangeItem
    gNRangeDeatils
    fromGN1/fromGN
    toGN10/toGN
    /gNRangeDeatils
    GNRangeServiceItemIdVF_RANGE_HOL_INTEGRATION_ID_1/GNRangeServiceItemId
    /gNRangeItem
    gNItem
    GN1GN
    /gnItem
    gNItem
    GN2GN
    /gnItem !--and so on 10 items .... in Source payload we had only one record --
    /voiceItem
    /orderItem
    /asset
    /serviceRequest
    /ns0:createDisconnectionServiceRequest

    Is ot possible to achieve the desired payload by means of Xquery? If not can we achive this by means of the XSLT.?????
    Seperate GN Item records are inserted with sequence starting from RangeFrom and ends with RangeTo.
    here in these case 1 - 10

    Thanks in Advance
    Raja

    Edited by: user12893766 on Aug 18, 2010 12:04 AM

    DB:2.67:Xquery: Can We Populate 10 Records With Sequence Based On One Record 9k

    yes this query worked for me.....
    thanks a lot. sharing the quote. And filtering teh primary Gn number form it.

    for $icount in data($initDisconnectGNWorkflowRequest1/DisconnectionDetails[1]/RangeFROM) to data($initDisconnectGNWorkflowRequest1/DisconnectionDetails[1]/RangeTO)
    return
    if(data($initDisconnectGNWorkflowRequest1/DisconnectionDetails[1]/Primaryinrange) != data($icount)) then
    (gNItem
    GN{data($icount)}/GN

    /gNItem)
    else
    ()
    }

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Create A/R Invoice From Draft 8a



    Hi,

    How to create A/R Invoice from documnet draft using DIAPI.

    Thanks,

    P.Suresh Kumar

    DB:2.67:How To Create A/R Invoice From Draft 8a


    Hi Suresh Kumar,

    You may check this as a reference: Re: Problems while saving the tax values in a Draft Document to AP Invoice

    Thanks,

    Gordon

  • RELEVANCY SCORE 2.67

    DB:2.67:Invoice List ac



    Hi,

    As per std SAP invoice list processing, all invoices and debit memos go in one invoice list(provided all prerequisites are met) and all credit memos go in another invoice list if they are prcessed together.

    Is there is any customizing to create invoice list with both credit memo and invoice in the same invoice list.

    Thanks in Advance

    Challa

    DB:2.67:Invoice List ac


    Hello,

    please check the split analysis to see what are the different fields unallowing to join them in one invoice list.

    Probably there is Invoice list type.

    If there is only the Invoice list type, then you can specify the Billing type in first screen of VF21 to remove this split reason.

    If there are other fields causing split, then it is necessary to check them.

    Best regards,

    Ivano.

  • RELEVANCY SCORE 2.67

    DB:2.67:Po No In Invoice From Order 73



    hi guru's

    i do order related billing ........when i create invoice it not copy the P O no. mention in order. to invoice.......

    pls suggest

    DB:2.67:Po No In Invoice From Order 73


    Hi there,

    If your requirement is to print the invoice num on the invoice document then you need to maintain the setting A in the Reference num field in VTFA.

    If your requirement is to print the PO num on the onvoice printout, then you need to have a code written in form layout of the invoice O/p prog sothat it picks up the value from the VBKD-BSTKD. You also need to mention the position where the data should appear on the print.

    Regards,

    Sivanand

  • RELEVANCY SCORE 2.67

    DB:2.67:Invoice Correction Request dc



    Hi Gurus,

    Can you give me the steps on how to create an invoice correction request?

    Thanks,

    Paul

    DB:2.67:Invoice Correction Request dc


    http://help.sap.com/saphelp_46c/helpdata/en/dd/55ff05545a11d1a7020000e829fd11/frameset.htm

    http://help.sap.com/saphelp_46c/helpdata/en/dd/55fede545a11d1a7020000e829fd11/frameset.htm

    http://help.sap.com/saphelp_46c/helpdata/en/34/60b1c4ae724effe10000009b38f91f/frameset.htm

  • RELEVANCY SCORE 2.67

    DB:2.67:Suppimentry Invoice m8



    hi

    wat is supplimentry invoice and how to do customising for the same.

    My client want to make mistake in stock transfer invoice and create and post ecise invoice,

    now he don't want to cancell or reverse excise invoice,he asked me to create suppliemntry invoice,

    how to do it and can we create excise invoice on the basis of supplimenty invoice

    above scenrion is for cross company stock transfer

    hemant

    DB:2.67:Suppimentry Invoice m8


    Hi

    Thanks for your reply

    I did same thing,i created order type but i created billing type w.r.t F2 and put item category TAD,so that user can't do delivery

    Reagrds

    Hemant

  • RELEVANCY SCORE 2.67

    DB:2.67:Unable To Create Invoice In Isupplier Portal ca


    Hi All,

    I am Unable to create invoice in iSupplier Portal.

    Steps:

    1) Search the PO
    2) Select the invoice,
    3) Add items to Invoice list.

    It gives error:
    You have not added any items to your invoice. Please select at least one item before proceeding.

    Regards,
    SYR

    DB:2.67:Unable To Create Invoice In Isupplier Portal ca

    Hi All,

    I am Unable to create invoice in iSupplier Portal.

    Steps:

    1) Search the PO
    2) Select the invoice,
    3) Add items to Invoice list.

    It gives error:
    You have not added any items to your invoice. Please select at least one item before proceeding.

    Regards,
    SYR

  • RELEVANCY SCORE 2.67

    DB:2.67:Excise Invoice -Credit Debit Memo z3



    Whether we have to create excise invoice in case of credit and debit memo

  • RELEVANCY SCORE 2.67

    DB:2.67:Report 39


    how create chargeback details report tied up with invoice,sales order

    DB:2.67:Report 39

    Write the query in SQL

    Then use it in Reports 6i or XML Publisher to develop the layout

    enjoy, iguru

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Use Drafts To Create Invoice dp



    How to use Drafts to create Invoice

  • RELEVANCY SCORE 2.67

    DB:2.67:Create Commercial Invoice From Proforma Invoice kc



    Dear All,

    I have a requirement where in we have to create commercial invoice with accounting entry with the reference of Proforma invoice.

    We have done the copy control for Billing to Billing that is from proforma invoice to Commerical invoice. but while creating Commercial invoice with ref of proforma invoice system is showing Billing document is not relevant for billing.

    Please provide some solution so that we can create commercial invoice with accounting entry.

    Thanks Regards,

    Ratish Patil

    DB:2.67:Create Commercial Invoice From Proforma Invoice kc


    No i can not create with reference of Sales Order because Item status is full invoiced. While Creating Z Billing type for Proforma invoice our consultant has forgot to change the copy control setting of Sales order to Billing type.

    So now in the system Sales order status is full completed and only proforma invoice is created against the same. so accounting entries have not been processed, but it gives wrong picture so now i want to create commerical invoice for proforma invoice or Sales order.

    Thanks Regards,

    Ratish Patil

  • RELEVANCY SCORE 2.67

    DB:2.67:Cummulative Sum In Obiee 11g df


    Hi,
    i have generated a report,need to create cummulative sum in my reports.can anyone give me the solution how to do.cummulative sum like
    col1 col2 col 3(cummulative_sum)
    A 5 5
    B 10 15(5+10)
    c 15 30(15+15)
    appreciate your response.

    Brgds,
    GN

    Edited by: GN on 31 Jan, 2012 3:48 AM

    DB:2.67:Cummulative Sum In Obiee 11g df

    Hi muram,
    Currently i am working with BI Publisher 11g,i dont find right document ,do have any step by step document for the beginers to understand.Kindly share plz.

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Create Invoice By Passing Delivery Number..? mf



    Plz suggest any method or code to create automatic invoice by passing delivery number...

    DB:2.67:How To Create Invoice By Passing Delivery Number..? mf


    Through BDC we have done it .

    we are passing delivery number as well text field also.

    Thanks