Tag Archives: Sage300

Smart Healthcare Billing Integration with Encounter Numbers in Sage ERP.

Our Healthcare service client use hospital software to manage their daily medical transactions, while the hospital’s accounts department uses a separate ERP system to maintain financial records. Therefore, it is essential to establish integration between the healthcare service departments and the accounts department to ensure that daily billing transactions are recorded accurately in the ERP… Read More »

Location Mismatch Warning on Order Entry screen

In Sage 300 ERP, Order Entry Screen is used to place orders for different locations against customers. Basically, Locations defined on Order Entry screen for Header field flows directly to detail level Location. But sometimes Items may not be available for few Locations or Users are not supposed to pick items from such locations. In… Read More »

Error: Permission Denied while making OCX

Sage 300 provides an SDK using which a developer can customize an existing OCX screen. This customized screen needs to be upgraded with a higher version of sage 300 when you upgrade your Sage 300 to higher version. While upgrading this customized source code with a higher version and making the OCX, sometimes we can… Read More »

How to use CSQRY using .NetAPI in C#

CSQRY CSQRY is the View CS0120. It basically takes SQL Query as the parameter to its Browse method and then returns the records via calls to Fetch. CSQRY is easy to execute general SQL statements through the Sage 300 API. This way we don’t need additional database credentials and don’t need to use an alternate… Read More »

Date of last Day End Run on IC Day end processing Screen in Sage 300 v2018

Use the I/C Day End Processing screen to: Update costing data for all transactions (unless you chose the option to update costing during posting). Produce general ledger journal entries from the transactions that were posted during the day (unless you do item costing during posting or create G/L transactions using the Create G/L Batch icon).… Read More »

New features and improvements on OE Invoice screen in Sage 300 v2018

Overview of OE Invoice Screen Use the O/E Invoice Entry screen to enter prepayments, and to enter, post, print, and export invoices. On the O/E Invoice Entry screen, you can: Enter prepayments for invoices Export invoices Print receipts (for prepayments) and invoices immediately after posting Customer Tab Use the Customer tab to specify information about… Read More »