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…

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

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

I have a client whose Accounts receivable batches have not been posting to GL as there was a post in progress batch. I resolved the batch - closed period but when the next batch is posted, the system is processing all the hanging batches and then throw…

I receipted my purchase order and posted it in Sage 300 but I did not put the correct amount down and hence I cannot Invoice it. Is there a way for me to edit or delete the the receipt for the purchase order. Please help me ASAP. Thank you.

I received two credits from a vendor for the same return. I went into PO credit note entry and entered the first one and changed the quantity I received a credit on to the correct amount. But when I try to enter the second credit for the remaining quantity…

We've set-up an American Express account, so that we can capture the detailed expenditures on our corporate card in A/P. All invoices paid with AMEX will be keyed as "Misc Pmts". When i create a new batch ((to key the new month's AMEX expenditures)…