Have you ever come across a collation problem in regards with Shoper, like ‘Cannot resolve the Collation Conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AI” in the equal to operation’?. If yes, then this article will help you understand the basics of Collation and how to resolve this issue permanently. A Collation is a set of rules that… Read More »
Like any other business application, Sage Accpac ERP also provides proper warnings and confirmations to users for accuracy of Data. Though these messages are for the benefit of the users, few (Power Users) find them annoying and often complaint about wastage of time. As they are confident of the changes they are making and just… Read More »
Tally Shopper integrates with Sage ACCPAC ERP using Greytrix Shopper Bridge which syncs the Shopper items into Sage ACCAPC ERP without doing any manual import & export. In this process we will first create the items in Sage ACCPAC ERP. In items there will number of optional fields one which can be your unique field… Read More »
We all know that certain fields that are available in Accpac Views are calculated fields and not stored physically in SQL table. So sometimes when we want these fields on our reports we don’t get them as reports directly access the SQL tables and not the views, so we have to write our own calculations… Read More »
If you are using Customization Directories to print different Custom reports for Specific users in a particular company. But instead of printing the custom report placed in the PATH specified Accpac continues to still print the Standard report. Well in this case here is something that you must know. The custom Path that you specify… Read More »
You are a Trader and you ask your Vendor to Ship goods directly to your Customer against the PO raised by you with him. Hence you don’t physically receive the goods but your customer does and your vendor raises Invoice directly to your Customer, after the Customer pays your Vendor, you raise a Commission Invoice… Read More »
As you know Out Of the Box GL Listing Report displays information like Credit, Debit, Net changes and Balances with Batch Entry Details grouped under Accounts in the selected range. Recently we received a requirement where they wanted to view this information at Account Level. What we did is we parameterized the report to display… Read More »
Greytrix has developed a module in Sage Accpac ERP to handle withholding tax [termed as TDS, Tax Deducted at Source] in INDIAN localization. The Greytrix TDS module for Sage ACCPAC ERP automatically calculates TDS amount on the document and deducts the TDS while the posting is done. In some cases it happens that the user… Read More »
Posting Transactions to locked Period: When it comes to posting of transactions in ERP users are always in want of controls specially the finance controllers would not want users to post entries in to a period for which they are creating a Trial Balance and other MIS reports. Sage ACCPAC ERP has beautifully handled this… Read More »
Has it ever happened to you that you customized an OCX/Screen at your end and after deploying it at clients end when you try to open it you just see a Status Bar (as shown below) and the screen would never load…? If yes then you might have figured out the reason (after lot of… Read More »
