• RELEVANCY SCORE 4.58

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




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

    Invoice #

    Billing

    Total

    602

    50.00

    50.00

    159

    75.00

    75.00

    847

    100.00

    847

    100.00

    847

    100.00

    300.00

    510

    80.00

    80.00

    987

    100.00

    100.00

  • RELEVANCY SCORE 3.29

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




    Hi Gurus,

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

    Can you please help.

    Thanks in advance for your time.
    Sunil

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

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

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

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

  • RELEVANCY SCORE 3.23

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





    Hi,

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

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

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

    Thanks

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


    Hi,

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

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

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

    Thanks

  • RELEVANCY SCORE 3.16

    DB:3.16:Invoice Amount Is Coming Repetitative In Report zc



    Hi,

    In my report, 3 fields are Invoice amount, base amount and tax amount...against document number. In it, base amount and tax amount are different with line items (document number have line items). But Invoice amount is same in all line items....when we do sub-total it sum multiple times...like

    Invoice amount.....base amount......tax amount

    10000.00.................5000.00...........200.00

    10000.00.................5500.00...........100.00

    10000.00.................5800.00...........530.00

    10000.00.................6100.00...........620.00

    10000.00.................8600.00...........400.00

    please look at 1st column, Invoice amount is same and other are diff.

    I want that Invoice amount should come only in 1st line item....like

    Invoice amount.....base amount......tax amount

    10000.00.................5000.00...........200.00

    ................................5500.00...........100.00

    ................................5800.00...........530.00

    ................................6100.00...........620.00

    ................................8600.00...........400.00

    Because when we do sub total, it sum multiple times (as line items have with document number)..

    Please tell me...

    Thanks....

    DB:3.16:Invoice Amount Is Coming Repetitative In Report zc


    Those replies were NOT automatically deleted.

    I reported those replies to the SCN Moderators because they were WRONG and hence got deleted.

    As to why I did not answer your query: such questions have been asked and answered many times here in this forum. So its easily searchable.

    pk

  • RELEVANCY SCORE 2.99

    DB:2.99:Discoverer 11 Cross Tab Aggregation fs


    Dear All,

    I have an issue with Discoverer Desktop aggregation behaviour. I've created a EBS report, that returns invoice data where the invoices have and have not been matched to a PO at Invoice Distribution level. This report is split into two sheets, one sheet for matched Invoice Distribution detail and another for unmatched Distribution detail. The results of which reconcile back to the applications.

    However, i have also added a summary cross tab page within the report to allow a high level overview which will incorporate percentage of total detail. However, the totals between unmatched and matched Distribution lines do not reconcille back to the two detail sheets. This cross tab report is based on the same calculations. ie return 1 for matched and 2 for unmatched.

    Upon investigating the invoice detail within the cross tab results, it would seem that it is missing some invoice distributions, this is the case where an invoice is made up of multiple lines, but only a few of the lines have been matched to a PO at distribution level. should i be using a different kind of calculation to acheive this kind of report. I'm aware there are certain limitations regarding aggregation that still exist within Disco.

    Example of exsiting calc, CASE WHEN INV.DISTRIBUTION_PO_DISTRIBUTION_ID IS NULL THEN 1 WHEM INV.DISTRIBUTION_PO_DISTRIBUTION_ID IS NOT NULL 2 END (With/Without match)

    Cross Tab -

    Y Axis Organisation_Name
    x Axis Matched || Not Matched || sum(Distribution line amount)

    Discoverer Desktop version 11.1.1.30

    Please let me know if you require any further detail.

    Kind regards
    Simon

    DB:2.99:Discoverer 11 Cross Tab Aggregation fs

    hi
    I may be interrupting you ..sorry for this..

    I am unable to connect to my discoverer desktop 11..Have you faced this issue..and if so please share your resolution

    thanks
    kumar

  • RELEVANCY SCORE 2.91

    DB:2.91:Om Shippments Issues zj


    Dear All,
    My client has 2 requirements and I need your help in this regard,

    1) We have a single Order say 5000 Dozen now we want to ship it partially, like firstly 2000 Dozen then 1000 Dozen and then 2000 Dozen, how can I achieve this target?and will this create an invoice for each Partial shipment?

    2) Can a single invoice have multiple orders say invoice total is $10,000 and it is comprised of 3 orders of 4000, 3000 and 3000.How is possible how can we achieve this target?

    Regards

    Naveed

    DB:2.91:Om Shippments Issues zj

    +1) We have a single Order say 5000 Dozen now we want to ship it partially, like firstly 2000 Dozen then 1000 Dozen and then 2000 Dozen, how can I achieve this target?and will this create an invoice for each Partial shipment?+

    For this you can split the Sales Order Line to different quantities, and it will be displayed partially on the Shipping Transactions Form, so you can create separate invoice for each partial shipment, by assigning different Delivery Order Numbers t0 each partial shipment.

    +2) Can a single invoice have multiple orders say invoice total is $10,000 and it is comprised of 3 orders of 4000, 3000 and 3000.How is possible how can we achieve this target?+

    After you have allocated multiple orders in the inventory, you can simply create a DELIVERY ORDER NUMBER on one of them. (ActionsAutoCreate Delivery), and on the other Orders, you can Assign the previously created Delivery Order Number to these deliveries (ActionsAssign to Delivery). By doing so, Delivery Order will create a single invoice, when you run the autoinvoice program.

    Hope this helps.

    Regards,
    Uzair Khan.

  • RELEVANCY SCORE 2.89

    DB:2.89:Sales Ar Item Type Invoice Print Layout Design "Sub Total" Per Page 97



    Dear Forum Team

    We need some advice on how to modify, fomulate(?) [Sub Total] for each page's 'amount' on the Sales AR Item Type Invoice.

    Currently the 'sub total amount' on each page is showing Grand Total instead of sub total.

    Thanks

    DB:2.89:Sales Ar Item Type Invoice Print Layout Design "Sub Total" Per Page 97


    Hi,

    In you PLD, In repetitive area, you might have linked the fields like Item name, Item Description, and so on. In these fields one of the field will be Total for line items. Am i right?

    If it is so, then in repetitive area footer, Create one Formula field and give formula PageSum("Field_025") (in your case)

    Ie., Field_201 = PageSum("Field_025")

    Field_025 - contains the Line Total of Row items.

    I hope this could help you.

    Raja.S

  • RELEVANCY SCORE 2.89

    DB:2.89:Multiple Receiavable Accounts On Single Project Invoice kk


    Hi,

    Well we have following requirement

    THe invoice created in Project Billing contain different lines and each line is a separate event (e.g milestone event,change order event,Material on site event etc. Alll these event are created automatically by custom extention). In Autoaaccounting we can assign one receivable account for total value of invoice so it hit one receivable account in GL but in our case we have different receivable accounts in GL for each invoice line or event (like milestone event,change order event,Material on site event etc). So how to achive this functionality?

    Cheers,

    DB:2.89:Multiple Receiavable Accounts On Single Project Invoice kk

    Hi

    Since there is only one receivable account per invoice, you must separate the events of different types into separate invoices.
    That may mean you will generate multiple invoices for the same project customer on the same day.
    Your custom extension should be modified to support that.

    The other approach is to convince accounting department to forget about that requirement :)
    All invoices will be sent to the same receivable account.

    You could easily develop a custom report that will be run at period end. The report will detail amounts of invoice lines and show the event type per line. The report could summarize amounts by event types accross invoices. Accountant could then enter a manual journal entry in GL to reclassify the total receivable account balance into various different receivable accounts.

    Dina

  • RELEVANCY SCORE 2.89

    DB:2.89:Query That Show Total Discount On A/R Invoice cf



    Dear all,

    I would like to have query that show summary of each invoice number that show 'Total of discount' ( 'Total of discount' = total of discount in line item + discount of total invoice ). Data that I would like to show on this query is as follow :

    Invoice No, Invoice Date, Customer Code, Total before discount, 'Total of discount', Total Amount, Vat amount

    Please kindly suggest the way to get this data.

    Thanks you in advanced.

    Angnam

    DB:2.89:Query That Show Total Discount On A/R Invoice cf


    Dear Angnam,

    Try:

    SELECT T0.DocNum 'Invoice No.', T0.DocDate, T0.CardCode 'Customer Code', T0.DocTotal 'Total Before Discount',

    SUM(T1.PriceBefDi * T1.Quantity *T1.DiscPrcnt)/100 + T0.DiscSum 'Total Discount',T0.VatSum

    FROM OINV T0

    INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry

    Group By T0.DocNum, T0.DocDate, T0.CardCode, T0.DocTotal,T0.DiscSum ,T0.VatSum

    Thanks,

    Gordon

  • RELEVANCY SCORE 2.87

    DB:2.87:Vsto 2005se Overwrites Data While Adding Rows (Rows.Add) To Table. 11


    Here's the Word 2007 document: (It's an invoice with a variable number of products in table 2. Table 3 is the invoice total and discount area.)
     
    Table 1
    some text with bookmarks
    Table 2
    Table 3
    ------------------------------- End of page -----------
     
    When programmatically adding rows to table 2 using rows.add in VB, the new rows will eventually overwrite table 3 and continue on to page 2 if enough rows are added. I would have thought that table 3 would be 'pushed' down to page 2 to eventually end up below its new position below table 2. If I make table 3 a footnote, the same situation occurs. Is this a default behavior, or is there a way to accomodate additional rows?
     
    RAF
     

    DB:2.87:Vsto 2005se Overwrites Data While Adding Rows (Rows.Add) To Table. 11

    Thank you for pointing me to the table options. Removing the 'allow overlap' on the third table did the trick.
     
    Bob F.
     

  • RELEVANCY SCORE 2.83

    DB:2.83:Subtotal Problem jj



    Please excuse my ignorance, but I am having a lot of trouble getting a subtotal to appear on a report. This report is basically an invoice listing. It sorts first by vendor name and then by invoice number. Each invoice may have multiple lines that go to different GL account codes. I'd like the report to also subtotal by invoice number. I was able to accomplish something similar by adding a new group, but it started making my report sort by invoice number instead of by vendor name. Any help would be appreciated. Thanks!

    DB:2.83:Subtotal Problem jj


    Why can't you just add the invoice subtotal to the Invoice group footer?

    You did not answer Debis question - What was the third group? Seems very strange that Group 3 over rode the Grp1 Vendor.

    Ian

  • RELEVANCY SCORE 2.83

    DB:2.83:Oracle Ap Question d9


    Dear All,

    Is there any possibility to record accruals in Oracle AP. If there is a draft invoice received and against that vendor a prepayment exist in AP and i have to record the total cost of the services after adjusting prepayment.

    The commercial invoice will be received some time in future.

    regards,

    zubair uddin

    DB:2.83:Oracle Ap Question d9

    i think you should create invoice for this supplier and apply this invoice to his prepayment and do create accounting as Draft and after you receive The commercial invoice do create account as final

    this good work around for this

  • RELEVANCY SCORE 2.83

    DB:2.83:Total Variances Through Ir c9



    Hi experts,

    Could some one explain me when the 'Total variances through IR' are generated?

    We have a case of a PO in Foreign currency for quantity of 1.

    This PO was invoiced before being received.

    When received, the GR value does not match the invoice value.

    The total GR value is adjusted with a 'Total variances through IR'. The total goods receipts does match the invoice value.

    I tried to look for possible different currency rates,but the documents have the same currency - PO and invoice and GR -

    Thank you.

    Monica.

    DB:2.83:Total Variances Through Ir c9


    Hi Monica,

    When the invoice was posted prior to the receiver the entries will be

    Invoice Receipt

    Debit GR/IR Clearing

    Credit Supplier Vendor

    then Goods Receipt

    Debit Inventory account

    credit GR/IR Clearing

    debit Variance

    then clear the variance

    debit Vendor

    credit variance

    assign points if useful

    Regards

    Genie

  • RELEVANCY SCORE 2.82

    DB:2.82:Bex Query Issue dx



    Hello All,

    I am having one key figure balance amount and invoice age ,Account code character.I have to develop the report which will have columns Account code ,total balance,balance for invoice age 0-100 days, balance for invoice age 100-200 days .I have tried to restrict the balance with invoice age for the cloumns but it is not giving the desired results. can some body help me on this.

    Thanks

    Jacko

    DB:2.82:Bex Query Issue dx


    Hi

    U have to create 2 selection for each ( 0 - 100 days ) and (100 - 200 days ) . and restrict that keyfigures with the corresponding characteristic . Please follow the below step.

    Restrict --- select value ranges --- select lower and upper characteristic ( not sure about description ) as invoice age( both are drop down box ) and select offset option beside that drop down , in the first offset give the value as -100 and in the second offset give the value as -200.

    Please follow the above guidelines...

    Revert back in case of any queries.

    Thanx Regards,

    RaviChandra

  • RELEVANCY SCORE 2.82

    DB:2.82:F-28 Post Incoming Payments 78



    .

    Hi , iam basically abaper, workig as tech functional in fico.

    My requirement is like this.

    1) When making partial adjustment against multiple invoices , say for examle.

    Total amount entered is 5000 in initial screen of f-28.

    A) invoice : 5260000001 - invoice amount : 2000 _ adusted amount : 2000

    B) invoice : 5260000002 - invoice amount : 7000- adusted amount : 3000.

    When saved dz doc is created.

    In the above case first invoice is cleared and second invoice is open when i checked in fbl5n. For cleared item invoice reference field and payment reference field are not updating. i.e invoice number 5260000001 is not appearing.

    But for open item invoice ref and payment ref fields are appearing.

    In fbl5n when i checked both billing doc and invoice reference fields are appearing only for open items, but for closed items in invoice ref field the same dz doc number is appearing instead of invoice number.

    Please help me.

    Its very urgent.

    DB:2.82:F-28 Post Incoming Payments 78


    Have you checked table BSAD? That links documents for cleared items of customers.

  • RELEVANCY SCORE 2.82

    DB:2.82:Invoice Field "Total Before Discount" 7m



    I am importing data via DTW to an invoice. I am then trying to apply a 10% discount. However, the 10% doesn't apply because the field "total before discount" is empty.

    I have tried to look at importing in to this field but can't find which field to update and I also thought that it would update automatically from the line items?

    Although perhaps it's not updating because by adding the items codes and qty during the import it doesn't then set the Total (LC) field. Do I have to set this?

    Edited by: Ricky Thomas on Apr 1, 2011 12:52 PM

    DB:2.82:Invoice Field "Total Before Discount" 7m


    HI,

    Ya,you just add the discount in its respective field along with the previous details(like neceesary standard information for that invoice) and update it through DTW....

    Edited by: kambadasan on Apr 1, 2011 1:29 PM

    Edited by: kambadasan on Apr 1, 2011 1:31 PM

  • RELEVANCY SCORE 2.81

    DB:2.81:How To Stop A Credit Memo For More Than The Reference Invoice? s1


    Hi All,My company would like to stop users from creating credit notes for more than the original invoice value, when the credit memo is referenced to an invoice. E.g. invoice is for $100, then multiple credit notes can be created, e.g. for $50, $30, and $30. Total credited = $110, but the original invoice was only for $100. there doesnt seem to be a standard message which can be issued under these circumstances in order to stop the users from doing this. Does anyone have any advice on how to stop this?Many thanksPhil

    DB:2.81:How To Stop A Credit Memo For More Than The Reference Invoice? s1

    Hi, This can be taken care through user exit MV45AFZZ in credit memo request creation .Regards,Siraj

  • RELEVANCY SCORE 2.78

    DB:2.78:Invoice Value Should Not Exceed Order Value j8



    Dear All,

    I have a requirement in which whenever a user creates an A/R invoice ( Partial or full ) the total invoice value ( Partial or Full ) should not exceed the total Sales Order Value.

    Scenerio :

    Sales Order No 10001 has 3 line items i.e Item 1, Item 2, Item 3 with line totals of each as 100, 200, 300. Now Invoice is done for Item 1 and Item 2 on 1/1/09 line total 100, 200 which totals to 300. Now again after some days final invoice is done for Item 3 whose line total is 300.

    Now I want a check that the system should check the total sales order value which is 600 with the Invoice Value and it should not allow to add the invoice if 600 is exceeded ( May be Invoice done partially also )

    Also a check is required that the line total value of Sales Order should not get exceeded when making the AR Invoice.

    I think this could be possible using SP. Pls advise how to make this SP.

    Best Regards,

    Depika

    DB:2.78:Invoice Value Should Not Exceed Order Value j8


    Dear Depika,

    First you need to confirm if you create all invoices based on sales order directly or not.

    Thanks,

    Gordon

  • RELEVANCY SCORE 2.78

    DB:2.78:Error On Adding A/P Invoice d1



    Hi Experts,

    I have encountered some problem on adding A/P Invoice (copy from Goods Receipt-PO). The error is u201CInventory Account is not defined, u2018ITEM001u2019 [Message 173-77]. This item 'ITEM001' is Set by GL Account by ITEMGROUP (at ITEM Master). I have already checked the Item Group that attached on this item and we don't see anything wrong on our configuration. And this specific item only have problem on adding AP Invoice.

    The ItemGroup that attached on item ITEM001 have Inventory Account and Allocation Account entry already. Please help me guys how to solve this issue....

    Thank You So Much.

    Jon

    DB:2.78:Error On Adding A/P Invoice d1


    Thank you for the help.....

    Regards,

    Jon

  • RELEVANCY SCORE 2.78

    DB:2.78:Tax Being Calculated Based On Each Item On The Invoice Rather Than Total? 8d



    Dear all

    I need your expertise on this.

    I'm having a problem with the invoice in SD which appears to calculate tax based on each item and added them up to print total tax, which is different from if you calculate tax based on the total amount.

    E.g. ) You have 10 lines on the invoice (in JPY):

    No. 1 127260

    No. 2 127260

    No. 3 157660

    No. 4 81580

    No. 5 157660

    No. 6 81580

    No. 7 88640

    No. 8 40060

    No. 9 40060

    No. 10 63460

    No. 11 63460

    and total amount is : 1028680. If tax ratio is 17.5% then total VAT amount would be 180019. But because of the way SAP (out SAP is 4.6c by the way) calculates VAT is at the moment based on each item, so VAT for each item would be:

    No.1 22271

    No.2 22271

    No.3 27591

    No.4 14277

    No.5 27591

    No.6 14277

    No.7 15512

    No.8 7011

    No.9 7011

    No.10 11106

    No.11 11106

    and the total of above is 180024. Please note SAP rounds JPY amount at the 1st decimal point.

    The invoice shows 180024 rather than 180019. I think most of the case VAT should be calculated based on the total amount not per item and adding them up.

    It would be great if there's any way to just 'configre' sap to achieve this. Thank you very much in advance.

    DB:2.78:Tax Being Calculated Based On Each Item On The Invoice Rather Than Total? 8d


    Hi Damodhar,

    Thank you for your quick reply!

    When you say " as a header condition", "Item condition" should be unticked - is that correct? I was looking at ATX1 and although it has "Group cond." as an Group condition option, I found "Changes which can be made" option has both "Header condit." and "Item condition" ticked. (Sorry not sure if ATX1 is the one I should look at!)

  • RELEVANCY SCORE 2.78

    DB:2.78:How To Deal With Data Inconsistent Problem? (Urgent) 8c


    I have following problem:
    Suppose I have a table to stroe invoice information. It has invoice amount.
    A Maximum value to control the upper limit of total invoice amount.
    Each time I submit an invoice, it get current sum of invoice amount and plus this invoice amount to check whether its over the upper limit. If its over the limit, I will do some other process.

    The problem is such program runs in weblogic cluster enviorment, maybe in one time there are more than one processor run such function. How to deal with such issue? how could I get the accurate sum of invoice amount?

    Thanks!!

    DB:2.78:How To Deal With Data Inconsistent Problem? (Urgent) 8c

    Yes, it can.

    Although the other threads /processes will block till your transaction commits.

    Serializable only means that the resource is blocked for read AND write until the transaction commits (and effectively releases the locks).

    In terms of using JTA/JDBC - it depends on what accesses your database. If it is only a cluster of J2EE servers, JTA would suffice. But if someone then connect directly to the database (say using TOAD or iSQLW) and fires a SQL statement, it may not get locked (depending on how JTA has implemented the serializable lock). If you use JDBC for the same, then your DATABASE itself locked.

  • RELEVANCY SCORE 2.78

    DB:2.78:How To Get Total Amount Of Invoice 33



    Hi Friends,

    I am creating an invoice in FB60. I want to get the total amount of this invoice. From which table can i get this value.

    I have the company code, document number, fiscal year as the key, what would be the logic to get the total invoice amount.

    Please advice.

    DB:2.78:How To Get Total Amount Of Invoice 33


    Do i need to loop on the line items to get the total amount or

    a select single will do?

  • RELEVANCY SCORE 2.77

    DB:2.77:Error When Adding Ap Invoice 97



    Dear All,

    I find an error appears when adding AP invoice, the error message is:

    there is a different between document total and its components[A/P invoice - Rows - Warehouse code][line : 0][message 439 - 138]. I could not add the AP invoice because of this error. Please give advice. Thanks

    Rgds,

    DB:2.77:Error When Adding Ap Invoice 97


    Hi Jimmy,

    Tks for your answer. It works. I did not know why it could be happened. I am using SAP B1 2005A SP 01 PL 18. I think I should upgrade to the latest PL asap.

    Rgds,

  • RELEVANCY SCORE 2.77

    DB:2.77:Why Is My Validation Working In This Way? 7d


    I have a form which consists of Invoice Header data.
    -For the Invoice header it consists of Multiple Invoice Line Details.
    -For each of these line Detail, i have multiple Invoice Distribution Lines

    Now For each Invoice Line we have Line Amount.
    Also For each Distribution line we have to enter Distribution Amount.

    Now the Line Amount should be equal to the Sum of the Distribution Amount of each Distribution Line under the Invoice Lines.

    Here is the code that i wrote for this validation in the validateEntity() method of the EO for the Invoice Lines.

    RowIterator rowset=getDistEO();// get the rowset for the Distribution Lines EO
    System.out.println("the number of rows are ="+rowset.getRangeSize());
    Row row=null;
    int distLineTotal=0;//set the variable for Total Distribution amt as 0
    int lineAmt=getAmount().intValue();// get the Line Amount for the Invoice Line

    System.out.println("in Line EO Line amt is = "+ lineAmt);

    //do the validation only if the any Distribution Line is present
    if( rowset.getRangeSize()gt;0){
    while((row=rowset.next())!=null){

    //Loop and set the Distribution Amount total
    distLineTotal=distLineTotal+((Number)row.getAttribute("Amount")).intValue();

    }

    System.out.println("distLineTotal is = "+ distLineTotal);
    if(distLineTotalgt;lineAmt distLineTotal==0){

    // Throw the exception if the Line Amount is less than Distribution Amount Total
    throw new OAAttrValException(OAException.TYP_ENTITY_OBJECT,getEntityDef().getFullName(),getPrimaryKey(),"Amount",getAmount(),"XXLBCARC","XXLBC_LINE_GREATER_THAN_DIST" );
    }else if(distLineTotallt;getAmount().intValue()distLineTotal==0){

    // Throw the exception if the Line Amount is greater than Distribution Amount Total
    throw new OAAttrValException(OAException.TYP_ENTITY_OBJECT,getEntityDef().getFullName(),getPrimaryKey(),"Amount",getAmount(),"XXLBCARC","XXLBC_LINE_LESSER_THAN_DIST" );
    }
    }

    Also for the Invoice Lines i have a Image by pressing which we would go to the Distribution Lines page.

    For this button i have set the disable the server side and client side validation to TRUE

    Now the validation works fine and suppose for the Invoice Line which is an Advanced table, if for rows 1 and 2 the Following exception is thrown.

    Error

    Row 1 Error - The Line Amount is Greater than the Distribution Line Amount Total.

    Row 2 Error - The Line Amount is Lesser than the Distribution Line Amount Total.

    Now this is fine.

    But Now suppose i click on the Image for Distribution Line, for the Invoice line 1 i.e. Row 1
    , it wont let me go to the Distribution Page.

    Instead the the error lines get added at the top of my screen like the following:

    Row 1 Error - The Line Amount is Greater than the Distribution Line Amount Total.

    Row 2 Error - The Line Amount is Lesser than the Distribution Line Amount Total.
    Row 2 Error - The Line Amount is Lesser than the Distribution Line Amount Total.
    Row 2 Error - The Line Amount is Lesser than the Distribution Line Amount Total.

    I have to first click on the Image for Distribution Line, for the Invoice line 2 i.e. Row 2, make the correction in the Distribution Page for that, then come back to the Invoice Line page and then I can make changes for the
    Invoice line 1 i.e. Row 1.

    Why cant i make changes to Invoice line 1 i.e. Row and the go to Invoice line 1 i.e. Row 2?

    Edited by: Pradeep on Jan 5, 2009 3:58 AM

  • RELEVANCY SCORE 2.77

    DB:2.77:Edi Invoice Posts To Single Receipt Item j8



    We have a scenario where for a single PO and line item, there are multiple receipts for the total quantity (multiple deliveries for one PO line item). The EDI invoice is also split in this manner with multiple segments to cover the multiple deliveries for a single PO/line item. During posting though the entire amount of the invoice is posted to the first goods receipt item even if it is more quantity than the GR quantity. For example, for PO item 10, there are receipts for 44 pcs and 4pcs (total 48). The invoice has two line items, one for 44pcs and one for 4pcs. However when the invoice is posted, the total of 48 pcs is posted to the 44pc line item resulting in a -4 difference while the second receipt item for 4pcs remains open in the GR/IR.

    Is there some setting in configuration I can maintain so that the invoice will try to post the open GR qty per line item and will not over-post on a single line item? In my scenario it would post 44pcs and then 4pcs to the respective GR items and clear the GR correctly instead of creating a -4/+4 scenario.

    If there no solution in configuration, has anyone else faced this issue and resolved through a user exit or other means?

    Thank you!

    DB:2.77:Edi Invoice Posts To Single Receipt Item j8


    We have a scenario where for a single PO and line item, there are multiple receipts for the total quantity (multiple deliveries for one PO line item). The EDI invoice is also split in this manner with multiple segments to cover the multiple deliveries for a single PO/line item. During posting though the entire amount of the invoice is posted to the first goods receipt item even if it is more quantity than the GR quantity. For example, for PO item 10, there are receipts for 44 pcs and 4pcs (total 48). The invoice has two line items, one for 44pcs and one for 4pcs. However when the invoice is posted, the total of 48 pcs is posted to the 44pc line item resulting in a -4 difference while the second receipt item for 4pcs remains open in the GR/IR.

    Is there some setting in configuration I can maintain so that the invoice will try to post the open GR qty per line item and will not over-post on a single line item? In my scenario it would post 44pcs and then 4pcs to the respective GR items and clear the GR correctly instead of creating a -4/+4 scenario.

    If there no solution in configuration, has anyone else faced this issue and resolved through a user exit or other means?

    Thank you!

  • RELEVANCY SCORE 2.77

    DB:2.77:Document Splitting Error While F-28 7m



    Hi

    we are in ECC6.0 with EHP4.

    we are receiving single cheque from customer agaisnt multiple invoice. these multiple invoice belong to multiple profit centre. some time customer pay additional amount agaisnt future shipment which we treat as payment on account. folloiwng is the example:-

    invoice no amount profit centre

    100 5000 PC100

    200 7000 PC200

    300 3000 PC300

    total amount due is 15000.00. But customer paid 20000.00 which include on account payment of 5000.00. now while recording this transaction through F-28, system picking profit centre from invoice document but unable to pick profit centre for on account payment. due to this, unable to post the document.

    error remain same even we are giving profit center on initial screen on F-28.

    in customization, we have done necessary settings and "Inherit" option selected in document splitting.

    any idea how to resolve above error. please revert

    regards

    DD

    DB:2.77:Document Splitting Error While F-28 7m


    Hi

    great...... i have similer thought on this issue. But still want to drive profit centre automatically.

    still i have not finilized the solution as number of profit centre is very high in our system and if we give freedom to user to choose profit centre then it will be big issue in term of profit centre reporting.

    if anybody has different thought on the issue, please revert.

    Regards

    DD

  • RELEVANCY SCORE 2.76

    DB:2.76:Total Invoice Open Item 10000 But User Wants Make Payment 1000 By App At Month End 88


    Dear Guru,

    I have one issue Exp: Total invoice price 10000 but my client want to make payment 1000 by APP at month end. how i can make payment 1000 by APP becoz the invoice open item 100000,please give me some solutions.

    Thanks,
    KND

    DB:2.76:Total Invoice Open Item 10000 But User Wants Make Payment 1000 By App At Month End 88


    Hi

    You can do this via Partial Payment in APP. First, use T-code F-59 to create a Payment Request and run F110 for the same.

    Thanks

    Naresh K.

  • RELEVANCY SCORE 2.76

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



    Hi All,

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

    Please help me out .

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


    Hi Manish,

    You can make use of these FMs RSPO_RETURN_ABAP_SPOOLJOB or RSPO_RETURN_ABAP_SPOOLJOB_RW .

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

    Hope it helps.

    Thanks,

    Daya

  • RELEVANCY SCORE 2.76

    DB:2.76:How To Use Autoinvoice To Import Summarized Invoices ! Very Urgent ! z1


    Hi !
    I have to use Autoinvoice to import legacy summarized invoices into Oracle Receivables and I need an explanation of how I have to do it.

    There are 2 legacy tables I have to use:

    Table 1: Contains summarized Invoices. A summarized invoice is an invoice without lignes and has only a total amount.
    Its fields are the following :
    - invoice number
    - customer Id
    - Amount (total amount)
    - due date

    Examples:
    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008

    In general a record in table 1 (a summarized invoice) is not associated with records from table 2 (Adjustments). But in some particular cases, it can be associated with adjustment records in table 2 but these adjustments are only information added to the summarized invoice and not a real adjustment. All what we need is to have adujstment information added to the summarized invoice so the adjustment amount is a additional information that must not be considered in any calculation.

    Here is the Adjustments table:
    Table 2: Adjustments
    It has the following fields:

    - Adjustment number
    - Adjustment date
    - Adjustment amount
    - Adjustment Type
    - Invoice number: number of the invoice to which the adjustment is associated (foreign key on Table 1)

    Example

    - Adjustment number: 1150
    - Adjustment date : 01-01-2008
    - Adjustment amount: 500$
    - Adjustment Type : Cancelation
    - Invoice number: 7899 (the second one above)

    The import result must be:

    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008
    - additional information for adjustment: Adjustment number=1150, Adjustment date=01-01-2008, Adjustment amount=500$, Adjustment Type= Cancelation.
    I think only RA_INTERFACE_LINE_ALL will be used since there is no distribution to. amount need to is to be used and I have to group lines by Customer Id + Invoice Numer + Adjustment number in order to get at a time one invoice of a customer and

    DB:2.76:How To Use Autoinvoice To Import Summarized Invoices ! Very Urgent ! z1

    Hi !
    I have to use Autoinvoice to import legacy summarized invoices into Oracle Receivables and I need an explanation of how I have to do it.

    There are 2 legacy tables I have to use:

    Table 1: Contains summarized Invoices. A summarized invoice is an invoice without lignes and has only a total amount.
    Its fields are the following :
    - invoice number
    - customer Id
    - Amount (total amount)
    - due date

    Examples:
    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008

    In general a record in table 1 (a summarized invoice) is not associated with records from table 2 (Adjustments). But in some particular cases, it can be associated with adjustment records in table 2 but these adjustments are only information added to the summarized invoice and not a real adjustment. All what we need is to have adujstment information added to the summarized invoice so the adjustment amount is a additional information that must not be considered in any calculation.

    Here is the Adjustments table:
    Table 2: Adjustments
    It has the following fields:

    - Adjustment number
    - Adjustment date
    - Adjustment amount
    - Adjustment Type
    - Invoice number: number of the invoice to which the adjustment is associated (foreign key on Table 1)

    Example

    - Adjustment number: 1150
    - Adjustment date : 01-01-2008
    - Adjustment amount: 500$
    - Adjustment Type : Cancelation
    - Invoice number: 7899 (the second one above)

    The import result must be:

    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008
    - additional information for adjustment: Adjustment number=1150, Adjustment date=01-01-2008, Adjustment amount=500$, Adjustment Type= Cancelation.
    I think only RA_INTERFACE_LINE_ALL will be used since there is no distribution to. amount need to is to be used and I have to group lines by Customer Id + Invoice Numer + Adjustment number in order to get at a time one invoice of a customer and

  • RELEVANCY SCORE 2.76

    DB:2.76:R Block Automatic Invoice Line Item Release For Payment 1m



    Its related to service PO, where we have the multiple invoice and GR line items for the PO.

    The invoice postings are happening earlier than the GR postings and its blocked for payment due to the absence of GR. please refer the below scenario.

    For example :

    Total PO Quantity 100 @ 2 GBP

    Total PO Value is 200 GBP

    Invoice

    First invoice Line item processed on 01.08.2012 for the quantity of 30 @ 2 = 60 GBP

    Invoice Status : Blocked for payment (R Block-MM) As there is no GR posted.

    Second invoice line item has been processed on 05.08.2012 for the quantity of 15 @ 2 = 30 GBP

    Invoice Status : Blocked for payment(R Block-MM) - As there is no GR posted.

    GR

    On 06.08.2012, GR has been posted for the quantity of 35 @ 2 = 70 GBP. After this GR posting, user is trying to Run the MRBR and expecting the first invoice(for the quantity of 30 @ 2 = 60 GBP) get release automatically as they have already posted the enough GR quantity on 06.08.2012 (35 @ 2 = 70). Its not happening as expected.

    I am not sure whether system is considering the total invoice and the total Goods receipt. In the above example the total invoice value is 90 GBP but GR has been done for only for the value of 70 GBP, invoice value more than the GR value.

    Considering from the business perspective, they want to release first invoice (35 @ 2 = 70 GBP) as vendor has provided the required services i.e. goods receipt has been already posted for the value of 30 @ 2 = 60 GBP on 01.08.2012.

    Could you please advise on the settings to release the first invoice automatically.

    DB:2.76:R Block Automatic Invoice Line Item Release For Payment 1m


    Hi All,

    Was this resolved - were you able to find any user exit to unblock automatically for invoices matching at item level ?

    Thanks

  • RELEVANCY SCORE 2.75

    DB:2.75:Excel 2007 Formula jd



    I have a multiple sheet workbook with an invoice form on each page that gets filled out. The data on each sheet is linked to a summary sheet. The form has a cell that lists the sub total $ amount of the order. Some orders are taxed, others are
    not. I have a field that needs the text " personal" or "business" entered. I have to have this text on the summary sheet. I want the tax field to populate based on the text in this field.
    If B6 is the text field (Personal or Business)
    C4 is Sub Total $ amount
    C5 is Tax$ amount
    C6 is Grand Total (C4+C5)
    What I need the formula to do:
    If (B6="Personal") then(( C5= (C4*.05)), OR if (B6="Business") then (C5=0)
    Is there a way to do this?

    DB:2.75:Excel 2007 Formula jd

    Just what I needed. I was ovethinking the problem.
    Thank You!

  • RELEVANCY SCORE 2.75

    DB:2.75:Multiple Invoices For A Invoice Document Number dm



    Hi BW Gurus I need your help and quick hint, I have a purchasing cube that recieve the data from 2lis_02_itm and fiap line item ofi_gl_4 which is document item purchasing and account payable, problem is report is showing the PO number and Invoice number and amount, but amount is total of multiple invoice but report only display the invoice number of least invoice amount instead of showing all the invoice numbers so I built the RRI but now problem is how ill the user know that Invoice number in display has multiple invoices and its not the all invoice numbers so he need to use rri, please tell if there is any counter field or any way we can identify the that the invoice number has multiple invoices

    please help

    Soniya

    DB:2.75:Multiple Invoices For A Invoice Document Number dm


    The Invoice will have the reference to a PO. Kindly check

  • RELEVANCY SCORE 2.75

    DB:2.75:This Workflow Job Was Canceled Because The Workflow That Started It Included An Infinite Loop. Correct It kj


    Hi,
    I have a plugin registered on Update of Total Amount of Invoice Entity, When I am adding a product through Invoice Product subgrid, I am getting the error as This workflow job was canceled because the workflow that started it
    included an infinite loop. Correct it.
    My plugin code is no where updating the Current Invoice Record.

    Thanks,
    Vijay

    DB:2.75:This Workflow Job Was Canceled Because The Workflow That Started It Included An Infinite Loop. Correct It kj

    Thanks Divyesh,

    I have added context.Depth1 also then to its throwing error. So I though of Instead triggering the plugin on updating the Total Amount feild on Invoice. I've cahnged and registered the plugin on the Update of Invoice Product
    form. Its working now.

    Regards,
    Vijay

  • RELEVANCY SCORE 2.74

    DB:2.74:After Invoicing Buyer Requested A Different Shipping Rate, How Do I Send A New Invoice? fd



    Hey everyone,

    Just getting some selling underway.

    Had a question about transactions.

    I had a buyer request a total so I invoiced them, but then they requested a different shipping method.

    How do I send them a new invoice? A second invoice? How do I re-invoice them?

    (I am adding the question in different wording so that it will come up in search results...)

    Thanks so much!

    DB:2.74:After Invoicing Buyer Requested A Different Shipping Rate, How Do I Send A New Invoice? fd


    The easiest way (for me) is to go back to the original end of transaction email you received fromeBay, click on the "Send invoice to buyer" link (under the buyer's name and address) and fill the new shippinginformation.

    This newer invoice automatically supercedes wharever information was sent earlier.




  • RELEVANCY SCORE 2.73

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



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

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


    Hi Jakob,

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

    thanks

    Sandeep Singh

  • RELEVANCY SCORE 2.73

    DB:2.73:Crystal Report Multiple Columns mc



    I'm having trouble with Crystal Report's multiple columns in the detail section.

    The details section, the multiple columns is checked then the printing direction is across - down. Since the form I am using is a pre-printed form, by estimation it can only allow at best 30 records in one page, that is 15 in the 1st half of the column and another 15 records on the next. For visual:

    Invoice No Invoice Date invoice total Invoice No Invoice Date invoice total

    1 16

    2 17

    3 .

    . .

    . .

    . 28

    14 29

    15 30

    For some reason there is this giant space after the last set of rows before it prints out the page footer. This giant blank section disrupts the layout of the page footer section.

    Here are some info on the details section as configuration is involved:

    Format with Multiple Columns - checked

    In Paging: New Page after 30 visible Records

    In Layout: Width: 3.5 in Height: 0.0 in

    Horizontal: 0.0 in Vertical: 0.0 in

    Printing Direction: Across-Down

    Anyone knows how to suppress it or have the page footer move upwards?

    P.S To see actual pre-printed form, please download this [http://www.mediafire.com/i/?csu0q75mjynys2k]

    Edited by: Khristine Angelei Basilla on Mar 1, 2012 8:34 AM

    DB:2.73:Crystal Report Multiple Columns mc


    Thanks for all the suggestions.

    Added the second detail in the group footer thru a sub report.

    adjusting it to stay in their "assigned" places is what I'm working out.

  • RELEVANCY SCORE 2.72

    DB:2.72:Total On Group Sorted Columns In Discoverer Plus j1


    Hi,

    We are facing an issue with the Total on a Group Sorted Column. Below are the details.

    Ex. The result set from a Custom Folder based on a Query is as shown below.

    |Batch | Invoice | Invoice Amount | Dist Line | Dist Line Amount |
    |1|1 |1000.00 |1|100.00 |
    |1|1 |1000.00 |2|200.00 |
    |1|1 |1000.00 |3|200.00 |
    |1|1 |1000.00 |4|500.00 |
    |1|2 |500.00 |1|500.00 |
    |1|3 |1000.00 |1|1000.00 |

    The issue is with Batch Total.

    In Discoverer Plus,
    - We have Batch as a Page Item.
    - We have Group Sorted the Invoice and Invoice_Amount Columns. Hence it is not displayed in Dist Lines 2, 3 and 4 for Invoice 1

    BATCH : 1 (Page Item)
    | Invoice | Invoice Amount | Dist Line | Dist Line Amount |
    |1|1000.00 |1|100.00 |
    | | |2|200.00 |
    | | |3|200.00 |
    | | |4|500.00 |
    |2 |500.00 |1|500.00 |
    |3 |1000.00 |1|1000.00 |
    | | Batch Total = ******** | | |

    Batch Total (Invoice Amount) = 5500.00 (When we use SUM or CELL SUM)
    * Its adding 1000 once for every Distribution Line.

    Batch Total (Invoice Amount) = 1500.00 (When we use SUM DISTINCT or CELL SUM DISTINCT)
    * Its adding 1000 only once as it considers it as DISTINCT Value.

    The Correct Batch Total should be 2500.00

    Any help in resolving this issue will be greatly appreciated.

    Thanks,
    Sujay

    DB:2.72:Total On Group Sorted Columns In Discoverer Plus j1

    Hi Micheal,

    I tried using the Average. No Luck.
    It does not compute the Total Correctly.
    Please let me know if you find any workaround to this issue.

    Thanks,
    Sujay

  • RELEVANCY SCORE 2.71

    DB:2.71:Hi - Invoice j9



    hi all

    i have customer po number in the tax invoice, now from this CPO nomber i have to get the total quantity in the p.o. for that cutomer p.o. number.

    right now i am getting bill quantity in tax invoice, i want total quantity for that cust. p.o. in tax invoice.

    thanx

    rocky

  • RELEVANCY SCORE 2.71

    DB:2.71:Withholding Tax Issue- Argentina k9



    Hello All,

    For Argentina, we are using "Withholding Tax type for Payment Posting".

    We have Payment grouping enable for the payment method.

    i.e. One Payment document for Multiple invoices.

    Our requirement is to have Withholding tax bae exemption amount considered per Payment document (and not per invoice)

    e.g. Invoice 1 base amount- 10000 ARS

    Invoice 2 base amount - 20000 ARS

    Total Base amount = 30000 ARS

    say, Withholding tax rate = 6%

    Withholding tax base exemption amount customied for Withholding tax type -Tax code combination is 1200 ARS

    DESIRED: So, Withholding tax should be (30000 - 1200) * 6% = 1728 ARS

    But what is right now being caluclated is per invoice

    this is what we are having

    (10000-1200)*6% = 528

    (20000-1200) * 6% = 1128

    Total = 1656 ARS

    i.e. withholding tax base exemption amount is deducted for each invoice.

    How can we have the amount calculated per Payment Document.

    Can you please suggest.

    Thanks in Advance

    BR

    Amitash

    DB:2.71:Withholding Tax Issue- Argentina k9


    Hi Mgitur,

    I deleted and made the customizations again as per your screenshot and now it's working perfectly fine.

    Thanks a lot for your help.

    Cheers

    BR

    Amitash

  • RELEVANCY SCORE 2.71

    DB:2.71:Multiple Line Results m7



    I use Crystal to get shipments by warehouse.

    The only way to get this is by Order Entry line item detail - Warehouse # field. However, if I group by

    invoice #, I get multiple line results for every line item on the invoice. I only need one.

    So if I have total fields in the detail, I get repeated info.

    I cannot surpress becuause some totls may be the same on multiple invoices.

    If the last item on the invoice is freight or misc. charge, there is no warehouse associated with this so i get no answer if I just take the last record.

    The item line field (status) DOES NOT WORK other wise I could use a formula to pick warehouse for item # 1 line.

    Does anyone have any ideas?

    DB:2.71:Multiple Line Results m7


    If you could post some sample data that would help.

    What about multiple groups. group by warehouse and then date, item number etc.

    Once you have these, supress the group headers / footers as needed.. Again a sample of the

    data would help.

  • RELEVANCY SCORE 2.71

    DB:2.71:Webservice Managecustomerinvoicerequestin c9



    Hello all,

    We've having some problems with the ManageCustomerInvoiceRequestIn webservice.

    We have been able to setup the webservice and generate customer invoice requests in the BYD system.

    However the customer invoice request only have one line/product and we want to create invoice requests that have multiple lines/products.

    We have attempted to update some of the ID's in the xml as we assume that there is a header id and item id's, but have not been successful.

    Can someone tell me the specific tags in the xml that are used to create multiple lines under one invoice request?

    If anyone had a sample xml file with the invoice id and invoice id line items marked that would be appreciated.

    Best regards,

    Kevin.

    DB:2.71:Webservice Managecustomerinvoicerequestin c9


    providing a sample of the XML you are sending would be helpful.

    When adding them you do not need to provide ID's SAP will Assign them automatically... You just need the Product and quantity and pricing information

    for example

    Item ReceivablesPropertyMovementDirectionCode2/ReceivablesPropertyMovementDirectionCode Product InternalIDMCF-0001/InternalID TypeCode1/TypeCode /Product Quantity unitCode="EA"1.0/Quantity QuantityTypeCodeEA/QuantityTypeCode PriceAndTax PriceComponent TypeCode7PR1/TypeCode Rate DecimalValue500/DecimalValue CurrencyCodeUSD/CurrencyCode BaseDecimalValue1/BaseDecimalValue BaseMeasureUnitCodeEA/BaseMeasureUnitCode /Rate /PriceComponent /PriceAndTax/Item

  • RELEVANCY SCORE 2.70

    DB:2.70:Printing Invoice Appendix On Last Page Of Each Invoice c8


    Hello,

    I have to print "Invoice Appendix" at the last page Of each Invoice Print Report.
    Invoice Appendix is coming properly if u run for a single Invoice as i have used section Break as bellow-

    Start Of Invoice Header
    Start Of Invoice Lines
    End Of Invoice Lines
    End Of Invoice Header
    --------------Section Break------------
    Start Of Invoice Appendix
    End Of Invoice Appendix

    But when i run the report for multiple Invoice "Invoice Appendix" print only on last page of the last Invoice.
    Can you please Help me, I need Invoice Appendix should display for every Invoice at the last Page. i'm using xmlp 5.6.1

    Regards,
    Aanta.

    DB:2.70:Printing Invoice Appendix On Last Page Of Each Invoice c8

    Hi Aanta
    You need to be on 5.6.2 release, you can then use the last page only feature to do this. Check the user guide for details.
    Regards, tim

  • RELEVANCY SCORE 2.70

    DB:2.70:Setcurrentline Lines.Count On A Sales Bom 3j



    I'm trying to update the value of the ProjectCode column in the Invoice just before I add the Document. For that I'm doing a Loop thru the Document Line and set the Project Code . The Problem I'm having is the Item in the Invoice are Sales BoM Items, so SB1 automatically adds the components to the Invoice row below the parent Item. When I try to do a Lines.Count is only counting the Lines for the Parent Items instead of all the lines in the Document , The same happen to the SetCurrentLine(linenumber) . I 'm using that property to check what is the returned value of the Item Code and instead of giving me the components item is returning the next parent Item in the Invoice Lines.

    Total Sales BoM Item added to the Invoice is :284 Items

    Total Lines after adding the transaction : 1000

    Total Lines Documents.Lines.Count return prior to add the document: 284

    For some reason those Properties doesn't seem to take into consideration lines added by the application.

    Does anyone have an idea why does the SDK only count the lines for the parent Item.

    Any Help will be appreciated

    DB:2.70:Setcurrentline Lines.Count On A Sales Bom 3j


    HI,

    No Idea, reason could be if you have a sales BOM which build from subset of sales BOM (parent-child), in this case at the end will now the lines count (recursively). Try it, the system always shows the first level in the marketing documents.

    But if you have only one projectcode by sales BOM item, i think it could not be a problem. (loop and set up).

    Even if you want to set different project codes within 1 sales BOM item, (child-by-child different), I am suggeting the following:

    1. Add as draft document

    2. Open the draft and now loop and set up the projectcode item-by-item

    3. Add draft as normal invoice

    4. delete the draft.

    It is works.

    Regards,

    J.

  • RELEVANCY SCORE 2.70

    DB:2.70:Need Changes In Fm Spell_Amount zz


    Hi All,
    There is Invoice of my customer in SAPSCRIPT,and they need some changes in invoice, There are 3 columns in Invoice.
    1 Total Invoice Amount
    2 Previous Outstanding Amount
    3 Total Amount due.
    and in last column showing rupees in words.
    Rupees in words showing Total Invoice amount in words,but my client want in place of Total invoice amount value(in words)
    it has to show Total amount Due rupees in words.
    In master code I have use FM SPELL_AMOUNT.
    here inplace of Total Invoice amount variable i have used Total amount Due varible to print.
    But its not working.
    Please help me out .

    Thanks and Regards
    Sankil

    DB:2.70:Need Changes In Fm Spell_Amount zz


    First split tot_amt_due in 3 parts

    tot_amt_due_c

    tot_amt_due_rs

    tot_amt_due_ps

    then declare data element foe all 3 varibles.

    SPLIT tot_amt_due_c AT '.' INTO tot_amt_due_rs tot_amt_due_ps.

    and call 2 FM module for rs ans ps varibles and pass these varibles.

    Thanks

    Sankil

  • RELEVANCY SCORE 2.70

    DB:2.70:Multiple Invoice For One Po ck



    Hi all

    We had a PO of 100 quantities.The GR was made 4 times for 25 materials. Now when we do MIRO,the quantity is showing 75

    as IV was done for 25 before.But now we have to make 3 invoice for 25 each, but its showing the total 75.

    How do i solve this??

    Thank You

    DB:2.70:Multiple Invoice For One Po ck


    Hi SD,

    You can Post 3 invoices with 25 Qty each even though it is showing 75.

    You are using PO based IV

    Cheers

    Vishal...

  • RELEVANCY SCORE 2.70

    DB:2.70:Can Anyone From Sap Comment On This? Credit Note From Ap Invoice px



    Hi all!

    I'm creating a partial credit note from a Service AP invoice via DI.

    My invoice has 2 lines, the first for 10.000, the second from 5.000 (no VAT to keep things simple) Tot = 15.000.

    In the credit note I have the first line for 2.000 and the second for 1.000, Total = 3.000.

    I set for the first line

    CreditNote.Lines.BaseType = "18"

    CreditNote.Lines.BaseEntry = 28

    CreditNote.Lines.BaseLine = 0

    CreditNote.Lines.Line Total = 2.000

    and for the second

    CreditNote.Lines.BaseType = "18"

    CreditNote.Lines.BaseEntry = 28

    CreditNote.Lines.BaseLine = 1

    CreditNote.Lines.Line Total = 1.000

    and for the CreditNote

    CreditNote.DOcTotal = 3.000

    Saving, I obtain a CreditNote with the first line for 10.000, the second for 5.000 and a total discount of 12.000, Total = 3.000. (same invoice amounts on the lines

    and a discount to get the correct invoice total).

    My question is: isn't there a way to obtain a credit note linked to the invoice but with line amounts different from the ones of the invoice (in my example: first line 2.000, second 1.000) and without discount?

    in B1 you can do it!!!

    I know that from a fiscal point of view the result is the same, but seeing credit notes in B1 different from the vendor documents is pretty upsetting for some customers ...

    Thanks in advance,

    francesca

    DB:2.70:Can Anyone From Sap Comment On This? Credit Note From Ap Invoice px


    Nevermind!

    I solved the problem: even with DI you can create a partial Credit Note.

  • RELEVANCY SCORE 2.70

    DB:2.70:Miro : Direct Posting For Material 8m



    Hi,

    In posting invoice with MIRO for material, after completion of invoice and posting, system is adding total stock value but not total stock for a material.

    Do anyone know about it? is it standard one?

    I am expecting additon of material stock along with stock value.

    Rgeards,

    Rahul Mandale

    DB:2.70:Miro : Direct Posting For Material 8m


    Hi,

    I understood qty will be updated in GR only.

    If I do MIRO for material posting, what could be the next step so that we can get stock updated?

    How I should do MIGO ref to that invocie document or GR/ IR clearing?

    Else any other option..

    Regards,

    Rahul Mandale

  • RELEVANCY SCORE 2.70

    DB:2.70:Quantity Column Total In The A/R Invoice pa



    Hi Experts,

    My client requirement is , In the A/R Invoice they want to see the total of quantity as they adding the items in the row-wises.And also i have added one UDF column for "No of cartons"(for multiple UOM purpose) even i want total for this UDF column also Whereas, Even i had tried using Subtotal in Type option , we able to see only total of Amount.

    Is it possible to add the total field for the coloumns in A/R invoices in Business01 2007 A.

    Regards,

    Dwarak

    DB:2.70:Quantity Column Total In The A/R Invoice pa


    Hi Dwarak.....

    Run time total sum is not possible throgh FMS else you would have to to SDK work. But if you want it to be displayed then you can display it into the simple PLD. Whenever your client requires he will fill the AR invoice details and just click on the print preview. This way you can solve the purpose.......

    Regards,

    Rahul

  • RELEVANCY SCORE 2.69

    DB:2.69:How To Put The Invoice Total On The Footer Section Of Last Page? zs


    Hi,

    I have a problem to put the invoice total on the footer section of last page? The invoice total is a value from a XML field which comes with one of tag in the XML file. I am beginner to XML Publisber, please help. thanks.
    Edmond

    DB:2.69:How To Put The Invoice Total On The Footer Section Of Last Page? zs

    Hi Hanson,
    Thanks for your reply. Sorry about that I don't understand how can I do that as I am beginner to XML Publisher. I appreciate if you could show me how and more details.
    Edmond

  • RELEVANCY SCORE 2.69

    DB:2.69:Bi Publisher Problem To Generate Multiple Pdf Document For One Invoice Xml. pm


    Customer is working with the integration BRM-BIP to generate PDF invoices.

    So they use the pin_inv_doc_gen batch to generate PDF documents. The problem is that they want to generate 3 PDF documents for each XML invoice.
    Oracle confirmed them that they can have multiple documents for the same invoice XML, and this by using the bursting mode.
    They tried to use the bursting with the integration BRM-BIP but they cannot have multiple PDF documents.

    They need help. We need some examples of using the bursting with the pin_inv_doc_gen ( BRM-BIP integration).

    DB:2.69:Bi Publisher Problem To Generate Multiple Pdf Document For One Invoice Xml. pm

    Customer is working with the integration BRM-BIP to generate PDF invoices.

    So they use the pin_inv_doc_gen batch to generate PDF documents. The problem is that they want to generate 3 PDF documents for each XML invoice.
    Oracle confirmed them that they can have multiple documents for the same invoice XML, and this by using the bursting mode.
    They tried to use the bursting with the integration BRM-BIP but they cannot have multiple PDF documents.

    They need help. We need some examples of using the bursting with the pin_inv_doc_gen ( BRM-BIP integration).

  • RELEVANCY SCORE 2.69

    DB:2.69:One Invoice Document With Multiple Charges For Multiple Currencies kj



    We have a scenario whereby one of our customer's requests is for their invoice to be billed in two currencies. This means, the meter consumption will be divided by two price blocks and each block will be charged at a different currency. Thus, the invoice which is in one billing and print document will show two price blocks with two different currencies. The same will be shown in the customer's account balance.

    Eg:

    Consumption = 200kwh

    Invoice:

    Line 1: 1st block 50kwh @ u20AC0.30 = u20AC15.00

    Line 2: 2nd and remaining block 150kwh @ US$0.15 = US$22.50

    Grand total of invoice = u20AC15.00 and US$22.50.

    Is this possible to be done in SAP?

    DB:2.69:One Invoice Document With Multiple Charges For Multiple Currencies kj


    We have a scenario whereby one of our customer's requests is for their invoice to be billed in two currencies. This means, the meter consumption will be divided by two price blocks and each block will be charged at a different currency. Thus, the invoice which is in one billing and print document will show two price blocks with two different currencies. The same will be shown in the customer's account balance.

    Eg:

    Consumption = 200kwh

    Invoice:

    Line 1: 1st block 50kwh @ u20AC0.30 = u20AC15.00

    Line 2: 2nd and remaining block 150kwh @ US$0.15 = US$22.50

    Grand total of invoice = u20AC15.00 and US$22.50.

    Is this possible to be done in SAP?

  • RELEVANCY SCORE 2.69

    DB:2.69:Invoice Blocking Due To Tolerance Limit At Header Invoice Value. 8s



    Hi,

    Our client needs to have tolerance limit set for total Invoice value.The Invoice contains multiple line items.The tolerance may be % or $ value.The standard setting which I know is for each Invoice line item but not for cummulative.The issue is if we post exceed but within tolerance amount for each line item from the Invoice containing multiple line items,the total Invoice value exceeds considerably.

    Please let me know the how to deal with this issue?

    DB:2.69:Invoice Blocking Due To Tolerance Limit At Header Invoice Value. 8s


    Hi Mandar,

    Set Tolerance Limits:

    In this step, you specify the tolerance limits for each tolerance key for each company code.

    When processing an invoice, the R/3 System checks each item for variances between the invoice and the purchase order or goods receipt. The different types of variances are defined in tolerance keys.

    As per your req ,it is not possible to compare PO Net header value with GR Total value and Toatl Invoice value because PO , GR and Invoice may contain the different line items.

    we are always doing Invoice verification at item level not on header level so SAP provides all the keys at item level only.

    Rewards if helpful...

    Regards

    Sanjay L

  • RELEVANCY SCORE 2.69

    DB:2.69:Variance For Total Invoice Amount 73



    Hi Experts,

    Please advise which variance i can use for total invoice amount. We have price and quantity varaince at item level. But at header level for total invoice amount there is no variance. User is able to enter any amount and it is going to "Inventory Small Diff" account. Please advise.

    Regards,

    Kamal

    DB:2.69:Variance For Total Invoice Amount 73


    Hi

    You can use BD (for posting small difference to an intermediate account) and PP (controls the total invoice amount with respect to item details amount).

    Thanks

  • RELEVANCY SCORE 2.69

    DB:2.69:In India Capture Of Multiple Excise Invoice At The Time Of Goods Receipt dd



    We would like to capture multiple excise invoice at the time of Goods Receipt. The excise invoice number captured should be updated in the RG 23 register with individual entry of excise invoice number and Qty against that excise invoice.

    The total GR will contain multiple excise invoice

    Can we use any user exit for the same or can anybody share there experiences.

    Amrish Sheth

    DB:2.69:In India Capture Of Multiple Excise Invoice At The Time Of Goods Receipt dd


    We would like to capture multiple excise invoice at the time of Goods Receipt. The excise invoice number captured should be updated in the RG 23 register with individual entry of excise invoice number and Qty against that excise invoice.

    The total GR will contain multiple excise invoice

    Can we use any user exit for the same or can anybody share there experiences.

    Amrish Sheth

  • RELEVANCY SCORE 2.69

    DB:2.69:Multiple Invoice Register - Fb60 sc



    Hi guys,

    actually I have to register in sap with FB60 a list of invoice. Example:

    vendor a

    vendor b

    vendor c

    I'm used to enter one by one the amount, the related cost center etc.

    Is there a way to import a list of them without adding one by one?

    I have an Excel sheet compiled with all the info I need..

    DB:2.69:Multiple Invoice Register - Fb60 sc


    too difficult in my honest opinion..

    you have to save the excel file in the txt - import it - update sap

    correct?

    I have to do this job once a month..

  • RELEVANCY SCORE 2.68

    DB:2.68:Not Adding Shipping Cost 1j



    I have never had this problem before. The invoices I am sending to theeBay buyers areshowing shipping cost but are not adding the shipping cost to the total of the invoice so I am not being paidfor the shipping cost. John

    DB:2.68:Not Adding Shipping Cost 1j


    I have never had this problem before. The invoices I am sending to theeBay buyers areshowing shipping cost but are not adding the shipping cost to the total of the invoice so I am not being paidfor the shipping cost. John

  • RELEVANCY SCORE 2.68

    DB:2.68:How Do I Update Of An Invoice With Multiple Detail Lines? kc


    I have a custom domain server which inherits DomainService. In it I have the following method:
    public Invoice GetInvoice(Invoice invoiceNo) {...}
    This method passes back an Invoice object which also has a List of InvoiceDetails. I have all the CUD methods for Invoice and Invoice Detail. The get invoice method works nicely and the binding to my silverlight page is great.
    When I run my silverlight program I modify some invoice header information and one or two detail lines. I then press the sumbit button I added and back on the server UpdateInvoice runs once and UpdateInvoiceDetail runs twice (once for each detail line I
    modified).
    I need to handle this invoice as one entity(header and details). Not only do I have to make sure that the detail lines I have changed(2 of 7) have not been changed by someone else, I have to make sure the other detail lines(the ones I haven't changed) also
    have not been changed by someone else. I also have to add up the amounts on all the detail lines and store the total on the header.
    How do I do this?
    oh, one other thing: When UpdateInvoice is called it's InvoiceDetails list is null so I can't just code the UpdateInvoice method and leave UpdateInvoiceDetail method alone. Also, what if I just update the details lines on the client and press submit? UpdateInvoice
    is not called at all.
    Here is my server code if interested:

    namespace SilverlightApplication3.Web.Services
    {

    // TODO: Create methods containing your application logic.
    [EnableClientAccess()]
    public class ReceivablesDS : DomainService
    {
    // fill these in later
    public void InsertInvoice(Invoice invoice){}
    public void UpdateInvoice(Invoice invoice)
    {
    // invoice.details is null at this point???
    }
    public void DeleteInvoice(Invoice invoice){}

    public void InsertInvoiceDetail(InvoiceDetail invoiceDetail) { }
    public void UpdateInvoiceDetail(InvoiceDetail invoiceDetail)
    {
    }
    public void DeleteInvoiceDetail(InvoiceDetail invoiceDetail) { }

    public Invoice GetInvoice(string invoiceNo)
    {
    using (Receivables db = new Receivables()) // an ODBC implementation for linq
    {
    ListInvoice invoices = (from i in db.arInvoiceHeaders
    where i.invoiceNo == invoiceNo
    select new Invoice()
    {
    billCustomerNo = i.billCustomerNo,
    billingDate = i.billingDate,
    customerNo = i.customerNo,
    detailDesc = i.detailDesc,
    discountAmt = i.discountAmt,
    discountDate = i.discountDate,
    dueDate = i.dueDate,
    headerCode = i.headerCode,
    headerType = i.headerType,
    interestCode = i.interestCode,
    interfacedYn = i.interfacedYn,
    invoiceAmt = i.invoiceAmt,
    invoiceNo = i.invoiceNo,
    noprintYn = i.noprintYn,
    sourceCode = i.sourceCode,
    subsystemIdCode = i.subsystemIdCode
    }).ToList(); // urg, my sql language does not support TOP so I can't say .First();

    Invoice inv = invoices[0]; // hack: get the first row. Ya I know it may not exist. I'll handle that later

    // another hack because my customer linq provider for odbc does not support joins
    ListInvoiceDetail detail = (from id in db.arInvoiceDetails
    where id.invoiceNo == inv.invoiceNo
    select new InvoiceDetail()
    {
    invoiceNo = id.invoiceNo,
    detailLineNo = id.detailLineNo,
    priceAmt = id.priceAmt
    }).ToList();

    // attach the detail lines to the invoice and return it.
    inv.details = detail;

    return inv;
    } // using
    }

    public IEnumerableSourceCodeCB GetSourceCodeCB()
    {
    using (Receivables db = new Receivables())
    {
    return (from sc in db.arSourceCodes
    select new SourceCodeCB()
    {
    sourceCode = sc.sourceCode,
    sourceDescription = sc.sourceDescription
    }).ToList();
    } // using
    }
    } // class

    // source code combo box data
    public class SourceCodeCB
    {
    [Key]
    public System.String sourceCode { get; set; }
    public System.String sourceDescription { get; set; }
    }

    public class Invoice
    {
    [Key]
    public System.String invoiceNo { get; set; }

    public System.Int16 subsystemIdCode { get; set; }
    public System.String billCustomerNo { get; set; }
    public System.String customerNo { get; set; }
    public System.Int16 headerType { get; set; }
    public System.String headerCode { get; set; }
    public System.String interfacedYn { get; set; }
    public System.String noprintYn { get; set; }
    public System.Double invoiceAmt { get; set; }
    public System.Double discountAmt { get; set; }
    public System.String sourceCode { get; set; }
    public System.String interestCode { get; set; }
    public System.String detailDesc { get; set; }
    public System.String billingDate { get; set; }
    public System.String dueDate { get; set; }
    public System.String discountDate { get; set; }

    [Include]
    [Association(invoice_invoiceDetail,invoiceNo,invoiceNo)]
    public IEnumerableInvoiceDetail details { get; set; }
    }

    public class InvoiceDetail
    {
    [Key]
    public System.String invoiceNo { get; set; }
    [Key]
    public System.Int16 detailLineNo { get; set; }

    public System.Double priceAmt { get; set; }
    }

    } //namespace

    DB:2.68:How Do I Update Of An Invoice With Multiple Detail Lines? kc

    I read that I have to add [composition] to my associated table in order to to what I want so I added it between my include and association:

    [Include]
    [Composition]
    [Association(invoice_invoiceDetail,invoiceNo,invoiceNo)]
    however now I get the error when I press the submit button:
    Code: 4004
    Category: ManagedRuntimeError
    Message: System.ServiceModel.DomainServices.Client.DomainException:
    And error occurred while submitting changes on the DomainContext of type 'ReceivablesDS'

    and the error was not handled. You must handle the SubmittedChanges event on the DomainDataSource and call

    SubmittedChangesEventArgs.MarkErrorAsHandled() to avoid this exception. ---
    System.ServiceModel.DomainServices.Client.DomainOperationException: Submit operation failed.

    One or more associated objects were passed for collection property 'details' on type 'Invoice',

    but the target collection is null.

  • RELEVANCY SCORE 2.68

    DB:2.68:Invoice Total Amt ak


    Hi

    How to calculate invoice total amount in payables????

    DB:2.68:Invoice Total Amt ak

    Hi

    How to calculate invoice total amount in payables????

  • RELEVANCY SCORE 2.68

    DB:2.68:Consolidated Billing/Sales Order From Multiple Service Orders z7



    Hi,

    I have a requirement to consolidate a list of Service Orders per customer within a month and only bill them monthly based on these Services Orders. Also, for daily shipment, we will have to generate a proforma invoice to clear Customs.

    Can someone please give me a pointer of how this should be done in CS?

    *Scenario:*

    Customer A

    - Service Order 001 ($200) - 01.06.2011

    - Service Order 002 ($300) - 01.06.2011

    -- Requirement to generate proforma invoice for this customer for shipment on 01.06.2011, total $500--

    - Service Order 003 ($250) - 02.06.2011

    - Service Order 004 ($100) - 02.06.2011

    -- Requirement to generate proforma invoice for this customer for shipment on 02.06.2011, total $350----

    - Service Order 005 ($100) - 03.06.2011

    - Service Order 006 ($300) - 03.06.2011

    -- Requirement to generate proforma invoice for this customer for shipment on 03.06.2011, total $400--

    By month end, to create a Sales Order and bill them for total of $1250

  • RELEVANCY SCORE 2.68

    DB:2.68:Formatting Issues In The Template Builder m3


    Hello,
    I just started using the XML Publisher/Template Builder and am coming across some formatting problems. For example, I am trying to create an RTF template for the Invoice. The XML was generated via a concurrent program from Oracle Applications. This XML has hundreds of invoices in it. The problems I'm facing in creating the RTF template for the Invoice are as follows:

    1. Page header/footer not printing.
    2. Each new invoice not starting on a new page.
    3. Would like the invoice header data (like the invoice number, date, order number, bill to and ship to addresses etc.) to print at the top of each page.
    4. Would like the invoice footer data (like the invoice sale amount, freight, sales tax and total) to print on just the last page after all invoice lines have been printed.
    5. If the invoice lines continue on to the next page, they should be preceded by the invoice header section.
    6. One of the invoice line fields (unit price) doesn't seem to be lining up with the rest of the fields.
    7. Can the conditional printing of the invoice title be placed into the page header?

    How do I attach my XML, RTF and PDF Output files to this message for reference? I would truly appreciate if you could provide any insight on my issues.
    Sincerely,
    Smita :)
    Email: spatangay@breg.com
    Phone: (760)599-5753

    DB:2.68:Formatting Issues In The Template Builder m3

    Hi

    I hv done the invoice, very efficiently, shoot me ur email ids at oracle_raj@yahoo.com and i will send you the required template..

    regs
    raj

  • RELEVANCY SCORE 2.68

    DB:2.68:Unbalanced Transaction Total - Invoice fz



    Hi,

    I am using the DI API to connect to a webservice which is pulling back Reserve Invoices placed on an online store and the payments. These have to equal the same amount.

    I am creating the invoices but there are some which are having rounding problems which result in the payment equaling a different amount to the invoice.

    Is there a way that you can explicitly set the document total so that it is always equal to the payment amount using the DI API which will use a rounding amount to automatically correct any differences?

    For example:

    Web invoice payment total = $100.00

    Sap calculated invoice total = $100.01

    Using the DI it would automatically calculate - Invoice DocTotal $100.00 + Rounding Required $0.01

    If this was possible it would allow me to ensure the payments would reconcile exactly for each transaction.

    Any help appreciated

    DB:2.68:Unbalanced Transaction Total - Invoice fz


    You can use workaround - create first the invoice as draft, get the doctotal, remove draft and create invoice once again with known doctotal.

  • RELEVANCY SCORE 2.67

    DB:2.67:Adding A New Material While Saving The Invoice In Sap Sd Module 7m



    Hello,

    We have a requirement where we need to create a Invoice with reference to sales order through VF01.

    While saving the Invoice a new line item (Material) must be added in the invoice through some Exit/BADI/Enhancement.

    We have written the code in the Enhancement spot of the include LV60AB03.

    The new line item is getting added when we enter the sales order in the initial screen but not getting saved while saving the invoice.

    When we check the invoice in VF03 the new material does not exist.

    Also we are getting an error when invoice is created.

    Document has been saved (Pricing error)

    Message VF071.

    Could anybody please provide information on how to add the new item/material at the time of saving the invoice with the correct pricing data?

    Thanks Regards

    Abdul samee

    DB:2.67:Adding A New Material While Saving The Invoice In Sap Sd Module 7m


    Hi Abdul,

    Can you please let me know if you are able to get this functionality? I have a requirement for similar functionality to add new material into Invoice at the time of creation. I tried to search for user exits as well.

    Can you please help me to resolve this? Can you tell me what is the user exit you have used?

    Regards,

    Suresh Linga.

  • RELEVANCY SCORE 2.67

    DB:2.67:Barcode Counting Over Groups zj


    Hi all,

    I am working on a barcode for my invoices print. This barcode counts over the invoices from 1 to 16 and then starts over again. For example if i have a set of 6 invoices each of 3 pages the barcode numbering will be as follows:
    invoice 1 page 1: 1
    invoice 1 page 2: 2
    invoice 1 page 3: 3
    invoice 2 page 1: 4
    invoice 2 page 2: 5
    ....
    invoice 5 page 3: 15
    invoice 6 page 1: 16
    invoice 6 page 2: 1
    invoice 6 page 3: 2

    I have tried to solve this with some xsl-fo programming, but i can't get the page-number or total pages per invoice into a variable. So I can't determine how many pages have been printed for previous invoices and which is the next number to print in the barcode.

    Hope you can give me some advice.

    DB:2.67:Barcode Counting Over Groups zj

    Hi all,

    I am working on a barcode for my invoices print. This barcode counts over the invoices from 1 to 16 and then starts over again. For example if i have a set of 6 invoices each of 3 pages the barcode numbering will be as follows:
    invoice 1 page 1: 1
    invoice 1 page 2: 2
    invoice 1 page 3: 3
    invoice 2 page 1: 4
    invoice 2 page 2: 5
    ....
    invoice 5 page 3: 15
    invoice 6 page 1: 16
    invoice 6 page 2: 1
    invoice 6 page 3: 2

    I have tried to solve this with some xsl-fo programming, but i can't get the page-number or total pages per invoice into a variable. So I can't determine how many pages have been printed for previous invoices and which is the next number to print in the barcode.

    Hope you can give me some advice.

  • RELEVANCY SCORE 2.67

    DB:2.67:Invoice Reduction For Multiple Document Types 99



    Hi experts,

    Is there a possibility to confugure invoice reduction for multiple document types in MIRO?

    I have settings for invoice reduction for document type KR /Vendor invoice in local currency/ in MIRO. I' d like to set invoice reduction for document type PI /vendor invoice in foreign currency/.

    Thanks!

    Geri

    DB:2.67:Invoice Reduction For Multiple Document Types 99


    Hi experts,

    Is there a possibility to confugure invoice reduction for multiple document types in MIRO?

    I have settings for invoice reduction for document type KR /Vendor invoice in local currency/ in MIRO. I' d like to set invoice reduction for document type PI /vendor invoice in foreign currency/.

    Thanks!

    Geri

  • RELEVANCY SCORE 2.67

    DB:2.67:Sum Column 77


    I have an SQL Server datasource with two joined tables; Invoice and Charge where each invoice has multiple charges. I would like to build an invoice summary screen where the user can update the invoice details and also see the total cost of all the
    associated charges.
    As there can be up to a million rows per invoice if I use a calculated column it takes ages to calculate the value. Ideally what I need is for the server to perform the SUM such as the SQL below:
    SELECT InvoiceNumber, SUM(Amount)
    FROM Invoice
    INNER JOIN Charge
    ON Invoice.idInvoice = Charge.idInvoice
    GROUP BY InvoiceNumber
    This returns the values I need almost instantly. How can I intercept the query for the screen to pull back a sum column?

    Thanks in advance for any help.

    DB:2.67:Sum Column 77

    @graham. Just curious what kind of invoice has a million line items?
    Because you want a calc after a change, that would involve either a client side sum (which is not going to work here) or some form of additional fetchafter a collection change event on child items. So you can update parentria record whichcalcs
    the sum server side, or fetch just the sum using an ria tableor a LS Command table pattern (CTP) that returnstheserver side calculatedoutput in one of thecommand table fields, then update ascreen data item field with the
    new value. UsingCTP in this wayis basicallya remote api call when you think about it.

  • RELEVANCY SCORE 2.67

    DB:2.67:Cst Calculation E1 Purchase Transaction ap



    Hi All,

    I am having a requirement of cst calculation in case of E1 purchase transaction (Sale in transit).

    Example of E1 Purchase Process :

    A is the Material Manufacturer in state X.

    B is the Dealer in state Y.

    C is our client in state Y.

    In this scenario to avoid multiple taxation E1 sales is carried out.

    A delivers material to C Sends invoice to B.

    Price - 100 , CST 2 % = 2 Rs.

    Now B sends final invoice to C with adding profit but sales tax is pass on.

    Price - 100 , Profit - 10, Total base price = 110, CST = 2 (Pass On from A).

    In this Process our client is C they want to have system based CST calculation. We are using tax procedure - TAXINJ.

    Please suggest how to achieve it.

    Regards

    Nitesh

    DB:2.67:Cst Calculation E1 Purchase Transaction ap


    Hi All,

    I am having a requirement of cst calculation in case of E1 purchase transaction (Sale in transit).

    Example of E1 Purchase Process :

    A is the Material Manufacturer in state X.

    B is the Dealer in state Y.

    C is our client in state Y.

    In this scenario to avoid multiple taxation E1 sales is carried out.

    A delivers material to C Sends invoice to B.

    Price - 100 , CST 2 % = 2 Rs.

    Now B sends final invoice to C with adding profit but sales tax is pass on.

    Price - 100 , Profit - 10, Total base price = 110, CST = 2 (Pass On from A).

    In this Process our client is C they want to have system based CST calculation. We are using tax procedure - TAXINJ.

    Please suggest how to achieve it.

    Regards

    Nitesh

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Use Autoinvoice To Import Summarized Invoices ! Asap (Correction) k3


    Hi !
    I have to use Autoinvoice to import legacy summarized invoices into Oracle Receivables and I need an explanation of how I have to do it.

    There are 2 legacy tables I have to use:

    Table 1: Contains summarized Invoices. A summarized invoice is an invoice without lignes and has only a total amount.
    Its fields are the following :
    - invoice number
    - customer Id
    - Amount (total amount)
    - due date

    Examples:
    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008

    In general a record in table 1 (a summarized invoice) is not associated with records from table 2 (Adjustments). But in some particular cases, it can be associated with adjustment records in table 2 but these adjustments are only information added to the summarized invoice and not a real adjustment. All what we need is to have adujstment information added to the summarized invoice so the adjustment amount is a additional information that must not be considered in any calculation.

    Here is the Adjustments table:
    Table 2: Adjustments
    It has the following fields:

    - Adjustment number
    - Adjustment date
    - Adjustment amount
    - Adjustment Type
    - Invoice number: number of the invoice to which the adjustment is associated (foreign key on Table 1)

    Example

    - Adjustment number: 1150
    - Adjustment date : 01-01-2008
    - Adjustment amount: 500$
    - Adjustment Type : Cancelation
    - Invoice number: 7899 (the second one above)

    The import result must be:

    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008
    - additional information for adjustment: Adjustment number=1150, Adjustment date=01-01-2008, Adjustment amount=500$, Adjustment Type= Cancelation.

    I think only RA_INTERFACE_LINE_ALL will be used since there is no distribution to define. Am I right? I think whe have to insert table 1 and table 2 data in RA_INTERFACE_LINES_ALL with the same batch source name.
    Questions:
    1- Must I define a grouping rule based on customer Id+ invoice number in order to gather invoice and its adjustment?
    2- What fields in interface table must be used and what must they contain as data from table 1 or 2 ?
    3- What are the flexfields that must be defined.4- What fields on interface table must be used to import adjustment info as additional information to an invoice ?

    Thank you for reply !

    DB:2.67:How To Use Autoinvoice To Import Summarized Invoices ! Asap (Correction) k3

    Hi !
    I have to use Autoinvoice to import legacy summarized invoices into Oracle Receivables and I need an explanation of how I have to do it.

    There are 2 legacy tables I have to use:

    Table 1: Contains summarized Invoices. A summarized invoice is an invoice without lignes and has only a total amount.
    Its fields are the following :
    - invoice number
    - customer Id
    - Amount (total amount)
    - due date

    Examples:
    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008

    In general a record in table 1 (a summarized invoice) is not associated with records from table 2 (Adjustments). But in some particular cases, it can be associated with adjustment records in table 2 but these adjustments are only information added to the summarized invoice and not a real adjustment. All what we need is to have adujstment information added to the summarized invoice so the adjustment amount is a additional information that must not be considered in any calculation.

    Here is the Adjustments table:
    Table 2: Adjustments
    It has the following fields:

    - Adjustment number
    - Adjustment date
    - Adjustment amount
    - Adjustment Type
    - Invoice number: number of the invoice to which the adjustment is associated (foreign key on Table 1)

    Example

    - Adjustment number: 1150
    - Adjustment date : 01-01-2008
    - Adjustment amount: 500$
    - Adjustment Type : Cancelation
    - Invoice number: 7899 (the second one above)

    The import result must be:

    invoice 1234
    - invoice number : 1234
    - customer Id : cust1234
    - Amount (total amount): 1000$
    - due date : 01-01-2008

    invoice 7899
    - invoice number : 7899
    - customer Id : cust7899
    - Amount (total amount): 2000 $
    - due date : 04-01-2008
    - additional information for adjustment: Adjustment number=1150, Adjustment date=01-01-2008, Adjustment amount=500$, Adjustment Type= Cancelation.

    I think only RA_INTERFACE_LINE_ALL will be used since there is no distribution to define. Am I right? I think whe have to insert table 1 and table 2 data in RA_INTERFACE_LINES_ALL with the same batch source name.
    Questions:
    1- Must I define a grouping rule based on customer Id+ invoice number in order to gather invoice and its adjustment?
    2- What fields in interface table must be used and what must they contain as data from table 1 or 2 ?
    3- What are the flexfields that must be defined.4- What fields on interface table must be used to import adjustment info as additional information to an invoice ?

    Thank you for reply !

  • RELEVANCY SCORE 2.67

    DB:2.67:Adding Dynamic Pages If The Total Number Of Pages Are Not Multiple Of 4 In Ssrs x9


    Hi
    I am working in a project where I need to develop a SSRS Report which will be exported to PDF , then print it a Book.
    Now the problem is that the book needs the number of pages to be multiple of 4. So the Report(PDF) is always should have multiple of 4 pages. If the total number of pages if not multiple of 4 then, I can add some text(other reports) which are of 1 or 2 or
    3 page contents.

    So in SSRS how can we identify the total page numbers with in the page(not in Footer or Header), so that I can show the extra pages(from different report).

    Please suggest me if you have any ideas.
    I am using SSRS 2008
    Thanks in advance.Sanjay

    DB:2.67:Adding Dynamic Pages If The Total Number Of Pages Are Not Multiple Of 4 In Ssrs x9

    Please refer below links
    http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/c2047eee-41a8-4d79-ae58-dbf60f6e7554/
    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/243e6b82-70f5-4051-8b3f-4110f931591fNanda

  • RELEVANCY SCORE 2.67

    DB:2.67:Payment Recieved, But Need To Add To Total Due To Shipping. p7



    Hi,

    Sold an item on eBay which had a domestic USA shipping cost paid by the buyer. However after payment was received, found out that the buyer lives in Poland. This will increase the shipping cost, but how do I go about adding to the total. Do I have to refund total mount and resend invoice? Or is there an easier way to do this? Thanks in advance!!

  • RELEVANCY SCORE 2.67

    DB:2.67:How To Get Total Amount Of Invoice cs



    Hi Friends,

    I am creating an invoice in FB60. I want to get the total amount of this invoice. From which table can i get this value.

    I have the company code, document number, fiscal year as the key, what would be the logic to get the total invoice amount.

    Please advice.

    DB:2.67:How To Get Total Amount Of Invoice cs


    Do i need to loop on the line items to get the total amount or

    a select single on this table will do?

  • RELEVANCY SCORE 2.66

    DB:2.66:Chart Expression: Sum Of Value In One Table Based On Date In Another 77



    I have 2 tables:

    Sales Order Table:

    SO.DATE

    SORDREF

    Order Val

    Sales Invoice Table:

    SORDREF

    Invoice Date (as TR.DATE)

    Invoice Val

    The Sales Order can have multiple lines in the Sales Order Table; Each Sales Order line in the Sales Order Table can have a one to many relationship with lines in the Sales Invoice Table.

    I created a straight table showing the Date and Value (using a simple sum expression) for each Sales Order ie using ony fields from the Sales Order Table. As it calculates the Order Value, there is only one line item on the table for each order.

    Then I introduce the TR.DATE field from the Sales Invoice table. Where there is more than one TR.DATE for a Sales Order, the chart duplicates the total Sales Order value across each row for the order.

    Any suggestions.?

    Rgds

    Joe

    DB:2.66:Chart Expression: Sum Of Value In One Table Based On Date In Another 77


    Sorry, I don't understand the question. Maybe you could show some example data and the chart you want, or post a sample QlikView?

    Also, since this seems to have nothing to do with this particular thread, maybe you should start a new one?

  • RELEVANCY SCORE 2.66

    DB:2.66:Multiple Invoice Dates In One Query pm


    Hello Forum Members:

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

    DB:2.66:Multiple Invoice Dates In One Query pm

    Try changing the WHERE clause to:

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

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

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

  • RELEVANCY SCORE 2.66

    DB:2.66:Multiple Line Items In Customer Invoice j7



    Hi

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

    For Example :

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

    Customer Account DR 9000

    Sales Revenue1 CR 2000

    Sales Revenue2 CR 3000

    Sales Revenue3 CR 4000

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

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

    Thank

    Risha

    DB:2.66:Multiple Line Items In Customer Invoice j7


    hi, Risha:

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

    SD:SAP ERP Sales and Distribution (SAP SD)

    FI:SAP ERP Financials

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

    Best wishes.

  • RELEVANCY SCORE 2.65

    DB:2.65:Multiple Tax Codes sx



    Suppose i want to create anA/R invoice in which i have 3 items namely Item A,Item B,Item C

    Item A-----Rs.4000 @vat 4% = 4160

    Item B----Rs.4000 @vat 4% =4160

    Item C-----Rs.4000 @vat 4% =4160

    Total =12480

    Now i want to apply service tax@10.3 on above total amount Rs. 12480...How will i handle above scenario in SAP B1 2007B???

  • RELEVANCY SCORE 2.65

    DB:2.65:Sum Distinct Field ak



    Hello everyone,

    I'm trying to sum some values from a field based on another one. I would like to use something like Sum(TOTAL Invoice Number Sales) but, instead to use TOTAL I need to use Distinct, due to I have many re-invoices numbers belonging to the same original invoice, and of course, I need to sum just one time each.

    Thanks in advance!!!

    DB:2.65:Sum Distinct Field ak


    Jean-Jacques,

    Very smart and very easy solution. The situation is a little complicated to explain. But your solution works perfect!!! Thank a lot!!!

  • RELEVANCY SCORE 2.65

    DB:2.65:Invoice For Sales Bom Through Di k8



    Dear Experts,

    I have done coding for creating the AR Invoice through DI API. But some of the Items have the Sales Bom . Its not working while adding the Invoice specially with Batch managed items. How to manage this ??

    Thanks in Advance,

    Senthil.K

    DB:2.65:Invoice For Sales Bom Through Di k8

    Hi ,

    Please close the thread.if ur issue is resolved.

    Regards,
    Prasad

  • RELEVANCY SCORE 2.65

    DB:2.65:Supplimentary Invoice (Excise) 9m



    Hi gurus,

    i have a scenario factory to depot sale. say initially iam biiling to my depot @ Rs.100/- + ED now from depot i have bill to the customer after adding some margin say base price Rs.120/- + Ed taxes. Now this difference of Ed amount how to be billed. My client insists me to create supplimentary invoice. Is there any option for supplimentary invoice please send me the details immediately.

    Thanks in advance

    V.S.Aasish

    DB:2.65:Supplimentary Invoice (Excise) 9m


    Hi Vinayak,

    I think Virendra is correct in your case.

    Pls find more details below :

    Creating Additional Excise Entries at Depots

    From the SAP Easy Access screen, choose Indirect Taxes Procurement Excise Invoice For Depot Additional Excise Entry at Depot.

    In the Internal exc. inv. no. field, enter the internal excise invoice number at the depot along with the year, and choose .

    The system displays the information from the excise invoice which has already been created at the depot, including the excise group, vendor excise invoice number, ship from, and all the receipt against that excise invoice, highlighting the RG 23D folio and serial numbers.

    An excise invoice item can have multiple A certificates attached to it. The A certificates will have the same folio number as the original line item, but the serial numbers will be different. A hierarchy icon differentiates the additional lines for an item line.

    You can maintain the A certificate number, date, and additional BED, AED ,SED and CESS for a given RG 23D Folio.

    After entering an A certificate you cannot delete the A certificate from the system, but you can change it until it is picked up during removals from the depot.

    If some of the values in an A certificate are incorrect, you can make the values zero so that they do not have an impact on the final excise value.

    Once an A certificate is used for removals then it cannot be changed.

    Save additional excise entry.

    The system creates an entry in register RG 23D. Folio number generation must be active for you to make use of this supplementary invoice functionality at depot.

    J1IG : Create Initial Entry

    J1IGA : A certificate entry at Depot

    J1IGD : Display of A certificates at Depot

    Hope this helps you. Pls come back if any issue.

    Best Regards,

    Gaurav Raghav

  • RELEVANCY SCORE 2.65

    DB:2.65:Filter Not Working With Multiple Datasets 8f


    Hi,I have a report that is setup with multiple datasets (four).  I started with one, projects, the main one and put the CRMAF_ to filter it, and it works.  I added another dataset for invoices that relate to the project but it does not return anything but the info at the top of the table, while the project info returned is correct.  I have the main table in each dataset with the CRMAF_ prefix, but even without it I get the same results.  I could put it all into one big sql statement but thats just crazy.  The Project table links to the invoice, purchase order and change order tables with projectid.  Basically, its like this:The user wants the project name and initial estimate.  no prob.the user also wants the total amount from all invoices for the project.  invoice table links to invoice data based on invoiceid in both.the user also wants the total amount of purchase orders for the project.  purchases table links to purchases data based on purchaseorder id in both.the user finally wants the total amount of change orders for the project.  changes table links to the changes data based on changeorder id in both.I have all 4 separate sql statements and they all work fine, but all together in one report, they just wont work properly.  is there some sort of sytax that I might need to follow in terms of CRMAF_ prefix?  Does it have to be in the main sql clause(project) and not the rest or does it have to be in all of them?  I guess  the main question is will it work with multiple datasets? 

    DB:2.65:Filter Not Working With Multiple Datasets 8f

    The foreign key field is the field which is present in both tables.  In your example, it's invoiceid for the invoice dataset because invoice table links to invoice data based on invoiceid in both.

  • RELEVANCY SCORE 2.65

    DB:2.65:Running Total In A Pivot Table a8



    Appreciate that this is a quetsion which has been posted before but I have tried the sugestions with no success...

    I have two tables namely SalesInvoice (multiple records per invoice) and Customer (one record per customer).

    I have created a pivot table with the dimensions Customer and Customer Category.

    My expressions are...

    Sales

    =sum(if(sin_FinancialYear = varCustomerSort, sin_Sales))

    RowNo

    =RowNo()

    ** All of my row numbers are being reported as 1 (I have included this as previous posts have suggested using this field).

    The expression I would like to add is "Running Total"...

    Can anyone please give me some suggestions on how to achieve this?

    Many Thanks

    Paul

    DB:2.65:Running Total In A Pivot Table a8


    This works for me:

    rangesum(above(column(1),0,rowno())) where column 1 contains the values I want to cumulate








  • RELEVANCY SCORE 2.65

    DB:2.65:Incoming Payment az



    Hi gurus,

    I have an issue with Incoming payment processing.

    I get payment for multiple invoices from overseas customers after deduction of the overseas bank charges which is one amount.

    How can we account for such expeneses invoicewise.

    e.g. Invoice 1 - $100

    Invoice 2 - $ 200

    Invoice 3 - $ 300

    total $ 600

    Less : Bank charges - $ 60

    Net Recieved - $ 540

    We need to account for $ 60 against each invoice based on value given by the user (say for invoice 1, it is 10$, etc...), so that net realization for each invoice can be arrived.

    Can anybody suggest me the way out for this. I thought of using the transaction key SKT for cash discount but this will not work as actual discount also may to be entered.

    thanks...

    Bik

    DB:2.65:Incoming Payment az


    There are two options for the same.

    1. Configuring the tolerance limit for the payment differences and assigning them to a dedicated GL account. Of course the tolerance for the individual user should also allow this differences in Co code /Employee tolerance if defined.

    2. Second option - simulate the transaction - system will show the difference - assign the posting key and clear it off manually.

    Hope this will help u.

  • RELEVANCY SCORE 2.65

    DB:2.65:Obtain Total Tax On An Invoice. s7



    What is the best table to obtain total tax on an invoice?. I have customer number and the document number available.

  • RELEVANCY SCORE 2.64

    DB:2.64:App Error ss



    Hi,

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

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

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

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

    But In proposal its split like below

    25934.4025997.6523674.024194.402295.154173
    _____________________
    Total 86268.82
    ________________

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

    Can anybody sort my problem.

    DB:2.64:App Error ss


    Hi Madhusudanan,

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

    Assign point if helpful.

    Thanks,

    Mir

  • RELEVANCY SCORE 2.64

    DB:2.64:Clarfication On Account Receivables 7f


    Hi All,I am working in R12 account receivables.I have the following questions1. can we apply a credit memo to an invoice at line level ? If yes , will the invoice lines get updated with new amounts after applying credit memo to it.2. can we apply a receipt to an invoice at line level ? will invoice lines have updated amount after applying receipt at line level if yes.Also I could see some invoices where Line amount + tax amount not equal to total balance in the balance due tab of invoice transaction screen in ARI do not know what scenario caused this?please clarify.

    DB:2.64:Clarfication On Account Receivables 7f

    Hi All,I am working in R12 account receivables.I have the following questions1. can we apply a credit memo to an invoice at line level ? If yes , will the invoice lines get updated with new amounts after applying credit memo to it.2. can we apply a receipt to an invoice at line level ? will invoice lines have updated amount after applying receipt at line level if yes.Also I could see some invoices where Line amount + tax amount not equal to total balance in the balance due tab of invoice transaction screen in ARI do not know what scenario caused this?please clarify.

  • RELEVANCY SCORE 2.64

    DB:2.64:How To Select Multiple Ap Invoice Lines cx


    Hi all,

    In my AP invoice, I have many lines.
    And I would like to select some lines in order to discard them.
    But it seems that it is not possible. I tried to do that with SHIFT + select each line but it doesn't work.

    Thanks for your help !

    Tina

  • RELEVANCY SCORE 2.64

    DB:2.64:Unable To Invoice For More Than 19 Items At One Ti... sz


    HI,
    I am a fairly new Power Seller came across this problem first a few weeks ago when a customer bought over 60 individual items from me at one go. I was absolutely astounded when I tried to send her one combined invoice discovered that I could only invoice for 19 items at once. I immediately emailed Ebay who said that that was their policy if I wanted to make a suggestion to contact a different section which I did got an automated reply! They may well be looking into it but that doesn't help me now as I have several customers who buy large lots from me. It is an absolute pain as I have to send multiple invoices then an email with the actual total plus keep reinforcing the fact that they must only send ONE payment to prevent Paypal taking more charges.
    How do other sellers get around this? I would really welcome some advice.
    Thanks alot.

    DB:2.64:Unable To Invoice For More Than 19 Items At One Ti... sz

    On this board I made some past comments about my early SM Pro use for 'memo' (backup) accounting entries.

    But I only use SA Pro for real business as I've done since AA Pro, the 'pre SA Pro' version.

    SM Pro is superfluous.

    My comments and other SA/SM comparisons should still be available by using my Id on the board 'search' button.

  • RELEVANCY SCORE 2.64

    DB:2.64:Installment Payment Terms Value Break Up zd


    Hello All,As per Satndard configuration for installment payment terms, we can do the total value breakup into installment payment terms percentage wise(%).My requirement is in case I have 3 installment payment terms(Say SD01, SD02 SD03) wrt one master payment term(Say SD04), During invoice posting the amount should be fixed for first two payment terms(SD01 SD02) differential amount should be posted wrt Third Payment term(SD03). Can I do this through some standard Configuration / Enhancement / Exit.If not possible is there any other way through which I can generate multiple FI docs for single invoice based on fixed values for customer balances.Thanks Regards.Amit

    DB:2.64:Installment Payment Terms Value Break Up zd

    Hi AmitI believe your requirement can be solved by using Billing Plan Types. RegardsPraveen...

  • RELEVANCY SCORE 2.64

    DB:2.64:Databinding In Ef af


    I have 2 questions regarding databinding in EF.
    1) lets say I need to bind read-only data to a grid that needs to display: Invoice number, Invoice Date, Customer Name and Total ammount per invoice. Invoice Number and Invoice Date should be bound to Invoice object, Customer Name should be bound to Name
    property of Rererential entity Customer (Invoice.Customer), and total amount is SUM(quantity * price) from InvoiceData collection (Invoice.InvoiceData).
    What is the best way to achieve this? Since this is read-only data, anonymous types are logical choice. But is there some other way, maybe a future demand would be to be allowed to change Invoice Number and Invoice Data fields directly through DataGridView?
    2) Lets say I have a master-detail form where I am entering data for Invoice. In grid I am entering InvoiceData (Product, Quantity, Price, etc). Can I have this grid bound to InvoiceData, but also displaying some other columns, that will display read-only
    calculated values (like total sum per product, total ammount of tax, etx)?
    Thanks,
    Goran

    DB:2.64:Databinding In Ef af

    Just to clarify things, regarding displaying read-only data, I find that David Peng's suggestion to create a helper class acceptable. But I am unable to find answer how to have editable data displayed in DataGridView, which will contain properties from Reference
    Entity? Example of data that needs to be displayed from two Entities (Product and ProductStore):

    ProductCode ProductName Product.ProductStore.Quantity Product.ProductStore.Price

    DataPropertyName only accepts first level properties of Invoice, and doesnt look into Complex types properties. Can this be done by implementing ITypedList on Invoice collection, and what else needs to be done?

  • RELEVANCY SCORE 2.64

    DB:2.64:Emi/Receivalbe Balance Amount With Respect To Invoice Amount zd



    Hi,

    I have requirement like Invoice total amount and Receipt amount. Every month it has to accumulate the receipt amount and need to tell Open Receivable amount for that particicular month.

    Eg: We have purchased a car and paying EMI every month and need to know the balance of the every month. Need to add the receipt amount of previous months paid and this month paid and tell the total balance against to Total Invoice amount.

    Below is the some rough numbers,I want to plot Line chart for this Open Receivable amount with respect to the Total Invoice Amount with respect to Receipt month. Can you please let me know, how can we achieve this requirement ?

    This is raw data Table:-

    Invoice Date Receipt Date Receipt Amount Open Receivable Invoice Total Amount

    November 12/31/2013 119 2,328 2,447

    November 1/22/2014 120 2,327 2,447

    November 1/31/2014 576 1,871 2,447

    November 0 2,447 2,447

    Sum: 815

    I need in this way :-

    Invoice Date Receipt Date Receipt Amount Open Receivable Invoice Total Amount

    November 12/31/2013 119 2,328 2,447

    November 1/22/2014 120 2,208 2,447

    November 2/31/2014 576 1,632 2,447

    November 0 1,632 2,447

    Sum: 815

    DB:2.64:Emi/Receivalbe Balance Amount With Respect To Invoice Amount zd


    [%] =(Invoice Amount-Receipt Amount)/Invoice Amount*100

    Try with below formula

    =Count([Invoice Number] Where ([%]100) In ([Material group])) .

    Here 100 is to say amount is not paid totally.

  • RELEVANCY SCORE 2.63

    DB:2.63:Bcs - Retrieve Multiple Metadata Fields Simultaneously xa


    Greetings Earthlings and SharePoint Experts. I'd like to know if it is possible to have SharePoint 2010 Enterprise retrieve multiple metadata fields simultaneously from a line of business database when profiling documents. The use case would
    be as follows: user adds invoice content type to a document library and SharePoint requests the invoice number. After receiving the invoice number, SharePoint goes to the LOB DB and grabs the customer number and invoice amount. So the invoice
    document is saved in the document library with 3 metadata fields: invoice number, customer number and invoice amount. But the user only needs to enter the invoice number.
    I suppose this can be done with some custom coding but I'm wondering it can be done through configuration alone.
    Thanks.

    DB:2.63:Bcs - Retrieve Multiple Metadata Fields Simultaneously xa


    If you are talking about a lookup column based on external list. Then yes you can bring in some extra columns.

    Ameet Phadnis (e Tek Global Inc.)

    Indeed you can, I didn't realize. Thanks.

    I am actually doing something very similar, however, my customer has asked if for a completely automated solution that will associate the external SQL database column containting a PO NUMBER with a column that has say a corresponding PO NUMBER. the
    idea is that we can correlate documents uploaded to data in a SQL database on the fly.
    Can this be achieved in Sharepoint designer?

  • RELEVANCY SCORE 2.63

    DB:2.63:Error At Gr da



    We have purchased goods from our foreign vendor in this case we first receive Invoice and than we do GR. But the problem is that at the time of GR the accounts are debited with half of the amount, as we have inducted second Invoice for some additional charges. Therefore, system is taking half of the total amount at GR and also showing total Invoice quantity as double.

    Help me.

    Irfan Ahmed

    DB:2.63:Error At Gr da


    Dear irfan

    in indian scenario custom is treated as vendor and the processing is different you will have to follow the process where you will have to define custom as vendor for pauying the customs dutyand for other prices you can use credit memo or subsequent credit or debit as required.

  • RELEVANCY SCORE 2.63

    DB:2.63:Adding Fields In Edi Output Of Invoice List zd



    Hi!

    I am trying to find out what is a process of adding fields in EDI output of Invoice List...

    I mean that I need to add some extra fields to Invoice lists.

    The information I have is: name of Form, print program and output type.

    I guess I need to modify printing program, is it a correct way to go?

    Hope to avoid modifying of print form...

    Will reward,

    Mindaugas.

    DB:2.63:Adding Fields In Edi Output Of Invoice List zd


    Same structure,then no need to have any user exit,just configure what ever setting required .

    No programming is required and mainly look at WE20 Transaction ( Maintain process control 1 Application V3,Messa type : LR00,Process code )

  • RELEVANCY SCORE 2.63

    DB:2.63:Multiple Invoice Creation 3c



    Hi All,

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

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

    Thanks

    Amit

    DB:2.63:Multiple Invoice Creation 3c


    Hi All,

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

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

    Thanks

    Amit

  • RELEVANCY SCORE 2.63

    DB:2.63:Freight Breakup Of A/R Document In Pld z7



    I need Freight Breakup of A/R Document in PLD.

    I have created multiple freight seeting in the the Freight Setup.

    When Adding these values in A/R Invoice I need the breakup in PLD

    Please help.

    DB:2.63:Freight Breakup Of A/R Document In Pld z7


    Dear Aslam,

    Even I had tested this query in 2005 Version and this query is 100% correct.

    Probably if you have 2007 Version already installed so you could check in that. As there could be difference of the fields naming in both versions.

    You can get the field naming via View- System Information.

    Hope this would help.

    Regards,

    Gagan Thareja

    SAP Business One Forums Team

    Edited by: Gagan Thareja on Apr 13, 2009 5:23 PM

  • RELEVANCY SCORE 2.63

    DB:2.63:Sap Sq02 Infoset Coding - Duplicates And Summing Field For Each. ak



    Hi,

    I am having trouble figuring out where to start/how to get the correct output. I am very new to abap coding. I am trying to create an infoset query and need to do a bit of coding in SQ02.

    I have two tables joined - one being RBKP as the *header for Invoice Receipts* the other is RBDRSEG for the *Invoice Document Items*.

    The query needs to run following some irrelevant parameters/variants, but when it does so it needs to - - -

    Look in RBDRSEG for all same Document numbers RBKP-BELNR EQ RBDRSEG-RBLNR

    In doing so RBDRSEG may or may not have multiple line results for each Doc No.

    I need to **total the field RBDRSEG-DMBTR for each Doc No. Result**.

    (If there a 5 lines for a Doc. No.; DMBTR will have a different value for each, this needs to be totaled)

    At this point I need the output to only show (along with other fields in RBKP) **One line with the SUM of the DMBTR field for each Doc. No.**

    I then need to have another field showing the *difference* of the Field RBKP - RMWWR which is the Invoice Total and the Total that was calculated

    earlier for that Doc. No. for field DMBTR.

    IF you could please help, I would incredibly grateful.

    Try to be as specific as possible with your questions/answers.

    Can all this coding be done in Record Processing?

    Thank you!Justin


    DB:2.63:Sap Sq02 Infoset Coding - Duplicates And Summing Field For Each. ak


    Hi,

    I am having trouble figuring out where to start/how to get the correct output. I am very new to abap coding. I am trying to create an infoset query and need to do a bit of coding in SQ02.

    I have two tables joined - one being RBKP as the *header for Invoice Receipts* the other is RBDRSEG for the *Invoice Document Items*.

    The query needs to run following some irrelevant parameters/variants, but when it does so it needs to - - -

    Look in RBDRSEG for all same Document numbers RBKP-BELNR EQ RBDRSEG-RBLNR

    In doing so RBDRSEG may or may not have multiple line results for each Doc No.

    I need to **total the field RBDRSEG-DMBTR for each Doc No. Result**.

    (If there a 5 lines for a Doc. No.; DMBTR will have a different value for each, this needs to be totaled)

    At this point I need the output to only show (along with other fields in RBKP) **One line with the SUM of the DMBTR field for each Doc. No.**

    I then need to have another field showing the *difference* of the Field RBKP - RMWWR which is the Invoice Total and the Total that was calculated

    earlier for that Doc. No. for field DMBTR.

    IF you could please help, I would incredibly grateful.

    Try to be as specific as possible with your questions/answers.

    Can all this coding be done in Record Processing?

    Thank you!Justin


  • RELEVANCY SCORE 2.63

    DB:2.63:Multiple Lines In Same Item 7s



    Hi it there a way to have some dynamic list in an Item.To give an example:Users log into Ess and choose a Catalog item "reprint invoice"then they fill in varibles like, company, location..etc.Now they want to add multiple invoice numbers within the same item, by typing invoice number and date, and then press like "add invoice".all invoices numbers should then create it's own task within the item.hope this is clear enough :-)

    DB:2.63:Multiple Lines In Same Item 7s


    Ok, thanx for the input,the current solutions is very similar to what you guys have done. so i guess i have to file an enhancement request :-)//

  • RELEVANCY SCORE 2.63

    DB:2.63:Adding Up Totals Of Various Documents Or Sheets ds


    this problem must have already been discussed on this board, but i couldn't find any thread that helped me. i'm also a numbers newbie - so please excuse me, if this quesion is stupid.

    i've made an invoice document, simlilar to the invoice template that comes with numbers 08.

    i duplicate an old invoice to write a new one (i could also just duplicate the sheet, so all invoices are in the same document, if that makes it easier).

    now i want a document (or a sheet within an document that contains all invoices) that lists all the sums of the invoices and adds them up. i want a total of all the invoices i create, a total that *automatically updates* when i create a new invoice by duplicating an older invoice.

    thanks.

    DB:2.63:Adding Up Totals Of Various Documents Or Sheets ds

    Look at:

    http://discussions.apple.com/messageview.jspa?messageID=8762210stqc=true

    It's in the Numbers '09 forum but it's in fact a document which works flawlessly in iWork '08.

    Yvan KOENIG (from FRANCE mercredi 7 janvier 2009 21:24:13)

  • RELEVANCY SCORE 2.63

    DB:2.63:Fixing Position In Invoice Report Example zm


    Hi..

    I have a report master/details,invoice_no and invoice_date in Master and price ,items and cost in details.

    How can I fixed the Invoice total at the buttom of Invoice paper??because every time the no of items per invoice insrease according to the invoice.So every time the invoice total not stay in same position.

    what Can I do ti fix this total regarding to no of items???

    DB:2.63:Fixing Position In Invoice Report Example zm

    Hi..

    I have a report master/details,invoice_no and invoice_date in Master and price ,items and cost in details.

    How can I fixed the Invoice total at the buttom of Invoice paper??because every time the no of items per invoice insrease according to the invoice.So every time the invoice total not stay in same position.

    what Can I do ti fix this total regarding to no of items???

  • RELEVANCY SCORE 2.63

    DB:2.63:Problem In The Creation Of 2nd Invoice za



    Hello Friend,

    Process:-

    We are facing problem at the time creation of 2nd invoice, we are doing following process

    1 ) Create multiple Sales Order with multiple Item (T-code :-VA01)

    2 ) Create multiple Delivery with reference to multiple Sales Order (T-code :-VL01N)

    3 ) Create Single Shipment Document with single Transporter against multiple deliveries and multiple routes (T-code :-VT01N)

    4 ) Create Single Shipment Cost Document against single Shipment Doc. (T-code :-VI01)

    5 ) Crete Individual billing document with reference to Delivery (T-code :-VF01)

    Issue:-

    Same Condition type of fright is triggering twice in 2nd Invoice which should be trigger 2nd condition record for2nd delivery in 2nd Invoice

    For eg:-

    Eg 1:-

    Eg 2:-
    Invoice Document
    A
    B
    C

    Let Say,

    Pricing of Invoice of A
    Invoice A
    Amt
    Per
    Unit
    Condition Value
    Basic Price
    100
    1
    EA
    100
    Fright
    20
    1
    EA
    20
    Total
    120

    120
    tax 5 %
    6
    1
    EA
    6
    Net amt
    126


    126

    Pricing for Invoice B
    Invoice B
    Amt
    Per
    Unit
    Condition Value

    Basic Price
    125
    1
    EA
    125

    Fright
    30
    1
    EA
    30

    Fright
    20
    1
    EA
    20

    (Condition Record of 1st Invoice)
    Total
    175

    175

    tax 5 %
    8.751
    EA
    8.75
    Net amt
    184

    184

    I have maintain Condition record with the combination of Transportation planning point+Shipment Type+forwarding agent+shipping point+material grp

    I have maintain Condition class B in Condition type for fright

    Please help us to solve this issue, for better understanding if require I can share the process with screen shot also.

    DB:2.63:Problem In The Creation Of 2nd Invoice za


    Clearly from your Item - Condition - Detail, the pricing source is F - Shipment Cost(Check VTFL - Item - Pricing Source). It will better, if you can control this at shipment level. As actual shipment costs will be based costing in shipment for settlement and accordingly that is billed. Correct?

    Why suggested pricing update. If either of the departure zone is not maintained, the system will redetermine pricing accordingly.

    In addition to that, please check what is your Pricing type maintain copying Control for Delv to Billing(TCode VTFL). Hope you have suitable one assigned there.

    Thanks, JP

  • RELEVANCY SCORE 2.63

    DB:2.63:System Is Allowing Invoice For Total Quantity Of P.O 1j



    Hi,

    We are creating Invoice with respect to P.O. System is allowing multiple time invoice for same P.O.

    e.g we have a P.O with 3 Line item.

    Mat 1 Qty 10,toal Value 100

    Mat2 Qty 15, total Value 150

    Mat3 Qty 20 Total value 200

    When I am creating Invoice for the P.O , 1st time one invoice is created for all items.

    Again I am posting the same P.O, it is allowing me to post , there is no message, only system is blocking the payment.

    However, if I am going for line item let say 20 for 2nd time it is not allowing to post.

    Can any body suggest the tolerance limit to use or message no. to be taken care of, for total P.O qty to total invoice qty.

    Regards

    Sunami

    Edited by: sunami on Nov 23, 2011 2:49 PM

    DB:2.63:System Is Allowing Invoice For Total Quantity Of P.O 1j


    Hi,

    Goto-----Use T.Code:OMRM maintain the message M8 -081 as error,Quantities invoiced greater than goods receipt quantity...

    Maintain the message as Error msg.......and check it out.

  • RELEVANCY SCORE 2.63

    DB:2.63:Create Invoice Automatically - Get Invoice Total Before Invoice Is Created kz



    Greetings all!

    I'm using SAP B1 2005A and I have a code that automatically creates A/R invoices based on delivery notes. Is there a way to get the invoice total before the invoice is added to the company database? The problem is I do not include all items from a processed delivery when creating an invoice so I cannot use the delivery total in this case.

    Regards, Yavor

    DB:2.63:Create Invoice Automatically - Get Invoice Total Before Invoice Is Created kz


    Hi Winfried!

    Thanks for the answer - will try to use the draft though i must remove it after I'm done with it for I wouldn't unnecessary drafts to pile up.

    Regards, Yavor

    PS: I think that ODLN.PaidToDate field should do just fine. It seems that ODLN.DocTotal - ODLN.PaidToDate returns the sum that is not yet processed in the corresponding delivery.

    Edited by: Yavor Naumov on Nov 25, 2008 7:46 PM

  • RELEVANCY SCORE 2.63

    DB:2.63:Reduce Vendor Invoice In Total z9



    Dear all,

    If i have invoice with many line items in MIRO T,Codes, now supplier invoice came with less amount and i would like to reduce my invoice amount at MIRO before posting, so i need to go to each line items and reduce some amount from each line items, is any way i could do that without referring to each line items, i mean in total.

    DB:2.63:Reduce Vendor Invoice In Total z9


    check out whether the following link is useful

    http://help.sap.com/saphelp_46c/helpdata/en/a8/b99284452b11d189430000e829fbbd/content.htm

  • RELEVANCY SCORE 2.62

    DB:2.62:Invoice Entry 8x


    As I wrote in summary , want to enter Invoice and have stock
    entered!
    I created tables like
    1)Invoice
    2)Supplier
    3)Merchandise
    As I have Invoice in my hand, would start
    is supplier in database If yes have all information and
    contact on head like invoice looks.
    than enter invoice # with purchase date and total amount.
    Now I want to start entering invoice details
    Item #, Categories.. and individual price (calculated with
    Qty And Unit price)
    And have my stock entered.
    I am learning Coldfusion and try to fulfill this application
    but I need some help if some one can give me some layout idea like
    Start using session variables , query Like cfquery name=
    getstock datasource="xy"
    Select Supplier.SupplierName, Supplier.Contact,
    Invoive.InvoiceNumber, Invoice.InvoiceDate
    From Supplier, Invoice
    Whrer Supplier.SupplierID = Invoice.SupplierID
    /Cfquery
    I need step by step general Idea.
    Will u please inspire me to learn coldfusion?

    DB:2.62:Invoice Entry 8x

    As I wrote in summary , want to enter Invoice and have stock
    entered!
    I created tables like
    1)Invoice
    2)Supplier
    3)Merchandise
    As I have Invoice in my hand, would start
    is supplier in database If yes have all information and
    contact on head like invoice looks.
    than enter invoice # with purchase date and total amount.
    Now I want to start entering invoice details
    Item #, Categories.. and individual price (calculated with
    Qty And Unit price)
    And have my stock entered.
    I am learning Coldfusion and try to fulfill this application
    but I need some help if some one can give me some layout idea like
    Start using session variables , query Like cfquery name=
    getstock datasource="xy"
    Select Supplier.SupplierName, Supplier.Contact,
    Invoive.InvoiceNumber, Invoice.InvoiceDate
    From Supplier, Invoice
    Whrer Supplier.SupplierID = Invoice.SupplierID
    /Cfquery
    I need step by step general Idea.
    Will u please inspire me to learn coldfusion?