570
If i Received and invoice and post a purchase invoice successfully. But its not goes to GL, The next GL number is always 114. Please help to solve this problem.
Today i modified one vendor Id and i create 2 seperate Dummy account(1.Purchse catogory-Inventory 2.Payable Catogry Accounts payable) for this Vendor .
*This post is locked for comments
Well what you could do is require them to start using batches and then print edit lists to review the transactions before they post them. Maybe there are errors in the batch. I feel like it is always a good idea to use a batch instead f Transaction Level Posting due to the edit list that will tell you if there are any errors.
While it is posting, can you check the process monitor? Do you have any third party add-ons that might be getting in the way?
I have the "Your transaction level posting has not finished issue with several clients and while the delete statements against the Dynamics and Company databases are helpful they are only a band-aid. How can I resolve this issue once and for all? There are times when it happens several times a day and asking companies to log off several times a day is ridiculous...they laugh at me. Oh and don't like I haven't created several user ID's to prevent down time...it just seem like no one knows how to resolve this.
Thats great!.
How did you get on with the SOP posting problem? Did you attempt the SQL query?
Ian.
I am not enable the setup Post to genereal ledger in In posting set up window.
i just enable that set up the problem was solved.
Hi Jenny,
What was causing the GL issue? (just interested)
For the sales issue refer to the knowledgebase article below:
Best regards,
| 1. | Have all users exit Microsoft Dynamics GP. | ||||
| 2. | Make a backup of the company database. | ||||
| 3. | In SQL Query Analyzer, run the following delete statement on the SY00800 table against the DYNAMICS database. | ||||
| 4. | Look for the problem records in the SY00500 table by running both the following statements against the company database. Note In the following statements, <xxx> represents the user ID that contains the error. | ||||
| 5. | If you have records that are returned with a blank BACHNUMB field, use the following delete statement. | ||||
| 6. | If you have records that are returned with a User ID in the BACHNUMB field, use the following delete statement. Note In the following statement, <xxx> represents the user ID that contains the error. | ||||
| 7. | Verify that you can select existing documents in the Sales Transaction Entry window. To open this window, click Transactions, point to Sales, and then click Sales Transaction Entry. If you want to delete an existing document, click Delete. If you want to void an existing document, click Void. | ||||
| 8. | If you continue to receive the error message, or if you cannot select the existing documents in the Sales Transaction Entry window, run the following scripts in SQL Query Analyzer against the company database to locate problem records in the SOP10100 table. Note In the following scripts, <xxx> represents the user ID that contains the error. | ||||
| 9. | Note any records that are returned, and then run the following statement in SQL Query Analyzer to delete the problem records from the SOP10100 table. Notes
| ||||
| 10. | Use the appropriate step:
| ||||
| 11. | In the Series list, click Sales, and then run the check links procedure on the Sales Work table group. | ||||
| 12. | If the transactions did not post in the Receivables Management module and in the Inventory module, reenter the transactions in the Sales Transaction Entry window. |
Thankus your valuable replay and i solved the problem in GL.
Please explain me how to solve the problem in sales transaction.
Hi Jenny,
You have two problems so.
1. Sales Transaction Entry problem: This is a common issue generally caused by a network error. Some tables have become locked. You will need to get all users out of GP and run some SQL queries in order to relese the tables. Are you familiar with running SQL queries? Hae you access to customersource / partnersource? If not I can paste a techknowledge here that tells you what to do.
2. Payables Invoice not creating GL Journal.
Best regards,
I am using version GP 10.
I tried to this ways , but still the problem is there, Why not automatically created the journal entry.
But in my sales transaction entry window there was a problem. there was a error message " your previous transaction - level posting section has not finish processing .Please allow time for finish. If you belive it has failedlog out GP and log back in to recover transaction.
It will affect for GL or not
Hi Jenny,
There could be a number of reasons for this. Best torule out the more straighforward ones first.
Does this just happen with one vendor? ie: If you post an invoice for other vendors, do they automatically post to the GL?
What version of GP are you on?
Best regards,
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (