Tag Archives: Sage300

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 »

Barcode integration with GRN Screen in Sage300

Use the Receipt Entry screen to: Enter receipts of goods into Purchase Orders—for inventory or non-inventory items. Edit existing receipts. Enter or change the vendor address information. Enter additional costs for receipts (from primary or secondary vendors). Invoice receipts and additional costs. New Stuff: Customized UI for Export Sales Details in CSV Format In this blog,… Read More »

Significance of “Format Phone Number” checkbox of “Company Profile” screen

Many companies follow the (XXX) XXX-XXXX format for the 10 digit Telephone Number and Fax Number. For example, (123) 456-7890. The Sage 300 ERP provides the facility to format the 10 digit Telephone Number and Fax Number in the (XXX) XXX-XXXX format. New Stuff: Vendor Outstanding Report by Optional Field Value in Sage 300 ERP… Read More »

Significance of using Default Posting Date option of I/C Options in Sage 300 ERP

The posting date is the transaction date used by Day End Processing in Inventory Control when it creates journal entries for the general ledger. The posting date determines the fiscal year and period to which transactions are posted in the G/L. New Stuff: Password Protecting the Sage Intelligence output Book In Sage 300 ERP we… Read More »

AR Options — Customer National Account and Group Statistics — Include Tax in Statistics in Sage 300 ERP

In our previous blog we discussed about “Allow Edit in Statistics in Sage 300 ERP”. Extending the discussion further we will now see how to Include Tax in Statistics for Customer National Account and Group Statistics under AR Options. New Stuff: Change Document Number, Document Date and Posting Date of OE Shipment and OE Invoice before… Read More »

Change Document Number, Document Date and Posting Date of OE Shipment and OE Invoice before creating it from Order Entry Screen

In our previous blog Order Entry Transaction flow in Sage 300 ERP, we have discussed about sales flow in Sage 300 ERP. In that blog, we have an overview on Creating O/E Entry, O/E shipment Entry and O/E Invoice Entry by Single Transaction. New Stuff: A/R Options — Allow Blank Comment Type Many times the… Read More »

Significance of using Default Posting Date option of O/E Options in Sage 300 ERP

The posting date is the transaction date used by Day End Processing in Inventory Control when it creates journal entries for the general ledger. The posting date determines the fiscal year and period to which transactions are posted in the G/L. New Stuff: Migrate Sales Order Shipment from Sage Business Vision to Sage 300 ERP… Read More »