Diff xists betwn 2005B n 2007B

[Former Member]

Hi,

there xists diff betwn 2005B n 2007B which are affecting some technical customization works, like a query with optional date parameter in 2005B is not behaving in such with 2007B. again some stored procedures are not working as b4 in 2005B when now being in 2007B. Have any one who uses 2007B noticed such irelavant actions? Kindly share ur points wat can be done in order to rectify it any way?

thks,

[ladislav_meszaros · Accepted solution]

Dear Shivanesh,

I believe your issue is related to modification made in the Business One stored procedure SBO_SP_TransactionNotification.

Please, notice that the Field type of the Object_Type in SBO_SP_TransactionNotification was changed from previous versions from Int to nvarchar. The error you are getting seems to be related to this Object_Type.

In releases earlier than 2007 A, the system ignored errors which occurred as a result of contradiction between field type in application and field type in the stored procedure. In Release 2007 A, such errors are handled properly.

The documentation regarding the SBO_SP_TransactionNotification procedure can be found in the following link:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/e991e2b9-0901-0010-0395-ef5...

See page 6 from this documentation:

Important Note for 2007 version

With the release of SAP Business One 2007, Business One will wait for the SBO_SP_TransactionNotification stored procedure to return both parameters @error and @error_message as return values. Without the return of these values, SAP Business One will consider the transaction as failed.

See also SAP Note [967470|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=967470] and SAP Note [841475|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=841475] for more detailed information.

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[former_member187989]

Check this notes

Note 1104866 - Central Note for SAP Business One 2007 B

Note 1131218 - Error Msg: Reconciliation amount must be less than balance

Jeyakanthan

[K_Pauquet]

Hi Shivanesh,

please refer to the 2007B landing page for delta info:

http://service.sap.com/smb/sbo/2007b

All the best,

Kerstin

[ladislav_meszaros]

Hi,

In Business One Version 2007 when you run the query and you do not choose any value for the date variable, SAP Business One assigns the value 01/01/1900 (January 1st 1900) as a default value instead of leaving the variable with the empty string ('').

As a result, some queries that used to return results for this case in previous releases, do not return any result and display the following message: No data was found as a result of the selection criteria.

Example of a query that used to return records in 2005 A SP01 or previous releases:

SELECT * from POR1 T1 where T1.ShipDate <= '[%1]' or '[%1]' =''

To reach a correct functionality of query please modify it as following:

SELECT * from POR1 T1 where T1.ShipDate <= '[%1]' or '[%1]' ='19000101'

Please refer to SAP note no. [1237002|https://websmp130.sap-ag.de/sap(bD1odSZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=1237002]

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[Former Member]

dear Ladislav,

can you similarly gimme any example for the Stored procedures too? i hav noted the procedures working properly in 2005B where as throwing error during the event in 2007B like 'Stored Procedure must return a value'

have you noticed? if so plz help me...

Thks,

Shiva.

[Former Member]

Dear Ladislav,

Thks for your valuable info. Will refer those n revert back.

Sincerely,

Shiva