Go Back > Forum > Baan Quick Support: Functional & Technical > Distribution, Transportation & Warehousing

User login

Frontpage Sponsor


Google search

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

Baanboard at LinkedIn

Reference Content

Thread Tools Display Modes
Old 11th December 2002, 06:45
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
Block Sales orders if invoices are overdue

We are on BIVc4.

I am trying to block shipments to customer when the customer is having unpaid overdue invoices.

Parameter "Block if invoices are overdue " is set to YES in maintain SLS parameters.

Sytem works fine for the orders thise are created after customer is having unpaid invoices. Sales order is blocked at the time of creation of sales orders & nothing can be invoiced in the sales order.

But the problem is that system allows to process orders which are created before the date on which customer is having unpaid overdue invoices. System doesn't have any control on these orders & these can be processed without any blocking.

In the maintain order type the parameter "block as of step" is maintain deliveries.
Reply With Quote
Sponsored Links
Old 11th December 2002, 09:50
MariaC's Avatar
MariaC MariaC is offline
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
Were these orders already in the system before the blocking was set up? If so Baan only does the credit checking at time of order entry so these orders would not be blocked. Maybe what you can do is try and block these manually.
Reply With Quote
Old 11th December 2002, 10:40
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

These orders are created after the blocking was set up.
Reply With Quote
Old 12th December 2002, 11:57
robertvg's Avatar
robertvg robertvg is offline
Senior Member
Join Date: Nov 2002
Location: Hoofddorp / The Netherlands
Posts: 164
robertvg is on a distinguished road
Baan: BaaN IVc4, 5.0c - DB: Oracle 8.1.7 - OS: HP-UX 11.11
The blocking check takes place when new order(lines) are created or changed. So any order that is already beyond the step that you have set as 'Block as of step' will process normally.
Also, any order that is never touched by anyone after the customer's status has changed (there are overdue invoices) will never check the blocking conditions and thus will not be blocked.
Now, you don't want to go in every order and make fake changes every day do you ?

There are two problems in the standard BaaN logic i.m.h.o.:
1) Actually I believe the logic in the BaaN sessions is incorrect, as the blocking logic in the sessions is actually "block as *on* step", whereas I believe it to be desirable that it should be "block as *from* step"; the orderprocess should be halted as on the specified step and all further ordersteps.
Or else at least the description and explanation of the field should be more clear.
2) Besides the order status (blocked/not blocked) the sessions in the order procedure should check the current customer status: are there overdue invoices, is the credit limit exceeded ?

There is no other solution to your problem then to customize the 'maintain deliveries' session to do the check as in 2). Or have accounting department send a signal to sales and block the orders manually.

Reply With Quote

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
Sales Invoices Not appear in tfacr200 noorulhaq Finance, Invoicing and Integration 5 24th May 2004 08:10
Calling Maintain Sales Orders for Inserting .. (No source Code) baanlegend Tools Development 1 28th April 2003 16:58
Performance issue while running EDI-DNC to create Sales Orders. How I resolve? mraguthu Tools Development 0 28th March 2002 19:08

All times are GMT +2. The time now is 11:25.

©2001-2018 - -