general ledger

Hi,  I am new to this community... I have a question.

How can I make a general entry to affect my accounts receivables G/L account without impacting my accounts receivable listing . The accountant had 

initially put it to allowance for doubtful accounts, now he would like to see it as part of the receivables. is this possible ?                                                                 I am using simply 50 premium accounting release 2014.2

  • If I understand your question correctly I think you would credit the accounts for doubtful account and debit accounts receiveable.

  • in reply to Sheda

    yes but he want to do it through general journal entry but it does not allow you to affect the receivable g/l

  • in reply to rosyg

    My understanding is that the AR is an 'Integrated " account. You must make sure nobody else is on the system. Turn off you account integration. Then post to the AR thru the GL. make sure you turn on your integration again.

  • in reply to medichair

    I just went to the general journal entries and made an entry and it took away from sales which I used to post to and added  it to the accounts receivable. It added to mine.  Is this what you want to do or am I still not understanding? It also posted to the GL.

  • in reply to Sheda

    Sheds it is not allowing me to do it ...when i put the g/l #1200 which is my receivable g/l it does not let me go in that g/l automatically like most other g/l "s ...maybe i have to create it

    Medichair  i am the only one on the system ( we are a small company) I don't know about account integration that you are talking about.

    thankyou

  • in reply to rosyg

    the two accounts i cannot access through general journal are the A/P and A/R

  • in reply to rosyg

    You can not do a general journal entry to dedicated accounts - A/R and A/P.  Your accountant can do the entry through the accountant version of Sage 50.  He/She will have to send you an updated backup which you would then have to load so that your A/R sub accounts balance to your GL.  That is of course if you do not need to do the entry into an individual client records.

    That is how I have done it in the past.  Hope this helps.

  • in reply to dglick

    thank you but this is what the accountant is asking me to figure out...he is not familiar with the way simply works. He has used Accpac if I'm not mistaken and that program allows this but obviously not Simply in the way it is behaving.

  • in reply to dglick

    Hi Rosyg

    You will go into the Accounts Receivable journal...the Sales Journal and create an invoice for this client. Instead of coding it to your revenue account the 4XXX account code you will code it to your doubtful accounts account the 1XXX account. You will be entering a negative number for the amount is to be Debited to  the Doubtful Accounts or a positive number if you are to Credit the Doubtful accounts.

    Whatever you do, DO NOT unlink the Accounts Receivable Control account as suggested in the above replies. Also DO NOT import entries from the accountant that affect AR. There are others too. IF you do either of those then your Control Account Accounts Receivable WILL NOT BALANCE to the Accounts Receivable sub-ledger.

    Hope this helps.

  • in reply to The Software Coach

    I am trying to do this as you suggest Jo Anne in the invoicing module and i am able to enter the g/l for doubtful accounts (which is the account i want to take away from) however i cannot enter the g/l for receivables in the invoicing (not allowing me to use it) so i guess there is no way around this without affecting my sales g/l

  • in reply to rosyg

    Hi Rosyg

    Please try the entry again. But this time when you do the entry look at the journal entry report for it before you post it. You are NOT supposed to be able to pick the Accounts Receivable account in the Sales Journal. That is the beauty of Sage 50 it picks the account for you, because it is linked to it.

    The only account you have to pick is the account for doubtful allowance. Once you have done that from withing the Sales Journal go to its menu bar and choose Report, Display Journal Entry and you will see the 2 accounts... Accounts Receivable and Allowance for Doubtful Accounts.

  • in reply to The Software Coach

    Hi all,

    Since this thread relates specifically to Sage 50 CA, I'm going to move it to that Support Group so that others can comment and add to the conversation as well.

    Thanks,

    Derek

  • I'm using Sage 50 complete and never have problems doing this.  

  • in reply to sbtbill

    This forum is for Sage 50 Canadian, which is not related in any way to Sage 50 Complete, or Sage 50 Line 50 UK.  This thread appears to have started in the wrong forum. 

    The original poster is using the Canadian software, and you are not, which would explain why you can do it and she can't.  Similarly, I can walk from my house to the Drumheller post office in under 10 minutes, and you probably can't, from yours.

    The three products are like orphans adopted by a rich tycoon.  They have lately been forced to dress the same in public at the whim of their master, but on the inside they remain pretty much what they always were, almost totally different.