Solved

A/P Transaction Report Needed for Non-Stock Items

  • 10 August 2023
  • 2 replies
  • 49 views

We have a non-stock item we use for A/P that tracks the labor used for one of our mechanics (it’s a vendor).  We would like a report that can give us the number of hours and the rate for that item.

 

We have been able to run the Purchase Order report for the item, but we do not use a PO every time we have them work on our equipment.

 

Thanks in advance for your help!

 

~Audrey

icon

Best answer by ricoybanez 11 August 2023, 03:46

View original

2 replies

Badge +18

Hi,

I think Finance → Transactions for Account report could work with a small modification to add the Units, Unit of Measure, and Unit cost to the report.

  1. Enter bill with Labor Item
    AP Bill
    1. Print Transactions for Account for the Account(s) to which the non-stock labor was posted
    2. Use Report Designer to add Units, Unit of Measure, and Unit cost to the report. - There is plenty of space.

Depending on how the non-stock item is configured, different GL accounts could be used for PO -related AP Bills versus AP Bills with no PO (may need to include multiple accounts in your report, to see total hours).

Otherwise, a generic inquiry report for APTran table will allow you to find and report your transactions.

Laura

 

Userlevel 3
Badge

@adupre , I recommend you can make a GENERIC Inquiry for your specific requirement, there are only 2 DAC’s you can use.

 

  1. APInvoice - (Date, Bill Type, Vendor)
  2. APTran - (Non-Stock ID, Description, QTY, UOM, Unit Cost, Ext. Cost)

 

Hope this will help your concern.

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 — 2024  Acumatica, Inc. All rights reserved