Sitemap

Amicuk Programming Answers

How to prepare Aging report in another system

2015-10-11   Views:0

Advertisement

Hi, I have seen aging report for customer in SAP B1, its okay but not serve my purpose. i want this report little difference. i sent a link file for aging report like this way. [Aging Report | http://www.sendspace.com/file/v8jbt3] if it is possible t

Hi,
I have seen aging report for customer in SAP B1, its okay but not serve my purpose. i want this report little difference.
i sent a link file for aging report like this way.
[Aging Report |
http://www.sendspace.com/file/v8jbt3]
if it is possible to make this report please help me about this.
Regards,
Mizan
Edited by: mizan700 on Dec 29, 2010 11:39 AM

The replay answer
Advertisement
Hi Mizan,
Try this as a command in Crystal Report:
SELECT T0.CardName,T0.DocNum,T0.DocDueDate, DateDiff(DD,T0.DocDueDate,getDate()) as Overdue, T0.DocTotal-T0.PaidToDate as 'Due Amount'
FROM dbo.OINV T0
where T0.DocStatus='O' AND DateDiff(DD,T0.DocDueDate,getDate())>0
UNION ALL
SELECT T0.CardName,Null,NULL, NULL, SUM(T0.DocTotal-T0.PaidToDate) as 'Due Amount'
FROM dbo.OINV T0
where T0.DocStatus='O' AND DateDiff(DD,T0.DocDueDate,getDate())>0
GROUP BY  T0.CardName
Order By T0.CardName,T0.DocDueDate DESC
Rank can be by CR function.
Thanks,
Gordon

Go to See the other 6 answers

How to prepare Aging report in another system

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

Hi, I have seen aging report for customer in SAP B1, its okay but not serve my purpose. i want this report little difference. i sent a link file for aging report like this way. [Aging Report | http://www.sendspace.com/file/v8jbt3] if it is possible t[More]

Printing a Customer Receivables Aging Report Doesn't Include PO #

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

The standard Detailed Receivables Aging report uses variable 152 that is supposed to show the Cust/Vendor Ref No.  It doesn't show anything however.  I tried changing it to a database field and relating it to the document #, but that didn't pull in a[More]

Posting date in aging report-PLD

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

Hi, I am trying to get posting date in my aging report-PLD but system is not showing any date in the field I have selected the database and posting date in the content and linked to doc no even then there are no results I am also trying to get docent[More]

Aging Report and Statement of Account in System Currency

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

Hi Experts, We have set up a Business Partner to have Multi Currency. All billing is in USD but payment could be in USD or Local currency Additional set up: Local Currency (JPY) System Currency (USD) We notice that if we set up BP as a multicurrreny[More]

Missing Function - Aging Report not match in System Currency in SBO 8.8

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

Dear all, Version: (Please provide the current version) SBO 8.8 Patch: 10 Description of requirements: (Please provide a detailed description) In mentioned patch level, the result/outstanding balance of Aging Report in System Currency was difference[More]

System (AGE3) 'Customer Aging Report' does not print BP Ref. No.

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

Hi Experts! I have a question about the PLD for the Customer Aging Report (AGE3 = Collection Report). This system print layout does not print the BP Ref. No. in that field. And when I went into the PLD, that field (and the other repetitive fields) ar[More]

Invoice Date on Aging Report (system)

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

The canned aging reports do not provide Document Date.  It does provide the Invoice or Credit Memo Document Number, we need it to pull the date of these documents as well.  Every customer of ours is seeking the same information on the aging reports a[More]

Aging report for Open Invoice

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

Hi All, I need to develop an Aging report for open invoice, there is no indication for open invoice or close invoice since we are using customise DS and DS from third party system. only one key flag we have is clearing date. so kindly let me know how[More]

Ap --Invoice Aging Report    aging period 0-360 periods

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

we need to increase the aging report by 0-360 here i am diving like 0-30 31-60 61-90 91-120 121-150 151-180 181-210 211-240 241-270 271-300 301-330 331-360 The standard layout prints only 4 periods , we want to print all the above periods in output.[More]

Aging Report does not match Balance Sheet Receivables/Payables Account

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

Hi experts, I am requesting your help to find out why our customer receivables/vendor payables aging reports total does not match our balance sheet accounts receivable/ accounts payable account for the same period. I would expect Customer Receivables[More]

Vendor ageing report

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

Hi all, i have to prepare vendor ageing report.In that there is one exception that is if "no. of overdue days > 7 " color should be red.But here no. of overdue days can be calculated with the following formula as shown below. no. of overdue d[More]

Hot
Customer [11:05 p.m.]: can I purchase icloud storage online with an apple gift cardhttps://discussions.apple.com/message/25264841#25264841Read other 2 answers [More]
Hello, starting with RM I just created a static structure for customer data. This works pretty well at the beginning level. Now I would like to add a hierarchy to the customer data. The next level in the structure should be projects with the project [More]
I'm working in a company where there seem to be two ways that the developers called AM functions: Direct Calling: CompanyTakeoffAMImpl thisAM =     (CompanyTakeoffAMImpl)pageContext.getApplicationModule(webBean); thisAM.runSalesFunction(pageContext.g [More]
How to bind the database and to place the data of a field in a EditBox and to modify the data of a table.Hi, Here got one example. Private oUserDataSource As SAPbouiCOM.UserDataSource oNewItem = oForm.Items.Add("ET_GUID", SAPbouiCOM.BoFormItemTy [More]
Since upgrading from R/3 4.7 to ECC 6.0 one of our smartforms has stopped functioning in the upgraded DEV environment. When running the check on the smartform the following error is displayed: Global Definitions      Field "STRING" is unknown. I [More]
Hi  in our shaepoint farm we have a application server,one wfe server and one reporting server and we are using BI solutions and running performance point service  i keep getting below error in wfe server and reporting server as well also. Log Name:  [More]
I am trying to download iTunes to my laptop but I keep getting this "Could not open key: UNKNOWN\Components\ followed by a bunch of numbers and letters.  I have unistalled iTunes and all the other apple componants.  I also used followed this http://d [More]
i want to pass the actual Value of a variable through a link. I dont want it hardcoded as its going to be dynamically read throught the database. So its like I tried using all sorts of different quotes and no quotes and was still just giving me the s [More]
Hi I need to do year over year comparision. I have a key figure net value.When the users run the report, they should have to columns for the same keyfigure for two different years. User should have the ability to compare the following. If user wants [More]
This has already been posted and no body answered. Any help is appreciated. In web service is it possible to expose the Constants used in the application. Let say for my web service I need to pass value for Operation, possible values for this are (ad [More]