Browse By Tags

  • accruals

    vacation pay stopped accruing and being paid out for a large number of employees but not all
  • Year End Closing Entry

    New year is already created but now need to close the previous fiscal year to retained earnings. How do I create the closing entry if the new year is already created?
  • PJC Change Orders

    Hi. We are trying to get posted change orders to be reflected in PJC. Any suggestions? Thanks.
  • Sage 300 2023 Web screen AR unable to create entries

    When choosing AR Batch or AR Entry via web screens, the page loads but the detail and optional grid spin incessantly, making it impossible to enter any data. IMPORTANT: log in as admin, we are able to enter data. See screenshot.
  • Error Exception of type 'System.OutofMemory' was thrown running State eFile and Reporting

    When trying to do quarterly payroll taxes, I received a popup stating an error occurred please see the log for details. The log message stated Exception of type ' System.OutOf MemoryException' was thrown. It doesn't seem to matter which state or return…
  • Sage 300 Posting Bank Reconciliation without asking all users to logout

    Multiple bank accounts that need to be reconciled and posted are being used by our Sage300 company. The problem is that, even when a certain bank isn't being used, it's always necessary to request that users log out. Is there another way to post a bank…
  • AR integration to GL not bringing across functional values

    Hi Just wondering if there is a known issue with the posting of AR invoice batches to the GL when multicurrency is in use. All of a sudden, starting Mid Feb 2023, the functional values are not posting to income accounts and all income is going to the…
  • Bill Credit for AR Retention

    We have a job that I need to do a bill credit to the retention. This isn't a write off. We elected not to bill the owner for the remaining outstanding retention. I searched and read that Sage doesn't offer the ability to do a bill credit to retention…
  • How to reverse an AR Refund Entry that do not have Bank Code?

    Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …
  • Reconciling Shipment Clearing & Payable Clearing Accounts

    Hi, I want to know, what is the best way to reconcile shipment clearing account and payable clearing account ? is there an easy way to make it zero at the end of the reporting date. Thank you
  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
  • How to populate GL Journal Entry - CUSTVEND column

    Hi all, On the GL Journal Entry screen, entry number finder, there are Customer / Vendor Number and Customer / Vendor Name column, which is related to GLJEH table, CUSTVEND column. I check on it and found that there is no value in this column. I would…
  • Sage 300 Web API - ICDayEndProcessing

    Hi All, I am developing a website that will use Sage 300 Web API to integrate with Sage 300 data. Currently, I would like to run the IC day end processing in my development, but I am confuse on the payload. Does someone have a sample or tutorial…
  • Customs Duties - How do we add them as additional costs with different rates for different items.

    Hi all. With American tariffs changing a lot recently, and therefore being volatile and different between types of products, we are looking for a way to add customs duties as additional costs based on each of the individual duty/tariff rates for each…
  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report? Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…
  • Anyone using Sage 300 V.2016 to do Budgeting ?

    Hi all, My company hasn't been using Sage 300 (V.2016) to do budgets. Its typically been done in excel. I know it can be done, (use sage to budget) but don't know where to start or what reports i can print. Are there any courses just for the budgeting…
  • Help with New Payroll Code

    Is it possible to have a payroll code that will allow me to enter a 'day rate' i.e. $160.00 per day but also keep track of insurable hours? So on the timecard, I want to enter 5 days work, it will come up with the day rate of $160.00 and multiply it by…