• Sage 300 GL Posting with Withholding Tax and Net Payable Adjustment

    How can we achieve the following task: A supplier invoice of $115, with a withholding tax of $15. The objective is to ensure that when posted to the General Ledger (GL), the $115 reflects in the expense account, while also accounting for the fact that…
  • Missing batch AR batch

    A customer reports that an AR batch is missing and didn't hit the customer records. They said it hit everything else. Is there a way to recover this batch assuming that the batch did affect IC, GL, and OE? I am still gathering info since it could be…
  • WEB API - ARReceiptAndAdjustmentBatch

    Hi there, I'm tryin to create a receipt for an invoice through this API. Testing in the Swagger interface - ARReceiptAndAdjustmentBatch Entity I'm posting: { "ReceiptsAdjustments": [ { "BatchType": "CA", "CustomerNumber": "1001CRJ22031…
  • Invoice Batch List behavior

    Good morning! Our accounts payable clerk has reported an odd behavior in a single company when she enters a record into a batch using the Invoice Batch List. Clicking the 'Add' button does not progress to the next blank record. Instead, the button changes…
  • Hide Delete Button in A/R Receipt

    I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish
  • G/L Journal Entry Error - Please Help

    Has anyone experienced this error before when processing G/L Journal Entry? Not sure where to even begin but processing a few transactions / posting banking transactions and then doing G/L Journal Entry and we get this error. We are running Sage 300 2022…
  • Sage 300 GL batch posting freezes

    Sage 300 Premium (Version 2022) SQL 2019 on Windows Server 2019 GL batch posting freezes during month end closing periods and Sage 300 becomes inaccessible for anyone who wants to further login. Other logged in users won't be able to post from GL…
  • A/R Receipt Batch List -> Default Ordering

    I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…
  • The Bank code and Bank currency combination does not match

    "The combination of bank code and bank currency for the entry does not match that for the batch. They must be the same." Receiving this error when posting a batch. Any help? The bank is setup as multicurrency but with FJD as default currency Thanks…
  • Can I process AP batches in October if September AP isn't closed yet without affecting each other?

    Is it possible to process an AP batch in October if the previous month (September) isn't closed yet? Would processing in October affect the September AP?
  • Recurring Batch Entries

    Hello Team, I was trying to create a new RECURRING BATCH ENTRIES through the GL Setup >>> Recurring Entries >>> Filling the GL Recurring Entries screen and click Add. After clicking "Add button", this error comes up " Sequence Number Dispenser.…
  • Customise Crystal Reports Forms

    I want to customise the Crystal reports to indicate which user keyed and/or posted batches in AR and AP. Which tables should i be looking at?
  • AR receipt batch posting slow

    Hi Support, One client is have an issue with AR receipt batch posting. The posting hangs even if there are only a few entries to be posted. Sage 6.1, PU1
  • Import Journal Entries into the New Year

    We just closed out June (end of our fiscal year). The Imported journal entries that were provisionally posted to the July GL in June do not appear on the July GL now. , Do I need to rekey them or is there a way I can get them to appear in the July GL…
  • Sage 300 - sql query for recalculating AP Balances - reconciling to GL

    Hi, I am trying to determine why my GL and AP control accounts dont balance. Yes, I know I can isolate GL only transactions from my control account, but I would like to build a more robust answer. To this end, I would like to build a query in sql…
  • How to undo AR Receipt Entry

    Hi, We have an AR receipt Entry batch with 2 entries my first entry is ok but I want to undo the 2nd entry in order to put back the document number in the first entry.
  • how to delete an AR Invoice Entry

    Hi, We are running on Sage300 ERP and we would like to know how to delete an AR invoice entry ( 3 entries).Is it possible to do so. Thanks.
  • Batch email processing gives random results

    We are trying to perform a batch print from a processed file. There are 21 customers in the file and each requires that an email be sent, when we try and run through the process it seems to randomly email only a portion of the customers. Last time it…
  • Error must print check before setting ready to post

    Hi , I have the 2 following error message here on AP Payment Batch List: You must print all checks for batch XXX before setting it ready to post. batch. And when I open the batch another error says "You must print all checks for batch XXX before settin…
  • Change payment terms for vendors

    Hi all, I would like to enquire how can I change the payment terms for a vendor if my invoice for the vendor is already posted? I realised my invoices for some vendors have wrong payment terms and now my aging report is wrong.. So, is it possible…
  • Day End Error

    Hi Support, We are receiving the following error message while post MO entry batch and another user poser OE invoice. Kindly assist Description: Incorrect procedure. You cannot run Day End Processing until other users have completed day end processing…
  • Excel Import additional Account Segments

    Hi, We're using Sage 300 ERP 2012.1 and our chart of accounts includes accounts with one segment, three segments, or four. Currently using the excel import for journal entries, we are only able to import three segments, then if we need the fourth segment…
  • Clearing Acounts in sage 300 erp

    Dear All, I am ICT supporting to sage 300 erp. I fail to understand what the following accounts means,their importance and how to reconcile them. I have googled and seems not to get the clear view .Please assist Creditors control Account Payable…
  • find deleted entries

    Hi, Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger. And I'd like to know if we can find out the User who deleted these entries.
  • Is there a way to edit OE invoices in AR?

    We use OE module to create invoices selling stock and non-stock inventory items from IC module. Sometimes there are errors on the OE invoices that need to be changed such as wrong taxes charged, unit prices don't match customer PO, etc. Sometimes the…