Category Archives: Sage 300

Migrate AR Payment from Microsoft GP to Sage 300 ERP

Greytrix is a pioneer in providing migration services at its Sage Migration Centre and catering end-users business requirements. Data migration is always a challenging task to perform. We migrate data with our well defined migration process. In this blog we will discuss about how AR Payment are migrated from Microsoft GP to Sage 300 ERP (Formerly known as Accpac).… Read More: Migrate AR Payment from Microsoft GP to Sage 300 ERP »

Shipment quantity status

Greytrix has developed one custom report which allow user to track the OE shipment data by Customer/Location/Item number. This report is showing the shipment quantity status by date and by fiscal period of the current year. New Stuff: Inventory Status Report as of date While maintaining the sales of the company it is very difficult task… Read More: Shipment quantity status »

Inventory Status Report as of date

An inventory control system is a system that encompasses all aspects of managing a company’s inventories; purchasing, shipping, receiving, tracking, warehousing and storage, turnover, and reordering. The Inventory control system is maintained by every firm to manage its inventories efficiently. Sometimes it is crucial to check the status of Stocks as of date for each warehouses. Greytrix has developed one custom… Read More: Inventory Status Report as of date »

Locate No. of Shipments in Sage 300 ERP for an Order

Sage 300 provides a functionality where user can create a shipment of an order according to the required Item and its quantity. Sage 300 also allows to create partial shipment of an order. Shipment can not be deleted from Sage 300 company so alternatively, it has an ability to set the Quantity Shipped  to zero… Read More: Locate No. of Shipments in Sage 300 ERP for an… »

Simplified AP Invoice Report in Sage 300

Enterprise Resource Planning is a type of software that connects day-to-day business process including order management, inventory and customer relationship management. The main application of an ERP Software is to collect and organize data from various levels and provide the management with a clear picture of profit and loss. New Stuff: GL Report with Source Document… Read More: Simplified AP Invoice Report in Sage 300 »

Validation on Financial Registration Numbers as per defined norms

In the previous blog we have seen details about auto generated vendor number on Vendor Master Screen for reference – new Stuff :-Auto Vendor / Customer Code Generation in Sage 300 ERP Continued with the same have done customization on the same vendor master screen for exact validation of GSTIN & PAN No according to… Read More: Validation on Financial Registration Numbers as per defined norms »

GL Report with Source Document Tax Amount

General ledger is a very important module of an ERP system. It contains the company’s assets, liabilities, owners’ equity, revenue, and expenses. This module contains the company’s accounting records. The GL holds the financial transactions of the company. This module contains the detail information that is necessary to prepare the ledger reports, liabilities etc. For… Read More: GL Report with Source Document Tax Amount »

How to find the list of Shipments for the shipped Items in an Order

In the last blog, we have discussed about “How to locate No. of Shipments in Sage 300 ERP for an Order” where user can find the number of Shipments created for an order. As we have discussed that Sage 300 provides a functionality where user can create a shipment of an order according to the… Read More: How to find the list of Shipments for the shipped… »

Hide Completed Lines in OE Invoice Entry Screen

There may be a scenario where the user may not invoice the entire inventory for shipment. There will also be a scenario where the user reviews the invoice after the shipment but the partial shipped lines are also visible on the invoice details. In this case, the user is unable to easily locate between fully… Read More: Hide Completed Lines in OE Invoice Entry Screen »

Import AR Invoice with Web API in Sage 300

Web Services API plays a very important & vital role in Sage 300 as we can import/export bulk data entries at one time. We have created new API for user to create AR Invoice Entry in Sage 300 and all the parameters of the entry will be imported from XML Structure Code. New Stuff: Order Integration… Read More: Import AR Invoice with Web API in Sage 300 »