Browse By Tags

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…

Is there a way to increase the window size when I am entering payroll? All I have is a pop-up window and I hate that I can't make it larger. Thanks.

Hi All, I entered a bank USD entry with the wrong USD to CAD rate. This is messing up the balance of the clearing account and so I would like to reverse the bank entry and re-enter it with the correct USD to CAD rate. However, the bank entry is now…

the Peach Tree software we are using is pretty dated I believe 2011. We receive statements monthly from the bank for a large equipment financed loan. The accounts used in setting up the loan were Note payable to the bank; Interest Expense, and the other…

So i came into the office today and started to do some sales invoices. Maybe after i posted three invoices i noticed that account period was still stuck on 20. It should of been 21 due to it being a new month. So i went to switch account period, clicked…

Good afternoon. With the need of one of my clients on posting inter-company journal entry. During post inter-company journal entry, "inter-company NA10 / NA011" or "Inter-company NA10 " will display on the description field of counterpart of the transaction…

Is there a way to prevent AP from using revenue accounts and a way to prevent AR from using AP related accounts?

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…

Hi, Is there a way in X3 to report on two dates, i.e, one for posting date (the date data is entered) and accounting date (the date data belongs to a specific period)? I need this for auditing prior period adjustments to see what entries were made after…

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…

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…

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…

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…

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…

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…

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…

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.

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.

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…

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…

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…

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…

Retail store has received inventory through Sage 50 US edition 2017. Inventory vendor invoices are paid ACH. Accounting person reconciling bank statements did not apply electronic payments to vendor invoice in Sage prior to reconciling. Reconciled bank…

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…

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…