Happy Business Starts Here

Highlighted
Support SME

How to locate certain invoice in Journal Entry basing on GL Segment Rule name?

How to find in which Journal Entry a certain invoice is included?






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √

1 REPLY 1
Support SME

Re: How to locate certain invoice in Journal Entry basing on GL Segment Rule name?

Response:

1. Open the invoice(e.g.INV00291326) and confirm the invoice date of it  => 02/01/2016

Screen Shot 2016-03-15 at 4.28.30 PM.png

 

2. Locate corresponding journal run basing on the invoice date => JR-00000005

Screen Shot 2016-03-15 at 4.22.22 PM.png

 

3. Since there is a GL Segmentation Rule already set, it will help us narrow down the journal entry we need to search. => VBS GL Segment


Click into the GL Segment Rule to see its details.

Screen Shot 2016-03-15 at 4.31.52 PM.png

 

4. After confirming what segment it is using, go back to the invoice owner account to check exact value of them. => Accounting Sales Channel: QA, Accounting Company: 20

Screen Shot 2016-03-15 at 4.41.05 PM.png

 

5. Go back to the list of Journal Entries and check if there is a record fitting conditions below: => JE-00000172
Transaction Types Included = Invoice Item (because customer is asking about invoice)
Accounting Sales Channel = QA
Accounting Company = 20

Screen Shot 2016-05-17 at 11.12.58 AM.png

 

6. Download Journal Entry and open it with Excel, then search for the keyword "INV00291326". => Records found

Screen Shot 2016-03-15 at 4.34.04 PM.png






If you found my answer helpful, please give me a kudo ↑
Help others find answers faster by accepting my post as a solution √