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).

Configuring Document Numbering for Sage 300 ERP

This is in continuation to our earlier blog where we discussed about our Document Numbering for Sage 300 ERP (aka Sage ACCPAC ERP ).Just to summarize again, Document Numbering Series add-on empowers Sage 300 ERP users to setup distinct numbering series add-on empowers Sage 300 ERP users to setup distinct numbering series for each set of transactions by various criteria such as by Account Sets, Location, Fiscal dates etc.

It is a user friendly Interface and very simple to process for configuration.

After activating the Document numbering module from the Data activation screen, you would be able to view the Document numbering option under Common Services.

 Document numbering module is easily configured under two heads i.e. Numbering Structure and Numbering Mapping.

1      Numbering Structure:  The add-on provides an easy option to form document number structure which consists of different segments name such as Prefix (Document Type), Fiscal Year, Location etc. Each segment can be configured as per the users need with the help of Separators like hyphen, Asterisk etc.

2      Numbering mapping: After setting up the required document structure; user needs to map them to appropriate document type. Numbering will only be active for a particular document if it is mapped here.

With the help of these two simple options, one can easily configure the Document numbering module for further use.

Reverse Remittance Entry Option in the Greytrix TDS Utility

TDS plays an important role within different sections of Indian Market, and almost every Individual/Company is liable to pay TDS to the government.

The TDS Deduction and Remittance process are easily followed by the Greytrix TDS users but the problem occurs if we need to reverse the TDS once the document is already remitted.

There are several occurrences when we deduct the TDS against a vendor and even selected the document for the Remittance purpose. Now as seen in the below screen shot the document has appeared within the remittance Entry.

Now for any reason if the user wants to remove the Transaction from the Remittance i.e. make the document available for Remittance again.

We have made this option easy in the Greytrix TDS utility, where in we have provided the “Void Remittance” button in our Greytrix TDS utility which will help you to reverse the remittance entry. This feature will make all the documents within the Remittance available for the Remittance again.

Below screen shows the Void Remittance button: -

Adding Additional Costs to Inventory When They Are Not Known At Time of Receipt in Accpac:

It is often identified that custom clearing agents or freight and insurance handlers do not bill the charges at the time of delivery of goods but send an accumulated bill on a monthly basis and then it becomes a headache for company to prorate it to inventory that is already shipped or consumed.

Then the company is left with following alternatives:

1.       To not to prorate the cost to inventory and directly add it to Cost of Sales at the end of year, hence compromising the costing effect.

2.       Wait for making the stock receipt till the time we receive a bill from vendor, which is not very practical.  To struggle and convince the vendor to send bills at the time of delivery, which your vendor might not agree to do.

Another alternative is to create a provisional vendor in Accpac Accounts Payable module for the purpose of prorating an approximation of additional costs on Inventory and then adjust the costs when the actual ones are known.

Let’s see in detail how this is accomplished:

Firstly we need to create a Provisional Cost Vendor Group and Account Set and Vendor in Accounts Payable module where the account set will link it to an account in General Ledger for Provisional Cost Vendor. Now go ahead and create the receipt selecting Provisional Cost Vendor (Let’s name him PR01) PR01 and put in the approximation of additional costs which is generally known to Accounts Team by experience. Then the respective Invoices against Material vendor and Provisional Cost Vendor shall be made.

	Dr	Cr
Inventory	100
Material Vendor		100
Inventory	30
Provisional Cost Vendor (PR01)		30

Next, when the actual invoice is received from your Additional Cost vendor, book it on the name of vendor (Let’s name him AD01) AD01 in Accounts Payable Module as a summary type invoice, and select the GL created as ‘Provisional Cost Clearing A/c’ under Income Statement.

	Dr	Cr
Provisional Cost Clearing A/C	40
Additional Cost Vendor (AD01)		40

Now to reduce the payable for Provisional Cost Vendor and increase the same for Additional Cost Vendor, pass a Credit Note/ Adjustment entry in Accounts Payable module while selecting the invoice created through PO Module and selecting the same ‘Provisional Cost Clearing’ account to be credited.

	Dr	Cr
Provisional Cost Vendor (PR01)	30
Provisional Cost Clearing A/C		30

Finally to adjust the difference between approximate and actual additional cost, create a GL-JE debiting Provisional Cost Clearing and Crediting COGS or Cost Variance account.

	Dr	Cr
COGS/ Cost Variance	10
Provisional Cost Clearing A/C		10

This way the inventory costs for each delivery can be identified and then added to COGS at the end of year.

Hope this helps ease your work.