Distribution

My customer averages 5000 to 6000 Sales Orders records per month, which means that when users go into the Sales Orders List screen (SO3010PL) which is a GI substitute list to find records, the All Records tab shows at the bottom a total (as of today 7/17) 7,784 PAGESwhich are over 155,000 records - SO and RC:They have always complaint about how slow Acumatica is finding records and it’s getting worst as the months go by. We have tried created Tabs, minimizing the quick search fields and so on w/o any luck.ALL RECORDS tab (that is one created by Default by Acumatica) cannot be modified as far as I have tried and we want to find a way to have a second “All Records” tab and all it does, where we can limit the amount of data to show, in this case by last 12 months- as the Default Tab, which is a check mark we know and shared so everyone can see it, as the second tab after the All Records tab no matter how many other Tabs we have, shared or not.The Sales Orders is one of the many PL they wi

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?   

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!

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 !

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.

Hi Please assist , I'm attempting to set up a business event that will send out email notifications to supplier. Ive set up a generic inquiry as follows.I then set up a business event from that generic inquiry.However When i run the action on the inquiry , it says completed but doesnt trigger the event. Please assist, I don't know what I'm missing, i have attempted to troubleshoot using the following guide Troubleshooting business events | Community (acumatica.com) i still get same results. 

Anyone know why I got error after I uploaded the line detail ? the line details still showing empty and unassigned.  

I am attempting to obtain a list of the top 10 items for the current year, based on their order quantity. I have tried using the "select top" option in the generic inquiry, but it is not providing the desired results. What I require is the total quantity summed up, and then the top 10 items should be displayed in a pivot table.

Error Inventory Release Issue with message error : "Error: Key field cannot start with a leading space." Please Help

Do we have lotserialAttribute package for the latest 23R1 version?

Hello, team - I’m trying to create a customization for one of our branches.  They would like all new Sales Orders of Type = “QT” to have the Requested On date be the OrderDate + 14.  This would only be relevant to Branch 05 in our system.  I’ve attempted to put a formula in the Requested Date Default field.  I’m aware that this doesn’t identify any branch conditions, but figured I’d give it a try anyway.=[OrderDate]+IIf( [OrderType]='QT', 14, 0)However, this only resulted in an error, so my guess is that it’s the wrong way of going about it.  Any thoughts?  Thanks!

Hi Team,Seeking your assistance for this concern.I tried to add a new condition in approval maps in Acumatica but upon savings this error appear. By the way We add some branches and this error appears.Thanks !

Hi,We are getting this error when we try to add Landed Cost to this Purchase Receipt. The error occurs both when triggering the ‘Enter Landed Cost’ button directly on the PR, and manually adding the PR to the Landed Cost document.Our landed cost settings work well for other receipts, it’s just this PR which currently is triggering the error.There is sufficient stock in this warehouse of the same lot/serial and inventory ID, and no issues since the original receipt. The UOM still exists on the Stock Item. I can use the B900KG UOM in inventory transactions and new POs without issue.Anyone have any ideas on how to get the LC working?

Hi Acumatica,I tried to transact a kit assembly with a non stock items components.The Non Stock Item GL Set up is this.but when i post this kit assembly it gives me this entry. The question is why is it Cr. Inventory Account? Is there a set up for this? To control the Cr. Entry upon releasing of a particular kit? Thank you!

Hello Acumatica Community, Can you help me on the following two queries,When Lead/Business Account/Opportunity is assigned to a workgroup need to generate a email to workgroup member. How can i configure this? Our Marketing team using Map.acumatica.com portal for creating contacts, Is that portal has any connection with Acumatica CRM application, or they need to manually create a contact in both places separately?Regards,Jewel ParvezLead ERP Consultant Alliant Rigserv LLC       

We presently use (2022R1) StoragePlaceStatus DAC to get the Inventory storage location in our Production Ticket.  Going forward to 2022R2, the StoragePlaceStatus DAC is Nonexistent in DB. In what table or how do we get information regarding inventory and storage location by stock item?  Is there a way to modify Production Ticket Report to display locations for the stock item.  (We used StoragePlaceStatus in 2022R1)   Thanks for your help.

The Quality Management Suite for Acumatica by eWorkplace Apps can help you manage even the most complex industry and government regulations while supporting stringent quality requirements. It can help: Track vendor certification and qualification    Execute inspection with checklists  Conduct incoming testing on goods receipt, shipment, kitting, ad-hoc, and warehouse transfer Perform forward and backward lot traceability  And more Get the Framework Overview Request InformationOrContact PartnerRalph Kubekrkubek@eworkplaceapps.com949-591-8671www.eworkplaceapps.com

I’m new to use the replenishment features of Acumatica, and kind of confused when I see I can setup replenishment classes on the warehouse, item class, item profile and item/warehouse details screen.where would I setup these classes for an item or warehouse, and what hierarchy does Acumatica uses between these 4 screens mentioned above to determine which class to use? and additionally why would it allow me to save multiple classes on the item profile how would the system know which class to use?if anyone can please give a brief explanation would really be a big help, Thanks in advance.

When we activate an approval, all new sales orders are created with an on-hold status.SO type is set to NOT be on hold by default.So we want the approval enabled, but we do not want new sales orders to default to "on-hold" unless the approval criteria are met.Remove hold is what triggers the approval process, so it does not matter if they have "Hold Orders on Entry" option disabled.If you setup an approval map, all documents will always be created in Hold status so when they are taken off hold the system will review map conditions and assigned an approver if the conditions are trueApproval map will always override any hold documents option under preferences screen.

Good day,We are trying to adjust out inventory that no longer exist or has been used in an old warehouse that is no longer going to be used.  We want to reduce to the On Hand to zero and the close/deactivate the warehouse to avoid any new sales/purchases to this warehouse.IN Error: The multiplier must be equal to 0 or 1.  I can’t fine a fix to this error to allow us to release the adjustment.  Any suggestions would be helpfulThank you.@Evan G   

We have a manufactured part that is on backorder on numerous Sales Orders.  I have an “emergency” Sales Order that must go today before we fulfill all previously entered Sales Orders.  We have processed the part, item added to inventory but Acumatica has applied the item to the oldest outstanding backorder and is not available to pull on the “emergency” order.  Is there any way to circumvent/turn off this function off?

Here’s the scenario:We are creating a large blanket PO for ~ 30 different countertops which are all custom and will be drop-shipped to different customers. We would like to be able to link the drop-ship POs to both the blanket PO as well as linked to the end-customer Sales Order. Is it possible to be linked to both?    

Hello linkies,Hope y’all doing well.I have been trying to create Wave Picklist for a Shipment with multiple locations.So here’s the scenario: I am looking to assign multiple pickers to the wave lists - one wave list for single shipment - with inventories from same warehouse but different locations - for those different locations different pickers to be assigned.I have created a Shipment as shown below:  And now when I try to Create a Pick List by filtering the values on the basis of the Location, the system doesn’t display the results in the table as shown below:  Also, upon creating a Wave Picklist, when I proceed to assign, the system displays me only 1 picker for one wavelist. Whereas, I have not been able to assign the same picklist to different pickers-as the locations are different:    Can anyone please guide me what I am missing here? Thank you in advance.

Hi Sir if we would like change inventory ID for certain part #. All the information are same and only change the inventory ID . How do we make the change in system? example from inventory ID : ABC change to XYZ     

I am trying to find a way to view deleted shipment records to discover who is deleting them and why they are being deleted. I tried to do this through a GI but I don't think the Shipments table supports exposing deleted shipments. Does anyone have a better idea as to how I can accomplish this?