Tag Archives: Receipt Lines

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: How to solve the error@“Field BPAADD(Alphanumeric) : mid$ Function not… »

User Restrictions on Purchase Inquiry Screen

In Sage X3, Users can check all the purchase related data using inquiry screens. But there is one drawback of this functionality that any user can check the data of all the other users also using inquiry screens. To overcome from this drawback, we did customization on Purchase Inquiry screens. By doing which users can… Read More: User Restrictions on Purchase Inquiry Screen »

How to get an Open PO Amount using inquiry screens in Sage X3

At first, we will see, what is an Open PO Amount? After creating GRN/Receipt against Purchase Order, remaining amount of PO i.e. (Total PO Amount including Tax – Total Receipt/GRN Amount including tax) is the Open PO Amount. That means Open PO Amount will be calculated until that PO is open. If PO is closed,… Read More: How to get an Open PO Amount using inquiry screens… »