By using this website, you agree to our Terms of Use (click here)
There are probably better ways to go about this, but I'd like to see if there is an easy way to add Invoice # to the primary Sales Orders generic inquiry?
I'm wanting a quick sanity check to see what SO's have been invoiced / haven't been invoiced.
I appreciate any assistance!
Hi, P -
Disclaimer - I suggest making a copy of the GI for anything other than the most basic modifications to provided/existing GIs. However, this is a good example of a basic mod! You do not have to add any tables or joins/DACs or Relationships:
- Start at the Generic Inquiry screen for SO-Sales Order. Navigate to the Results Grid tab.
- Add a row for the SOOrder Object and the InvoiceNbr Data Field. (The Visible box is automatically checked, so the column will appear without your having to add it via the Column Configurator of the list).
- Save.
@kpwise Thanks for the reply, Kimberly!
I actually went that route, but I realized that it would only pull Invoice Numbers for SO invoices, rather than the AR Invoice number.
We are indeed invoicing sales orders, but our current invoicing process (recent go live, we are trying to figure this out as we go) does not create SOInvoice documents, just ARInvoices.
Do you think we may be going about our invoicing incorrectly? I'm a bit confused on the difference between SOInvoices and ARInvoices, or at least what important distinctions exist between the two.
Figured it out - left joining ARTran on SOOrder. I completely missed the ARTran.SOOrderNumber field initially.
@p-bass Just keep in mind that you are now getting one record for every Invoice Line as opposed to one record for every Sales Order.
Regarding SO Invoices vs. AR Invoices, I personally think it's really confusing that there are two invoice screens: Invoices (SO303000) and Invoices and Memos (AR301000). Especially because they each have their own invoice format associated with them.
For clues as to when an invoice lands in one screen or the other (or both), compare the CONDITIONS tab in the definition of these two Generic Inquiries: Invoices (SO3030PL) and Invoices and Memos (AR3010PL).
@p-bass - I think likely the reason you have SOInvoices and ARInvoices in Acumatica is to allow for segregation of duties so that users who should only have access to inventory Sales can't also access non-inventory invoices (i.e. project invoices). The 2 different screens also have different options (i.e. SOInvoice screen CO303000 has options for shipments, orders, etc.) which are not available on the standard ARInvoice screen (AR301000). Once an SOInvoice is posted, it will show up in the AR Invoice screen, but not before.