Thanks very much for your ongoing support/responses. I will review your latest post and do some testing. Unfortunately we do not have a test environment, so I can only see the result on my own Member account, not a bulk action.

Hi: Not from an expense report (e.g. not wanting to invoice customers for some expense recovery, like time for a lawyer office, or charges related to a Vendor). This is creating invoices from the Item I mentioned, one per Member based on the Category and Item, and emailing them the invoice with PDF attachment. From your…

Hello, thanks for your new comment. I don't really follow your questions. Here is a summary of what I am trying to do with an example if that helps: I need to first create invoices for 100 Members. These members will be invoiced $230 per member (on June 15th) for their upcoming membership fees. They are identified where…

Hi: I removed those two dates and records do not appear. Please see the attached screenshot for the path to get the Invoice Members screen. Thank you.

Hi: It is part of the Member record (see screenshot if I go to Members\List\Members\Search. Correct - we have 283 members (mix of Developed and Undeveloped properties, some Members own both types) so it would take too long to do them one-by-one. There are Items defined for the invoice amounts for a Developed vs an…

Hello, back to revisiting how to perform this function. No clear answer yet. The task is: We are a non profit that has "Members" in Netsuite this is the same as Customers There will be two new charges to be invioiced in June. If a Member meets the condition where they have a record in Netsuite where "Developed"=Yes, they…

Hello: Because we are a not for profit association, we have Members, not Customers in Oracle but they get treated the same for invoicing/payment etc. Can you please let me know the steps to follow then to create the two invoices, then assign the members to one or the other of the two invoices. Then they have to be emailed.…

Hi, thanks for your help. You said "so all the invoices that meet the saved search criteria will be pulled and included". The invoices have to be created first to be pulled, they are not "existing invoices" so how are they first created? We will need two, one charging $230 and another charging $115 to go to the two…

Hi: The amount to be invoiced for any Developed property member is $230. The amount to be invoiced for any Undeveloped property member is $115. Those people can be identified where the Member Category field = either Developed, or Undeveloped, so there would be two searches. I'm not following your steps as that appears to…

Hello: It is more comprehensive than that. This is the workflow. We need to establish two new amounts to be invoiced. One amount is $230 for when the field "Category" = Developed in the member record. We need a second $115 amount invoiced if on the member record the "Category" = Undeveloped. Once the invoices are created…

We have asked our rep about a Sandbox, but he never replied about having this as an option. I would like to test it outside of the "production" database, to avoid having to do more corrections.

Hmm, on the JE screen, if I select the Member ID/Name in the "Name" column, will that attribute the $20 to that Member, then when I do step #2 the Customer Refund using that specific Member/ID will that clear everything out?

Hopefully one last question on this. On the JE, does the A/R first have to be set up in the name of the Member who overpaid, or can it appear this way, as a non-specific CR to A/R - not associated with a specific Member account? Thank you Scott

Hi: Can/should the first entry be a Journal Entry, and the second entry done through a Customer Refund (in our case Members/Accounts Receivable/Issue Member Refund)?

Hi: The GL impact is: DR Bank $230.00 CR A/R $230.00 which under recorded the Member's actual payment. Making the bank reconciliation off as the bank is $20 "high" without the extra $20 showing up in the GL. Thanks for your patience with this, Oracle is totally new to me so we've had to do a lot of self-learning with a…

Hi Tigran $250 went into the bank

Hi: I may be overcomplicating this. So should the entries be: DR A/R $20, CR Sales-Donations (as an example) to recognize the $20 for the Members account. Then will a Customer Refund transaction reverse that so it CR A/R making it $0, and Debits Sales-Donations $20 so that revenue is not recognized, and does the Refund…

Hello thank you for your answer, A/R was originally only debited for the correct amount of the invoice which was $230. The bank does need to be credited for $20 when the refund cheque is created - but - if A/R is debited the $20 won't that be overstating A/R?