Duplicate Journal Entry numbers, Customer name only listed on one entry. How to pull the name for the other entry, using the GL Account?
Hi all,
I have a large data set of Journal Entries. These Journal entries record all Customers who have been written off to bad debt.
We use:
Account#1 to credit the AR for when the bad debt is recorded, or debit it when the recovery payment comes in. This account always has the Customer name tied to it.
Account#6 to debit the bad debt expense. This account may or may not have the Customer name tied to it.
Account#7 to credit the bad debt recovery. This account may or may not have the Customer name tied to it.
Account#8 to debit an expense to credit card fees. This has absolutely nothing with what I'm trying to accomplish, however I must have Netsuite return the results of Account#1 so I can have all instances of Account#1 solely for the lookup of the Customer Name. The plan is to delete all of these Journal Entries that debit this expense and it's appropriate credit to Account#1.
I'm attempting to get all instances of Accounts 6 and 7 (only, not 8, nor its corresponding Journal Entry to Account#1) with the customer name. I can't simply use an xlookup, because of course, it will only return the first result in my list, which may be blank.
If I filter based on the name, I may retrieve Journal Entries that are not associated with Accounts 6 and 7.
Columns are:
B: Journal Number
C: GL account
D: Department (Ignore)
E: Customer Name
***
EDITED TO ADD:
Journal numbers in column A are duplicated. At minium twice- once for Account#1, and once for whichever other account, 6, 7, or 8.
Customer Names in column E may or may not be repeated.
***
Any help is greatly appreciated! Here's a screenshot of what I'm working with:
[link] [comments]
Want to read more?
Check out the full article on the original site