Solved

Anybody have any ideas on how this field (CTaxZoneID) can be populated based on certain conditions on the customer or customer location screen?I’ve tried managing this through the workflow engine, but the necessary fields from the DefAddress or DefLocationAddress tables are not available when trying to customize AR303000 or AR303020.Can field updates be based off a GI like in Business Events? 

I’m trying to import some data into bills and adjustments and its giving me the error “SuppliedbyVendorID cannot be empty” I’ve never had this before - can someone let me know what I need to look at to mitigate the issue? 

Hi All, I want to change the default filter of this screen (quick filters)  to “Pending Approval”. Currently the default is “On Hold”. How can I do this?  

Hi, I want to reorder the mobile app menu( put some existing items to the top of the main menu etc.) How do I do that?

I am working in the sandbox right now and trying to add “last cost” “avg. cost” and “qty on hand” to the generic inquiry.. as soon as i add “INItemCost” it returns duplicate lines on my inquiry results. Here are the relationsi i currently have (before i add INItemCost) Anyone have any ideas? 

We see SO line  numbering skips every other number (i.e. 1,3,5,7, etc) which then translates to the invoice in the same manner.  We need to have continuous numbering. 

Hi, To the Shipment PL, SO3020PL, I added the table SOOrderShipment, Joined from SOShipment via the Shipmemt.NoteID to the SOOrderShipment.ShipmentNoteIDI am trying to get the Sales Order Number. This is working great for all but 1 user. That user cannot see the column. The user can access Sales Orders & Shipments. They have the Administrator Role. I tried doing a reset to default Configuration I log in as that user & can customize the GI & can see the table/ join & field on the Results Grid. But when I view the GI , as them, the field does not display. It is also not listed in the Column Configurator.There are no errors in the trace. TIA, Bill

Hello,Does Acumatica allow for different warehouses to have different replenishment settings?For example if I have a MAIN warehouse and stores in City A and City B can I set the min/max replenishment to different values for each city?Thanks!   

How do I add a hyphen in Report Designer between 2 fields. Trying to end up with this;  Address - Number. +IIf([ShippingAddress.AddressLine1]<>null,[ShippingAddress.AddressLine1]+ - +[POOrder.OrderNbr]+'{br}','')

Form “MRP Display”When is the document type Shipment used by the system and when the type Sales Order ?I created two Sales Orders and run MRP. One has the type Shipment, the other one Sales order.

I understand that it’s suggested to not changing the decimal precision of a currency once transaction created and released. But, I just like to know what the problem exactly is. There are indeed transactions have been made on the currency (this is not base currency setup in the system) but most of them are having two decimal places on the amount, only one AR invoice has 3 dps. If this invoice is reversed and the decimal precision is changed from 4 to 2. What might be the impact? 

Hi all. We have a lot of stuck orders in the Bigcommerce that are not in Acumatica. Any advice on how I can know the root cause of this?  Thank you.

Hi,I wanted to get sum of all values in CASplit.CuryAmt field to display the Total Amount.these are the two tables that I wanted to get the line detail values.CASplit CAAdjAnd this is the new join I put to get the line detail values.  And this is the condition to get the Total Amount=Sum ( [CASplit.CuryTranAmt] )  But when I run the report, it duplicates all the value details in CASplit.CuryTranAmt field and added to the Total Amount.Does anyone know what causes this issue and how to fix it? Thank you.

Hi Team,We are working with 20.221.0021 build and we have a requirement to use a default Ship Via on importing order from BigCommerce to Acumatica instead of using the Shipping Option Mapping grid. Can you please confirm if is it possible through Entities Mapping screen or the best possible way to do it.And if there is a way we can stop populating the Shipping Option Mapping grid. Thank you!

Hi, We have a customer who owns time & expense management and payroll. They would like to explore integrating the time entry in time and expense mgt with payroll. My only issue is that i can not seem to find a way for a released timecard to make it into the payroll system.Does time entry integrate with payroll or is the integration and export/import? Thanks 

Does anyone know if the customer portal has (or best way to accomplish if not) a searchable knowledge-base? Our customer would like to enable the portal for their customers and have the customers be able to search and retrieve solutions to common questions. Maybe a wiki accomplishes this?

Hi everyone,I have a question with Purchase Order that the order of the rows is reversed, I want the lines to be printed in the order they were entered. I use the print version of the system and have not edited anything.Pls advice me if you have any idea.Thanks in advanced.

Hi,There is case which describes cipher suites usage in Acumatica Saas.I need to clarify ciphers suites usage for Acumatica.The question is : if I am using such expression in code :ServicePointManager.SecurityProtocol = SecurityProtocolType.Tls12;Does it mean that I my application which integrates with Acumatica Saas uses  “TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384” and“TLS_DHE_RSA_WITH_AES_256_GCM_SHA384” ciphers, because these two cipher suites are supported under TLS1.2 ?If pointing SecurityProtocolType does not mean cipher usage, how it must be implemented ?Best regards,Thanks in advance 

Hi, I’m tryiung to do a GET request from:acumatica/entity/Default/18.200.001/invoice?$filter=CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and Status eq 'Open' That returns the open invoices starting one date.Now I want to add a Balance component but I cannot make it works, I tried: CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance gt 0ALSOCreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance=0 With no success, I’m pretty sure it is a simple thing, but I cannot find it How can I do it? Thanks,Ignacio

Hi team,Exchange integration:We are using a service email address for customers to send in repair requests.Is it possible to auto-create a case for this repair request?How would we solve this? Would we use events?Thanks!

Hi all,I know this is a very basic question, but sometimes confuses our users. In the Sync History, we have the column ERP ID, and it can be easily understood to refer to the Stock Item SKU. But the details displayed are Item Descriptions, and you are not able to search items using SKU/ERP ID. Any reason why it was called ERP ID, though it was intended for Description or Product Names? :)Thank you  

I have recently noticed that two records dealing with two differents PaymentMethodID in our PaymentMethod table have the save NoteID value.I'm new in the Acumatica's world but it seems to me that a given NoteID value should be unique in its tenant.I have decided to change the NoteID value of one of my conflicting records but to do so, I have to check before for potential uses of this value in other tables. Am I exhaustive if I search for the value to be changed in all tables having a NoteID column or can NoteID values be also used in columns having an other name ?

On the form “MRP-Display” it is possible to create any order type regardless of the settings of the item.I have a planned purchase order because of the settings which is good. But it is possible to create a Production order based on this planned purchase order without any warning / error / infolog! Is there a set up to activate a plausibility check?  

Is there a way for us to create a generic inquiry, for this two table. Currently my project on the company is to set an approval map on the Sales Quotes based on the total amounts, and when printing the quote, the Approver name and their E Signature will be shown on the report. I want to use the subreport to get the approver name on the main report on the sales quotes. But my problem is how can i get the E Signature to be shown on the report.   

hi all, i would appreciate if anyone could assist or suggest any fixes. I am trying to check a custom bool field on a sales order split line using a business event triggered by an action off a GI.  the GI lists all allocated sales order split lines for a stock item marked as “requiring calibration” on the stock itemi check the line, actions - “Calibrate Line” which triggers a business event with an import scenario as a subscriber. the idea is to check the bow “Calibration Certificate Created” so that they don’t attempt to calibrate lines already calibrated. The event runs and fails with the entry below in the history.If i check the option in the history and “execute” the import runs successfully. If i run the import scenario as a stand alone scenario, it also is successful which points me down a route of an issue with it running as a business event from the action rather than a problem with the import scenario.  version is 2021R1 21.105.0023 any suggestions would be appreciated, import