Solved

Is there a way to easily CORRECT the Vendor Reference Number (ie. invoice #) of a Bill after it has been released and before it has been paid?  Currently the only way I see how to do this is to reverse the whole Bill.  This seems extremely unnecessary when what is needed is just an invoice # CORRECTION.  This is no different than changing the Due Date which, correctly so, is allowed.

I am trying to create an import scenario to import the Employee History line.  So that we do not have to hand enter the base data.I already created an Import Scenario to import and update the EPPositions table data.All I want to do now, is create an Import Scenario to import the “IsActive”, “PositionID”, and “StartDate” in the attached spreadsheet to the existing employee record under the Employee History tab.I am struggling creating the data provider and import scenario as it throws errors saying so many other columns need to be in the scenario, even though I do not want to update them.  (2nd spreadsheet attached show the errors on import)Does anyone have an Import Scenario for updating the Employee History that they would mind sharing as a template?Thank you!   

I am having an issue with the replenishment report not working all of the time.  One day the items show to reorder, and the next they do not.  Here are screen shots of what I am seeing.   From this screen shot you can see that some of these items should come up on my reorder report, and they did yesterday.  Today I am getting ready to order these items.  And this is what I see now.  You can see that they should still be there based on the parameters.  However they do not show up today.  I am not sure why it has changed.  We have not made any changes to the items.  If someone can explain that would be very appreciated.Thank you, 

I will occasionally get this error in the sync history preventing an order from importing into Acumatica. The inventory ID is not missing from the item on Shopify, and exists in Acumatica. See below for the highlighted error. Has anyone else experienced this and know the root cause of the error?  

Can anyone offer instructions on how to configure Acumatica (2020 R1) to give free shipping on orders over $500 on select Item Classes?  

I have included a confirmation message when click on save. If user click yes it proceeds to save. If click no i get this error. I just to to avoid save if click no but instead i get this. Why is that ? My code:  public void ARInvoice_RowPersisting(PXCache cache, PXRowPersistingEventArgs e, PXRowPersisting baseHandler)    {     if (baseHandler!= null)                baseHandler(cache, e);                   WebDialogResult result = Base.Document.Ask("Confirmation", "Do you want to save?", MessageButtons.YesNo);         if (result == WebDialogResult.No)         {             e.Cancel = true; // User clicked "No" in the confirmation dialog, cancel the save operation         }    }

Good day. We’re having a bit of a struggle determining the naming of entities in order to extract the relevant information via api calls. Example: We are trying to expand/extract the Ecommerce Data tab field “description”. Where exactly can we look to find the naming of this entity to expand? Will appreciate any guidance.Thank you     

Hi all !I’m facing a localization issue in screen SM206036 (BLC SYImportProcessSingle) with button “Add Substitution” (action “addSubstitutions”) in Acumatica 22.207. Even throught I set the french translation in dictionary for “Add Substitution” expression, the label of this button remains in English in the screen.Below, here is the original screen : Below, the translated screen :  Notes :    I stopped and restarted IIS after this change to force localization refresh,    As far as I could see, we do not have any customization on this screenThat’s weird because the translation of button (action “switchActivation”) just right next button “Add Substitution” wotks fine.Note : same issue with “Replace” (action “viewReplacement”).As I could see, the “switchActivation” action is directly defined in BLC SYImportProcessSingle  used by the screen whereas action “addSubstitutions” is defined in a parent class : SYProcess. The inheritance chainis the following one :SYImportProcessSingle  ->SYI

HelloI have a number in Acumatica Report which is calculated from following expression:How to display this result from Decimal in words?I found  a few articles but it isn’t what I need: https://www.acumatica.dev/admin/decimal-amount-into-text-words/ but it converts a value of field to words https://acumatica12.rssing.com/chan-6994821/article91.html build very long formula so it isn’t suitable for my case with Trillion number https://stackoverflow.com/questions/51728097/how-to-call-acumatica-function-from-report-designer I do not have access to the production server to edit ReportLauncher.aspx.cs file (Website Folder > Frames)Do you have any solution?Cheers

I’m working with a partner, and were attempting to reconcile many months of inventory history to the Trial Balance Summary. We’re attempting to build generic inquiries to do this using the INTran and INTranSplit tables, extracting rows, grouping by our materials / lots / warehouses / locations to find that last transaction and filtering by Financial Period.  Our comparison results are sometimes close, but never tying out. The back story is that a number of inventory receipts and adjustment were done during various go-lives and onboarding events, and now the Finance department is concerned about being able to audit the the history, essentiallly using details to prove out the Trial Balance Summary report.Has anyone out there encountered this circumstance? Perhaps someone might shed some light on how the Trial Balance Report (especially Inventory Accounts) is calculated and relates to the transaction history?  Many thanks!

Upon Adding of New Restriction Groups,The system gave me this error.Would you help me to solve this issue? 

Good day,I am trying to do nest IF Statement for the style based on the results.  I have a syntax issue which I can seem to resolve.  Any assistance would be greatly appreciated.  I have work on a couple of hours now. Thank you.=IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])=0,'Green60'), IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])=1,'yellow60'),IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])='-1','yellow60'),IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])=>2,'red60'),IIf(DateDiff('d',[SOOrder.RequestDate],[SOOrderShipment.ShipDate])=>-2,'red60')

HIis there a way to have authorized items for certain customers meaning certain customers can only order these items how about restricting unit of measure etc..

I’d like the ability to mass create employee timecards and potentially put that on an automation schedule.  Currently, we are using field service logs to populate employee timecards but I have to manually create the weekly timecards for each employee at the beginning of each week.  This is to make the time records viewable within Acumatica as well as our integrated payroll system.   I submitted a case directly to Acumatica Support and was informed that this is not currently doable through business events.  There may be a customization option, but that’s outside of my expertise.  I’d love to see suggestions for how to go about that if anyone has done something similar. Otherwise, it would be great to include this functionality in a future release. Thanks,Eric

Good morning, while on the Credit Memo and Debit Memo screen in AR, when we add a row, the row automatically adds account 3030. How can we change this to be an account other than 3030? Note: we know how to change it after the row is added, we need to change it so when we add a row it automatically goes to another account other than 3030. See attached below for reference:Thanks!

We have found some instances where bills were applied to commitments so the commitment is currently overstated.  I need to reduce the amount of the commitment by $200,000. I can’t edit the commitment itself and for some reason the change order screen is not allowing me to do a deduct change order of -200,000 (it’s not liking that it’s negative for some reason).  How am I to reduce the amount of a commitment??

Hello, I am trying to generate multiple weeks of 0 timecards for employees, the previous method that was located in the Employment History settings is no longer available, we recently updated to 2023 R1Where can the new method be found? 

I have a basic Acumatica Shipping question I hope someone can help me with. We are setting up Acumatica Shipping.  We only want to use Acumatica Shipping and not any third party plug in(s). We are using the basic Acumatica Shipping and not the Acumatica WMS. Does Acumatica Shipping have a “Packing List”, and does this Packing List include how many boxes are being shipped?  I found the Acumatica Shipping Confirmation, but it does not include the number of boxes shipped.  Your help is greatly appreciated.  

A lot of our Customers want us to ship product Collect and bill their freight account.  We are not integrating Carriers into our system as of yet but has anyone come up with a good way for Order Entry to key in the Customer’s freight account so it is visible on the Shipment Conformation and the Invoicing department will charge the correct account. all ideas are welcome.  

How to Hide Zero from a report.Highlighted fields should be hide?  

Hi,In the case we have a multi select combo box attribute like this :Attribute I want to isolate a specific value of the combo box like the last one (ValueID=Complété).For this, i put a formula in the GI and I get this error message(Picture Below).=IIF(INSTR([FSServiceOrder.DOCUMENTS_Attributes],'Complété')=1,True,False) I putted a Schema Field “FSAppointment.Completed” GIDo you have an idea how to resolve this?Thanks!

Hello all,I have abeen working on an export scenario and I have a condition that it should only export those records that have ‘AB’ as a prefix added in the batch number. How can I put up this condition? 

Hi,What happens when landed cost is added to an item after the the inventory issuance? For example, our manufacture sends us an invoice for the landed costs associated with a PO after its been received. In some instances the landed cost has been received even after we’ve invoiced and sent those items  out to our customers. I’m curious as to what happens in Acumatica once I add the Landed Costs to those items after its been invoiced and shipped out. How are the landed costs expensed as COGS. -Edwin

This is simply ridiculous.  I should be able to do this easily.  I created a Data Provider and Import Scenario to simply upload/import into Acumatica the job positions I want to use for Employees.  I have created imports dozens, (if not hundreds), of times, and this is one the simplest I have every needed to do, but it continues to error out on me and not process any of the records.  (There are only 51 of them).Can someone tell me what I am doing wrong and why this will not work?I am attaching the Data Provider, Import Scenario XML files and the original Excel file I am using. 

I am getting an error while inactive the warehouse ! Unreleased trasaction ? How to check the unreleased trasaction and make warehouse inactive.