You’re offline. This is a read only version of the page.
3,125
Good day,
License= Microsoft GP 10.0 BE
I'm looking for an invoice that the information doesn't appear displayed on reports>financial> trial report>
*This post is locked for comments
Hello Ian,
a) Inquiry #1 = The setup is the following could you please advice if this is correct?
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
b.) Inquiry #2:
The posting and tax dates default to the transaction date entered, how can i change them?
Hi Mayra,
Gald you got it explained. Looks like your posting set up is set to take the GL posting date from the Batch and not the transaction. I always prefer to use the transaction date as the posting date, and then these sorts of issues cannot occur. You can stop transactions back posting by keeping your open / closed gl periods under review.
To view your posting settings go to Tools >> SetUp >> Posting >> Posting.
Select your series and transaction type. On the middle right of this window will be something like 'Take Posting date from: Batch...or Transaction'. I'm guessing that Batch Date is selected.
Check internally if there is a good reason why you are using the batch date before you make any changes.
Also on Dates, you can have different Transaction, Posting and Tax dates. To see these click on the blue arrow beside transaction date in the transaction entry / enquiry window. The posting and tax dates default to the transaction date entered, but they can be changed if required.
Best regards,
Good day Ian,
Thank you. You were on the right track. I was excluding that date when you print your TB.
I had the available data but didn't process it in my brain properly because I had found out that the process of the sales distribution of accounts was posted on the daily entry 10/03/2010 but the invoice was posted on 05/04/2010. Which is rather confusing because i don't understand how this could have ocurred? Is there any way of preventing this issue from ocurring again?
I checked the Trial Balance and yes the account of the tax is being displayed on 10/03/2010 with the audit code SLSTE0000456.
Is there any way that some one erased the a batch and then it was assigned automatically by sequence to the process of the invoice?
Good day Jesus,
I was unable to find the transaction because it has already been posted.
Thanks,
Mayra
Hi Mayra,
Are you sure that the Trial Balance you are printing:
1. Includes the accounts you need.
2. Includes the date range of the transaction. Remember there can be a difference between the original Transaction Date and its posting date - and since you are using batch level posting, the GL posting data may be coming from the batch...which could have been incorrect. So while the Transaction appears in Receivables in May foe eaxmple, it could appear in GP in June - all dependent on how it was posted.
If its in RM, then the most likely three things that can have happened are:
Drilling back on the origial transaction in RM, click on the Blue Arrow (anyone know the proper name for this???) beside the date field, and you will be able to see the Document Date and the Posting Date. For good measure, check the posting date on the RM batch this transaction was in. This will give you some idea of there is an issue with RM Transaction date versus GL Posting Date.
Best regards,
check Transaction>Financial>General, see if you can find your transaction there as unposted in GL module.
Good day Frank,
No it does appear on the GL.
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.
So this invoice appears in Payables or Receivables module but doesn't appear anywhere in the general ledger?
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,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (