Did you try CInt([Amount]) * -1 ?

@timrodman Yes we've noticed the new report and are using it to check open Purchases. It's a very handy report. Replaces the Purchase Receipt Accrual ...

It's the same in 2018.1 - actually I think it's always been that way.

@matt-tries-to-do-things I have reproduced your issue on another Vendor which had an open balance. I cannot delete the Customer record Extended from t...

@matt-tries-to-do-things It worked fine for me when i deleted the customer created from "Extend to Customer" action. Something else must be going on i...

Have a look at Restriction Groups by Item or perhaps Item Class. However I find Restriction Groups kinda unpredictable. Also be careful creating them,...

Extend to Vendor takes the current vendor details and creates a NEW customer using those details. If you don't need the customer, just delete it. I al...

@gustavo-carrasquillo Sorry no idea on this one as I've never had the need to do this.

Hi Carl, It was logged last week and has been escalated to MYOB. The scary thing is we have 2 weeks to go before we are upgraded and no news as to whe...

You need to add either the PO or PO Receipt to the bill via the buttons on the toolbar.

I think your best option is contacting Acumatica for support.

Hi Gustavo, it's good that you solved your own problem, but seeing as you are dealing with what I am sure is a custom report, IMHO, the better way to ...

That's weird. It's an editable field for us.

It seems to be a MYOB related issue - not sure what they did wrong but somehow they managed to break these variables and also @Today. Our Locale sett...

Damn got so excited about this new feature. Is it true that you can't modify the report parameters used for the preview? Publishing endless new versio...

We have a mix of PO receipts and non-PO receipts. We basically need to recreate the old unbilled amount field from PO Receipts.

note: non-quoted leading or trailing spaces are ignored within any expression. and the falsepart is mandatory. Full ARM function reference available h...

The stupid thing is they called this change "Purchase Receipt Improvements" whereas for some it is a major step backwards. What it means for us is tha...

I suspect because you're missing Order Type. Take a look at the Purchase Order form report and compare it to yours.

GL Inquiries should be using GLHistoryByPeriod joined (twice) with GLHistory because of the way Acumatica optimises posting to the ledger. Discussed b...

Glad to have helped. I've never used horizontal spacing tool, but that coupled with Make Same Size tool speeds it up a lot (never used that before eit...

Definitely broken - Looking at pageHeaderSection1, every third field is getting concatenated with the second field. This behavior repeats in all other...

Setup application passwords on the accounts configured in Acumatica and use those passwords instead. App passwords aren't subject to MFA.

Scroll down to @Unit.... variables

Personally i think it's ok the way it is. For example, we had a big upgrade earlier this year implemented by our partner. During that upgrade, new scr...

@alisann-crough I did say that you needed to join IN.InventoryItem twice in my original post. 😉 Not quite sure what error you were getting, but your ...

I recommend you refer to this guide: In particular, Example 2.5.3 (Updating Detail Lines by Custom Key) on page 95. It is important that you have th...

In relations tab you need to relate via ID fields - in the results formula, if you want the CD values then use those in the IIf formula result. Check...

You need to join ARTran and INKitSpecStkDet to IN.InventoryItem (note: the table needs to be added twice to the GI, once for each join) and then use t...

@fred-zhou Definitely not, there are a few here.

Still seems totally weird that MYOB have provided their own integrated solution yet Acumatica insist on bundling it with the installer. For us MYOB Ad...

As that is a child table of warehouse, if you "change" a warehouse, essentially you are deleting a row and adding a new row. Are you actually doing t...

While I've never done it, in theory it might be possible but you might have trouble assigning things like Roles and Licenses Types via Import Scenario...

Change Warehouse Location ID of what?

Thanks for Sharing that @ellie.

Welcome @leticia-combrinck - I highly recommend Acumatica Open Uni if you want to learn Acumatica.

@ellie Fields tab are those fields on the source document that should be monitored for changes. Parameters are those passed to the report. Don't you m...

@siva-katakam I don't understand your question. I already posted the solution for reversing journals.

Build a GI to get the Customer IDs you want to change to a spreadsheet. Build an Import Scenario to apply whatever changes you need (not quite sure wh...

@timrodman No its from labeljoy website - something Carl pasted on that post.

In particular follow the link posted by @carl-brooks Hey @timrodman, any idea why the above page is asking for a logon?

Try holding down Ctrl + Alt and clicking on the field of interest. It will give you the DAC reference (Data Class + Data Field). Click on the amount, ...

You can't perform calculations based off grouped aggregated values in GI.

That should work - don't understand why it doesn't.

Not sure why it wouldn't work - make sure that there is no <Line Number> enabled on Document Details (I probably should have deleted that from t...

Why doesn't it work? That field above is the unpaid balance for the Sales Order as shown on the page.