How to transfer the stocks from Sage 300 ERP to Tally Shoper POS through Shopper Integration?

We have a provision of integrating Tally Shoper POS with Sage ACCPAC ERP recently branded as Sage 300 ERP in simple terms we have a bridge that connects the Tally Shoper POS with Sage Accpac ERP; we call this concept “ Tally Shoper Integration (http://greytrix.in/Tally-Shoper-Integration)”.

Consider a case where you have a Shoper POS installed at your various retail stores/branches s and the Sage 300ERP at your head office. The main warehouse stocks are maintained in Sage Accpac ERP and as per the requirements you transfer the stock from your main warehouse to your retail outlets/branches. 

Store locations would have to be created in Sage ACCPAC ERP as well, but in this case you will transferring the stock from Sage ACCPAC ERP to  Shoper POS installed at the retail outlets.

For the same, we carry out the purchase phase of shopper integration where in we can transfer the goods from Sage Accpac ERP to Shopper. 

In this case our first task will be to make a transit transfer from Sage Accpac ERP. In this step we transfer the goods from our main warehouse to the GIT locations. At the same time we create a CSV file which will be imported in the Shoper POS, the retail outlet user has to just take an inward of the same so that the stock gets affected at the Shopper POS level. And once we take an inward in the Shoper POS, a transit receipt is being created in Sage Accpac ERP automatically. Thus there is parallel stock is updated at all the three locations i.e. Sage Accpac ERP (Main Warehouse), Sage Accpac branch Location and Shopper POS location).

Statutory Form v6.0 for Sage Accpac v6.0 ERP

This post will be useful for our clients on Sage (Accpac)300  ERP with operations in India.

To avail concessional Tax Rates Customers/Vendors issue different types of statutory forms against their Sales/Purchases to/from a registered customer/Vendor for e.g. “C”, “H”, etc are some types of Forms.

Form C is issued by the dealer for purchasing goods from the dealer outside the state in which he resides the effect can be understood by looking at following example IF Mr. A Registered Dealer in Hyderabad (AP) wants to purchase goods from Mr. B a registered dealer in Mumbai. Mr. B who is selling the goods will charge VAT @ 4% or 12.5% on the goods if Mr. A issues him “C” Form then Mr. B should Charge him CST @ 2% so Mr. A is Saving Tax.

Just to summarize Statutory Form Module, we have provided an optional field named “FORMTYP” with 4 values listed “C”, “F”, “H” and “NA” against the AP/AR Invoices. The user can select this optional field as needed and post the invoice, and when the same data is retrieved on form tracker screen the Form Type value is fetched against the document from the optional field.

Sage Accpac ERP comprising with Greytrix Statutory Form Maintenance allows the dealer to keep a track of the various form applicable like Form C, H, etc. The add-on will allow users to maintain/track the receipt/issue of such statutory forms in an efficient way. We have also bundled this with few basic reports to supplement.

1.      Maintain Information:

• Form applicable or not for the Customer/Vendor.
• Name of the Form received.
• Form Number for each Invoice.

2.      Transact with Statutory Form for Customers and Vendors:

•  Receive the Statutory forms, from the Customers or Vendors for the particular Invoices in the date range given by the user.

3.      Print Statutory Form

•  The reporting provides flexible filtrations options of customer/Supplier No, form and to invoice dates before printing the information.

 

How to resolve: Error Code: 711

Many of our TDS clients face this issue while opening the AP Invoice/Payments Screen, below is the message popped up.

 “Error code: 711 Invalid class string. Looking for object with ProgID ” (refer below screen shot for error).

We have arrived at some conclusions regarding this cause of the issue as listed below:

• The respective file is not registered in the registry OR
• User may do not have the sufficient rights to use the AP module

To solve this error you need to do the following steps:

1. Close the Accpac, if it is in running mode.
2. Examine the user right for Sage Accpac folder, if not defined then please give the rights to the user.
3. If the operating system is window 7/window vista then make user as a power user. 
4. Execute the RegAcc.exe as administrator [you will find this in sage Accpac installable folder i.e. C:\Program Files\Sage Software\Sage Accpac\Runtime]

 Hope this helps!

How to resolve an error:- “An error (-5006: 0x80070002) has occurred while running the setup”

Most of the times, while installing/uninstalling any application, user gets an error as “An error (-5006: 0x80070002) has occurred while running the setup”. Please refer the below screen shot for the error.

This error generally occurs when terminal server may not be in the install mode. To change/switch the server in install mode, please follow the below process.

To Switch Terminal Services to Install Mode

When you want to add or remove programs, put the Terminal Services server in Install mode. To do this:

1. Click Start, and then click Run.
2. In the Open box, type cmd, and then click OK.
3. At the command prompt, type change user /install, and then press ENTER. The following message appears:
   “User session is ready to install applications.”
4. Type exit, and then press ENTER.
   Now you can add/ remove any application from Control panel. 

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.

Grouping feature in Document Numbering series

We continue our series for our Greytrix Document Numbering for Sage (Accpac) 300 ERP.

Today we will discuss about a new grouping feature to our solution. Let me explain how is this going to be used, if the company has a multi location/account set but need to generate a same numbering for a group of location and assign a different location for the other group. So to generate the numbering series, first user needs to create a numbering structure as per the requirement. (Shown in the below screen shot)

As seen in the below example there are 4 location where we can group in 2 parts.

Group1: Location 1 and Location 1A

Group2: Location2 and Location 2A

Now the demand is to assign same numbering for the Group1 and different numbering for Group2.
In that case we just need to assign Location 1 and 1A with Location Group 1 and while Location 2 and Location 2A with Location group 2.

Thus whenever system generates the numbering for any transactions having Location1 or 1A the number structure generated will be same [ditto] in continuous series. Similarly for Group2 as well. As explained above the functionality of Location Group the same thing will work for the Account Set as well.


Now whenever we will do the OE Order transactions for location 1 and 1A ; Accpac will generate the number as shown in below screen shots (as per structure code i.e. Prefix+Location +Number)

Greytrix Customer Portal for Sage 300 ERP

We are excited to announce release of our new solution Greytrix Customer Portal for Sage 300 ERP.

 Greytrix Customer Portal for Sage 300 ERP ( Sage Accpac ERP) opens a self-service access to your customers. Customer Portal of an organization gives their customers and business partners’ ability to access products information and place an order of required product from any internet enabled device. We have release Customer Portal designed especially for SME to boost their sales of product and increase services to customers.

   With the Customer Portal, you can empower your customers by providing them complete access to up to date and accurate information. It is a cost-effective solution that eliminates countless phone calls to verify the status of sales orders. By enabling your customers to make payments in the system, it will lessen time-consuming paperwork to reconcile accounting discrepancies resulting from incorrect billings and payment applications. The added convenience at your customers fingertips and the reliable automated payment entry processing result to an improved customer relationship, a sure win-win for both your business and your customers. Greytrix Customer Portal and Sage 300 ERP systems are linked to each other thereby enabling the transferral of a multitude of information from Customer Portal to Sage 300 ERP systems, and vice versa. The synchronization is automatically done, in real time. There is no need to manually import or export data ensuring accuracy of transferred data  

 KEY FEATURES 

v  Provides a shared view of data between company and customers for greater transparency.
v  Self-service access to your customers to manage their accounts.
v  Automated payment processing lessens clerical errors.
v  Reduces unnecessary administrative and overhead costs.
v  Helps you keep up with increasing sales volume while minimizing costs.
v  Online, real-time integration with Sage 300 ERP.

 View Current Orders and Order History

 The 'Order Inquiry' menu provides your customers with a snapshot of their Orders. On this menu, they can check their outstanding orders and amount, view full order history for previous orders, and preview their statements. For each order, the system provides details on the shipped quantity and Quantity on backorder.
 

  The Customer Portal also extends your billing and collection facilities by providing your customers with updated balances of their accounts online and in real time. This enables customers to review their accounts anytime and spot any possible discrepancies sooner. With this capability, your accounting department can avoid the time and expense of generating and mailing hard-copy statements to your customers.

   Hopefully this gives you an overview of Greytrix Customer Portal works with Sage 300 ERP (Sage Accpac ERP).