Ideas for Acumatica

Feedback processing: We do not reply to all messages, but we do read them, analyze them, and work to improve Acumatica based on the feedback we receive. Ideas and comments may not appear immediately. Some legitimate ideas are flagged as spam and will be added when we review the spam folders.
Content: This portal is for product ideas and feedback only. If you need customer service assistance, contact your Acumatica Support Partner, submit a support case, or get assistance from community resources: LinkedIn Group or StackOverflow
No Reliance: Information is maintained on a best-efforts basis and may be changed without notice. Acumatica cannot guarantee the accuracy of the information provided or guarantee completion of features/ideas described on this portal.

Add PO Accrual Report that is period sensitive

Clients find it absolutely impossible to reconcile and audit their PO Accrual accounts using the reports in tools within Acumatica.  There are several reasons for this:

 

  1. The current report only shows that accrual amounts for POs that have not yet been billed against.  It does not offer the ability to show PO Receipts that were open as of the end of a given financial period that were billed in a subsequent period.  The accountants want to see what the PO Accrual balance is at the end of the period to ensure the balance is correct.  
  2. Drop Ship POs are included in this report, but Drop Ship PO Receipts do not generate an accrual transaction until after the Sales Order has been invoiced.  This means that if a PO was receipted, but no AP Bill was entered, the current report will include the Drop Ship PO Receipt in the Purchase Accrual report.  This makes the report unreliable because a Drop Ship PO receipt does not update Purchase Accruals until the customer is invoiced.  The accrual is not made at the time of receipt.  
  3. Drop Ship POs that have been billed by the vendor, but not invoiced to the customer would not be included in this report, but have the effect of debiting the accrual account without a credit offset.  Therefore the report will overstate the outstanding accrual balance because it does not account for PO Receipts that have been billed by the vendor, but not yet invoiced to the customer.  
  4. The report does not account for Drop Ship PO Receipts that were received in full, but partially invoiced.  In such cases, there should be an option to exclude these from the report as it's possible that order is effectively closed.

 

In short, this report is unreliable from an accounting perspective is in need major enhancements.  We'd like to have such a report this is period sensitive and segregates the impact of Purchase Accrual account for regular POs and Drop Ship POs.

 

Section 1 should include Regular PO Receipts that have not yet invoiced by the vendor.  These represent the net credits to the PO Accrual account for regular POs as of the end of the financial period.

Section 2 should include Drop Ship PO receipts that have been invoiced to the customer, but not yet billed by the vendor.  These transactions represent net credits to the PO Accrual account for Drop Shipped POs as of the end of the accounting period.

Section 3 should include Drop Ship PO receipts that have been invoiced by the vendor, but not yet been billed to the customer as of the end of the accounting period.  These records represent net debits to the PO Accrual account that are outstanding pending the invoice to the customer.

Section 4 should include Drop Ship PO receipts that have neither been invoiced to the customer nor billed by the vendor.  These transactions currently have no accounting impact to the PO Accrual account given the current business logic in Acumatica.  This section should be informational.  

 

Drop ship PO workflows are a particular pain point for a lot of customers when not managed effectively.  Obtaining the data and accounting impact of drop ship PO receipts is difficult to get to and understand, which makes reconciling these accounts very difficult.

  • Guest
  • Feb 21 2020
  • Attach files