Sage BusinessVision 2023 - AP_TRANSACTIONS.REF_NO - 25 Character Field limited to 10 chars in the front end GUI

Question

AP_TRANSACTIONS.REF_NO has a 25 character field limit, however the use of this field has been limited in the BusinessVision front end GUI to 10 characters. 
 It appears that this is because the cheque number field in system setup is limited to 10 characters. 
 This can often be problematic when recording vendor payments with a reference number longer than 10 characters which is often the case with digital payment systems. 
 See images attached.

Erzsi_I · Answer

Hi LanceRock , 
 Thank you for your patience and our apologies for the delayed response. 
 To address this issue, you might consider creating a custom solution using ODBC to handle longer reference numbers. You can access the database structure, which will assist you in understanding the tables and fields within Sage BusinessVision, by following these steps : 
 
 Click Start , go to All Programs, find Sage BusinessVision, and double-click on Database Structure Help. 
 Alternatively, navigate to the C:\BusinessVision\Help folder on your server or main computer and double-click the B usinessVision Database Structure Reference.chm file. 
 
 This reference will allow you or your developer to see the database schema and might provide a way to customize your reports or data access to accommodate longer reference numbers. 
 We also recommend reaching out to our support team for assistance in case there has been an update or workaround since your initial post. They may also be able to help if a software update has addressed this limitation. 
 For any further assistance or to discuss this issue in more detail, please do not hesitate to get in touch with our support team. Warm Regards, Erzsi

Sage BusinessVision

Sage BusinessVision 2023 - AP_TRANSACTIONS.REF_NO - 25 Character Field limited to 10 chars in the front end GUI

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING