Tag Archives: sagex3

How to print comments data longer than 250 characters on Crystal Reports at once in Sage X3

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. At times, users encounter an issue where they input comments in the comment section exceeding… Read More »

Working with Crystal Report connector in Sage X3

In Sage X3, there are several ways to build reports, whether using the in-build query tools or deploying external crystal reports in the application server folder. External crystal reports provide so much freedom of design choices to the developers to build complex reportings for client’s requirement. However, when working on a Live production environment, access… Read More »

Auto-attachments tagging routine customization in Sage X3

In Sage X3, one of our client’s requirements was to have a way to get their attachments auto-tag to their respective transactions in a regular interval of time. For this we’ve developed a customization in place that’ll not only fulfill the requirement with minimal user efforts but also take in consideration of several validations and… Read More »

How to solve the error@“Field BPAADD(Alphanumeric) : mid$ Function not defined for the value given” when extracting the Excel export from the Purchasing Receipt Line Inquiry screens

Sage X3 is enterprise resource planning (ERP) product which help organization to manage all the operation of organization and database into a single software solution. Sage X3 contains list of modules like sales, purchase, inventory, project, financial and many more. One of our clients is encountering an error “Field BPAADD(Alphanumeric) : mid$ Function not defined… Read More »

Disabling access to transactions using 4GL in Sage X3

Many times we need to restrict access for transactions based on some requirement and for doing that Sage X3 provides ways from application setup. However, we as developers also have control with the 4GL (Safe X3 console language) to add more in depth conditional requirements which sometimes with setup is not achieved. To know more… Read More »