You have to have the SPS Commerce integration in order to do this unless you do something custom made. I recommend if you're currently using SPS Comm...

@susank17 In an import scenario -1 means create a new line. -2 is delete. Here's a good tutorial on import scenarios: /p>

@alconroy I tried to use that create bill option with my old company. The flow was the person doing the receipts (was a purchasing person doing it ma...

You can set up the credit card as a cash account since you don't have CC reconciliation. This is the guide I use. If you don't have an Acumatic...

@dboulle That was my first go to. I did the pivot table but didn't see a way to do the concatenation on the pivot table data.

@dboulle Product configurator. I think I got it. I had to make a GI for each "feature" I wanted then a GI to with all those individual GI's as data ...

@anne-r-trockman Correct me if I'm wrong. The PMBudget DAC table for each ProjectID has the [PMBudget.CuryActualAmount] and [PMBudget.CuryRevisedAmou...

@anne-r-trockman You can't do it this way that I know of. Figure 1 is how the results look in the GI. Figured 2 is how I want it to look. The resul...

@dboulle thanks Dominic. I know I can do the concat to get the combined datafield. My issue is how can I take the individual lines in the first phot...

I think I have it. I forgot to round the 2nd condition for LastCost by 4 digits so it was not matching. The math was going out to 6 or 7 digits so i...

I believe your Type needs to be where Invoice Number is and <Cancel> that. It has to select the document type first before we put in the number...

@nangel yes. For example let’s do 2 companies. Row 1 for Company 1: create all your text boxes. For Visible set to FALSE. For Visible Expr you wou...

@afriedman Figured it out. It was the import scenario. I was missing "Order Type". That needed to be specified with the order reference number as w...

@afriedman Changed it. Same thing. It's running 7 times and the GI has 7 records so it's definitely "processing" them. I wonder if something in the...

@nangel I think you would have to create two of the same fields and overlap them. Then use the Visible/VisibleExpr based on the criteria. Set one to...

For us we would prefer a per address fee. Initially we would verify all addresses in the system which is a large up front cost. After that our month...

For those that may have missed it the first time, like me, the row settings are per section. With a new section the rows start back over at 1. I was...

@jmck I did actually change the formula to be =(cDec([InventoryItem.SPA_Attributes])/100) * cdec([ARTran.Qty]) afterwards. It's not really "resolved"...

@jmck Thanks for the response. Here's the results. SPA Rate is the attribute and SPA Payment is the cDec. Interesting that cDec is turning it fr...

@jmck Actually I also have a 0.75 in that value on others. It simply represents a dollar amount. The attribute is an attribute I set up for inventor...

Created a subreport using ARAdjust2 table. Parameters I used was string of RefNbr. Filter is ARAdjust2.AdjdRefNbr = @RefNbr. On the detailSect...

@timrodman Nice! Didn't know that! I've used the filters to filter the report the way I want it then use trace to see the SQL which shows the value.

It's 2023, someone figured this out yet 🙂 I'm having this issue also.

@shawn-p-slavin Helped me out 3 years later! Worked perfectly and made the CFO happy.

@mcraig Great, we'll try that. Sounds reasonable and easier than a customization.

Thank you sir. Good example. I keep forgetting about Pivot Tables as well. We're simple - single ledger, single branch so worked out perfect.

Any resolution to this? I'm looking for this same solution.

@retha Possibly. That makes sense.

'ello! Just starting an Acumatica implementation so looking forward to it.