Lost unposted patch
Hi, I created a patch in 26 march, it was 50 line and every day I was adding more lines to post it at the end of the month. Today i was trying to open the patch but there is a message says there is no transactions. What is that mean?! Should I record all lines again ?! Please advise
*This post is locked for comments
Just a final follow up to not my posted question - but - if an account is referenced in History ( at any time ) I am thinking you can not remove the account from the GL00100 or anywhere for that matter - would that not break something in the Payables for example?
Just thinking out loud to my own question.
I was thinking about that ( budget ) but wondering how far back - this company seems to have kept all the budget import templates ever made - not tossing anyone - list goes back 10 years - crazy.
But I will be looking here.
Hi Bill,
I'm guessing if that account is out in some transaction somewhere, I would search the database for the account index. The search for a number will most likely return results that do not have anything to do with your query, but you should be able to tell if it's relevant by looking at the table and field value of the hits. If you see something in a 10 or 20 thousands file, I'd investigate. It may say 'unposted', but I have found that error message before on things that were in a work table. Depending on the size of the database, this query could take a long time to run, but sometimes it just needs to work :).
If you do not have a SQL search tool, you can download a FREE one from APEXSQL.com.
Kind regards,
Leslie
Ok it is Friday and I am beat - I am not sure I know where to go to pull out the big guns, but being from Texas I am sure you have the answer Val.
This client uses the GL and Payables only - no inventory, nothing else.
I have looked in the PM Work tables ( I think ) as well as the GL Work - nothing.
I did a full reconcile of GL and removed an number of JE records from the GL tables that had no batch details, but that did not change much.
Any assistance would be great
Hi,
At this point I'd search the entire database for the Account Index number that is attached to that account. Sometimes you've got to pull out the big guns. Once the query finishes, it should be pretty easy to eliminate random occurrences of the number by the name of the column the value was found in.
Good luck!
Leslie
Leslie, bit of an off shoot question - I have an error that says an account is part of an unposted transaction and therefore I can not delete the account. The account is marked in Finance as Inactive.
I have searched Gl10100 - GL10000 - GL10001 - nothing
I have run all the Batch Reconciles in Finance
This client has payables and GL only - simple installation
Question: Where else to look for this transaction?
First I'd run check links on the unposted transactions. If it's GL, I'd also reconcile batches. Go to Financial | Utilities | Reconcile and then choose Batches. For Check Links use Financial and select the Transaction Work logical file. If it still does not show up, look in SQL and check out the entries in the GL10000 and GL10001. Also check the GL20000 to make sure it wasn't posted by mistake. If you still can't find it, you can either re-enter it in the GL Entry screen, or put it in an Excel spreadsheet and past it into the GL Entry Screen.
Kind regards,
Leslie
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
