Question

PO Accrual Report Includes Drop-shipments

  • 18 November 2020
  • 4 replies
  • 124 views

Userlevel 1

The PO Accrual Reports needs to include all activity that affect the PO Accrual account.  The existing PO Accrual Reports only take into account the traditional Receipt of Goods into Inventory and Receipt of those Vendor Bills.  There is no way to audit this account if a customer uses Sales Order Drop-shipments.

In the Drop-shipment process, a Receipt of Goods and Bill is entered when the vendor notifies the Acumatica user that their Drop-ship PO has been fulfilled.  When this type of Receipt is entered and released, a G/L Transaction creates a Debit to the PO Accrual and a Credit to Accounts Payable.

Once the Sales Order Line that is flagged as Drop-shipped is invoiced and released, the system will create a G/L Transaction (via an Inventory Issue) that will Credit the PO Accrual Account and Debit a Cost of Sales Account.

If there is timing differences between the Vendor Bill and the Customer invoice, this Debit Balance will sit in the PO Accrual and the existing PO Accrual Reports do not take this into account.  The existing PO Accrual report do not match the PO Accrual balances and are useless in auditing this account.

Please provide a PO Accrual report that is accurate and takes into account the Drop-ship Feature.


4 replies

Userlevel 4
Badge +4

Hi @jeffrose90 

Let us know the version and build of Acumatica your test instance is on. We will check further. 

Regards,

Userlevel 1

20.107.0026 is the specific version; I haven’t looked at other versions

Badge

@jeffrose90 , this is a product limitation. The Purchase Accrual Details report ‘considers’ accrual account to be debited when a purchase receipt was released. In the case of drop shipments, the release or receipt does not create GL entries and, yes, updates only accrual report, which leads to this temporary inconsistency.

Depending on the process/requiments, I see two possible solutions:

  1. Use the Order Based billing for purchase order. This will allow to create AP Bills before PO Receipts and release PO receipts only immediately before Customer invoice. This will allow avoiding this discrepancy
  2. Set up a separate accrual account for drop shipments (possible by means of a customization or a separate warehouse for drop shipment). This will allow to reconcile a ‘real purchase’ accrual account with Purchase Accrual reports (where it should be reconcilable) and reconcile ‘billed but not invoiced’ drop ship accuals via different GI/report which can be built by the customer

A few other suggestions for dealing with the miss matched reporting that doesn’t suggest massive undertaking within Acumatica:

 

The PO Accrual Details report is much more helpful when looking for discrepancies.

Have the g/l, PO Accrual Details report and PO Accrual Summary report run every day for comparison.  Ideally, scheduled to automatically run after hours, but I am manually running them before I leave every night while we get the automation ironed out.  If you are starting from a reconciled balance, the daily viewing makes it completely possible to research all discrepancies.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2020  Acumatica, Inc. All rights reserved