web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Sales Invoice posted b...
Microsoft Dynamics GP (Archived)

Sales Invoice posted but unavailable info in certain areas

(0) ShareShare
ReportReport
Posted on by Mayra Humprey 3,125

Good day,

License = Microsoft GP 10.0

An invoice was created but when I check the account numbers on inquiries> financial>  it doesn't display any info.

I got the information of the account numbers when i check them out on the invoice page when i click distribution.

Because I'm to the point that i finally found the master id so then i checked on inquiries an got the audit code and the id of the lot but i can seem to go through from there.

 Thanks in advance for you advice:)

 

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,619 Super User 2025 Season 2 on at
    Re: Sales Invoice posted but unavailable info in certain areas

    It's possible that the GL batch was deleted instead of being posted or, maybe the batch hasn't been posted yet.  Have you checked for unposted GL batches?

  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Sales Invoice posted but unavailable info in certain areas

    Also, in your Positing setup's verify that the post to and post thru are checked in Sales module and Sales Transaction Entry option.

     

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Sales Invoice posted but unavailable info in certain areas

    Good day Frank,

    I did do the procedure of the scavenger hunt. After the invoice is posted. Normally the procedure we follow is we go transactions> sales>cash receipts and input each sales in a lot and then we go to transactions>sales> receivables batch entry and post the transaction finally we go to transactions>financial> bank deposit and post the information of the checkbook id and associate the invoices to the deposit and then it gets posted and we print out the report and take it to the accounting department. The report never indicates the tax details just the details of the accounts of the bank and receivables.

    So basically i anuled the receivables batch entry just to make sure the procedure was right and then input the information again and posted the bank deposit. Still when I go to reports>financial>trial balance> and just detail the filters that i want the movement of the accounts of income tax that invoice doesn't show on display.

    I checked on the inquiry> sales>receivables summary inquiry and the information was deducted from the customers statement.

    So i really i'm out of ideas and hitting a wall, maybe something got deleted as you mentioned that problem that i'm encountering now is that the users are blaming the system that it automatically erased the information, and because the BE version is that securily suffisticated to indicate who did the procedure i'm exhausted.

     Thanks in advance for your advice on how to solve this or atleast an idea of where to look. Have a nice day.

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Sales Invoice posted but unavailable info in certain areas

    Hello Sagi88,

    Well honestly I'm not sure how to verify the information you indicated, could you please advice the procedure?

     Although the odd thing in general up to right now this is an isolated incident, but i need to make sure i check everything because the users are saying the system doesn't work. So you can imagine management breathing down my neck for that nice comment.

  • Sagi88 Profile Picture
    Sagi88 2,250 on at
    Re: Re: Re: Sales Invoice posted but unavailable info in certain areas

    Hi Mayra.

    You need to go to the Administration Pane, Select Posting and Posting

    Select the Sales Module and select the origin, by your description should be Receiveable Sales Entry.

    You will see the options below showing the Post to and Post thru check boxes.

    If the post to is not checked no GL Entries are created when the invoice is posted.

    If the post to is checked but not the post thru and GL Entry is prepared and not posted automatically. You will have to goto the Financial and post the sales gl entries batches created. 

    These should both be clicked.

    Something you should try:

    In Smartlist select Financial - Account Transactions

    Using the default option (*), click columns and add the columns Document Status, Originating Master ID and Originating

    Document Number.

    These fields will contain the Customer ID and Invoice Number respectively.

    Using the search option use either one to limit the search to an invoice you know is one that you are looking for and see which transactions appear.

    If they don't appear the GL entry was deleted.

    If they appear and the Status is Work they need to posted.

    If they say open they were posted and you should check to which period they were posted. Maybe a date issue.

    Hope this helps you out.

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: Sales Invoice posted but unavailable info in certain areas

    Good day Sagi88,

    In relation to what you mentioned "Administration Pane, Select Posting and Posting" do you mean the following :microsoft dynamics> configuration> system> process server?

    Note: The odd thing is that it only has occurred with this invoice.

    I tried the option of checking out through the smartlist and the document status= open, the originating master id= EMPRMARI001 and the originating type = normal

     The odd thing is that the details of the entry transaction display that the date is 10/March/2010 but the invoices date says 05/April/2010 which is rather odd, well to me because i can understand how it could happen.

     

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: Re: Re: Re: Re: Sales Invoice posted but unavailable info in certain areas

    Mayra,

    Take a look at that Posting setup window again and check to see what selections have been made in the 'Create a Journal Entry Per' and the 'Posting Date From' options in the upper right quadrant of the window. If you are posting from the batch date then it is not only possible, but likely in some cases, that the invoice date and the transaction date are two different dates. I'm not clear on what the exact origin should be. I saw one suggestion for receivables, but I would also check Sales Transaction Entry if you are using SOP to originate your invoices.

    I've seen the situation you are in before, the users blame everything on the system when what is really needed is some training. Many of your queries could be answered and your users frustrations be calmed if you could get someone to invest in a little training. I never understand why a company would spend 100K on a software and then not invest any money on getting their people properly trained. I'm not talking about the partner comes in and spends a few hours with you - I mean real training with a certified instructor.

    You must have an unbelievable amount of patience :)

    Kind regards,

    Leslie

  • Mayra Humprey Profile Picture
    Mayra Humprey 3,125 on at
    Re: Re: Re: Re: Re: Re: Sales Invoice posted but unavailable info in certain areas

    Good day Ms. Vail,

     Thank you this help me get a better perspective of things.

    I went to tools>setup>posting>posting then selected the series= sales and the origin = receivables sales entry.

    In create a journal entry per = transaction is marked

    Posting Date from= Transaction

    If Existing Batch = Create New

    Actually I am looking for someone to train us and that is actually a certified instructor but i'm being rather cautious because well i'm in central america so most of the certified instructors or mainly in other countries that we rarely have options to aside from the fact that all the users i have are only native speaking people (spanish only).

    Thank you very much for your always comprehensive support.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans