Sage 300

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…

Hi Everyone, I have a client running on Sage 300 2014 and is facing challenges on AR document numbering. The system's AR Receipt document auto-numbering sometimes skip the sequence by a random number hence distorting the trail. Can anyone assist on…

I just upgraded a customer from Sage 300 2018 to Sage 300 2021. After upgrading they pointed out that many of their "Locked" periods were now unlocked. In their old database in the CSFSCST table there are NO lock records for 2020, 2018 and 2016. I…

Hello Team, To receive the currency rate I use the following endpoint -> CSCurrencyRates The response has the following structure: { "ToCurrency" : "CAD" , "RateType" : "AV" , "FromCurrency" : "AUD" , "RateDate" : "2020-01-02T00:00:00Z" ,…

I have chart of accounts with two segments i.e MAIN & MAIN SUB 1234 Repair and maintenance 1234-01 Repair and Maintenance - HQ 1234-02 Repair and Maintenance - TZ 1234-03 Repair and Maintenance - ZM On printing financial reports only Main…

Hello, I am trying to export the 2016/2017/2018 year end income statement accounts and amounts to excel. I cannot find which column definition displays this information. Every column definition I have tried does not tie out with the actual income statement…

SMTP checked How can you configure email to register in the outlook sent items when using office 365. Can it work when both using the desktop client and the webclient?

I reconciled on 4/30/18 and all was good. Then i realized a bank transfer was entered twice, so i entered a transaction going the opposite way to clear one of them out. When i reconcile the statement for 5/3 and select both of the transactions it shows…

Sage300 LanPak License autofills in error when using A4WLicMgr.exe to set the user keys. I access the license manager offline by using this tool found in the Sage\Runtime directory. However, when I go to add the license info, I am able to enter the type…

Is it possible to have a payroll code that will allow me to enter a 'day rate' i.e. $160.00 per day but also keep track of insurable hours? So on the timecard, I want to enter 5 days work, it will come up with the day rate of $160.00 and multiply it by…