Browse By Tags

  • What are the best practices for request of prior year reports by auditors?

    Hello, I have our live FAS listing in the current year (2015), and run monthly depreciation. When I am asked by auditors for FAS listing of prior years, (for example: 2011), I open a save copy of the 2011 company, create a report and send it over. However…
  • 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…
  • AP Invoice Batch Posting Issue

    BOI-Experts, We are running into an interesting phenomenon. A BOI script creates AP and PO invoices in multiple companies, and then posts the AP and PO batches company by company. A lot of times that works just fine. Every now and then the invoices…
  • 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…
  • How to find a lost un posted invoice that I lost and can no longer find

    Hello everyone, i was working on invoicing yesterday and i lost one of my biggest invoice and didn’t get to register/post it and now I can’t find it this is what I did. I went to Invoices and made a batch with all of the invoices then clicked on enter…
  • Cancelling Payment Batch

    FormerMember
    FormerMember
    I created an EFT payment batch, posted it and now want to cancel it. The open batch is still in the G/L. I'm wondering if I can just delete the batch in the G/L? What are the implications because I technically paid it, but didnt' actually send the funds…
  • Error posting Receipt of Goods batch

    Hello! We are trying to post a batch of Receipt of Goods and keep receiving the following error: Can anyone offer advice/suggestions/a solution?? Thank you!
  • Unable to read line level data

    Hello I am trying to read data from SO_SalesOrderDetial i tried setting key value to read data for a given sales order i am able to get data using GetResultSet but i am not able to read values like price , ordered etc and when i am trying to use…
  • Duplicate cash receipt pending post, won't let me post it

    It looks like I have a duplicate receipt entry, one is type Csh rc and has posted correctly to at, however the other entry is type Cs cs rc. Same date, same check number same amount. The problem is the second type Cs cs rc is "pending post" so it will…
  • 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 overwrite the sales tax using sdk

    We want to be able to write the Sales tax of a document back to sage using a third party application. From the .net dll, we have understood that the sales tax can only be calculated but not written to. But we want to know if there is any way we can edit…
  • Cash Receipts & National Account

    Hi, I posted same question under a different category, I tried to simplify it here. We currently receive thousands of payments (cash receipts) that need to be applied to open invoices as cash receipts payments from our customers; this is taking us forever…
  • Unable to edit order line and tax amount

    Hello I am trying to edit a existing sales order using BOI,... i am able to make header level changes but when i am trying to change line level data ( ie: item code) a new line is getting created.... And when i am trying to add a new line and over…
  • New to Sage 300 CRE

    I'm looking for a users guide for this software, does anyone know if there is such a thing? I have 40 years experience in accounting/bookkeeping and am new to this software. I would like to know the nuances of how this works and how the modules tie in…
  • How to get Batch task attached to a script to WORK in X3?

    Hi There, Would anyone help me? I am trying to run a simple batch task to generate a log file, but i can't get it to work. It seems to be executing ,but no trace file is generated. This code work fine on the script editor, but doesn't work when i…
  • 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.
  • General ledger export from a payroll processing company

    We need to outsource our payroll now because the Sage payroll module can not handle negative checks. The payroll companies say that they will build a general ledger export to bring in the payroll information to Sage100c. Do I need another software package…
  • 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…
  • Sage X3 Import Template Processing / Script for Header and Detail

    Hi I am trying to import a sales order using an import template, in the processing I can run some validations and stop the import by setting OK=0 if the validation fails, however it is my requirement that we just drop the one line of the import that…
  • Daily Transaction journal update out of Balance

    I updated our Daily Transaction Register yesterday and it showed me and Out of Balance amount in the Totals Section. Is there a short cut to find the Out of Balance Invoice? I had to comb throw 100 invoices, adding each line item and total to find which…
  • 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…
  • My November and October time and expenses are merged on one bill

    FormerMember
    FormerMember
    I am BRAND NEW to Time Slips. I've only worked with this system since September. I work for a solo practice attorney and I'm in the office 1-2 per week, depending on the week. My ability get a consistent grasp on this system is sporadic. I have an issue…