Sitemap

Amicuk Programming Answers

Invoice List Cancellation Status table field

-0001-11-30   Views:1

Advertisement

Hi, I need to know, which table field is updated when we cancel an invoice List using VF26. If there is cancellation once the VBRK-SFAKN is updated with the cancelled Invoice List Number. But in case there are multiple cancellations, the SFAKN field

Hi,
I need to know, which table field is updated when we cancel an invoice List using VF26. If there is cancellation once the VBRK-SFAKN is updated with the cancelled Invoice List Number. But in case there are multiple cancellations, the SFAKN field still contains the first cancelled Invoice list #. There is no status field in VBRL to indicate whether the status of the invoice list is cancelled or active.
How to trace whether the subsequent invoice lists are cancelled or not?
Thanks,
Amit

The replay answer
Advertisement
Amit,
I don't find any field being updated on the original Invoice list  while u are cancelling it.
So unfortunately you can't find from its VBRK entries that it was cancelled.
This is my understanding.... Let me know if you discover any thing new.
Coming to how we live up with it......
Before sending the invoice list to the customers we will check whether any entry exist in VBRK table with the same number in SFAKN(Cancelled billing doc #)..  So if any entry exist in VBRK, that means this document was cancelled, so ignore it from the send list.
Let me know if you would like to know anymore details....
Thanks,
Aj.

Go to See the other 8 answers

Invoice List Cancellation Status table field

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I need to know, which table field is updated when we cancel an invoice List using VF26. If there is cancellation once the VBRK-SFAKN is updated with the cancelled Invoice List Number. But in case there are multiple cancellations, the SFAKN field[More]

Equipment status table field...

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Does anyone know in which table is stored the equipment status field (Display lines for system status ITOBATTR-STTXT ). The field that tells you if the equipment is installed or available or flagged for deletion.. I will really appreciate any com[More]

Which table field I can confirm if the PO has done invoice receipt

Category:DefaultRelease time:2015-10-11Views:130

Hi, From which table field, I can confirm the PO has done invoice receipt. and in case of that with reference a PO, I have done the IR, but it was reversed, which means PO has not done invoice receipt. For this case, I don't want to read table EKBE t[More]

F110 - Grouping the vendor invoices by BSEG table fields

Category:DefaultRelease time:2015-10-11Views:130

Hi, I want to group the vendor invoices while making the payment through F110,  based on a BSEG table field. The settings in Grouping Key configuration (OBAP) only allows me to choose the fileds from BSIK table and not possible to select the fields f[More]

What is table field name for order status report  of rate per unit and  bal

Category:DefaultRelease time:2015-10-11Views:130

hi  i want to make FS for order status report i almost get all table and field but i don't get only two field  rate per unit and balance value  table field didn't get please help me searching in field and table   i want to develop my status reportHi,[More]

Field KNVV-CHSPL does not exist in field status tables (TMOD*)

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, Wile creating Customer master record at Tc= XD01 the following error coming as "Field KNVV-CHSPL does not exist in field status tables (TMOD*)" Plz help me its  urgent. VinayHi KNVV is the customer sales data table and CHSPL is the fie[More]

Pending Invoice amount - Table field

Category:DefaultRelease time:-0001-11-30Views:130

Hello experts, Is there a table field in SAP that indicates balance payment amount for an invoice? (Pending amount = Invoice amount - Payment amount). I know that we can calculate it but need to know if there is one field that indicates it. Would lik[More]

T-code for cancelled Invoice and cancelled Excise Invoice

Category:DefaultRelease time:2015-10-11Views:130

Dear Guru, kindly let me know the T-code for cancelled Invoice and cancelled Excise Invoice. Wishes, AbhishekHi Abhishek, I am not aware of any T-code through which you can see the cancelled invoice. I think either you have to go for development (SQV[More]

What is the table field for PO releaser in R/3 (4.7 Enterprise)?

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus out there: Do you know if there is a table field for PO releaser in R/3 (4.7 Enterprise)? We use for e.g. the transaction ME29N to release a PO and I haven't been able to find a DB table where the PO releaser is stored. In DB table EKKO I ca[More]

TABLE/FIELD FOR SALES ORDER'S SHIP TO LOCATION

Category:DefaultRelease time:-0001-11-30Views:130

Hi everyone, Does anyone tell me what is the related tables/fields for Sales Order's Ship To Location? Since I want to display the Ship To Location information in the Oracle Report in Oracle Apps R11i. I tried to use the following SQL select statemen[More]

Shipped and Cancellation Status of a Sales Order

Category:DefaultRelease time:-0001-11-30Views:130

Hello Experts , I have a Sales Order no. (vbak-vbeln).I want to know which is the Table-field for statuses which shows all items of sales order are shipped or only some of them are shipped. Also I want to know the Table-field which shows either the e[More]

Hot
hi why do we get the data from a view to a report. is it possible to get the data from a view in all the cases?hi Jyotssna,   Suppose you are planning to get the data from multiple tables then you got to specify seveal condtions and make use of joins [More]
Here's a question I haven't seen anywhere else. It's a long shot, but I'm going to ask anyway. We are using APEX 4.1.0.00.32. The IR Search bar uses a search where no wildcards are needed. In fact, if you do include a wildcard in the middle of the se [More]
Hello, everybody. I have a problem with Time Dimension generating with the help of the Standard Wizard. 1. I choose Dimensions -> New -> Using Time Wizard 2. Set Name as "Time" 3. On the next screen I choose ROLAP: Relational Storage 4. On [More]
Hello Experts, I am trying to create an EVDRE that suppresses any data that is less than 1 (For example, I have a .01 and a .05) and will prevent it from showing up in the report.  Does anyone know the best way of doing this? Thank you so much! David [More]
Ive been mixing a feature film in soundtrack. Previously I had a file containing the full film and (because I couldent get an OMF from avid to work no matter what i tried, so much for the bloody open media file format...) I had a straight wav of all [More]
I'm trying to configure messaging bridge to send messages from WLS           6.1sp1 to WLS 6.1sp1 in another domain and seems it doesn't work. I'm           using following configuration, any idea?           <MessagingBridge Name="BatchBridge" [More]
How to disable cache implementation in 8.1 SP6 for entity beans In our production environment, we want to disable cache implementation for entity beans. We are using weblogic 8.1 SP6. Weblogic cache implementation has been causing many cachefull exce [More]
hi... i am writing a program that requires me to include some directories in the classpath...but i don't where the classpath is..and how do i input the names of the directories...or do i run from it..actually i don' know a thing about classpaths..but [More]
I want to make a news app that shows you relevant news on the basis of your IOS browser information and i wonder if you are allowed to do this on IOS. It is obvious that the user needs to accept the terms of condition but does Apple accept this?BTW t [More]
Hi All, I need a Query to get only duplicate rows from a table. It should print the duplicate rows the number of times . it exists in the table.Added some duplicate records in emp table select count(*),empno,ename,job,mgr,hiredate,deptno from emp gro [More]