Distribution

I added the State field (part of Address DAC) to the Customer lookup GI. It shows fine in the GI view, but not in the Customer lookup inside the Sales Order lookup screen. Does anyone know how to make the State field show up inside the Customer lookup in the Sale Order screen?

I added some columns to the Cusomer lookup GI that you can load within the sales order screen. I would like to make the default width of this popover screen wider to accommodate the additional columns. Does this require a customization project to change the width of the popover window, or can it be done with configuration sans customization? (screenshot redacted with white box) 

Is it possible to have different letterhead populate on forms (Sales Order Confirmation, Shipment Confirmation) based on order type? We are acquiring a new brand and would like to avoid having a separate branch but would still like to have the ability to have the branding different based on the order. Is this possible? 

I’m trying to add Sales Categories to my Inventory items with an import scenario using the Stock Item screen to add items to my already created categories but have had no success. Has anyone succesfully been able to add stock items to sales categories with an import scenario?

When created a navigation in a GI it wants it to be an external url.Is there a way to create a local path it will accept to a pdf with a specific file name?\\server\data\files\((Shipment.Nbr)).pdfThe pdf files would be saved with the shipment number as the file name.

We promote stock items to our customers on a weekly and monthly basis.  Or we encourage our sales team to focus on certain stock items for a short period of time.  How can we track these promoted items to see if we are increasing sales of the promoted items?  Does Acumatica have a build in report to track and compare sales of an item to see increases on a short-term basis? 

when tried to prepare invoice it was showing the following error:  Inserting 'AR Invoice/Memo' record raised at least one error. Please review the errors. Error: The 03-2022 financial period is inactive in the MUFFINS company.

I would like to dynamically change the color (“Connotation”) of the Confirm Shipment action button (Shipment Entry screen) depending on a condition in 21R2.Example use case: If the Package Weight is not within an allowable range of the Shipped Weight, then change the Confirm Shipment action button connotation to "Warning". Otherwise, use “Success”. This color change would provide another visual indicator to my fulfillment staff that a shipment is okay to confirm.I’m currently using the `SOShipment_PackageWeight_FieldUpdated()` event to raise a SetPropertyException, but the warning icon is so small that it’s easily missed. I want to provide more visible feedback to the end-user to help prevent costly packaging errors.In the 21R2 workflow editor, the color appears to be controlled by the “Connotation” selection.It does not appear to be possible to conditionally change the connotation of the Action button using the 21R2 workflow editor. How can it be done using code? Maybe using PXScreenC

Does anyone know how the Landed Costs with Type - VAT Taxes work?I want to know how to configure and how it works. Thanks Jesus 

Hello There,I wanted to see alternate ID on PO Receipt line, how can I do this?Thank youJennifer

Does anyone have thoughts on how I might supply inventory balances to the system externally without having to manage inflows (Purchase Receipts) and outflows (selling stock from the warehouse)?As we test transitioning from our old system, we’d like to use the balances from the old system but allow the new system to enforce order limits, etc.I’m guessing this is not a thing, but I’m curious if anyone has any clever tricks to make this work...

I would like to ask is it possible and how to set outside process (outsourcing) without manufacturing mode. Till now I found solutions only for manufacturers by creating Production Orders but what if there is no production onside and we ship a purchased item to the Vendor for an outside process (coating etc) and then afterwards we receive it back from Vendor ready to sell. How to organize that case in the system in order to calculate costs correctly and track the item?

Hello everyone, I am playing around with the mobile app with warehouse management. I am trying to use the scan and transfer function to transfer between warehouses but the scan and transfer function seems to only allow transfer between locations in a single warehouse. Is there a way to bypass this? Is there any work-around? Thank you

2 of our customers have asked us to hide the Update IN and prepare invoice screen on the shipment screen.I tired to do this with permissions but am not well versed in it. After some research, it looks like I will need to do it through a custom work flow.Is this the right way to do this? Can I tie different workflows to specific roles? If not, do I just create a new screen based on it, add it to the site map and tie that to the role?All advice appreciated and thanks in advance.

Engage with other Distributors in the Acumatica Community with the new Distribution Show & Tell where Acumatica customers, partners, and Product Management staff share different ways they use Acumatica, sneak peaks into upcoming features, discussions around vertical markets, and trends in the industry. Each meetup will have a topic with individuals prepared to share, time allotted for participation from others who have joined, Q&A with each person who has shared, and polls on various topics to get your feedback. Show & Tell will be informal and interactive, so come ready to share your camera and engage: participate in the discussions or just listen in. The first Distribution Show & Tell topic is SIDE PANELS, one of my favorite features of the Acumatica platform. See how Acumatica Community members have used side panels to track shipments, view PDFs, see if the Finished Good on the SO can be fulfilled on the requested date (exploding a BOM into multiple levels), and much

Hi, I’m trying to add the Add Stocked Item popup to the mobile sales order (SO301000). I had success add the list of items (InventoryLookup), however I want to add the filters and its not working.I’m trying to follow the documentation https://help-2020r1.acumatica.com/(W(4))/Help?ScreenId=ShowWiki&pageid=7244493f-a03a-4efa-9cef-18f2d4f08682 RedirectToContainer="InventoryLookup$List$InventoryLookupInventory" update screen SO301000 { update container "OrderSummary" { add recordAction "AddInvBySite" { behavior = Void redirect = True redirectToContainer = "InventoryLookup$List$InventoryLookupInventory" } } add container "InventoryLookup" { visible = False fieldsToShow = 6 listActionsToExpand = 2 formActionsToExpand = 3 containerActionsToExpand = 2 type =SelectionActionList add field "InventoryIDInventoryCD" add field "QtySelected" add field "Description"

I would like to know if there is a way to create draft purchase receipts to track incoming stock. I have attempted to use the Purchase Receipt form but the problem with this is that the moment stock is on a receipt, even if that receipt is on hold, it shows as “Available” in the stock inventory summary and in some stock views.If it were possible to do this it would be an ideal place to store the transit documentation such as the Bill Of Lading and Customs documents and it would be even better if we could somehow use it to give insight/visibility internally on when stock is due to arrive on a line by line basis via a custom GI. Thoughts, comments and suggestions will be much appreciated.  @Naveen B  @Chris Hackett 

Hello, One of our customers has the following problem: he wants to use the creation of matrix items with only 2 attributes: sizes and colors, for which he has respectively 400 possible size values and 4500 possible color values. When he uses the grid in the template screen for matrix items, it simply can’t be loaded and he can’t use this functionality. He doesn’t want to break down the number of possible values in his use case. I have tried this myself with 200 values for 2 attributes, and indeed the time to check a box in the matrix item creation grid, takes at least 5 seconds before I can check another one. Have you ever encountered this kind of situation? Would you have an idea how to handle this request? Customization project or other?Thanks in advance for your feedback! Have a nice day!

I have a custom sales invoice listing report with a column for invoice type. I would want to know I can I add a negative sign to my invoice type “credit memo” so as to differentiate them from invoices?

Good dayI have a custom Material usage report I built based on a copy of the standard Historical Inventory Balance report. I am using the “Assembly Out” column which is my consumption as I only work with Assemblies. On the same report I would want to add a column depicts the current or historical material cost of an inventory item. I have tried to add the Last Cost field from the InventoryItem table but this does not bring any results.What method can I use to have the cost price field reflecting the item cost on the report?  

when Sales order not using approval setting, how to solve a back order status in sales order turn into waiting approval if the user change any of the column in detail line ? because approval action is not working..thx

Hello, Is is possible to change the default qty from 0 to 1 while entering line items during quote or sales order entry.  This will speed up the process due to most line entry is only quantity of 1.Thanks

We use the drag and drop file attachemnts to add the customer PO to the SO.In some instances it shows a file in the SO but the file box is empty.What could cause this?ThanksJohn 

Hi, We need to update the Item Cost base on the FIFO cost method. Ex. Item A - 20 Qty with 10$ After add the Laded Cost Value for particular Item Cost, it would be 12$. Have there any possibility to update the Item cost manually? Since user already has completed the landed cost process without adding additional 2$.Now we need to update that additional 2$ to Item. RegardsNethupul  

We have hundreds of items that require Expiration Dates annually. When an Item gets close to its Expiration Date we must have the product Re-Tested. Is there a way to track Expiration Dates without enforcing Lot/Serial Tracking on items?