New year is already created but now need to close the previous fiscal year to retained earnings. How do I create the closing entry if the new year is already created?
Has anyone figured out how to get income to show in Box 144 of the T4A in Canadian Payroll?
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 how…
I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
i have a few employees that have chosen to be cpp exempt on account of turning 65 and filing a cpt30 form. the x is missing in box 28 on their t4 for some employees and there for others
We have been working with a customer who has had some issues with their bank rec. We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error:
Requested payment was cleared pr…
Hi,
I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported?
Thanks for all you do
Client has a request to change the customer id but the customers belong to a national account. Reason for the change is that the customers are changing affiliations and client built in national account identifiers in the customer number. Most of the customers…
I have a client who's vendor is giving out some accessories with a 100% discount in a certain month. On Purchase order, the client is capturing this accessories with the previous cost but discounting it at 100%.
The challenge is and I stand corrected…
So I posted a transaction in Bank Services (deposit) in January - it was the wrong amount (posted say $150 when it was only $100) - so I went in and reversed it and reposted the transaction with the correct amount. No big deal right? well now my boss…
Here is our scenario. We give a customer a qoutation in Order entry. The customer then goes to the cashier to pay or payonline. Then the receipt is taken back to our sales team to ship and create invoice. Isnt there away that at the time of paying the…
How do you remove a posted adjustment in AR. I had a xact that I adjusted incorrectly, entered the correct adjustment but left with an adjustment that is essentially hanging. I can't adjust the adjustment because the document's balance is 0. Any…
Sage 300
Any solutions that can Auto-Apply mass open documents for all Customers in the A/R?
Credits (Open Receipts, CN etc) against Debits (Invoices, DN etc) using a certain criteria e.g. Date etc
Sage 300 Cloud
How possible is it to send both A/R Invoice and Statement in the same Email communication as separate attachments.
Sage 300 2019 PU7
While sending A/R Invoices/Statements via Email, the system sends some e.g. 50-90 and returns the Error below;
"Description: Mail delivery failed. Use the Email tab on the Company profile screen to send a test email and confirm that…
Hello,
I am trying to run a an IS through the statement designer function in Sage 300 ACCPAC. August would be period 1 of FY2022, however when I select this period, all the figures that come back are 0. If I select period 12 FY2021, everything runs as…
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…
Hi there,
I would like to create a budget report breakdown by month in columns side by side, what FR formula should I use for each column?
Thanks,
Zia
Customer Receipts are posted in the A/R as Prepayments because there is no Invoice.
There is a plan on when and how much the Customer should pay.
How can this Plan be managed in Sage 300 without raising an Invoice?
An invoice is raised at the end when…
Hello Team,
To receive the currency rate I use the following endpoint -> CSCurrencyRates
The response has the following structure:
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 Accounts…
Good day,
Sage 300 2021 PU2
I have a new Irish entity to setup which will be my first time setting up an Irish/European entity. In looking at the VAT/Tax reporting requirements I was wondering if there were any samples out there of the Tax Services configuration…
We have a client running 200 2021 with Product update 1. On the machine that is the main one (server), they get the above message when posting a combine Vendor request using Vendor Number Change.
Anyone have any sugeestions as to how to proceed.
A company wishes to setup Sage 300 for their operations in 4 different countries, 4 different currencies all reporting back to a single currency. There are two options
Option 1: 4 different Sage 300 Databases
Option 2: 1 Sage 300 database with a entity…
Sage 300 2019 PU7
How can we move some posted transactions (Invoices, Debit/Credit Notes, Receipts etc) between Customers in Accounts Receivable.
Break the Account move some and leave the rest.
Without creating Debit/Credit notes.
