Acumatica User Group Forums - Recent Posts

Nested SubReport Issue

cschwark — Tue, 05 May 2026 23:09:04 +0000

I have a custom Shift Changeover Checklist report (AM64000A.rpx) that runs perfectly when launched standalone, all fields populate, including a nested SubReport that lists materials. It uses parameters WONbr and OrderType, with filters on AMProdItem.ProdOrdID = @WONbr and AMProdItem.OrderType = @OrderType.

I'm trying to embed this report as a SubReport inside our Production Packet by Date (NW62000B.rpx), which already includes several other subreports (Production Ticket, Pre-Op Checklist, etc.) that work fine. I added a new Detail section in NW62000B with a SubReport control pointing at AM64000A.rpx, passing WONbr = = and OrderType = =.

When the packet runs, AM64000A's static layout prints (title, labels, panels), but every dynamic field is blank — Work Order number, Date (Today()), Location, Inventory Description, materials list, all empty. The same Detail section works correctly when I temporarily swap ReportName to IN619209.rpx (one of the existing working subreports), so the section wiring is fine. The issue is specific to AM64000A.rpx.

I have tried

Verified the SubReport Parameters collection (WONbr, OrderType) — values look correct
Unchecked Required and Visible on WONbr parameter in AM64000A
Hidden the nested materials SubReport inside AM64000A (no change)
Removed OrderType from the parent's parameter pass, falling back to AM64000A's default of "WO" (no change)
Deleted and re-added the SubReport control in the parent
Duplicated an existing working Detail section instead of creating a new one
Compared NW62000B's XML — detailSection8 is structurally identical to the working sections

I will attach the Large Packet (Production Packet By Date 62000B), Small Report (Shift Changeover Checklist 64000A) and the subreport if the Shift Changeover (shiftexchangechecklistmaterials)

Hoping to find some help

thank you!

3664 3661 3663

RE: Can't export GI's to excel that contain the FATrans DAC after upgrade to 2025 R1 in less than 25 min

tmac — Tue, 14 Apr 2026 19:31:03 +0000

I've had a similar issue with the out-of-the-box Fixed Asset Net Value report. It times out every time with one Branch when run for the full prior year. Acumatica development has it now.

RE: Limited or no support from Acumatica?

Ed Dolan — Tue, 24 Mar 2026 20:00:05 +0000

@jjbotes Good thoughts. We'll endeavor to find a solution.

RE: Limited or no support from Acumatica?

Johan Botes — Tue, 24 Mar 2026 19:31:18 +0000

The question is "when" in the business process does the negative inventory value change again to a positive?"

It makes no sense to always have a negative inventory value for reporting purposes - I suggest you change your business process to provide the correct "substance over form," financial, real-time, accurate numbers and control you desire.

By having negative stock values, you can effectively manipulate the Income Statement Profit and Tax liability. US GAAP does not allow that.

RE: Limited or no support from Acumatica?

Ed Dolan — Tue, 24 Mar 2026 19:20:09 +0000

@jjbotes Thank you for the feedback. I will discuss with our current VAR tomorrow. I realize that it is unusual for a company to have a constant positive inventory quantity but also a constant negative $ value for that inventory.

RE: Limited or no support from Acumatica?

Johan Botes — Tue, 24 Mar 2026 19:13:49 +0000

Acumatica can have positive units in stock but a negative inventory value, a situation that typically arises from timing discrepancies in inventory transactions, such as shipping an item before receiving it, or from specific cost adjustment processes. While "negative inventory" often implies a negative quantity, it can also manifest as a negative value (valuation) while the physical quantity remains positive

RE: Limited or no support from Acumatica?

Ed Dolan — Tue, 24 Mar 2026 19:07:20 +0000

@azeigler

I am concerned as well about the lack of support from Acumatica. Our VAR was clear that Acumatica's level of support was diminished and that they could not get an answer from Acumatica concerning adding positive quality inventory transactions with a negative(credit) dollar values.

I think a response from Acumatica in the vein of "Yes, Acumatica can do that, please see "XX" resources for the details" would be perfectly acceptable.

RE: Limited or no support from Acumatica?

Johan Botes — Tue, 24 Mar 2026 18:53:08 +0000

Hi Ed - the principle is embedded in standard functionality - all about how you configure the system. The key question is - What are the business processes and transaction flows, end-to-end?

One will need to have a bit of a discussion to understand and figure out how to account for this within your current business process, but in summary, with proper standard configuration, this is possible. During the discussion, it will become apparent if there are unforeseen quirks. Catering to said quirks will be a small no-code customization, if any.

RE: Limited or no support from Acumatica?

Ed Dolan — Tue, 24 Mar 2026 18:43:49 +0000

Johan,

Thanks for the rely and I hope you are well.

The particular issue/question in this case is we'll have positive inventory quantities, but the value ($) will have a credit balance.

We are being paid to take in material to be recycled. ( Debit: Cash/AR; Credit: Inventory)

RE: Limited or no support from Acumatica?

Albert Zeigler — Tue, 24 Mar 2026 18:43:36 +0000

@edolan I see, I think the context i was looking for was "questions like this". Although I have to say in my experience, Acumatica will promptly answer with the information provided by Mr. Johan in most cases. I have been directed to the Acumatica help, Knowledge Base, Known Issues, and occasionally the Community Forums.

I am glad there was an answer to your question so promptly!

I jumped in immediately because it would be quite discouraging if Acumatica was to start shutting off VARs from technical assistance.