Sage 300

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…

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…

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 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 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…

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…

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…

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…

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.

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…

Occasionally we get an error batch when posting AP checks. We have many companies running Sage and this happens to all of them at random times. The bank accounts exist and have been there for years. Does anyone know what causes this error? check xxx…

I have unposted payroll data that was calculated in error - how do I delete this extra payroll? I cannot create a ROE due to this unposted data, but the only place where I can see this unposted data in the payroll module is in cheque inquiry.

Hi there, We are having an issue posting an AP batch and CK batch from a cheque we issued March 31, 2016 but post dated it to April 4, 2016. Cheque printed last week but now we can not post the batch entries. Any idea?

We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…

Is there i way to specify working and non working days in Sage 300 ERP 6.0? This is in regards to calculating payments due dates in AP.

Hi All, Has anyone experienced (and hopefully resolved) an issue where an order in OE shows a negative subtotal despite having only positive quantities and unit prices (resulting in positive extended priced lines). Sage 300 (v2014, pu 1) is also allowing…

Hello, I recently posted about 10 invoices from BL with the invoice date of 1/20/2014. Is there an easy way to change or edit this date in AR, without having to void the invoices and regenerate all 10 from BL? When I go to adjust the invoice in AR, the…