Solved

I have a need to delete the Global cross-reference for many Stock Items in our system in order to get our Printed Forms to use the correct customer or vendor cross-reference (all cross-references appear in the Alternate ID field on the Sales Order and I can’t figure out how to get Report Designer to determine which is which without bringing tons of DACs).  I need to delete those Global one’s at the bottom.  Super simple to do manually.  I have an Excel sheet data provider with all the Stock ID’s, Aternate ID, and Alternate Type.  I’ve tried Keys, Custom Keys with @@ format, Line Number tricks.  The documentation says after finding the record with a key (tried both <Key: AlternateID> and <Key:AlternateType>), the summary Target Object must be selected to use the Action: Delete. Unfortunately with most of the scenarios I’ve tried there isn’t a useful error message either.  Anyone have any tips on how to accomplish this.  I think a method that works would be useful in the futu

Hi Everyone!Does anyone know of a way to assign sales reps in Acumatica based on item class and customer/business account at the time of sales order entry?Example: IF item class = Consignment, THEN Sales Rep = Business Account OwnerAny help would be greatly appreciated :)Thank you! 

I’m looking at Endpoint version 20.200.001 and specifically the Customer endpoint. The settings indicated that this endpoint is connected to screen AR303000. Under Customer is a field defined as:BillingContactOverride, Financial → Financial Settings, OverrideBillContactBut that field isn’t on that tab. OverrideBillContact is Billing → Bill-to Address → Override, OverrideClicking Validate Entity returns a message that says it validated.Am I missing something on understanding the field mapping or is the mapping incorrect?

We are rolling our the contract management module and noticed there really aren’t any reports or inquiries out there. Has anyone developed reports/inquiries for contracts they’d be willing to share?Thanks!

HiI have created a dashboard in finance , however i dont know how to put it as main page , which mean when i log in , it will show the dashboard that i created as currently is show the “controller” that created by aucumatica as below 

Is it safe to run “Validate Inventory” on a weekly basis?  

Is there a way to generate requisitions from Prepare Replenishments screen?There is need to utilise Bidding process on requisition for items that are below reorder level, currently it goes straight to Purchase Order.

How can pass list of values to a single parameter in the report designer   

I created a new field and I want to initialize by default trueThanks for your help.

How can we access the Acumatica “Chat” support as part of the Acumatica’s Direct Customer Support Services (Acumatica Standard Support)?  

Hi!Let’s picture a scenario where a Retail Company sells shoes through 45 stores and They have the next environment in each store:POS software with an interface to Dynamics GP POS software update GP in real time, it means, when a sell is being made in a store, the POS use the GL accounts defined on the item to post in GP the invoice process (inventory, ar invoice accounts) and in the same transaction, the payment is registered too (Post in GP the Payment accounts such as sales account, bank account, etc).With that said, let’s say that in december they process 200k transactions. The 200k transactions are related to the POS process described above.My question is, 200k transactions are considered ERP transactions instead or Commercial Transactions?Thanks!

I am trying to set Dashboards for various users in our company.  Is there a good video training or KB article that would be helpful? 

Hello,       The “add stock item” function is great on SO entry screen. Especially the “Sold since” feature.However, sometimes, the sold lines are wrong sell, or it is a alternative sell.likewe should sold item A to customer, while we wrong put item B on previous invoice.Customer normally would like to order item C, but item C is out of stock at that time, so we give him item D instead.       our need is to filter out the item B(wrong sell/human mistake) and Item D (alternative item) after selecting “sold since”      Can somebody give me some bright ideas?

Hello,I need a configure screen that contains also password and store them to DB.I set the TextMode to “Password” to hide it.    <px:PXTextEdit ID="edPassword" runat="server" DataField="Password" TextMode="Password" /> But the web browser (Chrome and Firefox) fills-in the login password into this field.Is there a possibility to prevent that in code? Thanks,Michael

Hello Guys  Can you help me with finding a way to link “Account” and “Batch”; I tried using GLTran but I have the same line repeated multiple times select * from account INNER join GLTran on Account.AccountID=GLTran.AccountIDINNER join Batch on GLTran.BatchNbr=batch.BatchNbrorder by AccountCD I’m missing something ? 

We’d like to use the results form different GIs for one report, is this possible? How?

We processed two check against two AP bills.  The checks show on the check register but not on the payment register.  The two AP bills remain Open as the status.  How do we connect the bill to the check after the check printed without having to void and issue a new check? 

Is there a way to set the accrual account based on PO type? i.e. We want the accrual account to be 2210 on a normal PO, but we want the accrual account to be 1250 on a drop ship PO.The accrual account is defined on the item level - so it seems that we would need a Drop Ship SKU as well as a normal SKU to do this out of the box -  which doesn't take the manual entry element out of the equation due to needing to pick the correct SKU. 

Hellowhen I try to recover the field [InventoryItem. Body] and change the option convert HTML into text and the option can splits to true, it doesn't move to the second page so it always removes some lines and I want to know if report designer has a limit on how many lines can print from InventoryItem. Body THANK YOU

For example, warn the users that there are open purchase orders when you change the status to No Purchases.  Procedurely, users should use the Inventory Summary or Allocation Details before changing the status but a warning would be a good idea.

Hello,Could you please help me, how to display only 2 decimals for below highlighted feilds in default notification templates. 

I want to make available a custom button field and a custom text field to be only available when  a given paymentmethod is selected. I want  the button “Process FEFT” and Text field Mobileno to be available only when TEMP paymentmethod is selected. protected void ARPayment_RowSelected(PXCache cache, PXRowSelectedEventArgs e) { var row = (ARPayment)e.Row; if (Base.Document.Current.PaymentMethodID=="TEMP") { } }Thanks

We are using the Shipengine integration for shipping in Acumatica. For label printers the website teaches you to create a batch file on a windows using the below code. Does anyone know the translation of this code if we were using a MAC instead of a windows?   

Hello Everyone,I have a custom button action with a long run to execute some business logic. Now, have a requirement where have to perform some updates based on the latest modifications performed by this long run.Is there a way we can set the long run operation status to completed, so that the record gets updated in DB and I can fetch those modified records and perform my updates in the same button click.Thanks in advance!

Hi, I am new to acumatica and I am trying to do some customizationI have created a new payment method and would want to have create a function related to it. eg, on selecting the said payment method, a TextEdit to appear for input of a variable, a given action button to be enabled. On the Button Click, I want to query a table and return true or false. If true the save action to go through. namespace PX.Objects.AR{  public class ARPaymentEntry_Extension : PXGraphExtension<ARPaymentEntry>  {    #region Event Handlers    public PXAction<PX.Objects.AR.ARPayment> ProcessTemp;      [PXButton(CommitChanges = true)]    [PXUIField(DisplayName = "Process Temp")]    protected void processTemp()    {    }    #endregion  }} Someone kindly help.Dan