• RELEVANCY SCORE 4.05

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





    Hi all

    i am creating customer invoice through t-code FB70.

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

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

    The multiple approvers are approved based on amount.

    Regards

    Mahesh

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


    Hello,

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

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

    regards

    Rick Bakker / hanabi technology

  • RELEVANCY SCORE 3.50

    DB:3.50:Account Payable Invoice Creation dz




    Hi All,

    I just want to know the Account Payable Invoice creation screen.

    How many data hit by invoice screen for master table

    AP_INVOICE_ALL

    specially invoice_date and gl_date column.

    Please help.

    Regards

    DB:3.50:Account Payable Invoice Creation dz

    Hi All,

    I just want to know the Account Payable Invoice creation screen.

    How many data hit by invoice screen for master table

    AP_INVOICE_ALL

    specially invoice_date and gl_date column.

    Please help.

    Regards

  • RELEVANCY SCORE 3.40

    DB:3.40:Automatic Creation Of Invoice And Excise Invoice? kj





    Hi Gurus,

    my Customer system if i Do Shipment The system is Automatically creating Post Good Issue and Invoice and excise Invoices (J1IIN) automatically.

    Can any one tell me where could be the automatic settings? and how they had done? as i have limited access to system

    Thx

    Seegal

  • RELEVANCY SCORE 3.35

    DB:3.35:Idod Type,Message Type,Inbound Function,Process Code Required 98



    Dear All,

    I require

    1. IDoc Type

    2. Message Type

    3. Inbound Function

    4. Process Code

    for

    a. Vendor Master Creation,Updation,Deletion

    b. Customer Master Creation,Updation,Deletion

    c. Vendor Invoice(TCode-FB60) Creation,Updation,Creation

    d. Vendor Credit Memo(Tcode-FB65) Creation,Updation,Creation

    e. Customer Invoice(TCode-FB70) Creation,Updation,Creation

    f. Customer Credit Memo(TCode-FB75) Creation,Updation,Creation

    i require to insert all the above detail into SAP from another system so please provide me the full detail.if the IDoc type is separate for Creation Updation Deletion then provide likewise.

    Everybody will rewarded.

    Thanks,

    RP

    DB:3.35:Idod Type,Message Type,Inbound Function,Process Code Required 98


    best thing is goto r3 and execute the tcode we60. from there have a f4 help and this takes u the screen having list of idocs. u may select from there or thru application heirarchy level also

  • RELEVANCY SCORE 3.33

    DB:3.33:Error:Invoice And Receipt Must Be Paid Exactly 9j



    Hi

    I m receiving an error while adding A/R invoice

    Invoice and receipt must be paid exactly[message 131-45]

    and pop up window of payment is opened.I want to pay to customer only after adding sales invoice not before adding.

    How to get rid of it?

    DB:3.33:Error:Invoice And Receipt Must Be Paid Exactly 9j


    Hi !

    Please raise a spreate Msg. This is wht forum rule. SomeOther Contributors also help us to solve the things.

    Pl close this thread !!

  • RELEVANCY SCORE 3.31

    DB:3.31:Invoice Details z8



    Hi,

    How to see teh Incoming Invoice data that is posted using BAPI_INCOMINGINVOICE_CREATE

    DB:3.31:Invoice Details z8


    Hi,

    Do you want to see the posted invoice or the data while invoice is being posted.

    If you want to see the data while invoice is being posted, find out the program which is doing this, put a break-point at function module BAPI_INCOMINGINVOICE_CREATE and see the data being passed to BAPI.

    If you want to see the data of invoice being posted using this BAPI, then take the invoice number and fiscal year from BAPI return message and look for the document in transaction MIR4.

    If you have invoice number and fiscal year, you can also check tables RBKP ( header data ), RSEG ( line iteam data ) and RBCO ( account assignment data )

    Give some more detail like so i can answer your question properly

    Regards,

    RS

  • RELEVANCY SCORE 3.25

    DB:3.25:Load A Report Like An Invoice 8a


    I am new to visual basic language. How do you go about coding a report to load data from my invoice screen so that the customer has an invoice.

    Mick

    DB:3.25:Load A Report Like An Invoice 8a

    Hi Mick,
    Welcome to the MSDN Forum.
    load data from my invoice screen
    Do you mean that the report can read the data on a screen rather than a data file like database or XML and so on?
    Do you want to send the invoice data to your customer or send a compeleted invoice? Generally, you can send the invoice data to your customers and let themself to print it by themself invoice styles.
    Please note, if you want your application can recognized the information on a non-related screen, it should be Intelligent Recognition issue.
    If I have misunderstood anything, please feel free to let me know.
    Best regards,Mike Feng [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

  • RELEVANCY SCORE 3.23

    DB:3.23:Different Pricing Date At Item Level In Invoice Correction Request jj



    Hi Experts,

    I am facing invoice split issue for invoice correction request where both credit and debit line items have different pricing date. Due to this different exchange rates are being picked up which then splitting the invoice. To resolve this i want to make pricing date same for both the line items. Credit item has pricing date of original customer invoice with reference to which the invoice correction request is generated. Debit item has pricing date of creation date of invoice correction request which is wrong and i want to change this to pricing date of original customer invoice . Please let me know how can i achieve this with standard customization.

    Thanks !

    DB:3.23:Different Pricing Date At Item Level In Invoice Correction Request jj


    Dear sandeep pl explaint your question a little bit more

    because i want to know then i can understand menters answers also

  • RELEVANCY SCORE 3.23

    DB:3.23:Invoice Approval Process z3


    Dear All,

    The Customer requirement is using the AME process to get Invoice Approved between two employees.
    One employee is Requester another employee is Approver If the Requester creates invoice more than 150 amount that invoice needs to get approved by approver.

    Kindly advice me on this as to how should I approve this invoice through AME Process.

    Regards,

    Younus

    DB:3.23:Invoice Approval Process z3

    Dear thanks for the reply but it doesn't help me alot.
    Kindly send me some setup document where I should match the steps with your document.

    Thanks,
    Younus

  • RELEVANCY SCORE 3.21

    DB:3.21:Creation Of Query Base On Quarters 1s



    Hi

    we have to create a query which shows sales of customer for last four quarters.

    can you pls tel me how to get the data for last four quarters

    DB:3.21:Creation Of Query Base On Quarters 1s


    Insrt the amount Key figure four time in your report, restrict each of them with Current CAL Quarter and with offset as 0, -1, -2, -3 in each of them.

  • RELEVANCY SCORE 3.18

    DB:3.18:Customer Invoice 93



    hai to all

    can anybody tell me how to view the customer invoice in sap

    thanks in advance

    DB:3.18:Customer Invoice 93


    Hi,

    T.Code: VF03

    Normally the FI Document number is same as Invoice Number.

    Assign points, if helpful.

    Regards,

    Harish

  • RELEVANCY SCORE 3.18

    DB:3.18:Customer Subscreen Vf02 jc



    Hi,

    Is there a possibility to add a customer subscreen during the creation of an invoice (vf01/vf02) in order to add some additional fields ?

    thx,

    Serge

    DB:3.18:Customer Subscreen Vf02 jc


    NO IT'S not possible

    because for vf01 no scrn exit available

  • RELEVANCY SCORE 3.16

    DB:3.16:Customer Account Statement To Payer m3



    Dear all,

    How do I get the account statement of a customer to be sent to the partner function Payer defined in the customer master data (not to the Sold-to-party), i.e. send the account statement to the same adress as the receiver of the invoice?

    Best regards

    M

    DB:3.16:Customer Account Statement To Payer m3


    Or do I need congifuration to solve this problem?

  • RELEVANCY SCORE 3.16

    DB:3.16:Direct Sales Scenario Configration In Sap.... 3d



    Dear Friends

    The scenario from the customer is like this:

    1) End user orders directly on Supplier. Customer will not know about this order

    2) Supplier supplies the product to the end user.

    3) Then sends the Invoice to Customer. Customer will know about the transaction only when they get this invoice from supplier.

    4) Customer does not maintain any data of the above transaction. They just make Direct Sales Invoice to End user based on the Supplier Invoice details.

    5) While creating Direct Sales Invoice, they enter both nd user details and Supplier details along with product details in the same screen.

    How can we configuare this scenario in SAP??

    Pls note we can not user Third party sales as there is not sale order craetion nor customer wants to create the sale order...

    Rgds

    Anis

    DB:3.16:Direct Sales Scenario Configration In Sap.... 3d


    Hi I understand what you mean... I have the same situation ) but order should be created ... It is a way, that the order is created automatically with a job, batch or web services, and then they can create the invoice manually or whatever they like...

    Br

    Saso

    p.s Just a brain storming

  • RELEVANCY SCORE 3.15

    DB:3.15:Which Table Show Customer Creation Data ? pp



    hello

    I need to find table

    to list all customers with date of creation in our SAP

    thx

    DB:3.15:Which Table Show Customer Creation Data ? pp


    Dear Nevargu

    Go to SE16 and give table KNA1 where there is a field "Created on" (Field name ERDAT).

    thanks

    G. Lakshmipathi

  • RELEVANCY SCORE 3.14

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



    Hi

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

    regards,

    K.S.Rao

  • RELEVANCY SCORE 3.14

    DB:3.14:Customer Account Statement To Payer 91



    Dear all,

    How do I get the account statement of a customer to be sent to the partner function Payer defined in the customer master data (not to the Sold-to-party), i.e. send the account statement to the same adress as the receiver of the invoice?

    Best regards

    M

    DB:3.14:Customer Account Statement To Payer 91


    Hi

    In the customer master correspondence tab, there are Customer user, Act.clk tel.n, Clerk's fax ,Clrk's internet. update these fields and try once. it will work.

    with regards

    Siva

  • RELEVANCY SCORE 3.11

    DB:3.11:Onetime Customer Table ks



    Hi All

    I have a one time ship to party

    During creation of sales order one time ship to party address will be filled

    During print out of Delivery document and Invoice document one time address is not appearing delivery and invoice output

    Please suggest the logic to get one time customer address and also the table where it gets stored

    DB:3.11:Onetime Customer Table ks


    You need to fetch the address from LIKP-KUNNR, now your output must be showing address from KNA1. Take address number from VBPA with partner function WE, then put that adress number in ADR6 to get the details of address

  • RELEVANCY SCORE 3.10

    DB:3.10:Random Data 3m



    Can someone post a script to generate random sales data in qlikview...

    What i need is

    Customer Name,

    Invoice Date

    Invoice Value

    Invoice Number.....etc

    DB:3.10:Random Data 3m


    Just replace the factor for RAND() function with the number of days in your interval:

    Date(makedate(2012,1,1)+floor(RAND()*(makedate(2013,12,31)-makedate(2012,1,1)+1))) as InvoiceDate,

  • RELEVANCY SCORE 3.09

    DB:3.09:Invoice For A Sales Order 3m



    Hi all ,

    How do i generate invoice for a sales order to a customer ?

    Thanks,

    Avani.

    DB:3.09:Invoice For A Sales Order 3m


    hi

    when generating billing type for you client copy from F1(order related billing) .check copy controls from order to billing. and then thru' tr.VF01 selecting f1 or ur document type u can generate order related invoice.

    regards

    mandar

  • RELEVANCY SCORE 3.09

    DB:3.09:Clear The Ar Invoice For The Customer Using F-30. Which Bapi Will Be Used And How? 7k



    I have a requirement where we need to clear the AR invoice for the customer in F-30 (transfer posting with clearing). Data will be received in csv format.

    Please suggest which BAPI to use and how?

    DB:3.09:Clear The Ar Invoice For The Customer Using F-30. Which Bapi Will Be Used And How? 7k


    I have a requirement where we need to clear the AR invoice for the customer in F-30 (transfer posting with clearing). Data will be received in csv format.

    Please suggest which BAPI to use and how?

  • RELEVANCY SCORE 3.09

    DB:3.09:Invoice List Assignment k7



    After creating invoice list, to what it is assigned ? Is the customer master data ? Where exacly..... ?

    DB:3.09:Invoice List Assignment k7


    Hi Sunil,

    Exactly Cutomer master.

    Sales area data -- BIlling documents invoice list dates

    Reward points pls.

    REgards,

    Govind.

  • RELEVANCY SCORE 3.08

    DB:3.08:Rank And P() ma



    Hi,

    I want to calculate the retention rate of the top 30% spending customer. As the 30% is base on a dynamic selection of the date period so I have to use the rank function and can't calculate it during the data load.

    This is how I can calculate the retention rate, a customer is retained if he purchase in 13 to 24 period and repurchase in 0 to 12 period. This is what I can do,

    =count(DISTINCT

    {[Month ID]={'=$(vRetentionXEnd)=$(vRetentionXStart)'}, [Invoice VIP Main No]=p({[Month ID]={'=$(vRetentionYEnd)=$(vRetentionYStart)'}}[Invoice VIP Main No])

    I can get the top 30% VIP customer base on this Rank function,

    =Count(DISTINCT [Invoice VIP Main No]={=rank(sum([Invoice Net Amount in HKD]),[Invoice VIP Main No])=$(vFormularDistinctVIP)*0.3'}}[Invoice VIP Main No]}[Invoice VIP Main No])

    The point is how can I put these two conditions together?

    DB:3.08:Rank And P() ma


    Yes, probably. The first expression you posted is incomplete.

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Retrieve Sales Rep Name Tagged To Ar Invoice In A Query. 97



    Hi,

    We need to display the sales person name which is tagged to the AR Invoice for our internal sales commission tracking.

    The problem here is if we use OSLP table to get this information the data retrived is the Sales rep name as seen in the BP data.

    In our scenario, even though a slaes rep is linked to a particular customer, sales person are given incentives based on the Products sold hence for certain brand the sales employee for that Invoice is allowed to change.

    When we create a query to list invoices and payments against the invoice we are not able to display the sales rep name that is tagged to the Invoice.

    Is there a way to display the sale persons name in a query using 'CASE' statement?

    or is there wany other way out.

    Please advise.

    Regards

  • RELEVANCY SCORE 3.08

    DB:3.08:How To Restrict Excise Invoice Of Cancelled Proforma Invoice? da



    How to Restrict Excise invoice of cancelled Proforma Invoice?

    I have cancelled (Completed ) Proforma invoice and now I want to restrict creation of excise invoice

    DB:3.08:How To Restrict Excise Invoice Of Cancelled Proforma Invoice? da


    Try with J_1I7_USEREXIT_EXCISE_BEF_SAV

    thanks

    G. Lakshmipathi

  • RELEVANCY SCORE 3.07

    DB:3.07:Udf From Ar Invoice In Customer Statement Report s9



    Can I display a UDF from AR Invoice in Customer Statement Report? The customer has a UDF at the title level they want to display on the row of the Customer Statement for each invoice. How do i edit the data that prints at the row level for each invoice number?

    DB:3.07:Udf From Ar Invoice In Customer Statement Report s9


    Customer Statement Report is hard coded PLD. You don't have any option to edit it. Only Query PLD or Crystal Report might be used to produce the report with those UDFs as you wish.

    Thanks,

    Gordon

  • RELEVANCY SCORE 3.07

    DB:3.07:Export Indicator In The Billing Invoice Header ak



    How does the Export Indicator field gets populated in the billing invoice doc. (from what specific source)? I have an invoice where the accounting doc. didnu2019t generate ... it referenced 'foreign trade data incomplete', yet both are for DOMESTIC customers. In the header for the invoice the Export Indicator was marked w/ an u2018Xu2019. I'm trying to determine how that field could get populated since the invoice for domestic customer (where would it be pulling from)?

    DB:3.07:Export Indicator In The Billing Invoice Header ak


    How does the Export Indicator field gets populated in the billing invoice doc. (from what specific source)? I have an invoice where the accounting doc. didnu2019t generate ... it referenced 'foreign trade data incomplete', yet both are for DOMESTIC customers. In the header for the invoice the Export Indicator was marked w/ an u2018Xu2019. I'm trying to determine how that field could get populated since the invoice for domestic customer (where would it be pulling from)?

  • RELEVANCY SCORE 3.05

    DB:3.05:Customer Creation s8


    dear,

    how to enable customer creation at the time of creating a sales order.

    regards

    imran

  • RELEVANCY SCORE 3.04

    DB:3.04:The House Bank In A Customer Invoice Posted By Fb70 3z



    Hi All,

    Could anyone tell me how to obtain a certain house bank in a customer invoice posted by FB70?

    I've made a test. I've filled an house bank into the master data of the customer (company data). Then, I've posted the invoice by FB70. I expected finding it in the item.... instead it wasn't there...

    Cuold anyone help me?

    Thanks

    Gandalf

  • RELEVANCY SCORE 3.04

    DB:3.04:How To Compare Data In A Table? ak



    Hi,

    I have one table that holds data of invoices. I want to test if I have duplicate invoices. A duplicate invoice is an invoice with the same invoice number, customer name, invoice date and invoice amount.

    Do you have any idea how I could build up this test an generate a table with these duplicate invoices?

    Thanks in advance!

    Kind regards,

    Jens

    DB:3.04:How To Compare Data In A Table? ak


    Thanks a lot this indeed solved my problem!

    Kind regards,

    Jens

  • RELEVANCY SCORE 3.04

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


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

    InvoiceID

    Invoice Heading

    User

    Desc

    Category

    AccountID

    Amount

    1

    Invoice Changes1

    Robert

    Invoice at JPM

    Personal

    1

    1.00

    1

    Invoice Changes1

    Robert

    Invoice at JPM

    Personal

    2

    2.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    1

    3.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    3

    4.00

    2

    Invoice Changes2

    Robert

    Invoice as check

    Savings

    4

    5.00

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

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

    Account

    Amount

    1

    $1.00

    2

    $2.00

    Audit Details:
    Creation Date:
    Created By

    Page footer Here


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

    Account

    Amount

    1

    $3.00

    3

    $4.00

    4

    $5/-

    Audit Details:
    Creation Date:
    Created By

    Page footer Here


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

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

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

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

  • RELEVANCY SCORE 3.04

    DB:3.04:Layout Of Customer Invoice In Sd cp



    Dear Gurus,

    I have few questions regarding the output control and invoice layout.

    1- I have configured the output control but when i go to print the invoice, system shows that there is no data.

    2- How to change the layout of invoice?

    3- where to assign the that layout to get invoice in that format?

    Please suggest me

    regards

    Ashutosh

    DB:3.04:Layout Of Customer Invoice In Sd cp


    Hi,

    Create a new smartform by using the T.Code SMARTFORMS and assign this one to your output type in NACE.

    If required write a new program and assign this one to your output type in NACE.

    ABAP team is going to help you out in these.

    Regards,

    Krishna.

  • RELEVANCY SCORE 3.04

    DB:3.04:How To Get The Mail Statuses When An Issue Output Of Invoice Is Done. m3



    Hi,

    1. I want to get the mail statuses of the invoice mail sent to a customer.

    2. In which table the log will be stored ?

    3. How to get the link for the billing document for which the mail was sent to the customer ?

  • RELEVANCY SCORE 3.03

    DB:3.03:Fms Query On A/R Invoice 7z



    hi experts,

    I was looking for some help on how to create the query to pull data from BP contact UDF (U_AR) to display in a UDF on an AR invoice for that customer (U_ARCON). Basically we are looking to populate how the invoice is to be recieved by customer (Email, Fax, Mail) when an invoice is created so the right method of delivery is choosen for that customer.

    gord

    DB:3.03:Fms Query On A/R Invoice 7z


    This query can not run directly. You have to assign it on the UDF.

    Updated to use BP Contact table.

    SELECT T0.U_AR FROM dbo.OCPR T0

    WHERE T0.CardCode = $[$4.0.0\]

  • RELEVANCY SCORE 3.03

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



    Hi sap guru's

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

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

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

    if there, how?

    Thanks in advance

    venu

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


    Hi,

    Check this -

    Go to FD10N - Customer Line item display

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

    Goto Environment Mass Change New Values

    Give the payment terms

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

    Regards,

    Sridevi

    Message was edited by:

    Sridevi

  • RELEVANCY SCORE 3.03

    DB:3.03:Auto Mailer To Customer mm


    Hi all,i have an requirement in CRM-ISA where i need to send an auto mail to the customer (who made order) after Invoice creation. This invoice is made in R/3. Can any one tell me how to get the status of the Order at Item level whether it has been Invoiced or NOT.regards,Kishore

  • RELEVANCY SCORE 3.02

    DB:3.02:Idod Type,Message Type,Inbound Function,Process Code Required ma



    Dear All,

    I require

    1. IDoc Type

    2. Message Type

    3. Inbound Function

    4. Process Code

    for

    a. Vendor Master Creation,Updation,Deletion

    b. Customer Master Creation,Updation,Deletion

    c. Vendor Invoice(TCode-FB60) Creation,Updation,Creation

    d. Vendor Credit Memo(Tcode-FB65) Creation,Updation,Creation

    e. Customer Invoice(TCode-FB70) Creation,Updation,Creation

    f. Customer Credit Memo(TCode-FB75) Creation,Updation,Creation

    i require to insert all the above detail into SAP from another system so please provide me the full detail.if the IDoc type is separate for Creation Updation Deletion then provide likewise.

    Everybody will rewarded.

    Thanks,

    RP

    DB:3.02:Idod Type,Message Type,Inbound Function,Process Code Required ma


    hi

    use t code wedi and goto EDI administration menu. in that goto development menu. there you can find all items like Idoc type, message type or process code all information is available. You can also use t code WE30,WE31,WE80,WE81, WE42 - Inbound process code and WE41 Outbound process code.

    Hope this helps. Assign points if useful.

    Rago

  • RELEVANCY SCORE 3.02

    DB:3.02:Billing Non-Customers In Field Service Debrief pc


    Hi All,

    In the field service process, we bill the customer via debrief and submitting charges i.e. data flows from Service to OM to Invoice creation.

    Can we enter debrief and bill some third party?

    In my case, service guy goes to a customers house who bought Thoshiba laptop from bestbuy....so after the laptop is fixed, the customer should not be billed, thoshiba should be billed as per the terms and agreement. How can I do that?

    Alex.

    DB:3.02:Billing Non-Customers In Field Service Debrief pc

    Hi Nagamohan,

    Can I create an SR and under the charges tab - change the bill-to - and bill Toshiba. Basically, under the charges tab, can we change bill-to and invoice someone other than the customer?

    Alex

  • RELEVANCY SCORE 3.01

    DB:3.01:Cancel Excise Invoice Only Before 24hrs Of Creation Time. z1



    Hi Gurus.

    System should allow to cancel excise invoice only beforel 24hours of creation of invoice.

    ie. Excise invoice created on 05-03-2010 at 0.01am then system should allow to cancel excise ivoice only before 06-03-2010 0.01am

    how to achieve this?

    reg,

    Amol

    DB:3.01:Cancel Excise Invoice Only Before 24hrs Of Creation Time. z1


    Hi Gurus.

    System should allow to cancel excise invoice only beforel 24hours of creation of invoice.

    ie. Excise invoice created on 05-03-2010 at 0.01am then system should allow to cancel excise ivoice only before 06-03-2010 0.01am

    how to achieve this?

    reg,

    Amol

  • RELEVANCY SCORE 3.00

    DB:3.00:How To Create Idocs For Existing Records m7



    Hi

    are there any standard program by which i could create and send the existing customer invoice (VF01) data thru EDI idoc to a 3rd party system even if the output type is not defined during the creation of the invoices?

    Regards

    Sujai

    DB:3.00:How To Create Idocs For Existing Records m7


    setup your message type, then do VF02 and add it manually.

  • RELEVANCY SCORE 2.99

    DB:2.99:Display Currency 91


    Hi GurusMy company code is in Euro,Customer is in USD,Customer Invoice in JPY.Now the thing is when we display in FB03,When clicking Display currency EURO USD get display but customer invoice dint get display(think its suppressed)Tel me how to rectify thatRegardsManoja

    DB:2.99:Display Currency 91

    Did you enter the customer invoice in your system in JPY? If yes, choose 'Document currency' radio button after you click on Display Currency button in FB03. If you have not entered the document in JPY, you cannot see JPY amount in FB03. Your assumption that something is suppressed is not correct.

  • RELEVANCY SCORE 2.99

    DB:2.99:Zf2 Invoice Creation For Down Payment Order 19



    Dear All ,

    Kindly give me your inputs on the following issue .

    1. Sales order - ZOR with net value of 1500.00 with material Item cat - TAO- Milestone-Bill.Plan. In item data billing plan tab , i have maintained Rs 500 as down payment , for billing doc type - FAZ with Rule in billing plan/invoice plan "05" and Date description"0009-Down payment".

    In 2nd line i have maintained values for ZF2 customer invoice with Rule in billing plan/invoice plan "05" and Date description"0008-Closing Invoice". with billing block "02" and fpr value RS1000.00

    2. I have created FAZ invoice for Rs 500 and posted the same in F-29 and posted the document .

    3. I have created delivery and completed PGI for the same

    4. Removed the billing block and tried to create ZF2 customer invoice , the invoice is created with "ZERO" value .

    Also tried by changing by Rule in billing plan/invoice plan "03" and Date description"0008-Closing Invoice". with billing block "02" and for value RS1500.00. In this case the invoice is created for Rs 1500.00.

    As per SAP Std , while creating ZF2 invoice . TWO line items should created

    1. for Rs 500 and another for Rs 1000.00

    Note : I have not changed any configuration settings and am using the same SAP settings .

    Kindly help me on this issues with your valuable inputs as i need to deliver the same today .

    Thanks in advance for all your help.

    Regards

    Veera

    DB:2.99:Zf2 Invoice Creation For Down Payment Order 19


    Hi Veera

    Please go through the following links which will help you to solve your problem

    http://www.sap-img.com/financial/how-down-payments-are-configured.htm

    DOWN PAYMENT REQUEST

    Please check for condition type AZWR which is down payment settlement , it has requirement as 2 and calc type as 48 acct key as ERL

    Regards

    Srinath

  • RELEVANCY SCORE 2.99

    DB:2.99:Edit The Invoiced Qty After Creation aa



    Hi All Friends

    I have one senario where i create the invoice with the reference of sales order where i have two requirement.

    1. i must able to invoice more then ordered quantity.

    2. after invoice i must edit the quantity (this invoice will not be released to accounts untill I get final confirmation to customer)

    Please respond me ASAP

    Regards

    Shambhu

  • RELEVANCY SCORE 2.99

    DB:2.99:How To Relate Invoice Creation Date And Po Creation Date xj



    Hi,

    I want to relate Invoice Creation Date and PO Creation Date. Can any one suggest on this.

    Thanks,

    Arvind

    DB:2.99:How To Relate Invoice Creation Date And Po Creation Date xj


    use table EKBE. the PO history category BEWTP is 'Q' for invoice document

    and column BUDAT will give you creation date of invoice. Creation date of PO can be taken from EKKO -AEDAT.

  • RELEVANCY SCORE 2.99

    DB:2.99:Double Invoice Check For Customer Invoice xa


    hello,can someone suggest as to how this can be acheived?I know we can do it for vendors, but for customer invoice, where is the check?Regards,Jay

  • RELEVANCY SCORE 2.99

    DB:2.99:How To Get Next Customer Invoice Id From Database ? c7


    Hello,
    How i can get an invoice id for my POS next Customer each time i submit my order. I have a field name ID in SQL that is auto increment. But it is generating
    on the time of submission of database while i need Invoice id on POS on completion of previous customer.
    Thanks

    Jazaib Hussain

    DB:2.99:How To Get Next Customer Invoice Id From Database ? c7

    Hello ,
    I would suggest you to have a look at
    http://msdn.microsoft.com/en-us/library/ms175098(v=sql.105).aspx
    But , before to use it , you must read and understand the whole Remarks part.
    The main question is : how many people are creating new InvoiceId at the same time ? If only one, usually no problem except when an INSERT is failing

    Failed statements and transactions can change the current identity for a table and create gaps in the identity column values. The identity value is never rolled back even though the transaction that tried to insert the value into the table is not committed
    But if several people can create orders at the same time, you will have problems : another person can create a new order before you and the value you have stored will be false.
    As your question is more related to Transact-SQL than SQL Server Data Access, I propose you that a moderator moves your thread towards the Transact-SQL forum ( before doing the move , I prefer to wait for the agreement of the original poster ). No thread
    to recreate , no thread let dying in the bad forum, no lost posts with a move by a moderator.
    Have a nice day
    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

  • RELEVANCY SCORE 2.99

    DB:2.99:Help Needed In Message Control - Very Urgent 88



    Hi Experts,

    I have one requirement where in the customer wants to stop creation of IDOC which posts Invoice using message control and message control status should be changed to RED color and also the message should be populated in the processing log saying 'IDOC processing failed, External customer numbers not maintained'.

    Could you please let me know any user exits or customer exits available for this purpose.

    I have searched all the possibilities.

    I have chanked the program RSNAST00 which picks up the data from table NAST and looks into table TNAPR to get the processing porgram for th selected output and also this program checks the partner profile and gets the process code which creates an inoice IDOC. I searched for user exits and customer exits to popolate the required messages and stop IDOC creation.

    I am an ABAPER and i know i need to write code to do validation, but could not find the exact place where to write? I any ABAPERS looking at this post, please reply me.

    Can anyone please advise me how to go about solving this issue?

    Thanks

    Srinath

    DB:2.99:Help Needed In Message Control - Very Urgent 88


    Hi ,

    My requirement is some what similar to Srinath and its urgent. But i would like to create the IDOC with Error status. I need to validate something at the control record level and if it fails i need to Error out the IDOC say status 51 or any status in RED with my custom status message.

    Srinath - I tried raising the exception in my user exit and it did'nt create the IDOC but it did not made the output red...So, I dont know if that will help you??

    Any ideas on how to do this is really appreciated!!

    Thanks,

    Naveed.

  • RELEVANCY SCORE 2.99

    DB:2.99:Customer Invoice js



    Hi experts,

    To create customer account statement i have to create customer invoice .

    how to crete customer invoice.

    Thanks,

    jeevitha

    DB:2.99:Customer Invoice js


    Hi!

    Use transaction VF01 to create a customer invoice.

    You need a previous document, like customer order (VA01 transaction) or delivery (VL01N transaction).

    Regards

    Tam

  • RELEVANCY SCORE 2.99

    DB:2.99:Adding Customer Fields To Fb01 Invoice 9j



    I added three customer fields to BSEG using transaction OXK3 and am trying to figure out how to get these fields on the invoice entry screen of FB01 (SAPMF05A / 0301). I was able to add them to the credit entry screen using the Maintain Coding Block Subscreens (OXK1), but can't figure out how to get them on the invoice entry screen.

    Any ideas?

    DB:2.99:Adding Customer Fields To Fb01 Invoice 9j


    Hi Sachin,

    Even i have a similar situation, where i need to add one customer field to FB01 trasaction in ite details.

    I have followed all the steps that are listed by you in the prior message.

    Now am able to chnage the screen layout in coding block area but unable to get my field on the screen.

    as i cahnge the sequense of customer screen in OXK1 it is getting reflected but, my customer field is not reflected on screen.

    Pl help in this regard, if i missed any step.

    Regards,

    Deepak.

  • RELEVANCY SCORE 2.99

    DB:2.99:How To Create An Invoice And Get Customer To Sign 38


    Im just starting my own mobile mechanic business and I want to use my iPad 2 (3G wifi) to create an invoice on the job, I also would like to get the customer to sign for the job on my screen.Is this possible ?

    DB:2.99:How To Create An Invoice And Get Customer To Sign 38

    Im just starting my own mobile mechanic business and I want to use my iPad 2 (3G wifi) to create an invoice on the job, I also would like to get the customer to sign for the job on my screen.Is this possible ?

  • RELEVANCY SCORE 2.98

    DB:2.98:Problem In The Commission Value 91



    hi

    can anybody help me on the below problem:

    1)
    Commission Agreements in Invoices
    :To enable Commission Agreements (Condition Type ZCA1) values to be copied from Sales Orders into the associated Invoices and Commission Credit Note.Currently Invoices reselect valid Commission Agreements upon invoice creation, i.e. Values may have changed after Sales Order creation.2)
    Commissions Agreements in Sales Orders
    :To enable Commission Agreements (Condition Type ZCA1) values to be changed in Quotation, i.e. override Commission Agreement, by authorised users:Option 1: Bespoke transaction.Option 2: Release Strategy.Option 3: Amend manually Manual approval and exception reporting.Note If this cannot be restricted in SAP a robust manual process must be implemented3)
    Commission Credit Note Financial Posting to Sales Ledger1
    - Sales invoice automatically creates a Commission Credit Note.2 - Value is posted to Suspense Account GL534900 (Automatic)3 - Value is then transferred to relevant Sales Ledger Commission account (Automatic)Step 3 often fails and may be related to dates / period end closing, there is also an issue with Customer credit notes which create commission debit notes4)
    Program Modification
    Re-create the link between the original invoice and the commission credit noteThe creation of a Sales Invoice automatically creates a PartRebSettl.Request Order (ZB3).Bespoke table ZVCOMMLINK is updated cross referencing the:Billing Document.Sales Document.Accounting Document.This table is used by ABAP Query ZAQ_FI_0042.Action 1: Identify historically data to populate bespoke table.Action 2: Update bespoke table with historical data.

    please help me on the above problem.i have checked in the copy control in which they are not maintaining the item category TAN in the sales document from sales document to invoice.but i dont know how then its coming in invoice if its not maintained in the copy control.Also in the automatic creation of credit memo i have to create a link between credit memo and the invoice generated

    waiting for a quick reply

    regards

    vikas

    DB:2.98:Problem In The Commission Value 91


    hi

    can anybody help me on the below problem:

    1)
    Commission Agreements in Invoices
    :To enable Commission Agreements (Condition Type ZCA1) values to be copied from Sales Orders into the associated Invoices and Commission Credit Note.Currently Invoices reselect valid Commission Agreements upon invoice creation, i.e. Values may have changed after Sales Order creation.2)
    Commissions Agreements in Sales Orders
    :To enable Commission Agreements (Condition Type ZCA1) values to be changed in Quotation, i.e. override Commission Agreement, by authorised users:Option 1: Bespoke transaction.Option 2: Release Strategy.Option 3: Amend manually Manual approval and exception reporting.Note If this cannot be restricted in SAP a robust manual process must be implemented3)
    Commission Credit Note Financial Posting to Sales Ledger1
    - Sales invoice automatically creates a Commission Credit Note.2 - Value is posted to Suspense Account GL534900 (Automatic)3 - Value is then transferred to relevant Sales Ledger Commission account (Automatic)Step 3 often fails and may be related to dates / period end closing, there is also an issue with Customer credit notes which create commission debit notes4)
    Program Modification
    Re-create the link between the original invoice and the commission credit noteThe creation of a Sales Invoice automatically creates a PartRebSettl.Request Order (ZB3).Bespoke table ZVCOMMLINK is updated cross referencing the:Billing Document.Sales Document.Accounting Document.This table is used by ABAP Query ZAQ_FI_0042.Action 1: Identify historically data to populate bespoke table.Action 2: Update bespoke table with historical data.

    please help me on the above problem.i have checked in the copy control in which they are not maintaining the item category TAN in the sales document from sales document to invoice.but i dont know how then its coming in invoice if its not maintained in the copy control.Also in the automatic creation of credit memo i have to create a link between credit memo and the invoice generated

    waiting for a quick reply

    regards

    vikas

  • RELEVANCY SCORE 2.98

    DB:2.98:Default Text In Customer Invoice 8z



    Dear All,

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

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

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

    Thanks in advance!!!!

    DB:2.98:Default Text In Customer Invoice 8z


    Hi Wolfang!!!

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

    Regards,

  • RELEVANCY SCORE 2.98

    DB:2.98:Link To Fetch The Customer Invoice And Its Residual Payments In The Zreport. fz



    Hi Experts,

    Can anybody let me know Table/field or BAPI/BADI to link the Customer invoice with its residual payments.

    Example :

    Customer have invoice of $ 100,000. and customer paid the residual payment twoice.

    First Payment : Residual payment is with $20000, Now remaining amount from invoice is $80,000.

    Second Payment : Residual payment is with $15000, Now remaing amount from invoice is $65,000.

    Now i need the report where i should get the invoice linked to its residual payments,

    Here is the out put :

    Invoice Amount : $100000

    1. Residual Pay : $20000

    2. Residual Pay : $15000

    Please let me know the table/fields or relevant BAPI/BADIs to fetcht the data?

    Regards,

    SAM

    DB:2.98:Link To Fetch The Customer Invoice And Its Residual Payments In The Zreport. fz


    Hi Experts,

    Can anyone guide me on this? Please guide me which table-fields shall i use to fetch the data?

    Thanks in advance.

  • RELEVANCY SCORE 2.98

    DB:2.98:Billing Rule Created For Pre-Payment Of Customer Invoice For Uk Vat ap



    Billing rule created for pre-payment of customer invoice. UK VAT requirement is to post VAT at time of invoice creation. It appearsthat pre-payment posts VAT at time of receipt of payment. This does not comply to UK VAT law.

    Please advise solution for UK VAT.

    How have other folks dealt with this in the UK?

    DB:2.98:Billing Rule Created For Pre-Payment Of Customer Invoice For Uk Vat ap


    Billing rule created for pre-payment of customer invoice. UK VAT requirement is to post VAT at time of invoice creation. It appearsthat pre-payment posts VAT at time of receipt of payment. This does not comply to UK VAT law.

    Please advise solution for UK VAT.

    How have other folks dealt with this in the UK?

  • RELEVANCY SCORE 2.98

    DB:2.98:How To Get Down Payment Amount Associated To One Customer Invoice 39



    Hello Experts,

    I have an issue and i need your help.

    I have one customer invoice in FI (Transaction FB70).

    In my form, i need to print the Down Payment Amount associated to this customer invoice. How can i get this information? I mean this amount. There is a table or MF that can give me this amount?

    Thank you in advance.

  • RELEVANCY SCORE 2.98

    DB:2.98:Proforma Invoice pf


    Hi All
    Does Order Management have Proforma Invoice creation feature?(11.5.10).
    Anyone have a way to print a proforma invoice for a customer before I ship the goods?

    Thanks
    Essam Essmat
    essam.essmat@mfg.bahgat.com

    DB:2.98:Proforma Invoice pf

    Hi All
    Does Order Management have Proforma Invoice creation feature?(11.5.10).
    Anyone have a way to print a proforma invoice for a customer before I ship the goods?

    Thanks
    Essam Essmat
    essam.essmat@mfg.bahgat.com

  • RELEVANCY SCORE 2.98

    DB:2.98:Basic zd



    i have customer vs invoice(s) data sheet in excel

    first I have to count no of invoices for each customer and

    i I want to see customer who have max invoice in text object

    DB:2.98:Basic zd


    Please close the thread by marking appropriate correct and helpful answers.

    -Sundar

  • RELEVANCY SCORE 2.98

    DB:2.98:Exit_Saplv50e_001 User Exit Is Not Working For Multiple Plants Case fp


    Hi,I have to update foreign trade data in Invoice during invoice creation using VF11. For that, I have written code in EXIT_SAPLV50E_001 and updated segal value. This functionality is working fine, if I have a single plant in an invoice. But customer has scenario where they can have multipl plants in an invoice.For multiple plants in an invoice, this EXIT_SAPLV50E_001 is not called. I am unable to find another better place where in I could place my code. Please help. Remember, case in multiple plants.Will be rewarded.RegardsArpit

    DB:2.98:Exit_Saplv50e_001 User Exit Is Not Working For Multiple Plants Case fp

    Hi Arpit, Please use below mentioned user exit in T-code VF11he following user exits are available for tcode VF11Exit Name DescriptionSDVFX001 User exit header line in delivery to accountingSDVFX002 User exit for A/R line in transfer to accountingSDVFX003 User exit cash clearing in transfer to accountingSDVFX004 User exit G/L line in transfer to accountingSDVFX005 User exit reserves in transfer to accountingSDVFX006 User exit tax line in transfer to accountingSDVFX007 User exit: Billing plan during transfer to AccountingSDVFX008 User exit: Processing of transfer structures SD-FISDVFX009 Billing doc. processing KIDONO (payment reference number)SDVFX010 User exit item table for the customer linesSDVFX011 Userexit for the komkcv- and kompcv-structuresV05I0001 User exits for billing indexV05N0001 User Exits for Printing Billing Docs. using POR ProcedureV60A0001 Customer functions in the billing documentV60P0001 Data provision for additional fields for display in listsV61A0001 Customer enhancement: PricingJ_3RSINV Customer enhancement: Pricingor You can use BADIBADI_SD_SALES_BASICBADI_SD_TO_FMBADI_SD_BILLINGRegards, Thangam.P

  • RELEVANCY SCORE 2.97

    DB:2.97:How To Obtain The House Bank In The Customer Invoice Posted By Fb70? dm



    Hi All,

    Could anyone tell me how to obtain a certain house bank in the customer invoice posted by FB70?

    I've made a test. I've filled an house bank in master data of the customer (company data). When I've posted the invoice by FB70, i've expected finding it in the item.... instead it wasn't there...

    Cuold anyone help me?

    Thanks

    gandalf

    DB:2.97:How To Obtain The House Bank In The Customer Invoice Posted By Fb70? dm


    Dear,

    The House bank will not reflect in customer invoice, it is used in outgoing or incoming payments.

  • RELEVANCY SCORE 2.97

    DB:2.97:Sms To Customer And Sales Employee After Invoice d3



    Hello,

    I want to use sms services of SAP business one.

    after creation of invoice, SMS should be send to customers and sales employee regarding diffrerent details.

    can anyone tell me how to configure SMS service for this??

    Awaiting for soonest reply , as my client need it urgent.

    Right answer will be highly appreciated.

    Thanks and regards,

    Poonam

    DB:2.97:Sms To Customer And Sales Employee After Invoice d3


    Hi Poonam,

    You may check these links below:

    http://scn.sap.com/thread/1851637

    http://scn.sap.com/thread/1320843

    http://scn.sap.com/thread/1160989

    JM

  • RELEVANCY SCORE 2.97

    DB:2.97:Invoice Creation With Withholding Tax f1



    Hi friends,

    when we create the invoice using TC FB60 how the tax details will reflect to particular invoice, what need to be done for invoice creation screen to reflect the tax details.

    Advance Thanks.

    your suggession will be given points.

    DB:2.97:Invoice Creation With Withholding Tax f1


    Dear Purna

    You need to create a tax code and assign in TC: FB60, the tax codes can

    be created by TC: FXTP or in ECC 6.0 the TC is FXTP or FV11 (for assigning tax code)

    Best Regards

    Mukesh Mokashi

  • RELEVANCY SCORE 2.96

    DB:2.96:Auto Creation Of Excise Inv For Material Sent To Depot ff



    Dear Gurus,

    We are sending material to Depot against performa invoice. The excise invoice we are creating manually through J1iin by maintaining Excise Group and series.

    Please guide how can we make it as defult creation of Excise invoice alongwith performa invoice.

    Regards,

    Vs

    DB:2.96:Auto Creation Of Excise Inv For Material Sent To Depot ff


    Hi,

    As Bala told select the check box Excise invoice during billing in Excice group definition and Maintain Default excise group and series group in Business transaction outgoing Ex Inv. Here you have to maintin the combination.

    regards

  • RELEVANCY SCORE 2.96

    DB:2.96:Customer/Vendor Down Payments (Raise Post) a3



    Hi Friends,

    Question:

    I am technical guy, now i want to know how to raise a vendor/customer down payments how to clear those in FICO.

    I tried in F-47, F-54, F-32, F-53...... but i didn't get the correct way.

    Doing:

    My intention is, i am generating a report with the help of Vendor Doc Number (BELNR). I am getting the number(BELNR) for Vendor/Customer Invoice from F-53.

    So is it possible to get the BELNR from F-53 for Down Payments.

    Additional Point:

    My Knowledge: Creation: vendor invoice (FB60) customer invoice (FB70)

    Payments vendor payments (F-53) customer paymetns (F-31).

    I need a answer for Question Block alone

    Thanks a lot

    Ganesh

    DB:2.96:Customer/Vendor Down Payments (Raise Post) a3


    It's dependent on the process (Business Process) - The only way you can find this info is when the users enter the PO info while creating a down payment request.

    In order to make the above step mandatory, PO/Other field representing this Info must be be a required field for Alternative Reconciliation Account.

    Nandita

  • RELEVANCY SCORE 2.96

    DB:2.96:Wbs Element Transfer From Invoice To Fi Documents. zc



    Dear Friends,

    In our business process

    1. Project creation

    2. Delivery

    3. Project Invoice.

    In this case we can see WBS elements in invoice item data. But this WBS elements did not transfer to Financial documents.

    Please suggest me how to transfer the WBS element from Invoice to FI Documents.

    Kindly Regards

    Arun

    DB:2.96:Wbs Element Transfer From Invoice To Fi Documents. zc


    Hi Arun,

    In the WBS masterdata, in basic data tab, if the " Account Assignment Element" is not ticked on, please tick it. After doing this, try the transaction from scratch once again. Now the posting document will have the WBS element.

  • RELEVANCY SCORE 2.96

    DB:2.96:Create Xml-Idoc From Outgoing Invoice Data 33



    Hi!

    A customer would like to get informations from our invoice with XML. The XML-file should be a XML-IDOC. Can I create this file by printing the invoice? Is there a function module to create the XML?

    Thanks

    Markus

    DB:2.96:Create Xml-Idoc From Outgoing Invoice Data 33


    Hi Vinod!

    Thank you for your answer.

    Best Regards

    Markus

  • RELEVANCY SCORE 2.96

    DB:2.96:Adding Layout To Starter Solution jk



    Hi

    I am using an "Invoice" starter solution. It has an invoice layout that is connected to "customer" and "products" data bases. I have adapted it to my needs and it works perfectly. I now need to add a layout for purchase orders and one for proposals. Both of these should work just like the invoice layout using data from the customer and products data bases.

    Can anyone give me some pointers on how to get started? I seem to be getting the sequencing all wrong. I have been using FM 5 for many years, but am new to FM 11.

    Thanks...Diana

    DB:2.96:Adding Layout To Starter Solution jk


    Diana,

    OK, seems you missunderstood my instructions. But none-the-less, lets work with where you are. Can you post a copy of your relationship graph after you make these changes?

    Purchase Orders is a new table in your table list, correct? Purchase Order Line Items also needs to be a new table. Link up the Purchase Orders table occurance to the Purchase Orders Line Items table occurance and branch off from this group your products and customers table occurances you just created. One products table can be represented on the graph by many table occurances, yes, using the same table is OK.

    Set up the Proposals table and a proposals Line Items as well.

    Believe me you do NOT want to use the same line items table for all three (Invoices, PO's Proposals). It sounds good, but a compound line items table will sooner or later cause more headaches that it's worth. Each function should be it's own island and script the jumping of lines between.

    Make sure each table has a ID (serial number) field and draw the relationships to and from it, just like the invoices table occurance group. Also, I would add a Created timestamp and a modified timestamp in each table. There will come a time someday when you will need to know this data.

    Once again you need to get all the tables and relationships worked-out first, then all the other modifications work much more smoothly.

    HTH,

    Tim

  • RELEVANCY SCORE 2.96

    DB:2.96:How To Join Reports cf



    Hi Experts,

    If i have one report, I would like to result of it or one field values to insert in variable of other report.

    Suppose Report A has in customer and Invoice

    Report B has Invoice and Check info

    I would like to put customer name in report A and get all invoice info and insert these invoice info into Report B to get result how it can possible.

    Thanks

  • RELEVANCY SCORE 2.95

    DB:2.95:Restricting Some Customers From Printing mj



    Hi Folks

    there is a requirement in which , we've to restrict

    printing invoice for some payers which has some specific customized attribute checked in customer master sales data.

    And we print invoice by running program rsnast00 and putting invoice in objkey and outputtype etc.

    One solution is to change the code and make a customized rsnast00 but we don't want to change standard code.

    Is there any work around.

    And we want output type to be determined while creation of invoice because we may like to print it in future.

    With regards

    Mandeep

    DB:2.95:Restricting Some Customers From Printing mj


    Mandeep,

    The best way is to write an output requirement. Even if the output is surpressed, you can manually create the output at a later date when you want it. But if you don't want this and want the output to be determined but not printed, try the following.

    Create a new condition table (if it does not already exists) with the customer and the attribute you were talking about. Add it to your existing access sequence for this output. Ensure that this table is the first one in the access. Enter the output condition record for this new access/table using VV31. While entering the condition record, enter the Date/Time value as "3 Send with Application own transaction".

    When you create the Invoice, the output will be determined based on the condition record. Then when your RSNAST00 job runs, it will print all the outputs that are determined and have a value of "1. Send with periodically scheduled job". The output that was determined in your invoice will never be printed by RSNAST00 job because it has a value of 3 !

    So you can see it in your invoice with yellow lights and it is available for manual printing when you want it.

    Regards,

    Chandan

    Note: You might have to ask your ABAPer to write code to ensure that the attribute value is available in the output structure in the invoice.

  • RELEVANCY SCORE 2.95

    DB:2.95:Editing An Invoice To Change A Customer's Email Addy ks



    I issued an invoice to my customer, sent him a reminder and now he wants the Paypal invoice sent to another email address instead.

    How do I resend the invoice using his additional email address?

    DB:2.95:Editing An Invoice To Change A Customer's Email Addy ks


    Coastal -

    Hello there!

    You can send the invoice to another address by logging in and clicking on "Request Money." Locate your invoice down below and select "Copy." You'll then be taken to a page that is a copy of that invoice and you can edit it to your heart's desire! You'll just want to make sure you cancel the old one so they don't accidentally pay it twice!

    Thanks!

    Adrian




    Was my post helpful? If so, please give me a kudos!Did my post solve the issue? If so, please accept it as a solution!

  • RELEVANCY SCORE 2.95

    DB:2.95:How To Put Validation While Creating Invoice Based On The Customer Data? 9k



    Hi All,

    I want to add a validation based on the customer no. while creating invoice in VF01.

    The validation code should be executed before the invoice is created because If the

    validation fails the invoice should not be created.

    i tries checking all the exits in SMOD but non seemed helpful. now i want to know where

    exactly i should put this code of validation.

    DB:2.95:How To Put Validation While Creating Invoice Based On The Customer Data? 9k


    Hi All,

    I want to add a validation based on the customer no. while creating invoice in VF01.

    The validation code should be executed before the invoice is created because If the

    validation fails the invoice should not be created.

    i tries checking all the exits in SMOD but non seemed helpful. now i want to know where

    exactly i should put this code of validation.

  • RELEVANCY SCORE 2.95

    DB:2.95:Invoice Creation Using Vf06/ Vf04 88



    Hi All.

    I have a monthly billing customer, where the month end will be the base for invoice creation, i might have around 900+ deliveries with more than 10,000 lines when an invoice is created for this customer.

    i dont want this to happen, i need to have a control that only around 100/ 200 deliveries are combined to have one invoice for this single payer. meaning on the above case i can have 10+ invoices ( not as a single invoice nor as 900+ invoices per delivery).

    can you please let me know on acheiving this functionality

    Thanks Regards

    ilango

    DB:2.95:Invoice Creation Using Vf06/ Vf04 88


    i had maintained 3 in this area

    Do you mean Billing - Billing Docs - Country specific features ?? If so, ensure no user exit is in place.

    G. Lakshmipathi

  • RELEVANCY SCORE 2.95

    DB:2.95:Excise Invoice Should Not Get Created Without Pgi j8



    Hi,

    I have a scenario where the billing document is being generated by the customer without PGI after creation of outbound delivery for exports. (This is as per customer's requirement - Copy control maintained in VTFL for the same - copying requirements 11 )

    This creates a situation - excise invoice can be created without PGI - which creates problems for customer. This should not happen.

    Customer wants a check during the excise invoice creation - excise invoice should not get created if PGI has not been done.

    Kindly advise as to how this can be done.

    Regards,

    T Saravanan

    DB:2.95:Excise Invoice Should Not Get Created Without Pgi j8


    Thanks Lakshmipathi for the solution.

    Using the user exit mentioned by you, we have been able to solve the issue.

    Regards,

    T Saravanan

  • RELEVANCY SCORE 2.94

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



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

    Script is

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Appreciate any input on what is wrong with the above script

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


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

    Script is

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    Appreciate any input on what is wrong with the above script

  • RELEVANCY SCORE 2.94

    DB:2.94:A/R Down Payment Not Posting To A/R Invoice ss



    We are having trouble with the a/r down payment process. We have open invoices even though we have already received payment.

    For example, a customer mailed in a check to order items. We added the items on a sales order. We clicked on the Money Bag (Payment Means), and entered the check as a deposit on the order. SAP added a note that the order was linked to down payment. Through a batch process, we delivered the order and it became an a/r invoice. Because the A/R Invoice is created in a batch, we can't apply the down payment at the time of invoice creation. When we go back into the a/r invoice, the down payment money is not available to apply to the invoice. If we select the box with the triple dots next to total down payment to apply the down payment, it says u201CNo matching records found.u201D

    When I click on the Business Partner, I can't see the down payment in their account balance to close it manually. What I do see is three entries. The first is a DT, debiting customer account for the a/r down payment. I donu2019t understand this entry, because this sounds like itu2019s u201Cchargingu201D the customer for their deposit. The second is an RD, crediting the customer account for the incoming payment. These two entries are reconciled against each other and closed. The third entry is an IN, for the open invoice.

    How do I get the a/r down payment process to work and reconcile the incoming payment to the invoice?

    Please help.

    - David Daniels

    DB:2.94:A/R Down Payment Not Posting To A/R Invoice ss


    Hi,

    The Downpayment functionality is the advance payment recieved and the same needs to be assigned to the Invoice.

    If possible, please test the compete scenario which you have and make the target document from the Sales Order to Delivery and from Delivery document to Invoice.

    The Invoice automatically assigns the Downpayment created based on the Sales Order. (Check in 8.8 version).

    If it is not helping then you can check the option of creating a Reserve Invoice to book the advance you get against the Sales Orders prepared.

    Hope it helps.

    Kind Regards,

    Jitin

    SAP Business One Forum Team

  • RELEVANCY SCORE 2.94

    DB:2.94:Rename Customer Data Tab In Po jf



    I want to rename the Customer Data Tab existing in the PO creation screen

    How can i do it? Pls suggest.

  • RELEVANCY SCORE 2.94

    DB:2.94:How Excise Invoices Are Sorted In Excise Invoice Selection Screen (J1ij) sd



    Sir

    when I do excise invoice creation in Ji1j for customer depatch, in the excise invoice selection screen , the excise invoices are not sorted properly, i.e excise invoice related to 2011 appearing first and then 2008 is appearing then again 2011 is appearing.

    can some one tell me how these excise invoices are sorted?

    Jaya Anand

    DB:2.94:How Excise Invoices Are Sorted In Excise Invoice Selection Screen (J1ij) sd


    Sir

    Not yet. Already 'EI proc' is set as First in firstout only.

    But Still , 2008 document is appearing in the middle of 2011 documents. i.e first 4 documents is related to 2011 and 5th document is 2008 and then again 6th document related to 2011 ect...

    Can I attach the screen shot in this forum?

    Regards

    Jaya Anand

    Edited by: Jayaanand on Nov 21, 2011 10:19 AM

  • RELEVANCY SCORE 2.94

    DB:2.94:Customer Invoice Of Fi Document 3p



    Hi Gurus,

    How to print invoices posted using fb70 which is customer fi invoice....

    Can we use same invoice which is developed for invoices from sd module....

    Thanks

    DB:2.94:Customer Invoice Of Fi Document 3p


    Dear Mohit

    Plz check this link

    https://scn.sap.com/thread/1012914

    Dear MMPIO

    plz let me know Any differnce is there between assigning SAP19 IN OB77 and F.62

    Thanks a lot

  • RELEVANCY SCORE 2.93

    DB:2.93:Two Ne Fields In Customer Invoice And A Button To Call A New Screen With... 3d



    Hi All,

    My reqirement is Two new fields in customer invoice and a button to call a new screen with employee data and all there have to reflect in the statndard reports. How to do this.

    Regards,

    KAMAL KP

    DB:2.93:Two Ne Fields In Customer Invoice And A Button To Call A New Screen With... 3d


    Hi All,

    My reqirement is Two new fields in customer invoice and a button to call a new screen with employee data and all there have to reflect in the statndard reports. How to do this.

    Regards,

    KAMAL KP

  • RELEVANCY SCORE 2.93

    DB:2.93:Help ! Import Details df


    i using vb express 2005
     
    my invoice system got some tables
     
    Customer
    CustomerID
    Name
    Address
     
    Statement (form statement)
    StatementID
    CustomerID
    Date
    itemno
    Desription
    Debit
    Credit
     
    invoice ( form invoice)
    InvoiceID
    invoice no ---(currently in textbox) need send to --- itemno in statement
    Invoice_date (currently in date timepicker)---need send to --- date in statement
    CustomerID
     
    invoicedetails ( form invoice)
    InvoicedetailsID
    InvoiceID
    quantity
    price
    total (currently in textbox)---need send to --- Debit in statement
     
     
     
    i need to send those 3 data from invoice to statement .
    how to do it ? use sql statement?

    DB:2.93:Help ! Import Details df

    I'm not sure i follow you exactly on this one.
    When you say update do you mean after you type in the data in the textboxes or after you update the database table?
     
    Either way you just need to use an event to put the data into your variables and then get that data into the statement form.
     
    either use a button to send the data or another event tied to your invoice boxes or invoice form
    let's say you use a button
     
    Basically it would be like this
     
    type the data in the invoice boxes
    click the button
    button code ---------
                  Integer.TryParse(me.totaltextbox.Text, invtotal)
                                statementform.totaltextbox.text = invtotal
     
    That's basically it
    add all your data like this in one event
     
    Keep in mind that i am assuming you have a details view of your statement table in the statement form

  • RELEVANCY SCORE 2.93

    DB:2.93:Need Urgent Help fs


    Dear All

    We have a report where we need to show the average difference based on two columns.

    We are currently showing a field "difference" and it is based on "Invoice transaction date" which is the date invoice created and "Transaction creation date" which is payment created date. .

    For example if a customer has 3 lines in this report the difference between the invoice date and the payment date is shown in the "difference" column(number of days).

    Now the user wants this to be further consilidated into customer name and invoice number level.

    so this "difference" values (number of days) should be further divided into number of rows per each customer and the invoice number of that customer.

    Ex : If customer A has two invoice numbers 1 and 2 and each invoice has two payments raised on two different days (incase of CM ) , the report will show two different lines for each invoice number and the difference of days between the invoice created date and payment created date , further it should also show the avg difference at both invoice number level and the customer name level.

    How can we achieve this?

    Please help me.

    Regds
    Mano

    DB:2.93:Need Urgent Help fs

    Dear All

    We have a report where we need to show the average difference based on two columns.

    We are currently showing a field "difference" and it is based on "Invoice transaction date" which is the date invoice created and "Transaction creation date" which is payment created date. .

    For example if a customer has 3 lines in this report the difference between the invoice date and the payment date is shown in the "difference" column(number of days).

    Now the user wants this to be further consilidated into customer name and invoice number level.

    so this "difference" values (number of days) should be further divided into number of rows per each customer and the invoice number of that customer.

    Ex : If customer A has two invoice numbers 1 and 2 and each invoice has two payments raised on two different days (incase of CM ) , the report will show two different lines for each invoice number and the difference of days between the invoice created date and payment created date , further it should also show the avg difference at both invoice number level and the customer name level.

    How can we achieve this?

    Please help me.

    Regds
    Mano

  • RELEVANCY SCORE 2.93

    DB:2.93:Fbra Customer Invoice fj



    Hi I cleared customer invoice for 100$ by a customer payment in F-28.

    Then I used FBRA to reset reverse this cleared invoice. Now this invoice is open again but how can I track 100$ received from customer.

    I

    DB:2.93:Fbra Customer Invoice fj


    I guess there is some misunderstanding about FBRA function. It comes with Reset and also Reset and Reverse. So the question is, which one did you activate? If you had chosen the Reset then the changes done was only to unmatched the cleared items whereby both the invoice and payments becomes open items again.

    If you had chosen Reset and Reverse of the payment doc no. then the reset process was done and also the payment was reversed thereby the entry shd have been Dr Customer Cr Bank to reverse and also cleared the payment with the invoice being the only open items waiting to be cleared.

  • RELEVANCY SCORE 2.93

    DB:2.93:Func Module/Bapi For Invoice Creation pd



    Any function module for invoice creation WITH REFERENCE TO A SALEORDER. ??

    DB:2.93:Func Module/Bapi For Invoice Creation pd


    Hi,

    check this FM:GN_INVOICE_CREATE or BAPI: BAPI_BILLINGDOC_CREATEMULTIPLE

    check this link also.

    BAPI for creating sales invoice

    Regards

    Appana

  • RELEVANCY SCORE 2.93

    DB:2.93:Vendor Treat As Customer Complicated Scenario mz



    Respected Sir

    Vendor treat as customer , i had done all settings as per vendor customer master data.

    1) Vendor treat as customer this is also one of the scenario in Dairy. when vendor invoice amount customer invoice amount should be deducted display in F-53 FBL1N.

    Example:

    Vendor Invoice Rs.125000.00

    ( - )

    Customer Invoice Rs. 75000.00

    -

    Total Amount 45000.00

    2) When i do payment to vendor in F-53 ,only display Rs.45000.00

    So what should i do for this plz guide me .

    Correct/Good answer get reward.

    Thanks regards,

    Girish

    DB:2.93:Vendor Treat As Customer Complicated Scenario mz


    Hi,

    What I understand is that you have a vendor invoice for 125000/- and a customer Invoice for 75000/-.

    As this customer is also a vendor you need at the time of making the balance amount of 50000/- you only want this 50000/- to appear in the open item list.

    I the above understanding of mine is correct,

    You need to change your process. You advice your client to first do residual clearing using F-44.

    Then at the time of payment using f-53 you will get the balance 50000/- is only displayed.

    keep in mind that the number ranges that you are having in you system. The system will generate a new document with a different number.

    Sarma

  • RELEVANCY SCORE 2.93

    DB:2.93:Cancel Paypal Invoice To Customer p9



    I sent a paypal invoice to a customer but to the incorrect email address. He sent me an email answer in reply to confirming the payment. How do I cancel the current paypal invoice and resend a new one to the correct email address?

    DB:2.93:Cancel Paypal Invoice To Customer p9


    What I also do is make sure to check the checkbox that says the other party will get a copy of the notice of cancellation of the money request. The default of the the checkbox is that the other party will NOT get an email notification of the cancellation. In this situation it sounds good for them to get the notice through email IMO.

  • RELEVANCY SCORE 2.93

    DB:2.93:How To Create Commercial Invoice .. 8f



    DEAR

    While creating invoice my customer wants output as a commercial invoice

    i am not able to do it and not understood plz help me how to it

    DB:2.93:How To Create Commercial Invoice .. 8f

    In SAP, you can generate two types of invoices; one is Commercial Invoice which is legally binded and the standard billing type provided by SAP for commercial invoice is F2. The other billing type is F1 F8 which are Order related and Delivery related proformas respectively which has no financial impact. Please search the forum for more details if you want.

    G. Lakshmipathi

  • RELEVANCY SCORE 2.93

    DB:2.93:Customer Invoice Number jz



    Hi,

    I am trying to implement Lockbox. I need to create an BAI2 file, which consists of "Customer Invoice". I need to know where can we get the Customer Invoice number. We can post Customer Invoice using FB70, after giving all the information, I got a message "Document 1051 was posted". Is 1051 the Customer Invoice number ?

    I Will award points surely.

    Thanks

    Rajanikanth

    DB:2.93:Customer Invoice Number jz


    Hi,

    Yes, that is the customer invoice number. If you want to see the same where it is go to the transaction code FBL5N and give customer name and search.

    Assign Points

    Z

  • RELEVANCY SCORE 2.92

    DB:2.92:One Time Customers In Sap Business One 1z



    Hello,

    i want to know some thing about one time customer. In SAP Business One data base one perticular customer is there. His customer id is c99999 and name is one time customer. I prepared sales quotation, sales order and delivery for that customer and i am trying to prepare invoice for that customer. How can i create Invoice for that custome.

    Thank you,

    jyothi

    DB:2.92:One Time Customers In Sap Business One 1z


    Hello, jyothi.

    There is A/R Invoice + Payment document in Sales A/R module for one time customers.

    HTH.

    Anton

  • RELEVANCY SCORE 2.92

    DB:2.92:How To Filter Data aa


    Hello Everybody
    I have four entities (Invoice, ApplyCredit, CreditNote Customer)
    Relationships
    From ApplyCredit to Invoice = Many - Zero or One
    From ApplyCredit to CreditNote = Many - Zero or One
    So as per above scenario a many to many relationship created between Invoice and CreditNote. That is OK.
    And also Customer is One to Many relationship with Invoice and CreditNote respectively.
    My problem is,
    If CreditNote having Customer1, then i want to filter all invoice where Customer = Customer1.
    Anybody please help me how can i do this ?Rashmi Ranjan Panigrahi

    DB:2.92:How To Filter Data aa

    Now it makes sense. I don't think this has to do with many-to-many at all.This probably doesn't actually require you to write code for a query; you can probably just use the designer.

    Create a query over the Invoices entity set. The query should have an integer parameter (call it CustomerId). Then add a filter expression that looks like Customer.Id Equals @CustomerId.On the screen, add a new collection based on this newly created query. Then bind the CustomerId query parameter to the selected CreditNote's Customer's ID. The expression propbably looks like CreditNotes.SelectedItem.Customer.IdSelect the modal window and set its Choices property to this new collection.Justin Anderson, LightSwitch Development Team

  • RELEVANCY SCORE 2.92

    DB:2.92:Using For Each, Assign And Invoke Activity c3


    Gurus,
    I am working on Customer creation process. We get Customer Data in XML. The customer Element has 2 to 5 Addreess child elements. I want to invoke CreateAddress Partner Link (Oracle AS Adapter) for each addess.
    I dont know how to do this. Could you please let me know ?

    Thanks,

  • RELEVANCY SCORE 2.92

    DB:2.92:Sequence Of Process In Export Order ds



    Hi,

    I am following a sequence in Exports scenario:*(where materail is first get transferred to port and then will be delivered to export customer)

    1. Creation of Export order.

    2. Create of stock transfer order from manufacturing plant to port.

    3,.Creation of deliver, stock trnasfer invoice, excise invoice

    4. MIGO at port.

    5. Delvier of export order.

    6. Invoice of export order which sends material to export customer.

    Is the process which I am following is correct. OR it needs to amend.

    Please suggest.

    Gaurav

    DB:2.92:Sequence Of Process In Export Order ds


    Dear Gaourav

    Process 1

    STO From manufacturing plant to Port Plant

    Creat STO first in me21n from man plant to port plant

    Deliver due list in VL02H

    DeliveryVL01N

    Billing VF01

    Based on Billing create Excise invoice J1IIN (For exports you need not maintain duty. All tax condition types are statistical in Billing.

    Good Receipt- MIGO (RG23A Part 1 will update)

    Capture Excise invoice at port plant - J1IEX (RG23A Part 2 will update)

    Process 2

    Sales Process from Port Plant

    Then create Export sales order Delivery PI-- J1IIN (Exc Invoice)

    I have considerd port as port plant. If you create port as Depot, J1IG J1IJ needs to be updated.

    Regards

    Deepu Pillai

  • RELEVANCY SCORE 2.92

    DB:2.92:Withholding Tax Selection During Sales Order Creation az



    Hi,

    Do we have an option to select or deselect Withholding Tax Codes at the time of Creating Sales order / Billing for the Customer?

    As, We get the popup during the time of invoice creation to the vendor.

    Your inputs are appreciated.

    Thanks Best Regards

    Shashikanth.M

    DB:2.92:Withholding Tax Selection During Sales Order Creation az


    Hi,

    Refer the below OSS note:-

    [https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=178824]

    Regards,

    Gaurav

  • RELEVANCY SCORE 2.92

    DB:2.92:Create Invoice mz



    I want creating an invoice to receive "sales revenue received in advance" before issue goods to customer.

    How can i do it ?

    DB:2.92:Create Invoice mz


    Dear,

    As per as your query......Raise Proforma Invoice and collect payment form customer.

    u must maintain Paymetn teram as Advance payment....

    Hope you can manage from this...

    Regards

    Luckky

  • RELEVANCY SCORE 2.92

    DB:2.92:No Business Object Triggering For Invoice Creation 8c



    Hi ,

    I have to develop workflow for invoice creation approval.As once invoice is created then it should go to sales dept. for checking the details and once they approve it then it should be forwarded to customer. But the problem here is no business object/event is triggering for invoice creation Tcode - VF01.

    i have checked it in trace SWEL but its showing no business object triggering entry.so if no business object is getting triggered how is it possible to start workflow.

    please suggest me that whether i need to trigger business object using User Exit or i need to activate some business object for this transaction so that it will start triggering by its own every time incoice is created / changed.

    Thanks,

    Rahul

    Edited by: Rahul Bhasin on May 9, 2008 10:22 AM

    DB:2.92:No Business Object Triggering For Invoice Creation 8c


    Other option is to do event linkage in Trx SWEC with Cng. doc VERKBELEG and BO VBRK.

    Regards, IA

  • RELEVANCY SCORE 2.92

    DB:2.92:Taxation Invoice 3k


    Hi,During the bill from plant If some customer doesnot want Taxation Invoice but Industrial customer want taxation Include in the Invoice,how to do in the system?Please give me the solution.Thanks,Liku.

    DB:2.92:Taxation Invoice 3k

    Hi,Simply exempt those customer for tax in customer master.billing tabThanks,Raja

  • RELEVANCY SCORE 2.92

    DB:2.92:Customer Invoice Email 79



    Hi,

    Can someone help me on how to get the OTF data of the invoice? Is there any Function Module? I searched in SCn, but couldn't find one.

    Need to convert the OTF data of the Invoice to PDF and send it as an attachment via email.

    I know we have to use 'SO_DOCUMENT_REPOSITORY_MANAGER Function Module for Email attachments.

    Please help.

    Thanks Regards,Sowmya

    DB:2.92:Customer Invoice Email 79


    Hi,

    Have you checked the link below. Should help you.

    http://wiki.sdn.sap.com/wiki/display/Snippets/Smartform+to+Mail+as+PDF+attachment

    What ever it is smartform or SAPScript the idea is to get the OTF convert to PDF and send mail. The wiki should help I think. Also the DUMP POSTING_ILLEGAL_STATEMENT means you are trying to do and activity in a Form where it is not allowed. can you please state the form at the statement that is being disallowed. All these details ate present in the short dump.

    Cheers,

    Arindam

  • RELEVANCY SCORE 2.92

    DB:2.92:Collective Invoice Issue ? p7



    Dear Experts,

    we have common delivery , billing document and item category for all countries, and present VBRK/VBRP setting is ( 904 Single invoice )

    If business want collective invoice then from customer master additional data , Attribute as per setting we are printing collective invoice.

    now the requirement from one specific country is for few document types they want collective invoice and other document type they want as single invoice to their customers , and it should be that country specific other country should not be affected

    (e.g. for standard order rush order customer want each order separate invoice , BUT in case of consignment orders customer want collective invoice )

    Through customer master data setting we can achieve this but client don't want to change the master data as per frequent transactions

    How can achieve this with out affecting the other countries business process???????????

    Regards

    Hanumant

    DB:2.92:Collective Invoice Issue ? p7


    Why dont you post this question in SD forum .

  • RELEVANCY SCORE 2.91

    DB:2.91:Excise Invoice Before Commercial Invoice sf



    Dear All,

    Export Sale the scenario is as follows.

    Date is creation date.

    Order- 1-12-2011

    Delivery- 1-12-2011

    Excise invoice-1-12-2011

    Commercial invoice-7-12-2011

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

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

    Reg,

    amol

    DB:2.91:Excise Invoice Before Commercial Invoice sf


    Dear Amol Tamhane,

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

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

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

    Let me know if you have any further clarifications

    ThanksRegards

    Raghu.k

  • RELEVANCY SCORE 2.91

    DB:2.91:Invoice For Asset Sale. 98



    Dear Friends,

    Please tell me how to get the invoice from asset sale with customer

    ( Tran Code f-92).

    It is client reqiurement.

    Thanks regards,

    Reva naik

    DB:2.91:Invoice For Asset Sale. 98


    Dear Friends,

    Please tell me how to get the invoice from asset sale with customer

    ( Tran Code f-92).

    It is client reqiurement.

    Thanks regards,

    Reva naik

  • RELEVANCY SCORE 2.91

    DB:2.91:Blocking Invoice Creation j8



    Hi Friends,

    Suggest me to configure the system to block the invoice creation automatically when ever customer account is overdue.

    Regards,

    Basha

    DB:2.91:Blocking Invoice Creation j8


    hi,

    its possible to achieve this thru credit mgmt. but i does not make sense to block billing wen the PGI has happened (i assme this is a service sales). so i sugest tht the creidt check be dne at the time of sales order creation.

    saurabh

  • RELEVANCY SCORE 2.91

    DB:2.91:Invoice Discount 8k



    i released invoice to accounting but when i made print preview the discount structure not appeared in the invoice so how to let the discount appear in the invoice of the customer

    DB:2.91:Invoice Discount 8k


    Hi,

    If your program is standard then the value is suppose to pick up from the tick, if your Output program is a newly created once by abapers, then they have to check whether the condition type is take into consideration in the output program and also in the Smartforms whether the logic has been mentioned.

    Thanks

    Sudhir

  • RELEVANCY SCORE 2.91

    DB:2.91:Post Customer Invoice Without Line Items. cc



    Ppl, I am extracting customer invoice data from an external sytem and data consists of invoice header with the invoice total but no line items.How can i post this invoice in FI.

    what is the meaning of posting in FI if i am not posting to GL or AR? Where will the invoice get posted?

    your help is greatly appreciated.

    Thanks.

    DB:2.91:Post Customer Invoice Without Line Items. cc


    Best thing is to ask your business/functional person to enter the same thing in the system as if they were to do this manually. Check what transactions they use and what additional values that they enter apart from the ones that you receive on your files. This is the easiest way. If I answer your questions, that will only be my best guess as I wouldn't know your configuration settings and business rules.

  • RELEVANCY SCORE 2.91

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


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

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

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