Does anyone have experience accessing the following internal field while importing?
CurrentDocument.CuryUnbilledOrderTotal
I need access to it because I want to remove a cancelled order line, get the new unbilled $ amount, and then enter that number into the “applied to order”
I BELIEVE I can’t simply do math on what I am removing, as there’s an external tax calculation that needs to happen after removing the line and saving the order
Best answer by emery97
Hi
The official answer from Missy Main at Acumatica Support is that CurrentDocument.CuryUnbilledOrderTotal is NOT readable by the system during an import scenario. This is despite the fact that it is listed in the available “internal” fields.
The workaround suggested was to make the updates that affect the CurrentDocument.CuryUnbilledOrderTotal, enter 0 into the “applied to order”, then in a second pass, use a generic inquiry as a data provider source and include the value CurrentDocument.CuryUnbilledOrderTotal.
enter the new CurrentDocument.CuryUnbilledOrderTotal value into the “applied to order”
+19Hi
This field is automatically computed based on the Sales Order lines and the associated payment amounts, and therefore cannot be directly modified or imported.
Sorry to have caused confusion. I know that I cannot update it. I am trying to read/use it as data to input into another field
See below. This scenario works perfectly if I use a static value for example:
= ‘1.99’
So I know that my scenario is working properly otherwise.
I need to read the dollar value of CurrentDocument.CuryUnbilledOrderTotal … when I use it as a source as pictured below, but I get an error when running the import scenario if i set it this way
Hi
Hi
The official answer from Missy Main at Acumatica Support is that CurrentDocument.CuryUnbilledOrderTotal is NOT readable by the system during an import scenario. This is despite the fact that it is listed in the available “internal” fields.
The workaround suggested was to make the updates that affect the CurrentDocument.CuryUnbilledOrderTotal, enter 0 into the “applied to order”, then in a second pass, use a generic inquiry as a data provider source and include the value CurrentDocument.CuryUnbilledOrderTotal.
enter the new CurrentDocument.CuryUnbilledOrderTotal value into the “applied to order”
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
