By using this website, you agree to our Terms of Use (click here)

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.