Solved

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

I need the date output in a GI to be yyyy/mm/dd for a third party integration but we use mm/dd/yyyy as a default. How can I flip this around?

Dear ALL,I created Generic Inquiry using “InventoryTranHistEnqFilter” table. But when I pressed “VIEW INQUIRY” to see the result it gave error “Invalid object name 'InventoryTranHistEnqFilter'”.Please explain the cause of the error and help how to fix it !Many thanks !NNT 

Hi, We are going to have clients log into to Acumatica. But they will need to view only their customer account in Receivables and their relevant stock and non- stock items related to the item class. Here are the screenshots for my Restriction Group Setup for Inventory Item by Item Class. Note there is only ONE company not multiple companies. Here is the user that will only have access to the TXC item class.   Here is the setup to restrict access to the item class. Note nothing was done in Inventory Items since they are grouped under the Item Classes.   When I log in as that user all of the inventory amounts still show. What am I doing wrong any help would be appreciated: 

Hi all, Can you help me about the Tally of records in Inventory Summary to Purchase Receipts because when I create a Purchase Order then Purchase Receipts the quantity is correct but when I go to Inventory Summary the total of Purchase Receipts is double (Please see the screenshot below) This is the total of Purchase Receipts (On-hand, Available, and Shipping are 100) But in the Inventory Summary is double the digit of quantity that I received in Purchase Receipts  and in the Inventory Balance are the same reports   Please help me to fix this bugs.

Any possibility of Commerce edition supporting Mfg Product Configurator with commerce sites?

Hi,  I’ve found some instances where a user deleted an item of a SO while not canceling the drop-ship PO. This could be very common when dealing with high volume ecommerce shipments. Is there a way to prevent this from happening? Workflow should be Cancel PO > Remove Item from SO 

Trying to convert the code below for the 2022 R1 release.  The PX.Objects.CT.CTBillEngine.ARContractInvoiceEntry graph has been removed, but I cannot find what it should be replaced with.The code is updating some custom fields on the Invoice generated from the Run Contract Billing action.    public delegate void BillDelegate(Nullable<Int32> contractID, Nullable<DateTime> date);    [PXOverride]    public void Bill(Nullable<Int32> contractID, Nullable<DateTime> date, BillDelegate baseMethod)    {        PXGraph.InstanceCreated.AddHandler<PX.Objects.CT.CTBillEngine.ARContractInvoiceEntry>((graph) =>                  {            graph.RowInserted.AddHandler<ARInvoice>((sender, e) =>            {                ARInvoice inv = (ARInvoice)e.Row;                                 // pull value from custom UsrCustPO field                 Contract ContractRow = Contract.PK.Find(Base, contractID);                 // extension name:  ContractExt           

Hi, Created a PR. Created a PO using Auto create Function.  PO has been created. If user delete this PO, system not allow again to create the PO using same PR.How we can facilitate this? RegardsNethupul  

Hi - does anyone have any recommendations for a UK based Acumatica consultant who can help on UK VAT set up?

I have a IFF here that is working for formatting the cell in yellow=IIf( [POOrder.Status] = 'N', IIf( [POLine.PromisedDate] < Today(), 'yellow40', 'default'), 'default') What I want is to highlight the cells that are +14 days from today.Like you can in a filter @Today+14 Thanks 

Hi all, Do you know how do I add the Description Tab from stock items screen to a generic inquiry? If I add the body field that is how it looks.  Thanks, Patricia