Solved

I am trying to import my initial balances, I have imported a Trial Balance but when I release it, it shows me entirely different numbers in some accounts and will not let me edit anything.  The Journal Transaction that is created is out of balance and there’s nothing that I see that I can do to get my initial balances in the system.This is my import spreadsheet: 

Hi,I need to create customization project that will include all functionality from existing 2 for more convenient way for deploying projectDoes Acumatica support merge of 2 existing customization projects or adding changes from one project to another ? There is no difference in what way it could be done, I just need to gather all custom logic to one package. Acumatica version 2021R2thanks in advance 

Does Acumatica use the base UOM, Unit of measure for safety stock, reorder point, min order qty, max order qty and lot size? In the stock item screen, should any of these take into account he purchasing unit of measure?Even if set on the VENDOR tab of stock items? I believe EVERYTHING should be in the base unit of measure, I just want to confirm. 

Hi,Is there any way to use the same carrier plugin but for different accounts, which are not customer accounts.I have 10 warehouses and each one has its own UPS account number, how can I pass the correct account number to the plugin or is customization needed? 

Hello,Im trying to request applications from invoice to get payments. I tried to use such request https://*comanyname*.acumatica.com/entity/*EndPointVersion*/SalesInvoice/Invoice/*invoiceID*?$expand=ApplicationsCreditMemo,Detailsbut it returns "ApplicationsCreditMemo": []but I see my invoice has Applications. Please suggest how to request SalesInvoice applications?

Quick query, I have crested a very simple import scenario to bring in project transactions with the following fields which work when I enter these manually and release  Not sure why but when I prepare and then import I get an error “The Save Button is Disabled” Any ideas on what is wrong?  

Hi In this topic The sample custom screen and endpoint was provided by @jinin for my solution, which contains custom screen with user and password for input  in Acumatica interface I need to add one more field here for input : URL. How it should be done in proper way ?I opened custom screenTried to add new field called usrURLSuccessfully published without errors, after that, this field  appeared at endpoint selector The thing about which I am worried about is this tab  : Data Access CustomEndpoint.FilterIt appeared only after I added new filed, am I doing something wrong ? Will it cause some troubles ?

 I have a processing screen to get data from an Acumatica table and do gyrations and put data into a custom table.  I don’t need to select any records from a filter results.  I just want to use the filters on the screen to “do the work” on all records returned by the filter.I originally had a button under the End Date that would fire a custom action.  In order to make this a schedulable process, I THINK I needed to do it as a processing screen.So...I tried to re-do the screen.Since I am pulling data from the AuditHistory table, there is no “Select checkbox” to select on the processing screen.  Is my delegate not firing because there is no Select checkbox available in the filter results?Is there a way to use a PXFilterProcessing without a list of records with a Select checkbox?This is what my screen looks like after removing the Get Report Data button and making it a processall button on the top of the screen.This is the constructor that sets up the processing button.public QTCAuditRepo

I have a processing screen that pulls records based on a date range.          public PXFilteredProcessing<AuditHistory, QTCAuditHistoryReportFilter,             Where<AuditHistory.screenID.IsEqual<QTCAuditHistoryReportFilter.screenID.FromCurrent>.                And<AuditHistory.changeDate.IsBetween<QTCAuditHistoryReportFilter.startDate.FromCurrent, QTCAuditHistoryReportFilter.endDate.FromCurrent>>>> RecordsToProcess; The filter screen looks like this. The problem is that if there is a record in the AuditHistory table with a change date of2022-07-06 21:44:08.583 it won’t get selected.  I need my selector to just look for the DATE portion and ignore the time portion.  Is there something I can do in my selector to just use the Date portion?

Hi everyone. May I ask how I can have qty on hand in my inventory using my test account in acumatica?

Hi,In this topic The sample custom screen and endpoint was provided by @jinin for my solution, which contains custom screen with user and password for input  in Acumatica interface So, I have custom form with fieldsI need password value to be hidden same as at login tabWhat actions at customization screen must be done for that ?Acumatica version 2021R2thanks in advance 

Hi, I have a requirement where some validations are to occur once the inventory ID field is updated in the Requisitions screen. The logic is based on values taken from custom fields in a custom form and synced with user defined field in Summary area of requisition form and line item’s inventory ID. The logic is attached but the warning and error messages are not executed. Please let me know how to solve this issue.Custom Form Record Validated By Referencing these 2 Fields protected virtual void RQRequisitionLine_InventoryID_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e, PXFieldUpdated InvokeBaseHandler) { InvokeBaseHandler?.Invoke(cache, e); RQRequisitionLine rowLine = (RQRequisitionLine)e.Row; if (rowLine == null) return; // Get current Requisition RQRequisition row = Base.Document.Current; // Find my custom field from Extension var ext = PXCache<RQRequisition>.GetExtension<RQRequisiti

I guess this is a question more for Acumatica’s product team, but if anyone has encountered this scenario before, please enlighten me as well.Right now in Acumatica, Gift Card is a non-stock item. So when a gift card is purchased in Shopify, the Sales Order is synced to Acumatica with the non-stock item just like a normal Sales Order, so how do we treat the gift card liability?For example, when you sell a gift card to the customer, if you have not redeemed the gift card, the gift card amount is still a liability, until the customer redeems it, then it goes to Sales. But if we treat it as a non-stock item on the Sales Order, it goes straight into Gift Card sales.Is treating a giftcard sale straight away as a sale instead of a liability a correct way to handle it?

Hi All , I’m unable to insert the ScheduleID in Child table Column ,because it is integer type storing the integer Default  value(-2147483647).Not storing actual value. How to insert FSContractSchedule.scheduleIDfield into Child table (SSPFSScheduleInsp.scheduleID).can you plz help me in this..!this is my DAC#region ScheduleID         [PXDBInt(IsKey = true, MinValue = 1, MaxValue = 999999)]         [PXUIField(DisplayName = "Schedule ID")]         [PXDefault(typeof(FSContractSchedule.scheduleID.FromCurrent))]         public virtual int? ScheduleID { get; set; }         public abstract class scheduleID : PX.Data.BQL.BqlInt.Field<scheduleID> { }         #endregion.but it is storing like this in my table  Thanks…! 

Has anyone else seen this issue in an upgrade to 22 R1? STAT ledger changed ledger types from statistical (20 R2) to budget (22 R1). This causes an issue where postings can no longer be made on the JT screen due to the ledger change.I’ve opened a high priority case with Acumatica support on this but wanted to see if anyone else has experienced this. I checked our other clients who have moved to 22 R1, and they did not have statistical ledgers setup to verify if others have been affected by this.

Under Acumatica 2020R2 version , user just define one company which belongs to ‘Without Branches’ Type ,however while create a new sales order /direct invoice ,system will pop out the warning shows that [Branch ID cannot be empty ]at the moment user clicks on Save button to save the sales order .End up the order is saved but what may be the reason trigger such warning . Do refer attach for issues showing .Hope can get some advice for this .Appreciate.

Is this a bug? I can’t delete the password from system email accounts. I can add/remove the user name and all of the other fields, but I can’t switch out the password.As a result, I can’t send out emails due to authentication issues  

Hi all,One of our employees purchased a fixed asset using his personal account. Then he needs to claim expense and record this asset into our book. Here in the expense claim form we only see “expense account”, but we’d like to record this amount into “fixed asset” instead of an expense account. So how do we do that? Is it ok if we just key in an account for fixed asset here? Thanks! 

There is a default Physical Inventory reason code in Inventory Preferences. I have approximately 20 different Physical Inventory Types generated by Item Class. When you select “GENERATE PI”  in “Prepare Physical Count” it always pulls the default reason code from Inventory Preferences. I need a different reason code for each of the Item Class Inventory Types. Does anyone know if there is a way to set this up so you don’t have to change the default reason code every time before selecting “GENERATE PI” (in “Prepare Physical Count”) ?

We’re looking for the best way to prevent the Error: Another process has updated the 'SOOrder' record. Your changes will be lost when our integration writes back an external ID.  When a users saves the first SO line it creates a push notification and creates a record in our external app.  The ID generated in that App is then written back to the External Ref number on the SO which will be used to stay in sync with the external App.  However if a user continues to add lines they have to refresh the SO.The current thought is to create a customization that creates a table that will store the SO GUID or Order Type and Number and our external ID.  Then have the GI for the push notification relate to this new table.Any other ideas on how to prevent this issue?  

We run many projects (we make windows and doors and each houselot is a project) At the end of each project we are struggling to track what has been delivered to site and what has not. We currently make a PDF of all the items that were part of the project and store it as a file on the project with the name “Delivery Docket” but updating this is a pain. It would be ideal if there was some way to have “Output Items” per project, that when each item  is delivered, it is somehow “shipped” from the project so that we can easily see what is left to be delivered - is there an easy way to do this?if it were possible, then it would be easy to make a delivery manifest straight out of Acumatica/MYOBA

 I need to add two new status values of "Billed"  and “Expired” to the Service Contracts screen.1) Is the list of Service order status values exposed as a preference in Acumatica?2)Can new status values be added through a customization?3) Would the addition of new status values impact related Service order business rules? Thank you in advance.Ken Severud

Hi,In my customer’s instance, the debit account in the details tab of the AP bill is allowed to change when the AP bill is in the Open Status. What is the option to stop this ? Thank you,Dulanjana

Removing Stock Items

Hi all! I’ve created a set of labels using Report Designer and added to the site map. I now want to add a Print Label button to a generic inquiry. I setup the report up in the navigation parameters, added a column that reads ‘Print Label’ and pointed the navigation to the report/labels. This works when only needing to print one label. But if I click print label on one row and click print label on another row, for example, the second row displays the data from the first row. It doesnt seem to update based on the row I am clicked on. Is this a bug or is there a setting needed to get the print out to show the correct data per row? Thanks!