Tag Archives: Sage ERP 300

How to attach Optional fields to serial numbers

In our previous blog, Storing unique attributes of vehicle by VIN for automobile industry we had seen how we can store the unique attributes of a specific serial number in its serial optional fields. In the current blog we will see how we can auto insert the optional fields on serial numbers, when the serial… Read More: How to attach Optional fields to serial numbers »

Migrate AP Invoice (summary) from Sage Business Vision to Sage 300 ERP

GUMU™ for Sage Business Vision ERP to Sage 300 ERP is a Sage certified migration solution. Greytrix is a pioneer in providing migration services at its Sage Migration Centre and catering end-users business requirements. We provide data Migration Services from Sage Business Vision to Sage 300 ERP (formerly known as Sage Accpac) at our Sage Migration Center. Our GUMU™ migration utility is compatible to convert all Master and Open transactions along with Sales, Purchase and GL historical data from Sage Business Vision to Sage 300 ERP. In this blog, we will discuss about how Sage Business Vision AP Invoices (Summary) are migrated to Sage 300 ERP using GUMU™. New Stuff: Migrate PO Invoice from Sage Business Vision to Sage 300 ERP Part -I Note: During migration process, we consider all Invoices which are not created using close order as a summary type AP Invoice in Sage Businesss Vision. Navigate through the below link to check the AP Invoice (summary) in Sage Business Vision. Sage Business Vision -> Accounts Payable -> Open Items and Ctrl+N to create new summary Invoice. You can check all transaction’s records related to entered vendor id in Inquiry tab. As you can view, here we have referred the transaction of Vendor ‘OPTSYS’ and Transaction Number ‘0000203398’. To check the details of this invoice double click on highlighted invoice and select type as Invoice in select list. As shown in below screenshot. Below are the screenshots of the converted summary AP Invoice into Sage 300 data. Above screenshots shows, the converted AP Invoice (Summary) in the Sage 300 with the same details present in Sage Business Vision. After data migration from Sage Business Vision the field values of Sage Business Vision AP Invoice (Summary) get converted with the following mapping, In this way, Sage Business Vision AP Invoice (Summary) are migrated into target Sage 300 ERP company database. Greytrix helps in migrating to Sage 100, Sage 300 and Sage ERP X3 from Sage Pro, Sage 50 US, Sage 50 CA,Sage 50 Usage Business Works, Sage Business Vision, QuickBooks and MS Dynamics Great Plains.

Feature of Mask Structure for Item Serial and Lot

In this blog we will discuss about the feature of mask structure. Mask structure is very useful feature in SAGE 300 ERP. We can defined “N” number of mask structure and can use for item/s. In mask structure we can pre-define / fix the structure of serial or lot with the combination of character and… Read More: Feature of Mask Structure for Item Serial and Lot »

Intercompany Transaction

In this blog, we will discuss intercompany transactions. Sage 300 has a very useful module – “Intercompany Transaction” for organizations, who have multiple entities along with transaction being done. When a transaction is done between two companies/entities, it usually seems that two separate entries will be made. We illustrate in details for better understanding. For… Read More: Intercompany Transaction »

Storing unique attributes of vehicle by VIN for automobile industry

In our previous blog Sage 300 ERP for Automobile Dealer Industry we had given a brief introduction, now in this blog we will be focusing on how automobile dealers can retain vast data of unique vehicles on the basis of its Vehicle Identification Number or VIN. In automobile industry every single car is unique because… Read More: Storing unique attributes of vehicle by VIN for automobile industry »

Change/Control Over Due Date and Payment Limit of Vendor Invoice

In SAGE 300 a very useful feature is available called as the “A/P Control Payment”. Through which any organization can control over due date and payment limit for specific Invoice of specific Vendor. Suppose, we booked a purchase invoice of a vendor and its due date is 29-May-2015 and its Invoice value is Rs.13483.20 as… Read More: Change/Control Over Due Date and Payment Limit of Vendor Invoice »

General Ledger Revaluation in Sage 300

In Sage 300 if you are passing multicurrency transaction in your books of accounts, due to fluctuation of exchange rates of source currency you would be required to re-evaluate your general ledger. The difference between current fluctuations may be exchange gain or loss. Following are tips to configure your exchange gain/loss of your general ledger… Read More: General Ledger Revaluation in Sage 300 »

Single Invoice of Vendor with multiple payment schedule.

 In SAGE 300 a very useful feature is available, called the “Multiple Payment Schedule”, through which, any organization can have control over vendor bills due as per their defined schedule, bill wise. For example, if any organization has term with vendor that 50% of bill will get due after 30 days and remaining balance 50%… Read More: Single Invoice of Vendor with multiple payment schedule. »