Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Finance, Invoicing and Integration

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
17%
500 - 800 GB
6%
800 - 1200 GB
6%
1200 - 1500 GB
17%
1500 - 2000 GB
17%
> 2000 GB
22%
Total votes: 18

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 18th January 2003, 09:48
amarpreet's Avatar
amarpreet amarpreet is offline
Senior Member
 
Join Date: Jul 2002
Location: Chandigarh India
Posts: 124
amarpreet is on a distinguished road
Baan: BaaN IVC4 - DB: PL-SQL - OS: Windows NT
Aging Analysis by supplier

Hello everybody.

I am totally unaware of finance module & posting this thread onbehalf of my accounts department.

Our accounts department generates an aging analysis report thru session tfacp2420m000 & get the report in a no of formats.

There are always some receipts not posted to finance & accounts wants a againg analysis report which should also include unposted receipts.

i.e. Is there any standard report which include aging analysis by supplier (with posted transactions & unposted transactions)

This may be one of the absurd thread but please suggest something. Infact I don't know anything regarding finance module.

Thanks
Reply With Quote
  #2  
Old 20th January 2003, 09:11
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
I'm not sure what you mean by receipts not posted to finance yet. The aging analysis report only prints data which is in the open entries table in finance. Basically this is any invoices or cash in the open entries.
__________________
Regards
Maria
Reply With Quote
  #3  
Old 20th January 2003, 10:39
amarpreet's Avatar
amarpreet amarpreet is offline
Senior Member
 
Join Date: Jul 2002
Location: Chandigarh India
Posts: 124
amarpreet is on a distinguished road
Baan: BaaN IVC4 - DB: PL-SQL - OS: Windows NT
Reply

There are some purchase orders for which receipts are made but purchase invoices not printed. Also thse transactions are yet to be posted in finance.

These purchase orders are having status as print purchase invoices.

In other words our management analysis of suppliers based on receipt date.
Reply With Quote
Sponsored Links
  #4  
Old 20th January 2003, 10:50
MariaC's Avatar
MariaC MariaC is offline
Guru
 
Join Date: Sep 2001
Location: South Africa
Posts: 386
MariaC is on a distinguished road
Baan: BaanIV, BaanV, BaanERPLN - DB: SQL, Oracle - OS: Unix, Windows
There is a report tfacp1432m000 which shows orders which have been received but have not had invoices entered in Finance.

Invoices for purchase are entered manually though finance and are not posted through integration. As far as I know there is no way to age receipts which have no invoices.
__________________
Regards
Maria
Reply With Quote
  #5  
Old 27th January 2003, 09:16
julisb's Avatar
julisb julisb is offline
Senior Member
 
Join Date: Aug 2001
Location: NRW, Germany
Posts: 137
julisb is on a distinguished road
Baan: IVc4 - DB: Oracle - OS: Unix, NT
Maria is right, there is no possibility to see the receipts in the aging analysis because there is no booking on liability account for it.

regards, Juli
__________________

--------------------
The illusion of our life is, that the next hour is not the last one.
Reply With Quote
  #6  
Old 29th January 2003, 08:31
Rajnish Goyal's Avatar
Rajnish Goyal Rajnish Goyal is offline
Junior Member
 
Join Date: Apr 2002
Location: India
Posts: 20
Rajnish Goyal is on a distinguished road
Baan: Baan IV c4 - DB: informix - OS: NT, Unix
first of all i need some clarifications

1. Do you want to see the outstanding of suppliers or customers?

2. If it is in case of suppliers, there will be no receipt from suppliers?

3. what do meant by posting or unposting? is this finalised or unfinalised transactions?
Reply With Quote
  #7  
Old 29th January 2003, 08:43
amarpreet's Avatar
amarpreet amarpreet is offline
Senior Member
 
Join Date: Jul 2002
Location: Chandigarh India
Posts: 124
amarpreet is on a distinguished road
Baan: BaaN IVC4 - DB: PL-SQL - OS: Windows NT
1. I want to see outstanding of suppliers with aging.

2. Receipt if made against a purchase order generated against a supplier (Vendor)

3. I want to include those purchase receipts having purchase order status as

1. Maintain receipt - Yes

2. Maintain approval - Yes or No

3. Maintain CENVAT Receipts - Yes or No

4. Print Purchase invoice - Yes or No.

More clearly I want to include purchase order having status as any of above.

Also there is one field matched as tdpur045.matc in tdpur045. I want to include the receipts having status as no.

Thanks for extending me an helping hand. Our management wants to have an debtors included in aging as soon the material is received in factory premises rather then the party's bill is booked in finance.
Reply With Quote
  #8  
Old 29th January 2003, 10:13
Rajnish Goyal's Avatar
Rajnish Goyal Rajnish Goyal is offline
Junior Member
 
Join Date: Apr 2002
Location: India
Posts: 20
Rajnish Goyal is on a distinguished road
Baan: Baan IV c4 - DB: informix - OS: NT, Unix
1. When you make a Receipt against a PO, there is no financial document generated ( only inventory entry is passed, inventory dr & PBR Cr).
2. In supplier aging only those docoument comes which are passed in finance module. (when purchase is match and approved, payment to supplier etc.)

So as per your requirement this is not feasible to see all the documents.


You can customise your own report.
Reply With Quote
  #9  
Old 29th January 2003, 10:18
Rajnish Goyal's Avatar
Rajnish Goyal Rajnish Goyal is offline
Junior Member
 
Join Date: Apr 2002
Location: India
Posts: 20
Rajnish Goyal is on a distinguished road
Baan: Baan IV c4 - DB: informix - OS: NT, Unix
as per your query regarding that your management wants that creditors updated as soon as material comes in side the premises

this is already happening, might be you have not studied the entries of receipt

when any receipt is made the entries are generated like this


Material Debit


Purchase bill to be received credit
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
data missing on aging analysis report jpadilla Finance, Invoicing and Integration 2 24th July 2004 03:50
balance 0 but supplier shown in againg analysis summary amarpreet Finance, Invoicing and Integration 9 24th April 2003 13:55
supplier balances are not equal to balance shown in supplier aging Rajnish Goyal Finance, Invoicing and Integration 5 14th May 2002 14:08


All times are GMT +2. The time now is 14:59.


©2001-2018 - Baanboard.com - Baanforums.com