Have had 2 clients in the last two weeks come up with mysterious beginning balances on accounts as of the first fiscal year in history. Digging into DFDM, I've found a posting with a BLANK Fiscal Year and Period in both cases. In neither case could I…
I am using Sage 50 Canadian Edition 2021.1 I used "open as an admin" to open the sage program. I am in the single-user mode and logged in as a system admin. I have some issue that cannot post into a future date. cannot add departments in payroll. when…
We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account.
To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…
We had our PPP loan forgiven, and our CPA told me to book it in under "Non-taxable income". I spoke with one person that set to setup account 950 to book this as non-taxable revenue. It still shows up on the Income Statement, is this correct?
My users are experiencing an issue where the accounting department is still performing month end closing processes for the previous month after start of the next month so the current General Ledger period is still last month and does not match the current…
Hi. Just setting up a new company from Dynamics.
Their year-end is May 31st. In order to have historical transactions, I started the company as of 2019. Entered the GL historical amounts, then entered each month's adjustments for the year 2019~2020…
All,
I am new to the product. We are running BW2019 as a Cash Accounting system. We have entered Cash Disbursement Journals for the checks we wrote, but we did not put a description so that we know who we wrote them to. How do you go back and correct…
Hello All,
I would like to have a seamless integration from Sage 300 People to Sage 100c.
First of all is the seamless integration possible , If yes , which of the layout below should I use?
Hello! I've been looking through the forums for some time trying to find some assistance to our reports being out of balance, some posts and responses have helped me track down unusual information, but nothing conclusive to help fix the issue(s):
-…
When entering a JE there is the individual line comment; is there any way to print that individual comment per line when printing a GL (or an individual account in the GL)?
Hello Team,
I was trying to create a new RECURRING BATCH ENTRIES through the GL Setup >>> Recurring Entries >>> Filling the GL Recurring Entries screen and click Add.
After clicking "Add button", this error comes up " Sequence Number Dispenser.…
Hi All,
Suddenly my My Reports / General Ledger / Adit trail report that I use to keep a record of journals posted is suddenly coming up with a message stating that there are no records to print. This is part of our month-end process and they printed…
Hi
I am creating a Group of service items in order to override Transaction Type IN (invoice) default general accounts for Debit/Credit. I did the following:
- created the Group "Service CEB Utility"
- created a service item "ELEC001"
- Put ELEC001…
Has anyone ever seen this error before when importing a cashbook batch.
I have tried the solutions in this knowledge base article with no joy.
KB Article - Object was open.pdf
Hello all!
I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…
A client has a need for a General Ledger Account Code made up of more than one segment, but with the option of not using delimiters. Is there a way to do this in Sage 300?
For example, Segment #1 = Cost Centre, XXXX; Segment #2 = Account, XXXXXX
Instead…
Hi
I have to do some cashbook entries for transactions over a 6 months period. Needing some best practices concerning:
1) Do I need to create and separate each type of transaction (BankA_CASH, BankB_CASH, BankA_DEP, BankB_DEP) in separate batches…
We have a frustrating situation where, if someone prints a GL report to screen and leaves it open, another user cannot login to the GL application. They receive an error message, "GL transaction file in use." If the user in the system closes that report…
when deleting a transaction Is the data updated in the GL?
I am asked to delete some transactions from the previous year and I am not sure if the Ending Balance will be updated
Thank You
Sage 300 2020 PU 2. A customer receives the error message, 'The Header Journal Source Code AR must match the Batch Journal Source of GL' when importing a batch from AR (Create G/L Batch). The batch contains AR-IN and AR-PY transactions. Source Codes are…
I created our registered charity in SAGE but I skipped the step to import or use the default chart of accounts when using the Wizard.
Now it appears that I have to create every account individually
or create a new company to be able to use the Wizard…
Hi
I need to create following structure of accounts:
Revenue -> Audit -> Local
Revenue -> Audit -> Offshore
Revenue -> Advisory -> Local
Revenue -> Advisory -> Offshore
etc..
I decided to go with segmented COA and created Segments like:…
Hi
I am new to using Sage 200.
I am trying to insert some transactions (purchases) from supplierA.
As shown below, all transactions will go under Purchases.
1) How can I make it go under Purchases --- SupplierA account?
2) Do I need to create…