Skip to main content
Answer

Sales Order Accrual Report - (Shipped Not Invoiced )

  • June 30, 2022
  • 3 replies
  • 367 views

bigil
Freshman II
Forum|alt.badge.img

Is there any option or Report to see the details of the Sales Order Accrual Report - (Shipped Not Invoiced )

Needs to see the details of Shipped Not Invoiced GL account based on Shipments Confirmed and IN update done but not Invoiced .

 

Similar to Purchase Accrual Reports 

Best answer by mvolshteyn

@bigil , here is the example of GI which shows the shipped not invoiced account per shipments (and periods) . It shows only shipments which were issued from inventory and not invoiced when the ‘Use Shipped Not Invoiced Account’ as checked in SO Preferences

You can build a report based on this GI structure if necessary

3 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+17
  • Captain II
  • June 30, 2022

Hi @bigil  

There is currently nothing out of the box for this. You would need a customized report for this. How are you tracking the Shipped Not Invoiced GL account?


mvolshteyn
Acumatica Moderator
Forum|alt.badge.img+3
  • Technical Account Manager in the ISV Team
  • Answer
  • July 4, 2022

@bigil , here is the example of GI which shows the shipped not invoiced account per shipments (and periods) . It shows only shipments which were issued from inventory and not invoiced when the ‘Use Shipped Not Invoiced Account’ as checked in SO Preferences

You can build a report based on this GI structure if necessary


Forum|alt.badge.img

[Use Shipped - Not - Invoiced Account]

Thank you for the valuable information shared.

We use the Shipped-Not-Invoiced Account on our order type to ensure that it generates an inventory transaction. The release of the inventory Issue on the Issues form (IN302000) post the the correct GL accounts, How do you set the Sub Account to post to the Warehouse segment values?

I have reviewed the posting class settings, reason code settings, but cannot find the accounts that will allow you to set the criteria for the Issues transactions

Retha