Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Sales Invoice Entries are creating Batches in GL

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hello!

We are facing a problem, We post the Sales Invoice , But  it does not create any entry into GL , and the Invoices are  not appearing in the Unposted list in Sales Transaction Entry of Invoice Type.

Kindly help us in this regard,

 

Hilal Uddin

IT Project manager

 

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Invoice Entries are creating Batches in GL

    Dear Tim & Mohammad

    I appolgy for delay reply

    This might be  happening due to not full user access , I gave the user full access .

    For Invoices a batch entry is  created now in GL after posting , But  problem is that  all those invoices are also printed for those threre were no entry SLSTE created in GL.

    After Posting one invoice only successfully , the user is facing a problem  with the error " Your previous transaction-level has not finished processin please allow time to finish ........... " and he can not proceed , I ran  this  query " Delete SY00500 where BACHNUMB = User ID  'John '

    Again he is able to post only one invoice and after that again the same error " Your previous transaction-level has not finished processin please allow time to finish ........... " .

    I think this is happening due stucked up records ,  

    How to post those records/batches/invoices in GL as they are not appearing in the Sales invoice  look up ?

    How to eliminate this error permanantly

    Kindly Help

    Hilal Uddin

    Regards,

  • Tim W Profile Picture
    Tim W 2,925 on at
    Re: Sales Invoice Entries are creating Batches in GL

    I would also look to see if there are batches created at the GL by your sales posting process which themselves are unposted.  I've seen that when the fiscal period is open for sales but closed for GL and when we have an unbalanced GL entry.  We get that a bit as the logic to round a markdown does not match the ext price rounding so once or twice a month we have an unbalanced GL entry posted from sales but hung at the GL.

    Open Transactions -> Financial -> Batches and see if you have any batch names starting with SLSTE

    Tim

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Invoice Entries are creating Batches in GL

    1. Check Tools>> Routines>> Batch Recovery and make sure that your batch is not stuck there.

    No batch stuck Up.

    2. Check if your transaction affected your customer or not.  

    No, The transaction are also not affecting the Customer .  I checked in Customer Order inquiry report and I found all invoices  those are posted from Sales Transaction entry, but still appearing in the Unposted option.

    Now how to post all these invoices as these are not appearing in the Sales Transaction Entry Window  

    3. Check if the transaction exit in GL open transactions and the journal is unposted. -

    There is no transaction available in GL for the problematic ones. So , not came into GL

    4. Check your posting setup and make sure that "Post to GL" is marked for "Sales Transaction Entry". I checked that option and it was marked ,  I will post today some invoices , then I will see the results.

    5. but it could also be if the sales is for  0 dollars and if the items have 0 cost.   There would be nothing to post.

    The items cost is '0' for some items but not all , But before  posting was o.k even with '0' cost.

    Kindly answer for  No.2 .

    Regards,

    Hilal Uddin

  • Dan Liebl Profile Picture
    Dan Liebl 7,320 on at
    Re: Sales Invoice Entries are creating Batches in GL

    Mohammad has a great starting point, but it could also be if the sales is for  0 dollars and if the items have 0 cost.   There would be nothing to post.

    Dan Liebl, CMA CPIM | Senior Consultant | OTT,Inc | DLiebl@OTT-inc.com

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Sales Invoice Entries are creating Batches in GL

    Hilal,

    Many things to validate:

    1. Check Tools>> Routines>> Batch Recovery and make sure that your batch is not stuck there.

    2. Check if your transaction affected your customer or not.

    3. Check if the transaction exit in GL open transactions and the journal is unposted.

    4. Check your posting setup and make sure that "Post to GL" is marked for "Sales Transaction Entry".

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans