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…
  • 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…
  • 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…
  • Batches stuck as "in use"

    We have run into an issue a few times with both AP and GL batches. The status changes and is stuck on "in use". We check that there are no users in the batch, but the status gets stuck, we can't delete it or post it. The only resolution we are able to…
  • 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…
  • Fictitious Invoices across all open batches

    Every now and then one of my locations has their internet drop when one of the stations is writing a sales order. When we log back in, the invoice gets distributed to all open batches across the company, and cannot be deleted or changed. It will not update…
  • 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…
  • on trial balance report, debit balance and credit balance is not equal, some difference. any tool to find why and how ?

    Trial balance report is having some difference for debit balance and credit balance. how it can happen and what is the best way to solve this? version: 9 patch2
  • SO invoice entry creating random backorders

    Our invoice clerk report 3 times that she had back orders on invoice she had entered last week. We don't do backorders in our business so this is very unusual. The Backorder column is not on the SO Invoice Data Entry form. The system seems to grab the…
  • debiting more than one GL expense code in bank payment entry

    I am new to Sage X3, we need to book certain expenses directly through bank payment entry debiting more than one GL code, example when we reimburse certain expenses of staff we need to book to various GL code such as school fee, vehicle maintenance reimbursement…