Distribution

Is there a way in which the Quantity or Price can be checked or subjected to a threshold limit? This can prevent or reduce keying error entries. Perhaps the Limit on the Purchase Order should be enabled so e.g. If we already have a Max quantity in stock, then we should not be able to enter a new quantity to be purchased, unless their is already a sales order logged against the quantity on Stock, and then if so, that only the difference in quantity can be ordered and within a price range (otherwise requiring additional overriding authorisations).

Hi. Is there a way in Acumatica where I can partially receive a component item in a kit at Purchase Receipts transaction screen? Thanks!

Hi!I am working on figuring out how to make the following happen…I need to be able to have a map that assigns a sales person to the sales order depending on the customer account and which warehouse the product is coming from.  Anyone have any ideas on how to make that happen? Any help or input would be greatly appreciated :)Thank you!

We have a Dollar account and a Euro account.  We do a Bank Transfer from Dollar to Euro, enter the conversion rate, and everything works as it should.  Except our Euro bank charges $5 and we send it in the same transaction.  So if we want $1,000 worth of Euros, we actually transfer $1,005.  We tried adding a $5 detail line on the Bank Transfer but it still shows up as a separate transaction.  It would be silly to create a clearing account just to add these two amounts together, so we just deal with 2 debits in Acumatica Banking and 1 debit in Online Banking.  Does anyone have a solution?  (We don’t particularly want to modify the exchange rate to allow for the $5 either, although I know it’s another workaround.)

Hey All,I’m trying to create a generic inquiry for PO approvals. My goal is to link the GI to a business event to send to multiple approvers, owners etc. I have everything working except that the email address for the approver does not pull onto my GI.  Tables: Joins:POOrder to EPApproval   EPApproval to ContactResults: Email address is blank. Email is from the contact table. The contact table for the employee stores their email address.    Thanks!

I added some User Defined Fields on the Purchase Order document, however once I put the document to the open status these UDF are longer editable (same as other fields in the document header), I wonder if there is a solution for this, I need to edit these fields even when the document is in the open status.

I have been trying to get a transfer order Auto run to work and I have hit a point where I don't know what I have done incorrectly.Here is my parameters:Working with a Transfer order I have enabled Quick Process in the TR order type and the button appears on the top of the transfer order screen I have tested that the quick process produces a desired result of pushing the transfer order through shipping and updates IN appropriately when I manually press the OK button the process order screen.  I have started a customization project that once the transfer order is released it will pop open the quick process screen and then it stops.  In the customization I went ahead an found an action of OK (quickProcessOk) on the actions screen and set the auto run to true. When I remove the order from hold the following screen pops up but then nothing future happens.  Does anyone have a clue of where I may be off here?  The desired result is when the order is taken off of hold the quick process runs w

Hello, We’ve run into an interesting problem. Some of the Stock Items we purchase are sometimes sourced by more than one country. The ‘Country of Origin’ field on Stock Items is limited to one option unfortunately. Has anyone else ran into a similar issue, and if so, how did you go about resolving it? Outside of customization, I’m hoping someone’s had an interesting way of handling this that I might just be missing. 

I want to create a widget based on the screen AR409000, where all sales are summed together, regardless of customer class. If I delete the customer class in the inquiry parameters, so that the field is empty, the system does not implement this, I still only see the sales in the standard customer class in the widget. Does anyone have an idea how I can solve this problem?   

My client has over 3000 variants and will be converting their web site to Big Commerce.  I have added all of the Variants to the item classes but now I need to import the template items but it insists I have default column attribute - most of the template items have a single variant which will be the Row Variant.  How can I, turn off the Active flag and only have active the single variant I need for the Row.  Adding a dummy column variant would overcome the issue but them I would need to go back and somehow make inactive the variants and remove the dummy,  

We are new to Acumatica, and we have issues with emailing the customer statement. It says, "Error: The email account is empty...". Despite the fact that all of the customers' email addresses are incorrectly set up on the customer profile, are there any other places in Acumaitca to fix the issues other than the customer profile? I deleted the last statement and regenrated it several times, but it did not fix the issue. 

Why is the total Dead Stock Cost in the dead stock screen different from the total cost in the inventory valuation & Inventory Summary.I have a item that shows the same QTY ON HAND in the Dead stock, Inventory Summary, Inventory Valuation but the DEAD STOCK COST is 47K but the Inventory Summary & Inventory Valuation the total cost is 14Kwhy is the Dead Stock qty calculating 47K ? How did it get that number Does the dead stock do some sort of Inventory Holding calculation?  

Hello, I created a custom printed form and placed it on the site map. I added a customization project that allows this form to be printed from the sales order screen via the action menu > Printing & Emailing section. (This form is a copy of the sales order without prices). When I print from the Site map, the form prints correctly using the selected parameters. When I print from the Action Menu, no data is visible. I have updated the user access to the new form to match the original form that was copied. What am I missing? 

I have a purchase order that has a extended cost of an inventory item pulled up from the Vendor Prices screen . How to change this setting . I do not want the line item in the purchase order to automatically populate the extended cost from the Vendor Prices screen , instead i want the extended cost in the purchase order to pull the last cost/current cost in the stock items screen.  

Many of our customers find it very annoying that they have to manually touch the “Set Qty” button on their mobile devices in order to set the quantity being picked/packed/shipped. We are trying to include the Set Qty command (*qty) as a barcode on the picklist report so that they can scan that command and then scan the barcode for the quantity (since there’s no way to set the mobile device to default to the shipping quantity).I can’t find the right way to format the command on the report so that the barcode scanner will read it and put the device in Set Qty mode.Does anyone know how to do this? 

Using 22R2.  We have set up a customer account in the Fedex carrier set up and set that to a billing type of Receiver.  When the label prints, the label shows the billing type as Third Party Billing.  Ideas?

I’m looking for a way to assign totes to shipments for wave picking before we print the pick list. Like a process screen that will allow me to do it in bulk.

Is there a way to short ship a wave or batch pick list? Let’s say I go to the location and the item isn’t physically there and I need to confirm the batch or wave pick list without that item. Currently when I try to hit confirm line, or confirm pick it gives me an error that the pick list is not done.

What access right should be allowed to view inventory in the creation of a GI? Anyone have an idea as to why this is not able to be viewed as an administrator? 

Scenario:We have a purchase order with item A , B , and C. We create a prepayment because this vendor requires a 50% down payment. This pre-payment gets allocated evenly between the 3 lines on the Purchase order.I then proceed to create the purchase receipt for just item B (LINE 2), that is the only thing that shipped. Give it a total of $300,which means I pre-paid the $150 and that is shown as the prepaid amount on the line item, on the purchase order. I create the purchase receipt and then release it to automatically create the Bill. I technically only owe the remaining $150 on this line item, but the bill is created for the full $300 and applies the full prepayment leaving only $25 to be remaining on this bill. Then when the other items are received it, it will look like we owe the full amount. When really, we need to pay the remaining $150 for this item for shipping, not for any other item that hasn’t shipped yet.Has anyone found a solution to this problem? Or is there a setting or

Confusion: We have the CRM module in our Acumatica 2023 R2.  Are Support and Cases now a part of the CRM module without extra licenses?  

How do I print a check out for a customer’s credit? I know how to print a check to pay a bill, but I have never printed a check to pay a customer their credit. 

Hello all,I have a PO created with status as Completed & Po Receipt released. And now I have a credit memo received. How can I record a credit memo against this PO? Thanks.

Acumatica - > EDI partner → drop ship vendor → customerWe have a drop ship edi integration done and i need to evaluate the inefficiencies in the current integration ? one area is to identify current manual task from the process map and try to automate them. Any other suggestions on how I can approach this ? 

How do I clear the error "one or more lines have unassigned location and/or Lot/Serial Number" for a PO receipt? We do not use Lot/Serial Numbers and only have one location (MAIN).