Sage 300

We're utilizing Sage 300 2023. After generating and receiving a Purchase Order (PO), along with creating the associated Accounts Payable (AP) invoice and posting it to the General Ledger (GL), we've noticed that the expense account remains unaffected…

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

Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…

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…

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…

Setting up Direct Deposit in Sage 300 ERP - with BMO in Canada. The bank said we are missing our short name and long name in the file we are uploading to them, so it was rejected. Does anyone know where to enter this information in Sage 300 ? Thanks.

Hi all, I try to assigned the current open batch(E.g: 75), that I manually created in Sage, when I called web API ARInvoiceBatches with BatchNumber=75, it still will create an entry inside new batch (E.g: 80) instead of my current open batch (E.g…

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…

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…

Hello Everyone, We are experimenting with the Web API in Sage and I noticed that for OE Invoices it only allows GET operations. Is there a road map for the development of the Web API from Sage or are there any plans to implement POST operations for…

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…

I am trying to process invoices and receipts in Accounts Receivable for a National Account (main account and not a member account), but I get the error that " Customer number XXXX does not exist ". I was under the impression that this is possible and…

I need your advise on how to use account segment (identification of account segment) even from PO. Let’s make example, a PO was created from Segment Division of 100 (Fakultas Kedokteran). What I wanted is when I receipt goods, the Journal will be Dr Inventory…

Hello Team, I need your help with the following question. I applied a payment for the Invoice, but the Invoice doesn't change the Amount Due. Could you please clarify why Sage 300 doesn't change the amount once the user paid the invoice using a payment…

Hello Team, Could you help me with the following question. What Invoice field I can consider as an Invoice Close Date? I found only the Invoice Batch Date and Invoice Posting Date. But I cannot find the Invoice Close Date?

Am trying to import misc payment in AP Payment batch but all misc payment amount is duplicated Am using Sage 300 Standard 2020 PU 5

I was wondering if anyone else has an issue with the A/R Document Inquiry Screen including Tax as part of the Detail and Total Amounts? We are still using 2018 PU3 Classic, has this been corrected in a later release or in the web screens? It seems…

Hi All, so one of my customer have done a wrong OE transaction, shipment, and invoice. They apply the wrong unit price, and this happen to a lot of transactions (4 days transaction) Is it possible to delete it, and delete it in a bulk? Thank you…

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…

Hi All, My colleague, who somehow believes slowly entering the entries manually is the best way to do things, told me if I import entries from excel templates something is going to be wrong. Is there any truth to it? In particular, he mentioned that…