Sage Accpac Community

Comments being dropped in Order Entry

PacBioLabs — Fri, 20 Nov 2009 13:00:49 GMT

Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:"Times New Roman"; mso-fareast-theme-font:minor-fareast; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin;} I am wondering if anybody else has experienced comments on orders being dropped from the system. We have been experiencing some random cases where people comments entered on the OE totals tab just plain vanish. We have not been able to develop a repeatable case, at the moment it appears random. This has happened 3 or 4 times in the last month. Does anybody have any thoughts what might of caused this? Thanks.

canadian payroll vacation pay accrual

Louis Ucci — Tue, 17 Nov 2009 12:31:45 GMT

I have a couple of issues. Our employees go from 4% of gross wages for vacation pay to 6% after 6 complete years of employment. I believe that Sage Accpac begins calculating 6 % after the 6th year anniversary isattained however I haven't been able to set this up. I believe it has something to do with the carry over function. Also, at our year end I have difficulty putting out a report determining my current balances for vacation pay owing. How can I improve on this. If I use our fiscal year end date as a carry over date will that mean that the totals on our check advice will be reset at fiscal year end (August) and not at calender year end? Finally, my last issue with vacation pay is how to go about paying out one accrual rate and beginning another. For example, an employee has $200 built up at the 4% rate and now has begun the 6% rate. I know I can turn off the 4% by 'do not calculate" but is there a way to coombine it under the new rate or do I have to pay out both when our employee chooses to receive his accrual. I am also worried about the accrual accruing when it iss paid out so that it never really reaches zero. Any advise on these matters would be greatly appreciated.

in-house payroll processing webcast

JanD — Thu, 19 Nov 2009 17:54:31 GMT

This one hour webcast will demonstrate how to bring your payroll process in-house. Save time and money and gain full control of your payroll process.

Thursday, December 3, 2009

11:00 am (Pacific)

2:00 pm (Eastern)

Problem with Sage Accpac ERP 5.5 - Oracle 10G, 64 Bit

Rengarajan — Thu, 19 Nov 2009 16:14:06 GMT

Hi,

We are facing a problem to setup database for Sage Accpac ERP 5.5 on Windows Server 2003 R2 (64 Bit) and Oralce 10G (64 Bit).

Database Server Configuration:

OS: Windows 2003 Server R2 - 64 Bit

Database: Oracle 10G. - 64 Bit.

Application Server Configuration:

OS: Windows 2003 Server R2 - 64 Bit

Oracle 10G 64 Bit, Client.

When we are trying to create new database, the error showing ("Unable to Connect Database (error = 99).

Note: I can able to create ODBC in Application server for the same Oracle Database. We have checked all the ways like ping ipaddress, able to connect Oracle thorw SQL *plus.

Then, in the same application server, we have installed (Oracle 10G 32 Bit Client) on application server, it was connected sucessfully.

Please provide us solution for the same.

We want to know the Performance in Oracle 10G for Sage Accpac ERP 5.5. Do you think, if the 500 Users, try to access database, is Application will be slow?

The customer is asking us to "Workstation setup in the client system".

If its slow, let me know which version of Oracle is recommended for Sage Accpac ERP 5.5

- Rengarajan

Information on Sage Accpac Intelligence

Jacqueline Li — Thu, 19 Nov 2009 14:38:57 GMT

Sage Accpac Intelligence is a new reporting/Business Intelligence tool that is being launched along with Sage Accpac 5.6.

If you are upgrading to 5.6 Sage Accpac Intelligence should be one of the pre-checked modules for you.

If you don't see "Sage Accpac Intelligence" as one of your icons on the Accpac desktop, you will need to go to Administative Services --> Data Activation and activate Sage Accpac Intelligence from there. Note that EVERYONE on Accpac 5.6 will get one license of the Report Manager out of the box!

For more information on Sage Accpac Intelligence (and other new features in 5.6) you can go get our FREE 3 HOUR TRAINING at Sage University!

Financial Reporter grouping question

tamiam — Wed, 18 Nov 2009 17:10:15 GMT

Hoping to obtain help on this tricky question. I am in a Non-for-profit where there are numerous fund balances. ACCPAC seems to have a limitation when it comes to excluding segment code ranges. This is especially useful for our Balance sheet as certain account groupings are in one area and excluded in another. Our existing report shows for example: ="751000~892300-96950", which reports on the segment code 1 and excludes the 96950 which is a segment code 2. Is there away to include ranges as opposed to excluding individuals?

Hope I'm making my question clear enough :)

Thanks for your help!

Setting up Recurring Charges

cyndgriffith — Thu, 15 Oct 2009 12:32:27 GMT

Can you set up recurring charges in O/E or is that option only available in A/R? I would like to be able to invoice customers automatically each year without having to go in and change their order from "standing" to "active" each time. Is there a way to do this in O/E? Thanks so much for all of the help I have received, you all have been very patient with my questions!

on hold field in PO report

furfrog — Mon, 16 Nov 2009 22:20:33 GMT

Hi,

Where in the PO report can I find the setting which defines that a PO is printed as blank when "On Hold" is checked?

I found that code in the report: AND ({POPORH1.ONHOLD} = 0)
But if I change it or even delete it nothing changes.

I took the above line of code from here:
//Selection Criteria Query String now build in UI and passed into @SELECTION_CRITERIA

if {?SWDELMETHOD} = "1" then //Selection partly done in UI - sortto and sortfrom is the same
(
    {POPORL.COMPLETION}=1 and
    {POPORH1.PONUMBER} = {?PORFROM} and
    (({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1))
)
else // No selection in UI
(
    {POPORL.COMPLETION}=1

    AND ( (({POPORH1.PORTYPE} = 1) AND (ToNumber({?ACTIVE})=1))
    OR (({POPORH1.PORTYPE} = 2) AND (ToNumber({?STANDING})=1))
    OR (({POPORH1.PORTYPE} = 3) AND (ToNumber({?FUTURE})=1))
    OR (({POPORH1.PORTYPE} = 4) AND (ToNumber({?BLANKET})=1))
        )

    AND ({POPORH1.ISPRINTED}=0 OR ToNumber({?PRINTED})=1)
    AND ({POPORH1.PONUMBER} >= {?PORFROM})
    AND ({POPORH1.PONUMBER} <= {?PORTO})
    AND (({POPORL.STPRINT}=0) OR (ToNumber({?DPRINTED})=1)) and

    // if delivery method is 3, always select vendor
    // else select vendors that have delivery method of mail
    (
        {?SWDELMETHOD} = "3" or
        (
            {?SWDELMETHOD} = "2"
            and
            {APVEN.DELMETHOD} = 0
        )
    )
)

GL Currency Revaluation AccPac ERP 5.5 'NO records were found to be revalued"

TimRichardson — Wed, 19 Aug 2009 02:17:31 GMT

New user.

My functional currency is AUD. I have several multicurrency bank, creditor and debtor accounts.

I want to do a GL revaluation so that the AUD equivalent on the balance sheet matches the source currency at the spot rate at the end of the month.

We use the unrealised/realised method, the one that is supposed to make reversing entries.

Whenver I try to create a revaluation batch, I get the result "Description: No records were found to be revalued". The accounts I select have foreign currency transactions (almost all from subledgers, eg AR, AP and Bank services), I force revaluation. I hope I don't misunderstand what is supposed to happen. I have, for example, an account with a Euro balance of 1118 showing up as AUD 4425, which is very wrong (I have much bigger effects in other accounts).

These problem accounts are all multicurrency. They don;t have any AUD transactions; the Euro account only has Euro transactions, the GBP account only has GBP transactions, and so on. I have one revaluation code, using spot rates. I get the "no records" message regardless of which currency I try to revalue.

Templates in PO 5.5

furfrog — Mon, 16 Nov 2009 01:32:41 GMT

Hi,

I've set up a template for PO 5.5 where I've checked the 'On Hold' checkbox.
When openening PO entry all the pre-selections from my template gets pre-filled in - thats cool.

However as soon as I select a vendor the 'on hold' checkbox gets unchecked while the rest of the choices from my template stay.
Would anyone know why and how to force it to keep 'On Hold' checked?

A Sneak peek of Sage Accpac version 5.6!

JanD — Thu, 05 Nov 2009 15:24:01 GMT

You are invited to Explore Sage Accpac 5.6 in a Free Webcast. Take advantage of this opportunity to explore what’s new in Sage Accpac Version 5.6! Whether you’re a new Sage Accpac user or a long-time expert, this FREE Webcast will introduce you to the new functionality that will save you time, cut costs, improve your workflow, and help you better use Sage Accpac to automate processes in your business.

Wednesday, November 18, 2009

10:00 am (Pacific)

1:00 pm (Eastern)

Register Today (http://inter.viewcentral.com/events/cust/search_results.aspx?cid=best&pid=2&event_id=1116&lnksrc=Community)

Windows 7 compatibility???

Gerry — Tue, 10 Nov 2009 14:25:48 GMT

We have A4W 5.5A installed with all the latest service packs. We are running pervasive server 9.5.

Are there any compatibility issues with Windows 7?

TIA

Gerry

Importing AR Invoice - Terms code cannot be blank?

Gerry — Mon, 16 Nov 2009 10:29:12 GMT

I am importing an AR Invoice. The file is an excel 2003 file. When importing I get the message

Description: Invalid input. Terms code cannot be blank

I don't have a column for Terms, and when I added a column, I still receive the same message.

We are running 5.5A with all the latest SP's.

TIA

Gerry

Sage Accpac Users & setting Backups

eranda.pre — Mon, 16 Nov 2009 02:28:53 GMT

Pls let me know how to Backup Accpac users & site.

Thanks

Eranda Peiris

ACCPAC 5.5 hangs when Posting A/P Pyment Batches only for a Particular Company

gwbennett — Mon, 09 Nov 2009 16:06:02 GMT

For a specific Company, ACCPAC hangs when Print/Posting A/P batches from a particular User's workstation.

...At the stage after acknowledging that Cheques have printed successfully, the application hangs ..ACCPAC is Ended via Task Manager

Then the User goes back into ACCPAC, does Print/Post on the batch and it ends successfully.

RVSpy & DBSpy diagnostics don't appear to indicate any issue.

This particular User does not experience any other issues when running A/P Payment Batches for any other Company and this event does not occur when staging using a Copy of the data from the ACCPAC Server.

Can anyone suggest some steps to isolate and resolve ? Thank you , George

Crystal Report Newbie

MTC — Wed, 11 Nov 2009 11:26:47 GMT

We're using Accpac 500 ERP 5.4a.

We have about 4-5 custom reports that we've always paid a guy to do. I asked him if we have the ability (software installed) to do these custom reports, and he replied that A runtime version of Crystal Reports is included with the SageAccpac system. You need the report designer to make changes.

Can someone give me some basic info as to the cost of the designer, where to get it, and how the support is to learn it?

Cheque Spec with Account Numbers

lbelanger — Tue, 10 Nov 2009 13:11:14 GMT

Hi All,

I'm am searching for a cheque spec that includes the account numbers for the Invoice (If there was one). Does anyone have a lead on such a spec? It's hard to link the APADV and the Invoice tables taking into consideration credit/debit notes, misc payments etc. I've tried a few different methods and am pulling my hair out to account for every scenario.

My thanks to any contributors.

Laura

Entering Openning balances

abdul latheef — Sat, 07 Nov 2009 10:41:23 GMT

Please explain me how to enter the vendors and customers opening balances.in sage accpac 5.5

Thank you

accpac network doesn't work

Mike — Fri, 06 Nov 2009 17:09:08 GMT

i have 2 computers to use accpac erp version 5.30 as share data.

Computer A is a server, it installed SM, GL, AR,AP,IC,OE and lan-pak. recently, the computer B needs to format and deleted everything. as a network and 2 computer share data, i have questions:

1. computer B needs to install sm, gl, ar.ap,ic oe and lan-pak?

2. if computer B doesn't need install above modules how about computer B needs to install lan-pak?

Reorder reports

jga — Mon, 02 Nov 2009 12:37:12 GMT

Does anyone have any ideas about how to do a "fuzzy" reorder report? In other words, if I have to place an order with Acme for widgets and gizmos (because they have fallen below my reorder points), I might like to know that dodads are almost at the reorder point so I can order those too at the same time.

It would be nice to be able to create a purchase order from I/C based on items being close to their reorder points rather than absolutely there.

UI crash when printing with custom Crystal report

LanceB — Mon, 02 Nov 2009 08:34:57 GMT

When I attempt to print a PO using a custom version of POPOR04.RPT (which works fine when previewed in Crystal Reports), the Purchasing GUI crashes with the following popup message:

"Runtime Error! Program: c:\afw\runtime\A4WCONTAINERXP.EXE"

The report uses a sub-report to connect to a Web Service endpoint to extract information based on the purchase order context being printed. When I remove the Web Service connection, the report works normally.

Any ideas on how to debug this or where the problem may be?

Thanks in advance,

Lance

Can't attend Sage Summit? Listen Live!

JanD — Wed, 28 Oct 2009 13:53:33 GMT

Join us to hear influential leader, Brent Leary, co-founder and partner of CRM Essentials LLC, discuss trends in Social CRM and what it means for your business during a live webcast from the Summit floor. Watch this session in real-time, online, and even submit questions during the session.

Event: Industry Trends in Social CRM presented by Brent Leary

When: Wednesday, November 11, 2009 8:30 a.m. Eastern

Voiding Cheques

lbernier — Wed, 28 Oct 2009 12:59:01 GMT

I am currently using AccPac version 5.3, using it for A/P purposes soley. I have entered, posted and printed a cheque to the wrong vender. I would like to void the cheque (I do have it in my hands), and clear that transaction from the 'wrong' vendors account. (The invoice needs to be re-entered to another vendor). If possible I would like to know the process for doing this.

Also, it would be really helpful to know how to change the number of a printed cheque (in Accpac). A check run was in the process and someone printed on one. A manual cheque was cut, but I would like AccPac to represent the manual Cheque number.

Thanks alot!

Lauren

How to export all the datafields from the multiple tables in the single line

janakiraman — Wed, 28 Oct 2009 05:15:22 GMT

Dear All,

As you all know there is export option available in every transaction module to excel,Csv and others

but my problem is i was not able to export in single line.

Please help me to export all the datafields on the single line.

SQL server 2008: does specifying server rather than datasource bring better performance?

TimRichardson — Tue, 27 Oct 2009 21:27:31 GMT

We use SQL Server 2008 and Accpac ERP 5.5A. In database setup, I can specify a data source (for example, a SQL Native Client data source) or I can directly enter the SQL server hostname.

If that's my choice: use a Native Client data source, or specify the database directly, which is best?