Sage 300

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

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…

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…

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…

Am trying to send post request to sage API concurrently where by many requests are sent at once. I got an error 'Record Conflict {en-us I/C Options. Record has been modified by another program' and debug .Net debug pop up Everything work fine…

Hi all, my customer is making a journal entry when this happen. Please refer to the Rate column and the cell value in red rectangle. The value of the rates on this column are prefill accordingly. But the value for the last item line is different from…

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…

We have a client running Sage 300 v2021.5. They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. Because of this status, they cannot clear the deposit in their bank rec. Has anyone seen…

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…

Hello Team, I try to post the Invoice, but receive the following error message: Invoice Batch Attempt to perform Record Update without security authorization. Could you clarify how to fix this error message? What settings I should do?

Hi All, I did an AP vendor number change. I now receive this error 2147417848 Automation error The object invoked has disconnected from its clients. How do I fix this as we no longer can access this vendor? I did a AP vendor number chan…

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…