Hi Lise:

When you are entering historical amounts into the sub-ledgers you are actually putting carry forward information from the previous year meaning prior to June 1st 2019. In the Setup, settings, Company, Information section the earliest date needs to be changed to the earliest date of the historical carry forward information you have to enter into the various modules E.G. Payables, receivables, etc..

Hope this helps!

Hi Agate:

Wish that it was that easy.  Tried that - this is the answer I get.

Remember, I started the company with a previous previous year date, entered the historical entries only into the GL account codes, then posted previous monthly entries through journal entries for the GL Codes.

Now I'm trying to enter the year ending 05.31.20 totals into the historical entries, but it won't let me.

Thought I would do a year-end in order to bring it in line with the entries I want to make, but again, it won't let me.  Gives me the error I posted in my initial question.

Slept on it, and wondered if I unlinked the accounts it would let me do a year-end, then I could enter the historical entries.

Or I will delete the journal entries I made, clear everything, then do a year end (or at least try).

Any thoughts on that?  Or should I zero out those control accounts, then try it?  Gr... there has to be a way!

Lise

Lise Lecours said:

Remember, I started the company with a previous previous year date, entered the historical entries

The way the program works is that "Historical Entries or Historical Amounts" are those transactions that happened before using Sage 50, not before today.

Because you used the first fiscal year of Jun 1/19 to May 31/20, you must enter the outstanding A/R and A/P as of May 31/19 as Agate indicated.

Once those amounts balance with the Opening Balances of your Accounts Receivable and Accounts Payable on your Balance sheet then you should be able to move the year forward.

You can check your integrity from Maintenance, Check Data Integrity to make sure you are balanced.

Lise Lecours said:

Or should I zero out those control accounts, then try it?

Would you really consider that to be accurate?  If your closing balances as of May 31/19 have amounts in them for specific accounts, then the logic is that there will be a balance on Jun 1/19 when you start the day.

Hi Richard:

Thanks for your reply.

Ok.  There has to be a solution to this.

The system won't let me put in any of the historical transactions past

so I can't enter any historical information.  Which is why I wanted to do a year-end in order to bring those amounts into the system. 

QUESTION:  Can I do a year-end and then enter historical transactions after doing that?

If that's the case, I will delete the 2019~2020 journal entries I put in, then do the year-end, and re-input the journal entries, then enter the historical entries.

WILL THAT WORK? 

WILL IT LET ME ENTER HISTORICAL TRANSACTIONS AFTER DOING A YEAR-END?

Thanks.

Lise

Hi Lise:

I do not think you can close the year-end without putting in the history! If you have put in your journal entries for the first year, then type in your history amounts into payables and receivable with a June 1st date. Check your data integrity, if both columns agree then finish by closing your history. Do a backup, then do a fiscal year-end procedure, meaning advance you year to the next fiscal period.

Hope this helps!

Lise Lecours said:

The system won't let me put in any of the historical transactions past

That's because there can't possibly be any.  You told the program you are using Jun 1/19 as the first day you are using Sage 50.  May 31/19 and before is history, not May 31/20 and before.

Richard S. Ridings said:

The way the program works is that "Historical Entries or Historical Amounts" are those transactions that happened before using Sage 50, not before today.

I am not sure why you keep asking to put in "Historical Transactions" for a period of time that is not Historical according to how the program was created.  You need to figure out which customer and vendor invoices were still outstanding May 31/19 and enter those as historical transactions on the customer and vendor ledgers.  The total of all customer outstanding invoices should be the Opening Balance amount you entered into the Accounts Receivable account when you entered the trial balance opening balances.

Lise Lecours said:

QUESTION:  Can I do a year-end and then enter historical transactions after doing that?

No.  The programmers think it is a better idea to get your company working properly and balanced before you move to a second year.

Lise Lecours said:

WILL THAT WORK?

I don't know.  Will the balance of all accounts that are linked match the subsidiary journal's totals?  eg. Accounts receivable balance match the total of all outstanding customer amounts from "The last day before you started using Sage 50".

Lise Lecours said:

WILL IT LET ME ENTER HISTORICAL TRANSACTIONS AFTER DOING A YEAR-END?

No.

Have you checked your Data Integrity?

Do you have a list of outstanding customer invoices and vendor invoices from your previous bookkeeping system as of May 31/19?

Are there any other amounts that are out of balance according to your data integrity check?  A/R and A/P are not the only linked accounts, payroll and inventory are linked as well if they are in use.