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: How to Calculate Current Quantity on Hand on Custom Reports… »
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: Custom Report would not print even after setting Customization Directory… »
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: How to handle Commission Sales in Sage Accpac ERP? »
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: GL Listing report – Summarized by Accounts »
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: Greytrix TDS for Sage ACCPAC ERP now with Manual TDS… »
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: Sage ACCPAC ERP checks your postings »
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: Customized OCX on Installation does not open up instead just… »
If you ever come across a situation where you have a custom routine that is designed to use XAPI License, but actually when executed the program still uses a LanPak License while creating an XAPI session. This means the workstation is not set or configured to use IAP users… Below is where you will find… Read More: LanPak License getting used to create a XAPI Session »
Well Average costing and FIFO costing has their own value, are equally important and have their own advantages. It depends on how they are used in various companies. However here we shall understand the difference between Average costing method and FIFO costing method when they are used in business? Rather how do average and FiFO… Read More: Average Costing Method Vs FIFO Costing Method Vs Sage ACCPAC… »
Recently while working on OE Picking slip’s customization for a client we recorded a macro for Print Picking Slips routine, but when executed, the macro would just print a blank report. On further investigation I figured out that problem is due to Parameter “SESHNDL” (below is the code of recorded Macro) [SNIP] Dim rpt As… Read More: Macro recorded to printing Picking Slips prints blank report »
