Sage 300

We have just upgraded our client to Sage 300 Version 2023 from 2016. In version 2016, when you email statements, it does so through Outlook leaving a copy in the sent items. When we upgraded to 2023, it uses SMTP. Is there any setting we can change…

"Purchase Order. Record Already Exists - next number field is to be updated in PO setup -Options- Documents and Next Number. Client keeps jamming up the numbers by manual entry of the field - has someone built a logic around to deny manual input of…

Making an AP Payment Entry to a foreign vendor in AUD. FJD is the local currency We are converting AUD 21,640 at a rate of 0.6620 per FJD The amount should be FJD 32,688.82 Sage300 calculated FJD 32,689.238 Is this because the decimal places are set…

Has anyone else had an issue with tax calculations on non periodic payments since the installation of the January tax table update? We have a client, that had used these types of payments for retro pay for a number of years, and always added that non…

I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…

I am unable to post batches from the Web screens of Sage 300 2022. The batches I am attempting to post are small one or 2 entries. I have tried both GL and AP. When I attempt to post them in the web client they just appear hung indicating it is processing…

Dear Gurus, I am using SAGE 300 Premium 2018. I installed and loaded SAMSYS, SAMINC and SAMLTD. I am at the General Ledger Module --> G/L Transactions, trying to browse Journal Entries. Whenever I scroll to the end of the entries, I will get this…

Hello Everyone, I recently created a new year(2024) for a client's company, but the document date and posting date are 2024 instead them being DECEMBER 31, 2023. Now, I am not sure if it's an error or it's okay. My idea is to reverse the entry and repost…

When we are using costing item on Inventory Control module, Day End Process or During Posting. Then we have Audit result and doing Adjustment backdate, ex. current period Nov 2023 (many issued/internal usages Item from Jan to Oct), we input IC Adjustment…

Hello. One of our vendors wants us to do a pay and deduct from a PO Invoice when items are short shipped. We have been short paying based on the receiving receipt so that our inventory is correct, but that does not work for them. How can we add the information…

AP Batch Invoice has been posted, but it didn't push an invoice into the payment. How do I get the invoice to pushed into the payment section?

A credit note was created and the system automatically generates a credit note number but an error batch was generated with the message CN00ABC already exists. Why would the system generate a credit note number which already exists?

Normally in Sage 300 when we create and post credit notes in AR, we can apply the credit note to a customer's invoice the next day. We created and posted a credit but on the following day it's not available to apply against an invoice nor does it show…

After User creates an invoice and posts it in the Order Entry module, the invoice should appear in the A/R -> Aged Trial Balance. but the invoice does not appear. then I checked the A/R module -> Posting Errors. And it turns out, the invoices had an error…

Is there a good way to change all posted transactions from one period to another? A customer is wanting to change their fiscal calendar and move the last 6 months worth of data to a different period. I told them they would have to do journal entries but…

Hi All, In my current project I'm writing a code to create a payment batch in Sage300 via REST API. In order to do that I'm doing a GET to a random payment and then clearing the fields to add the new data. Is there a way to get a template of the payload…

Hi there, I'm quite inexperienced using Sage 300 ERP, and I'm trying to add a new asset, but it's displaying Error Code: 380 "Date does not exist in Fiscal Calendar!". I've had no troubles adding assets for the past few months, so I'm not sure what…

Sage 300 v2020 PU4 on AWS cloud Server ll works fine on the desktop version, however, when trying to create a batch entry within the Web Screens in AR Invoice it hangs and does not add an entry, it allows navigation to other modules and adding batch…

I have setup price Check with Price Check approval. However, when processing the O/E . Whether the price is below the percentage threshold or not . l get the below errror message: "Description: The price check failed because currently the unit cost…

Hi, If we receive an item to an existing Lot, Why the stock date and Expiry dates are not updating automatically to the date of PO Receipt. ? This will make an issue of Auto-allocation in OE, system will take this Lot ,even it contains the latest…

I keep getting error which prevent importing of Invoice Batch created using in Excel 2007 template. "The document total amount does not match payment schedule amount. Correct 05:15:30 payment amounts in the schedule". I have populated all necessary columns…

Hi All, I posted an AR Refund Entry that is using Cash Payment, No Bank Code, use Cash Account instead. It does not have a Bank Code so I cannot use the Reverse Transaction from Bank Transaction. Any other way to reverse this refund? Thank …

Hi, We found a Difference between AR GL balance and AR subledgers as at 31st December 2022 and that difference comes from December 2022. i want to know how to reconcile the month of December 2022 and find the reasons for this difference. Please advice…

Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…

Does anyone know how to adjust EI insurable and CPP pensionable earnings for T4s on Sage 300?