Browse By Tags

  • Quantity Available

    Hello trying to find what table the Available qty is located... Can't find in CI_Item or IM_itemwarehouse
  • Global Parameter

    Hello, I need to be able to define a new global parameter but I can't seem to figure out how to do it correctly. I was able to create one but I wasn't able to add it to a selection list and make it work. I am not sure how to define which field in the…
  • Changing Inventory type from Normal to Non-Physical

    Hi Is there anyway to change an already created item number from Normal to Non-Physical? Or do I have to recreate the item number again? Past employee create items that are consumables and should not be inventoried and wish to correct this. Thanks…
  • Allocating Employers portion of CPP/EI/WCB to a fund

    I have a fund in Sage that I track all of my operating expenses through. How can I allocate the employer portion of payroll costs through that fund? I have their salary going through a staff account but want the employer costs going through a separate…
  • Payroll Calculations - Sage 100 Canada

    Is there anyone willing to share their payroll calculations (how they are set up)? Particularly looking for the WCB calculation and the processes you do or if you even use it. Please email me at [email protected]
  • Sub Accounts ?

    Hi. I currently have an Asset Account "1710-0001 (Calgary) -Plant Equipment". We have now decided that we'd like to track the different pieces of equipment in Sage, rather than on a spreadsheet. I just want to confirm, I should be able to make Sub…
  • Maximum stock setup in product site

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Maximum stock limit in Sage X3

    Hello, can anyone tell me how can I setup the maximum stock quantity for a product site. I tried adding it in product site but don't know how it works, the system still allows me to receive more stock. I need such a setup that once the maximum quantity…
  • Event Viewer Error

    Just wondering if anyone has come across the following application error in event viewer. System Registry Error. The operating system reported "The system cannot find the file specified. " on attempting to create or open the ACCPAC International, Inc…
  • Automated Emails sent out from SAGE 100

    Hoping for any assistance in this issue. For some reason, Past Due invoice after 60 days, are getting automatically emailed out to customers on random days. I do not know where/how it is doing this. There is nothing in Task Scheduler or in our Sage…
  • Expired Lot Error

    I have a sales order I allocated material to. When generating a preparation plan, the following errors come up: When I look at the lot characteristics, it indicates that the lot doesn't expire until next year. I tried running a stock resynchronization…
  • Sage BV Client - Convert Quote to Order

    Would anyone happen to have a way to convert and existing quote to an order, using the next sequential order number automatically? I believe I am using the 2018 version. Any and all help would be greatly appreciated. Michelle
  • Need to Hide 'Dashboards' for users

    I created a non-admin user with limited permissions. I found a way to hide "Data models and views", but I can't figure out how to hide 'Dashboards'. Although they are not accessible for this user, I still need them to be hidden from the screen. is it…
  • Multiple currencies in the same company. Different currencies in different sites.

    Would like to know if its possible to have a company with sites that have different currencies. For example. Parent company is Germany but has sites in the US. Germany company defaults to EURO but the US sites need to be in USD. Can this be done…
  • Sage 50 Accounting - Cloud Connectivity

    How does the Cloud Connectivity feature of Sage 50 Accounting work? Any information will be highly appreciated.
  • Item No. with two different rates

    Hello, I started a new role recently and was tasked with untangling a pricing issue. The item I am trying to update is 8 - it is showing two different rates for different products. Both are outdated and need to be adjusted. When I go to to the…
  • Optional field multiple values

    Is there any way to have one optional field allow for multiple values. Ie an optional field in A/R Customers named 'additionalPhoneNumber' and for the customer we could have multiple ' additionalPhoneNumber' defined.
  • accès cabinet

    Bonjour, est-ce possible dans notre accès cabinet d'avoir les employés du cabinet voir toutes les licences? Comme par exemple, j'ai 6 clients qui utilise Sage Accounting mais en tant que responsable du cabinet, je suis la seule à tous les voir J…
  • FIrewall screen opening delay v2024

    There is a site that behaves very oddly; new server and upgrade of Sage300 Server 2022 Std DC/SQL together (yeah I know security weakness - told I.T. when Private Firewall is On at server stations get green bar opening screen with error message…
  • Controls on Purchase Orders

    Is there a way to set controls where a user is only allowed to create a PO and not have the capability of editing or deleting a PO?
  • Current Earnings Account not posting to Balance Sheet

    Hello, Let me preface by I've reached out to Sage technical support (1:30 hours yesterday) and we have another appointment for tomorrow, however, I thought I'd post here see if anybody has encountered this issue. I setup a new company on sage, and…
  • Preprogrammer des operations

    J'aimerais programmer ou mémoriser des paiement qui se prennent automatiquement dans notre compte bancaire pour qu'il soit ajouter automatiquement dans mes paiments dans sage. Comment faire merci
  • T&M User Setup as Contractor, not Employee

    Can T&M users be configured as contractors (not employees)? I want them posting hours directly to projects so project budgets stay up to date. They can send a single merged bill at the end of each month which can be reconciled against the project hours…
  • Unable to Create New Purchase Order

    Hi, I have created a newly company and sites. However, when creating the first Purchase Order, the document number is automatically created and displayed, but the button "Create" still active. It display error message (Order JBP020724PO0001, Line…
  • Price and Quantity Reversed When Data Moves from PO to Invoice Entry

    Hi, Data is flipped between the PO Screen and Invoice Screen. In PO... Price - $25 Quantity - 300 When I go into Accounts Payable Invoice Entry... Price- 300 Quantity - $25 Is there a way to fix this? I think it is a configuration issue…