• Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • SAGE 300 ERP RollOver

    Hello Everyone, I recently created a new year(2024) for a client's company, but the document date and posting date are 2024 instead them being DECEMBER 31, 2023. Now, I am not sure if it's an error or it's okay. My idea is to reverse the entry and repost…
  • Sage300 GL Financial Report print to file error

    Sage300 v6.0 using RDP. only one user has problem. FR Preview is normal. When generate report by print destination as file. a blank error message open. the file select screen's capture is adnormal If ok, it will hanged. Any hints?
  • Can payment term based on working days instead of calendar day?

    Hi, I have checked the term setup in A/R Setup -> Term. Is there any way to set the term to be based on working days? (E.g 30 working days instead of 30 calendar days?) Thank you.
  • Error Code 380: Sage 300 ERP

    Hi there, I'm quite inexperienced using Sage 300 ERP, and I'm trying to add a new asset, but it's displaying Error Code: 380 "Date does not exist in Fiscal Calendar!". I've had no troubles adding assets for the past few months, so I'm not sure what…
  • Adding ICITEMO field to an OE picking ticket

    I am attempting to add ICITEMO fields to my OE picking ticket, but some how I cannot select the ICITEMO table in my sub report. I do not see any of the optional field table being able to be selected. Any ideas of what I am doing wrong.
  • Book Balance in Bank Reconciliation

    Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…
  • Sage 300 2014 AR Receipt Entry numbering

    Hi Everyone, I have a client running on Sage 300 2014 and is facing challenges on AR document numbering. The system's AR Receipt document auto-numbering sometimes skip the sequence by a random number hence distorting the trail. Can anyone assist on…
  • How to adjust EI and CPP earnings on Sage 300

    Does anyone know how to adjust EI insurable and CPP pensionable earnings for T4s on Sage 300?
  • Credit limits overide report

    Is there a report or something to identify what user approved a credit limit overide
  • Sage Accpac ERP Database error=49153 After restore database from another server

    Hi All, I just restore Sage Accpac 5.6A from old server to our new server (both database names are the same: "ACCPACSYS" & "ACCPACDAT"). After restore successfully and launch Sage Accpac ERP on server (on where Accpac 5.6A and its sql server database…
  • PO backorder date default

    Hello a user requested that the default backorder date for POs be changed from 1 year to 2 years. Is this possible? Sage 300 2017. Thank you.
  • On Journal Entry, Rate value is different from the other item line

    Hi all, my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…
  • A/R deposit shows Not Posted in bank rec

    We have a client running Sage 300 v2021.5. They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. Because of this status, they cannot clear the deposit in their bank rec. Has anyone seen…
  • emailing AR statements

    Has anyone had any issues with being "black listed" by your email provider/server for emailing AR statements, invoices, etc... from the Sage program's email capability? My IT people are concerned because we are one division (using only Sage) of a larger…
  • overflow. maximum entry has been generated for batch

    I have a client whose Accounts receivable batches have not been posting to GL as there was a post in progress batch. I resolved the batch - closed period but when the next batch is posted, the system is processing all the hanging batches and then throw…
  • Sage 300 Bank Feeds

    Can someone assist me in configuring bank feeds. I have included in Sage 300 2020 PU 7 installation but when I open any bank in bank e-statements ( Bank Services) I do not see anything to do with bank feeds. How best can i go around this.
  • AR Customer default price list

    Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…
  • Multiple users printing different customer statement concurrently - sage 300

    in one of our client , Users cannot print different customer statements concurrently. Is this how sage works? If for example a user has printed a statement for Customer X and while it is still open on his machine, another user tries to print a statement…
  • Apply Open Credits to an Invoice during Invoice Entry

    How to apply open credits e.g. prepayments, open credit notes etc directly to an Invoice in A/R while entering the Invoice. The Invoice amount should reduce with the credits amount.
  • Importing Receipt Batches

    I am able to import misc receipts into Sage 300 AR successfully. I create a batch, set my bank and batch date which equals my deposit date, then import a single file of multiple misc receipts to reflect that day of deposits. My question is that I have…
  • Period locks change on upgrade to 2021

    I just upgraded a customer from Sage 300 2018 to Sage 300 2021. After upgrading they pointed out that many of their "Locked" periods were now unlocked. In their old database in the CSFSCST table there are NO lock records for 2020, 2018 and 2016. I…
  • PST on Expenses

    I am from Vancouver BC area. We pay 7% PST on expenses. I am trying to enable tax calculations on our Sage 300 which are currently disabled on our AP System. When I do that, system is posting expense and applicable tax as two separate line items in the…
  • Error during the push payment to Sage 300. The payment type is 'Receipt'.

    Hello Team, I try to push a payment with the 'Receipt' status. But I receive an error message: "value": "The request parameters are invalid. Fail to save value to (Applied Receipts/Adjustments) for fields (Customer Number, Document Number, Payment Number…
  • Currency Rate

    Hello Team, To receive the currency rate I use the following endpoint -> CSCurrencyRates The response has the following structure: { "ToCurrency" : "CAD" , "RateType" : "AV" , "FromCurrency" : "AUD" , "RateDate" : "2020-01-02T00:00:00Z" ,…