Distribution

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

We have a business event which sends a notification to the Purchase Order Approver.We want the owner of the PO to be notified also. Which screen field should be used so that the PO owners email can be copied in the CC field on the email template? Regards

Hi,Can u pls help me with the Custom button which are written for Invoice and Memos Screen but it also displays in Invoice Screen  

Invoice, click print.  There is a green email button.  For some users it is greyed out.  Where is the security setting for that button?

Hello EveryoneWe have a problem with the size of the database due to the emails and attachements.Is there something we can do in order not to save these emails with their attachements ? a setting we missed?  If not a possibility of a purge of the data we don’t need ?Any ideas Thnx;

What functionality should I expect from the ShipStation integration? I’ve installed the customization, connected both systems within ShipStation, and started configuring ShipStation in Acumatica. However, I’m struggling to get orders to sync to ShipStation. What needs to be set up in Ship Via? Is a carrier required? I’ve reviewed the user guide from ShipStation but still can’t get the orders to sync. Additionally, will the "Shop for Rates" feature be available with this integration? I haven’t been able to find any clear resources on this—can you help?

ACH payments are our primary means of remittance.  Our ACH payments are accompanied by an emailed Remittance Advice (triggered by a Business Event).  This has worked without issue for the two years we have been on Acumatica.  For the same amount of time we have been trying to get Acumatica to email a Remittance Advice when making an ACH payment for a Prepayment (out of Purchase Order). At first we tried making Active a stock Business Event, “Email Vendor ACH Prepay Advice,” which did not work.  We have subsequently tried numerous modifications.  Requests for Vendor Prepayments are fairly infrequent.  Sometimes weeks pass between a failed attempt, a modification and the occasion to try again. At any rate, here is what has most recently failed: Anyone have the magic combination to cause Acumatica to email a Remittance Advice for an ACH Prepayment?

We are in the metals industry, and one of the somewhat unique aspects of our business from an ERP perspective is that sometimes we will cut pieces of material that we sell into smaller pieces, per our customer’s request. So as a simple example, let’s say you have a 20ft x 20 ft piece of aluminum plate, and the customer asks for a piece that is 16ft x 18ft. We will cut that plate to size, and then have a remainder (what we call a remnant or a piece) that is left over. Sometimes we will directly scrap this remainder (not keep it around), and other times we will keep it on hand and sell it to another customer, or use it to cut another piece for a customer who may require a size smaller than that previously cut piece. We need to maintain heat/lot tracking of these pieces from the parent item.Does anyone have any clever ideas about the best way to program this in Acumatica? You could obviously create a new item every time you create one of these pieces, that is the exact dimensions of the p

Every Purchase Order requires a Vendor. Every Item has a Vendor attached to it. How do I tell a PO to only allow line items who are set for the vendor on the PO? Example: I am buying from Bob on a PO, but Acumatica lets me try to buy an item that is only sold by Frank. If a PO is for Bob, why can’t the item selector only show me items buyable from Bob? I don’t care about the things I can buy from Frank. This would also help ensure that the vendors are attached properly (like Bob sells Milk, but I don’t see Milk on my list, so I know something is off on the item). Hopefully this is a toggle somewhere I’m missing.

I can’t find a report or inquiry that displays project specific inventory quantity. The only time you get to see the quantity for project specific inventory is when you add a line with an inventory item on the sales order, shipment, transfer or issue form, then the information gets displayed in the footer section of the screen as indicated below.project inventory tracking on the footer of the applicable formsWhat table and field name is used to store project specific inventory quantities that’s reserved in a virtual location.Thanks.

Does anyone else run into the issue of not being able to use non-stock kits because any component that has user-enterable lots cannot be added to a Non-stock Kit specification?If so, what was your solution? This has been a huge pain point for us.

I am importing invoices into screen SO303000 and I have 2,500 record lines and this is taking about 6 hours, previously I would import this in under an hour using the same template.What could be the issue?

We’d like to “Update Matrix Items” with the attribute values that we’ve added to our Template Items. We learned, after selling some items for free, that it also over-writes the default price with the 0.00 from the Template. Our Matrix Items represent sizes and are each their own price, so we’d like to NOT update the price when we use the “Update Matrix Items” function. Is this possible?

Hi Team When I send an email using below actions> Purchase order> Print purchase order> send- When I click send I am getting only signature in the email body, however the subject line shows as expected. I am unable to reproduce the issue in another instance or local instance. 

HI,When create the purchase receipt, the sales order’s shipped qty column indicates the receipt qty as shipped. But the created purchase receipt was incorrect and the user need to cancel (Return or something to correct the error) the release purchase receipt and receipt again the correct qty.Once we create the Return using the following button, it allows to receipt again the same PO qty.After create the return, Then we have create the purchase receipt again with correct qty. system allow to do the same but the SO shipped qty indicates as followWhat is the process to correct the erroneously created drop ship reciept without doing any adjustments to the created SO? or is there any other process?Thanks 

Hi,A client is having an issue where the Owner field in the Purchase Orders screen is always empty.I found the existing question below about this issue, but the selected answer didn't work for me.Is there a different way that this Owner field should be populated now? If so, what is the best way to added options for this field?Let me know if I can provide any other information.Kind regards,Andrew Purchase Order owner | Community (acumatica.com)  

Hello, apologies for the long question.I am working to setup Acumatica and noticed the handling of inventory for Sales Order shipments is different than every system I have worked on in the past. With our current configuration, when you create shipment for a Sales order you stop just short of Updating IN. This is because one you Update IN it creates the inventory COGS transaction on the PL. We do not invoice and recognize the revenue, until the product is delivered to our customers. So if you do Update IN this creates a disconnect between revenue and expense (not an option). However, if you do not Update IN the inventory remains “On Hand” at the warehouse and all reporting shows those quantities on hand. What I would prefer to see is that inventory moved to In Transit until the SO is invoices at which time the inventory is expenses and the Receivable is created. Due to the inventory remaining ON Hand I am having a difficult time reconciling physical counts at our sites and creates a hu

Has anyone had any luck in customising Shipment fields to allow editing after shipment confirmation?Our company requires multiple shipments (one for each vehicle) against the same order. Due to Acumatica limitations, this means we need to confirm the earlier shipment to open a subsequent one, despite the shipment not actually being confirmed. Naturally, this leads to errors, which are particularly difficult to correct due to too many subsequent shipments having been ‘confirmed’ already.This leads to the issue of how to rectify errors. Should there be any way to customise the editing of Shipment fields (such as date, description, UDFs, and quantity) even in a Confirmed state, it would help a lot to resolve our problem.Thanks!

Error: “The account is on a credit hold. Remove from credit hold?” When I am creating a new sales order, the following error has occurred. 

Hello Everyone,Can you please help me with the sample source code to enable the field in the Sales Order screen when the Sales Order status is in COMPLETED status using WORKFLOWs from the code level? 

Hello Everyone,What is the best practice for receiving inventory at landed cost when the freight is charged as a separate line item by the goods vendor?The distinction from using a Landed Cost document is that the freight is being charged by the goods vendor on the same invoice as the goods receipt, not from a separate freight vendor.  The following idea has been submitted, but wanted to check if anyone had a good process for this while under review.Thank you!Luke

Setup some stock skus to use related items (set the item class to NOT allow Negatives) and tried to assemble a kit that one of the components was at a qty 0, and had allow for substitutions but I’m not sure where I pick the substitution item to add to the Kit assemble BOM.  Is there something I’m missing in the process?   How do I process the substitution?  

I have a report designed based on the historical inventory valuation and I would want to introduce a date range parameter instead of using the Period as is with the standard Acumatica forms. I have the report date field selected via the filter but when I run the report on data is extracted.Has anyone worked with an inventory valuation report where one can draw the date parameter range instead of using a period?

The company purchases consumables in bulk e.g. stationery, refreshments. Once received into inventory, employees request these items with the employee's manager approval. The request also should specify the expense subaccount. Inventory clerk should then be able to pick up the request and issue quantities on request or less but not more.Creating an "internal" order type seemed brilliant, selling the items at zero price. The only drawback was all order types including trade orders use the same shipment numbering sequence. How best can this be setup? 

I have a situation where kits will be produced in one warehouse then transferred to another warehouse using at transfer sales order.  However, when I plan replenishments and don’t have a replenishment method assigned to the kit items in the production warehouse, I cannot get an amount to process in the prepare replenishment grid.I could set up bogus replenishment parameters, but want to avoid that.  Any help on planning replenishments for kits?  I think maybe there is a gap here. Thanks,Dennis