Distribution

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.  

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

Good Morning,I have an issue where the customer wants to run the PO Order and send it out via email.  This of course works as expected.  They also wanted a sign off form attached.   Initially this was solved using the report footer as the sign off page.  However, the customer wants them separated into two distinct attachments on the email and not one document.  My initial thought is that this is now two form reports, the latter being triggered by the former (PO Order) running.  Is there some good way to solve this? Goal:  Customer runs PO Order Form Report, clicks send.  Email has two attachments, the purchase order and the sign off form.  Do note that the sign off also has purchase order and project info on it.

Good day all,I have added a project column to the grid on the reconciliation tab of the Fixed Assets form. After that I added a project ID on the header as shown belowWhen I select a project ID at the top I want it to filter the data below using the project ID selected. I have extended the AssetMant graph using the code below but when I publish I get errorsnamespace PX.Objects.FA{ public class AssetMaint_Extension : PXGraphExtension<PX.Objects.FA.AssetMaint> { #region Event Handlers public PXFilter<GLTranFilter> Filter; protected virtual IEnumerable DsplAdditions() { if (Filter.Current != null && !string.IsNullOrEmpty(Filter.Current.UsrProjectFilter)) { // Apply filter

We are currently in version 2022 R2. Tax Category, Taxes Zone, and Taxes have all been set up.  We implemented in a Canadian branch, which is why we are adding a GST tax. However, the tax is not generating on POs and APs. I have found a post, but our situation is the opposite. @Laura02   helped me out a lot to check and she was unable to get tax to appear on a PO in 2022 R2, which is the same version we are using at the moment. Purchase orders getting issued with tax - despite vendor being Tax Exempt Could this be a version issue? The PO and Bills and Adjustments are not generating a tax? Is there anyone else experiencing the same problem.

Does anyone know how to load external url image to Acumatica Form?For example I have an UDF UsrImageUrl = https://designerimages.artifi.net/UserPhoto/0e8a78b2-eea3-475e-b38c-b3ea2b606926/Customize/Standard/5f2142de-766c-44a0-8f32-0b447de9f6e2.png.How do I load image in UsrImageUrl to an Form? Thanks

Hi, I am trying to import on the Item Warehouse Details and I am getting an error that the warehouse can not be empty. Does anyone have an idea?Here is the screen that I am importing to:The import scenario:The error (warehouses are filled in) 

On Requisition detail, there is an Account and Subaccount field. When I enter a Requisition, these fields are empty by default. If I populate the fields, then create PO from the requisition, the Account flows to the PO (even if different from account on the non-stock item), BUT the subaccount does not. It defaults from non-stock item. Is there a way to allow subaccount to flow from Requisition to PO?  My understanding is AP Preferences determine where the subaccount comes from if non-stock items are used. I have it set to pull from inventory item. Don’t see anything that could be changed here to accomplish the above. Anyone know what else I could do? I don’t understand the point of subaccount on Requisition if it can’t flow to the PO/Receipt where the actual posting occurs. Thought maybe it’s just for budgeting, but that doesn’t explain why the Account does flow to the PO.  Thanks in advance. 

Community,I was working with the Inventory Transaction Summary report, and when you click the box ‘Show Items Without Movement’ it still shows items with movement.  When I open the Transaction Details, it shows receipts/issues etc. This is also with a specific location chosen.   I have a manger that is wanting to see every part number that has a specific receipt location that has no transaction history.Any thoughts?  Ideas?  I’m willing to write a report, but do not want to recreate the wheel if there is something better already out there.Thank you,Trisha

Hello  I want to display on the Sales Order report , the item description with to languages at once I know the info is in InvenrotyItemKvExt  but i can’t find it in report designer 

Hello Acumatica Community,As a boat manufacturer, we procure aluminum in bars and send them to an external company for cutting into sheets. How can we effectively track this process in Acumatica, to keep consistency with Item IDs and managing Unit of Measure (UOM) conversions seamlessly?Please share your insights. Thanks!

I need to create a generic inquiry using data on the Inventory Summary screen and I specifically need Lot/Serial Number. I can find most of the fields I need in INLocationStatus, but serial number isn’t stored there. Where can I find that? 

Hi! I have a client with this requirement: for POs they need to be able to assign a condition to each line item, for example, new, used, refurbished, etc. This condition then needs to flow down to the purchase receipt so receiving makes sure they receive the item in its proper condition. We’ve already mentioned using line item notes but they don’t like it. I’ve thought about template items but that might be excessive. I’m thinking about item cross references or related items since Acumatica no longer has subitems. But if you have any ideas would be great.

Hi everyone,We’re delighted to announce this Community Mentoring session with @Neil Cantral!Business Events for Order ManagementA brief overview of Acumatica Business Events, how they are used to manage orders in a B2B distribution company, and a Q&A.Neil: I’m a leader in the PNW Acumatica Users Group and the Director of IT for Wilmar LLC, a B2B distributor of automotive tools trading under brands like Performance Tool. My Acumatica journey started in 2016 and I’m always happy to talk and share my experience with the platform. My focus over the years has been rooted in the Distribution module with a lot of experience in inventory allocations, reporting, third-party WMS, and customization.Community Mentoring sessions are approximately 30 minutes and limited to small groups (10-12) of members with one of our power users who is an expert on a topic. If this sessio

Hi Can we create purchase order types in the acumatica same as the SO order types?

We have an intercompany vendor that we purchase goods from without any tax impact. The vendor is tax exempt, but when we issue a PO, it is generated with tax. When we generate interco sales order, it is generated without tax. Any idea why the PO would be getting created with tax? The item on the PO is a taxable item as it is taxable to the end customer.  

Is there a way to find out which account scanned which items using a mobile scanner, not an inventory tag? It would be really helpful for auditing if I could track exactly which account scanned what items and I figure it must be somewhere.

Hi Everyone,I am wondering if anyone in the group have tried and succeed in having a conditions set between multiple attributes so only relevant data shows based on what was selected. I see some old article which is referring to product configurator and some rules, however in 2023R1, I don't see these type of rules available to link attributes.Example :Attribute 1 (Brand) = TOYOTA , HONDAAttribute 2 (Model) = Camry, Highlander, GR86, CR-V, Accord, PilotWhen Attribute 1 is chosen by the user as Toyota for the Attribute 2 user should only see relevant model of Toyota and not Honda models.Thanks,Hari 

HI All,We are a trading company in construction business. We buy products from oversea supplier, and product is customized to fix with specific project, which means the components of product may not be changed but the qty of component to create a finished product will be changed, and the dimension of finished product will change too.For example, I got an order 1 Movable Wall for Project A, 1 Movable Wall for Project B (because of different project, the finished Movable Wall will be in different size). The information related to 2 Movable Wall is display as below table:Product Component Component QTY Packages QTY Movable Wall Project A Frame 1 2   Wall 1 2 Movable Wall Project B Frame 2 3   Wall 3

Hi,Looking for your insights into the the following questions around inventory valuation methods.Average Cost Calculation:  Is the average cost recalculation triggered only on a purchase? If a purchase is back dated after a sale has already been posted does the system recalculate the cost on that sale to reflect the true average cost? FIFO Cost Calculation If a purchase is back dated after a sale has already been posted does the system recalculate the cost on that sale to reflect the proper FIFO cost? Inventory Adjustments:  Under FIFO do all inventory adjustments need to be matched to a prior purchase?  Negative Inventory: Average Cost:  If inventory sold into a negative position and purchase back dated will system adjust costs to accurate average cost or just use the last cost for sales made? FIFO:  If inventory sold into a negative position and purchase back dated will

I have been using stock item attributes for years. They always show up in the InventoryItem DAC for me to select in a generic inquiry on on a report.However, I’ve just run into a situation where they aren’t in the InventoryItem DAC and I can’t figure out why they are not showing up for this specific customer.I have set up this attribute: And added it to this Item Class: The attribute shows up on the Stock Item and allows me to enter a value: However, when I try to add it as a column on the Stock Items list, the attr

Client has a 5 page Terms & Conditions for the want to have sent with their PO.  It has word-level formatting which would be time consuming to replicate in report designer.  I tried adding a PDF version of the T&C’s to the email template but it doesn’t carry over when I send a PO out of the system using that template.Outside of writing the report does anyone have an easier method of attaching a document to a template that isn’t a report?  

Hi Everyone,I am unable to binding the data in grid, I don’t know what’s going on . Data view (Graph)   [PXFilterable]   public SelectFrom<FSEquipment>.          InnerJoin<FSSODet>.On<FSSODet.SMequipmentID.IsEqual<FSEquipment.SMequipmentID>>.          InnerJoin<FSServiceOrder>.On<FSServiceOrder.refNbr.IsEqual<FSSODet.refNbr>>.          Where<FSSODet.refNbr.IsEqual<PYServiceEquipHistory.refNbr.FromCurrent>.          And<FSSODet.SMequipmentID.IsEqual<PYServiceEquipHistory.equipmentID.FromCurrent>>>.          OrderBy<FSServiceOrder.orderDate.Desc>.View ServiceEquipmentView;  Where condition not working here..! Data available in the database When we sele

How can we generate an invoice for recognition transection after runing  Recognition it only generates a batch number. If we want an invoice, what do we do?