Happy Business Starts Here

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

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 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
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 √

View solution in original post

1 REPLY 1
Highlighted
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 √

View solution in original post