Skip to main content
Question

Do AR and AP Tables have something similar to the InvtMult field in Inventory transaction tables?

  • July 30, 2025
  • 0 replies
  • 32 views

Forum|alt.badge.img+1

I’m sure there’s good reason, but every ERP including Acumatica that I’ve worked with loves to record all transactions as positive values.  Inventory tables line INTran at least have the InvtMult field that you can multiply your quantities and net costs by to tie out to the actual ins and outs of inventory.

I haven’t seen a similar field in ARTran or APTran, so instead we’re doing a lot of “iif” statements in GIs based on transaction types.  It’s ugly, especially when you have to aggregate.

We’re on 23R1 right now but working on moving to 25R1.  Is there a similar field in either version to the InvtMult field in Inventory?