Use the O/E Credit/Debit Note Entry screen to credit or debit customer accounts for returned merchandise, items not included on an invoice, and other price adjustments On the O/E Credit/Debit Note Entry screen and affect goes to as follows:- Credit customer accounts for returned merchandise, damaged items, and price adjustments. Debit customer accounts for price… Read More: OE Credit – Debit Import routine »
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, user can: Enter and post invoices Enter prepayments for invoices Export invoices Print receipts (for prepayments) and invoices immediately after posting If you use Payment Processing, process or void a credit card… Read More: OE Invoice Import routine »
In our previous blogs, we have seen that how you can import different entities in Sage 300. In this blog, we will see how you import GL Entries with simple excel format. Below is the screenshot for our import utility of GL Import Macro. The user needs to select the appropriate excel sheet and then… Read More: Generic Macro of GL Import »
ERP (Enterprise Resource Planning) is built for accounting and business. With the help of ERP, we can develop Report/customization as per client requirement. In this blog, we will discuss about Sales Order Import Macro – How to Import a record of Sales Order using Sales Order Macro. New Stuff: Display Finish Good Item on manufacturing issuance… Read More: Generic Macro of Sales Order Import »
Enterprise resource Planning or ERP is a solution for organisations to manage their business efficiently. The main application of an ERP Software is to collect and organise data from various levels and provide the management a clear picture of profit and loss. New Stuff: Material Reservation/MO Report Discussing about PO, AR, IC, GL module, let us… Read More: AR Invoice Import Utility »
Generally the automobile industries are moving towards the implementation of ERP into their organization. In this blog we will see how the service invoices can directly create into Sage 300 from another system. If a vehicle comes in a workshop for servicing, then after completion of the service, we make invoice for the total labor… Read More: Service Invoice Import Routine for Automobile industries in Sage 300 »
You must have already heard about release of Product Update 1 of Sage 300 ERP 2014. In this blog, let’s discuss one of its additional feature that has been introduced in Product Update 1 to enhance Standard Import and Export routine support of Excel 2007 (.xlsx file format). New Stuff: Implementation of bar code in… Read More: Much awaited Excel 2007 (.xlsx) support in Product Update 1… »
Sage 300 ERP has a very extensive Import Export procedure to almost all Data Entry Screens. But these need to follow certain formats and multiple worksheets., making it a bit complicated for the users to use templates to import data from a different system. For the ease of users we have developed Import-Export add-ons which… Read More: Generic Import-Export Macros for Sage 300 ERP »
Recently we integrated a POS system with Sage Accpac ERP, here we had taken care of Item Sync, Transfer of Inventory from Warehouse to Shops, Shop to Shop etc… along with importing all Sales information from each POS shop to Accpac ERP. Well this is not the topic of discussion here I will reserve this… Read More: How to execute Day End Process programmatically in Sage Accpac… »
