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
We are planning to implement row-level security using VPD. For that to happen, we need to capture the Windows NT userid since all the applications connect through a generic Oracle userid which will not help us. Has anyone done this before? Your respo [More]
iPhoto isn't seeing any of my pictures.  Help appreciated.If you meant to transfer the iPhone's photo library to a computer? Yes you can but you need a 3rd party tool to do that: Mac: http://www.ecamm.com/mac/phoneview/ PC: http://www.wideanglesoftwa [More]
I'm new to the IPhone. All other phones I' ve used in the past I could save sounds and use them as a ringtone. I just can't seem to figure it out with the I4. Can it be done?You can record sounds with the Voice Memos app, then sync them to your compu [More]
Hi, I have 6 ODSes which I load from 5 different flat files located on my desktop on a daily basis and a 6th file which I load once per week. All 7 files are then pushed to a cube before reporting can be done. Being the first timer on creating proces [More]
Hi, After export -> import from one workspace to another in the same database (different schema) the date display is not correct on most pages in the application. In the old workspace the appears as '26-OCT-2009' and on the new it is '26-OCT-0009'. T [More]
I have a variable, called "contentp". It get set by buttons like so: contentp = "p1"; I would like to use that variable in a path, but am not sure how. I was thinking something like the following, but get an error message. nav. + conte [More]
i download and install the ios 6 on my iphone 4s and now i can't conect my phone to a wifi network it shows a log in page that doesnt work what can i do or what is happening?Try: Settings > Reset > Reset Network Settings. If that does not work it is [More]
We have people in our company that use both version 9.0, 8.0 and 7.0. Can someone using version 9.0 save backwards so that someone with 8.0 or 7.0 can read and digitally sign the document? Thanks!Use Reduce File Size or PDF Optimize. Both can save to [More]
Hi, I'm trying to do a comparison between 2 tables but since the realtionship between them is a many --> many I need to summarise the data from each before doing the comparison I've done this before in SQL server by using temporary tables as in SELEC [More]
the page A with the primary table student, I copy page A save as page B for enhance purpose, if I need to add a few more columns on primary table student , my questions are: 1) when I add columns and built the record student, how to avoid lost the da [More]