Tag Archives: sage

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 »

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 »

VIN Allocation Against the order for Automobile Industry

In our previous blogs for auto mobile we had discussed about how we can store the details of the VIN number.Storing unique attributes of vehicle by VIN for automobile industry In automobile industry, every VIN or chassis has its unique attributes and at times there are special changes made to the vehicle, and hence it… Read More: VIN Allocation Against the order for Automobile Industry »

Vendor Outstanding Report by Optional Field Value in Sage 300 ERP

Optional Field is one of the best features in Sage 300 to capture various information at any level. It means we can link the Optional Fields at Masters as well as Transaction Level though the optional Field cannot be linked to the Bank Services (For Masters as well as Transactions). By using this feature we… Read More: Vendor Outstanding Report by Optional Field Value in Sage 300… »

Restrict users access of modifying the GL Imported batches in Sage 300

General ledger is one of the primary components of accounting. Hence G/L Batches are crucial activity as it enables the user to keep control over all the transactions of any enterprise. In some cases G/L batches are created as a non- Sage ERP Accpac program i.e. imported batches & you want to restrict the users… Read More: Restrict users access of modifying the GL Imported batches in… »

Inquiry tool in Sage 300 web portal

Sage 300 web Portal has a new advanced feature called the “ADHOC Query Tool” where we had query templates for A/R customers & Transactions, A/P Vendors & Transactions, G/L Accounts & Net changes, G/L Account & Transactions, IC Transactions, O/E Transactions & P/O Transactions. Through specific filter criteria a user can add multiple filters according… Read More: Inquiry tool in Sage 300 web portal »

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 »

G/L Integration in A/P module with options for creating G/L transaction by (Creating and Posting a New Batch)

General ledger is one of the primary component of accounting. Hence G/L Integration is a crucial activity as it enables the user to keep control over all the transactions of any enterprise. All the transactions flows from various modules to the General ledger. Sage 300 enables the administrator to configure the G/L transaction settings. Creating and… Read More: G/L Integration in A/P module with options for creating G/L… »