Solved

Hi Team, I have some query on how to set the base currency in a tenant.Case 1 - We have a company in the United states, India, Europe. All have their own company currency i.e., Base currency - USD,INR,EUR. If I set the Company Currency for United states, the base currency is taken as USD. If I tried to create another company for India the same USD base currency field was freezed and automatically taking USD. As per the Document, base currency once set in the system will be applicable for all the companies in a tenant. In order to have multi base currency, then we should able the multi base currency option from Enable/Disable features. When we trying to enable it, system ask us to disable some features like Contract management, Payroll, Time management etc. But we do have payroll and time management in our business.Case 2 - In the above three companies, how we can perform the consolidation. My reporting company is in US, we are in need to provide the consolidated report in USD quarterly

Hi, I am new to Acumatica, hence all my issues I post here. We have a lease that expired. I cannot seem to reactivate it or renew the lease. Any tips? What am I missing? Thank you. 

Hello,    I found Acumatica is having add on called “AcuPOS powered by IIG”, which looks like an entrie whole solution for POS and Acumatica integration.   But correct me if I am wrong, “AcuPOS” looks like also requiring the customers switch/change the POS system they are using right now, right?    If the customers prefer to stay with the POS they are now using, Is there any existed way to go?

I have added this tab in shipment screen and I am to able to get the values stored in DB. These are read-only fields.public class SOShipmentExt : PXCacheExtension<PX.Objects.SO.SOShipment> { #region usrMyField [PXDBString()] [PXUIField(DisplayName = "My Field", Required = false, Enabled = false)] public string UsrMyField { get; set; } public abstract class usrMyField : PX.Data.BQL.BqlString.Field<usrMyField > { } #endregion } 

I have added a custom field it is perfectly able to save the data in my table but when I open that record to edit field is always empty. What am I missing here ? namespace PX.Objects.CR{ public class CROpportunityExt : PXCacheExtension<PX.Objects.CR.CROpportunity> { #region UsrProbability [PXDBInt] [PXIntList( new int[] {10,20,30,40,50,60,70,80,90,100}, new string[] {"10%","20%","30%","40%","50%","60%","70%","80%","90%", "100%"})] [PXUIField(DisplayName = "Probability")] public virtual int? UsrProbability { get; set; } public abstract class usrProbability : PX.Data.BQL.BqlInt.Field<usrProbability> { } #endregion }} 

Let’s say that we have 2 different warehouses, MAIN warehouse, and another warehouse in a different city that is SECONDARY warehouse. We create a sales order with 9 items from MAIN warehouse, but one item is only available in SECONDARY warehouse. We want to transfer the stcok required from SECONDARY warehouse to MAIN warehouse, for inclusion in the customer’s order for one consolidated delivery all at the same time.Is there a way to transfer this inventory from SECONDARY warehouse to MAIN warehouse, for consolidation into the single order automatically? (the alternative of course is to transfer first, and then add to the customer’s order, but this runs ths risk that someone else grabs that inventory after the transfer to the MAIN warehouse).

I want to update UsrSendPONotifications checkbox(which is in PO screen) to true when I update a row in corresponding PO Receipt.This is the code that I tried & it is not working. So , UsrSendPONotifications checkbox remains false.Any idea about this?   protected void POReceipt_RowUpdated(PXCache cache, PXRowUpdatedEventArgs e)    {                  var row = (POReceipt)e.Row;            if (row == null) return;            else            {                POReceiptLine receiptLine = new PXSelect<POReceiptLine, Where<POReceiptLine.receiptNbr, Equal<Required<POReceiptLine.receiptNbr>>>>(Base).Select(row.ReceiptNbr);                if(receiptLine == null) return;                  else                {                    POOrder poOrder = new PXSelect<POOrder, Where<POOrder.orderType, Equal<Required<POOrder.orderType>>, And<POOrder.orderNbr, Equal<Required<POOrder.orderNbr>>>>>(Base).Select(receiptLine.POType, receiptLine

Hi all,I’d like to use the default endpoint to retrieve the relationship between the Project & Vendor. Could someone shed some light on how to $expand that please? (Tool used : Postman)Can it be achieved by creating a customized endpoint which I have added the Vendors (screenname) but how do I expand that to link Projects?See below image for the new endpoint. 

Hello,Reading the ACU documentation and it's not abundantly clear...When you publish a Customization, do you need to have the Role of "Customizer" assigned to a user in order for them to access the screens it has created or edited?and/or is this embedded in the Access Rights portion of the customization?  Cheers!k2

@Naveen Boga  I need to create a workflow condition such that when a user creates a new service order, and does not have a service item in the details, the status on the document will change.  My issue is accessing the document details grid to use in a condition.  It seems that when doing a workflow I can use any of the FS.ServiceOrder DAC fields in a condition/action but none of the FS.SODet (details) fields.  Is there some secret method to making the details available?  Note: I am not a coder and am looking for non-coding solutions.  Thanks.  

I have removed some snap shots from our production instance and ran the “Optimize Database”  operation. However I am still seeing space being occupied by the snap shots. Has anyone else seen this? How can i keep up with the Whitespace usage and Acumatica.   

The report is only pulling data utilizing the main report parameters.  As long as there is data within the parameters of the main report it will print the main report and will then print the data from the subreport that is within the same parameters. If nothing prints in the main document due to the parameters nothing prints from the subaccount even though there is data that should print. What am I missing?

Is there away to update the BOM material items expiration date?   We just are testing some BOMs in our pilot configurations. and realized that some items have expired?  As far as I can tell you would need to make a new revision?  Does the expiration date effect using the BOM in Production.I am new to Manufacturing.  I figured you should be able to update the existing. Thank you in advance for your assistance

All I have a labor batch that Will release, create the GLBatch and Create the Cost Batch however the cost batch will not process. and the labor batch ends with an error Another Process has added the ‘AMProdEvent’ record. - The labor batch is still in “balanced” status, the Cost Transaction is still in “UNReleased” Status. My assumption is I could probably release the cost transaction. Which would finish the process. But would that close the Labor batch?  

On the payments and applications screen, type is customer refund and apply to documents of type prepayment, I’m unable to add finance charges. May I know what’s the logic behind where finance charges option is disabled for customer refund? And also, how can I process the finance charges?

If I want to add new DB fields on this screen, which table they will be added I know its ScanHeader DACExtension but I am not able to find the respective table. I need to add details like on which day this shipment was scanned it was scanned by whom and data like that. 

A store credit is given to a customer manually in Big Commerce.  The customer can apply store credits to their order.  What type of payment method should be used in Acumatica for the processing and accounting?  You would think this is really a discount because you never did a transaction in Acumatica for this.  Even if you created a credit memo on account in Acumatica, this is no way to create a store credit in Big Commerce.

HelloIs it possible to enable record counting at Processing pages or Inquiry pages on Layout as it is at Generic Inquiries?

Has anyone else encountered issues with Shopify real time sync after updating to the latest build of Acumatica 2022R1?  We are now getting an error “The push notification definition is not found in the system.” when we try to stop and restart the real-time sync. 

We have a customer that delivers product from their own truck.  They need to print an invoice from the truck once delivery is complete.  Is there a way to print from Acumatica, on a tablet to a blue toothed printer?

I want to add value in DB for one of my DACExtension.protected void ScanHeader_Barcode_FieldUpdated(PXCache cache, PXFieldUpdatedEventArgs e){ ScanHeader row = (ScanHeader)e.Row; HeaderExt headerExt = row.GetExtension<HeaderExt>(); PickPackShip.Host graph = PXGraph.CreateInstance<PickPackShip.Host>(); SOShipment shipment = (from p in graph.Select<SOShipment>() where p.ShipmentNbr == row.Barcode select p).FirstOrDefault(); if (shipment != null) { SOShipmentExt shipmentExt = shipment.GetExtension<SOShipmentExt>(); cache.SetValueExt<SOShipmentExt.myField>(shipment, headerExt.MyField); }}I am trying like this but this is not working. My graph is not directly linked with SOShipment. My graph is PickPackShip.Host

Hello.So my DB has significantly increased in size. I suspect the culprit are orphaned snapshots. I had the warning signed in System → Tenants, that there were at least 2 orphaned snapshots but when I clicked on optimize database to remove does orphaned snapshots I got an error almost immediately and then the warning sign disappeared. Is there a way I can manually check in the SQL database to see if there are any orphaned snapshots and to delete all those records from the database? Also when I check the database size in the Acumatica Interface by going to System - Tenants - View Space Usage, it shows the database size is 110GB in total - but SQL Management Studio shows the Database Size is almost 300GB and when I do a manual backup thats about the size of the .bak file...  Any pointers as what I can do to fix this issue would be greatly appreciated. 

I have a situation where I need to have add a second AP bill to a Landed Cost Entry. After I create first AP bill, the landed cost is no longer available to be used.  I tried a partial amount.  I cannot change the qty.?

how to handle or bypass api error “quantity available will go negative”?Validate Min. Markup set no validation  

 i have problem if i add paramater in generic inquiry in acumatica mobile, help