Using BOM and Assembly to Convert Items in Sage Accpac aka 300 ERP

The other day we were discussing Sage 300 for a prospect in Fabric industry and came across a requirement where they needed to convert a roll of fabric into multiple pieces. The simple solution provided was to have more than 1 UOM (Units of Measure) defined for the same item and then based on the conversion unit transact the item in both the units Roll and Pieces. However, they insisted on maintaining the item separately for Roll and Pieces. Now this situation can be handled using the BOM and Assembly functions of Accpac aka Sage 300.

Listing down the steps on how to define BOM (Bill of Material) and then assemble an item (Raw Material) to form finished good.

Go to Inventory Control Module and select Bills of Material under I/C Items and Price Lists. Select the Master Item as the item to be prepared as the finished good, which in this case will be Fabric Pieces. Assign a BOM number, Fixed and Variable costs that can incur in the conversion of roll into pieces. Fill in the build quantity as the no. of pieces that can be made using 1 unit quantity of roll (e.g. 10 pieces of 1 meter each if the roll is of 10 meters.). Select the Component item as Roll, enter the Unit Quantity (e.g. 10 Meter) and then save this BOM.

Now whenever a conversion is to be done, go to I/C Transactions> Assemblies and select the Master Item number, Location and Build Quantity and then run the assembly. This will convert 1 roll of fabric (say 10 meters) into 10 Pieces of fabric (say 1 meter each).

The benefit of using this process is that you can program the system to take care of the costing of cut-pieces based on the cost occurred in procuring the role.

On top of this, you can also record the loss of fabric due to the cutting process involved by entering the actual quantity in build quantity. (e.g. 1 roll converts into 9.7 pieces – provided you have allow fractional quantities checkbox on) and also if there are any fixed or variable costs involved in the process, they are taken care of.

This process will help you keep a more detailed track of stock that you own in different UOM and also automate to add the conversion costs and wastages to finished goods.

Hope this helps. Keep visiting for more.

Greytrix TDS v2.2 for SAGE 300 ERP

Sage 300 (formerly Sage Accpac ) ERP has flexibility to support the unique needs of multi-site and global organizations. For global organizations with offices in India we have developed a must- needed Tax Solution "Greytrix TDS (Tax Deducted at Source ) for Sage 300 ERP"

Get ready for a First look of our Greytrix 300 (Accpac) ERP with enhanced features. in this version Greytrix TDS ( Tax Deducted at Source) modules will be available in portal with all these features.

Tax deducted at Source is an add-on for Sage Accpac ERP enabling organizations to maintain complex requirements on Tax Deducted at Source and generates reports and forms required by the Central Government including eTDS file. Tax deducted at Source automates your tax deduction calculations under various sections and slabs and provides you comprehensive, accurate and detailed reporting.

Overview of enhancement of Greytrix TDS portal:  

Below Image show the user interface links of Greytrix TDS provided in the Sage 300 Portal.

You can easily Generate TDS related Reports like:

1.       Form 16A

2.       Form 26Q/27Q

3.       Deduction and remittance

4.       TDS challan

5.       E-TDS quarterly return

Lets now see the shortcut navigation tab of Greytrix TDS for Easy access of User Interface in Sage 300 ERP Portal

Now lets look at User Interface of “Nature of deduction” from portal.  User can easily access the entire screen same like earlier version of TDS but with new advanced look.

Do provide us with you feedback/suggestion on sage@greytrix.com . We would be glad to make additions to our existing list.

TDS Cumulative cutoff Deduction

TDS has significant importance in Indian taxation system and every Individual/Company need to pay TDS to government. We are providing a brief explanation on handling of Cumulative Cutoff while operating the Greytrix TDS utility. 

Cumulative cutoff:

 If you check the cumulative cutoff check box then program will consider this section as under cumulative cutoff. You can define cumulative cutoff amount in NOD screen for those TDS section which are belonging from this categories. Refer the below screen shot.

Whenever we define a Nature of deduction with a cumulative cut off section we need to set a particular amount as cumulative cut off limit [refer the below screen shot]. As per the cumulative cut off section rule it says that all the documents which lie below the cumulative cut off amount do not qualify for TDS deduction.

But when any Invoice against the same vendor is created such that the sum of all the previous documents and the current one exceeds the cumulative cut off limit in that case deduction is done on the entire summed up amount.

For example consider VENDOR V0001 is under the NOD which has cumulative cut off section applied against it. Consider, cumulative cutoff amount is RS 30000, in this case if you create 1^st invoice of RS 25000. TDS amount will not be deducted for this invoice. But, if you create a document of RS 6000 then sum of all the documents results in to 31000 and this has exceeded the cut off limit along with the previous document. So, TDS amount would be RS 3100 if TDS percentage is 10.

Note: Suppose you define the cumulative cutoff as RS 30,000 and also you have provided the TDS percentage amount [e.g. 10] for range 0-30,000. In this case program will not consider this NOD as under cumulative cutoff. TDS will be deducted for all documents which are belonging from this NOD.

Read more

An affordable End to End solution for SME ERP Needs

Are you encountering the following business issues?

• Decision making process is Based on Inconsistent, incomplete or non integrated
  Financial, Manufacturing, Inventory and Operational Data
• You are banking on a low end accounting software worth a few thousand to run
  operations of an organization worth Crores
• Your business analytics system consists of working with Excel sheets
• You do not have any idea as to how much items you have, its costing or where
  are they located.
• You want to use a globally recognized sophisticated system but pricing is not for
  SME’s and it does not support Indian Taxes and Special reports.

Sage ERP and CRM: An affordable solution for you automation needs

The Sage Accpac (Enterprise Resource Planning) ERP system is, at core, a sophisticated,robust accounting and operations system for small and midsized businesses and Sage CRM is for Marketing, Sales, and Customer service teams.

A system which will take care of all your business pain points.

Prices starts at just a few including implementation. Schedule a request to discuss the problems which you have and you will receive a solution along with the demo before you actually buy the system.

MODULES

Inventory Control
Accounts Payable and Receivable
Sales/Purchase Orders
General Ledger
Project Management
Manufacturing
CRM Sales/Marketing
TDS and Excise
Financial Reporter
Business Intelligence
Manufacturing
Service Management