Solved

hello, i need to make integration between two databases to send the items and the quantities from database to another database automatically which tables should i make the integration with ?thanks in advance

I have done the following steps: Created the SQL list Put the list in “Database Scripts” of the customization project. Create the DAC for the database table and move it to the extension library that I'm working on. I'm storing the values as follows: DACName store = new DACName             {                 column1 = value1,                 column2 = value2,                 column3 = value3             };             PxGraphName.Caches[typeof(DACName)].Insert(store);             PxGraphName.Persist();             PxGraphName.Caches[typeof(DACName)].Clear(); The issue is that, whenever I run the program, I look into the table and the value isn’t stored. I know information might be a bit vague but it’s to not overcomplicate things. I also haven't added anything the DAC of the table that stores the values, so if i need to add something let me know.

I have a situation where a customer has raised a sales order for one item with a quantity of 10.    This line has been allocated a despatch has been created but not yet confirmed.   The customer then has a situation where one of the items cannot be despatched and only require a quantity of 9 to be despatched.   It does allow to amend the shiipped quantity but then reports and error advising the quantity shipped is greater than the quantity allocated.    The only way round this would be to cancel the despatch amend the allocated quantity on the sales order and then recreate the despatch.   Can anyone advise on settings/workarounds to avoid this long winded way of allowing the despatch quantity to be amended?   

I’m testing adding a file using Postman and I’m getting the error:{    "message": "The request is invalid.",    "modelState": {        "": [            "Unable to translate bytes [E2] at index 10 from specified code page to Unicode."        ]    }} Here are the headers:In the body I’ve tried several different pdf files but I still get the same result.  I’m not sure what I need to change to get this to work.

This may be simplicity, but I honestly cannot figure this out. I created and released the below Production Order:And I’m seeing it on the Schedule Board, but it’s not taking up any capacity in the Production Schedule Board. What am I doing wrong? I have the BOM, routing, and calendar all set up 

If I have a wave pick worksheet with a set of shipments and a few of them are already done. How do I cancel the remainder of the worksheet?Below is a shot of the worksheet I’m trying to remove/cancel. Thank you everyone!

I’m working through the setup of System Accounts in anticipation of leveraging the Incoming Mail Processing feature. I’ve encountered a few different issues over the course of setting up ~20 System Email Accounts that are connecting to our MS365/Azure tenant. For the most part, things are working as expected BUT there are a handful of accounts that continue to be problematic… During the automated processing of the emails, some accounts encounter the error “The mail receive has failed. Exception has been thrown by the target of an invocation.” during the automated processing of the emails. As suggested by other threads within this community, I’ve opted to recreate the System Email Accounts and it’s associated External Application from scratch. This did seem to work, initially, but roughly an hour later the problem resurfaced. It’s been suggested that the error could be due, in part, to the quantity of emails being processed, specifically those stored within the defined root folder of th

Hi Acumatica, Upon clicking of Prepare Invoice in SO with TR Type. The Invoice Status is already balance though the on hold check box in AR Preferences is enable. Is there a way to make it on hold? So that our approval for invoice might effect. Thanks !

Am creating a generic inquiry that list all the purchases accruals. Can someone kindly advise on how to achieve this? Have tried it several times using the information from Build Schema for report designer but still I can’t achieve this  

sorry

I have a customization that adds a field: UsrASGMarkup -- which calculates a user’s suggested price based on markup logic. This field is added to FSAppointment.This customization creates the field in the database.But if I unpublish that customization -- and try to go into an appointment, I get this error:  Even though the only customization that requires that field is not published. Why in the world am I getting this error? And is there anyway to avoid it ?  

When using the run allocations screen, GL batches for allocations are generated on-hold or balanced.Is there any way of changing the status to auto-release? There are multiple daily allocations, and manually releasing them every day doesn’t feel like a good use of time.I have considered an automation schedule for Release Transactions, but the problem is we can’t filter directly by Type: Allocation, so other GL batches which we don’t want to release also end up in the same schedule.

Has anyone seen this error before for inter-branch mapping. We’ve tried saving multiple times for the past few days but no luck: 

I need to add multiple emails to some customer records. These addresses will be accessed via the API. They will be used to alert the users (CSR team) of events that occur outside of Acumatica.Is there a built-in way to add internal (our company) email addresses? Or, do I need to add a custom field?

Hi all, I tried to use SOLine.aMProdOrdID in my customization project as below.But it shows me following error.The Type amProdOrdID does not exist in the type ‘SOLine’ But when I see SOLine table in Database, amProdOrdID column is there.How can I fix this issue? Thanks.

Hi AllNot sure if anyone know how to define the column C below in RED BOX detailsCurrently , i would like to create a Balance sheet Report comparative month to monthExample: Balance Sheet Report Comparative  Sept 2021 and Aug 2021I manage to set for Sept 2021 in column B  , however i am not sure how to set for Aug 2021 in column C , Refer to below in RED BOX highlightedI tried the formula in  = Format( '{0: MMMM d, yyyy}',Report.GetPeriodEndDate(@StartPeriod,-1)) is not workable.May i know who can help in this formula?  

Hi Experts,I am working on a couple of things to include all Business Accounts in the selection on Projects (PM301000) screen. As of now only customers are displayed under selector of Business Accounts.I have tried the standard code as below.[PXDBInt][PXDimensionSelector("BIZACCT", typeof(BAccount.bAccountID), substituteKey: typeof(BAccount.acctCD), DescriptionField = typeof(BAccount.acctName))][PXUIField(DisplayName = "Business Account", Visibility = PXUIVisibility.SelectorVisible)]I have tried below workaround to achieve the same but unable to get the desired outcome on the Projects screen. #region Usrbaccount [PXDBInt] [PXUIField(DisplayName = "Business Account")] [PXSelector(typeof(Search<BAccount.acctCD, Where<BAccount.type, Equal<ContractExt.HardCodeValues.VE>, Or<BAccount.type, Equal<ContractExt.HardCodeValues.CP>, Or<BAccount.type, Equal<ContractExt.HardCodeValues.CU>, Or<BAccount.type, Equal<ContractExt.HardC

Hi All,I am trying to retrieve Account class value on a col set based on row set account class value.My row set is set to expand based on (code-description) but one of my customers wants this to account class next to the account code.I have tried using @startAccountgroup and @endaccountgroup. This has not worked.If any suggestions please let me know.  

Hi,after some row in the calendar, the data isnt readable.Is it a known issue? How to resolve that? after scrolling to the top 

We are a construction edition user.  We would like to be able to display the notes saved to the project screen (CST.PM.30.10.00) when entering a PO for that project on screen (CST.PO.30.10.00). Some of our projects require only certain types of products and we would like that to alert our purchasing staff when they are creating a purchase order.

Hi,There is a way to filter things who appear in T&M Proforma.If by example we dont want to bill item ABC to the customer (and don’t want to appear on the invoice)?Could I manage this via Project/Cost budget? Billing rule? Configuration?Now I delete ABC rows manually.Thanks

I work for a large construction company, currently the thought process is to set- up all of our Revenue Budgets at the Task level only and to set-up our Cost Budgets at the Task and Cost Code level. The reason for this is to provide a high level view at the Revenue we are receiving and giving us the ability to be more specific and detailed within the Cost Budget, by adding that additional layer of identification with the Cost Code.By setting up each budget at a seperate level of detail, completely makes the WIP report unusable. The system will not recognize funds allocated to cost codes within the Cost Budget because the Revenue budget auto-assigns the default (0000)  cost code to anything labeled with just a Task. Please see the example below.Is this the way we should be thinking about both Budgets?Is their anyway to reconcile this without having both budgets at the Task and Cost Code level?Is anyone else out there running Revenue budgets and Cost Budgets at different levels of detail

I’m trying to make Dashboards to show poeple how to do their jobs. This often comes in list formats. Like the following, where every word or letter is a widget.Create        Release  A                    A  B                    B  C                   C                        D The current Dashboard formats don’t allow this, becuase you can’t have a widget (D) to the right of an empty space. I would like to have a “blank” or “spacer” widget we can add to make whitespace for user readability on dashboards. I think this would greatly enhance what is often the first screen type any user encounters when logging in.

Hi Everyone We have created a Business event to send an email on order confirmation with the SO details.Issue :The emails is triggered properly with Billingg and shipping address in the Sales order (If the Ship-To Contact and Ship-To Address is not overridden, In the email details is displaying as expected When we are doing the below Override Options I have override Ship-To Contact and Ship-To Address and updated the account name and address, in the email “Account name” and “Billing address” is not displaying I have override Ship-To Contact and updated the account name, in the email “Account name” is not displaying I have override Ship-To Address and updated the address, in the email “Account name” and “Billing address” is not displaying email displaying as below even we have dataAttaching the Business event, Template and GI.No customization Impact.